Microsoft Visual C# Data Sets: Data Relationships

	Data Set Example Application: Bethesda Car Rental

Introduction

This is an example of creating a file-based database using the techniques of the DataSet class of the .NET Framework.

Practical Learning: Introducing Data Relationships

Start Microsoft Visual Studio
Create a new Windows Application named BethesdaCarRental2
To add a new form to the project, in the Solution Explorer, right-click BethesdaCarRental2 -> Add -> Windows Form...
Set the Name to OrderProcessing and press Enter

Design the form as follows:

Control	Text	Name	Other Properties
Label	Processed By:		AutoSize: False BackColor: Gray BorderStyle: FixedSingle ForeColor: White TextAlign: MiddleLeft
Label	Employee #:
MaskedTextBox		cbxEmployeeID
Label	Employee Name:
TextBox		txtEmployeeName
Label	Processed For		AutoSize: False BackColor: Gray BorderStyle: FixedSingle ForeColor: White TextAlign: MiddleLeft
Label	Driver's Lic #:
TextBox		cbxCustomerID
Label	Cust Name:
TextBox		txtCustomerName
Label	Address:
TextBox		txtCustomerAddress
Label	City:
TextBox		txtCustomerCity
Label	State:
ComboBox		cbxCustomerStates	DropDownStyle: DropDownList Sorted: True Items: AL, AK, AZ, AR, CA, CO, CT, DE, DC, FL, GA, HI, ID, IL, IN, IA, KS, KY, LA, ME, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VT, VA, WA, WV, WI, WY
Label	ZIP Code
TextBox		txtCustomerZIPCode
Label	Car Selected		AutoSize: False BackColor: Gray BorderStyle: FixedSingle ForeColor: White TextAlign: MiddleLeft
Label	Tag Number:
TextBox		cbxCarID
Label	Car Condition:
ComboBox		cbxCarConditions	Sorted: True Items: Needs Repair Drivable Excellent
Label	Make:
TextBox		txtMake
Label	Model:
TextBox		txtModel
Label	Year:
TextBox		txtCarYear
label	Tank Level:
ComboBox		cbxTankLevels	Empty 1/4 Empty 1/2 Full 3/4 Full Full
Label	Mileage Start:
TextBox		txtMileageStart	TextAlign: Right
Label	Mileage End:
TextBox		txtMileageEnd	TextAlign: Right
Label	Order Timing		AutoSize: False BackColor: Gray BorderStyle: FixedSingle ForeColor: White TextAlign: MiddleLeft
Label	Start Date:
DateTimePicker		dtpStartDate
Label	End Date:
DateTimePicker		dtpEndDate
Label	Days:
TextBox	0	txtDays	TextAlign: Right
Label	Order Status
ComboBox		cbxOrderStatus	Items: Car On Road Car Returned Order Reserved
Label	Order Evaluation		AutoSize: False BackColor: Gray BorderStyle: FixedSingle ForeColor: White TextAlign: MiddleLeft
Label	Rate Applied:
TextBox	0.00	txtRateApplied	TextAlign: Right
Button	Rental Rates	btnRentalRates
Label	Sub-Total:
TextBox	0.00	txtSubTotal	TextAlign: Right
Button	Calculate	btnCalculate
Label	Tax Rate:
TextBox	7.75	txtTaxRate	TextAlign: Right
Label	%
Button	Save	btnSave
Label	Tax Amount:
TextBox	0.00	txtTaxAmount	TextAlign: Right
Button	Print...	btnPrint
Label	Order Total:
TextBox	0.00	txtOrderTotal	TextAlign: Right
Button	Print Preview...	btnPrintPreview
Label	Receipt #:
TextBox	0	txtReceiptNumber
Button	Open	btnOpen
Button	New Rental Order/Reset	btnNewRentalOrder
Button	Close	btnClose

On to the Order Processing form, double-click the Start Date date time picker control

Implement the event as follows:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;

namespace BethesdaCarRental2
{
    public partial class OrderProcessing : Form
    {
        public OrderProcessing()
        {
            InitializeComponent();
        }

        private void dtpStartDate_ValueChanged(object sender, EventArgs e)
        {
            dtpEndDate.Value = dtpStartDate.Value;
        }
    }
}

Return to the Order Processing form and double-click the End Date control

Implement its event as follows:

// This event approximately evaluates the number of days as a
// difference between the end date and the starting date
private void dtpEndDate_ValueChanged(object sender, EventArgs e)
{
    int days;

    DateTime dteStart = this.dtpStartDate.Value;
    DateTime dteEnd = this.dtpEndDate.Value;

    // Let's calculate the difference in days
    TimeSpan tme = dteEnd - dteStart;
    days = tme.Days;

    // If the customer returns the car the same day, 
    // we consider that the car was rented for 1 day
    if (days == 0)
        days = 1;

    txtDays.Text = days.ToString();
    // At any case, we will let the clerk specify the actual number of days
}

Return to the Order Processing form and double-click the Rental Rates button

Implement its event as follows:

private void btnRentalRates_Click(object sender, EventArgs e)
{
    RentalRates wndRates = new RentalRates();
    wndRates.Show();
}

Return to the Order Processing form and double-click the Calculate button

Implement its event as follows:

private void btnCalculate_Click(object sender, EventArgs e)
{
    int    Days = 0;
    double RateApplied = 0.00;
    double SubTotal = 0.00;
    double TaxRate = 0.00;
    double TaxAmount = 0.00;
    double OrderTotal = 0.00;

    try
    {
        Days = int.Parse(this.txtDays.Text);
    }
    catch (FormatException)
    {
        MessageBox.Show("Invalid Number of Days");
    }

    try
    {
        RateApplied = double.Parse(txtRateApplied.Text);
    }
    catch (FormatException)
    {
        MessageBox.Show("Invalid Amount for Rate Applied");
    }

    SubTotal = Days * RateApplied;
    txtSubTotal.Text = SubTotal.ToString("F");

    try
    {
        TaxRate = double.Parse(txtTaxRate.Text);
    }
    catch (FormatException)
    {
        MessageBox.Show("Invalid Tax Rate");
    }

    TaxAmount = SubTotal * TaxRate / 100;
    txtTaxAmount.Text = TaxAmount.ToString("F");

    OrderTotal = SubTotal + TaxAmount;
    txtOrderTotal.Text = OrderTotal.ToString("F");
}

