private static void LoadTables(Server server, DataTable openTables, sqlController sqc)
{
foreach (DataRow r in openTables.Rows)
{
server.EnterExistingTable((int)r["TableNumber"], (int)r["NumGuests"]);
Table table = server.getTable((int)r["TableNumber"]);
table.ID = (int)r["ID"];
int billsCount = sqc.getBillCount(table);
while (billsCount > 0)
{
table.AddNewList();
billsCount -= 1;
}
DataTable billDT = sqc.getBills(table);
int count = billDT.Rows.Count;
List <Bill> bills = table.GetBills();
foreach (Bill bill in bills)
{
var query = from mRow in billDT.AsEnumerable()
where mRow.Field <int>("CheckNum") == bill.CheckNum
select mRow;
DataView njview = query.AsDataView();
bill.ID = Int32.Parse(njview[0]["ID"].ToString());
bill.Payment = Decimal.Parse(njview[0]["Payment"].ToString());
}
}
}
public void updateBackWaitTips(string shift, decimal hours)
{
restaurant = (Restaurant)Session["Restaurant"];
decimal tips = 0.00M;
if (shift == Shift.Lunch.ToString())
{
tips = restaurant.LunchSATips;
}
else
{
tips = restaurant.DinnerSATips;
}
sqc = new sqlController();
try
{
var tip = (tips / hours);
sqc.UpdateBackWaitTips(shift, tip, GetDate());
}
catch (Exception ex)
{
Logger.Log(ex);
}
finally
{
sqc = null;
}
}
protected bool Validate(string userid, string password)
{
sqlController sqC = new sqlController();
DataTable dt = sqC.GetCredentials(userid);
if (dt.Rows.Count > 0)
{
string passwordHash = dt.Rows[0]["password"].ToString();
string userPassword = Hash.EncodePasswordToBase64(password.TrimStart().TrimEnd());
if (dt.Rows[0]["userid"].ToString().Trim() == userid && passwordHash == userPassword)
{
User user = new User();
user.ID = (int)dt.Rows[0]["id"];
user.UserID = dt.Rows[0]["userid"].ToString().Trim();
user.Name = dt.Rows[0]["name"].ToString().Trim();
user.IsAdmin = (int)dt.Rows[0]["isadmin"] == 1;
Session["User"] = user;
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public void AddCount()
{
sqlController sqc = new sqlController();
sqc.InsertVisit(this);
sqc = null;
}
public void Save()
{
SentDate = DateTime.Now;
sqlController sqc = new sqlController();
sqc.InsertMessage(this);
sqc = null;
}
public Order(int prod_id, string name, decimal price, int table_number)
{
this.product_id = prod_id;
this.name = name;
this.price = price;
Status = OrderStatus.UnOrdered;
this.tableNum = table_number;
//this.employee_id = employee_id;
sqC = new sqlController();
}
public void SaveBill()
{
sqlController sqC = new sqlController();
this.id = sqC.insertBill(this);
foreach (Order order in Orders)
{
order.BillID = this.ID;
}
}
protected void popStaffList(EmployeeRoles role)
{
sqlController sqc = new sqlController();
lstStaff.DataSource = sqc.GetNamesInJob(role.ToString());
lstStaff.DataTextField = "Name";
lstStaff.DataValueField = "Name";
lstStaff.DataBind();
sqc = null;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null)
{
Response.Redirect("~/login.aspx");
}
server = (Server)Session["Employee"];
SQC = new sqlController();
DataTable dt = SQC.GetTotals(server);
if (dt != null)
{
if (dt.Rows[0]["Appetizer"].ToString() != "")
{
lblAppTotal.Text = String.Format("{0:C}", dt.Rows[0]["Appetizer"]);
}
if (dt.Rows[0]["Soup"].ToString() != "")
{
lblSoupTotal.Text = String.Format("{0:C}", dt.Rows[0]["Soup"]);
}
if (dt.Rows[0]["Beverage"].ToString() != "")
{
lblBeverageTotal.Text = String.Format("{0:C}", dt.Rows[0]["Beverage"]);
}
if (dt.Rows[0]["Sandwich"].ToString() != "")
{
lblSandwichTotal.Text = String.Format("{0:C}", dt.Rows[0]["Sandwich"]);
}
if (dt.Rows[0]["Salad"].ToString() != "")
{
lblSaladTotal.Text = String.Format("{0:C}", dt.Rows[0]["Salad"]);
}
if (dt.Rows[0]["Entree"].ToString() != "")
{
lblEntreeTotal.Text = String.Format("{0:C}", dt.Rows[0]["Entree"]);
}
if (dt.Rows[0]["Beer"].ToString() != "")
{
lblBeerTotal.Text = String.Format("{0:C}", dt.Rows[0]["Beer"]);
}
if (dt.Rows[0]["Wine"].ToString() != "")
{
lblWineTotal.Text = String.Format("{0:C}", dt.Rows[0]["Wine"]);
}
if (dt.Rows[0]["Dessert"].ToString() != "")
{
lblDessertTotal.Text = String.Format("{0:C}", dt.Rows[0]["Dessert"]);
}
lblSalesTotal.Text = String.Format("{0:C}", Sum(dt));
}
}
private static void LoadOrders(Server server, sqlController sqc)
{
DataTable orders = sqc.getOpenTableOrders(server);
foreach (DataRow row in orders.Rows)
{
Order order = new Order((int)row["ProductID"], row["Name"].ToString(), (decimal)row["Price"], (int)row["TableNumber"]);
order.ServerID = Int32.Parse(server.ID);
order.Status = (OrderStatus)row["Status"];
order.ID = (int)row["OrderID"];
server.TakeOrder(order, (int)row["CheckNum"]);
}
}
public void DeleteMessages()
{
sqlController sqc = new sqlController();
foreach (Message message in Messages)
{
if (!message.IsActive)
{
sqc.UpdateMessageToInactive(message);
}
}
sqc = null;
}
public void DeleteShift()
{
string strShift = "";
string detailsShift = lblShiftDetailsShift.Text.Trim();
string Name = lblShftDetailsName.Text.Trim();
string Job = lblShiftDetailsJob.Text.Trim();
string Date = shftDate.Text.Trim();
string fullStartDate = Date + "," + detailsShift;
string[] strt = fullStartDate.Split('-');
DateTime startTime = DateTime.Parse(strt[0]);
TimeSpan four = new TimeSpan(16, 0, 0);
TimeSpan shiftStart = startTime.TimeOfDay;
if (shiftStart < four)
{
strShift = "Lunch";
}
else
{
strShift = "Dinner";
}
//Begin Delete Values
Shift shift = new Shift();
shift.Name = Name;
shift.Job = Job;
shift.Start = startTime;
shift.ShiftName = strShift;
sqlController sqc = new sqlController();
try
{
if (sqc.DeleteShift(shift) > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showSuccessMessage", "showSuccessMessage();", true);
lblMessage.Text = "Shift was deleted successfully.";
GetShifts();
}
}
catch (Exception ex)
{
Logger.Log(ex);
ScriptManager.RegisterStartupScript(this, GetType(), "showErrorMessage", "showErrorMessage();", true);
}
sqc = null;
//scheduleDetails.Hide();
ScriptManager.RegisterStartupScript(this, GetType(), "Close", "$('#deleteClose').click();", true);
}
private void LoadMessages()
{
sqlController sqc = new sqlController();
var results = sqc.GetMessages();
Messages.Clear();
foreach (DataRow row in results.Rows)
{
Message message = new Message(row["name"].ToString(), row["email_address"].ToString(), row["message"].ToString());
message.IsActive = (int)row["isactive"] == 1;
message.SentDate = (DateTime)row["sentdate"];
message.ID = (int)row["id"];
Messages.Add(message);
}
}
public DataTable populateBWGrid(string shift)
{
sqc = new sqlController();
try
{
return(sqc.GetBackwaitData(shift, GetDate()));
}
catch (Exception ex)
{
Logger.Log(ex);
return(null);
}
finally
{
sqc = null;
}
}
public void GetShifts()
{
DateTime[] range = GetDay(Calendar1.SelectedDate);
sqlController sqc = new sqlController();
List <SqlParameter> sqlParams = new List <SqlParameter>();
sqlParams.Add(new SqlParameter("@Start", range[0]));
sqlParams.Add(new SqlParameter("@End", range[1]));
DataTable table = sqc.GetShifts(sqlParams);
sqlParams.Clear();
DataTable empTable = sqc.GetScheduleNames();
foreach (DataRow row in empTable.Rows)
{
var s = new Employee(row["Name"].ToString());
s.Title = row["Job"].ToString();
if (!empList.Any(x => x.Name == row["Name"].ToString()))
{
empList.Add(s);
}
fullList.Add(s);
}
lstShifts = new List <Shift>();
foreach (DataRow row in table.Rows)
{
Employee Employee = empList.First(x => x.Name == row["Name"].ToString());
Shift shift = new Shift();
shift.ID = (int)row["ID"];
shift.Name = row["Name"].ToString().Trim();
shift.Start = (DateTime)row["Start_Time"];
shift.End = (DateTime)row["End_Time"];
shift.Job = row["Job"].ToString().Trim();
//Employee.Title = row["Job"].ToString().Trim();
shift.ShiftName = row["Shift"].ToString().Trim();
Employee.Schedule.Shifts.Add(shift);
lstShifts.Add(shift);
}
Session["Shifts"] = null;
Session["Schedule"] = null;
Session["Full"] = null;
Session["Shifts"] = lstShifts;
Session["Schedule"] = empList;
Session["Full"] = fullList;
Get_ScheduleNames();
}
public decimal sumBackWaitHours(string shift)
{
sqc = new sqlController();
try
{
return(sqc.GetBackWaitHoursSum(shift, GetDate()));
}
catch (Exception ex)
{
Logger.Log(ex);
return(0.00M);
}
finally
{
sqc = null;
}
}
public bool areThereBackWaitHours(string shift)
{
sqc = new sqlController();
try
{
return(sqc.GetBackWaitHours(shift, GetDate()) > 0);
}
catch (Exception ex)
{
Logger.Log(ex);
return(false);
}
finally
{
sqc = null;
}
}
protected void popBWList()
{
sqc = new sqlController();
try
{
txtBackName.DataSource = sqc.GetNamesInJob("Backwaiter");
txtBackName.DataTextField = "Name";
txtBackName.DataValueField = "Name";
txtBackName.DataBind();
}
catch (Exception)
{
}
finally
{
sqc = null;
}
}
protected void popStaffList()
{
sqc = new sqlController();
try
{
txtName.DataSource = sqc.GetServingStaff();
txtName.DataTextField = "Name";
txtName.DataValueField = "Name";
txtName.DataBind();
}
catch (Exception ex)
{
}
finally
{
sqc = null;
}
}
public DataTable populateServerGrid(string shift)
{
sqc = new sqlController();
try
{
var date = GetDate();
return(sqc.GetServerData(shift, GetDate()));
}
catch (Exception ex)
{
Logger.Log(ex);
return(null);
}
finally
{
sqc = null;
}
}
public Table(int numberGuests, int tableNumber, int employee, bool existing)
{
this.numberGuests = numberGuests;
this.tableNumber = tableNumber;
Status = TableStatus.Open;
this.employee_id = employee;
sqC = new sqlController();
bills = new List <Bill>();
if (!existing)
{
Save();
}
AddNewList();
if (!existing)
{
bills[0].SaveBill();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (HttpContext.Current.Session["Employee"] == null)
{
Response.Redirect("~/login.aspx", false);
Context.ApplicationInstance.CompleteRequest();
}
List <Order> updatedOrders = (List <Order>)HttpContext.Current.Session["UpdatedOrders"];
if (updatedOrders != null)
{
sqC = new sqlController();
foreach (Order order in updatedOrders)
{
sqC.updateOrderBillID(order);
}
sqC = null;
}
server = (Server)HttpContext.Current.Session["Employee"];
table = server.getTable(Int32.Parse(HttpContext.Current.Session["TableNum"].ToString()));
List <Bill> bills = table.GetBills();
if (updatedOrders != null)
{
foreach (Bill bill in bills)
{
if (bill.ID == 0 && bill.Orders.Count > 0)
{
bill.SaveBill();
}
bill.CalculateTotal();
bill.Update();
}
}
RemoveEmptyBills(bills);
Session["Employee"] = server;
Response.Redirect("~/Sales_App/tblDetails.aspx?Table=" + Int32.Parse(table.TableNumber.ToString()), false);
Context.ApplicationInstance.CompleteRequest();
}
public void insertBackWaitData(Backwaiter backwait)
{
sqc = new sqlController();
try
{
if (sqc.InsertBackWait(backwait, GetDate()) > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showSuccessMessage", "showSuccessMessage();", true);
}
backwait = null;
}
catch (Exception ex)
{
Logger.Log(ex);
ScriptManager.RegisterStartupScript(this, GetType(), "showErrorMessage", "showErrorMessage();", true);
}
finally
{
sqc = null;
}
}
public static void LoadObjects(Employee employee, DataTable openTables)
{
try
{
sqlController sqc = new sqlController();
if (employee is Server)
{
LoadTables((Server)employee, openTables, sqc);
LoadOrders((Server)employee, sqc);
}
else if (employee is Manager)
{
LoadEmployees((Manager)employee, openTables, sqc);
}
}
catch (Exception ex)
{
Logger.Log(ex);
}
}
public void insertServerData(Server server)
{
sqc = new sqlController();
try
{
if (sqc.InsertServer(server, GetDate()) > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showSuccessMessage", "showSuccessMessage();", true);
}
server = null;
}
catch (Exception ex)
{
Logger.Log(ex);
ScriptManager.RegisterStartupScript(this, GetType(), "showErrorMessage", "showErrorMessage();", true);
}
finally
{
sqc = null;
txtName.Focus();
}
}
public void Update()
{
sqlController sqC = new sqlController();
sqC.updateBill(this);
}
private static void LoadEmployees(Manager manager, DataTable openTables, sqlController sqc)
{
//load each employee and tables and orders for employee
}
private void insert_schedule(string staffName, string strJob, DateTime strtTime, DateTime endTime, string strShift)
{
Shift shift = new Shift();
shift.Name = staffName;
shift.Job = strJob;
shift.ShiftName = strShift;
shift.Start = strtTime;
shift.End = endTime;
shift.PostDate = DateTime.Now;
sqlController sqc = new sqlController();
try
{
if (sqc.Check_Shift(shift.Name, shift.Start, shift.ShiftName) > 0)
{
lblStrtTimeEdit.Text = "*Shift is unavailable.";
lblStrtTimeEdit.ForeColor = System.Drawing.Color.Red;
lstStartHours.BorderStyle = BorderStyle.Dotted;
lstStartHours.BorderColor = System.Drawing.Color.Red;
lstStartMinutes.BorderStyle = BorderStyle.Dotted;
lstStartMinutes.BorderColor = System.Drawing.Color.Red;
return;
}
if (sqc.InsertShift(shift) > 0)
{
ScriptManager.RegisterStartupScript(this, GetType(), "showSuccessMessage", "showSuccessMessage();", true);
lblMessage.Text = "Shift was added successfully.";
lstStaffType.Text = " ";
lstStaff.Items.Clear();
lstShift.Text = "Lunch";
lstStartMinutes.Text = " ";
lstStartHours.Text = " ";
lstEndHours.Text = " ";
lstEndMinutes.Text = " ";
lblStrtTimeEdit.Text = "";
lblStaffTypeEdit.Text = "";
lblStaffEdit.Text = "";
lblShiftEdit.Text = "";
lstStaffType.BorderStyle = BorderStyle.NotSet;
lstStartMinutes.BorderStyle = BorderStyle.NotSet;
lstStartHours.BorderStyle = BorderStyle.NotSet;
lstEndHours.BorderStyle = BorderStyle.NotSet;
lstEndMinutes.BorderStyle = BorderStyle.NotSet;
lstStaffType.BorderColor = System.Drawing.Color.Empty;
lstStartMinutes.BorderColor = System.Drawing.Color.Empty;
lstStartHours.BorderColor = System.Drawing.Color.Empty;
lstEndHours.BorderColor = System.Drawing.Color.Empty;
lstEndMinutes.BorderColor = System.Drawing.Color.Empty;
lstStartHours.DataSource = strtLunchHours;
lstStartHours.DataBind();
lstEndHours.DataSource = strtLunchHours;
lstEndHours.DataBind();
GetShifts();
}
}
catch (Exception ex)
{
Logger.Log(ex);
ScriptManager.RegisterStartupScript(this, GetType(), "showErrorMessage", "showErrorMessage();", true);
}
sqc = null;
}
