Example #1
0
        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();
        }
Example #2
0
        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);
        }
Example #3
0
        public DataSet GetAllCustomerOrders()
        {
            DAL_Access_Supplier_Votech dataLayerPS;
            DataSet datasetCustomerOrders;

            dataLayerPS           = new DAL_Access_Supplier_Votech();
            datasetCustomerOrders = dataLayerPS.GetAllCustomerOrders();
            return(datasetCustomerOrders);
        }
Example #4
0
        public DataSet getInvoiceOrderItem()
        {
            DAL_Access_Supplier_Votech dataLayerPS;
            DataSet datasetgetinvoiceorderitem;

            dataLayerPS = new DAL_Access_Supplier_Votech();
            datasetgetinvoiceorderitem = dataLayerPS.getInvoiceOrderItem();
            return(datasetgetinvoiceorderitem);
        }
Example #5
0
        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));
        }
Example #6
0
        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));
        }