private Boolean showBookingInformation()
{
lblBookingId.Text = EditBooking2.TBookingID;
txtPhoneNo.Text = EditBooking2.TEmail;
HotelReservationEntities3 h = new HotelReservationEntities3();
var book = from x in h.bookings
where x.bookingid == EditBooking2.TBookingID && x.email == EditBooking2.TEmail
select x;
booking b1 = book.FirstOrDefault();
if (book.FirstOrDefault() != null)
{
RegularExpressionValidator2.Visible = false;
txtName.Text = b1.name;
txtPassportNo.Text = b1.passportno;
txtEmail.Text = b1.email;
txtPhoneNo.Text = b1.Phone;
txtCheckInDate.Text = b1.datecheckin.ToShortDateString();
txtCheckOutDate.Text = b1.datecheckout.ToShortDateString();
int range = b1.datecheckout.DayOfYear - b1.datecheckin.DayOfYear + 1;
if (range >= 0)
{
lblDurantionOut.Text = range.ToString();
}
else
{
lblDurantionOut.Text = "0";
}
string roomType = "";
switch (b1.roomid)
{
case "s": roomType = "Single";
break;
case "d": roomType = "Double";
break;
case "du": roomType = "Deluxe";
break;
case "su": roomType = "Superior";
break;
}
lblRoomType.Text = roomType;
lblNumberOfRoom.Text = b1.roomno.ToString();
var room = from x in h.roomfacilities
where x.roomid == b1.roomid
select x;
roomfacility rm = room.FirstOrDefault();
lblPrice.Text = "$" + rm.roomrent.ToString() + " per room";
lblTotal.Text = "$" + (rm.roomrent * range).ToString();
infoPanel.Visible = true;
return(true);
}
else
{
return(false);
}
}
protected void btnregister_Click(object sender, EventArgs e)
{
using (var db = new HotelReservationEntities3())
{
login login = new login();
login.userid = txtuname.Text;
login.passsword = txtpassword.Text;
userdetail user = new userdetail();
user.userid = txtuname.Text;
user.name = txtname.Text;
user.passportno = txtnirc.Text;
user.email_phoneno = txtemail.Text;
db.logins.Add(login);
db.SaveChanges();
db.userdetails.Add(user);
db.SaveChanges();
Session["user"] = login;
Session["userdetail"] = user;
Response.Redirect("BookingConfirmation.aspx");
}
}
private void calculateCost(int range)
{
lblBookingId.Text = EditBooking2.TBookingID;
HotelReservationEntities3 h = new HotelReservationEntities3();
var book = from x in h.bookings
where x.bookingid == EditBooking2.TBookingID && x.email == EditBooking2.TEmail
select x;
booking b1 = book.FirstOrDefault();
string roomType = "";
switch (lblRoomType.Text)
{
case "Single": roomType = "s";
break;
case "Double": roomType = "d";
break;
case "Deluxe": roomType = "du";
break;
case "Superior": roomType = "su";
break;
}
b1.roomid = roomType;
lblNumberOfRoom.Text = "1";
var room = from x in h.roomfacilities
where x.roomid == b1.roomid
select x;
roomfacility rm = room.FirstOrDefault();
lblPrice.Text = "$" + rm.roomrent.ToString() + " per room";
lblTotal.Text = "$" + (rm.roomrent * range).ToString();
}
protected void Button1_Click(object sender, EventArgs e)
{
using (HotelReservationEntities3 hr = new HotelReservationEntities3())
{
for (int i = 0; i < noofroom; i++)
{
if (noofroom < numgen)
{
var booking1 = (from a in hr.bookings
select a).ToList();
int idgen = booking1.Count;
booking bk = new booking();
int no = idgen;
no++;
bk.bookingid = "bk" + no;
bk.name = TextBox3.Text;
bk.Phone = TextBox6.Text;
bk.passportno = TextBox4.Text;
bk.email = TextBox5.Text;
bk.datecheckin = Convert.ToDateTime(Checkin.Text);
bk.datecheckout = Convert.ToDateTime(Checkout.Text);
//bk.noofpeople = Convert.ToInt16(Noofpeople.Text);
bk.roomid = Roomtype.Text;
string type = Roomtype.Text;
if (type.Equals("d"))
{
int temp1 = 60 - numgen;
temp1++;
bk.roomno = Roomtype.Text + temp1;
hr.bookings.Add(bk);
hr.SaveChanges();
numgen--;
}
else
{
int temp2 = 20 - numgen;
temp2++;
bk.roomno = Roomtype.Text + temp2;
hr.bookings.Add(bk);
hr.SaveChanges();
numgen--;
}
if (numgen == 0)
{
break;
}
}
}
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
using (HotelReservationEntities3 dele = new HotelReservationEntities3())
{
var Delebook = (from x in dele.bookings
where x.bookingid == EditBooking1.TBookingID &&
x.email == EditBooking1.TEmail
select x).First();
if (Delebook != null)
{
dele.bookings.Remove(Delebook);
dele.SaveChanges();
Clear();
EditBooking1.Message = "Record Deleted Successfully";
}
}
}
void Retrieve_Submit(object sender, EventArgs e)
{
HotelReservationEntities3 h = new HotelReservationEntities3();
var book = from x in h.bookings
where x.bookingid == EditBooking1.TBookingID &&
x.email == EditBooking1.TEmail
select x;
if (book.FirstOrDefault() != null)
{
booking b = book.FirstOrDefault();
PanelInfo.Visible = true;
labName.Text = b.name;
labPss.Text = b.passportno;
labEmail.Text = b.email;
labTel.Text = b.Phone;
labIN.Text = b.name;
labOUT.Text = b.datecheckin.ToString("dd/MM/yyyy");
labIN.Text = b.datecheckout.ToString("dd/MM/yyyy");
labDuration.Text = (b.datecheckout.Date.Day - b.datecheckin.Date.Day).ToString();
if (b.roomid == "s")
{
labRoomT.Text = "Single room";
}
else if (b.roomid == "d")
{
labRoomT.Text = "Double room";
}
else if (b.roomid == "su")
{
labRoomT.Text = "Superior";
}
else if (b.roomid == "du")
{
labRoomT.Text = "Deluxe";
}
labRoomNo.Text = "1";
}
else
{
EditBooking1.Message = "No Record has been found";
}
}
protected void Button3_Click(object sender, EventArgs e)
{
using (HotelReservationEntities3 db = new HotelReservationEntities3())
{
var login = db.logins.Find(TextBox1.Text);
if (login != null)
{
if (login.passsword.Trim() == TextBox2.Text.Trim())
{
Session["user"] = login;
HotelReservationEntities3 context = new HotelReservationEntities3();
var query = from x in context.userdetails
where x.userid == login.userid
select x;
userdetail detail = query.First();
TextBox3.Text = detail.name;
Session["MainName"] = detail.name;
TextBox4.Text = detail.passportno;
TextBox5.Text = detail.email_phoneno;
Session["userdetail"] = detail;
Label2.Text = "Member Infromation";
Label6.Text = "Member Name";
Label17.Visible = false;
//Response.Redirect("");
}
else
{
Label17.Visible = true;
}
}
else
{
Label17.Visible = true;
}
}
}
private void changeBooking()
{
lblBookingId.Text = EditBooking2.TBookingID;
HotelReservationEntities3 h = new HotelReservationEntities3();
var book = from x in h.bookings
where x.bookingid == EditBooking2.TBookingID && x.email == EditBooking2.TEmail
select x;
booking b1 = book.FirstOrDefault();
string roomType = "";
switch (lblRoomType.Text)
{
case "Single": roomType = "s";
break;
case "Double": roomType = "d";
break;
case "Deluxe": roomType = "du";
break;
case "Superior": roomType = "su";
break;
}
// int beforeRoomAmounts = Convert.ToInt32(lblNumberOfRoom.Text);
var avail = from x in h.availablities
where x.dateofavailablity >= b1.datecheckin && x.dateofavailablity <= b1.datecheckout && //&& x.roomsavailable >= beforeRoomAmounts
x.roomid == roomType
select x;
foreach (availablity a in avail)
{
a.roomsavailable += 1;
}
b1.name = txtName.Text;
b1.passportno = txtPassportNo.Text;
b1.email = txtEmail.Text;
b1.Phone = txtPhoneNo.Text;
// lblAfterChange.Text = txtPhoneNo.Text;
b1.datecheckin = Convert.ToDateTime(txtCheckInDate.Text);
b1.datecheckout = Convert.ToDateTime(txtCheckOutDate.Text);
b1.roomid = roomType;
lblNumberOfRoom.Text = "1";
var room = from x in h.roomfacilities
where x.roomid == b1.roomid
select x;
roomfacility rm = room.FirstOrDefault();
lblPrice.Text = "$" + rm.roomrent.ToString() + " per room";
lblTotal.Text = "$" + (rm.roomrent).ToString();
//int afterRoomAmounts = Convert.ToInt32(lblNumberOfRoom.Text);
var avail2 = from x in h.availablities
where x.dateofavailablity >= b1.datecheckin && x.dateofavailablity <= b1.datecheckout && //&& x.roomsavailable >= afterRoomAmounts
x.roomid == roomType
select x;
foreach (availablity a in avail2)
{
a.roomsavailable -= 1;
}
h.SaveChanges();
}
private void checkDateAvailability()
{
DateTime checkIn = Convert.ToDateTime(txtCheckInDate.Text);
DateTime checkOut = Convert.ToDateTime(txtCheckOutDate.Text);//Calendar2.SelectedDate;
String roomtypr = lblRoomType.Text;
int roomAmounts = 1;
HotelReservationEntities3 h = new HotelReservationEntities3();
string roomType = "";
switch (lblRoomType.Text)
{
case "Single": roomType = "s";
break;
case "Double": roomType = "d";
break;
case "Deluxe": roomType = "du";
break;
case "Superior": roomType = "su";
break;
}
var avail = from x in h.availablities
where x.dateofavailablity >= checkIn && x.dateofavailablity <= checkOut && x.roomsavailable >= roomAmounts &&
x.roomid == roomType
select x;
int range = checkOut.DayOfYear - checkIn.DayOfYear + 1;
// int range = checkOut.Date.Day - checkIn.Date.Day+1;
if (avail.FirstOrDefault() == null || avail.ToArray().Length != range)
{
confirmChangeButton.Enabled = false;
var notAvail = from x in h.availablities
where x.dateofavailablity >= checkIn && x.dateofavailablity <= checkOut && x.roomsavailable < roomAmounts &&
x.roomid == roomType
select x;
string message = "";
foreach (availablity a in notAvail)
{
message += a.dateofavailablity.ToShortDateString() + " ";
}
if (range >= 1)
{
testLabel.Text = "Sorry! " + message + " is not available ";
}
else
{
testLabel.Text = "Please choose vaild date !";
}
testLabel.Visible = true;
}
else
{
confirmChangeButton.Enabled = true;
testLabel.Text = "It is available ! ";
testLabel.Visible = true;
}
if (range >= 1)
{
lblDurantionOut.Text = range.ToString();
calculateCost(range);
}
else
{
lblDurantionOut.Text = "0";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
using (HotelReservationEntities3 hr = new HotelReservationEntities3())
{
for (int i = 0; i < noofroom; i++)
{
if (noofroom < numgen)
{
var booking1 = (from a in hr.bookings
select a).ToList();
int idgen = booking1.Count;
booking bk = new booking();
int no = idgen;
//no++;
//bk.bookingid = "bk" + no;
var check = (from x in hr.bookings
select x.bookingid).ToList();
List <int> listid = new List <int>();
foreach (String strbookingid in check)
{
int x = Convert.ToInt32(strbookingid.Substring(2));
listid.Add(x);
}
int maxid = listid.Max();
maxid++;
bk.bookingid = "bk" + maxid;
bk.name = TextBox3.Text;
//bk.Phone = TextBox6.Text;
bk.passportno = TextBox4.Text;
bk.email = TextBox5.Text;
bk.datecheckin = Convert.ToDateTime(Checkin.Text);
bk.datecheckout = Convert.ToDateTime(Checkout.Text);
//bk.noofpeople = Convert.ToInt16(Noofpeople.Text);
bk.roomid = Roomtype.Text;
string type = Roomtype.Text;
if (type.Equals("d"))
{
int temp1 = 60 - numgen;
temp1++;
bk.roomno = Roomtype.Text + temp1;
bk.noofpeople = 2;
hr.bookings.Add(bk);
hr.SaveChanges();
//updating availablity table
avai[i] = numgen;
numgen--;
}
else if (type.Equals("s"))
{
int temp2 = 20 - numgen;
temp2++;
bk.roomno = Roomtype.Text + temp2;
bk.noofpeople = 1;
hr.bookings.Add(bk);
hr.SaveChanges();
avai[i] = numgen;
numgen--;
}
else if (type.Equals("du"))
{
int temp2 = 20 - numgen;
temp2++;
bk.roomno = Roomtype.Text + temp2;
bk.noofpeople = 3;
hr.bookings.Add(bk);
hr.SaveChanges();
avai[i] = numgen;
numgen--;
}
else if (type.Equals("su"))
{
int temp2 = 20 - numgen;
temp2++;
bk.roomno = Roomtype.Text + temp2;
bk.noofpeople = 5;
hr.bookings.Add(bk);
hr.SaveChanges();
avai[i] = numgen;
numgen--;
}
else
{
}
//Jade
var avail2 = from x in hr.availablities
where x.dateofavailablity >= bk.datecheckin && x.dateofavailablity <= bk.datecheckout && //&& x.roomsavailable >= afterRoomAmounts
x.roomid == Roomtype.Text
select x;
foreach (availablity a in avail2)
{
a.roomsavailable -= 1;
}
hr.SaveChanges();
//Thiru
//var availablity1 = (from a in hr.availablities
// select a).ToList();
//int idgen1 = availablity1.Count;
//int avgen = idgen1;
//avgen++;
//non = avai.Min();
//if (type.Equals("s"))
//{
// availablity av = new availablity();
// av.roomsavailable = non;
// av.availablityid = "av"+avgen;
// av.dateofavailablity = Convert.ToDateTime(Checkin.Text);
// av.roomid = "s";
// hr.availablities.Add(av);
// hr.SaveChanges();
//}
//else if (type.Equals("d"))
//{
// availablity av = new availablity();
// av.roomsavailable = non;
// av.availablityid = "av" + avgen;
// av.dateofavailablity = Convert.ToDateTime(Checkin.Text);
// av.roomid = "d";
// hr.availablities.Add(av);
// hr.SaveChanges();
//}
//else if (type.Equals("du"))
//{
// availablity av = new availablity();
// av.roomsavailable = non;
// av.availablityid = "av"+avgen;
// av.dateofavailablity = Convert.ToDateTime(Checkin.Text);
// av.roomid = "s";
// hr.availablities.Add(av);
// hr.SaveChanges();
//}
//else if (type.Equals("su"))
//{
// availablity av = new availablity();
// av.roomsavailable = non;
// av.availablityid = "av"+avgen;
// av.dateofavailablity = Convert.ToDateTime(Checkin.Text);
// av.roomid = "su";
// hr.availablities.Add(av);
// hr.SaveChanges();
//}
if (numgen == 0)
{
break;
}
String display = "Successfully Booked !!! Thank you for booking at our hotel. You will receive mail about the confirmation.";
ClientScript.RegisterStartupScript(this.GetType(), "Message", "alert('" + display + "')", true);
String toEmail = TextBox5.Text;
String subject = "Booking Confirmation.";
String body = "Successfully booked.";
sendemail(toEmail, subject, body);
}
}
}
}
public String search(DateTime find,DateTime find1, String temp)
{
int[] remaining = new int[30];
int i = 0;
//int diff= Convert.ToInt16(find1-find);
if (find < find1)
{
using (HotelReservationEntities3 hr = new HotelReservationEntities3())
{
for (DateTime check = find; check < find1; check = check.AddDays(1))
{
var book = (from b in hr.bookings
where b.roomid == temp && b.datecheckin == find
select b).ToList();
// booking bbb = book.FirstOrDefault<booking>();
if ((book.Count == 0) && (temp.Equals("s")) || (book.Count == 0) && (temp.Equals("su")) || (book.Count == 0) && (temp.Equals("du")))
{
remaining[i] = 20;
i++;
availablity aa = new availablity();
var check1 = (from x in hr.availablities
select x.availablityid).ToList();
List<int> listid = new List<int>();
foreach (String strbookingid in check1)
{
int x = Convert.ToInt32(strbookingid.Substring(2));
listid.Add(x);
}
int maxid = listid.Max();
maxid++;
aa.availablityid = "av" +maxid;
aa.dateofavailablity = find;
aa.roomid = "s";
aa.roomsavailable = 19;
hr.availablities.Add(aa);
hr.SaveChanges();
}
else if ((book.Count == 0) && (temp.Equals("d")))
{
remaining[i] = 60;
i++;
availablity aa = new availablity();
var check1 = (from x in hr.availablities
select x.availablityid).ToList();
List<int> listid = new List<int>();
foreach (String strbookingid in check1)
{
int x = Convert.ToInt32(strbookingid.Substring(2));
listid.Add(x);
}
int maxid = listid.Max();
maxid++;
aa.availablityid = "av" + maxid;
aa.dateofavailablity = find;
aa.roomid = "s";
aa.roomsavailable = 19;
hr.availablities.Add(aa);
hr.SaveChanges();
}
else if ((book.Count > 0) && (temp.Equals("d")))
{
remaining[i] = 60 - book.Count;
// String r= remaining.ToString();
// Label7.Text= r;
//var avi =( from a in hr.availablities
// where a.roomid == temp && a.dateofavailablity == find
// select a).ToList();
// if((avi.Count>0)&&(temp.Equals("d")))
//{
//}
// availablity aa = avi.FirstOrDefault<availablity>();
// String r = aa.roomsavailable.ToString();
// Label7.Text = r;
i++;
}
else if ((book.Count > 0) && (temp.Equals("su")) || (book.Count > 0) && (temp.Equals("du")) || (book.Count > 0) && (temp.Equals("s")))
{
remaining[i] = 20 - book.Count;
// String r1 = remaining.ToString();
i++;
// Label7.Text = r1;
}
else
r1 = "Coun't find the search";
}
//passing = Convert.ToInt16(remaining.Max());
r1 = Convert.ToString(remaining.Max());
}
}
return r1;
}