private void PopulateScheduleDescription()
{
grdDes.DataSource = null;
DataTable dt = new DataTable();
dt = PaymentScheduleBL.GetDesc(m_iCCId, m_iPayTypeId, m_cType);
if (dt == null)
{
return;
}
grdDes.DataSource = dt;
grdDes.ForceInitialize();
grdViewDes.PopulateColumns();
grdViewDes.Columns["SchDescId"].Visible = false;
grdViewDes.Columns["SchDescName"].Caption = "Schedule Description";
grdViewDes.Columns["SchDescName"].OptionsColumn.AllowEdit = false;
grdViewDes.Columns["Sel"].OptionsColumn.AllowEdit = true;
grdViewDes.Columns["Sel"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdViewDes.Appearance.HeaderPanel.Font = new Font(grdViewDes.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdViewDes.OptionsSelection.InvertSelection = true;
grdViewDes.OptionsSelection.EnableAppearanceHideSelection = false;
grdViewDes.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewDes.Appearance.FocusedRow.ForeColor = Color.White;
}
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (grdReceiptView.FocusedRowHandle <= 0)
{
return;
}
GridView view = grdReceiptView;
view.GridControl.Focus();
int index = view.FocusedRowHandle;
if (index <= 0)
{
return;
}
DataRow row1 = view.GetDataRow(index);
DataRow row2 = view.GetDataRow(index - 1);
object val1 = row1[OrderFieldName];
object val2 = row2[OrderFieldName];
row1[OrderFieldName] = val2;
row2[OrderFieldName] = val1;
view.FocusedRowHandle = index - 1;
int Handle = index - 1;
DataTable dt = new DataTable();
dt = grdReceipt.DataSource as DataTable;
PaymentScheduleBL.UpdateReceiptTypeSortOrder(dt);
PopulateGrid();
grdReceiptView.FocusedRowHandle = Handle;
}
private void btnDel_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (grdDescView.FocusedRowHandle < 0)
{
return;
}
int iSchId = Convert.ToInt32(CommFun.IsNullCheck(grdDescView.GetFocusedRowCellValue("SchDescId"), CommFun.datatypes.vartypenumeric));
if (PaymentScheduleBL.CheckPaymentScheduleDesUsed(iSchId) == true)
{
MessageBox.Show("Schedule Description Used, Do not Delete");
return;
}
try
{
if (MessageBox.Show("Do you want to Delete Row?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
string sSql = "DELETE FROM dbo.SchDescription WHERE SchDescId=" + iSchId + " AND Type='" + m_cDescType + "'";
CommFun.CRMExecute(sSql);
grdDescView.DeleteRow(grdDescView.FocusedRowHandle);
}
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (DGvTransPay.FocusedRowHandle < 0)
{
return;
}
int iPayId = Convert.ToInt32(DGvTransPay.GetRowCellValue(DGvTransPay.FocusedRowHandle, "TypeId").ToString());
if (PaymentScheduleBL.CheckPaymentScheduleUsed(iPayId) == true)
{
MessageBox.Show("Payment Schedule Used, Do not Delete");
return;
}
DialogResult result1 = MessageBox.Show("Do you want to Delete", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result1 == DialogResult.Yes)
{
string sql = String.Format("DELETE FROM PaySchType WHERE TypeId={0}", DGvTransPay.GetFocusedRowCellValue("TypeId"));
SqlCommand cmd = new SqlCommand(sql, BsfGlobal.OpenCRMDB());
cmd.ExecuteNonQuery();
cmd.Dispose();
BsfGlobal.g_CRMDB.Close();
DGvTransPay.DeleteRow(DGvTransPay.FocusedRowHandle);
}
}
private void PopulateData()
{
DataTable dt = new DataTable();
if (m_sType == "Pay")
{
dt = PaymentScheduleBL.GetPreviousStages(m_iTempId, m_iCCId, m_iPayTypeId);
}
else
{
dt = PaymentScheduleBL.GetFlatPreviousStages(m_iTempId, m_iCCId, m_iPayTypeId, m_iFlatId);
}
cboDatefrom.Properties.DataSource = dt;
cboDatefrom.Properties.ValueMember = "TemplateId";
cboDatefrom.Properties.DisplayMember = "Description";
cboDatefrom.Properties.PopulateColumns();
cboDatefrom.Properties.Columns["TemplateId"].Visible = false;
cboDatefrom.Properties.Columns["SchDate"].Visible = false;
cboDatefrom.EditValue = 0;
radioGroup1.SelectedIndex = 0;
cboDayMonth.EditValue = "None";
dtpDate.EditValue = null;
DataTable dtT = new DataTable();
if (m_sType == "Pay")
{
dtT = PaymentScheduleBL.GetPayScheduleDate(m_iTempId);
}
else
{
dtT = PaymentScheduleBL.GetFlatPayScheduleDate(m_iPayTypeId);
}
if (dtT.Rows.Count > 0)
{
cboDatefrom.EditValue = Convert.ToInt32(dtT.Rows[0]["PreStageTypeId"]);
if (Convert.ToBoolean(dtT.Rows[0]["DateAfter"]) == true)
{
radioGroup1.SelectedIndex = 1;
}
if (dtT.Rows[0]["DurationType"].ToString() == "D")
{
cboDayMonth.EditValue = "Day";
}
else if (dtT.Rows[0]["DurationType"].ToString() == "M")
{
cboDayMonth.EditValue = "Month";
}
txtDuration.Text = dtT.Rows[0]["Duration"].ToString();
dtpDate.EditValue = dtT.Rows[0]["SchDate"];
}
dtT.Dispose();
}
private void PopulateData()
{
gridReceipt.DataSource = null;
gridViewReceipt.Columns.Clear();
dtRept = PaymentScheduleBL.GetReceiptQualFlat(m_iPaySchId, m_sSchType, m_iPayTypeId, m_iCCId, m_iFlatId, m_bTypewise, "B");
gridReceipt.DataSource = dtRept;
gridViewReceipt.PopulateColumns();
gridViewReceipt.Columns["PaymentSchId"].Visible = false;
gridViewReceipt.Columns["FlatId"].Visible = false;
gridViewReceipt.Columns["ReceiptTypeId"].Visible = false;
gridViewReceipt.Columns["QualifierId"].Visible = false;
gridViewReceipt.Columns["Amount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridViewReceipt.Columns["Amount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
gridViewReceipt.Columns["PaidAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridViewReceipt.Columns["PaidAmount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
gridViewReceipt.Columns["BalanceAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridViewReceipt.Columns["BalanceAmount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
gridViewReceipt.Columns["CurrentAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
gridViewReceipt.Columns["CurrentAmount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
//RepositoryItemTextEdit txtEditAmt = new RepositoryItemTextEdit();
//txtEditAmt.LookAndFeel.UseDefaultLookAndFeel = false;
//txtEditAmt.Mask.EditMask = BsfGlobal.g_sDigitFormat;
//txtEditAmt.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
//txtEditAmt.Mask.UseMaskAsDisplayFormat = true;
//txtEditAmt.Validating += txtEditAmt_Validating;
//txtEditAmt.Spin += txtEditAmt_Spin;
//txtEditAmt.KeyDown += txtEditAmt_KeyDown;
//gridViewReceipt.Columns["Amount"].ColumnEdit = txtEditAmt;
}
private void GetStage()
{
dtStage = new DataTable();
dtStage = PaymentScheduleBL.GetStages(m_iCostCentreId, m_iPayTypeId);
if (dtStage.Rows.Count > 0)
{
DataColumn dtcCheck = new DataColumn("Sel") /*column object with the name */ DataType
{
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//string sMsg = PaymentScheduleBL.GetPaySchFlatValidate(m_iCCId, m_iFlatId);
//if (sMsg == "Land") { MessageBox.Show("Mismatch Land Value"); return; }
//if (sMsg == "Base") { MessageBox.Show("Mismatch Construction Value"); return; }
//if (sMsg == "OtherCost") { MessageBox.Show("Mismatch OtherCost Value"); return; }
//for (int x = 0; x < dtPaySchFlat.Rows.Count; x++)
//{
// for (int i = 0; i < dtFlat.Rows.Count; i++)
// {
// if (Convert.ToInt32(dtFlat.Rows[i]["TemplateId"]) == Convert.ToInt32(dtPaySchFlat.Rows[x]["TemplateId"]))
// {
// dtFlat.Rows[i]["FlatId"] = m_iFlatId;
// dtFlat.Rows[i]["SchDate"] = dtPaySchFlat.Rows[x]["SchDate"];
// dtFlat.Rows[i]["SchPercent"] = dtPaySchFlat.Rows[x]["SchPercent"];
// dTotal = dTotal + Convert.ToDecimal(dtFlat.Rows[i]["SchPercent"]);
// }
// }
//}
Cursor.Current = Cursors.WaitCursor;
grdViewPayFlat.FocusedRowHandle = grdViewPayFlat.FocusedRowHandle + 1;
decimal dTotal = Convert.ToDecimal(CommFun.IsNullCheck(grdViewPayFlat.Columns["SchPercent"].SummaryText, CommFun.datatypes.vartypenumeric));
if (dTotal != 100)
{
MessageBox.Show("Percentage should be 100"); return;
}
dtFlat = new DataTable();
dtFlat = PaymentScheduleBL.GetCommPaySchFlat(m_iCCId, m_iFlatId, m_iPayTypeId);
if (bCheckBill == false)
{
if (m_bPayTypewise == true)
{
PaymentScheduleBL.UpdateFlatSchedule(m_iFlatId, dtFlat);
}
else
{
PaymentScheduleBL.UpdateFlatScheduleQual(m_iFlatId, dtFlat);
}
}
//PaymentScheduleBL.UpdateFlatSchedule(m_iFlatId, dtFlat);
PopulatePaySchFlat();
Close();
Cursor.Current = Cursors.Default;
}
private void UpdateData()
{
if (gridControl1.DataSource == null)
{
return;
}
m_tQualifier.AcceptChanges();
DataTable dtM = new DataTable();
dtM = gridControl1.DataSource as DataTable;
if (dtM.Rows.Count > 0)
{
PaymentScheduleBL.UpdateCCQualifier(m_iCCId, dtM, m_tQualifier);
}
}
private void btnOk_Click(object sender, EventArgs e)
{
SetSchDate();
bool bAfter = false;
if (radioGroup1.SelectedIndex == 1)
{
bAfter = true;
}
string sDurType = "";
if (cboDayMonth.EditValue.ToString() == "Day")
{
sDurType = "D";
}
else if (cboDayMonth.EditValue.ToString() == "Month")
{
sDurType = "M";
}
int iDuration = Convert.ToInt32(CommFun.IsNullCheck(txtDuration.EditValue, CommFun.datatypes.vartypenumeric));
string dDate;
if (dtpDate.EditValue == DBNull.Value || dtpDate.EditValue == null)
{
dDate = null;
}
else
{
dDate = Convert.ToDateTime(dtpDate.EditValue).ToString("dd-MMM-yyyy");
}
if (m_sType == "Pay")
{
PaymentScheduleBL.UpdatePayScheduleDate(m_iTempId, Convert.ToInt32(cboDatefrom.EditValue), bAfter, sDurType, iDuration, dDate, m_iCCId, m_iPayTypeId);
}
else
{
PaymentScheduleBL.UpdateFlatPaySchDate(m_iFlatId, m_iTempId, Convert.ToInt32(cboDatefrom.EditValue), bAfter, sDurType, iDuration, dDate, m_iCCId, m_iPayTypeId);
}
m_bOk = true;
Close();
}
public void FillData()
{
grdDesc.DataSource = null;
m_dt = new DataTable();
m_dt = PaymentScheduleBL.PopulateDescriptionMaster(m_cDescType);
grdDesc.DataSource = m_dt;
grdDesc.ForceInitialize();
grdDescView.PopulateColumns();
grdDescView.Columns["SchDescId"].Visible = false;
grdDescView.Appearance.HeaderPanel.Font = new Font(grdDescView.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdDescView.OptionsSelection.InvertSelection = true;
grdDescView.OptionsSelection.EnableAppearanceHideSelection = false;
grdDescView.Appearance.FocusedRow.ForeColor = Color.Teal;
grdDescView.Appearance.FocusedRow.BackColor = Color.White;
}
private void frmFinalization_Load(object sender, EventArgs e)
{
bool bCheckBill = PaymentScheduleBL.CheckBillPassed(m_iFlatId);
if (bCheckBill == true)
{
btnOk.Enabled = false;
}
FillBrokerDet();
FillExec();
if ((m_iFlatId != 0) && (m_sMode == "E"))
{
bedit = true;
EditFinalization();
bedit = false;
}
}
private void PopulateGrid()
{
DataTable dt = new DataTable();
dt = PaymentScheduleBL.GetReceiptTypeOrder(m_iPayTypeId, m_iCCId);
grdReceipt.DataSource = dt;
grdReceiptView.PopulateColumns();
grdReceiptView.Columns["Id"].Visible = false;
grdReceiptView.Columns["SortOrder"].Visible = false;
grdReceiptView.Columns["SchType"].Visible = false;
grdReceiptView.Columns["TransId"].Visible = false;
grdReceiptView.Appearance.HeaderPanel.Font = new Font(grdReceiptView.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdReceiptView.Appearance.FocusedCell.BackColor = Color.Teal;
grdReceiptView.Appearance.FocusedCell.ForeColor = Color.White;
grdReceiptView.Appearance.FocusedRow.ForeColor = Color.Black;
grdReceiptView.Appearance.FocusedRow.BackColor = Color.Teal;
grdReceiptView.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();
}
private void PopulateData()
{
DataSet ds = new DataSet();
ds = PaymentScheduleBL.GetReceiptQ(m_iCCId);
DataTable dt = new DataTable();
dt = ds.Tables["ReceiptType"];
gridControl1.DataSource = dt;
gridControl1.ForceInitialize();
gridView1.PopulateColumns();
gridView1.Columns["ReceiptTypeId"].Visible = false;
gridView1.Columns["OtherCostId"].Visible = false;
gridView1.Columns["SchType"].Visible = false;
RepositoryItemButtonEdit butQual = new RepositoryItemButtonEdit()
{
TextEditStyle = TextEditStyles.DisableTextEditor
};
butQual.LookAndFeel.UseDefaultLookAndFeel = false;
butQual.LookAndFeel.SkinName = "Money Twins";
gridView1.Columns["ReceiptTypeName"].ColumnEdit = butQual;
butQual.DoubleClick += butQual_DoubleClick;
DataTable dtQ = new DataTable();
dtQ = ds.Tables["Qualifier"];
for (int i = 0; i < gridView1.RowCount; i++)
{
string sType = gridView1.GetRowCellValue(i, "SchType").ToString();
int iRId = Convert.ToInt32(gridView1.GetRowCellValue(i, "ReceiptTypeId").ToString());
int iOId = Convert.ToInt32(gridView1.GetRowCellValue(i, "OtherCostId").ToString());
DataView dv = new DataView(dtQ);
if (sType == "A")
{
dv.RowFilter = "SchType ='A'";
}
else if (sType == "O")
{
dv.RowFilter = "SchType ='O' and OtherCostId = " + iOId;
}
else
{
dv.RowFilter = "SchType ='R' and ReceiptTypeId = " + iRId;
}
if (dv.ToTable() != null)
{
DataTable dtT = new DataTable();
dtT = dv.ToTable();
//if (dtT.Rows.Count == 0)
//{
// dtT = PaymentScheduleDL.QualifierSelect(0, "B", DateTime.Now);
//}
for (int j = 0; j < dtT.Rows.Count; j++)
{
DataRow dr = m_tQualifier.NewRow();
dr["RowId"] = i;
dr["QualifierId"] = Convert.ToInt32(CommFun.IsNullCheck(dtT.Rows[j]["QualifierId"], CommFun.datatypes.vartypenumeric));
dr["Expression"] = CommFun.IsNullCheck(dtT.Rows[j]["Expression"], CommFun.datatypes.vartypestring).ToString();
dr["ExpPer"] = Convert.ToDecimal(CommFun.IsNullCheck(dtT.Rows[j]["ExpPer"], CommFun.datatypes.vartypenumeric));
if (Convert.ToDecimal(CommFun.IsNullCheck(dtT.Rows[j]["Net"], CommFun.datatypes.vartypenumeric)) != 0)
{
dr["Net"] = Convert.ToDecimal(CommFun.IsNullCheck(dtT.Rows[j]["Net"], CommFun.datatypes.vartypenumeric));
}
else
{
dr["Net"] = Convert.ToDecimal(CommFun.IsNullCheck(dtT.Rows[j]["Net"], CommFun.datatypes.vartypenumeric));
}
dr["Add_Less_Flag"] = CommFun.IsNullCheck(dtT.Rows[j]["Add_Less_Flag"], CommFun.datatypes.vartypestring).ToString();
dr["SurCharge"] = Convert.ToDecimal(CommFun.IsNullCheck(dtT.Rows[j]["SurCharge"], CommFun.datatypes.vartypenumeric));
dr["EDCess"] = Convert.ToDecimal(CommFun.IsNullCheck(dtT.Rows[j]["EDCess"], CommFun.datatypes.vartypenumeric));
dr["HEDCess"] = Convert.ToDecimal(CommFun.IsNullCheck(dtT.Rows[j]["HEDCess"], CommFun.datatypes.vartypenumeric));
dr["Taxable"] = Convert.ToDecimal(CommFun.IsNullCheck(dtT.Rows[j]["Taxable"], CommFun.datatypes.vartypenumeric));
m_tQualifier.Rows.Add(dr);
}
}
}
gridView1.OptionsView.ColumnAutoWidth = true;
}
private void frmPaymentFlat_Load(object sender, EventArgs e)
{
dtFlat = new DataTable();
dtFlat = PaymentScheduleBL.GetCommPaySchFlat(m_iCCId, m_iFlatId, m_iPayTypeId);
PopulatePaySchFlat();
}
private void PopulatePaySchFlat()
{
dtPaySchFlat = new DataTable();
dtPaySchFlat = PaymentScheduleBL.GetPaymentScheduleFlat(m_iCCId, m_iFlatId);
grdPayFlat.DataSource = null;
grdViewPayFlat.Columns.Clear();
grdPayFlat.DataSource = dtPaySchFlat;
grdViewPayFlat.PopulateColumns();
grdViewPayFlat.Columns["PaymentSchId"].Visible = false;
grdViewPayFlat.Columns["SchType"].Visible = false;
grdViewPayFlat.Columns["TemplateId"].Visible = false;
grdViewPayFlat.Columns["LevelName"].Visible = false;
grdViewPayFlat.Columns["BlockName"].Visible = false;
grdViewPayFlat.Columns["NetAmount"].Visible = false;
grdViewPayFlat.Columns["CumulativeAmount"].Visible = false;
grdViewPayFlat.Columns["SchPercent"].Caption = "%";
grdViewPayFlat.Columns["Description"].OptionsColumn.AllowEdit = false;
grdViewPayFlat.Columns["Amount"].OptionsColumn.AllowEdit = false;
grdViewPayFlat.Columns["SchDate"].OptionsColumn.AllowEdit = true;
bool bCheckBill = PaymentScheduleBL.CheckBillPassed(m_iFlatId);
if (bCheckBill == true)
{
grdViewPayFlat.Columns["SchPercent"].OptionsColumn.AllowEdit = false;
btnOK.Enabled = false;
}
else
{
grdViewPayFlat.Columns["SchPercent"].OptionsColumn.AllowEdit = true;
btnOK.Enabled = true;
}
RepositoryItemButtonEdit txtDEdit = new RepositoryItemButtonEdit()
{
TextEditStyle = TextEditStyles.DisableTextEditor
};
txtDEdit.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime;
txtDEdit.DisplayFormat.FormatString = "dd/MM/yyyy";
grdViewPayFlat.Columns["SchDate"].ColumnEdit = txtDEdit;
txtDEdit.DoubleClick += txtDEdit_DoubleClick;
RepositoryItemTextEdit txtSchPer = new RepositoryItemTextEdit();
grdViewPayFlat.Columns["SchPercent"].ColumnEdit = txtSchPer;
txtSchPer.Mask.EditMask = BsfGlobal.g_sDigitFormat;
grdViewPayFlat.Columns["SchPercent"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
txtSchPer.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
txtSchPer.Mask.UseMaskAsDisplayFormat = true;
txtSchPer.EditValueChanged += txtSchPer_EditValueChanged;
RepositoryItemTextEdit txtAmt = new RepositoryItemTextEdit();
grdViewPayFlat.Columns["Amount"].ColumnEdit = txtAmt;
txtAmt.Mask.EditMask = BsfGlobal.g_sDigitFormat;
grdViewPayFlat.Columns["Amount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
txtAmt.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
txtAmt.Mask.UseMaskAsDisplayFormat = true;
RepositoryItemButtonEdit txtAmtEdit = new RepositoryItemButtonEdit();
txtAmtEdit.TextEditStyle = TextEditStyles.DisableTextEditor;
grdViewPayFlat.Columns["NetAmount"].ColumnEdit = txtAmtEdit;
txtAmtEdit.Mask.EditMask = BsfGlobal.g_sDigitFormat;
txtAmtEdit.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
txtAmtEdit.DoubleClick += txtAmtEdit_DoubleClick;
//txtAmtEdit.EditValueChanged += txtPerEdit_EditValueChanged;
grdViewPayFlat.Columns["Description"].Width = 300;
grdViewPayFlat.Columns["SchDate"].Width = 100;
grdViewPayFlat.Columns["SchPercent"].Width = 60;
grdViewPayFlat.Columns["Amount"].Width = 100;
grdViewPayFlat.Columns["NetAmount"].Width = 100;
grdViewPayFlat.Columns["SchPercent"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewPayFlat.Columns["SchPercent"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewPayFlat.Columns["SchPercent"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewPayFlat.Columns["Amount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewPayFlat.Columns["Amount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewPayFlat.Columns["Amount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewPayFlat.Columns["NetAmount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewPayFlat.Columns["NetAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewPayFlat.Columns["NetAmount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewPayFlat.OptionsCustomization.AllowFilter = false;
grdViewPayFlat.OptionsBehavior.AllowIncrementalSearch = true;
grdViewPayFlat.OptionsView.ShowFooter = true;
grdViewPayFlat.OptionsView.ColumnAutoWidth = true;
grdViewPayFlat.FocusedRowHandle = 0;
grdViewPayFlat.FocusedColumn = grdViewPayFlat.VisibleColumns[0];
grdViewPayFlat.OptionsSelection.InvertSelection = true;
grdViewPayFlat.OptionsSelection.EnableAppearanceHideSelection = false;
grdViewPayFlat.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewPayFlat.Appearance.FocusedRow.ForeColor = Color.White;
//grdViewPayFlat.BestFitColumns();
}
public frmStagePickList()
{
InitializeComponent();
oPaySchBL = new PaymentScheduleBL();
}
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;
}
