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