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