protected void rsvcreatebtn_Click(object sender, EventArgs e) { Reservation r = new Reservation(); r.Reservationnum = rsv2tbx.Text; r.Roomnum = rm2tbx.Text; r.Firstname = gf2tbx.Text; r.Lastname = gl2tbx.Text; r.Nric = nric2tbx.Text; r.Numofadult = adg1tbx.Text; r.Numofchild = ch1tbx.Text; r.Contactnum = cnt1tbx.Text; r.Emailadd = email2tbx.Text; r.Homeadd = home2tbx.Text; r.Postalcode = Convert.ToInt32(post2tbx.Text); r.Country = co2tbx.Text; r.Paymentmeth = meth2ddl.Text; r.Checkindate = ci2tbx.Text; r.Checkoutdate = cho2tbx.Text; r.Addremarks = add2tbx.Text; r.Indicationlate = ind2tbx.Text; r.Roomclass = class2tbx.Text; Paymentdetails p = new Paymentdetails(); p.Paymentmeth = meth2ddl.Text; p.Creditcardnum = cred2tbx.Text; p.Creditholdername = holder2tbx.Text; p.Expirydate = exp2tbx.Text; p.Nric = nric2tbx.Text; p.Firstname = gf2tbx.Text; p.Lastname = gl2tbx.Text; p.Reservationnum = rsv2tbx.Text; if (SWENDbmanager.InsertReservation(r) == 1) { lblsuccesscreate.Text = "Reservation Creation Completed.."; } else { lblsuccesscreate.Text = "Reservation Creation Failed.."; } if (SWENDbmanager.InsertPayment(p) == 1) { lblpaycreated.Text = "Payment Details Creation Completed.."; } else { lblpaycreated.Text = "Payment Details Creation Failed.."; } }
protected void updbtn_Click(object sender, EventArgs e) { Reservation r = new Reservation(); r.Firstname = gfnametbx.Text; r.Lastname = glnametbx.Text; r.Nric = nrictbx.Text; r.Roomnum = roomtbx.Text; r.Roomclass = classtbx.Text; r.Contactnum = cntbx.Text; r.Emailadd = emailtbx.Text; r.Country = ctbx.Text; r.Homeadd = hometbx.Text; r.Postalcode = Convert.ToInt32(postaltbx.Text); r.Checkindate = citbx.Text; r.Checkoutdate = cotbx.Text; r.Paymentmeth = paymentddl.Text; r.Indicationlate = indtbx.Text; r.Addremarks = addrtbx.Text; r.Reservationnum = rsvnotbx.Text; r.Numofchild = childtbx.Text; r.Numofadult = adulttbx.Text; Paymentdetails p = new Paymentdetails(); p.Nric = nrictbx.Text; p.Paymentmeth = paymentddl.Text; p.Creditcardnum = cardnotbx.Text; p.Creditholdername = holdertbx.Text; p.Expirydate = exptbx.Text; p.Firstname = gfnametbx.Text; p.Lastname = glnametbx.Text; p.Reservationnum = rsvnotbx.Text; if (SWENDbmanager.UpdateReservation(r) == 1) { lblSuccessful.Text = "Reservation Update Completed.."; } else { lblUnsuccessful.Text = "Reservation Update Failed.."; } if (SWENDbmanager.UpdatePaymentDetails(p) == 1) { lblpaycompleted.Text = "Payment Details Update Completed.."; } else { lblpayfailed.Text = "Payment Details Update Failed.."; } }
public static int UpdateReservation(Reservation r) { int rowsupdated = 0; SqlConnection conn = null; try { conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["SWENConnectionString"].ConnectionString; conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; comm.CommandText = "UPDATE Reservation SET firstname=@firstname, lastname=@lastname, nric=@nric, roomnum=@roomnum, addremarks=@addremarks, contactnum=@contactnum, emailaddress=@emailaddress, homeaddress=@homeaddress, postalcode=@postalcode, country=@country, paymentmeth=@paymentmeth, roomclass=@roomclass, checkindate=@checkindate, checkoutdate=@checkoutdate, indicationlate=@indicationlate, numofchild=@numofchild, numofadult=@numofadult WHERE reservationnum=@reservationnum"; comm.Parameters.AddWithValue("@firstname", r.Firstname); comm.Parameters.AddWithValue("@lastname", r.Lastname); comm.Parameters.AddWithValue("@nric", r.Nric); comm.Parameters.AddWithValue("@roomnum", r.Roomnum); comm.Parameters.AddWithValue("@addremarks", r.Addremarks); comm.Parameters.AddWithValue("@contactnum", r.Contactnum); comm.Parameters.AddWithValue("@emailaddress", r.Emailadd); comm.Parameters.AddWithValue("@homeaddress", r.Homeadd); comm.Parameters.AddWithValue("@postalcode", r.Postalcode); comm.Parameters.AddWithValue("@country", r.Country); comm.Parameters.AddWithValue("@paymentmeth", r.Paymentmeth); comm.Parameters.AddWithValue("@roomclass", r.Roomclass); comm.Parameters.AddWithValue("@checkindate", r.Checkindate); comm.Parameters.AddWithValue("@checkoutdate", r.Checkoutdate); comm.Parameters.AddWithValue("@indicationlate", r.Indicationlate); comm.Parameters.AddWithValue("@numofchild",r.Numofchild); comm.Parameters.AddWithValue("@numofadult",r.Numofadult); comm.Parameters.AddWithValue("@reservationnum", r.Reservationnum); rowsupdated = comm.ExecuteNonQuery(); conn.Close(); } catch (SqlException e) { throw e; } return rowsupdated; }
public static Reservation GetReservationByNum(string reservationnum) { Reservation r = new Reservation(); SqlConnection conn = null; try { conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["SWENConnectionString"].ConnectionString; conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; comm.CommandText = "SELECT * FROM Reservation WHERE reservationnum=@reservationnum"; comm.Parameters.AddWithValue("@reservationnum", reservationnum); SqlDataReader dr = comm.ExecuteReader(); if (dr.Read()) { r.Reservationnum = (string)dr["reservationnum"]; r.Firstname = (string)dr["firstname"]; r.Lastname = (string)dr["lastname"]; r.Nric = (string)dr["nric"]; r.Roomnum = (string)dr["roomnum"]; r.Addremarks = (string)dr["addremarks"]; r.Contactnum = (string)dr["contactnum"]; r.Emailadd = (string)dr["emailaddress"]; r.Homeadd = (string)dr["homeaddress"]; r.Postalcode = (int)dr["postalcode"]; r.Country = (string)dr["country"]; r.Paymentmeth = (string)dr["paymentmeth"]; r.Roomclass = (string)dr["roomclass"]; r.Checkindate = (string)dr["checkindate"]; r.Checkoutdate = (string)dr["checkoutdate"]; r.Indicationlate = (string)dr["indicationlate"]; r.Numofchild = (string)dr["numofchild"]; r.Numofadult = (string)dr["numofadult"]; } dr.Close(); } catch (SqlException e) { throw e; } return r; }