protected void bind()
{
string PO_ID = Request.QueryString["PO_ID"];
List <DAL_PurchaseOrder> PO_List = new List <DAL_PurchaseOrder>();
PO_List = obj.GetSinglePurchaseOrders(PO_ID);
tb_PO_ID.Text = PO_ID;
tb_PO_CompanyEmail.Text = PO_List[0].PO_CompanyEmail.ToString();
tb_CompanyName.Text = PO_List[0].PO_CompanyName.ToString();
tb_CompanyContact.Text = PO_List[0].PO_CompanyContact.ToString();
tb_CompanyAddress.Text = PO_List[0].PO_CompanyAddress.ToString();
lbl_To.Text = PO_List[0].PO_CompanyEmail.ToString();
// =============== Gridview =================
DAL_OrderItem item = new DAL_OrderItem();
DataTable ds;
ds = item.GetAll_OrderItem();
gv_OrderItem.DataSource = ds;
gv_OrderItem.DataBind();
gv_OrderItem.FooterRow.Cells[2].Text = "Total Amount";
gv_OrderItem.FooterRow.Cells[3].Text = ds.Compute("SUM(OI_Price)", "").ToString();
}
protected void bind()
{
string PO_ID = Request.QueryString["PO_ID"];
List <DAL_PurchaseOrder> PO_List = new List <DAL_PurchaseOrder>();
PO_List = obj.GetSinglePurchaseOrders(PO_ID);
tb_PO_ID.Text = PO_ID;
tb_PO_CompanyEmail.Text = PO_List[0].PO_CompanyEmail.ToString();
tb_CompanyName.Text = PO_List[0].PO_CompanyName.ToString();
tb_CompanyContact.Text = PO_List[0].PO_CompanyContact.ToString();
tb_CompanyAddress.Text = PO_List[0].PO_CompanyAddress.ToString();
lbl_To.Text = PO_List[0].PO_CompanyEmail.ToString();
// =============== Gridview =================
DAL_OrderItem item = new DAL_OrderItem();
DataSet ds;
ds = item.GetAll_OrderItem();
gv_OrderItem.DataSource = ds;
gv_OrderItem.DataBind();
}