private void SetDataSource(ReportDocument Report)
{
DateTime dteRetValue = Constants.C_DATE_MIN_VALUE;
ReportDataset rptds = new ReportDataset();
Data.Contacts clsContacts;
System.Data.DataTable dt;
switch (cboReportType.SelectedItem.Value)
{
case ReportTypes.CREDITS_Purchases:
#region purchases
CreditPaymentDetails clsCreditPaymentDetails = new CreditPaymentDetails();
clsCreditPaymentDetails.BranchDetails = new BranchDetails()
{
BranchID = Int32.Parse(cboBranch.SelectedItem.Value)
};
clsCreditPaymentDetails.TerminalNo = txtTerminalNo.Text.Trim();
clsCreditPaymentDetails.PurchaseDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentDetails.PurchaseDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentDetails.CreditType = CreditType.Individual;
clsCreditPaymentDetails.CreditCardTypeID = Int16.Parse(cboCreditType.SelectedItem.Value);
clsCreditPaymentDetails.CreditorLastnameFrom = txtLastNameFrom.Text;
clsCreditPaymentDetails.CreditorLastnameTo = txtLastNameTo.Text;
clsContacts = new Data.Contacts();
dt = clsContacts.CreditPurchasesAsDataTable(clsCreditPaymentDetails, "cci.CreditCardNo");
clsContacts.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.ContactCreditPurchases.NewRow();
foreach (DataColumn dc in rptds.ContactCreditPurchases.Columns)
{
drNew[dc] = "" + dr[dc.ColumnName];
}
rptds.ContactCreditPurchases.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CREDITS_Payments:
#region payments
CreditPaymentCashDetails clsCreditPaymentCashDetails = new CreditPaymentCashDetails();
clsCreditPaymentCashDetails.BranchDetails = new BranchDetails()
{
BranchID = Int32.Parse(cboBranch.SelectedItem.Value)
};
clsCreditPaymentCashDetails.TerminalNo = txtTerminalNo.Text.Trim();
clsCreditPaymentCashDetails.PaymentDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentCashDetails.PaymentDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentCashDetails.CreditType = CreditType.Individual;
clsCreditPaymentCashDetails.CreditCardTypeID = Int16.Parse(cboCreditType.SelectedItem.Value);
clsCreditPaymentCashDetails.CreditorLastnameFrom = txtLastNameFrom.Text;
clsCreditPaymentCashDetails.CreditorLastnameTo = txtLastNameTo.Text;
clsContacts = new Data.Contacts();
dt = clsContacts.CreditPaymentCashDetailedAsDataTable(clsCreditPaymentCashDetails, "cci.CreditCardNo");
clsContacts.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.ContactCreditPaymentCash.NewRow();
foreach (DataColumn dc in rptds.ContactCreditPaymentCash.Columns)
{
drNew[dc] = "" + dr[dc.ColumnName];
}
rptds.ContactCreditPaymentCash.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CREDITS_CreditorsLedgerSummary:
#region ledger summary
Data.Billing clsBilling = new Data.Billing();
dt = clsBilling.ListAsDataTable(GuarantorID: 0, CreditCardTypeID: Int16.Parse(cboCreditType.SelectedItem.Value), CreditType: CreditType.Individual, BillingDate: DateTime.Parse(cboBillingDate.SelectedItem.Value), CheckIsBillPrinted: false, SortField: "GUA.ContactName, CUS.ContactName", SortOrder: System.Data.SqlClient.SortOrder.Descending);
clsBilling.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
System.Data.DataRow drNew = rptds.CreditBillHeader.NewRow();
foreach (System.Data.DataColumn dc in rptds.CreditBillHeader.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.CreditBillHeader.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CustomerCreditSummarizedStatistics:
#region CustomerCreditSummarizedStatistics
Data.ContactCreditCardInfos clsContactCreditCardInfos = new Data.ContactCreditCardInfos();
dt = clsContactCreditCardInfos.IHCreditCardSummarizedStatistics(false);
clsContactCreditCardInfos.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CCISummary.NewRow();
foreach (DataColumn dc in rptds.CCISummary.Columns)
{
drNew[dc] = dr[dc.ColumnName];
}
rptds.CCISummary.Rows.Add(drNew);
}
break;
#endregion
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void SetDataSource(ReportDocument Report)
{
DateTime dteRetValue = Constants.C_DATE_MIN_VALUE;
ReportDataset rptds = new ReportDataset();
Data.Contacts clsContacts;
System.Data.DataTable dt;
switch (cboReportType.SelectedItem.Value)
{
case ReportTypes.CREDITS_Purchases:
#region purchases
CreditPaymentDetails clsCreditPaymentDetails = new CreditPaymentDetails();
clsCreditPaymentDetails.BranchDetails = new BranchDetails() { BranchID = Int32.Parse(cboBranch.SelectedItem.Value) };
clsCreditPaymentDetails.TerminalNo = txtTerminalNo.Text.Trim();
clsCreditPaymentDetails.PurchaseDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentDetails.PurchaseDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentDetails.CreditType = CreditType.Individual;
clsCreditPaymentDetails.CreditCardTypeID = Int16.Parse(cboCreditType.SelectedItem.Value);
clsCreditPaymentDetails.CreditorLastnameFrom = txtLastNameFrom.Text;
clsCreditPaymentDetails.CreditorLastnameTo = txtLastNameTo.Text;
clsContacts = new Data.Contacts();
dt = clsContacts.CreditPurchasesAsDataTable(clsCreditPaymentDetails, "cci.CreditCardNo");
clsContacts.CommitAndDispose();
foreach(System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.ContactCreditPurchases.NewRow();
foreach (DataColumn dc in rptds.ContactCreditPurchases.Columns)
drNew[dc] = "" + dr[dc.ColumnName];
rptds.ContactCreditPurchases.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CREDITS_Payments:
#region payments
CreditPaymentCashDetails clsCreditPaymentCashDetails = new CreditPaymentCashDetails();
clsCreditPaymentCashDetails.BranchDetails = new BranchDetails() { BranchID = Int32.Parse(cboBranch.SelectedItem.Value) };
clsCreditPaymentCashDetails.TerminalNo = txtTerminalNo.Text.Trim();
clsCreditPaymentCashDetails.PaymentDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentCashDetails.PaymentDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : Constants.C_DATE_MIN_VALUE;
clsCreditPaymentCashDetails.CreditType = CreditType.Individual;
clsCreditPaymentCashDetails.CreditCardTypeID = Int16.Parse(cboCreditType.SelectedItem.Value);
clsCreditPaymentCashDetails.CreditorLastnameFrom = txtLastNameFrom.Text;
clsCreditPaymentCashDetails.CreditorLastnameTo = txtLastNameTo.Text;
clsContacts = new Data.Contacts();
dt = clsContacts.CreditPaymentCashDetailedAsDataTable(clsCreditPaymentCashDetails, "cci.CreditCardNo");
clsContacts.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
DataRow drNew = rptds.ContactCreditPaymentCash.NewRow();
foreach (DataColumn dc in rptds.ContactCreditPaymentCash.Columns)
drNew[dc] = "" + dr[dc.ColumnName];
rptds.ContactCreditPaymentCash.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CREDITS_CreditorsLedgerSummary:
#region ledger summary
Data.Billing clsBilling = new Data.Billing();
dt = clsBilling.ListAsDataTable(GuarantorID: 0, CreditCardTypeID: Int16.Parse(cboCreditType.SelectedItem.Value), CreditType: CreditType.Individual, BillingDate: DateTime.Parse(cboBillingDate.SelectedItem.Value), CheckIsBillPrinted: false, SortField: "GUA.ContactName, CUS.ContactName", SortOrder: System.Data.SqlClient.SortOrder.Descending);
clsBilling.CommitAndDispose();
foreach (System.Data.DataRow dr in dt.Rows)
{
System.Data.DataRow drNew = rptds.CreditBillHeader.NewRow();
foreach (System.Data.DataColumn dc in rptds.CreditBillHeader.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.CreditBillHeader.Rows.Add(drNew);
}
#endregion
break;
case ReportTypes.CustomerCreditSummarizedStatistics:
#region CustomerCreditSummarizedStatistics
Data.ContactCreditCardInfos clsContactCreditCardInfos = new Data.ContactCreditCardInfos();
dt = clsContactCreditCardInfos.IHCreditCardSummarizedStatistics(false);
clsContactCreditCardInfos.CommitAndDispose();
foreach (DataRow dr in dt.Rows)
{
DataRow drNew = rptds.CCISummary.NewRow();
foreach (DataColumn dc in rptds.CCISummary.Columns)
drNew[dc] = dr[dc.ColumnName];
rptds.CCISummary.Rows.Add(drNew);
}
break;
#endregion
default:
break;
}
Report.SetDataSource(rptds);
SetParameters(Report);
}
private void LoadData()
{
try
{
DateTime dteRetValue = DateTime.MinValue;
Data.CreditPaymentDetails clsCreditPaymentDetails = new Data.CreditPaymentDetails();
clsCreditPaymentDetails.BranchDetails = new Data.BranchDetails();
clsCreditPaymentDetails.TerminalNo = "";
clsCreditPaymentDetails.PurchaseDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : DateTime.Now.AddDays(-60);
clsCreditPaymentDetails.PurchaseDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : DateTime.Now;
clsCreditPaymentDetails.CreditType = CreditType.Both;
clsCreditPaymentDetails.CreditCardTypeID = 0;
clsCreditPaymentDetails.CustomerDetails = mclsCustomerDetails;
Data.Contacts clsContacts = new Data.Contacts();
System.Data.DataTable dt = clsContacts.CreditPurchasesAsDataTable(clsCreditPaymentDetails, "CP.CreditDate");
clsContacts.CommitAndDispose();
System.Data.DataView dv = dt.DefaultView;
dv.Sort = "TransactionDate";
dt = dv.ToTable();
dgvItems.MultiSelect = true;
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 = "Credit";
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 = "Credit Purchase from: " + clsCreditPaymentDetails.PurchaseDateFrom.ToString("MMM dd, yyyy") + " to " + clsCreditPaymentDetails.PurchaseDateTo.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.CreditPaymentDetails clsCreditPaymentDetails = new Data.CreditPaymentDetails();
clsCreditPaymentDetails.BranchDetails = new Data.BranchDetails();
clsCreditPaymentDetails.TerminalNo = "";
clsCreditPaymentDetails.PurchaseDateFrom = DateTime.TryParse(txtTrxStartDate.Text + " 00:00:00", out dteRetValue) ? dteRetValue : DateTime.Now.AddDays(-60);
clsCreditPaymentDetails.PurchaseDateTo = DateTime.TryParse(txtTrxEndDate.Text + " 23:59:59", out dteRetValue) ? dteRetValue : DateTime.Now;
clsCreditPaymentDetails.CreditType = CreditType.Both;
clsCreditPaymentDetails.CreditCardTypeID = 0;
clsCreditPaymentDetails.CustomerDetails = mclsCustomerDetails;
Data.Contacts clsContacts = new Data.Contacts();
System.Data.DataTable dt = clsContacts.CreditPurchasesAsDataTable(clsCreditPaymentDetails, "CP.CreditDate");
clsContacts.CommitAndDispose();
System.Data.DataView dv = dt.DefaultView;
dv.Sort = "TransactionDate";
dt = dv.ToTable();
dgvItems.MultiSelect = true;
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 = "Credit";
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 = "Credit Purchase from: " + clsCreditPaymentDetails.PurchaseDateFrom.ToString("MMM dd, yyyy") + " to " + clsCreditPaymentDetails.PurchaseDateTo.ToString("MMM dd, yyyy");
txtTrxStartDate.SelectAll();
txtTrxStartDate.Select();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,"RetailPlus",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
