protected void btnClockIn_Click(object sender, EventArgs e) { Employee emp = dde.Employees.Where(t => t.Emp_User_Name.ToUpper().Equals(Username.Text.ToUpper()) && t.Emp_Password.Equals(Password.Text)).FirstOrDefault(); if (emp != null) { TimeSpan span = TimeSpan.Parse("00:00:00.0000000"); Empworktime EmpChk = dde.Empworktimes.Where(t => t.Emp_ID == emp.Emp_ID && t.Clock_In != span && t.Clock_Out == span).ToList().FirstOrDefault(); if (EmpChk == null) { Empworktime ClockInTime = new Empworktime(); ClockInTime.Clock_In = DateTime.Now.TimeOfDay; ClockInTime.Emp_ID = emp.Emp_ID; ClockInTime.Work_Date = DateTime.Now; dde.Empworktimes.Add(ClockInTime); dde.SaveChanges(); lblError.Text = ""; } else { lblError.Text = "User has already clocked in."; lblError.Visible = true; } } else { lblError.Text = "Username or Password is incorrect."; lblError.Visible = true; } }
protected void btnOrder_Click(object sender, EventArgs e) { using (DowntownDeliEntity dde = new DowntownDeliEntity()) { List <Inventory> listofItems = new List <Inventory>(); foreach (ListViewDataItem item in lvOrderInventoryItems.Items) { CheckBox cbAddToOrder = (CheckBox)item.FindControl("cbAddToOrder"); if (cbAddToOrder.Checked) { Label lblItemID = (Label)item.FindControl("lblItemID"); int id = int.Parse(lblItemID.Text); Inventory invItem = dde.Inventories.Find(id); if (invItem != null) { listofItems.Add(invItem); } } } if (listofItems.Count > 0) { foreach (Inventory inv in listofItems) { Inventory_Order invOrder = new Inventory_Order(); invOrder.Item_ID = inv.Item_ID; invOrder.Vendor_ID = int.Parse(ddlVendors.SelectedValue); invOrder.Quantity = 50; invOrder.Total_Cost = (inv.Cost * 50) + ((inv.Cost * 50) * .0675M); invOrder.Purchase_Date = DateTime.Now; invOrder.Delivery_Date = DateTime.Now.AddDays(5); dde.Inventory_Order.Add(invOrder); Inventory invItem = dde.Inventories.Find(inv.Item_ID); invItem.Quantity += 50; dde.SaveChanges(); lvInventoryItems.DataSource = dde.Inventories.OrderBy(t => t.Item_Name).ToList(); lvInventoryItems.DataBind(); lvOrderInventoryItems.DataSource = dde.Inventories.OrderBy(t => t.Item_Name).Where(t => t.Quantity <= 25).ToList(); lvOrderInventoryItems.DataBind(); } Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "OpenModal('SuccessModal')", true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "OpenModal('FailureModal')", true); } } }
protected void btnAddNew_Click(object sender, EventArgs e) { using (DowntownDeliEntity dde = new DowntownDeliEntity()) { Inventory invItem = new Inventory(); invItem.Item_Name = tbItemName.Text; invItem.Quantity = int.Parse(tbNewQuantity.Text); invItem.Cost = decimal.Parse(tbCost.Text); invItem.Experation_Date = DateTime.Parse(ExpDateTimePickerInput.Value); dde.Inventories.Add(invItem); dde.SaveChanges(); lvInventoryItems.DataSource = dde.Inventories.OrderBy(t => t.Item_Name).ToList(); lvInventoryItems.DataBind(); ddlInventory.DataSource = dde.Inventories.OrderBy(t => t.Item_Name).ToList(); ddlInventory.DataBind(); } }
protected void btnUpdate_Click(object sender, EventArgs e) { using (DowntownDeliEntity dde = new DowntownDeliEntity()) { int item = int.Parse(ddlInventory.SelectedValue); int quantity = int.Parse(tbQuantity.Text); Inventory invItem = dde.Inventories.FirstOrDefault(a => a.Item_ID == item); if (invItem != null) { invItem.Quantity = quantity; dde.SaveChanges(); } lvInventoryItems.DataSource = dde.Inventories.OrderBy(t => t.Item_Name).ToList(); lvInventoryItems.DataBind(); ddlInventory.DataSource = dde.Inventories.OrderBy(t => t.Item_Name).ToList(); ddlInventory.DataBind(); } }
protected void lvInventoryItems_ItemCommand(object sender, ListViewCommandEventArgs e) { switch (e.CommandName) { case "DeleteCommand": using (DowntownDeliEntity dde = new DowntownDeliEntity()) { ListViewDataItem item = (ListViewDataItem)e.Item; Label lblItemID = (Label)item.FindControl("lblItemID"); int id = int.Parse(lblItemID.Text); Inventory invItem = dde.Inventories.Find(id); dde.Inventories.Remove(invItem); dde.SaveChanges(); lvInventoryItems.DataSource = dde.Inventories.OrderBy(t => t.Item_Name).ToList(); lvInventoryItems.DataBind(); } break; } }
protected void btnSubmitOrder_Click(object sender, EventArgs e) { if (ModifyOrder) { order = dde.Orders.Find(order.Order_ID); } bool valid = false; if (ddlPromos.SelectedItem.Value != "0") { long PromoID = long.Parse(ddlPromos.SelectedItem.Value); Promotion promo = dde.Promotions.Find(PromoID); if (promo != null) { if (promo.Discount_Type == "Percent Off") { if (promo.Discount != null) { order.Ord_Date = DateTime.Now; order.Price = ((order.Price + (order.Price * ((Decimal)promo.Discount / 100))) + (order.Price * 0.0675M)); if (!ModifyOrder) { dde.Orders.Add(order); } dde.SaveChanges(); valid = true; } } else if (promo.Discount_Type == "Cash Off") { if (promo.Discount != null) { order.Ord_Date = DateTime.Now; order.Price = ((order.Price + (Decimal)promo.Discount) + (order.Price * 0.0675M)); if (!ModifyOrder) { dde.Orders.Add(order); } dde.SaveChanges(); valid = true; } } else { Product_Order cheapestProd = order.Product_Order.Where(t => t.Product.Price > 0).OrderBy(t => t.Product.Price).FirstOrDefault(); if (cheapestProd != null) { order.Ord_Date = DateTime.Now; order.Price = ((order.Price - cheapestProd.Product.Price) + (order.Price * 0.0675M)); if (!ModifyOrder) { dde.Orders.Add(order); } dde.SaveChanges(); valid = true; } } } } else { order.Ord_Date = DateTime.Now; order.Price = (order.Price + (order.Price * 0.0675M)); if (!ModifyOrder) { dde.Orders.Add(order); } dde.SaveChanges(); valid = true; } if (valid) { if (!ModifyOrder) { foreach (Product_Order prodOrder in order.Product_Order) { Product prods = dde.Products.Find(prodOrder.Product_ID); foreach (Product_Inventory prodInv in prods.Product_Inventory) { Inventory inv = dde.Inventories.Find(prodInv.Item_ID); inv.Quantity -= 1; dde.SaveChanges(); } } } else { foreach (Product_Order prodOrder in deletedProducts) { Product prods = dde.Products.Find(prodOrder.Product_ID); foreach (Product_Inventory prodInv in prods.Product_Inventory) { Inventory inv = dde.Inventories.Where(t => t.Item_ID == prodInv.Item_ID).Single(); inv.Quantity += 1; dde.SaveChanges(); } } } submitSide.Visible = false; ddlProducts.ClearSelection(); ddlPromos.ClearSelection(); lvOrderItems.DataSource = null; lvOrderItems.DataBind(); tbQuantity.Text = ""; txtCustomer.Text = ""; lblCustomer.Text = ""; order = new Order(); ModifyOrder = false; valid = true; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "OpenModal('SuccessModal')", true); } }
protected void btnUpdateMenuItem_Click(object sender, EventArgs e) { long id = long.Parse(ddlMenuItemProducts.SelectedValue); prod = dde.Products.Find(id); prod.Price = decimal.Parse(txtMenuItemPrice.Text); dde.SaveChanges(); List <Inventory> listofItems = new List <Inventory>(); foreach (ListViewDataItem item in lvInventoryItems.Items) { CheckBox cbProductInvItem = (CheckBox)item.FindControl("cbProductInvItem"); if (cbProductInvItem.Checked) { Label lblItemID = (Label)item.FindControl("lblItemID"); int id2 = int.Parse(lblItemID.Text); Inventory invItem = dde.Inventories.Find(id2); if (invItem != null) { listofItems.Add(invItem); } } } foreach (Inventory inv in listofItems) { Product_Inventory prodInv = dde.Product_Inventory.Where(t => t.Item_ID == inv.Item_ID && prod.Product_ID == t.Product_ID).ToList().FirstOrDefault(); if (prodInv == null) { Product_Inventory NewprodInv = new Product_Inventory(); NewprodInv.Item_ID = inv.Item_ID; NewprodInv.Product_ID = prod.Product_ID; dde.Product_Inventory.Add(NewprodInv); dde.SaveChanges(); } } foreach (Product_Inventory prodInv in prod.Product_Inventory.ToList()) { if (!listofItems.Contains(prodInv.Inventory)) { Product_Inventory prodInv2 = dde.Product_Inventory.Find(prodInv.Prod_Inv_ID); dde.Product_Inventory.Remove(prodInv2); dde.SaveChanges(); } } prod = new Product(); }