//function for updating new records
void Update()
{
//create an instance of the Ticket Book
clsTicketCollection TicketBook = new clsTicketCollection();
//validate the data on the web form
string Error = TicketBook.ThisTicket.Valid(txtTicketPurchaseDate.Text, txtTicketNo.Text, txtFlightNo.Text, txtSeatNo.Text);
//if the data is ok then add it to the object
if (Error == "")
{
//find the record to update
TicketBook.ThisTicket.Find(TicketID);
//get the data entered by the user
TicketBook.ThisTicket.TicketPurchaseDate = Convert.ToDateTime(txtTicketPurchaseDate.Text);
TicketBook.ThisTicket.TicketNo = txtTicketNo.Text;
TicketBook.ThisTicket.FlightNo = Convert.ToInt32(txtFlightNo.Text);
TicketBook.ThisTicket.SeatNo = txtSeatNo.Text;
//update the record
TicketBook.Update();
//all done so redirect back to the main page
Response.Redirect("TicketList.aspx");
}
else
{
//report the error
lblError.Text = "There were problems with the data entered " + Error;
}
}
public void UpdateMethod()
{
//create an instance of a class
clsTicketCollection AllTicket = new clsTicketCollection();
//create the item of test data
clsTicket TestItem = new clsTicket();
//var to store the primarykey
Int32 PrimaryKey = 0;
//set its properties
TestItem.TicketPurchaseDate = DateTime.Now.Date;
TestItem.TicketNo = "ASD456GH";
TestItem.FlightNo = 535;
TestItem.SeatNo = "53B";
//set thisticket to the test data
AllTicket.ThisTicket = TestItem;
//add the record
PrimaryKey = AllTicket.Add();
//set the primary key of the test data
TestItem.TicketID = PrimaryKey;
//modify the test data
TestItem.TicketPurchaseDate = DateTime.Now.Date;
TestItem.TicketNo = "HGF3F72";
TestItem.FlightNo = 767;
TestItem.SeatNo = "5B";
//Set the record based on the new test data
AllTicket.ThisTicket = TestItem;
//update the record
AllTicket.Update();
//find the record
AllTicket.ThisTicket.Find(PrimaryKey);
//test to see this ticket matches the test data
Assert.AreEqual(AllTicket.ThisTicket, TestItem);
}