private void ChangeGridValue(int argEntryId) { DataTable dt = new DataTable(); dt = CashEntryBL.GetChangeGridCashReceiptRegister(argEntryId); int iRowId = frmCashRegister.m_oGridMasterView.FocusedRowHandle; if (dt.Rows.Count > 0) { frmCashRegister.m_oGridMasterView.SetRowCellValue(iRowId, "Amount", Convert.ToDecimal(CommFun.IsNullCheck(dt.Rows[0]["Amount"], CommFun.datatypes.vartypenumeric))); } dt.Dispose(); }
public void GetBuyer() { DataTable dt = new DataTable(); dt = CashEntryBL.GetBuyer(m_iCCId); cboBuyer.Properties.DataSource = CommFun.AddSelectToDataTable(dt); cboBuyer.Properties.PopulateColumns(); cboBuyer.Properties.DisplayMember = "LeadName"; cboBuyer.Properties.ValueMember = "LeadId"; cboBuyer.Properties.Columns["LeadId"].Visible = false; cboBuyer.Properties.ShowHeader = false; cboBuyer.Properties.ShowFooter = false; cboBuyer.ItemIndex = 0; }
public void GetCostCentre() { DataTable dt = new DataTable(); dt = CashEntryBL.GetCostCentre(); DataRow newRow = dt.NewRow(); newRow[0] = -1; newRow[1] = "-- Select CostCentreName --"; dt.Rows.InsertAt(newRow, 0); cboProject.Properties.DataSource = dt; cboProject.Properties.PopulateColumns(); cboProject.Properties.DisplayMember = "CostCentreName"; cboProject.Properties.ValueMember = "CostCentreId"; cboProject.Properties.Columns["CostCentreId"].Visible = false; cboProject.Properties.ShowHeader = false; cboProject.Properties.ShowFooter = false; cboProject.ItemIndex = 0; }
private void btnOK_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (BsfGlobal.FindPermission("Buyer-Receipt-Cash-Add") == false) { MessageBox.Show("You don't have Rights to Buyer-Receipt-Cash-Add"); return; } if (cboProject.EditValue == null || Convert.ToInt32(cboProject.EditValue) <= 0) { MessageBox.Show("Select Project"); return; } if (cboBuyer.EditValue == null || Convert.ToInt32(cboBuyer.EditValue) <= 0) { MessageBox.Show("Select Buyer"); return; } if (Convert.ToInt32(txtAmt.EditValue) <= 0) { MessageBox.Show("Enter Cash Amount"); return; } DateTime d = Convert.ToDateTime(CommFun.IsNullCheck(dEDate.EditValue, CommFun.datatypes.VarTypeDate)); if (m_iCashRecpId == 0) { if (dtInfo.Rows.Count > 0) { CashEntryBL.InsertCashDetails(dtInfo, m_iCCId, m_iBuyerId, Convert.ToDecimal(txtAmt.EditValue), d, m_sType); } } else { if (dtInfo.Rows.Count > 0) { CashEntryBL.UpdateCashDetails(m_iCashRecpId, dtInfo, m_iCCId, m_iBuyerId, Convert.ToDecimal(txtAmt.EditValue), d, m_sType); } } Close(); }
private void PopulateEditData() { //DataTable dt = new DataTable(); dtInfo = CashEntryBL.GetPayInfoRegEntry(m_iCashRecpId, m_iBuyerId, m_sType); if (dtInfo.Rows.Count > 0) { dEDate.EditValue = Convert.ToDateTime(dtInfo.Rows[0]["CashDate"]).ToString("dd/MMM/yyyy"); cboProject.EditValue = Convert.ToInt32(dtInfo.Rows[0]["CostCentreId"]); cboBuyer.EditValue = Convert.ToInt32(dtInfo.Rows[0]["LeadId"]); txtAmt.EditValue = Convert.ToDecimal(dtInfo.Rows[0]["CashAmount"]); } dtInfo = CashEntryBL.GetPayInfoRegEntry(m_iCashRecpId, m_iBuyerId, m_sType); gridReceipt.DataSource = null; gridViewReceipt.Columns.Clear(); gridReceipt.DataSource = dtInfo; gridViewReceipt.PopulateColumns(); gridReceipt.ForceInitialize(); gridViewReceipt.Columns["PBillId"].Visible = false; gridViewReceipt.Columns["ProgRegId"].Visible = false; gridViewReceipt.Columns["CashReceiptId"].Visible = false; gridViewReceipt.Columns["PaySchId"].Visible = false; gridViewReceipt.Columns["LeadId"].Visible = false; gridViewReceipt.Columns["FlatId"].Visible = false; gridViewReceipt.Columns["CashDate"].Visible = false; gridViewReceipt.Columns["CashAmount"].Visible = false; gridViewReceipt.Columns["Area"].Visible = false; gridViewReceipt.Columns["Rate"].Visible = false; gridViewReceipt.Columns["CostCentreId"].Visible = false; gridViewReceipt.Columns["CostCentreName"].Visible = false; gridViewReceipt.Columns["QualifierAmt"].Visible = false; gridViewReceipt.Columns["Amount"].Visible = false; gridViewReceipt.Columns["NetAmt"].Visible = false; gridViewReceipt.Columns["NetAmount"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridViewReceipt.Columns["NetAmount"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat; gridViewReceipt.Columns["CurrentAmount"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridViewReceipt.Columns["CurrentAmount"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat; gridViewReceipt.Columns["SurplusAmount"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridViewReceipt.Columns["SurplusAmount"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat; gridViewReceipt.Columns["Balance"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridViewReceipt.Columns["Balance"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat; gridViewReceipt.Columns["NetAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; gridViewReceipt.Columns["NetAmount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; gridViewReceipt.Columns["Balance"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; gridViewReceipt.Columns["Balance"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; gridViewReceipt.Columns["CurrentAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; gridViewReceipt.Columns["CurrentAmount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; gridViewReceipt.OptionsCustomization.AllowFilter = false; gridViewReceipt.OptionsBehavior.AllowIncrementalSearch = true; gridViewReceipt.OptionsView.ShowAutoFilterRow = false; gridViewReceipt.OptionsView.ShowViewCaption = false; gridViewReceipt.OptionsView.ShowFooter = true; gridViewReceipt.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect; gridViewReceipt.OptionsSelection.InvertSelection = false; gridViewReceipt.OptionsView.ColumnAutoWidth = true; gridViewReceipt.Appearance.HeaderPanel.Font = new Font(gridViewReceipt.Appearance.HeaderPanel.Font, FontStyle.Bold); gridViewReceipt.FocusedRowHandle = 0; gridViewReceipt.FocusedColumn = gridViewReceipt.VisibleColumns[0]; gridViewReceipt.Appearance.HeaderPanel.Font = new Font(gridViewReceipt.Appearance.HeaderPanel.Font, FontStyle.Bold); gridViewReceipt.Appearance.FocusedCell.BackColor = Color.Teal; gridViewReceipt.Appearance.FocusedCell.ForeColor = Color.White; gridViewReceipt.Appearance.FocusedRow.ForeColor = Color.Black; gridViewReceipt.Appearance.FocusedRow.BackColor = Color.White; gridViewReceipt.OptionsSelection.EnableAppearanceHideSelection = false; }
private void PopulatePayInfo() { dtInfo = new DataTable(); dtInfo = CashEntryBL.GetPayInfo(m_iBuyerId, m_sType); gridReceipt.DataSource = null; gridViewReceipt.Columns.Clear(); for (int i = 0; i < dtInfo.Rows.Count; i++) { if (Convert.ToDecimal(dtInfo.Rows[i]["NetAmount"]) == Convert.ToDecimal(dtInfo.Rows[i]["SurplusAmount"])) { dtInfo.Rows.RemoveAt(i); } } gridReceipt.DataSource = dtInfo; gridViewReceipt.PopulateColumns(); gridReceipt.ForceInitialize(); gridViewReceipt.Columns["PBillId"].Visible = false; gridViewReceipt.Columns["ProgRegId"].Visible = false; gridViewReceipt.Columns["PaySchId"].Visible = false; gridViewReceipt.Columns["FlatId"].Visible = false; gridViewReceipt.Columns["NetAmt"].Visible = false; gridViewReceipt.Columns["Area"].Visible = false; gridViewReceipt.Columns["Rate"].Visible = false; gridViewReceipt.Columns["Amount"].Visible = false; gridViewReceipt.Columns["QualifierAmt"].Visible = false; gridViewReceipt.Columns["NetAmount"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridViewReceipt.Columns["NetAmount"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat; gridViewReceipt.Columns["CurrentAmount"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridViewReceipt.Columns["CurrentAmount"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat; gridViewReceipt.Columns["SurplusAmount"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridViewReceipt.Columns["SurplusAmount"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat; gridViewReceipt.Columns["Balance"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric; gridViewReceipt.Columns["Balance"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat; gridViewReceipt.Columns["NetAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; gridViewReceipt.Columns["NetAmount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; gridViewReceipt.Columns["CurrentAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; gridViewReceipt.Columns["CurrentAmount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; gridViewReceipt.Columns["Balance"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum; gridViewReceipt.Columns["Balance"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS; gridViewReceipt.OptionsCustomization.AllowFilter = false; gridViewReceipt.OptionsBehavior.AllowIncrementalSearch = true; gridViewReceipt.OptionsView.ShowAutoFilterRow = false; gridViewReceipt.OptionsView.ShowViewCaption = false; gridViewReceipt.OptionsView.ShowFooter = true; gridViewReceipt.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect; gridViewReceipt.OptionsSelection.InvertSelection = false; gridViewReceipt.OptionsView.ColumnAutoWidth = true; gridViewReceipt.Appearance.HeaderPanel.Font = new Font(gridViewReceipt.Appearance.HeaderPanel.Font, FontStyle.Bold); gridViewReceipt.FocusedRowHandle = 0; gridViewReceipt.FocusedColumn = gridViewReceipt.VisibleColumns[0]; gridViewReceipt.Appearance.HeaderPanel.Font = new Font(gridViewReceipt.Appearance.HeaderPanel.Font, FontStyle.Bold); gridViewReceipt.Appearance.FocusedCell.BackColor = Color.Teal; gridViewReceipt.Appearance.FocusedCell.ForeColor = Color.White; gridViewReceipt.Appearance.FocusedRow.ForeColor = Color.Black; gridViewReceipt.Appearance.FocusedRow.BackColor = Color.White; gridViewReceipt.OptionsSelection.EnableAppearanceHideSelection = false; }