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); } }