/// <summary>Indexes this instance.</summary>
/// <returns> Return list view of all guest in database</returns>
public ActionResult Index()
{
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
List <Guest> guest = guestBusinessLayer.Guests.ToList();
return(View(guest));
}
public ActionResult Delete(int id)
{
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
guestBusinessLayer.DeleteGuest(id);
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id)
{
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
Guest guest = guestBusinessLayer.Guests.Single(g => g.GuestId == id);
return(View(guest));
}
public ActionResult Index()
{
GuestListViewModel guestListViewModel = new GuestListViewModel();
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
List <Guest> guests = guestBusinessLayer.GetGuests();
List <GuestViewModel> mylist = new List <GuestViewModel>();
int count = 0;
foreach (Guest gs in guests)
{
if (count == 10)
{
break;
}
GuestViewModel guestViewModel = new GuestViewModel();
guestViewModel.Name = gs.Name;
guestViewModel.GuestId = gs.GuestId.ToString();
guestViewModel.ContactNo = gs.ContactNo;
guestViewModel.TableNo = gs.TableNo;
guestViewModel.Attendance = gs.Attendance;
mylist.Add(guestViewModel);
count++;
}
guestListViewModel.Guest = mylist;
return(View("Index", guestListViewModel));
}
public ActionResult SaveGuest(Guest g, string BtnSubmit)
{
GuestViewModel guestViewModel = new GuestViewModel();
guestViewModel.Statusflag = false;
switch (BtnSubmit)
{
case "Save Guest":
if (ModelState.IsValid)
{
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
g.ContactNo = new string(g.ContactNo.Where(char.IsDigit).ToArray());
guestBusinessLayer.SaveGuest(g);
guestViewModel.Statusflag = true;
return(View("SaveGuestList", guestViewModel));
}
else
{
guestViewModel.Name = g.Name;
guestViewModel.ContactNo = g.ContactNo;
guestViewModel.TableNo = g.TableNo;
guestViewModel.Attendance = g.Attendance;
guestViewModel.Statusflag = false;
return(View("SaveGuestList", guestViewModel));
}
case "Cancel":
return(RedirectToAction("ManageGuests"));
}
return(new EmptyResult());
}
public ActionResult FindGuest()
{
string searchname = Request.Form["SearchByName"];
GuestListViewModel guestListViewModel = new GuestListViewModel();
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
List <Guest> guests = new List <Guest>();
if (searchname == "all")
{
guests = guestBusinessLayer.GetGuests();
}
else if (searchname != null && searchname != "")
{
guests = guestBusinessLayer.FindGuests(searchname);
}
List <GuestViewModel> mylist = new List <GuestViewModel>();
foreach (Guest gs in guests)
{
GuestViewModel guestViewModel = new GuestViewModel();
guestViewModel.Name = gs.Name;
guestViewModel.GuestId = gs.GuestId.ToString();
guestViewModel.ContactNo = gs.ContactNo;
guestViewModel.TableNo = gs.TableNo;
guestViewModel.Attendance = gs.Attendance;
mylist.Add(guestViewModel);
}
guestListViewModel.Guest = mylist;
return(View("Index", guestListViewModel));
}
public ActionResult Edit(Guest guest)
{
if (ModelState.IsValid)
{
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
guestBusinessLayer.UpdateGuest(guest);
return(RedirectToAction("Index"));
}
return(View(guest));
}
// GET: Table
public ActionResult Index()
{
TableListViewModel tableList = new TableListViewModel();
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
List <TableViewModel> myTablelist = new List <TableViewModel>();
int Max_Table = 0;
if (int.TryParse(guestBusinessLayer.GetMaxTable(), out Max_Table))
{
for (int i = 1; i <= Max_Table; i++)
{
TableViewModel table = new TableViewModel();
List <TableGuestViewModel> tableGuest = new List <TableGuestViewModel>();
decimal attendees = 0;
decimal local_percentage = 0;
table.TableNo = i.ToString();
List <Guest> guests = guestBusinessLayer.GetTableGuest(i.ToString());
if (guests.Count > 0)
{
foreach (Guest gs in guests)
{
TableGuestViewModel myGuest = new TableGuestViewModel();
myGuest.GuestId = gs.GuestId.ToString();
myGuest.Name = gs.Name;
myGuest.TableNo = gs.TableNo;
myGuest.Attendance = gs.Attendance;
if (myGuest.Attendance)
{
attendees++;
}
tableGuest.Add(myGuest);
}
local_percentage = (attendees / guests.Count) * 100;
table.Percentage = (int)Math.Floor(local_percentage);
table.TableGuest = tableGuest;
myTablelist.Add(table);
}
}
}
tableList.Total = guestBusinessLayer.GetTotalGuest();
tableList.Attended = guestBusinessLayer.GetAttendedGuest();
tableList.OverallPercentage = (int)Math.Floor(((decimal)tableList.Attended / tableList.Total) * 100);
tableList.Table = myTablelist;
return(View("TableView", tableList));
}
public ActionResult DeleteGuest(int id)
{
GuestViewModel guestViewModel = new GuestViewModel();
if (id != 0)
{
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
Guest guests = guestBusinessLayer.FindGuestsById(id);
guestViewModel.Name = guests.Name;
guestViewModel.GuestId = guests.GuestId.ToString();
guestViewModel.ContactNo = guests.ContactNo;
guestViewModel.TableNo = guests.TableNo;
guestViewModel.Attendance = guests.Attendance;
}
return(View("DeleteGuestConfirm", guestViewModel));
}
public ActionResult EditGuest(Guest guest)
{
string BtnSubmit = Request.Form["BtnSubmit"];
switch (BtnSubmit)
{
case "Save Guest":
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
if (ModelState.IsValid)
{
guestBusinessLayer.EditGuest(guest);
}
break;
case "Cancel":
return(RedirectToAction("ManageGuests"));
}
return(RedirectToAction("ManageGuests"));
}
public JsonResult JUpdateAttd(AttdViewModel g)
{
string GuestId = g.GuestId;
bool Attendance = g.Attendance;
int GuestIdInt = int.Parse(g.GuestId);
GuestListViewModel guestListViewModel = new GuestListViewModel();
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
if (Attendance)
{
guestBusinessLayer.SetAttd(GuestId);
}
else
{
guestBusinessLayer.DelAttd(GuestId);
}
return(Json(g, JsonRequestBehavior.AllowGet));
}
public ActionResult ConfirmedDeleteGuest(int id)
{
GuestViewModel guestViewModel = new GuestViewModel();
string BtnSubmit = Request.Form["BtnSubmit"];
if (id != 0)
{
switch (BtnSubmit)
{
case "Yes":
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
guestBusinessLayer.DeleteGuest(id);
break;
case "Cancel":
return(RedirectToAction("ManageGuests"));
}
}
return(RedirectToAction("ManageGuests"));
}
public ActionResult EditGuest(int id)
{
GuestViewModel guestViewModel = new GuestViewModel();
if (id != 0)
{
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
Guest guests = guestBusinessLayer.FindGuestsById(id);
if (guests == null)
{
return(View("EditGuestListError"));
}
guestViewModel.Name = guests.Name;
guestViewModel.GuestId = guests.GuestId.ToString();
guestViewModel.ContactNo = guests.ContactNo;
guestViewModel.TableNo = guests.TableNo;
guestViewModel.Attendance = guests.Attendance;
}
return(View("EditGuestList", guestViewModel));
}
public ActionResult ManageGuests()
{
GuestListViewModel guestListViewModel = new GuestListViewModel();
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
List <Guest> guests = guestBusinessLayer.GetGuests();
List <GuestViewModel> mylist = new List <GuestViewModel>();
foreach (Guest gs in guests)
{
GuestViewModel guestViewModel = new GuestViewModel();
guestViewModel.Name = gs.Name;
guestViewModel.GuestId = gs.GuestId.ToString();
guestViewModel.ContactNo = gs.ContactNo;
guestViewModel.TableNo = gs.TableNo;
guestViewModel.Attendance = gs.Attendance;
mylist.Add(guestViewModel);
}
guestListViewModel.Guest = mylist;
return(View("ManageGuestList", guestListViewModel));
}
public JsonResult JFindGuest()
{
GuestListViewModel guestListViewModel = new GuestListViewModel();
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
List <Guest> guests = new List <Guest>();
string keyword = "";
if (RouteData.Values["id"] != null)
{
keyword = RouteData.Values["id"].ToString();
}
if (keyword == "all")
{
guests = guestBusinessLayer.GetGuests();
}
else if (keyword != "" && keyword != null)
{
guests = guestBusinessLayer.FindGuests(keyword);
}
List <GuestViewModel> mylist = new List <GuestViewModel>();
foreach (Guest gs in guests)
{
GuestViewModel guestViewModel = new GuestViewModel();
guestViewModel.Name = gs.Name;
guestViewModel.GuestId = gs.GuestId.ToString();
guestViewModel.ContactNo = gs.ContactNo;
guestViewModel.TableNo = gs.TableNo;
guestViewModel.Attendance = gs.Attendance;
mylist.Add(guestViewModel);
}
guestListViewModel.Guest = mylist;
return(Json(guestListViewModel.Guest, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdateAttd()
{
string attendanceId = Request.Form["Attendance"];
string GuestIdForAttd = Request.Form["GuestIdForAttd"];
string FromPage = Request.Form["FromPage"];
if (attendanceId == null)
{
attendanceId = "0";
}
char[] delimiterChars = { ' ', ',', '.', ':', '\t' };
string[] arrayGuestIdForAttd = GuestIdForAttd.Split(delimiterChars);
string[] arrayAttendance = attendanceId.Split(delimiterChars);
bool foundFlag = false;
GuestListViewModel guestListViewModel = new GuestListViewModel();
GuestBusinessLayer guestBusinessLayer = new GuestBusinessLayer();
if (attendanceId != "0")
{
for (int i = 0; i < arrayGuestIdForAttd.Length; i++)
{
foundFlag = false;
for (int j = 0; j < arrayAttendance.Length; j++)
{
if (arrayGuestIdForAttd[i] == arrayAttendance[j])
{
guestBusinessLayer.SetAttd(arrayGuestIdForAttd[i]);
foundFlag = true;
}
}
if (!foundFlag)
{
guestBusinessLayer.DelAttd(arrayGuestIdForAttd[i]);
}
}
}
else if (attendanceId == "0")
{
for (int i = 0; i < arrayGuestIdForAttd.Length; i++)
{
guestBusinessLayer.DelAttd(arrayGuestIdForAttd[i]);
}
}
Guest guests = new Guest();
List <GuestViewModel> mylist = new List <GuestViewModel>();
foreach (string s in arrayGuestIdForAttd)
{
GuestViewModel guestViewModel = new GuestViewModel();
guests = guestBusinessLayer.FindGuestsById(int.Parse(s));
guestViewModel.Name = guests.Name;
guestViewModel.GuestId = guests.GuestId.ToString();
guestViewModel.ContactNo = guests.ContactNo;
guestViewModel.TableNo = guests.TableNo;
guestViewModel.Attendance = guests.Attendance;
mylist.Add(guestViewModel);
}
guestListViewModel.Guest = mylist;
if (FromPage == "ManageGuestList")
{
return(View("ManageGuestList", guestListViewModel));
}
else
{
return(View("Index", guestListViewModel));
}
}
