private void LoadData()
{
try
{
DateTime dteRetValue = DateTime.MinValue;
Data.CreditPaymentCashDetails clsSearchKeys = new Data.CreditPaymentCashDetails();
clsSearchKeys.BranchDetails = new Data.BranchDetails();
clsSearchKeys.TerminalNo = "";
clsSearchKeys.PaymentDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : DateTime.Now.AddDays(-60);
clsSearchKeys.PaymentDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : DateTime.Now;
clsSearchKeys.CreditType = CreditType.Both;
clsSearchKeys.CreditCardTypeID = 0;
clsSearchKeys.ContactID = mclsCustomerDetails.ContactID;
Data.Contacts clsContacts = new Data.Contacts();
System.Data.DataTable dt = clsContacts.CreditPaymentCashAsDataTable(clsSearchKeys, "trx.CreatedOn");
clsContacts.CommitAndDispose();
System.Data.DataView dv = dt.DefaultView;
dv.Sort = "TransactionDate";
dt = dv.ToTable();
dgvItems.MultiSelect = false;
dgvItems.AutoGenerateColumns = true;
dgvItems.AutoSize = false;
dgvItems.DataSource = dt.TableName;
dgvItems.DataSource = dt;
foreach (DataGridViewTextBoxColumn dc in dgvItems.Columns)
{
dc.Visible = false;
}
dgvItems.Columns["TransactionNo"].Visible = true;
dgvItems.Columns["TransactionDate"].Visible = true;
dgvItems.Columns["CreditReason"].Visible = true;
dgvItems.Columns["Amount"].Visible = true;
dgvItems.Columns["TransactionNo"].Width = 150;
dgvItems.Columns["TransactionDate"].Width = 150;
if (dt.Rows.Count < 16)
{
dgvItems.Columns["CreditReason"].Width = 350;
}
else
{
dgvItems.Columns["CreditReason"].Width = 320;
}
int iWidth = (dgvItems.Width - dgvItems.Columns["TransactionNo"].Width - dgvItems.Columns["TransactionDate"].Width - dgvItems.Columns["CreditReason"].Width) / 1;
if (dt.Rows.Count >= 16)
{
iWidth = iWidth - 20;
}
dgvItems.Columns["Amount"].Width = iWidth;
dgvItems.Columns["TransactionNo"].HeaderText = "Transaction No";
dgvItems.Columns["TransactionDate"].HeaderText = "Transaction Date";
dgvItems.Columns["CreditReason"].HeaderText = "Description";
dgvItems.Columns["Amount"].HeaderText = "Amt. Paid";
dgvItems.Columns["Amount"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["Amount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["TransactionDate"].DefaultCellStyle.Format = "yyyy-MM-dd hh:mm tt";
dgvItems.Columns["Amount"].DefaultCellStyle.Format = "#,##0.#0";
dgvItems.ReadOnly = true;
dgvItems.Select();
decimal decTotalPayable = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
decimal decTemp = decimal.TryParse(dr["Amount"].ToString(), out decTemp) ? decTemp : 0;
decTotalPayable += decTemp;
}
lblTotal.Text = decTotalPayable.ToString("#,##0.#0");
grpBox1.Text = "Payments from: " + clsSearchKeys.PaymentDateFrom.ToString("MMM dd, yyyy") + " to " + clsSearchKeys.PaymentDateTo.ToString("MMM dd, yyyy");
txtTrxStartDate.SelectAll();
txtTrxStartDate.Select();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void LoadData()
{
try
{
DateTime dteRetValue = DateTime.MinValue;
Data.CreditPaymentCashDetails clsSearchKeys = new Data.CreditPaymentCashDetails();
clsSearchKeys.BranchDetails = new Data.BranchDetails();
clsSearchKeys.TerminalNo = "";
clsSearchKeys.PaymentDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : DateTime.Now.AddDays(-60);
clsSearchKeys.PaymentDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : DateTime.Now;
clsSearchKeys.CreditType = CreditType.Both;
clsSearchKeys.CreditCardTypeID = 0;
clsSearchKeys.ContactID = mclsCustomerDetails.ContactID;
Data.Contacts clsContacts = new Data.Contacts();
System.Data.DataTable dt = clsContacts.CreditPaymentCashAsDataTable(clsSearchKeys, "trx.CreatedOn");
clsContacts.CommitAndDispose();
System.Data.DataView dv = dt.DefaultView;
dv.Sort = "TransactionDate";
dt = dv.ToTable();
dgvItems.MultiSelect = false;
dgvItems.AutoGenerateColumns = true;
dgvItems.AutoSize = false;
dgvItems.DataSource = dt.TableName;
dgvItems.DataSource = dt;
foreach (DataGridViewTextBoxColumn dc in dgvItems.Columns)
{
dc.Visible = false;
}
dgvItems.Columns["TransactionNo"].Visible = true;
dgvItems.Columns["TransactionDate"].Visible = true;
dgvItems.Columns["CreditReason"].Visible = true;
dgvItems.Columns["Amount"].Visible = true;
dgvItems.Columns["TransactionNo"].Width = 150;
dgvItems.Columns["TransactionDate"].Width = 150;
if (dt.Rows.Count < 16) dgvItems.Columns["CreditReason"].Width = 350; else dgvItems.Columns["CreditReason"].Width = 320;
int iWidth = (dgvItems.Width - dgvItems.Columns["TransactionNo"].Width - dgvItems.Columns["TransactionDate"].Width - dgvItems.Columns["CreditReason"].Width) / 1;
if (dt.Rows.Count >= 16) iWidth = iWidth - 20;
dgvItems.Columns["Amount"].Width = iWidth;
dgvItems.Columns["TransactionNo"].HeaderText = "Transaction No";
dgvItems.Columns["TransactionDate"].HeaderText = "Transaction Date";
dgvItems.Columns["CreditReason"].HeaderText = "Description";
dgvItems.Columns["Amount"].HeaderText = "Amt. Paid";
dgvItems.Columns["Amount"].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["Amount"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
dgvItems.Columns["TransactionDate"].DefaultCellStyle.Format = "yyyy-MM-dd hh:mm tt";
dgvItems.Columns["Amount"].DefaultCellStyle.Format = "#,##0.#0";
dgvItems.ReadOnly = true;
dgvItems.Select();
decimal decTotalPayable = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
decimal decTemp = decimal.TryParse(dr["Amount"].ToString(), out decTemp) ? decTemp : 0;
decTotalPayable += decTemp;
}
lblTotal.Text = decTotalPayable.ToString("#,##0.#0");
grpBox1.Text = "Payments from: " + clsSearchKeys.PaymentDateFrom.ToString("MMM dd, yyyy") + " to " + clsSearchKeys.PaymentDateTo.ToString("MMM dd, yyyy");
txtTrxStartDate.SelectAll();
txtTrxStartDate.Select();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
