public void RemoveTable(int ReservationID, int TableID) //Remove Table (TR)
{
Table_Reservation table_Reservation = GetTable_ReservationById(ReservationID, TableID);
_context.Table_Reservations.Remove(table_Reservation);
_context.SaveChanges();
}
public string GetAreaByID(int ReservationID) // Get the area of a reservation (using
{
try
{
Table_Reservation td = GetTable_ReservationById(ReservationID);
Table t = GetTableByID(td.TableID);
return(t.Area);
}
catch { return(""); }
}
public void AddTable(int ReservationID, int TableID) //set a Table to Reservation
{
Table_Reservation table_Reservation = new Table_Reservation()
{
TableID = TableID,
ReservationID = ReservationID,
};
_context.Table_Reservations.Add(table_Reservation);
_context.SaveChanges();
}
public ActionResult MakeReservation(string date, string Stime, string Etime)
{
if (Session["UserId"] == null)
{
return(View("~/Views/HomePage/Login.cshtml"));
}
else if (Session["table"] != null && date != "" && Stime != "" && Etime != "" && date != null)
{
RestaurantEntities db = new RestaurantEntities();
List <TableCartCreateViewModel> list = (List <TableCartCreateViewModel>)Session["table"];
Table_Cart_Make tc = new Table_Cart_Make();
tc.Customer_Id = (int)Session["UserId"];
tc.Status = "Pending";
tc.Date = date;
tc.Start_time = Stime;
tc.End_Time = Etime;
db.Table_Cart_Make.Add(tc);
db.SaveChanges();
int TableCartId = db.Table_Cart_Make.Max(x => x.Table_Cart_Id);
foreach (var item in list)
{
Table_Reservation tr = new Table_Reservation();
tr.Table_Cart_id = TableCartId;
tr.Table_Id = item.Table_Id;
db.Table_Reservation.Add(tr);
db.SaveChanges();
}
Session["table"] = null;
}
List <ReservationOverViewModel> list2 = getAllReservation();
//return View("~/Views/HomePage/Index.cshtml");
return(View("ShowAllReservation", list2));
}
public IActionResult Index()
{
var Sittings = _services.GetListSitting();
ReportViewModel model = new ReportViewModel()
{
//for Sittings
AllSittings = Sittings,
SittingID = Sittings[0].SittingID
};
try
{
List <Sitting> s = _services.GetListSitting();
List <Reservation> Rs = _services.GetAllReservation();
int cs = 0;
foreach (Reservation r in Rs)
{
Table_Reservation td = _services.GetTable_ReservationById(r.ReservationID);
if (td != null)
{
Table t = _services.GetTableByID(td.TableID);
//area
if (t.Area == "Main Room")
{
model.MainRoom++;
}
if (t.Area == "Balcony")
{
model.Balcony++;
}
if (t.Area == "Outside")
{
model.OutSide++;
}
}
cs = cs + r.NumberOfGuests;
//source
if (r.Source == "WebSite")
{
model.Website++;
}
if (r.Source == "Mobile")
{
model.Mobile++;
}
if (r.Source == "Walk in")
{
model.InPErson++;
}
//sitting
if (r.SittingID == s[0].SittingID)
{
model.Breakfast++;
}
if (r.SittingID == s[1].SittingID)
{
model.Lunch++;
}
if (r.SittingID == s[2].SittingID)
{
model.Dinner++;
}
}
model.Reservations = Rs.Count();
model.Clients = cs;
return(View(model));
}
catch { return(RedirectToAction("Error", "Home")); }
}
public async static void SetReservation(
//List<Table_Reservation> Res,
//List<Table_Reserv_Event> Res_Ev, List<Table_Reserv_Event_Detail> Res_EvDe,
//string _user_id,string _event_status,Object table1,Object table2
)
{
using (var transactionScope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
{
var NowTime = DateTime.Now.ToString("yyyyMMddhhmmss");
var Res = new Table_Reservation()
{
user_id = "test006",
reserv_id = string.Concat("RES", NowTime),
//測試用預約時間
reserv_time = DateTime.Now,
event_status = string.Concat(0, (int)Enum_Reserv_Status.Start),
create_time = DateTime.Now,
reserv_event_id = string.Concat("RES_EV", NowTime)
};
var Res_Ev = new Table_Reserv_Event()
{
event_id = string.Concat("RES_EV", NowTime),
event_name = "",
event_detail_id = string.Concat("RES_DET", NowTime)
};
var Res_Det = new Table_Reserv_Event_Detail()
{
event_detail_id = string.Concat("RES_DET", NowTime),
event_needed_item = "testitem",
amount = 4564,
unit = "元"
};
string sqlCommand1 = @"INSERT INTO
_Reservation
(user_id, reserv_id, reserv_time,event_status,create_time,reserv_event_id)
VALUES(@user_id,@reserv_id, @reserv_time,@event_status,@create_time,@reserv_event_id);";
string sqlCommand2 = @"INSERT INTO
_Reserv_Event
(event_id, event_name, event_detail_id)
VALUES(@event_id, @event_name, @event_detail_id);";
string sqlCommand3 = @"INSERT INTO
_Reserv_Event_Detail
(event_detail_id, event_needed_item, amount,unit)
VALUES(@event_detail_id, @event_needed_item, @amount,@unit);";
using (var conn = new SqlConnection(_connStr))
{
conn.Open();
await conn.ExecuteAsync(sqlCommand1, Res);
await conn.ExecuteAsync(sqlCommand2, Res_Ev);
await conn.ExecuteAsync(sqlCommand3, Res_Det);
}
transactionScope.Complete();
}
}