Return to the Order Processing form
From the Printing section of the Toolbox, click PrintDocument and click the form
In the Properties window, set its (Name) to docPrint and press Enter

Under the form, double-click docPrint and implement its event as follows:

private void docPrint_PrintPage(object sender,
	System.Drawing.Printing.PrintPageEventArgs e)
{
    e.Graphics.DrawLine(new Pen(Color.Black, 2), 80, 90, 750, 90);
    e.Graphics.DrawLine(new Pen(Color.Black, 1), 80, 93, 750, 93);

    string strDisplay = "Bethesda Car Rental";
    System.Drawing.Font fntString = new Font("Times New Roman", 28,
                        FontStyle.Bold);
    e.Graphics.DrawString(strDisplay, fntString,
                        Brushes.Black, 240, 100);

    strDisplay = "Car Rental Order";
    fntString = new System.Drawing.Font("Times New Roman", 22,
                        FontStyle.Regular);
    e.Graphics.DrawString(strDisplay, fntString,
                        Brushes.Black, 320, 150);

    e.Graphics.DrawLine(new Pen(Color.Black, 1), 80, 187, 750, 187);
    e.Graphics.DrawLine(new Pen(Color.Black, 2), 80, 190, 750, 190);

    fntString = new System.Drawing.Font("Times New Roman", 12,
                FontStyle.Bold);
    e.Graphics.DrawString("Receipt #:  ", fntString,
                Brushes.Black, 100, 220);
    fntString = new System.Drawing.Font("Times New Roman", 12,
                FontStyle.Regular);
    e.Graphics.DrawString(txtReceiptNumber.Text, fntString,
                                  Brushes.Black, 260, 220);
    e.Graphics.DrawLine(new Pen(Color.Black, 1), 100, 240, 380, 240);

    fntString = new System.Drawing.Font("Times New Roman", 12,
                FontStyle.Bold);
    e.Graphics.DrawString("Processed By:  ", fntString,
                Brushes.Black, 420, 220);
    fntString = new System.Drawing.Font("Times New Roman", 12,
                FontStyle.Regular);
    e.Graphics.DrawString(txtEmployeeName.Text, fntString,
                                  Brushes.Black, 550, 220);
    e.Graphics.DrawLine(new Pen(Color.Black, 1), 420, 240, 720, 240);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);

    e.Graphics.FillRectangle(Brushes.Gray,
			 new Rectangle(100, 260, 620, 20));
    e.Graphics.DrawRectangle(Pens.Black,
			 new Rectangle(100, 260, 620, 20));

    e.Graphics.DrawString("Customer", fntString,
                                  Brushes.White, 100, 260);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Driver's License #: ", fntString,
                                  Brushes.Black, 100, 300);
    e.Graphics.DrawString("Name: ", fntString,
                                 Brushes.Black, 420, 300);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(cbxCustomerID.Text, fntString,
                                  Brushes.Black, 260, 300);
    e.Graphics.DrawString(txtCustomerName.Text, fntString,
                                  Brushes.Black, 540, 300);
    e.Graphics.DrawLine(new Pen(Color.Black, 1), 100, 320, 720, 320);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Address: ", fntString,
                                  Brushes.Black, 100, 330);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(txtCustomerAddress.Text, fntString,
                                  Brushes.Black, 260, 330);
    e.Graphics.DrawLine(new Pen(Color.Black, 1), 100, 350, 720, 350);

    strDisplay = txtCustomerCity.Text + " " +
                         cbxCustomerStates.Text + " " +
                         txtCustomerZIPCode.Text;
    fntString = new System.Drawing.Font("Times New Roman",
 		12, FontStyle.Regular);
    e.Graphics.DrawString(strDisplay, fntString,
                                  Brushes.Black, 260, 360);
    e.Graphics.DrawLine(new Pen(Color.Black, 1), 260, 380, 720, 380);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);

    e.Graphics.FillRectangle(Brushes.Gray,
		new Rectangle(100, 410, 620, 20));
    e.Graphics.DrawRectangle(Pens.Black,
		new Rectangle(100, 410, 620, 20));

    e.Graphics.DrawString("Car Information", fntString,
                                  Brushes.White, 100, 410);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Tag #: ", fntString,
                                  Brushes.Black, 100, 450);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(cbxCarID.Text, fntString,
                                  Brushes.Black, 260, 450);
    e.Graphics.DrawLine(new Pen(Color.Black, 1), 100, 470, 380, 470);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Year: ", fntString,
                                  Brushes.Black, 420, 450);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(txtCarYear.Text, fntString,
                                  Brushes.Black, 530, 450);
    e.Graphics.DrawLine(new Pen(Color.Black, 1), 420, 470, 720, 470);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Make: ", fntString,
                                  Brushes.Black, 100, 480);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(txtMake.Text, fntString,
                                  Brushes.Black, 260, 480);
    e.Graphics.DrawLine(new Pen(Color.Black, 1), 100, 500, 380, 500);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Model: ", fntString,
                                  Brushes.Black, 420, 480);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(txtModel.Text, fntString,
                                  Brushes.Black, 530, 480);
    e.Graphics.DrawLine(new Pen(Color.Black, 1), 420, 500, 720, 500);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Car Condition: ", fntString,
                                  Brushes.Black, 100, 510);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(cbxCarConditions.Text, fntString,
                                  Brushes.Black, 260, 510);
    e.Graphics.DrawLine(new Pen(Color.Black, 1), 100, 530, 380, 530);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Tank Level: ", fntString,
                                  Brushes.Black, 420, 510);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(cbxTankLevels.Text, fntString,
                                  Brushes.Black, 530, 510);
    e.Graphics.DrawLine(new Pen(Color.Black, 1), 420, 530, 720, 530);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Mileage Start:", fntString,
                                  Brushes.Black, 100, 540);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(txtMileageStart.Text, fntString,
                                  Brushes.Black, 260, 540);
    e.Graphics.DrawLine(new Pen(Color.Black, 1), 
				100, 560, 380, 560);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("MileageEnd:", fntString,
                          Brushes.Black, 420, 540);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(txtMileageEnd.Text, fntString,
                          Brushes.Black, 530, 540);
    e.Graphics.DrawLine(new Pen(Color.Black, 1),
			420, 560, 720, 560);

    e.Graphics.FillRectangle(Brushes.Gray,
			 new Rectangle(100, 590, 620, 20));
    e.Graphics.DrawRectangle(Pens.Black,
			 new Rectangle(100, 590, 620, 20));

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Order Timing Information", fntString,
                          Brushes.White, 100, 590);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Start Date:", fntString,
                           Brushes.Black, 100, 620);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(dtpStartDate.Value.ToString("D"),
			  fntString, Brushes.Black, 260, 620);
    e.Graphics.DrawLine(new Pen(Color.Black, 1),
			100, 640, 720, 640);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("End Date:", fntString,
                          Brushes.Black, 100, 650);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(dtpEndDate.Value.ToString("D"), fntString,
                          Brushes.Black, 260, 650);
    e.Graphics.DrawLine(new Pen(Color.Black, 1),
			100, 670, 520, 670);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Days:", fntString,
                          Brushes.Black, 550, 650);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(txtDays.Text, fntString,
                                  Brushes.Black, 640, 650);
    e.Graphics.DrawLine(new Pen(Color.Black, 1),
			550, 670, 720, 670);

    e.Graphics.FillRectangle(Brushes.Gray,
			new Rectangle(100, 700, 620, 20));
    e.Graphics.DrawRectangle(Pens.Black,
			 new Rectangle(100, 700, 620, 20));

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Order Evaluation", fntString,
                          Brushes.White, 100, 700);

    StringFormat fmtString = new StringFormat();
    fmtString.Alignment = StringAlignment.Far;

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Rate Applied:", fntString,
                          Brushes.Black, 100, 740);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(txtRateApplied.Text, fntString,
                          Brushes.Black, 300, 740, fmtString);
    e.Graphics.DrawLine(new Pen(Color.Black, 1),
			100, 760, 380, 760);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Tax Rate:", fntString,
                          Brushes.Black, 420, 740);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(txtTaxRate.Text, fntString,
                          Brushes.Black, 640, 740, fmtString);
    e.Graphics.DrawString("%", fntString,
                          Brushes.Black, 640, 740);
    e.Graphics.DrawLine(new Pen(Color.Black, 1),
			420, 760, 720, 760);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Sub-Total:", fntString,
                          Brushes.Black, 100, 770);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(txtSubTotal.Text, fntString,
                          Brushes.Black, 300, 770, fmtString);
    e.Graphics.DrawLine(new Pen(Color.Black, 1),
			100, 790, 380, 790);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Tax Amount:", fntString,
                                  Brushes.Black, 420, 770);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(txtTaxAmount.Text, fntString,
                          Brushes.Black, 640, 770, fmtString);
    e.Graphics.DrawLine(new Pen(Color.Black, 1),
			420, 790, 720, 790);

    fntString = new Font("Times New Roman", 12, FontStyle.Bold);
    e.Graphics.DrawString("Order Total:", fntString,
                                  Brushes.Black, 420, 800);
    fntString = new Font("Times New Roman", 12, FontStyle.Regular);
    e.Graphics.DrawString(txtOrderTotal.Text, fntString,
                          Brushes.Black, 640, 800, fmtString);
    e.Graphics.DrawLine(new Pen(Color.Black, 1),
			420, 820, 720, 820);
}

