private void PopulateFlatDetails()
{
DataTable dtFlat = new DataTable();
dtFlat = ClientBL.GetFlatDetails(EnqId, m_FlatId);
grdFlatDetails.DataSource = dtFlat;
FlatView.Columns["CostCentreId"].Visible = false;
FlatView.Columns["LandRegisterId"].Visible = false;
FlatView.Columns["FlatId"].Visible = false;
FlatView.Columns["FlatNo"].Caption = CommFun.m_sFuncName + "/Plot No";
FlatView.Columns["FlatType"].Caption = CommFun.m_sFuncName + "/Plot Type";
if (dtFlat.Rows.Count > 0)
{
FlatId = Convert.ToInt32(CommFun.IsNullCheck(FlatView.GetFocusedRowCellValue("FlatId"), CommFun.datatypes.vartypenumeric));
CCId = Convert.ToInt32(CommFun.IsNullCheck(FlatView.GetFocusedRowCellValue("CostCentreId"), CommFun.datatypes.vartypenumeric));
m_iLandRegId = Convert.ToInt32(CommFun.IsNullCheck(FlatView.GetFocusedRowCellValue("LandRegisterId"), CommFun.datatypes.vartypenumeric));
}
if (m_iLandRegId != 0)
{
dtPaySchedule = PaymentScheduleBL.GetPaymentSchedulePlot(m_iLandRegId, FlatId);
}
else
{
dtPaySchedule = PaymentScheduleBL.GetPaymentScheduleFlat(CCId, FlatId);
}
grdPayment.DataSource = dtPaySchedule;
if (dtPaySchedule.Rows.Count > 0)
{
decimal dAmt = 0;
for (int i = 0; i < dtPaySchedule.Rows.Count; i++)
{
dAmt = dAmt + Convert.ToDecimal(dtPaySchedule.Rows[i]["NetAmount"]);
dtPaySchedule.Rows[i]["CumulativeAmount"] = dAmt;
}
}
PaymentView.Columns["PaymentSchId"].Visible = false;
PaymentView.Columns["TemplateId"].Visible = false;
if (m_iLandRegId == 0)
{
PaymentView.Columns["BlockName"].Visible = false;
PaymentView.Columns["LevelName"].Visible = false;
}
PaymentView.Columns["SchType"].Visible = false;
PaymentView.Columns["CumulativeAmount"].Visible = false;
RepositoryItemTextEdit txtAmtEdit = new RepositoryItemTextEdit();
PaymentView.Columns["NetAmount"].ColumnEdit = txtAmtEdit;
txtAmtEdit.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
txtAmtEdit.DisplayFormat.FormatString = "f3";
txtAmtEdit.Mask.EditMask = "f3";
txtAmtEdit.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
txtAmtEdit.Mask.UseMaskAsDisplayFormat = true;
RepositoryItemTextEdit txtCumAmt = new RepositoryItemTextEdit();
PaymentView.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;
PaymentView.Columns["SchPercent"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
PaymentView.Columns["Amount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
PaymentView.Columns["NetAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
PaymentView.Columns["CumulativeAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
PaymentView.Columns["SchPercent"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
PaymentView.Columns["Amount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
PaymentView.Columns["NetAmount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
PaymentView.Columns["CumulativeAmount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
PaymentView.Columns["SchPercent"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
PaymentView.Columns["Amount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
PaymentView.Columns["NetAmount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
PaymentView.Columns["CumulativeAmount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
PanelProgress.Controls.Clear();
frmFlatTrans frmT = new frmFlatTrans();
frmT.Dock = DockStyle.Fill;
frmT.TopLevel = false;
frmT.FormBorderStyle = FormBorderStyle.None;
PanelProgress.Controls.Add(frmT);
frmT.Execute(FlatId);
int LandId = Convert.ToInt32(CommFun.IsNullCheck(FlatView.GetFocusedRowCellValue("LandRegisterId"), CommFun.datatypes.vartypenumeric));
frmProgressChart frmP = new frmProgressChart();
PanelProgress.Controls.Clear();
frmP.Dock = DockStyle.Fill;
frmP.TopLevel = false;
frmP.FormBorderStyle = FormBorderStyle.None;
PanelProgress.Controls.Add(frmP);
frmP.m_iLandId = LandId;
if (cboCheckList.EditValue.ToString() == "Handing Over")
{
frmP.Execute(FlatId, false, "H");
}
else if (cboCheckList.EditValue.ToString() == "Works")
{
frmP.Execute(FlatId, false, "W");
}
else if (cboCheckList.EditValue.ToString() == "Finalization")
{
frmP.Execute(FlatId, false, "F");
}
else if (cboCheckList.EditValue.ToString() == "Cancellation")
{
frmP.Execute(FlatId, false, "C");
}
PopulatePayInfo();
FlatView.Appearance.HeaderPanel.Font = new Font(FlatView.Appearance.HeaderPanel.Font, FontStyle.Bold);
FlatView.Appearance.FocusedCell.BackColor = Color.Teal;
FlatView.Appearance.FocusedCell.ForeColor = Color.White;
FlatView.Appearance.FocusedRow.ForeColor = Color.Teal;
FlatView.Appearance.FocusedRow.BackColor = Color.White;
FlatView.OptionsSelection.EnableAppearanceHideSelection = false;
PaymentView.Appearance.HeaderPanel.Font = new Font(PaymentView.Appearance.HeaderPanel.Font, FontStyle.Bold);
PaymentView.Appearance.FocusedCell.BackColor = Color.Teal;
PaymentView.Appearance.FocusedCell.ForeColor = Color.White;
PaymentView.Appearance.FocusedRow.ForeColor = Color.Teal;
PaymentView.Appearance.FocusedRow.BackColor = Color.White;
PaymentView.OptionsSelection.EnableAppearanceHideSelection = false;
}
private void FlatView_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
CCId = Convert.ToInt32(FlatView.GetFocusedRowCellValue("CostCentreId"));
FlatId = Convert.ToInt32(FlatView.GetFocusedRowCellValue("FlatId"));
m_sFlatNo = FlatView.GetFocusedRowCellValue("FlatNo").ToString();
m_iLandRegId = Convert.ToInt32(CommFun.IsNullCheck(FlatView.GetFocusedRowCellValue("LandRegisterId"), CommFun.datatypes.vartypenumeric));
if (m_iLandRegId != 0)
{
dtPaySchedule = PaymentScheduleBL.GetPaymentSchedulePlot(m_iLandRegId, FlatId);
}
else
{
dtPaySchedule = PaymentScheduleBL.GetPaymentScheduleFlat(CCId, FlatId);
}
grdPayment.DataSource = dtPaySchedule;
if (dtPaySchedule.Rows.Count > 0)
{
decimal dAmt = 0;
for (int i = 0; i < dtPaySchedule.Rows.Count; i++)
{
dAmt = dAmt + Convert.ToDecimal(dtPaySchedule.Rows[i]["NetAmount"]);
dtPaySchedule.Rows[i]["CumulativeAmount"] = dAmt;
}
}
PaymentView.Columns["PaymentSchId"].Visible = false;
//PaymentView.Columns["CostCentreId"].Visible = false;
//PaymentView.Columns["FlatId"].Visible = false;
//PaymentView.Columns["OtherCostId"].Visible = false;
PanelProgress.Controls.Clear();
frmFlatTrans frmT = new frmFlatTrans();
frmT.Dock = DockStyle.Fill;
frmT.TopLevel = false;
frmT.FormBorderStyle = FormBorderStyle.None;
PanelProgress.Controls.Add(frmT);
frmT.Execute(FlatId);
int LandId = Convert.ToInt32(CommFun.IsNullCheck(FlatView.GetFocusedRowCellValue("LandRegisterId"), CommFun.datatypes.vartypenumeric));
frmProgressChart frmP = new frmProgressChart();
PanelProgress.Controls.Clear();
frmP.Dock = DockStyle.Fill;
frmP.TopLevel = false;
frmP.FormBorderStyle = FormBorderStyle.None;
PanelProgress.Controls.Add(frmP);
frmP.m_iLandId = LandId;
if (cboCheckList.EditValue.ToString() == "Handing Over")
{
frmP.Execute(FlatId, false, "H");
}
else if (cboCheckList.EditValue.ToString() == "Works")
{
frmP.Execute(FlatId, false, "W");
}
else if (cboCheckList.EditValue.ToString() == "Finalization")
{
frmP.Execute(FlatId, false, "F");
}
else if (cboCheckList.EditValue.ToString() == "Cancellation")
{
frmP.Execute(FlatId, false, "C");
}
PopulatePayInfo();
PopulateBuyerInfo();
PopulateCustomerFeedback();
}