protected void rsvnobtn_Click(object sender, EventArgs e)
{
string reservationnum = rsvnotbx.Text;
Reservation r = SWENDbmanager.GetReservationByNum(reservationnum);
Paymentdetails p = SWENDbmanager.GetPaymentdetailsByNum(reservationnum);
gfnametbx.Text = r.Firstname;
glnametbx.Text = r.Lastname;
nrictbx.Text = r.Nric;
roomtbx.Text = Convert.ToString(r.Roomnum);
classtbx.Text = r.Roomclass;
cntbx.Text = r.Contactnum;
emailtbx.Text = r.Emailadd;
ctbx.Text = r.Country;
hometbx.Text = r.Homeadd;
postaltbx.Text = Convert.ToString(r.Postalcode);
citbx.Text = r.Checkindate;
cotbx.Text = r.Checkoutdate;
paymentddl.Text = r.Paymentmeth;
indtbx.Text = r.Indicationlate;
addrtbx.Text = r.Addremarks;
childtbx.Text = r.Numofchild;
adulttbx.Text = r.Numofadult;
cardnotbx.Text = p.Creditcardnum;
holdertbx.Text = p.Creditholdername;
exptbx.Text = p.Expirydate;
}
protected void shgbtn_Click(object sender, EventArgs e)
{
string reservationnum = shgtbx.Text;
Reservation r = SWENDbmanager.GetReservationByNum(reservationnum);
Paymentdetails p = SWENDbmanager.GetPaymentdetailsByNum(reservationnum);
lblrmno.Text = r.Roomnum;
string roomnum = lblrmno.Text;
Room r1 = SWENDbmanager.GetRoomByNum(roomnum);
lblrmtype.Text = r1.Roomtype;
lblgname.Text = r.Firstname;
lblgnamel.Text = r.Lastname;
lblnric.Text = r.Nric;
lblagno.Text = r.Numofadult;
lblcgno.Text = r.Numofchild;
lblcno.Text = r.Contactnum;
lblem.Text = r.Emailadd;
lblhma.Text = r.Homeadd;
lblpc.Text = Convert.ToString(r.Postalcode);
lblc.Text = r.Country;
lblpm.Text = p.Paymentmeth;
lblcrno.Text = p.Creditcardnum;
lblcrname.Text = p.Creditholdername;
lblexp.Text = p.Expirydate;
lblcid.Text = r.Checkindate;
lblcod.Text = r.Checkoutdate;
lblrr.Text = r1.Roomrate;
}
protected void rmdelbtn_Click(object sender, EventArgs e)
{
string roomnum = rmnotbx.Text;
if (SWENDbmanager.DeleteRoom(roomnum) == 1)
{
lblSuccessful.Text = "Room Deletion Completed..";
}
}
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..";
}
}
protected void Button4_Click(object sender, EventArgs e)
{
string staffno = staffnotbx.Text;
if (SWENDbmanager.DeleteStaff(staffno) == 1)
{
lblSuccesful.Text = "Staff Deletion Completed..";
}
else
{
lblSuccesful.Text = "Staff Deletion Failed..";
}
}
protected void rmnobtn_Click(object sender, EventArgs e)
{
string roomnum = rmnotbx.Text;
Room r = SWENDbmanager.GetRoomByNum(roomnum);
lblroomid.Text = Convert.ToString(r.Roomid);
lblroomno.Text = r.Roomnum;
lblroomtype.Text = r.Roomtype;
lblnumbed.Text = Convert.ToString(r.Numofbed);
lblbedtype.Text = r.Bedtype;
lblclass.Text = r.Roomclass;
lblroomrate.Text = r.Roomrate;
roomstattbx.Text = r.Roomstatus;
}
protected void Button1_Click(object sender, EventArgs e)
{
string staffno = staffnotbx.Text;
Staff s = SWENDbmanager.GetStaffByNum(Convert.ToInt32(staffno));
lblstaffno.Text = Convert.ToString(s.Staffnum);
staffnametbx.Text = s.Staffname;
lbldob.Text = s.Dob;
lblbankno.Text = s.Bankaccnum;
contatbx.Text = Convert.ToString(s.Contactnum);
homeaddtbx.Text = s.Homeadd;
dutytbx.Text = s.Dutytype;
usernametbx.Text = s.Username;
passtbx.Text = s.Password;
}
protected void loginbtn_Click(object sender, EventArgs e)
{
string username = usertbx.Text;
string password = pwtbx.Text;
Staff s = new Staff();
s = SWENDbmanager.UserLogin(username, password);
if (s == null)
{
lblfail.Text = "Invalid Username or Password..";
}
else
{
string staffnum = Convert.ToString(s.Staffnum);
Response.Redirect("HomePage.aspx?staffnum=" + staffnum);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
string staffnum = Request.QueryString["staffnum"];
Staff s = SWENDbmanager.GetStaffByNum(Convert.ToInt32(staffnum));
lbluser.Text = s.Staffname;
lblstaffnum.Text = Convert.ToString(s.Staffnum);
staffnametbx.Text = s.Staffname;
dobtbx.Text = s.Dob;
banktbx.Text = s.Bankaccnum;
conttbx.Text = Convert.ToString(s.Contactnum);
lblduty.Text = s.Dutytype;
hometbx.Text = s.Homeadd;
usertbx.Text = s.Username;
pwtbx.Text = s.Password;
if (lblduty.Text == "Administrator")
{
staffbtn.Visible = true;
}
}
protected void createroombtn_Click(object sender, EventArgs e)
{
Room r = new Room();
r.Roomnum = rnotbx.Text;
r.Roomtype = rttbx.Text;
r.Roomclass = rctbx.Text;
r.Numofbed = Convert.ToInt32(nobtbx.Text);
r.Bedtype = tobtbx.Text;
r.Roomstatus = rstbx.Text;
r.Roomrate = rrtbx.Text;
if (SWENDbmanager.InsertRoom(r) == 1)
{
lblSuccessful.Text = "Room Creation Completed..";
}
else
{
lblSuccessful.Text = "Room Creation Failed..";
}
}
protected void dlbtn_Click(object sender, EventArgs e)
{
string reservationnum = rsvnotbx.Text;
if (SWENDbmanager.DeleteReservation(reservationnum) == 1)
{
lblSuccessful.Text = "Reservation Deletion Completed..";
}
else
{
lblUnsuccessful.Text = "Reservation Deletion Failed..";
}
if (SWENDbmanager.DeletePaymendDetails(reservationnum) == 1)
{
lblpaycompleted.Text = "Payment Details Deletion Completed..";
}
else
{
lblpayfailed.Text = "Payment Details Deletion Failed..";
}
}
protected void rmeditbtn_Click(object sender, EventArgs e)
{
Room r = new Room();
r.Roomid = Convert.ToInt32(lblroomid.Text);
r.Roomnum = lblroomno.Text;
r.Roomtype = lblroomtype.Text;
r.Numofbed = Convert.ToInt32(lblnumbed.Text);
r.Bedtype = lblbedtype.Text;
r.Roomclass = lblclass.Text;
r.Roomrate = lblroomrate.Text;
r.Roomstatus = roomstattbx.Text;
if (SWENDbmanager.UpdateRoom(r) == 1)
{
lblSuccessful.Text = "Room Status Update Completed..";
}
else
{
lblSuccessful.Text = "Room Status Update Failed..";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Staff s = new Staff();
s.Staffname = staffnametbx.Text;
s.Dob = dobtbx.Text;
s.Bankaccnum = banknotbx.Text;
s.Contactnum = Convert.ToInt32(contatbx.Text);
s.Homeadd = hometbx.Text;
s.Dutytype = dutytbx.Text;
s.Username = usernametbx.Text;
s.Password = passtbx.Text;
if (SWENDbmanager.InsertStaff(s) == 1)
{
lblSuccessful.Text = "Staff Creation Completed..";
}
else
{
lblSuccessful.Text = "Staff Creation Failed..";
}
}
protected void Button3_Click(object sender, EventArgs e)
{
Staff s = new Staff();
s.Staffnum = Convert.ToInt32(lblstaffno.Text);
s.Staffname = staffnametbx.Text;
s.Dob = lbldob.Text;
s.Bankaccnum = lblbankno.Text;
s.Contactnum = Convert.ToInt32(contatbx.Text);
s.Homeadd = homeaddtbx.Text;
s.Dutytype = dutytbx.Text;
s.Username = usernametbx.Text;
s.Password = passtbx.Text;
if (SWENDbmanager.UpdateStaff(s) == 1)
{
lblSuccesful.Text = "Staff Update Completed..";
}
else
{
lblSuccesful.Text = "Staff Update Failed..";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Staff s1 = new Staff();
s1.Staffnum = Convert.ToInt32(lblstaffnum.Text);
s1.Staffname = staffnametbx.Text;
s1.Dob = dobtbx.Text;
s1.Bankaccnum = banktbx.Text;
s1.Contactnum = Convert.ToInt32(conttbx.Text);
s1.Dutytype = lblduty.Text;
s1.Homeadd = hometbx.Text;
s1.Username = usertbx.Text;
s1.Password = pwtbx.Text;
if (SWENDbmanager.UpdateStaff(s1) == 1)
{
lblupdated.Text = "Profile Update Completed..";
}
else
{
lblupdated.Text = "Profile Update Failed..";
}
}