Return to the Order Processing form
From the Printing section of the Toolbox, click PrintDialog and click the form
In the Properties window, change its Name to dlgPrint
Still in the Properties windows, set its Document property to docPrint

On the Order Processing form, double-click the Print button and implement its event as follows:

private void btnPrint_Click(object sender, EventArgs e)
{
    if (dlgPrint.ShowDialog() == DialogResult.OK)
        docPrint.Print();
}

Return to the Order Processing form
From the Printing section of the Toolbox, click PrintPreviewDialog and click the form
In the Properties window, change its (Name) to dlgPrintPreview
Still in the Properties windows, set its Document property to docPrint
On the Order Processing form, double-click the Print Preview button

Implement the event as follows:

private void btnPrintPreview_Click(object sender, EventArgs e)
{
    dlgPrintPreview.ShowDialog();
}

Return to the Order Processing form and double-click the New Rental Order/Reset button

Implement the event as follows:

private void btnNewRentalOrder_Click(object sender, EventArgs e)
{
    cbxEmployeeID.SelectedIndex = -1;
    txtEmployeeName.Text = "";
    cbxCustomerID.SelectedIndex = -1;
    txtCustomerName.Text = "";
    txtCustomerAddress.Text = "";
    txtCustomerCity.Text = "";
    cbxCustomerStates.Text = "DC";
    txtCustomerZIPCode.Text = "";
    cbxCarID.SelectedIndex = -1;
    cbxCarConditions.SelectedIndex = 2;
    txtMake.Text = "";
    txtModel.Text = "";
    txtCarYear.Text = "";
    cbxTankLevels.SelectedIndex = 0;
    txtMileageStart.Text = "0";
    txtMileageEnd.Text = "0";
    dtpDateProcessed.Value = DateTime.Today;
    dtpStartDate.Value = DateTime.Today;
    dtpEndDate.Value = DateTime.Today;
    txtDays.Text = "1";
    txtRateApplied.Text = "0.00";
    txtSubTotal.Text = "0.00";
    txtTaxAmount.Text = "0.00";
    txtOrderTotal.Text = "0.00";
    cbxOrderStatus.SelectedIndex = 0;
}

In the Solution Explorer, right-click Form1.cs and click Rename
Type Central.cs and press Enter

Design the form as follows:

Control	Text	Name
Button	Order Processing...	btnOrderProcessing
Button	Customers...	btnCustomers
Button	Car Editor...	btnCarEditor
Button	Employees	btnEmployees
Button	Close	btnClose

Double-click an unoccupied area of the form and implement the event as follows:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;

namespace BethesdaCarRental2
{
    public partial class Central : Form
    {
        public Central()
        {
            InitializeComponent();
        }

        private void Central_Load(object sender, EventArgs e)
        {
            // If this directory doesn't exist, create it
            Directory.CreateDirectory(@"C:\Bethesda Car Rental1");
        }
    }
}

Return to the Central form and double-click the Order Processing button

Implement its event as follows:

private void btnOrderProcessing_Click(object sender, EventArgs e)
{
    OrderProcessing order = new OrderProcessing();
    order.ShowDialog();
}

To add a new form to the project, in the Solution Explorer, right-click BethesdaCarRental2 -> Add -> Windows Form...
Set the Name to RentalRates and press Enter

Add a ListView to the form and create its Columns as follows:

