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