private void PopulateOC() { dtOC = new DataTable(); try { dtOC = ProjectInfoBL.GetOtherCost(m_iCCId); grdOC.DataSource = dtOC; grdViewOC.Columns["OtherCostId"].Visible = false; grdViewOC.Columns["SysDefault"].Visible = false; grdViewOC.Columns["Sel"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; grdViewOC.BestFitColumns(); grdViewOC.Columns["OtherCostName"].OptionsColumn.ReadOnly = true; grdViewOC.Columns["OtherCostName"].OptionsColumn.AllowEdit = false; grdViewOC.OptionsSelection.InvertSelection = true; grdViewOC.OptionsSelection.EnableAppearanceHideSelection = false; grdViewOC.Appearance.FocusedRow.BackColor = Color.Teal; grdViewOC.Appearance.FocusedRow.ForeColor = Color.White; } catch (Exception e) { throw e; } }
private void PopulateOC() { BsfGlobal.OpenCRMDB(); dtOC = new DataTable(); string stt = ""; string newS = ""; try { stt = m_sOCId.TrimEnd(','); for (int i = 0; i < stt.Length; i++) { newS += stt[i].ToString(); } dtOC = ProjectInfoBL.SelectOtherCost(newS, iArea, CCId); grdOC.DataSource = dtOC; grdViewOC.Columns["OtherCostId"].Visible = false; grdViewOC.Columns["Amount"].Visible = false; grdViewOC.Columns["Flag"].Visible = false; grdViewOC.Columns["SysDefault"].Visible = false; grdViewOC.Columns["Area"].Visible = false; grdViewOC.Columns["Amount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; grdViewOC.Columns["Amount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; grdViewOC.Columns["Sel"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; RepositoryItemCheckEdit chkSel = new RepositoryItemCheckEdit(); chkSel.CheckedChanged += chkSel_CheckedChanged; grdViewOC.BestFitColumns(); grdViewOC.Columns["OtherCostName"].OptionsColumn.ReadOnly = true; grdViewOC.Columns["OtherCostName"].OptionsColumn.AllowEdit = false; RepositoryItemTextEdit txtAmount = new RepositoryItemTextEdit(); grdViewOC.Columns["Amount"].ColumnEdit = txtAmount; txtAmount.Mask.EditMask = BsfGlobal.g_sDigitFormat; txtAmount.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric; txtAmount.Validating += txtAmount_Validating; BsfGlobal.g_CRMDB.Close(); grdViewOC.Appearance.HeaderPanel.Font = new Font(grdViewOC.Appearance.HeaderPanel.Font, FontStyle.Bold); grdViewOC.Appearance.FocusedCell.BackColor = Color.Teal; grdViewOC.Appearance.FocusedCell.ForeColor = Color.White; grdViewOC.Appearance.FocusedRow.ForeColor = Color.Teal; grdViewOC.Appearance.FocusedRow.BackColor = Color.White; grdViewOC.OptionsSelection.EnableAppearanceHideSelection = false; } catch (Exception e) { throw e; } }
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { DataTable dt = new DataTable(); dt = grdOC.DataSource as DataTable; if (dt == null) { return; } ProjectInfoBL.UpdateOCType(dt); Close(); }
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { string sBlock = "", sBook = "", sFlat = ""; decimal dBlockAmt = 0, dBookAmt = 0, dFlatAmt = 0; try { if (rGBlock.SelectedIndex == 0) { sBlock = "P"; if (Convert.ToDecimal(txtBlock.EditValue) > 100) { MessageBox.Show("Should Not Exceed 100%"); return; } } else { sBlock = "L"; } dBlockAmt = Convert.ToDecimal(txtBlock.EditValue); if (rGBook.SelectedIndex == 0) { sBook = "P"; if (Convert.ToDecimal(txtBook.EditValue) > 100) { MessageBox.Show("Should Not Exceed 100%"); return; } } else { sBook = "L"; } dBookAmt = Convert.ToDecimal(txtBook.EditValue); if (rGFlat.SelectedIndex == 0) { sFlat = "P"; if (Convert.ToDecimal(txtFlat.EditValue) > 100) { MessageBox.Show("Should Not Exceed 100%"); return; } } else { sFlat = "L"; } dFlatAmt = Convert.ToDecimal(txtFlat.EditValue); ProjectInfoBL.UpdatePenalty(m_iCCId, sBlock, dBlockAmt, sBook, dBookAmt, sFlat, dFlatAmt); } catch (Exception ex) { throw ex; } Close(); }
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { grdViewOC.FocusedRowHandle = grdViewOC.FocusedRowHandle + 1; if (m_sType == "Service") { if (dtOC.Rows.Count > 0) { ProjectInfoBL.UpdateServiceOC(dtOC, m_sType, m_iCCId); } } else { if (dtOX.Rows.Count > 0) { ProjectInfoBL.UpdateServiceOC(dtOX, m_sType, m_iCCId); } } Close(); }
private void frmCancellation_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = ProjectInfoBL.GetPenalty(m_iCCId); if (dt.Rows.Count > 0) { if (dt.Rows[0]["BlockingType"].ToString() == "P") { rGBlock.SelectedIndex = 0; } else { rGBlock.SelectedIndex = 1; } txtBlock.EditValue = Convert.ToDecimal(dt.Rows[0]["BlockingPenalty"]); if (dt.Rows[0]["BookingType"].ToString() == "P") { rGBook.SelectedIndex = 0; } else { rGBook.SelectedIndex = 1; } txtBook.EditValue = Convert.ToDecimal(dt.Rows[0]["BookingPenalty"]); if (dt.Rows[0]["CancelType"].ToString() == "P") { rGFlat.SelectedIndex = 0; } else { rGFlat.SelectedIndex = 1; } txtFlat.EditValue = Convert.ToDecimal(dt.Rows[0]["CancelPenalty"]); } else { rGBlock.SelectedIndex = 1; rGBook.SelectedIndex = 1; rGFlat.SelectedIndex = 1; } }
private void PopulateGrid() { DataTable dt = new DataTable(); dtOC = new DataTable(); dt = ProjectInfoBL.GetOtherCostType(); dtOC = ProjectInfoBL.GetOCTypeMaster(); DataRow dr; dr = dtOC.NewRow(); dr["OCTypeId"] = 0; dr["OCTypeName"] = "None"; dtOC.Rows.InsertAt(dr, 0); DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit cboOC = new DevExpress.XtraEditors.Repository.RepositoryItemLookUpEdit(); cboOC.DataSource = dtOC; cboOC.PopulateColumns(); cboOC.ValueMember = "OCTypeId"; cboOC.DisplayMember = "OCTypeName"; cboOC.Columns["OCTypeId"].Visible = false; cboOC.ShowFooter = false; cboOC.ShowHeader = false; grdOC.DataSource = dt; grdViewOC.PopulateColumns(); grdViewOC.Columns["OCTypeId"].Caption = "TypeName"; grdViewOC.Columns["OtherCostId"].Visible = false; grdViewOC.Columns["OtherCostName"].OptionsColumn.AllowEdit = false; grdViewOC.Columns["OCTypeId"].ColumnEdit = cboOC; cboOC.EditValueChanged += new EventHandler(cboOC_EditValueChanged); grdViewOC.Appearance.HeaderPanel.Font = new Font(grdViewOC.Appearance.HeaderPanel.Font, FontStyle.Bold); grdViewOC.OptionsSelection.InvertSelection = true; grdViewOC.OptionsSelection.EnableAppearanceHideSelection = false; grdViewOC.Appearance.FocusedRow.BackColor = Color.Teal; grdViewOC.Appearance.FocusedRow.ForeColor = Color.White; }
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { DataTable dt = new DataTable(); dt = grdOC.DataSource as DataTable; ProjectInfoBL.UpdateSortOrder(dt); grdViewOC.FocusedRowHandle = grdViewOC.FocusedRowHandle + 1; DataTable dtRtnVal = new DataTable(); using (DataView dvData = new DataView(dtOC) { RowFilter = "Sel = '" + true + "'" }) { dtRtnVal = dvData.ToTable(); } if (dtRtnVal.Rows.Count > 0) { ProjectInfoBL.UpdateOC(m_iCCId, dtRtnVal); } Close(); }
private void grdViewOC_ShowingEditor(object sender, System.ComponentModel.CancelEventArgs e) { if (Convert.ToBoolean(CommFun.IsNullCheck(grdViewOC.GetFocusedRowCellValue("SysDefault"), CommFun.datatypes.vartypenumeric)) == true) { e.Cancel = true; return; } if (grdViewOC.FocusedColumn.FieldName == "Sel") { bool bSel = Convert.ToBoolean(CommFun.IsNullCheck(grdViewOC.GetFocusedRowCellValue("Sel"), CommFun.datatypes.vartypenumeric)); if (bSel == true) { int iOCId = Convert.ToInt32(CommFun.IsNullCheck(grdViewOC.GetFocusedRowCellValue("OtherCostId"), CommFun.datatypes.vartypenumeric)); bool bUsedinFlats = ProjectInfoBL.CheckUsedInFlatsPayment(m_iCCId, iOCId); if (bUsedinFlats == true) { e.Cancel = true; //MessageBox.Show("Selected OtherCost Used in Flat-Payment", "OtherCost", MessageBoxButtons.OK, MessageBoxIcon.Information); //return; } } } }