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();
}
protected void bind()
{
string CO_ID = Request.QueryString["CO_ID"];
List <DAL_CustomerOrder> CO_List = new List <DAL_CustomerOrder>();
CO_List = obj.GetSingleCustomerOrder(CO_ID);
tb_ID.Text = CO_ID;
tb_CompanyEmail.Text = CO_List[0].CO_CompanyEmail.ToString();
tb_CompanyName.Text = CO_List[0].CO_CompanyName.ToString();
tb_CompanyContact.Text = CO_List[0].CO_CompanyContact.ToString();
tb_CompanyAddress.Text = CO_List[0].CO_CompanyAddress.ToString();
// =============== Gridview =================
DAL_OrderItem item = new DAL_OrderItem();
DataSet ds;
ds = item.GetAll_OrderItem();
gv_OrderItem.DataSource = ds;
gv_OrderItem.DataBind();
lbl_To.Text = CO_List[0].CO_CompanyEmail.ToString();
}
protected void bind()
{
string CO_ID = Request.QueryString["CO_ID"];
List <DAL_CustomerOrder> CO_List = new List <DAL_CustomerOrder>();
CO_List = obj.GetSingleCustomerOrder(CO_ID);
lbl_ID.Text = CO_ID;
lbl_Email.Text = CO_List[0].CO_CompanyEmail.ToString();
lbl_Name.Text = CO_List[0].CO_CompanyName.ToString();
lbl_contact.Text = CO_List[0].CO_CompanyContact.ToString();
lbl_Address.Text = CO_List[0].CO_CompanyAddress.ToString();
lbl_Date.Text = CO_List[0].CO_Date.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();
lbl_Total.Text = ds.Compute("SUM(OI_Price)", "").ToString();
}
protected void bind()
{
string DO_ID = Request.QueryString["DO_ID"];
List <DAL_DeliveryOrder> DO_List = new List <DAL_DeliveryOrder>();
DO_List = DO.getDeliveryOrder(DO_ID);
tb_DO_ID.Text = DO_ID;
tb_CompanyEmail.Text = DO_List[0].DO_CompanyEmail.ToString();
tb_CompanyName.Text = DO_List[0].DO_CompanyName.ToString();
tb_CompanyContact.Text = DO_List[0].DO_CompanyContact.ToString();
tb_CompanyAddress.Text = DO_List[0].DO_CompanyAddress.ToString();
DAL_OrderItem oi = new DAL_OrderItem();
DataTable ds = oi.GetAll_OrderItem();
gvDeliveryOrderItems.DataSource = ds;
gvDeliveryOrderItems.DataBind();
}
protected void gv_OrderItem_SelectedIndexChanged(object sender, EventArgs e)
{
int selectedRow = gv_OrderItem.SelectedIndex;
GridViewRow row = gv_OrderItem.Rows[selectedRow];
BLL_OrderItem obj = new BLL_OrderItem();
string ProdName = row.Cells[1].Text;
string ProdDesc = row.Cells[2].Text;
string ProdPrice = row.Cells[3].Text;
// WEBSERVICE INSERT INTO SUPPLIER
obj.createOrderItems(ProdName, ProdDesc, ProdPrice);
// Insert INTO COMPANY
DAL_OrderItem obj2 = new DAL_OrderItem();
obj2.insertOrderItem(ProdName, ProdDesc, ProdPrice);
}
protected void gv_OrderItem_SelectedIndexChanged(object sender, EventArgs e)
{
int selectedRow = gv_OrderItem.SelectedIndex;
GridViewRow row = gv_OrderItem.Rows[selectedRow];
BLL_OrderItem obj = new BLL_OrderItem();
//string Id = row.Cells[0].Text;
string ProdName = row.Cells[1].Text;
string ProdDesc = row.Cells[2].Text;
string ProdPrice = row.Cells[3].Text;
obj.createOrderItems(ProdName, ProdDesc, ProdPrice);
DAL_OrderItem obj2 = new DAL_OrderItem();
obj2.insertOrderItem(ProdName, ProdDesc, ProdPrice);
}
public int insertOrderItem(string ProdName, string ProdDesc, string ProdPrice)
{
DAL_OrderItem obj = new DAL_OrderItem();
return(obj.insertOrderItem(ProdName, ProdDesc, ProdPrice));
}
public int createOrderItems(string ProdName, string ProdDesc, string ProdPrice)
{
DAL_OrderItem obj = new DAL_OrderItem();
return(obj.createOrderItems(ProdName, ProdDesc, ProdPrice));
}