private DataTable GetPurchaseOrderTable()
{
long telHlp = 0;
long faxHlp = 0;
string telfmt = "000-000-0000";
string szTel = "";
TimelyDepotContext db01 = new TimelyDepotContext();
DataTable table = null;
DataRow row = null;
PurchaseOrderList thepurchaseorderlist = null;
List<PurchaseOrderList> purchaseList = new List<PurchaseOrderList>();
var qryPurchaseOrder = db.Vendors.Join(db.PurchaseOrders, vdad => vdad.VendorNo, prod => prod.VendorId, (vdad, prod)
=> new { vdad, prod }).OrderBy(vdod => vdod.prod.PurchaseOrderNo);
if (qryPurchaseOrder.Count() > 0)
{
foreach (var item in qryPurchaseOrder)
{
thepurchaseorderlist = new PurchaseOrderList();
thepurchaseorderlist.PurchaseOrderId = item.prod.PurchaseOrderId;
thepurchaseorderlist.PurchaseOrderNo = item.prod.PurchaseOrderNo;
thepurchaseorderlist.SODate = item.prod.PODate;
thepurchaseorderlist.VendorNo = item.prod.VendorId;
//thepurchaseorderlist.VendorNo = GetCustomerDataSO(db01, item.ctad.VendorId.ToString());
thepurchaseorderlist.CompanyName = GetVendorData01(db01, item.prod.VendorId);
thepurchaseorderlist.SalesOrderNo = item.prod.SalesOrderNo;
thepurchaseorderlist.ShipDate = item.prod.ShipDate;
thepurchaseorderlist.PaymentAmount = this.GetTotalPO01(db01, item.prod.PurchaseOrderId);
purchaseList.Add(thepurchaseorderlist);
}
}
table = new DataTable("SalesOrderList");
// Set the header
DataColumn col01 = new DataColumn("PurchaseOrderNo", System.Type.GetType("System.String"));
DataColumn col02 = new DataColumn("Date", System.Type.GetType("System.String"));
DataColumn col03 = new DataColumn("VendorNo", System.Type.GetType("System.String"));
DataColumn col04 = new DataColumn("VendorCompanyName", System.Type.GetType("System.String"));
DataColumn col05 = new DataColumn("SalesOrderNo", System.Type.GetType("System.String"));
DataColumn col06 = new DataColumn("ShipDate", System.Type.GetType("System.String"));
DataColumn col07 = new DataColumn("Amount", System.Type.GetType("System.String"));
table.Columns.Add(col01);
table.Columns.Add(col02);
table.Columns.Add(col03);
table.Columns.Add(col04);
table.Columns.Add(col05);
table.Columns.Add(col06);
table.Columns.Add(col07);
//Set the data row
foreach (var item in purchaseList)
{
row = table.NewRow();
row["PurchaseOrderNo"] = item.PurchaseOrderNo;
row["Date"] = item.SODate;
row["VendorNo"] = item.VendorNo;
row["VendorCompanyName"] = item.CompanyName;
row["SalesOrderNo"] = item.SalesOrderNo;
row["ShipDate"] = item.ShipDate;
row["Amount"] = item.PaymentAmount;
table.Rows.Add(row);
}
return table;
}
public PartialViewResult PurchaseOrderList(int? page)
{
int pageIndex = 0;
int pageSize = PageSize;
TimelyDepotContext db01 = new TimelyDepotContext();
PurchaseOrderList thepurchaseorderlist = null;
List<PurchaseOrderList> customerList = new List<PurchaseOrderList>();
var qryPurchaseOrder = db.Vendors.Join(db.PurchaseOrders, vdad => vdad.VendorNo, prod => prod.VendorId, (vdad, prod)
=> new { vdad, prod }).OrderBy(vdod => vdod.prod.PurchaseOrderNo);
if (qryPurchaseOrder.Count() > 0)
{
foreach (var item in qryPurchaseOrder)
{
thepurchaseorderlist = new PurchaseOrderList();
thepurchaseorderlist.PurchaseOrderId = item.prod.PurchaseOrderId;
thepurchaseorderlist.PurchaseOrderNo = item.prod.PurchaseOrderNo;
thepurchaseorderlist.SODate = item.prod.PODate;
thepurchaseorderlist.VendorNo = item.prod.VendorId;
//thepurchaseorderlist.VendorNo = GetCustomerDataSO(db01, item.ctad.VendorId.ToString());
thepurchaseorderlist.CompanyName = GetVendorData01(db01, item.prod.VendorId);
thepurchaseorderlist.SalesOrderNo = item.prod.SalesOrderNo;
thepurchaseorderlist.ShipDate = item.prod.ShipDate;
thepurchaseorderlist.PaymentAmount = this.GetTotalPO01(db01, item.prod.PurchaseOrderId);
customerList.Add(thepurchaseorderlist);
}
}
//Set the page
if (page == null)
{
pageIndex = 1;
}
else
{
pageIndex = Convert.ToInt32(page);
}
var onePageOfData = customerList.ToPagedList(pageIndex, pageSize);
ViewBag.OnePageOfData = onePageOfData;
return PartialView(customerList.ToPagedList(pageIndex, pageSize));
}
