private void PopulateCustomerFeedback() { DataTable dtInfo = new DataTable(); dtInfo = FlatdetailsBL.PopulateCustomerFeedback(FlatId); gridControl1.DataSource = null; gridView1.Columns.Clear(); gridControl1.DataSource = dtInfo; gridView1.PopulateColumns(); gridView1.OptionsCustomization.AllowFilter = false; gridView1.OptionsBehavior.AllowIncrementalSearch = true; gridView1.OptionsView.ShowFooter = true; gridView1.OptionsView.ColumnAutoWidth = true; gridView1.Appearance.HeaderPanel.Font = new Font(gridView1.Appearance.HeaderPanel.Font, FontStyle.Bold); gridView1.FocusedRowHandle = 0; gridView1.FocusedColumn = gridView1.VisibleColumns[0]; gridView1.OptionsSelection.InvertSelection = true; gridView1.OptionsSelection.EnableAppearanceHideSelection = false; gridView1.Appearance.FocusedRow.BackColor = Color.Teal; gridView1.Appearance.FocusedRow.ForeColor = Color.White; }
private void PopulatePayInfo() { DataTable dtInfo = new DataTable(); dtInfo = FlatdetailsBL.GetPayInfo(FlatId); grdPayInfo.DataSource = null; grdViewPayInfo.Columns.Clear(); grdPayInfo.DataSource = dtInfo; grdViewPayInfo.PopulateColumns(); if (dtInfo.Rows.Count > 1) { m_sCCName = dtInfo.Rows[1]["CostCentreName"].ToString(); m_sBuyerName = dtInfo.Rows[1]["LeadName"].ToString(); m_sFlatType = dtInfo.Rows[1]["TypeName"].ToString(); m_sBlockName = dtInfo.Rows[1]["BlockName"].ToString(); m_sLevelName = dtInfo.Rows[1]["LevelName"].ToString(); } grdViewPayInfo.Columns["CostCentreName"].Visible = false; grdViewPayInfo.Columns["LeadName"].Visible = false; grdViewPayInfo.Columns["TypeName"].Visible = false; grdViewPayInfo.Columns["BlockName"].Visible = false; grdViewPayInfo.Columns["LevelName"].Visible = false; grdViewPayInfo.Columns["ReceiptId"].Visible = false; grdViewPayInfo.Columns["QualifierId"].Visible = false; grdViewPayInfo.Columns["NetPer"].Visible = false; grdViewPayInfo.Columns["BankName"].ColumnEdit = repositoryItemMemoEdit1; grdViewPayInfo.Columns["PaymentMode"].ColumnEdit = repositoryItemMemoEdit1; grdViewPayInfo.Columns["ChequeNo"].ColumnEdit = repositoryItemMemoEdit1; grdViewPayInfo.Columns["Amount"].ColumnEdit = repositoryItemMemoEdit1; grdViewPayInfo.Columns["Amount"].OptionsColumn.AllowEdit = false; grdViewPayInfo.Columns["Amount"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; grdViewPayInfo.Columns["Amount"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat; grdViewPayInfo.Columns["Amount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewPayInfo.Columns["Amount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdViewPayInfo.OptionsCustomization.AllowFilter = false; grdViewPayInfo.OptionsBehavior.AllowIncrementalSearch = true; grdViewPayInfo.OptionsView.ShowFooter = true; grdViewPayInfo.OptionsView.ColumnAutoWidth = true; grdViewPayInfo.Appearance.HeaderPanel.Font = new Font(grdViewPayInfo.Appearance.HeaderPanel.Font, FontStyle.Bold); grdViewPayInfo.FocusedRowHandle = 0; grdViewPayInfo.FocusedColumn = grdViewPayInfo.VisibleColumns[0]; grdViewPayInfo.OptionsSelection.InvertSelection = true; grdViewPayInfo.OptionsSelection.EnableAppearanceHideSelection = false; grdViewPayInfo.Appearance.FocusedRow.BackColor = Color.Teal; grdViewPayInfo.Appearance.FocusedRow.ForeColor = Color.White; }
private void ToFlatDetails() { DataTable dtFlat = new DataTable(); dtFlat = FlatdetailsBL.GetToFlatDetails(m_iCCId); cboToFlat.Properties.DataSource = dtFlat; cboToFlat.Properties.PopulateColumns(); cboToFlat.Properties.DisplayMember = "FlatNo"; cboToFlat.Properties.ValueMember = "FlatId"; cboToFlat.Properties.ShowHeader = false; cboToFlat.Properties.ShowFooter = false; cboToFlat.Properties.Columns["FlatId"].Visible = false; cboToFlat.Properties.Columns["FlatTypeId"].Visible = false; }
public void Fill_FlatArea() { DGVTrans.DataSource = null; DataTable dt = new DataTable(); if (m_sType == "FlatType") { dt = FlatdetailsBL.GetFlatTypeArea(m_iFlatTypeId); DGVTrans.DataSource = dt; dgvTransView.Columns["FlatTypeId"].Visible = false; } else if (m_sType == "FlatDet") { dt = FlatdetailsBL.GetFlatArea(m_iFlatId); DGVTrans.DataSource = dt; } FlatAreaGrid(); }
private void PopulateGrid() { DataTable dt = new DataTable(); dt = FlatdetailsBL.GetAllotmentRegister(m_iCCId); grdCancel.DataSource = dt; grdCancelView.PopulateColumns(); //grdCancelView.Columns["CostCentreId"].Visible = false; grdCancelView.Columns["CancelId"].Visible = false; //grdCancelView.Columns["CostCentreId"].OptionsColumn.ShowInCustomizationForm = false; //grdCancelView.Columns["CancelId"].OptionsColumn.ShowInCustomizationForm = false; grdCancelView.Columns["CancelDate"].Width = 100; grdCancelView.Columns["CostCentreName"].Width = 150; grdCancelView.Columns["BuyerName"].Width = 120; grdCancelView.Columns["AllotmentNo"].Width = 100; grdCancelView.Columns["FlatNo"].Width = 100; grdCancelView.Columns["Area"].Width = 100; grdCancelView.Columns["NetAmount"].Width = 120; grdCancelView.Columns["PenaltyAmt"].Width = 120; grdCancelView.Columns["BalanceAmount"].Width = 120; grdCancelView.Columns["TotalCarParking"].Width = 120; grdCancelView.Columns["Approve"].Width = 100; grdCancelView.Columns["Area"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdCancelView.Columns["NetAmount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdCancelView.Columns["PenaltyAmt"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdCancelView.Columns["BalanceAmount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdCancelView.Columns["TotalCarParking"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdCancelView.Columns["Approve"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; grdCancelView.Columns["Approve"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; grdCancelView.FocusedRowHandle = 0; grdCancelView.FocusedColumn = grdCancelView.VisibleColumns[0]; grdCancelView.OptionsSelection.InvertSelection = true; grdCancelView.OptionsSelection.EnableAppearanceHideSelection = false; grdCancelView.Appearance.FocusedRow.BackColor = Color.Teal; grdCancelView.Appearance.FocusedRow.ForeColor = Color.White; grdCancelView.OptionsView.ColumnAutoWidth = true; dt.Dispose(); }
private void UpdateValues() { DataTable dt = new DataTable(); DataTable dtM = new DataTable(); dtM = DGVTrans.DataSource as DataTable; DataView dv = new DataView(dtM); dt = dv.ToTable(); if (m_sType == "FlatType") { FlatdetailsBL.InsertFlatTypeArea(dt, m_iFlatTypeId); } else if (m_sType == "FlatDet") { FlatdetailsBL.InsertFlatArea(dt, m_iFlatId); } }
private void PopulateReport() { DataTable dt = new DataTable(); dt = FlatdetailsBL.PopulateChangedBuyerName(m_iCCId); if (dt == null) { return; } gridControl1.DataSource = dt; gridControl1.ForceInitialize(); gridView1.PopulateColumns(); gridView1.OptionsSelection.InvertSelection = true; gridView1.OptionsSelection.EnableAppearanceHideSelection = false; gridView1.Appearance.FocusedRow.BackColor = Color.Teal; gridView1.Appearance.FocusedRow.ForeColor = Color.White; gridView1.BestFitColumns(); }
public void FillData() { DataTable dtInfo = new DataTable(); dtInfo = FlatdetailsBL.GetBuyerInfo(m_iFlatId, cboSOA.EditValue.ToString(), m_bPayTypewise); DgvBuyer.DataSource = null; DgvBuyerView.Columns.Clear(); DgvBuyer.DataSource = dtInfo; DgvBuyerView.PopulateColumns(); DgvBuyerView.Columns["CumulativeAmount"].Visible = false; DgvBuyerView.Columns["PBNo"].Caption = "PBill No"; DgvBuyerView.Columns["AsOnDate"].Caption = "Ref Date"; DgvBuyerView.Columns["BillAmount"].Caption = "Payable"; DgvBuyerView.Columns["PaidAmount"].Caption = "Paid"; DgvBuyerView.Columns["BillAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; DgvBuyerView.Columns["PaidAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; DgvBuyerView.Columns["Balance"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; DgvBuyerView.OptionsCustomization.AllowFilter = false; DgvBuyerView.OptionsBehavior.AllowIncrementalSearch = true; DgvBuyerView.OptionsView.ShowAutoFilterRow = false; DgvBuyerView.OptionsView.ShowViewCaption = false; DgvBuyerView.OptionsView.ShowFooter = true; DgvBuyerView.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect; DgvBuyerView.OptionsSelection.InvertSelection = false; DgvBuyerView.OptionsView.ColumnAutoWidth = true; DgvBuyerView.Appearance.HeaderPanel.Font = new Font(DgvBuyerView.Appearance.HeaderPanel.Font, FontStyle.Bold); DgvBuyerView.FocusedRowHandle = 0; DgvBuyerView.FocusedColumn = DgvBuyerView.VisibleColumns[0]; DgvBuyerView.Appearance.FocusedCell.BackColor = Color.Teal; DgvBuyerView.Appearance.FocusedCell.ForeColor = Color.White; DgvBuyerView.Appearance.FocusedRow.ForeColor = Color.Black; DgvBuyerView.Appearance.FocusedRow.BackColor = Color.Teal; DgvBuyerView.OptionsSelection.EnableAppearanceHideSelection = false; }
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (BsfGlobal.FindPermission("Flat-Transfer") == false) { MessageBox.Show("You don't have Rights to Flat-Transfer"); return; } int iNewFlatId = Convert.ToInt32(CommFun.IsNullCheck(cboToFlat.EditValue, CommFun.datatypes.vartypenumeric)); if (iNewFlatId < 0) { MessageBox.Show("Select To Flat"); return; } DialogResult result1 = MessageBox.Show("Are you sure to Flat-Transfer", "Flat-Transfer", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result1 == DialogResult.Yes) { FlatdetailsBL.UpdateFlatTransfer(iNewFlatId, m_iFlatId, m_iLeadId); } Close(); }
private void cboBrokerName_EditValueChanged(object sender, EventArgs e) { if (bedit == true) { return; } DataTable dtB = new DataTable(); int iSORegId = 0; string sCommType = ""; decimal dNetAmt = 0; decimal dPer = 0; decimal dAmt = 0; string sPerBased = ""; if (Convert.ToInt32(cboBrokerName.EditValue) != 0) { DevExpress.XtraEditors.LookUpEdit editor = (DevExpress.XtraEditors.LookUpEdit)sender; DataRowView dr = editor.Properties.GetDataSourceRowByKeyValue(editor.EditValue) as DataRowView; if (dr != null) { string BrokerName = CommFun.IsNullCheck(dr["BrokerName"], CommFun.datatypes.vartypestring).ToString(); m_iBrokerId = Convert.ToInt32(dr["BrokerId"]); iSORegId = Convert.ToInt32(dr["SORegisterId"]); } if (cboBrokerName.Text == "None") { lblCommision.Enabled = false; lblCommisionAmt.Enabled = false; txtCommisionAmt.Enabled = false; txtCommision.Enabled = false; txtCommision.Text = "0.00"; txtCommisionAmt.Text = "0.00"; } else { lblCommision.Enabled = true; lblCommisionAmt.Enabled = true; txtCommisionAmt.Enabled = true; txtCommision.Enabled = true; dtB = FlatdetailsBL.GetBrokerComm(iSORegId, m_iCCID, m_iBrokerId); if (dtB.Rows.Count > 0) { sCommType = dtB.Rows[0]["CommType"].ToString(); dPer = Convert.ToDecimal(dtB.Rows[0]["Percentage"]); dAmt = Convert.ToDecimal(dtB.Rows[0]["Amount"]); sPerBased = dtB.Rows[0]["PerBased"].ToString(); if (sPerBased == "N") { dNetAmt = m_dNetAmt; } else if (sPerBased == "B") { dNetAmt = m_dBaseAmount; } if (sCommType == "P") { txtCommision.EditValue = dPer; txtCommisionAmt.EditValue = decimal.Round(dNetAmt * dPer / 100, 3); } else if (sCommType == "A") { txtCommision.EditValue = decimal.Round(dAmt / dNetAmt * 100, 3); txtCommisionAmt.EditValue = dAmt; } } else { txtCommision.Text = "0"; txtCommisionAmt.Text = "0"; } } } #region Broker //if (Convert.ToInt32(cboBrokerName.EditValue) != 0) //{ // DevExpress.XtraEditors.LookUpEdit editor = (DevExpress.XtraEditors.LookUpEdit)sender; // DataRowView dr = editor.Properties.GetDataSourceRowByKeyValue(editor.EditValue) as DataRowView; // string BrokerName = dr["BrokerName"].ToString(); // m_iBrokerId = Convert.ToInt32(dr["BrokerId"]); // if (cboBrokerName.Text == "None") // { // lblCommision.Enabled = false; // lblCommisionAmt.Enabled = false; // txtCommisionAmt.Enabled = false; // txtCommision.Enabled = false; // txtCommision.Text = "0.00"; // txtCommisionAmt.Text = "0.00"; // } // else // { // lblCommision.Enabled = true; // lblCommisionAmt.Enabled = true; // txtCommisionAmt.Enabled = true; // txtCommision.Enabled = true; // SqlCommand cmd; // SqlDataReader dr12; // //string Sql = "select A.BName,B.CommPer from BrokerDet A Inner Join BrokerCC B on A.BrokerId=B.BrokerId where B.BrokerId=" + i_BrokId; // string Sql = "Select C.VendorName BrokerName,B.CommPer From BrokerDet A " + // " Inner Join BrokerCC B On A.BrokerId=B.BrokerId " + // " Inner Join [" + BsfGlobal.g_sVendorDBName + "].dbo.VendorMaster C On C.VendorId=A.VendorId" + // " Where B.BrokerId=" + m_iBrokerId + " And B.CostCentreId=" + m_iCCID + ""; // cmd = new SqlCommand(Sql, BsfGlobal.OpenCRMDB()); // dr12 = cmd.ExecuteReader(); // dr12.Read(); // if (dr12.HasRows) // { // txtCommision.Text = dr12["CommPer"].ToString(); // decimal dNetAmt = m_dBaseAmount; // decimal dComP = Convert.ToDecimal(CommFun.IsNullCheck(txtCommision.Text, CommFun.datatypes.vartypenumeric)); // decimal dBrokerAmt = 0; // if (dComP != 0) { dBrokerAmt = dNetAmt * dComP / 100; } // txtCommisionAmt.Text = CommFun.FormatNum(dBrokerAmt.ToString(), 2); // } // else // { // txtCommision.Text = "0.00"; // txtCommisionAmt.Text = "0.00"; // } // } //} #endregion }
private void PopulateBuyerInfo() { DataTable dtInfo = new DataTable(); dtInfo = FlatdetailsBL.GetClientBuyerInfo(FlatId, m_iLandRegId, cboType.EditValue.ToString()); grdSOA.DataSource = null; grdViewSOA.Columns.Clear(); grdSOA.DataSource = dtInfo; if (dtInfo.Rows.Count > 0) { decimal dAmt = 0; for (int i = 0; i < dtInfo.Rows.Count; i++) { dAmt = dAmt + Convert.ToDecimal(dtInfo.Rows[i]["Balance"]); dtInfo.Rows[i]["CumulativeAmount"] = dAmt; } } grdViewSOA.PopulateColumns(); grdViewSOA.Columns["PBNo"].Caption = "PBill No"; grdViewSOA.Columns["AsOnDate"].Caption = "Ref Date"; grdViewSOA.Columns["BillAmount"].Caption = "Payable"; grdViewSOA.Columns["PaidAmount"].Caption = "Paid"; grdViewSOA.Columns["CumulativeAmount"].Visible = false; RepositoryItemTextEdit txtCumAmt = new RepositoryItemTextEdit(); grdViewSOA.Columns["CumulativeAmount"].ColumnEdit = txtCumAmt; txtCumAmt.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; txtCumAmt.DisplayFormat.FormatString = "f3"; txtCumAmt.Mask.EditMask = "f3"; txtCumAmt.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; txtCumAmt.Mask.UseMaskAsDisplayFormat = true; grdViewSOA.Columns["BillAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewSOA.Columns["PaidAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewSOA.Columns["Balance"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewSOA.Columns["CumulativeAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom; grdViewSOA.Columns["BillAmount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewSOA.Columns["PaidAmount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewSOA.Columns["Balance"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewSOA.Columns["CumulativeAmount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdViewSOA.OptionsCustomization.AllowFilter = false; grdViewSOA.OptionsBehavior.AllowIncrementalSearch = true; grdViewSOA.OptionsView.ShowAutoFilterRow = false; grdViewSOA.OptionsView.ShowViewCaption = false; grdViewSOA.OptionsView.ShowFooter = true; grdViewSOA.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect; grdViewSOA.OptionsSelection.InvertSelection = false; grdViewSOA.OptionsView.ColumnAutoWidth = true; grdViewSOA.Appearance.HeaderPanel.Font = new Font(grdViewSOA.Appearance.HeaderPanel.Font, FontStyle.Bold); grdViewSOA.FocusedRowHandle = 0; grdViewSOA.FocusedColumn = grdViewSOA.VisibleColumns[0]; grdViewSOA.Appearance.FocusedCell.BackColor = Color.Teal; grdViewSOA.Appearance.FocusedCell.ForeColor = Color.White; grdViewSOA.Appearance.FocusedRow.ForeColor = Color.Teal; grdViewSOA.Appearance.FocusedRow.BackColor = Color.White; grdViewSOA.OptionsSelection.EnableAppearanceHideSelection = false; }
public void FillData() { DataTable dt = new DataTable(); DataTable dtInterest = new DataTable(); dt = FlatdetailsBL.GetInterest(m_iFlatId, m_sType, Convert.ToDateTime(dEAsOnDate.EditValue), m_iCreditDays); dtInterest = dt.Clone(); dtInterest.Columns.Add("Balance", typeof(decimal)); dtInterest.Columns.Add("Days", typeof(int)); dtInterest.Columns.Add("Interest", typeof(decimal)); #region for Interest Calculation for (int i = 0; i < dt.Rows.Count; i++) { string sType = Convert.ToString(dt.Rows[i]["Type"]); if (sType == "P") { string sPayDesc = Convert.ToString(dt.Rows[i]["Description"]); DateTime dFinaliseDate = Convert.ToDateTime(CommFun.IsNullCheck(dt.Rows[i]["FinaliseDate"], CommFun.datatypes.VarTypeDate)); DateTime dCompletionDate = Convert.ToDateTime(CommFun.IsNullCheck(dt.Rows[i]["Date"], CommFun.datatypes.VarTypeDate)); int iCreditDays = Convert.ToInt32(dt.Rows[i]["CreditDays"]); int iPaySchId = Convert.ToInt32(dt.Rows[i]["PaymentSchId"]); decimal dIntPer = Convert.ToDecimal(dt.Rows[i]["IntPercent"]); DataRow dRow = dtInterest.NewRow(); dRow["PaymentSchId"] = iPaySchId; dRow["SortOrder"] = dt.Rows[i]["SortOrder"]; dRow["Date"] = dCompletionDate; dRow["Description"] = dt.Rows[i]["Description"]; dRow["Receivable"] = dt.Rows[i]["Receivable"]; dRow["Received"] = dt.Rows[i]["Received"]; dRow["CreditDays"] = iCreditDays; dRow["FinaliseDate"] = dFinaliseDate; dRow["Type"] = dt.Rows[i]["Type"]; dtInterest.Rows.Add(dRow); DateTime dInterestDate; if (m_sType == "S") { if (dCompletionDate > dFinaliseDate) { dInterestDate = dCompletionDate; } else { dInterestDate = dFinaliseDate; } } else { dInterestDate = dCompletionDate; } DataView dv = new DataView(dt) { RowFilter = String.Format("PaymentSchId={0} AND Type='R'", iPaySchId) }; DataTable dtRec = new DataTable(); dtRec = dv.ToTable(); decimal dReceivable = Convert.ToDecimal(dt.Rows[i]["Receivable"]); decimal dBalance = dReceivable; DateTime dCalInterestDate = dInterestDate; if (dtRec.Rows.Count == 0) { dInterestDate = dInterestDate.AddDays(iCreditDays); } else { for (int j = 0; j < dtRec.Rows.Count; j++) { dRow = dtInterest.NewRow(); dRow["PaymentSchId"] = dtRec.Rows[j]["PaymentSchId"]; dRow["SortOrder"] = dtRec.Rows[j]["SortOrder"]; dRow["Date"] = dtRec.Rows[j]["Date"]; dRow["Description"] = dtRec.Rows[j]["Description"]; decimal dReceived = Convert.ToDecimal(dtRec.Rows[j]["Received"]); dRow["Received"] = dReceived; dRow["CreditDays"] = dtRec.Rows[j]["CreditDays"]; dRow["FinaliseDate"] = dtRec.Rows[j]["FinaliseDate"]; dRow["Type"] = dtRec.Rows[j]["Type"]; DateTime dRecdDate = Convert.ToDateTime(dtRec.Rows[j]["Date"]); if (dRecdDate < dInterestDate) { dRecdDate = dCompletionDate; } if (j == 0) { dCalInterestDate = dInterestDate; dCalInterestDate = dCalInterestDate.AddDays(iCreditDays); } else { dCalInterestDate = dInterestDate; } TimeSpan ts = dRecdDate - dCalInterestDate; int iDays = ts.Days; if (iDays < 0) { iDays = 0; } dRow["Days"] = iDays; decimal dInterest = 0; if (dBalance == 0) { dInterest = 0; } else if (iDays == 0) { dInterest = 0; } else if (dIntPer == 0) { dInterest = 0; } else { dInterest = decimal.Round((dBalance * dIntPer * iDays) / 36500, 3); } dRow["Interest"] = dInterest; dBalance = dBalance - dReceived; if (dBalance < 0) { dRow["Balance"] = 0; } else { dRow["Balance"] = dBalance; } dtInterest.Rows.Add(dRow); dInterestDate = dRecdDate; //dBalance = 0; } } if (dBalance > 0) { dRow = dtInterest.NewRow(); dRow["PaymentSchId"] = iPaySchId; dRow["Date"] = m_dAsOnDate.ToString("dd-MMM-yyyy"); dRow["Description"] = "Interest Payable (" + sPayDesc + ") As On -" + m_dAsOnDate.ToShortDateString(); dRow["CreditDays"] = iCreditDays; dRow["IntPercent"] = dIntPer; dRow["Balance"] = dBalance; TimeSpan ts = m_dAsOnDate - dInterestDate; int iDays = ts.Days; if (iDays < 0) { iDays = 0; } dRow["Days"] = iDays; decimal dInterest = 0; if (dBalance == 0) { dInterest = 0; } else if (iDays == 0) { dInterest = 0; } else if (dIntPer == 0) { dInterest = 0; } else { dInterest = decimal.Round((dBalance * dIntPer / 36500) * iDays, 3); } dRow["Interest"] = dInterest; dtInterest.Rows.Add(dRow); } dBalance = 0; } } #endregion //DataRow dr; //dr = dt.NewRow(); //dr["Date"] = Convert.ToDateTime(dEAsOnDate.EditValue).ToString("dd-MMM-yyyy"); //dr["Description"] = "Interest Payable"; //dr["Receivable"] = 0; //dr["Received"] = 0; //dr["CreditDays"] = 0; //dr["IntPercent"] = 0; //dr["Balance"] = 0; //dr["Days"] = iCreditDays; //dr["Interest"] = decimal.Round((dBal * dIntPer / 36500) * iCreditDays, 3); ; //dt.Rows.Add(dr); grdInt.DataSource = dtInterest; grdIntView.PopulateColumns(); grdInt.ForceInitialize(); grdIntView.BestFitColumns(); grdIntView.Columns["PaymentSchId"].Visible = false; grdIntView.Columns["FlatId"].Visible = false; grdIntView.Columns["SortOrder"].Visible = false; grdIntView.Columns["CreditDays"].Visible = false; grdIntView.Columns["IntPercent"].Visible = false; grdIntView.Columns["FinaliseDate"].Visible = false; grdIntView.Columns["Type"].Visible = false; grdIntView.Columns["Receivable"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdIntView.Columns["Received"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdIntView.Columns["Interest"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdIntView.Columns["Days"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; grdIntView.Columns["Days"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; grdIntView.Columns["Interest"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdIntView.Columns["Balance"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdIntView.Columns["Receivable"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; grdIntView.Columns["Receivable"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormatS; grdIntView.Columns["Receivable"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdIntView.Columns["Receivable"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdIntView.Columns["Received"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; grdIntView.Columns["Received"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormatS; grdIntView.Columns["Received"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdIntView.Columns["Received"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdIntView.Columns["Balance"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; grdIntView.Columns["Balance"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormatS; grdIntView.Columns["Balance"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdIntView.Columns["Balance"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdIntView.Columns["Interest"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; grdIntView.Columns["Interest"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormatS; grdIntView.Columns["Interest"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdIntView.Columns["Interest"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdIntView.Appearance.HeaderPanel.Font = new Font(grdIntView.Appearance.HeaderPanel.Font, FontStyle.Bold); grdIntView.OptionsSelection.InvertSelection = true; grdIntView.OptionsSelection.EnableAppearanceHideSelection = false; grdIntView.Appearance.FocusedRow.ForeColor = Color.White; grdIntView.Appearance.FocusedRow.BackColor = Color.Teal; grdIntView.OptionsView.ColumnAutoWidth = true; }
public void FillSOAData() { DataTable dt = new DataTable(); dt = FlatdetailsBL.GetSOA(m_iFlatId, m_sType, m_dAsOnDate, m_iCreditDays); dt.Columns.Add("Balance", typeof(decimal)); dt.Columns.Add("Days", typeof(int)); dt.Columns.Add("Interest", typeof(decimal)); for (int i = 0; i < dt.Rows.Count; i++) { int iCreditDays = Convert.ToInt32(dt.Rows[i]["CreditDays"]); if (i == 0) { decimal dIntPer = Convert.ToDecimal(dt.Rows[i]["IntPercent"]); decimal dReceivable = Convert.ToDecimal(dt.Rows[i]["Receivable"]); decimal dReceived = Convert.ToDecimal(dt.Rows[i]["Received"]); DateTime FromDate = Convert.ToDateTime(dt.Rows[i]["Date"]); DateTime ToDate = Convert.ToDateTime(dt.Rows[i]["Date"]); TimeSpan ts = ToDate - FromDate; int iDays = ts.Days; if (iDays < 0) { iDays = 0; } //decimal dBalance = 0; //decimal dInt = decimal.Round((dBalance * dIntPer / 36500) * iDays, 3); dt.Rows[i]["Balance"] = 0; dt.Rows[i]["Days"] = iDays; dt.Rows[i]["Interest"] = 0; } else { decimal dIntPer = Convert.ToDecimal(dt.Rows[i - 1]["IntPercent"]); decimal dReceivable = Convert.ToDecimal(dt.Rows[i - 1]["Receivable"]); decimal dReceived = Convert.ToDecimal(dt.Rows[i - 1]["Received"]); DateTime FromDate = Convert.ToDateTime(dt.Rows[i - 1]["Date"]); DateTime ToDate = Convert.ToDateTime(dt.Rows[i]["Date"]); if (FromDate.AddDays(m_iCreditDays) <= ToDate) { FromDate = FromDate.AddDays(m_iCreditDays); } //FromDate = FromDate.AddDays(m_iCreditDays); TimeSpan ts = ToDate - FromDate; //ts = FromDate - ToDate; int iDays = ts.Days; if (iDays < 0) { iDays = 0; } decimal dBal = (dReceivable + Convert.ToDecimal(dt.Rows[i - 1]["Balance"])) - dReceived; decimal dInt = decimal.Round((dBal * dIntPer / 36500) * iDays, 3); dt.Rows[i]["Balance"] = dBal; dt.Rows[i]["Days"] = iDays; dt.Rows[i]["Interest"] = dInt; } } grdInt.DataSource = dt; grdIntView.PopulateColumns(); grdInt.ForceInitialize(); grdIntView.BestFitColumns(); grdIntView.Columns["SortOrder"].Visible = false; grdIntView.Columns["CreditDays"].Visible = false; grdIntView.Columns["IntPercent"].Visible = false; grdIntView.Columns["Interest"].Visible = false; grdIntView.Columns["Days"].Visible = false; grdIntView.Columns["BillNo"].Caption = "Bill/Receipt No"; grdIntView.Columns["Receivable"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdIntView.Columns["Receivable"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdIntView.Columns["Received"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdIntView.Columns["Received"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdIntView.Columns["Interest"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdIntView.Columns["Interest"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdIntView.Appearance.HeaderPanel.Font = new Font(grdIntView.Appearance.HeaderPanel.Font, FontStyle.Bold); grdIntView.Appearance.FocusedCell.BackColor = Color.Teal; grdIntView.Appearance.FocusedCell.ForeColor = Color.White; grdIntView.Appearance.FocusedRow.ForeColor = Color.Black; grdIntView.Appearance.FocusedRow.BackColor = Color.Teal; grdIntView.OptionsSelection.EnableAppearanceHideSelection = false; }