private void LoadInvoices() { string Receiptno = txtReceiptno.Text.Trim(); string name = txtname.Text.Trim(); string PaymentType = GetSelectedType(); if (Receiptno.Equals("") && name.Equals("")) { ShowMessage("Invoice Number or Customer Name Required", true); txtReceiptno.Focus(); } else { DateTime fromdate = bll.ReturnDate(txtfromDate.Text.Trim(), 1); DateTime todate = bll.ReturnDate(txttoDate.Text.Trim(), 2); dataTable = datapay.GetInvoice(Receiptno, name, PaymentType, fromdate, todate); DataGrid1.DataSource = dataTable; DataGrid1.DataBind(); if (dataTable.Rows.Count > 0) { CalculateTotal(dataTable); DataGrid1.Visible = true; lblTotal.Visible = true; ShowMessage(".", true); } else { lblTotal.Text = "."; DataGrid1.Visible = false; lblTotal.Visible = false; ShowMessage("No Record found", true); } } }
private void LoadCredits() { try { string custName = txtCustName.Text; string CustAccount = txtCustAccount.Text; DateTime fromdate = bll.ReturnDate(txtfromDate.Text.Trim(), 1); DateTime todate = bll.ReturnDate(txttoDate.Text.Trim(), 2); dataTable = datafile.GetCreditsToApprove(custName, CustAccount, fromdate, todate); if (dataTable.Rows.Count > 0) { MultiView1.ActiveViewIndex = 0; DataGrid1.Visible = true; DataGrid1.DataSource = dataTable; DataGrid1.CurrentPageIndex = 0; DataGrid1.DataBind(); //ShowMessage(".", false); } else { MultiView1.ActiveViewIndex = -1; ShowMessage("No Credits To Approve", true); } } catch (Exception ex) { throw ex; } }
private void LoadLogs() { user.Name = txtSearch.Text.Trim(); user.Role = cboAccessLevel.SelectedValue.ToString(); user.FromDate = bll.ReturnDate(txtfromDate.Text.Trim(), 1); user.ToDate = bll.ReturnDate(txttoDate.Text.Trim(), 2); dataTable = datafile.GetLogs(user); DataGrid1.DataSource = dataTable; DataGrid1.DataBind(); }
private void LoadLogs() { string file_type = cboAccessLevel.SelectedValue.ToString(); DateTime FromDate = bll.ReturnDate(txtfromDate.Text.Trim(), 1); DateTime ToDate = bll.ReturnDate(txttoDate.Text.Trim(), 2); dataTable = datafile.GetFileProcesses(file_type, FromDate, ToDate); DataGrid1.CurrentPageIndex = 0; DataGrid1.DataSource = dataTable; DataGrid1.DataBind(); }
private void LoadBatches() { DateTime fromDate = bll.ReturnDate(txtfromDate.Text.Trim(), 1); DateTime toDate = bll.ReturnDate(txttoDate.Text.Trim(), 2); bool confirmed = chkActive.Checked; dataTable = datapay.GetPaymentBatches(fromDate, toDate, confirmed); DataGrid1.CurrentPageIndex = 0; DataGrid1.DataSource = dataTable; DataGrid1.DataBind(); }
private void LoadDeletedTransactions() { if (txtfromDate.Text.Equals("")) { DataGrid1.Visible = false; ShowMessage("From Date is required", true); txtfromDate.Focus(); } else { vendorcode = cboVendor.SelectedValue.ToString(); vendorref = txtpartnerRef.Text.Trim(); Paymentcode = cboPaymentType.SelectedValue.ToString(); Account = txtAccount.Text.Trim(); CustName = txtCustName.Text.Trim(); fromdate = bll.ReturnDate(txtfromDate.Text.Trim(), 1); //todate = bll.ReturnDate(txttoDate.Text.Trim(), 2); teller = txtSearch.Text.Trim(); utility = cboUtility.SelectedValue.ToString(); dataTable = datapay.GetDeletedTransactions(vendorcode, vendorref, teller, fromdate, Paymentcode, Account, CustName, utility); //dataTable = datapay.GetFailedTransactions(vendorcode, vendorref, teller, fromdate, Paymentcode, Account, CustName, utility); DataGrid1.CurrentPageIndex = 0; DataGrid1.DataSource = dataTable; DataGrid1.DataBind(); if (dataTable.Rows.Count > 0) { string rolecode = Session["RoleCode"].ToString(); if (rolecode.Equals("004")) { MultiView1.ActiveViewIndex = -1; } else { MultiView1.ActiveViewIndex = 0; } DataGrid1.Visible = true; //Button1.Visible = true; btnDelete.Visible = true; ShowMessage(".", true); } else { DataGrid1.Visible = false; //Button1.Visible = false; btnDelete.Visible = false; MultiView1.ActiveViewIndex = -1; ShowMessage("No Record found", true); } } }
private void LoadTransactions() { string tranType = DropDownList1.SelectedValue.ToString(); string vendorcode = cboVendor.SelectedValue.ToString(); string vendorref = txtpartnerRef.Text.Trim(); string Paymentcode = "0"; string Account = ""; string CustName = ""; DateTime fromdate = bll.ReturnDate(txtfromDate.Text.Trim(), 1); DateTime todate = bll.ReturnDate(txttoDate.Text.Trim(), 2); string teller = ""; if (tranType.Equals("0")) { ShowMessage("Please Select Transaction Type", true); } else if (vendorcode.Equals("0")) { ShowMessage("Please Select Collection Partner", true); } else { if (tranType.Equals("1")) { dataTable = datapay.GetTransToBin(vendorcode, vendorref, Account, CustName, Paymentcode, teller, fromdate, todate); } else { dataTable = datapay.GetReconciledTransToBin(vendorcode, vendorref, Account, CustName, Paymentcode, teller, fromdate, todate); } DataGrid1.DataSource = dataTable; DataGrid1.DataBind(); if (dataTable.Rows.Count > 0) { MultiView1.ActiveViewIndex = 0; CalculateTotal(dataTable); ShowMessage(".", true); } else { MultiView1.ActiveViewIndex = -1; ShowMessage("No Record found", true); } } chkSelect.Checked = false; CheckBox2.Checked = false; }
private void LoadTransactions() { string vendorcode = cboVendor.SelectedValue.ToString(); string vendorref = ""; string option = cboBatchType.SelectedValue.ToString(); string Paymentcode = "0"; string Account = txtAccountno.Text.Trim(); string CustName = ""; DateTime fromdate = bll.ReturnDate(txtfromDate.Text.Trim(), 1); DateTime todate = bll.ReturnDate(txttoDate.Text.Trim(), 2); string teller = ""; if (option.Equals("0")) { ShowMessage("Please Select Batch Type to Create", true); } else if (vendorcode.Equals("0")) { ShowMessage("Please Select Collection Partner", true); } else { if (option.Equals("P")) { dataTable = datapay.GetTransforBatching(vendorcode, vendorref, Account, CustName, Paymentcode, teller, fromdate, todate); } else { dataTable = datapay.GetRevTransforBatching(vendorcode, vendorref, Account, CustName, Paymentcode, teller, fromdate, todate); } DataGrid1.DataSource = dataTable; DataGrid1.DataBind(); if (dataTable.Rows.Count > 0) { MultiView1.ActiveViewIndex = 0; CalculateTotal(dataTable); ShowMessage(".", true); } else { MultiView1.ActiveViewIndex = -1; ShowMessage("No Record found", true); } } }
private void LoadTransactions() { string tranType = DropDownList1.SelectedValue.ToString(); string vendorcode = "0"; string vendorref = txtpartnerRef.Text.Trim(); string Paymentcode = "0"; string Accountno = txtAccountNo.Text.Trim(); string CustName = ""; DateTime fromdate = bll.ReturnDate(txtfromDate.Text.Trim(), 1); DateTime todate = bll.ReturnDate(txttoDate.Text.Trim(), 2); string teller = ""; if (tranType.Equals("0")) { ShowMessage("Please Select Transaction Type", true); } else if (vendorref.Equals("") && Accountno.Equals("")) { ShowMessage("Please Enter Account / Vendor Transaction ref", true); txtAccountNo.Focus(); } else { bool reconciled = Process.Gettrans_status(tranType); dataTable = datapay.GetBinnedTransactions(vendorcode, vendorref, Accountno, CustName, Paymentcode, reconciled, teller, fromdate, todate); DataGrid1.DataSource = dataTable; DataGrid1.DataBind(); if (dataTable.Rows.Count > 0) { MultiView1.ActiveViewIndex = 0; CalculateTotal(dataTable); ShowMessage(".", true); } else { MultiView1.ActiveViewIndex = -1; ShowMessage("No Record found", true); } } chkSelect.Checked = false; CheckBox2.Checked = false; }
private void LoadTransactions() { if (txtfromDate.Text.Equals("")) { DataGrid1.Visible = false; ShowMessage("From Date is required", true); txtfromDate.Focus(); } else { string status = cboStatus.SelectedValue.ToString(); string districtcode = cboBranches.SelectedValue.ToString(); DateTime fromdate = bll.ReturnDate(txtfromDate.Text.Trim(), 1); DateTime todate = bll.ReturnDate(txttoDate.Text.Trim(), 2); if (districtcode.Trim().Equals("ALL VENDOR CODES")) { districtcode = "0"; } if (status.Trim().Equals("ALL UTILITIES")) { status = "0"; } dataTable = datapay.GetInterfaceErrorTable(districtcode, status, fromdate, todate); DataGrid1.CurrentPageIndex = 0; DataGrid1.DataSource = dataTable; DataGrid1.DataBind(); if (dataTable.Rows.Count > 0) { ////string rolecode = Session["RoleCode"].ToString(); ////if (rolecode.Equals("004")) ////{ //MultiView1.ActiveViewIndex = -1; ////} ////else ////{ MultiView1.ActiveViewIndex = 0; //CalculateTotal(dataTable); //} //DataGrid1.Visible = true; //ShowMessage(".", true); } else { lblTotal.Text = "."; DataGrid1.Visible = false; lblTotal.Visible = false; MultiView1.ActiveViewIndex = -1; ShowMessage("No Record found", true); } } }
private void LoadTransactions() { if (txtfromDate.Text.Equals("")) { DataGrid1.Visible = false; ShowMessage("From Date is required", true); txtfromDate.Focus(); } else { string vendorcode = cboVendor.SelectedValue.ToString(); string vendorref = txtpartnerRef.Text.Trim(); //string Paymentcode = cboPaymentType.SelectedValue.ToString(); string status = cboStatus.SelectedValue.ToString(); string Account = txtAccount.Text.Trim(); string CustName = txtCustName.Text.Trim(); DateTime fromdate = bll.ReturnDate(txtfromDate.Text.Trim(), 1); DateTime todate = bll.ReturnDate(txttoDate.Text.Trim(), 2); //string teller = txtSearch.Text.Trim(); string utility = cboUtility.SelectedValue.ToString(); dataTable = datapay.GetTransactionsForPrePaidVendors(vendorcode, vendorref, Account, status, CustName, fromdate, todate, utility); DataGrid1.CurrentPageIndex = 0; DataGrid1.DataSource = dataTable; DataGrid1.DataBind(); if (dataTable.Rows.Count > 0) { string rolecode = Session["RoleCode"].ToString(); if (rolecode.Equals("004")) { MultiView1.ActiveViewIndex = -1; } else { MultiView1.ActiveViewIndex = 0; CalculateTotal(dataTable); } DataGrid1.Visible = true; ShowMessage(".", true); } else { lblTotal.Text = "."; DataGrid1.Visible = false; lblTotal.Visible = false; MultiView1.ActiveViewIndex = -1; ShowMessage("No Record found", true); } } }
private void LoadPayments() { if (txtfromDate.Text.Equals("")) { DataGrid1.Visible = false; ShowMessage("From Date is required", true); txtfromDate.Focus(); } else { string districtcode = GetDistrictCode(); string Receiptno = txtReceiptno.Text.Trim(); string Paymentcode = cboPaymentType.SelectedValue.ToString(); string Paymode = cboPaymode.SelectedValue.ToString(); DateTime fromdate = bll.ReturnDate(txtfromDate.Text.Trim(), 1); DateTime todate = bll.ReturnDate(txttoDate.Text.Trim(), 2); string teller = cboCashier.SelectedValue.ToString(); dataTable = datapay.GetPaymentsToReverse(districtcode, Receiptno, Paymentcode, Paymode, teller, fromdate, todate); DataGrid1.DataSource = dataTable; DataGrid1.DataBind(); if (dataTable.Rows.Count > 0) { CalculateTotal(dataTable); MultiView1.ActiveViewIndex = 0; DataGrid1.Visible = true; lblTotal.Visible = true; ShowMessage(".", true); } else { lblTotal.Text = "."; DataGrid1.Visible = false; lblTotal.Visible = false; MultiView1.ActiveViewIndex = -1; ShowMessage("No Record found", true); } } }
private void LoadTransactions() { if (txtfromDate.Text.Equals("")) { DataGrid1.Visible = false; ShowMessage("From Date is required", true); txtfromDate.Focus(); } else { string vendorcode = cboVendor.SelectedValue.ToString(); string receiptNo = txtReceiptno.Text.Trim(); string meterNo = txtMeterNo.Text.Trim(); DateTime fromdate = bll.ReturnDate(txtfromDate.Text.Trim(), 1); DateTime todate = bll.ReturnDate(txttoDate.Text.Trim(), 2); dataTable = datapay.GetPrepayments(vendorcode, meterNo, receiptNo, fromdate, todate); DataGrid1.CurrentPageIndex = 0; DataGrid1.DataSource = dataTable; DataGrid1.DataBind(); if (dataTable.Rows.Count > 0) { string rolecode = Session["RoleCode"].ToString(); if (rolecode.Equals("004")) { MultiView1.ActiveViewIndex = -1; } else { MultiView1.ActiveViewIndex = 0; CalculateTotal(dataTable); } DataGrid1.Visible = true; ShowMessage(".", true); } else { lblTotal.Text = "."; DataGrid1.Visible = false; lblTotal.Visible = false; MultiView1.ActiveViewIndex = -1; ShowMessage("No Record found", true); } } }
private void LoadCustomerContacts() { string accountno = txtaccountno.Text.Trim(); string phone = txtPhone.Text.Trim(); PhoneValidator phonevalid = new PhoneValidator(); if (phonevalid.PhoneNumbersOk(phone)) { phone = GetPhoneNumber(phone); DateTime fromDate = bll.ReturnDate(txtfromdate.Text.Trim(), 1); DateTime toDate = bll.ReturnDate(txttodate.Text.Trim(), 2); dataTable = datapay.GetCustomercontacts(accountno, phone, fromDate, toDate); if (dataTable.Rows.Count > 0) { DataGrid1.CurrentPageIndex = 0; DataGrid1.DataSource = dataTable; DataGrid1.DataBind(); DataGrid1.Visible = true; MultiView1.ActiveViewIndex = 0; ShowMessage(".", true); } else { DataGrid1.Visible = false; MultiView1.ActiveViewIndex = -1; ShowMessage("No Record found", true); } } else { DataGrid1.Visible = false; MultiView1.ActiveViewIndex = -1; ShowMessage("Please Enter a valid phone number", true); txtPhone.Focus(); } }