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;
}
