protected void button1_Click(object sender, EventArgs e)
{
Reservation.Status = 1;
if (Reservation.Id == -1)
{
dbc.AddHotelReservation(Reservation);
}
else
{
dbc.UpdateHotelReservation(Reservation);
}
try
{
DateTime time = new DateTime();
for (time = Reservation.CheckIn; time != Reservation.CheckOut; time = time.AddDays(1))
{
Table_Arrangement arrangement = new Table_Arrangement();
if (!dbc.CheckArrangementDate(Reservation.HotelId, Reservation.RoomType, time))
{
arrangement.BookedNumber = Reservation.RoomNum;
arrangement.Date = time;
arrangement.HotelId = Reservation.HotelId;
arrangement.RoomType = Reservation.RoomType;
arrangement.Rate = (dbc.GetRoomByHotelIdAndRoomType(Reservation.HotelId, Reservation.RoomType)).FullRate;
dbc.AddArrangement(arrangement);
}
else
{
arrangement = dbc.GetArrangementByHotelIdRoomTypeAndDate(Reservation.HotelId, Reservation.RoomType, time);
arrangement.BookedNumber += Reservation.RoomNum;
dbc.UpdateArrangement(arrangement);
}
}
}
catch (Exception) { }
Response.Redirect("Management.aspx");
}
partial void DeleteTable_Arrangement(Table_Arrangement instance);
partial void UpdateTable_Arrangement(Table_Arrangement instance);
partial void InsertTable_Arrangement(Table_Arrangement instance);
private void detach_Table_Arrangement(Table_Arrangement entity)
{
this.SendPropertyChanging();
entity.Table_Room = null;
}
private void RefleshPanel2()
{
String roomtype = GridView1.SelectedRow.Cells[0].Text;
int hotelId = hotel.Id;
arrangement = dbc.GetArrangementByHotelIdAndRoomType(hotelId, roomtype);
_arrangement.Clear();
for (int i = 0; i < 7; i++)
{
bool found = false;
foreach (Table_Arrangement a in arrangement)
{
if (a.Date.ToShortDateString() == DateTime.Now.AddDays(i).ToShortDateString())
{
_arrangement.Add(a);
found = true;
break;
}
}
if (!found)
{
Table_Arrangement a = new Table_Arrangement();
a.HotelId = hotel.Id;
a.RoomType = GridView1.SelectedRow.Cells[0].Text;
a.Date = DateTime.Now.AddDays(i);
a.BookedNumber = 0;
a.Rate = Convert.ToInt32(GridView1.SelectedRow.Cells[1].Text.Substring(1, GridView1.SelectedRow.Cells[1].Text.Length - 1));
_arrangement.Add(a);
}
}
}
//更新日程信息
public void UpdateArrangement(Table_Arrangement arrangement)
{
var q = from s in data.Table_Arrangement
where s.HotelId == arrangement.HotelId && s.RoomType == arrangement.RoomType && s.Date >= arrangement.Date && s.Date < arrangement.Date.AddDays(1)
select s;
foreach (Table_Arrangement c in q)
{
c.BookedNumber = arrangement.BookedNumber;
c.Rate = arrangement.Rate;
}
data.SubmitChanges();
}
//添加新日程
public void AddArrangement(Table_Arrangement arrangement)
{
data.Table_Arrangement.InsertOnSubmit(arrangement);
data.SubmitChanges();
}
