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