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"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var reorderReport = ViewReorderReportController.showReorderReport(); reorderReportListGridView.DataSource = reorderReport; reorderReportListGridView.DataBind(); } }
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"); }