(Name)	Text	TextAlign	Width
colCategory	Category		90
colDaily	Daily	Right
colWeekly	Weekly	Right
colMonthly	Monthly	Right
colWeekend	Weekend	Right

Create its Items as follows:

ListViewItem	SubItems	SubItems	SubItems	SubItems
	Text	Text	Text	Text
Economy	35.95	32.75	28.95	24.95
Compact	39.95	35.75	32.95	28.95
Standard	45.95	39.75	35.95	32.95
Full Size	49.95	42.75	38.95	35.95
Mini Van	55.95	50.75	45.95	42.95
SUV	55.95	50.75	45.95	42.95
Truck	42.75	38.75	35.95	32.95
Van	69.95	62.75	55.95	52.95

Complete the design of the form as follows:
To add a new form to the application, in the Solution Explorer, right-click BethesdaCarRental2 -> Add -> Windows Form...
Set the Name to Employees and click Add
From the Data section of the Toolbox, click DataSet and click the form
Click Untyped Dataset and click OK
In the Properties window, change the following characteristics:
DataSetName: Employees
(Name): dsEmployees
Click Tables and click its button
Click Add and change the following characteristics:
TableName: Employee
(Name) tblEmployee
Click Columns and click its button
In the Columns Collection Editor, click Add change the characteristics as follows:
ColumnName: EmployeeID
(Name): colEmployeeID
While the EmployeeID member is selected, in the Properties list, double-click AutoIncrement to set its value to True
Click AutoIncrementSeed and type 1

Click Add continuously and create the following columns:

AllowDBNull	ColumnName	(Name)	Expression
False	EmployeeNumber	colEmployeeNumber
	FirstName	colFirstName
False	LastName	colLastName
	FullName	colFullName	LastName + ', ' + FirstName
	Title	colTitle

Click Close and click Close

Design the form as follows:

Control	Text	Name	Other Properties
DataGridView		dgvEmployees	DataSource: dsEmployees DataMember: Employee
Button	Close	btnClose

Data Grid Columns

DataPropertyName	HeaderText	Width
EmployeeID	Empl ID	50
EmployeeNumber	Empl #	65
FirstName	First Name	70
LastName	Last Name	70
FullName	Full Name	120
Title		110

Double-click an unoccupied area of the form and implement the event as follows:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;

namespace BethesdaCarRental2
{
    public partial class Employees : Form
    {
        public Employees()
        {
            InitializeComponent();
        }

        private void Employees_Load(object sender, EventArgs e)
        {
            string strFilename = @"C:\Bethesda Car Rental1\employees.xml";

            if (File.Exists(strFilename))
                dsEmployees.ReadXml(strFilename);
        }
    }
}

Return to the form and click an unoccupied area of its body
In the Properties window, click Events and double-click FormClosing

Implement its event as follows:

private void Employees_FormClosing(object sender, FormClosingEventArgs e)
{
    dsEmployees.WriteXml(@"C:\Bethesda Car Rental1\employees.xml");
}

Return to the form and double-click the Close button

Implement its event as follows:

private void btnClose_Click(object sender, EventArgs e)
{
    Close();
}

Display the Central form and double-click the Employees button

Implement it as follows:

private void btnEmployees_Click(object sender, EventArgs e)
{
    Employees frmEmployees = new Employees();
    frmEmployees.ShowDialog();
}

Execute the application
On the Central form, click the Employees button

Create a few employees as follows:

Employee #	First Name	Last Name	Title
62-845	Patricia	Katts	General Manager
92-303	Henry	Larson	Sales Representative
25-947	Gertrude	Monay	Sales Representative
73-947	Helene	Sandt	Intern
40-508	Melanie	Karron	Sales Representative
22-580	Ernest	Chisen	Sales Manager
20-308	Melissa	Roberts	Administrative Assistant

Close the forms and return to your programming environment
To add a new form to the application, in the Solution Explorer, right-click BethesdaCarRental2 -> Add -> Windows Form...
Set the Name to Customers and click Add
From the Data section of the Toolbox, click DataSet and click the form
Click Untyped Dataset and click OK
In the Properties window, change the following characteristics:
DataSetName: Customers
(Name): dsCustomers
Click Tables and click its button
Click Add and change the following characteristics:
TableName: Customer
(Name) tblCustomer
Click Columns and click its button

In the Columns Collection Editor, click Add continuously and create the following columns:

ColumnName	(Name)	Additional Properties
CustomerID	colCustomerID	AutoIncrement: True AutoIncrementSeed: 1
DrvLicNumber	colDrvLicNumber	AllowDBNull: False Unique: True
FullName	colFullName	AllowDBNull: False
Address	colAddress
City	colCity
State	colState
ZIPCode	colZIPCode

Click Close and click Close

Design the form as follows:

Control	Text	Name	Other Properties
DataGridView		dgvCustomers	DataSource: dsCustomers DataMember: Customer
Button	Close	btnClose

Data Grid Columns

DataPropertyName	HeaderText	Width
CustomerID	Cust ID	50
DrvLicNumber	Drv Lic #	80
FullName	Full Name
Address
City		80
State		45
ZIPCode	ZIP Code	60

Double-click an unoccupied area of the form and implement the event as follows:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;

namespace BethesdaCarRental2
{
    public partial class Customers : Form
    {
        public Customers()
        {
            InitializeComponent();
        }

        private void Customers_Load(object sender, EventArgs e)
        {
            string strFilename = @"C:\Bethesda Car Rental1\customers.xml";

            if (File.Exists(strFilename))
                dsCustomers.ReadXml(strFilename);
        }
    }
}

Return to the form and click an unoccupied area of its body
In the Properties window, click Events and double-click FormClosing

Implement its event as follows:

private void Customers_FormClosing(object sender, FormClosingEventArgs e)
{
     dsCustomers.WriteXml(@"C:\Bethesda Car Rental1\customers.xml");
}

Return to the form and double-click the Close button

Implement its event as follows:

private void btnClose_Click(object sender, EventArgs e)
{
    Close();
}

Display the Central form and double-click the Customers button

Implement it as follows:

private void btnCustomers_Click(object sender, EventArgs e)
{
    Customers frmCustomers = new Customers();
    frmCustomers.ShowDialog();
}

Execute the application

Click the Customers button and create a few customers as follows:

