public CreditPaymentDetails setDetails(System.Data.DataRow dr)
{
Data.CreditPaymentDetails Details = new Data.CreditPaymentDetails();
Details.BranchDetails = new Branch(base.Connection, base.Transaction).Details(Int32.Parse(dr["BranchID"].ToString()));
Details.TerminalNo = dr["TerminalNo"].ToString();
Details.SyncID = Int64.Parse(dr["SyncID"].ToString());
Details.CreditPaymentID = Int64.Parse(dr["CreditPaymentID"].ToString());
Details.TransactionID = Int64.Parse(dr["TransactionID"].ToString());
Details.CreditPaymentID = Int64.Parse(dr["CreditPaymentID"].ToString());
Details.CustomerDetails = new Contacts(base.Connection, base.Transaction).Details(Int64.Parse(dr["ContactID"].ToString()));
Details.Amount = decimal.Parse(dr["AmountPaid"].ToString());
Details.TransactionNo = dr["TransactionNo"].ToString();
Details.TransactionDate = DateTime.Parse(dr["CreditDate"].ToString());
Details.CreditBefore = decimal.Parse(dr["CreditBefore"].ToString());
Details.CreditAfter = decimal.Parse(dr["CreditAfter"].ToString());
Details.CreditReason = dr["CreditReason"].ToString();
Details.CashierName = dr["CashierName"].ToString();
Details.AmountPaidCuttOffMonth = decimal.Parse(dr["AmountPaidCuttOffMonth"].ToString());
Details.Remarks = dr["Remarks"].ToString();
Details.TransactionNo = dr["TransactionNo"].ToString();
Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
Details.LastModified = DateTime.Parse(dr["LastModified"].ToString());
return(Details);
}
public Data.PaymentDetails AssignArrayListPayments(ArrayList arrCashPaymentDetails, ArrayList arrChequePaymentDetails, ArrayList arrCreditCardPaymentDetails, ArrayList arrCreditPaymentDetails, ArrayList arrDebitPaymentDetails)
{
Data.CashPaymentDetails[] CashPaymentDetails = new Data.CashPaymentDetails[0];
if (arrCashPaymentDetails.Count > 0)
{
CashPaymentDetails = new Data.CashPaymentDetails[arrCashPaymentDetails.Count];
arrCashPaymentDetails.CopyTo(CashPaymentDetails);
}
Data.ChequePaymentDetails[] ChequePaymentDetails = new Data.ChequePaymentDetails[0];
if (arrChequePaymentDetails.Count > 0)
{
ChequePaymentDetails = new Data.ChequePaymentDetails[arrChequePaymentDetails.Count];
arrChequePaymentDetails.CopyTo(ChequePaymentDetails);
}
Data.CreditCardPaymentDetails[] CreditCardPaymentDetails = new Data.CreditCardPaymentDetails[0];
if (arrCreditCardPaymentDetails.Count > 0)
{
CreditCardPaymentDetails = new Data.CreditCardPaymentDetails[arrCreditCardPaymentDetails.Count];
arrCreditCardPaymentDetails.CopyTo(CreditCardPaymentDetails);
}
Data.CreditPaymentDetails[] CreditPaymentDetails = new Data.CreditPaymentDetails[0];
if (arrCreditPaymentDetails != null && arrCreditPaymentDetails.Count > 0)
{
CreditPaymentDetails = new Data.CreditPaymentDetails[arrCreditPaymentDetails.Count];
arrCreditPaymentDetails.CopyTo(CreditPaymentDetails);
}
Data.DebitPaymentDetails[] DebitPaymentDetails = new Data.DebitPaymentDetails[0];
if (arrDebitPaymentDetails != null && arrDebitPaymentDetails.Count > 0)
{
DebitPaymentDetails = new Data.DebitPaymentDetails[arrDebitPaymentDetails.Count];
arrDebitPaymentDetails.CopyTo(DebitPaymentDetails);
}
if (arrCashPaymentDetails.Count > 0)
for (Int32 i = 0; i < arrCashPaymentDetails.Count;i++ )
{
CashPaymentDetails[i].TransactionID = mclsSalesTransactionDetails.TransactionID;
CashPaymentDetails[i].TransactionNo = mclsSalesTransactionDetails.TransactionNo;
CashPaymentDetails[i].BranchDetails = mclsTerminalDetails.BranchDetails;
CashPaymentDetails[i].TerminalNo = mclsSalesTransactionDetails.TerminalNo;
}
if (arrChequePaymentDetails.Count > 0)
for (Int32 i = 0; i < arrChequePaymentDetails.Count; i++)
{
ChequePaymentDetails[i].TransactionID = mclsSalesTransactionDetails.TransactionID;
ChequePaymentDetails[i].TransactionNo = mclsSalesTransactionDetails.TransactionNo;
ChequePaymentDetails[i].BranchDetails = mclsTerminalDetails.BranchDetails;
ChequePaymentDetails[i].TerminalNo = mclsTerminalDetails.TerminalNo;
}
if (arrCreditCardPaymentDetails.Count > 0)
for (Int32 i = 0; i < arrCreditCardPaymentDetails.Count; i++)
{
CreditCardPaymentDetails[i].TransactionID = mclsSalesTransactionDetails.TransactionID;
CreditCardPaymentDetails[i].TransactionNo = mclsSalesTransactionDetails.TransactionNo;
CreditCardPaymentDetails[i].BranchDetails = mclsTerminalDetails.BranchDetails;
CreditCardPaymentDetails[i].TerminalNo = mclsTerminalDetails.TerminalNo;
}
if (arrCreditPaymentDetails != null && arrCreditPaymentDetails.Count > 0)
for (Int32 i = 0; i < arrCreditPaymentDetails.Count; i++)
{
CreditPaymentDetails[i].TransactionID = mclsSalesTransactionDetails.TransactionID;
CreditPaymentDetails[i].TransactionNo = mclsSalesTransactionDetails.TransactionNo;
CreditPaymentDetails[i].BranchDetails = mclsTerminalDetails.BranchDetails;
CreditPaymentDetails[i].TerminalNo = mclsTerminalDetails.TerminalNo;
}
if (arrDebitPaymentDetails != null && arrDebitPaymentDetails.Count > 0)
for (Int32 i = 0; i < arrDebitPaymentDetails.Count; i++)
{
DebitPaymentDetails[i].TransactionID = mclsSalesTransactionDetails.TransactionID;
DebitPaymentDetails[i].TransactionNo = mclsSalesTransactionDetails.TransactionNo;
DebitPaymentDetails[i].BranchDetails = mclsTerminalDetails.BranchDetails;
DebitPaymentDetails[i].TerminalNo = mclsTerminalDetails.TerminalNo;
}
Data.PaymentDetails Details = new Data.PaymentDetails();
Details.BranchID = mclsTerminalDetails.BranchDetails.BranchID;
Details.TransactionID = mclsSalesTransactionDetails.TransactionID;
Details.arrCashPaymentDetails = CashPaymentDetails;
Details.arrChequePaymentDetails = ChequePaymentDetails;
Details.arrCreditCardPaymentDetails = CreditCardPaymentDetails;
Details.arrCreditPaymentDetails = CreditPaymentDetails;
Details.arrDebitPaymentDetails = DebitPaymentDetails;
return Details;
}
public void SaveCreditPayments(DataGridViewSelectedRowCollection dgvItemsSelectedRows, ArrayList arrCashPaymentDetails, ArrayList arrChequePaymentDetails, ArrayList arrCreditCardPaymentDetails, ArrayList arrCreditPaymentDetails, ArrayList arrDebitPaymentDetails, bool ActivateSuspendedAccount)
{
// save the cashpayments
foreach (Data.CashPaymentDetails det in mclsSalesTransactionDetails.PaymentDetails.arrCashPaymentDetails)
{
//string strRemarks = "PAID BY:" + mclsSalesTransactionDetails.CustomerDetails.ContactName + " PAYMENTTYPE:Cash DATE:" + mclsSalesTransactionDetails.TransactionDate.ToString("MM-dd-yyyy hh:mm:ss tt");
//if (!string.IsNullOrEmpty(det.Remarks)) strRemarks += Environment.NewLine + det.Remarks;
string strRemarks = string.Empty;
decimal decRemainingAmountPaid = det.Amount;
foreach (DataGridViewRow dr in dgvItemsSelectedRows)
{
Int64 intCreditPaymentID = Convert.ToInt64(dr.Cells["CreditPaymentID"].Value.ToString());
Int32 intCPRefBranchID = Convert.ToInt32(dr.Cells["BranchID"].Value.ToString());
string strCPRefTerminalNo = dr.Cells["TerminalNo"].Value.ToString();
decimal decBalance = Convert.ToDecimal(dr.Cells["Balance"].Value.ToString());
if (decRemainingAmountPaid >= decBalance)
{
InsertCreditPaymentCash(intCreditPaymentID, intCPRefBranchID, strCPRefTerminalNo, decBalance, strRemarks, ActivateSuspendedAccount);
dr.Cells["CreditPaid"].Value = decBalance;
dr.Cells["Balance"].Value = 0;
decRemainingAmountPaid -= decBalance;
}
else if (decRemainingAmountPaid > 0 && decRemainingAmountPaid < decBalance)
{
InsertCreditPaymentCash(intCreditPaymentID, intCPRefBranchID, strCPRefTerminalNo, decRemainingAmountPaid, strRemarks, ActivateSuspendedAccount);
//dgItems.Select(itemIndex);
dr.Cells["CreditPaid"].Value = decRemainingAmountPaid;
dr.Cells["Balance"].Value = decBalance - decRemainingAmountPaid;
decRemainingAmountPaid = 0;
break;
}
}
if (decRemainingAmountPaid > 0)
{
//insert a dummy purchase dated Jan 1, 2014 as a reference for paying
Data.CreditPaymentDetails clsCreditPaymentDetails = new Data.CreditPaymentDetails();
clsCreditPaymentDetails.BranchDetails = mclsTerminalDetails.BranchDetails;
clsCreditPaymentDetails.TerminalNo = mclsSalesTransactionDetails.TerminalNo;
clsCreditPaymentDetails.TransactionID = mclsSalesTransactionDetails.TransactionID;
clsCreditPaymentDetails.TransactionNo = mclsSalesTransactionDetails.TransactionNo;
clsCreditPaymentDetails.IsRefund = false;
clsCreditPaymentDetails.TransactionDate = new DateTime(2014, 12, 1); //this should be Dec1,2014 so that it wont include in Billing
clsCreditPaymentDetails.CashierName = "SysUser";
clsCreditPaymentDetails.Amount = decRemainingAmountPaid;
clsCreditPaymentDetails.CustomerDetails = mclsSalesTransactionDetails.CustomerDetails;
clsCreditPaymentDetails.Remarks = "pay-no purchase: deposit " + mclsSalesTransactionDetails.TransactionDate.ToString("yyyy-MM-dd HH:mm:ss");
clsCreditPaymentDetails.CreditReason = "Deposit @ Ter#:" + mclsSalesTransactionDetails.TerminalNo + " Br#:1 trx: " + mclsSalesTransactionDetails.TransactionNo + " date:" + mclsSalesTransactionDetails.TransactionDate.ToString("yyyy-MM-dd HH:mm");
clsCreditPaymentDetails.CreditCardTypeID = mclsContactDetails.CreditDetails.CardTypeDetails.CardTypeID;
Data.CreditPayments clsCreditPayments = new Data.CreditPayments(mConnection, mTransaction);
mConnection = clsCreditPayments.Connection; mTransaction = clsCreditPayments.Transaction;
clsCreditPaymentDetails.CreditPaymentID = clsCreditPayments.Insert(clsCreditPaymentDetails);
clsCreditPayments.CommitAndDispose();
//insert the payment
InsertCreditPaymentCash(clsCreditPaymentDetails.CreditPaymentID, mclsTerminalDetails.BranchDetails.BranchID, mclsSalesTransactionDetails.TerminalNo, decRemainingAmountPaid, "pay-no purchase: deposit", ActivateSuspendedAccount);
}
}
foreach (Data.ChequePaymentDetails det in mclsSalesTransactionDetails.PaymentDetails.arrChequePaymentDetails)
{
//string strRemarks = "PAID BY:" + mclsSalesTransactionDetails.CustomerDetails.ContactName + " PAYMENTTYPE:Cheque DATE:" + mclsSalesTransactionDetails.TransactionDate.ToString("MM-dd-yyyy hh:mm:ss tt");
//if (det.Remarks != null) strRemarks += Environment.NewLine + det.Remarks;
string strRemarks = string.Empty;
decimal decRemainingAmountPaid = det.Amount;
foreach (DataGridViewRow dr in dgvItemsSelectedRows)
{
Int64 intCreditPaymentID = Convert.ToInt64(dr.Cells["CreditPaymentID"].Value.ToString());
Int32 intCPRefBranchID = Convert.ToInt32(dr.Cells["BranchID"].Value.ToString());
string strCPRefTerminalNo = dr.Cells["TerminalNo"].Value.ToString();
decimal decBalance = Convert.ToDecimal(dr.Cells["Balance"].Value.ToString());
if (decRemainingAmountPaid >= decBalance)
{
InsertCreditPaymentCheque(intCreditPaymentID, intCPRefBranchID, strCPRefTerminalNo, det.ChequeNo, decBalance, det.ValidityDate, strRemarks);
dr.Cells["CreditPaid"].Value = decBalance;
dr.Cells["Balance"].Value = 0;
decRemainingAmountPaid -= decBalance;
}
else if (decRemainingAmountPaid > 0 && decRemainingAmountPaid < decBalance)
{
InsertCreditPaymentCheque(intCreditPaymentID, intCPRefBranchID, strCPRefTerminalNo, det.ChequeNo, decRemainingAmountPaid, det.ValidityDate, strRemarks);
//dgItems.Select(itemIndex);
dr.Cells["CreditPaid"].Value = decRemainingAmountPaid;
dr.Cells["Balance"].Value = decBalance - decRemainingAmountPaid;
decRemainingAmountPaid = 0;
break;
}
}
if (decRemainingAmountPaid > 0)
{
//insert a dummy purchase dated Jan 1, 2014 as a reference for paying
Data.CreditPaymentDetails clsCreditPaymentDetails = new Data.CreditPaymentDetails();
clsCreditPaymentDetails.BranchDetails = mclsTerminalDetails.BranchDetails;
clsCreditPaymentDetails.TerminalNo = mclsSalesTransactionDetails.TerminalNo;
clsCreditPaymentDetails.TransactionID = mclsSalesTransactionDetails.TransactionID;
clsCreditPaymentDetails.TransactionNo = mclsSalesTransactionDetails.TransactionNo;
clsCreditPaymentDetails.IsRefund = false;
clsCreditPaymentDetails.TransactionDate = new DateTime(2014, 12, 1); //this should be Dec1,2014 so that it wont include in Billing
clsCreditPaymentDetails.CashierName = "SysUser";
clsCreditPaymentDetails.Amount = decRemainingAmountPaid;
clsCreditPaymentDetails.CustomerDetails = mclsSalesTransactionDetails.CustomerDetails;
clsCreditPaymentDetails.Remarks = "pay-no purchase: deposit " + mclsSalesTransactionDetails.TransactionDate.ToString("yyyy-MM-dd HH:mm:ss");
clsCreditPaymentDetails.CreditReason = "Deposit @ Ter#:" + mclsSalesTransactionDetails.TerminalNo + " Br#:1 trx: " + mclsSalesTransactionDetails.TransactionNo + " date:" + mclsSalesTransactionDetails.TransactionDate.ToString("yyyy-MM-dd HH:mm");
clsCreditPaymentDetails.CreditCardTypeID = mclsContactDetails.CreditDetails.CardTypeDetails.CardTypeID;
Data.CreditPayments clsCreditPayments = new Data.CreditPayments(mConnection, mTransaction);
mConnection = clsCreditPayments.Connection; mTransaction = clsCreditPayments.Transaction;
clsCreditPaymentDetails.CreditPaymentID = clsCreditPayments.Insert(clsCreditPaymentDetails);
clsCreditPayments.CommitAndDispose();
//insert the payment
InsertCreditPaymentCheque(clsCreditPaymentDetails.CreditPaymentID, mclsTerminalDetails.BranchDetails.BranchID, mclsSalesTransactionDetails.TerminalNo, det.ChequeNo, decRemainingAmountPaid, det.ValidityDate, "pay-no purchase: deposit");
}
}
}
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);
}
}
public CreditPaymentDetails setDetails(System.Data.DataRow dr)
{
Data.CreditPaymentDetails Details = new Data.CreditPaymentDetails();
Details.BranchDetails = new Branch(base.Connection, base.Transaction).Details(Int32.Parse(dr["BranchID"].ToString()));
Details.TerminalNo = dr["TerminalNo"].ToString();
Details.SyncID = Int64.Parse(dr["SyncID"].ToString());
Details.CreditPaymentID = Int64.Parse(dr["CreditPaymentID"].ToString());
Details.TransactionID = Int64.Parse(dr["TransactionID"].ToString());
Details.CreditPaymentID = Int64.Parse(dr["CreditPaymentID"].ToString());
Details.CustomerDetails = new Contacts(base.Connection, base.Transaction).Details(Int64.Parse(dr["ContactID"].ToString()));
Details.Amount = decimal.Parse(dr["AmountPaid"].ToString());
Details.TransactionNo = dr["TransactionNo"].ToString();
Details.TransactionDate = DateTime.Parse(dr["CreditDate"].ToString());
Details.CreditBefore = decimal.Parse(dr["CreditBefore"].ToString());
Details.CreditAfter = decimal.Parse(dr["CreditAfter"].ToString());
Details.CreditReason = dr["CreditReason"].ToString();
Details.CashierName = dr["CashierName"].ToString();
Details.AmountPaidCuttOffMonth = decimal.Parse(dr["AmountPaidCuttOffMonth"].ToString());
Details.Remarks = dr["Remarks"].ToString();
Details.TransactionNo = dr["TransactionNo"].ToString();
Details.CreatedOn = DateTime.Parse(dr["CreatedOn"].ToString());
Details.LastModified = DateTime.Parse(dr["LastModified"].ToString());
return Details;
}
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);
}
}
