public void UpdateFileDiscrepancies(List <WCF_FileDiscrepancy> fileDiscrepancies, string username) { Inventory_Adjustment invAdjustmentSup = new Inventory_Adjustment(); invAdjustmentSup.deleted = "N"; invAdjustmentSup.clerk_user = username; invAdjustmentSup.status = "Pending"; invAdjustmentSup.date = DateTime.Today; invAdjustmentSup.status_date = DateTime.Today; Inventory_Adjustment invAdjustmentMan = new Inventory_Adjustment(); invAdjustmentMan.deleted = "N"; invAdjustmentMan.clerk_user = username; invAdjustmentMan.status = "Pending"; invAdjustmentMan.date = DateTime.Today; invAdjustmentMan.status_date = DateTime.Today; foreach (WCF_FileDiscrepancy i in fileDiscrepancies) { int adjusted = int.Parse(i.adjustedQty); Stock_Inventory inventory = context.Stock_Inventory.Where(x => x.item_code == i.itemCode).ToList().First(); inventory.current_qty += adjusted; MonthlyCheckModel itemModel = new MonthlyCheckModel(inventory); double cost = Math.Abs(adjusted) * itemModel.AveragePrice; Adjustment_Details adjDetails = new Adjustment_Details(); adjDetails.deleted = "N"; adjDetails.item_code = inventory.item_code; adjDetails.quantity_adjusted = adjusted; adjDetails.reason = i.reason; if (cost < 250) { invAdjustmentSup.Adjustment_Details.Add(adjDetails); } if (cost >= 250) { invAdjustmentMan.Adjustment_Details.Add(adjDetails); } context.Adjustment_Details.Add(adjDetails); } if (invAdjustmentSup.Adjustment_Details.Count != 0) { context.Inventory_Adjustment.Add(invAdjustmentSup); context.SaveChanges(); } if (invAdjustmentMan.Adjustment_Details.Count != 0) { context.Inventory_Adjustment.Add(invAdjustmentMan); context.SaveChanges(); } }
public void UpdateMonthlyCheck(List <MonthlyCheckModel> list, string username) { Inventory_Adjustment inventoryAdjMan = new Inventory_Adjustment(); inventoryAdjMan.clerk_user = username; inventoryAdjMan.deleted = "N"; inventoryAdjMan.status = "Pending"; inventoryAdjMan.date = DateTime.Today; inventoryAdjMan.status_date = DateTime.Today; Inventory_Adjustment inventoryAdjSup = new Inventory_Adjustment(); inventoryAdjMan.clerk_user = username; inventoryAdjMan.deleted = "N"; inventoryAdjMan.status = "Pending"; inventoryAdjMan.date = DateTime.Today; inventoryAdjMan.status_date = DateTime.Today; foreach (MonthlyCheckModel i in list) { int adjusted = i.CurrentQuantity - i.ActualQuantity; Stock_Inventory inventory = context.Stock_Inventory.Where(x => x.item_code == i.ItemCode).ToList().First(); MonthlyCheckModel itemModel = new MonthlyCheckModel(inventory); double cost = Math.Abs(adjusted) * itemModel.AveragePrice; Adjustment_Details adjustmentDetail = new Adjustment_Details(); adjustmentDetail.item_code = i.ItemCode; adjustmentDetail.quantity_adjusted = adjusted; adjustmentDetail.reason = i.Reason; adjustmentDetail.deleted = "N"; if (cost >= 250) { inventoryAdjMan.Adjustment_Details.Add(adjustmentDetail); } else if (cost < 250) { inventoryAdjSup.Adjustment_Details.Add(adjustmentDetail); } context.Adjustment_Details.Add(adjustmentDetail); } if (inventoryAdjMan.Adjustment_Details.Count != 0) { context.Inventory_Adjustment.Add(inventoryAdjMan); context.SaveChanges(); } if (inventoryAdjSup.Adjustment_Details.Count != 0) { context.Inventory_Adjustment.Add(inventoryAdjSup); context.SaveChanges(); } }
public List <MonthlyCheckModel> GetAllMonthlyCheck() { List <MonthlyCheckModel> modelList = new List <MonthlyCheckModel>(); List <Stock_Inventory> inventoryList = context.Stock_Inventory.Where(x => x.deleted == "N").ToList(); foreach (Stock_Inventory i in inventoryList) { MonthlyCheckModel model = new MonthlyCheckModel(i); modelList.Add(model); } return(modelList); }
protected void Page_Load(object sender, EventArgs e) { context = new SSISEntities(); if (!IsPostBack) { checkDone = CheckIfMonthlyDone(); List <MonthlyCheckModel> itemList = (List <MonthlyCheckModel>)Session["Monthly"]; if (itemList == null) { itemList = new List <MonthlyCheckModel>(); List <Stock_Inventory> stockList = context.Stock_Inventory.Where(x => x.deleted == "N").ToList(); foreach (Stock_Inventory i in stockList) { MonthlyCheckModel item = new MonthlyCheckModel(i); itemList.Add(item); } Session["Monthly"] = itemList; } MonthlyCheckGV.DataSource = itemList; MonthlyCheckGV.DataBind(); UserModel user = new UserModel(HttpContext.Current.User.Identity.Name); UserModel depthead = user.FindDelegateOrDeptHead(); //CheckLabel.Text = depthead.Username; //today = DateTime.Today; //DateTB.Text = today.Date.ToString("dd/MM/yyyy"); itemList = (List <MonthlyCheckModel>)Session["Monthly"]; //Session["Monthly"] = itemList; MonthlyCheckGV.DataSource = itemList; MonthlyCheckGV.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { context = new SSISEntities(); List <MonthlyCheckModel> modelList; Dictionary <string, int> SessionInfo; if (!IsPostBack) { modelList = new List <MonthlyCheckModel>(); SessionInfo = (Dictionary <string, int>)Session[PUBLIC_SESSION_DISCREPANCY_DICT]; // Early quit if no session if (SessionInfo == null) { lblWarning.Text = "No discrepancies to be filed."; ConfirmBtn.Visible = false; return; } lblWarning.Visible = false; foreach (KeyValuePair <string, int> pair in SessionInfo) { string itemCode = pair.Key; int qtyAdjusted = pair.Value; Stock_Inventory inventory = context.Stock_Inventory.Where(x => x.item_code == itemCode).ToList().First(); MonthlyCheckModel model = new MonthlyCheckModel(inventory); model.ActualQuantity = model.CurrentQuantity - qtyAdjusted; modelList.Add(model); } Session["DisDetail"] = modelList; FileDiscrepencyGV.DataSource = modelList; FileDiscrepencyGV.DataBind(); } }
public bool UpdateMonthlyCheck(List <WCF_MonthlyCheck> monthlyChecks, string username) { Inventory_Adjustment invAdjustmentSup = new Inventory_Adjustment(); invAdjustmentSup.deleted = "N"; invAdjustmentSup.clerk_user = username; invAdjustmentSup.status = "Pending"; invAdjustmentSup.date = DateTime.Today; invAdjustmentSup.status_date = DateTime.Today; Inventory_Adjustment invAdjustmentMan = new Inventory_Adjustment(); invAdjustmentMan.deleted = "N"; invAdjustmentMan.clerk_user = username; invAdjustmentMan.status = "Pending"; invAdjustmentMan.date = DateTime.Today; invAdjustmentMan.status_date = DateTime.Today; foreach (WCF_MonthlyCheck i in monthlyChecks) { int actual = int.Parse(i.actualQuantity); int current = int.Parse(i.CurrentQuantity); int adjusted = current - actual; if (adjusted == 0) { continue; } Stock_Inventory inventory = context.Stock_Inventory.Where(x => x.item_code == i.ItemCode).ToList().First(); inventory.current_qty = actual; MonthlyCheckModel itemModel = new MonthlyCheckModel(inventory); double cost = Math.Abs(adjusted) * itemModel.AveragePrice; Adjustment_Details adjDetails = new Adjustment_Details(); adjDetails.deleted = "N"; adjDetails.item_code = i.ItemCode; adjDetails.quantity_adjusted = adjusted; adjDetails.reason = i.Reason; if (cost < 250) { invAdjustmentSup.Adjustment_Details.Add(adjDetails); } if (cost >= 250) { invAdjustmentMan.Adjustment_Details.Add(adjDetails); } context.Adjustment_Details.Add(adjDetails); } if (invAdjustmentSup.Adjustment_Details.Count != 0) { context.Inventory_Adjustment.Add(invAdjustmentSup); context.SaveChanges(); } if (invAdjustmentMan.Adjustment_Details.Count != 0) { context.Inventory_Adjustment.Add(invAdjustmentMan); context.SaveChanges(); } if (invAdjustmentSup.Adjustment_Details.Count != 0 || invAdjustmentMan.Adjustment_Details.Count != 0) { return(true); } else { return(false); } }