Driver's Lic. #	State	Full Name	Address	City	ZIP Code
M-505-862-575	MD	Lynda Melman	4277 Jamison Avenue	Silver Spring	20904
379-82-7397	DC	John Villard	108 Hacken Rd NE	Washington	20012
J-938-928-274	MD	Chris Young	8522 Aulage Street	Rockville	20852
497-22-0614	PA	Pamela Ulmreck	12075 Famina Rd	Blain	17006
922-71-8395	VA	Helene Kapsco	806 Hyena Drive	Alexandria	22231
C-374-830-422	MD	Hermine Crasson	6255 Old Georgia Ave	Silver Spring	20910
836-55-2279	NY	Alan Pastore	4228 Talion Street	Amherst	14228
397-59-7487	TN	Phillis Buster	724 Cranston Circle	Knoxville	37919
115-80-2957	FL	Elmus Krazucki	808 Rasters Ave	Orlando	32810
294-90-7744	VA	Helena Weniack	10448 Great Pollard Hwy	Arlington	22232

Close the Customers form
To add a new form to the application, in the Solution Explorer, right-click BethesdaCarRental2 -> Add -> Windows Form...
Set the Name to CarEditor and click Add

Design the form as follows:

Control	Text	Name	Other Properties
Label	Text #
TextBox		txtTagNumber
Label	Make:
TextBox		txtMake
Label	Model:
TextBox		txtModel
Label	Year:
TextBox		txtYear
Label	Category:
ComboBox		cboCategories	DropDownStyle: DropDownList
ComboBox		cboCategories	Items:	Economy Compact Standard Full Size Mini Van SUV Truck Van
PictureBox		pbxCar	SizeMode: Zoom
CheckBox	CD Player	chkCDPlayer	CheckAlign: MiddleRight
CheckBox	DVD Player	chkDVDPlayer	CheckAlign: MiddleRight
Button	Select Car Picture...	btnSelectPicture
CheckBox	Available	chkAvailable	CheckAlign: MiddleRight
Label	Picture Name	lblPictureName
Button	Submit	btnSubmit
Button	Close	btnClose	DialogResult: Cancel
OpenFileDialog	(Name): dlgOpen Title: Select Item Picture DefaultExt: jpg Filter: JPEG Files (.jpg,.jpeg)\|.jpg\|GIF Files (.gif)\|.gif\|Bitmap Files (.bmp)\|.bmp\|PNG Files (.png)\|*.png
Form			FormBorderStyle: FixedDialog MaximizeBox: False MinimizeBox: False ShowInTaskbar: False

Double-click the Select Car Picture button and implement its event as follows:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;

namespace BethesdaCarRental2
{
    public partial class CarEditor : Form
    {
        public CarEditor()
        {
            InitializeComponent();
        }

        private void btnSelectPicture_Click(object sender, EventArgs e)
        {
            if (dlgPicture.ShowDialog() == DialogResult.OK)
            {
                lblPictureName.Text = dlgPicture.FileName;
                pbxCar.Image = Image.FromFile(lblPictureName.Text);
            }
        }
    }
}

Return to the Car Editor form
From the Data section of the Toolbox, click DataSet and click the form
Click Untyped Dataset and click OK
In the Properties window, change the following characteristics:
DataSetName: Cars
(Name): dsCars
Click Tables and click its button
Click Add and change the following characteristics:
TableName: Car
(Name) tblCar
Click Columns and click its button

In the Columns Collection Editor, click Add continuously and create the following columns:

ColumnName	(Name)	Additional Properties
CarID	colCarID	AutoIncrement: True AutoIncrementSeed: 1
TagNumber	colTagNumber	AllowDBNull: False Unique: True
Make	colMake
Model	colModel
Year	colYear	DataType: System.UInt16
Category	colCategory
CDPlayer	colCDPlayer	DataType: System.Boolean
DVDPlayer	colDVDPlayer	DataType: System.Boolean
Available	colAvailable	DataType: System.Boolean

Click Close and click Close

Double-click the Submit button and implement the event as follows:

private void btnSubmit_Click(object sender, EventArgs e)
{
    if (txtTagNumber.Text.Length == 0)
    {
        MessageBox.Show("You must enter the car's tag number");
        return;
    }

    if (txtMake.Text.Length == 0)
    {
        MessageBox.Show("You must specify the car's manufacturer");
        return;
    }

    if (txtModel.Text.Length == 0)
    {
        MessageBox.Show("You must enter the model of the car");
        return;
    }

    if (txtYear.Text.Length == 0)
    {
        MessageBox.Show("You must enter the year of the car");
        return;
    } 
            
    DataRow rowCar = tblCar.NewRow();

    rowCar["TagNumber"] = txtTagNumber.Text;
    rowCar["Make"] = txtMake.Text;
    rowCar["Model"] = txtModel.Text;
    rowCar["CarYear"] = txtYear.Text;
    rowCar["Category"] = cbxCategories.Text;
    rowCar["CDPlayer"] = chkCDPlayer.Checked;
    rowCar["DVDPlayer"] = chkDVDPlayer.Checked;
    rowCar["Available"] = chkAvailable.Checked;
    tblCar.Rows.Add(rowCar);

    dsCars.WriteXml(@"C:\Bethesda Car Rental1\cars.xml");

    if (lblPictureName.Text.Length != 0)
    {
        FileInfo flePicture = new FileInfo(lblPictureName.Text);
        flePicture.CopyTo(@"C:\Bethesda Car Rental1\" +
                          txtTagNumber.Text + flePicture.Extension);
    }

    txtTagNumber.Text = "";
    txtMake.Text = "";
    txtModel.Text = "";
    txtYear.Text = "";
    cbxCategories.Text = "Economy";
    chkCDPlayer.Checked = false;
    chkDVDPlayer.Checked = false;
    chkAvailable.Checked = false;
    lblPictureName.Text = ".";
    pbxCar.Image = null;
}

Return to the form and double-click the Close button

Implement its event as follows:

private void btnClose_Click(object sender, EventArgs e)
{
    Close();
}

Display the Central form and double-click the Car Editor button

Implement it as follows:

private void btnCarEditor_Click(object sender, EventArgs e)
{
    CarEditor editor = new CarEditor();
    editor.ShowDialog();
}

Copy the following pictures to any folder somewhere on your computer:


BMW: 335i	Chevrolet Avalanche

Honda Accord	Mazda Miata

Chevrolet Aveo	Ford E150XL

Buick Lacrosse	Honda Civic

