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