protected void bind()
{
string InvoiceNum = Request.QueryString["InvoiceNum"];
BLL_Supplier_Votech obj = new BLL_Supplier_Votech();
DAL_CreateInvoice[] Invoice_List;
Invoice_List = obj.GetInvoiceCreated();
lbl_InvoiceNum.Text = InvoiceNum;
lbl_CompanyEmail.Text = Invoice_List[0].CO_CompanyEmail.ToString();
lbl_CompanyName.Text = Invoice_List[0].CO_CompanyName.ToString();
lbl_Companycontact.Text = Invoice_List[0].CO_CompanyContact.ToString();
lbl_CompanyAddress.Text = Invoice_List[0].CO_CompanyAddress.ToString();
lbl_Date.Text = Invoice_List[0].InvoiceDate.ToString();
//Gridview codes
DAL_Access_Supplier_Votech item = new DAL_Access_Supplier_Votech();
DataSet ds;
ds = item.getInvoiceOrderItem();
gv_InvoiceOrderItem.DataSource = ds;
gv_InvoiceOrderItem.DataBind();
//gv_InvoiceOrderItem.FooterRow.Cells[2].Text = "Total Amount";
//gv_InvoiceOrderItem.FooterRow.Cells[3].Text = ds.Compute("SUM(OI_Price)", "").ToString();
//lbl_Total.Text = ds.Compute("SUM(OI_Price)", "").ToString();
}
public DataSet GetAllOrderItem(string CO_ID)
{
DAL_Access_Supplier_Votech dataLayerPS;
DataSet datasetCustomerOrderViewMore;
dataLayerPS = new DAL_Access_Supplier_Votech();
datasetCustomerOrderViewMore = dataLayerPS.GetAllOrderItem(CO_ID);
return(datasetCustomerOrderViewMore);
}
public DataSet GetAllCustomerOrders()
{
DAL_Access_Supplier_Votech dataLayerPS;
DataSet datasetCustomerOrders;
dataLayerPS = new DAL_Access_Supplier_Votech();
datasetCustomerOrders = dataLayerPS.GetAllCustomerOrders();
return(datasetCustomerOrders);
}
public DataSet getInvoiceOrderItem()
{
DAL_Access_Supplier_Votech dataLayerPS;
DataSet datasetgetinvoiceorderitem;
dataLayerPS = new DAL_Access_Supplier_Votech();
datasetgetinvoiceorderitem = dataLayerPS.getInvoiceOrderItem();
return(datasetgetinvoiceorderitem);
}
protected void btn_Pay_Click(object sender, EventArgs e)
{
DAL_Access_Supplier_Votech obj = new DAL_Access_Supplier_Votech();
//insert into local DB
obj.companyPaySupplier(tb_PaymentDate.Text, tb_ChequeNo.Text, Convert.ToInt32(tb_PaymentAmount.Text), tb_Payee.Text, tb_Memo.Text, Convert.ToInt32(tb_InvoiceNum.Text));
Response.Write("<script>alert('Successfully Paid!');</script>");
//insert into supplier DB
obj.PaySupplier(tb_PaymentDate.Text, tb_ChequeNo.Text, Convert.ToInt32(tb_PaymentAmount.Text), tb_Payee.Text, tb_Memo.Text, Convert.ToInt32(tb_InvoiceNum.Text));
}
public int PaySupplier(string PaymentDate, string ChequeNo, decimal PaymentAmount, string Payee, string Memo, int InvoiceNum)
{
DAL_Access_Supplier_Votech obj = new DAL_Access_Supplier_Votech();
return(obj.PaySupplier(PaymentDate, ChequeNo, PaymentAmount, Payee, Memo, InvoiceNum));
}