Ford F-150	Mazda Mazda5

Volvo S40	Land Rover LR3

Execute the application
Click the Car Editor button and create the cars
Close the Car Editor form
Return to your programming environment
Display the Order Processing form
From the Data section of the Toolbox, click DataSet and click the form
Click Untyped Dataset and click OK
In the Properties window, change the following characteristics:
DataSetName: RentalOrders
(Name): dsRentalOrders
Click Tables and click its button
Click Add and change the following characteristics:
TableName: RentalOrder
(Name) tblRentalOrder
Click Columns and click its ellipsis button

In the Columns Collection Editor, click Add twice and create the following columns:

ColumnName	(Name)	Additional Properties
RentalOrderID	colRentalOrderID	AutoIncrement: True AutoIncrementSeed: 1000
DateProcessed	colDateProcessed	DataType: System.DateTime

Click Close

Practical Learning: Creating a Primary Key

While the RentalOrder table is still selected in the Members list, in the Properties list, click Constraints and click its button
In the Constraints Collection Editor, click Add -> Unique Constraint
Set the Name to PKRentalOrders
Click the check box of RentalOrderID and click the Primary Key check box
Click OK and click Close

Click Columns and create the following columns:

ColumnName	(Name)	Other Properties
RentalOrderID	colRentalOrderID
DateProcessed	colDateProcessed
EmployeeID	colEmplID	DataType: System.Int32
EmployeeName	colEmployeeName
CustomerID	colCustID	DataType: System.Int32
CustomerName	colCustomerName
CustomerAddress	colCustomerAddress
CustomerCity	colCustomerCity
CustomerState	colCustomerState
CustomerZIPCode	colCustomerZIPCode
CarID	colVehicleID	DataType: System.Int32
Make	colCarMake
Model	colCarModel
Year	colCarYear	DataType: System.UInt16
Condition	colCarCondition
TankLevel	colTankLevel
MileageStart	colMileageStart	DataType: System.UInt32
MileageEnd	colMileageEnd	DataType: System.UInt32
RentStartDate	colRentStartDate	DataType: System.DateTime
RendependDate	colRendependDate	DataType: System.DateTime
Days	colDays	DataType: System.UInt16
RateApplied	colRateApplied	DataType: System.Double
SubTotal	colSubTotal	DataType: System.Double
TaxRate	colTaxRate	DataType: System.Double
TaxAmount	colTaxAmount	DataType: System.Double
OrderTotal	colOrderTotal	DataType: System.Double
OrderStatus	colOrderStatus

Click Close
While the RentalOrder table is selected, in the RentalOder Properties list, click PrimaryKey and click the arrow of its combo box.
Notice the check box on RentalOrderID
In the Tables Collection Editor, click Add and change the following characteristics:
TableName: Car
(Name) tblCar
Click Columns and click its button

In the Columns Collection Editor, click Add continuously and create the following columns:

ColumnName	(Name)	Additional Properties
CarID	colCarID	AutoIncrement: True AutoIncrementSeed: 1
TagNumber	colTagNumber	AllowDBNull: False Unique: True
Make	colMake
Model	colModel
Year	colYear	DataType: System.UInt16
Category	colCategory
CDPlayer	colCDPlayer	DataType: System.Boolean
DVDPlayer	colDVDPlayer	DataType: System.Boolean
Available	colAvailable	DataType: System.Boolean

Click Close
While the Car table is selected, in the Properties list, click Constraints and its button
In the Constraints Collection Editor, if Constraint1 is selected, click Edit (otherwise, click Add -> Unique Constraint)
Set the Name to PKCars
Click the check box of CarID and click the Primary Key check box:
Click OK and click Close
In the Tables Collection Editor, click Add and change the following characteristics:
TableName: Customer
(Name) tblCustomer
Click Columns and click its button

In the Columns Collection Editor, click Add continuously and create the following columns:

ColumnName	(Name)	Additional Properties
CustomerID	colCustomerID	AutoIncrement: True AutoIncrementSeed: 1
DrvLicNumber	colDrvLicNumber	AllowDBNull: False Unique: True
FullName	colFullName	AllowDBNull: False
Address	colAddress
City	colCity
State	colState
ZIPCode	colZIPCode

Click Close
Click Constraints and click its button
In the Constraints Collection Editor, if Constraint1 is selected, click Edit (otherwise, click Add -> Unique Constraint)
Set the Name to PKCustomers
Click the check box of CustomerID and click the Primary Key check box (clear any other check box)
Click OK and click Close
In the Tables Collection Editor, click Add and change the following characteristics:
TableName: Employee
(Name) tblEmployee
Click Columns and click its button

In the Columns Collection Editor, click Add continuously and create the following columns:

ColumnName	(Name)	Additional Properties
EmployeeID	colEmployeeID	AutoIncrement: True AutoIncrementSeed: 1
EmployeeNumber	colEmployeeNumber	AllowDBNull: False Unique: True
FirstName	colFirstName	AllowDBNull: False
LastName	colLastName
FullName	colEmplFullName
Title	colTitle

Click Close
Click Constraints and click its button
In the Constraints Collection Editor, if Constraint1 is selected, click Edit (otherwise, click Add -> Unique Constraint)
Set the Name to PKEmployees
Click the check box of EmployeeID and click the Primary Key check box (clear any other check box)
Click OK and click Close

Practical Learning: Using the Relationships

If necessary, display the OrderProcessing form.
Double-click an unoccupied area of the form and change its Load event as follows:

private void OrderProcessing_Load(object sender, EventArgs e)
{
    string strFilename = @"C:\Bethesda Car Rental1\employees.xml";

    if (File.Exists(strFilename))
        dsRentalOrders.ReadXml(strFilename);

    strFilename = @"C:\Bethesda Car Rental1\customers.xml";

    if (File.Exists(strFilename))
        dsRentalOrders.ReadXml(strFilename);

    strFilename = @"C:\Bethesda Car Rental1\cars.xml";

    if (File.Exists(strFilename))
        dsRentalOrders.ReadXml(strFilename);
}

Return to the Order Processing form and click the Employee # combo box
In the Properties window, change the following characteristics:
DataSource: dsRentalOrders
DisplayMember: Employee.EmployeeNumber

On the form, double-click the Employee # combo box and implement the event as follows:

