private static int?GetTotalPendingAdjustmentQtyForStock(string itemNo, List <AdjustmentVoucher> aVList) { int? qty = 0; LussisEntities context = new LussisEntities(); // If no Pending Vouchers found if (aVList.Count == 0) { // Return 0 return(qty); } else { // For each Pending Voucher for (int i = 0; i < aVList.Count; i++) { List <AdjustmentVoucherDetail> aVDList = aVList[i].AdjustmentVoucherDetails.ToList <AdjustmentVoucherDetail>(); // For each VoucherDetail for (int j = 0; j < aVDList.Count; j++) { // Add to Qty if itemNo matches AdjustmentVoucherDetail aVD = aVDList[j]; if (aVD.ItemNo.Equals(itemNo)) { qty += aVD.Qty; } } } return(qty); } }
public static List <OrderItem> GetAutoGeneratedOrderList() { // Create empty OrderList List <OrderItem> orderList = new List <OrderItem>(); // Get all Stocks List <StationeryCatalogue> allStockList = GetAllStocks(); // Get Pending Vouchers List <AdjustmentVoucher> aVList = new LussisEntities().AdjustmentVouchers.Where(x => x.Status.Equals("Pending")).ToList <AdjustmentVoucher>(); // Get Pending PO List <PurchaseOrder> pOList = new LussisEntities().PurchaseOrders.Where(x => x.Status.Equals("Pending")).ToList <PurchaseOrder>(); // For each Stock for (int i = 0; i < allStockList.Count; i++) { StationeryCatalogue stock = allStockList[i]; // Get OrderQty int?orderQty = GetOrderQty(stock.ItemNo, aVList, pOList); // If OrderQty > 0, create OrderItem if (orderQty > 0) { OrderItem orderItem = new OrderItem(stock); orderItem.OrderQtyList[0] = orderQty; orderList.Add(orderItem); } } return(orderList); }
public static List <AdjustmentVoucherDetail> GetAVDetails(int aVNo) { LussisEntities context = new LussisEntities(); List <AdjustmentVoucherDetail> result = context.AdjustmentVoucherDetails.Where(x => x.AvNo == aVNo).ToList <AdjustmentVoucherDetail>(); return(result); }
public static void AddOrder(List <OrderItem> orderList, string itemNo) { // Get Stock StationeryCatalogue stock = GetStock(itemNo); // Get Pending Vouchers List <AdjustmentVoucher> aVList = new LussisEntities().AdjustmentVouchers.Where(x => x.Status.Equals("Pending")).ToList <AdjustmentVoucher>(); // Get Pending PO List <PurchaseOrder> pOList = new LussisEntities().PurchaseOrders.Where(x => x.Status.Equals("Pending")).ToList <PurchaseOrder>(); // Create orderItem OrderItem orderItem = new OrderItem(stock); int? orderQty = GetOrderQty(itemNo, aVList, pOList); if (orderQty > 0) { orderItem.OrderQtyList[0] = orderQty; } else { orderItem.OrderQtyList[0] = stock.ReorderQty; } // Add to orderList orderList.Add(orderItem); }
public static void IncreaseStockFromSupplier(String itemNo, int quantity, String supplierCode) { LussisEntities context = new LussisEntities(); // Get Entities StationeryCatalogue stationeryItem = context.StationeryCatalogues.Where(item => item.ItemNo.Equals(itemNo)).FirstOrDefault(); Supplier supplier = context.Suppliers.Where(supp => supp.SupplierCode.Equals(supplierCode)).FirstOrDefault(); StockTxnDetail detail = new StockTxnDetail() { AdjustQty = quantity, Date = DateTime.Today, ItemNo = itemNo, Remarks = "Supplied by " + supplierCode, }; // If entities are found, update database if (stationeryItem != null && supplier != null) { detail.RecordedQty = stationeryItem.CurrentQty + detail.AdjustQty; stationeryItem.CurrentQty = detail.RecordedQty; context.StockTxnDetails.Add(detail); context.SaveChanges(); } }
protected void Page_Load(object sender, EventArgs e) { LussisEntities context = new LussisEntities(); int SNO = (Convert.ToInt16(Request["SNO"]) - 1); int SNOforSupplier = SNO + 1; var query = ViewReorderReportController.checkForPO(SNO); if (query != null) { var dateQuery = query.DateIssued; Label2.Text = "Reorder Report as of"; Label3.Text = dateQuery.Value.ToString("MMM yyyy"); var supplierSelected = query.SupplierCode; var reOrderReportDetails = ViewReorderReportController.showReorderReportDetails(SNO, supplierSelected); ReorderReportDetailsGridView.DataSource = reOrderReportDetails; ReorderReportDetailsGridView.DataBind(); } else { DateTime currentMthYear = DateTime.Now.AddMonths(-SNO); Label2.Text = "There is no Reorder Report for the month of"; Label3.Text = currentMthYear.ToString("MMM yyyy"); } }
private static int?GetTotalPendingPurchaseQtyForStock(string itemNo, List <PurchaseOrder> pOList) { int? qty = 0; LussisEntities context = new LussisEntities(); // If no Pending PO if (pOList.Count == 0) { // Return 0 return(qty); } else { // For each Pending PO for (int i = 0; i < pOList.Count; i++) { List <PurchaseOrderDetail> pODList = pOList[i].PurchaseOrderDetails.ToList <PurchaseOrderDetail>(); // For each PODetail for (int j = 0; j < pODList.Count; j++) { // Add to Qty if itemNo matches PurchaseOrderDetail pOD = pODList[j]; if (pOD.ItemNo.Equals(itemNo)) { qty += pOD.Qty; } } } return(qty); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //populate DeptListBox LussisEntities context = new LussisEntities(); var populateDeptListBox = context.Departments.Select(x => x.DeptName).ToList(); DeptListBox.DataSource = populateDeptListBox; DeptListBox.DataBind(); //populate ItemsDDL List <String> itemsList = new List <String>(); itemsList = context.StationeryCatalogues.Select(x => x.Description).ToList(); ItemsDDL.DataSource = itemsList; ItemsDDL.DataBind(); //allow user to choose the 1st day of the month even if 36month ago the cut // off was eg: 4th var minDate = DateTime.Now.AddMonths(-36); var firstDayOfMonth = new DateTime(minDate.Year, minDate.Month, 1); //set the textbox date FromDate.Attributes["min"] = firstDayOfMonth.ToString("yyyy-MM-dd"); FromDate.Attributes["max"] = DateTime.Now.ToString("yyyy-MM-dd"); EndDate.Attributes["min"] = firstDayOfMonth.ToString("yyyy-MM-dd"); EndDate.Attributes["max"] = DateTime.Now.ToString("yyyy-MM-dd"); } }
public static void UpdateReceivedQty(int dNo, string itemNo, int qty) { LussisEntities context = new LussisEntities(); DisbursementDetail dDetail = context.DisbursementDetails.Where(x => x.DisbursementNo == dNo && x.ItemNo.Equals(itemNo)).FirstOrDefault(); dDetail.Received = qty; context.SaveChanges(); }
public static void UpdatePODQty(int pONo, string itemNo, int qty) { LussisEntities context = new LussisEntities(); PurchaseOrderDetail pOD = context.PurchaseOrderDetails.Where(x => x.PONo == pONo && x.ItemNo.Equals(itemNo)).FirstOrDefault(); pOD.Qty = qty; context.SaveChanges(); }
public static void DeletePOD(int pONo, string itemNo) { LussisEntities context = new LussisEntities(); PurchaseOrderDetail pOD = context.PurchaseOrderDetails.Where(x => x.PONo == pONo && x.ItemNo.Equals(itemNo)).FirstOrDefault(); context.PurchaseOrderDetails.Remove(pOD); context.SaveChanges(); }
public static List <PurchaseOrderDetail> GetPurchaseOrderDetailsOf(int purchaseOrderNumber) { List <PurchaseOrderDetail> poDetails = new List <PurchaseOrderDetail>(); LussisEntities context = new LussisEntities(); poDetails = context.PurchaseOrderDetails.Where(po => po.PONo == purchaseOrderNumber).ToList(); return(poDetails); }
public static void DeleteAVD(int aVNo, string itemNo) { LussisEntities context = new LussisEntities(); AdjustmentVoucherDetail aVD = context.AdjustmentVoucherDetails.Where(x => x.AvNo == aVNo && x.ItemNo.Equals(itemNo)).FirstOrDefault(); context.AdjustmentVoucherDetails.Remove(aVD); context.SaveChanges(); }
public static void UpdateAVDetailQty(int aVNo, string itemNo, int qty, string reason) { LussisEntities context = new LussisEntities(); AdjustmentVoucherDetail aVD = context.AdjustmentVoucherDetails.Where(x => x.AvNo == aVNo && x.ItemNo.Equals(itemNo)).FirstOrDefault(); aVD.Qty = qty; aVD.Reason = reason; context.SaveChanges(); }
public static void SubmitAdjustmentVoucher(string itemNo, DateTime dateIssued, int qty, string reason, int issueEmpNo) { AdjustmentVoucher aV; AdjustmentVoucherDetail aVD; LussisEntities context = new LussisEntities(); using (var txn = new TransactionScope()) { // Create AdjustmentVoucher aV = new AdjustmentVoucher(); aV.DateIssued = dateIssued; aV.IssueEmpNo = issueEmpNo; aV.Status = "Pending"; context.AdjustmentVouchers.Add(aV); context.SaveChanges(); // Create AdjustmentVoucherDetails aVD = new AdjustmentVoucherDetail(); aVD.AvNo = aV.AvNo; aVD.ItemNo = itemNo; aVD.Qty = qty; aVD.Reason = reason; context.AdjustmentVoucherDetails.Add(aVD); context.SaveChanges(); txn.Complete(); } // Send Email var supplier1Code = context.StationeryCatalogues.Where(x => x.ItemNo.Equals(itemNo)).FirstOrDefault().Supplier1; var unitPrice = context.SupplyTenders.Where(x => x.ItemNo.Equals(itemNo) && x.SupplierCode.Equals(supplier1Code)).FirstOrDefault().UnitPrice; var price = qty * unitPrice; Employee recipient; if (price >= 250) { recipient = context.StoreAssignments.Where(x => x.Role.Equals("Manager")).FirstOrDefault().Employee; } else { recipient = context.StoreAssignments.Where(x => x.Role.Equals("Supervisor")).FirstOrDefault().Employee; } string recipientEmail = recipient.Email; string emailSubject = EmailTemplate.GenerateAdjustmentVoucherSubject(); string emailContent = EmailTemplate.GenerateAdjustmentVoucherEmail(recipient.EmpName, aV.AvNo); EmailBackend.sendEmailStep(recipientEmail, emailSubject, emailContent); }
public static void SubmitOrder(List <OrderItem> orderList, int orderedBy, DateTime dateIssued) { // Create empty POList List <PurchaseOrder> pOList = new List <PurchaseOrder>(); using (var txn = new TransactionScope()) { // For each OrderItem for (int i = 0; i < orderList.Count; i++) { OrderItem orderItem = orderList[i]; string itemNo = orderItem.Stock.ItemNo; // Qty > 0? for (int j = 0; j < orderItem.OrderQtyList.Count; j++) { string supplierCode = orderItem.SupplierCodeList[j]; int? qty = orderItem.OrderQtyList[j]; if (qty > 0) { // Create or get PO PurchaseOrder pO = CreatePurchaseOrder(supplierCode, orderedBy, dateIssued, pOList); int pONo = pO.PONo; // Create POD PurchaseOrderDetail pOD = CreatePurchaseOrderDetail(pONo, itemNo, qty); } } } txn.Complete(); } // Send Email LussisEntities context = new LussisEntities(); var supervisorName = context.StoreAssignments.Where(x => x.Role == "Supervisor").FirstOrDefault().Employee.EmpName; List <string> pOEmailEntries = new List <string>(); foreach (PurchaseOrder pO in pOList) { var pONo = pO.PONo; var supplier = context.Suppliers.Where(x => x.SupplierCode.Equals(pO.SupplierCode)).FirstOrDefault().SupplierName; var pOEmailEntry = pONo + " " + supplier; pOEmailEntries.Add(pOEmailEntry); } var recipientEmail = context.StoreAssignments.Where(x => x.Role == "Supervisor").FirstOrDefault().Employee.Email; var emailSubject = EmailTemplate.GenerateOrderFormEmailSubject(); var emailContent = EmailTemplate.GenerateOrderFormEmail(supervisorName, pOEmailEntries); EmailBackend.sendEmailStep(recipientEmail, emailSubject, emailContent); }
private static void ProcessRequisitions(LussisEntities context, int retrievalNo) { // Get Approved Requisitions List <Requisition> requisitionList = GetApprovedRequisitions(context); if (requisitionList.Count == 0) { throw new Exception("No Requisitions to Process"); } // For each Requisition for (int i = 0; i < requisitionList.Count; i++) { // Get RequisitionDetails List <RequisitionDetail> requisitionDetailList = requisitionList[i].RequisitionDetails.ToList <RequisitionDetail>(); // For each RequisitionDetail for (int j = 0; j < requisitionDetailList.Count; j++) { // Get deptCode & itemNo string deptCode = requisitionDetailList[j].RequisitionInfo.EmployeeWhoIssued.DeptCode; string itemNo = requisitionDetailList[j].ItemNo; // Get RetrievalDetail RetrievalDetail retrievalDetail = GetRetrievalDetail(context, retrievalNo, deptCode, itemNo); if (retrievalDetail != null) { // Update RetrievalDetail retrievalDetail.Needed += requisitionDetailList[j].Qty; } else { // Create RetrievalDetail retrievalDetail = new RetrievalDetail(); retrievalDetail.RetrievalNo = retrievalNo; retrievalDetail.DeptCode = deptCode; retrievalDetail.ItemNo = requisitionDetailList[j].ItemNo; retrievalDetail.Needed = requisitionDetailList[j].Qty; retrievalDetail.BackLogQty = 0; retrievalDetail.Actual = 0; retrievalDetail = AddRetrievalDetail(context, retrievalDetail); context.SaveChanges(); } } // Update Requisition Status requisitionList[i].Status = "Processed"; } context.SaveChanges(); }
private static PurchaseOrderDetail CreatePurchaseOrderDetail(int pONo, string itemNo, int?qty) { LussisEntities context = new LussisEntities(); // Create PurchaseOrderDetail PurchaseOrderDetail pOD = new PurchaseOrderDetail(); pOD.PONo = pONo; pOD.ItemNo = itemNo; pOD.Qty = qty; context.PurchaseOrderDetails.Add(pOD); context.SaveChanges(); return(pOD); }
protected void Page_Load(object sender, EventArgs e) { LussisEntities context = new LussisEntities(); int poNO = Convert.ToInt32(Request["PO"]); poNumberLabel.Text = Convert.ToString(poNO); var toGetSupplier = context.PurchaseOrders.Where(x => x.PONo == poNO).FirstOrDefault(); var supplierSelected = toGetSupplier.SupplierCode; var supplierName = toGetSupplier.Supplier.SupplierName; suppliernameLabel.Text = supplierName; var getPODetails = ApprovePurchaseOrderController.getPurchaseOrderDetails(poNO, supplierSelected); ApprovePODetailsGridView.DataSource = getPODetails; ApprovePODetailsGridView.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { LussisEntities context = new LussisEntities(); int iAV = Convert.ToInt32(Request["IAV"]); invAdjLabel.Text = Convert.ToString(iAV); var getIAVDetails = ApproveInventoryAdjustmentController.getInvAdjDetails(iAV); var EmpName = context.AdjustmentVouchers.Where(x => x.AvNo == iAV).FirstOrDefault().Employee1.EmpName; invAdjClerkLabel.Text = EmpName; var dateRaised = context.AdjustmentVouchers.Where(x => x.AvNo == iAV).FirstOrDefault().DateIssued.Value; dateRaisedText.Text = dateRaised.ToString("dd-MMM-yyyy"); ApproveInventoryAdjustmentDetailsGridView.DataSource = getIAVDetails; ApproveInventoryAdjustmentDetailsGridView.DataBind(); }
protected void rejectAdjustmentButton_Click(object sender, EventArgs e) { int iAV = Convert.ToInt32(Request["IAV"]); var empNo = Profile.EmpNo; ApproveInventoryAdjustmentController.setStatusReject(iAV); ApproveInventoryAdjustmentController.setApprovedBy(iAV, empNo); //send Email, will need to put in controller LussisEntities entity = new LussisEntities(); AdjustmentVoucher currentAV = entity.AdjustmentVouchers.Where(x => x.AvNo == iAV).FirstOrDefault(); Employee recpt = entity.Employees.Where(x => x.EmpNo == currentAV.IssueEmpNo).FirstOrDefault(); Employee approver = entity.Employees.Where(x => x.EmpNo == empNo).FirstOrDefault(); EmailBackend.sendEmailStep(recpt.Email, EmailTemplate.GenerateAdjVouchStatusChangedEmailSubject(iAV.ToString(), currentAV.Status), EmailTemplate.GenerateAdjVouchStatusChangedEmail(recpt.EmpName, iAV.ToString(), approver.EmpName, currentAV.Status)); Response.Redirect("~/Store/Supervisor/ApproveInventoryAdjustmentList.aspx"); }
public void updateStockTxn() { //get no of Rows int rowCount = ApproveInventoryAdjustmentDetailsGridView.Rows.Count; for (int i = 0; i < rowCount; i++) { LussisEntities context = new LussisEntities(); StockTxnDetail stkdetails = new StockTxnDetail(); //get itemno to pass to controller to update stocktxndetails table Label itemNoLabel = (Label)ApproveInventoryAdjustmentDetailsGridView.Rows[i].FindControl("ItemCode"); string itemNoText = itemNoLabel.Text; //get date DateTime getDate = DateTime.Now; //get adjusted qty Label amtAdjustedLabel = (Label)ApproveInventoryAdjustmentDetailsGridView.Rows[i].FindControl("qtyAdjustedAmt"); int amtAdjustedText = Convert.ToInt32(amtAdjustedLabel.Text); //get Recordedqty int qtyAmt = (int)context.StationeryCatalogues.Where(x => x.ItemNo == itemNoText).Select(x => x.CurrentQty).First() + Convert.ToInt32(amtAdjustedText); //get Remarks Label remarksLabel = (Label)ApproveInventoryAdjustmentDetailsGridView.Rows[i].FindControl("Remarks"); string remarksText = remarksLabel.Text; //get own Emp No var empNumber = Profile.EmpNo; stkdetails.ItemNo = itemNoText; stkdetails.Date = getDate; stkdetails.AdjustQty = amtAdjustedText; stkdetails.RecordedQty = qtyAmt; stkdetails.Remarks = remarksText; ApproveInventoryAdjustmentController.updateStockTransactioninDB(stkdetails); ApproveInventoryAdjustmentController.updateStationeryCatalogue(itemNoText, qtyAmt); } }
public static void DeleteAV(int aVNo) { LussisEntities context = new LussisEntities(); using (var txn = new TransactionScope()) { // Remove AdjustmentVoucherDetails List <AdjustmentVoucherDetail> result = context.AdjustmentVoucherDetails.Where(x => x.AvNo == aVNo).ToList <AdjustmentVoucherDetail>(); foreach (AdjustmentVoucherDetail aVD in result) { context.AdjustmentVoucherDetails.Remove(aVD); } // Remove AdjustmentVoucher AdjustmentVoucher aV = context.AdjustmentVouchers.Where(x => x.AvNo == aVNo).FirstOrDefault(); context.AdjustmentVouchers.Remove(aV); context.SaveChanges(); txn.Complete(); } }
public static void DeletePO(int pONo) { LussisEntities context = new LussisEntities(); using (var txn = new TransactionScope()) { // Remove PurchaseOrderDetails List <PurchaseOrderDetail> pODs = context.PurchaseOrders.Where(x => x.PONo == pONo).FirstOrDefault().PurchaseOrderDetails.ToList(); foreach (PurchaseOrderDetail pOD in pODs) { context.PurchaseOrderDetails.Remove(pOD); } // Remove PurchaseOrder PurchaseOrder pO = context.PurchaseOrders.Where(x => x.PONo == pONo).FirstOrDefault(); context.PurchaseOrders.Remove(pO); context.SaveChanges(); txn.Complete(); } }
public static int CreateWeeklyRetrieval() { context = new LussisEntities(); int retrievalNo = -1; // Creating Database Transaction using (var txn = new TransactionScope()) { try { //Add Retrieval Retrieval retrieval = AddRetrieval(context, new Retrieval() { Date = DateTime.Today }); // Get RetrievalNo retrievalNo = retrieval.RetrievalNo; // Add RetrievalDetails (from RequisitionDetails) ProcessRequisitions(context, retrievalNo); // Add RetrievalDetails (from Backlogs) ProcessBacklogs(context, retrievalNo); // Clear Backlog Clear(context); // Commit Transaction txn.Complete(); } catch (Exception) { // Rollback Transaction //dbcxtransaction.Rollback(); } } return(retrievalNo); }
private static PurchaseOrder CreatePurchaseOrder(string supplierCode, int orderedBy, DateTime dateIssued, List <PurchaseOrder> pOList) { LussisEntities context = new LussisEntities(); // Check if SupplierCode inside pOList PurchaseOrder pO = pOList.Where(x => x.SupplierCode.Equals(supplierCode)).FirstOrDefault(); if (pO == null) { // Create PurchaseOrder pO = new PurchaseOrder(); pO.SupplierCode = supplierCode; pO.OrderedBy = orderedBy; pO.DateIssued = dateIssued; pO.Status = "Pending"; context.PurchaseOrders.Add(pO); context.SaveChanges(); pOList.Add(pO); } return(pO); }
public static DisbursementDetail AddDisbursementDetail(LussisEntities context, DisbursementDetail disbursementDetail) { // TODO : Put a filter for what kind of disbursement to edit DisbursementDetail detail = context.DisbursementDetails .Where(det => det.DisbursementNo.Equals(disbursementDetail.DisbursementNo) && det.ItemNo.Equals(disbursementDetail.ItemNo)) .FirstOrDefault(); if (detail != null) { // Append to existing if it already exists detail.Needed += disbursementDetail.Needed; detail.Promised += disbursementDetail.Promised; detail.Received += disbursementDetail.Received; } else { // Add new detail context.DisbursementDetails.Add(disbursementDetail); } context.SaveChanges(); return(disbursementDetail); }
//reject button protected void rejectButton_Click(object sender, EventArgs e) { int poNO = Convert.ToInt32(Request["PO"]); var empNo = Profile.EmpNo; var remarks = approvePORemarksTB.Text; ApprovePurchaseOrderController.setStatusReject(poNO); ApprovePurchaseOrderController.updateApproveBy(poNO, empNo); ApprovePurchaseOrderController.updateDateReviewed(poNO); ApprovePurchaseOrderController.updateRemarks(poNO, remarks); //send email, will need to put in controller LussisEntities entity = new LussisEntities(); PurchaseOrder currentPO = entity.PurchaseOrders.Where(x => x.PONo == poNO).FirstOrDefault(); Employee recpt = entity.Employees.Where(x => x.EmpNo == currentPO.OrderedBy).FirstOrDefault(); Employee approver = entity.Employees.Where(x => x.EmpNo == empNo).FirstOrDefault(); EmailBackend.sendEmailStep(recpt.Email, EmailTemplate.GeneratePOStatusChangedEmailSubject(poNO.ToString(), currentPO.Status), EmailTemplate.GeneratePOStatusChangedEmail(recpt.EmpName, poNO.ToString(), approver.EmpName, currentPO.Status, currentPO.Remarks)); Response.Redirect("~/Store/Supervisor/ApprovePOList.aspx"); }
protected void Page_Load(object sender, EventArgs e) { LussisEntities context = new LussisEntities(); int SNO = (Convert.ToInt16(Request["SNO"])); var query = context.PURCHASEORDERVIEWs .Where(x => x.PONo == SNO); var purchaseOrderDetails = ViewReorderReportController.showPurchaseOrderDetails(SNO); var abc = purchaseOrderDetails.Select(x => new { ItemNo = x.ItemNo, Description = x.Description, Qty = x.Qty, UnitPrice = x.UnitPrice }); GridViewTest.DataSource = abc; GridViewTest.DataBind(); //filling up labels supplierNameLabel.Text = Convert.ToString(context.PurchaseOrders .Where(p => p.PONo == SNO) .FirstOrDefault().Supplier.SupplierName); poNumberLabel.Text = Convert.ToString(SNO); orderedByLabel.Text = Convert.ToString(context.PurchaseOrders .Where(p => p.PONo == SNO) .FirstOrDefault().Employee1.EmpName); datedLabel.Text = context.PurchaseOrders .Where(p => p.PONo == SNO) .FirstOrDefault().DateIssued.Value.ToString("dd MMM yyyy"); int empNo = (int)context.PurchaseOrders.Where(p => p.PONo == SNO).FirstOrDefault().ApprovedBy; approvedByLabel.Text = context.Employees.Where(x => x.EmpNo == empNo).First().EmpName; dated2Label.Text = context.PurchaseOrders .Where(p => p.PONo == SNO) .FirstOrDefault().DateReviewed.Value.ToString("dd MMM yyyy"); }
private static void ProcessBacklogs(LussisEntities context, int retrievalNo) { // Get Backlogs List <BackLog> backlogList = context.BackLogs.ToList <BackLog>(); // For each Backlog for (int i = 0; i < backlogList.Count; i++) { // Get deptCode & itemNo string deptCode = backlogList[i].DeptCode; string itemNo = backlogList[i].ItemNo; // Get RetrievalDetail RetrievalDetail retrievalDetail = GetRetrievalDetail(context, retrievalNo, deptCode, itemNo); if (retrievalDetail != null) { // Update RetrievalDetail retrievalDetail.BackLogQty += backlogList[i].BackLogQty; } else { // Create RetrievalDetail retrievalDetail = new RetrievalDetail(); retrievalDetail.RetrievalNo = retrievalNo; retrievalDetail.DeptCode = deptCode; retrievalDetail.ItemNo = itemNo; retrievalDetail.Needed = 0; retrievalDetail.BackLogQty = backlogList[i].BackLogQty; retrievalDetail.Actual = 0; retrievalDetail = AddRetrievalDetail(context, retrievalDetail); } } context.SaveChanges(); }