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; }