private void cbxEmployeeID_SelectedIndexChanged(object sender, EventArgs e)
{
    foreach (DataRow row in tblEmployee.Rows)
    {
        if (cbxEmployeeID.Text == row["EmployeeNumber"].ToString())
            txtEmployeeName.Text = row["FullName"].ToString();
    }
}

On the form, click the Driver's Lic # combo box
In the Properties window, change the following characteristics:
DataSource: dsRentalOrders
DisplayMember: Customer.DrvLicNumber

On the form, double-click the Driver's Lic # combo box and implement the event as follows:

private void cbxCustomerID_SelectedIndexChanged(object sender, EventArgs e)
{
    foreach (DataRow row in tblCustomer.Rows)
    {
        if (cbxCustomerID.Text == row["DrvLicNumber"].ToString())
        {
            txtCustomerName.Text = row["FullName"].ToString();
            txtCustomerAddress.Text = row["Address"].ToString();
            txtCustomerCity.Text = row["City"].ToString();
            cbxCustomerStates.Text = row["State"].ToString();
            txtCustomerZIPCode.Text = row["ZIPCode"].ToString();
        }
    }
}

On the form, click the Tag Number combo box
In the Properties window, change the following characteristics:
DataSource: dsRentalOrders
DisplayMember: Car.TagNumber

On the form, double-click the Tag Number combo box and implement its ValueChanged event as follows:

private void cbxCarID_SelectedIndexChanged(object sender, EventArgs e)
{
    foreach (DataRow row in tblCar.Rows)
    {
        if (cbxCarID.Text == row["TagNumber"].ToString())
        {
            txtMake.Text = row["Make"].ToString();
            txtModel.Text = row["Model"].ToString();
            txtCarYear.Text = row["Year"].ToString();
        }
    }
}

Return to the OrderProcessing form
From the Data section of the Toolbox, click DataSet and click the form
Click Untyped Dataset and click OK
In the Properties window, change the following characteristics:
DataSetName: OrderProcessing
(Name):dsOrderProcessing
Click the ellipsis button of the Tables field
In the Tables Collection Editor, click Add and change the characteristics as follows:
TableName: RentalOrder
(Name): tblRental
Click the ellipsis button of the Columns field

In the Columns Collection Editor, click Add continuously and create the following columns:

ColumnName	(Name)	Other Properties
ReceiptNumber	colReceiptNumber	AutoIncrement: True AutoIncrementSeed: 1001
DateProcessed	colProcessedDate
OrderStatus	colStatus
EmployeeNumber	colEmplNumber
EmployeeName	colEmplName
CustomerDrvLicNbr	colDrvLicNbr
CustomerName	colCustName
CustomerAddress	colCustAddress
CustomerCity	colCustCity
CustomerState	colCustState
CustomerZIPCode	colCustZIPCode
CarTagNumber	colCarTagNumber
CarMake	colMake
CarModel	colVehicleModel
CarYear	colVehicleYear
CarCondition	colCondition
CarTankLevel	colCarTankLevel
MileageStart	colCarMileageStart
MileageEnd	colCarMileageEnd
RentStartDate	colStartDate
RendependDate	colEndDate
TotalDays	colTotalDays
RateApplied	colAppliedRate
SubTotal	colTotalSub
TaxRate	colRateTax
TaxAmount	colAmountTax
OrderTotal	colTotalOrder

Click Close and click Close

On the form, double-click the Save button and implement its event as follows:

