private void bCreditPayment_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
frmSelectCustomer frm = new frmSelectCustomer();
if (frm.ShowDialog() == DialogResult.OK)
{
Server2Client sc = new Server2Client();
CustomerAccounts ca = new CustomerAccounts();
Customers cc = new Customers();
Customer c = new Customer();
double bal = 0;
c = cc.getCustomer(frm.CustomerID);
rptCreditPayment rpt = new rptCreditPayment();
XRSummary tdr = new XRSummary();
XRSummary tcr = new XRSummary();
rpt.lbCNM.Text = c.CustomerName;
rpt.lbADR.Text = c.Address;
rpt.lbPHN.Text = c.Phone;
rpt.lbEML.Text = c.Email;
if (!frm.DateSelected)
{
sc = ca.getCustomerBalance(frm.CustomerID);
bal = sc.Value;
sc = ca.getTransactionDetails(frm.CustomerID);
rpt.DataSource = sc.dataTable;
}
else
{
sc = ca.getCustomerBalance(frm.CustomerID, frm.DateFrom, frm.DateTo);
bal = sc.Value;
sc = ca.AccountStatement(frm.CustomerID, frm.DateFrom, frm.DateTo);
rpt.DataSource = sc.dataTable;
}
rpt.lbTDT.DataBindings.Add("Text", null, "TransDate", "{0:dd-MM-yyyy}");
rpt.lbRMK.DataBindings.Add("Text", null, "Description");
rpt.lbTDR.DataBindings.Add("Text", null, "Debit", "{0:c}");
rpt.lbTCR.DataBindings.Add("Text", null, "Credit", "{0:c}");
rpt.lbBAL.DataBindings.Add("Text", null, "Balance", "{0:c}");
rpt.lblTDR.DataBindings.Add("Text", null, "Debit", "{0:C2}");
rpt.lblTCR.DataBindings.Add("Text", null, "Credit", "{0:C2}");
rpt.lblTBL.Text = bal.ToString("c2");
tdr.FormatString = "{0:C2}";
tcr.FormatString = "{0:C2}";
tdr.Running = SummaryRunning.Report;
tcr.Running = SummaryRunning.Report;
rpt.lblTCR.Summary = tdr;
rpt.lblTDR.Summary = tcr;
dv.PrintingSystem = rpt.PrintingSystem;
rpt.CreateDocument(true);
}
}
private void lueCNM_EditValueChanged(object sender, EventArgs e)
{
if (lueCNM.EditValue != null)
{
int CID = Convert.ToInt32(lueCNM.EditValue);
Server2Client sc = new Server2Client();
CustomerAccounts ca = new CustomerAccounts();
sc = ca.getCustomerBalance(CID);
CustomerBalance = sc.Value;
Customers cust = new Customers();
cc = cust.getCustomer(CID);
}
}
private void lueCNM_EditValueChanged(object sender, EventArgs e)
{
int id = Convert.ToInt32(lueCNM.EditValue);
sc = new Server2Client();
ca = new CustomerAccounts();
sc = ca.getCustomerBalance(id);
if (sc.Message != null)
{
txtCBAL.Text = sc.Message;
txtCBAL.Enabled = false;
}
else
{
txtCBAL.Text = sc.Value.ToString();
}
}
public frmCreditPayment(int CustomerID)
{
InitializeComponent();
txtPDT.DateTime = DateTime.Now.Date;
sc = new Server2Client();
cus = new Customers();
ca = new CustomerAccounts();
sc = cus.getCustomers();
lueCNM.Properties.DataSource = sc.dataTable;
lueCNM.Properties.DisplayMember = "CustomerName";
lueCNM.Properties.ValueMember = "ID";
lueCNM.EditValue = CustomerID;
sc = ca.getCustomerBalance(CustomerID);
txtCBAL.Text = sc.Value.ToString();
txtAMNT.Text = "0";
txtNBAL.Text = "0";
}