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