private void btnSave_Click(object sender, EventArgs e)
{
    // Don't save this rental order if we don't
    // know who processed it
    if (cbxEmployeeID.SelectedIndex < 0)
    {
        MessageBox.Show("You must select the employee number or " +
                        "the clerk who processed this order.");
        return;
    }

    // Don't save this rental order if we don't
    // know who is renting the car
    if (cbxCustomerID.SelectedIndex < 0)
    {
        MessageBox.Show("You must select the driver's license number " +
                        "of the customer who is renting the car");
        return;
    }

    // Don't save the rental order if we don't
    // know what car is being rented
    if (cbxCarID.SelectedIndex < 0)
    {
        MessageBox.Show("You must select the tag number " +
                        "of the car that is being rented");
        return;
    }

    // This variable will allow us to know whether 
    // we are only updating a rental order
    bool found = false;
    // This is the XML file that holds the rental orders
    string strFilename = @"C:\Bethesda Car Rental1\RentalOrders.xml";

    // This is the stream that holds the file
    FileStream bcrStream = new FileStream(strFilename,
                                          FileMode.OpenOrCreate,
                                          FileAccess.ReadWrite,
                                          FileShare.ReadWrite);

    // Check the rental orders
    foreach (DataRow rowRentalOrder in tblRental.Rows)
    {
        // Find out if there is already a rental
        // order with the current receipt number
        if (rowRentalOrder["ReceiptNumber"].ToString() ==
            txtReceiptNumber.Text)
        {
            // Since the rental order was found, make note
            found = true;

            // Get ready to update the rental order
            rowRentalOrder["DateProcessed"] =
                        dtpDateProcessed.Value.ToString("d");
            rowRentalOrder["EmployeeNumber"] = cbxEmployeeID.Text;
            rowRentalOrder["EmployeeName"] = txtEmployeeName.Text;
            rowRentalOrder["CustomerDrvLicNbr"] = cbxCustomerID.Text;
            rowRentalOrder["CustomerName"] = txtCustomerName.Text;
            rowRentalOrder["CustomerAddress"] = txtCustomerAddress.Text;
            rowRentalOrder["CustomerCity"] = txtCustomerCity.Text;
            rowRentalOrder["CustomerState"] = cbxCustomerStates.Text;
            rowRentalOrder["CustomerZIPCode"] = txtCustomerZIPCode.Text;
            rowRentalOrder["CarTagNumber"] = cbxCarID.Text;
            rowRentalOrder["CarMake"] = txtMake.Text;
            rowRentalOrder["CarModel"] = txtModel.Text;
            rowRentalOrder["CarYear"] = txtCarYear.Text;
            rowRentalOrder["CarCondition"] = cbxCarConditions.Text;
            rowRentalOrder["CarTankLevel"] = cbxTankLevels.Text;
            rowRentalOrder["MileageStart"] = txtMileageStart.Text;
            rowRentalOrder["MileageEnd"] = txtMileageEnd.Text;
            rowRentalOrder["RentStartDate"] =
                        dtpStartDate.Value.ToString("d");
            rowRentalOrder["RendependDate"] =
                        dtpEndDate.Value.ToString("d");
            rowRentalOrder["TotalDays"] = txtDays.Text;
            rowRentalOrder["RateApplied"] = txtRateApplied.Text;
            rowRentalOrder["SubTotal"] = txtSubTotal.Text;
            rowRentalOrder["TaxRate"] = txtTaxRate.Text;
            rowRentalOrder["TaxAmount"] = txtTaxAmount.Text;
            rowRentalOrder["OrderTotal"] = txtOrderTotal.Text;
            rowRentalOrder["OrderStatus"] = cbxOrderStatus.Text;
            // STOP!!!
            break;
        }
    }

    // If the receipt number was not found,
    // then prepare to create a new rental order
    if (found == false)
    {
        DataRow rowRentalOrder = tblRental.NewRow();

        rowRentalOrder["DateProcessed"] =
                    dtpDateProcessed.Value.ToString("d");
        rowRentalOrder["EmployeeNumber"] = cbxEmployeeID.Text;
        rowRentalOrder["EmployeeName"] = txtEmployeeName.Text;
        rowRentalOrder["CustomerDrvLicNbr"] = cbxCustomerID.Text;
        rowRentalOrder["CustomerName"] = txtCustomerName.Text;
        rowRentalOrder["CustomerAddress"] = txtCustomerAddress.Text;
        rowRentalOrder["CustomerCity"] = txtCustomerCity.Text;
        rowRentalOrder["CustomerState"] = cbxCustomerStates.Text;
        rowRentalOrder["CustomerZIPCode"] = txtCustomerZIPCode.Text;
        rowRentalOrder["CarTagNumber"] = cbxCarID.Text;
        rowRentalOrder["CarMake"] = txtMake.Text;
        rowRentalOrder["CarModel"] = txtModel.Text;
        rowRentalOrder["CarYear"] = txtCarYear.Text;
        rowRentalOrder["CarCondition"] = cbxCarConditions.Text;
        rowRentalOrder["CarTankLevel"] = cbxTankLevels.Text;
        rowRentalOrder["MileageStart"] = txtMileageStart.Text;
        rowRentalOrder["MileageEnd"] = txtMileageEnd.Text;
        rowRentalOrder["RentStartDate"] = 
		dtpStartDate.Value.ToString("d");
        rowRentalOrder["RendependDate"] = dtpEndDate.Value.ToString("d");
        rowRentalOrder["TotalDays"] = txtDays.Text;
        rowRentalOrder["RateApplied"] = txtRateApplied.Text;
        rowRentalOrder["SubTotal"] = txtSubTotal.Text;
        rowRentalOrder["TaxRate"] = txtTaxRate.Text;
        rowRentalOrder["TaxAmount"] = txtTaxAmount.Text;
        rowRentalOrder["OrderTotal"] = txtOrderTotal.Text;
        rowRentalOrder["OrderStatus"] = cbxOrderStatus.Text;
        tblRental.Rows.Add(rowRentalOrder);
    }

    // Now that the rental order is ready, ...
    try
    {
        // ... save it
        dsOrderProcessing.WriteXml(bcrStream);
    }
    finally
    {
        bcrStream.Close();
    }
}

Return to the form and double-click the Open button

Implement its event as follows:

private void btnOpen_Click(object sender, EventArgs e)
{
    bool found = false;

    try
    {
        string strFilename = @"C:\Bethesda Car Rental1\RentalOrders.xml";

        if (File.Exists(strFilename))
        {
            dsOrderProcessing.ReadXml(strFilename);

            foreach (DataRow rowRentalOrder in tblRental.Rows)
            {
                if (rowRentalOrder["ReceiptNumber"].ToString() == txtReceiptNumber.Text)
                {
                    found = true;
                    dtpDateProcessed.Value = 
			DateTime.Parse(rowRentalOrder["DateProcessed"].ToString());
                    cbxEmployeeID.Text = rowRentalOrder["EmployeeNumber"].ToString();
                    txtEmployeeName.Text = rowRentalOrder["EmployeeName"].ToString();
                    cbxCustomerID.Text = rowRentalOrder["CustomerDrvLicNbr"].ToString();
                    txtCustomerName.Text = rowRentalOrder["CustomerName"].ToString();
                    txtCustomerAddress.Text = 
			rowRentalOrder["CustomerAddress"].ToString();
                    txtCustomerCity.Text = rowRentalOrder["CustomerCity"].ToString();
                    cbxCustomerStates.Text = rowRentalOrder["CustomerState"].ToString();
                    txtCustomerZIPCode.Text = 
			rowRentalOrder["CustomerZIPCode"].ToString();
                    cbxCarID.Text = rowRentalOrder["CarTagNumber"].ToString();
                    txtMake.Text = rowRentalOrder["CarMake"].ToString();
                    txtModel.Text = rowRentalOrder["CarModel"].ToString();
                    txtCarYear.Text = rowRentalOrder["CarYear"].ToString();
                    cbxCarConditions.Text = rowRentalOrder["CarCondition"].ToString();
                    cbxTankLevels.Text = rowRentalOrder["CarTankLevel"].ToString();
                    txtMileageStart.Text = rowRentalOrder["MileageStart"].ToString();
                    txtMileageEnd.Text = rowRentalOrder["MileageEnd"].ToString();
                    dtpStartDate.Value = 
			DateTime.Parse(rowRentalOrder["RentStartDate"].ToString());
                    dtpEndDate.Value = 
			DateTime.Parse(rowRentalOrder["RendependDate"].ToString());
                    txtDays.Text = rowRentalOrder["TotalDays"].ToString();
                    txtRateApplied.Text = rowRentalOrder["RateApplied"].ToString();
                    txtSubTotal.Text = rowRentalOrder["SubTotal"].ToString();
                    txtTaxRate.Text = rowRentalOrder["TaxRate"].ToString();
                    txtTaxAmount.Text = rowRentalOrder["TaxAmount"].ToString();
                    txtOrderTotal.Text = rowRentalOrder["OrderTotal"].ToString();
                    cbxOrderStatus.Text = rowRentalOrder["OrderStatus"].ToString();
                    break;
                }
            }
        }
        else
            MessageBox.Show("There is no cleaning order to open");
    }
    catch (ConstraintException)
    {
    }

    if (found == false)
        MessageBox.Show("There is no rental order with that receipt number");
}

Execute the application


Home	Copyright © 2010-2016, FunctionX	Home