public void FillData()
{
dt = new DataTable();
dt = PMSReceiptBL.GetReceiptRegister();
grdReceipt.DataSource = dt;
grdViewReceipt.PopulateColumns();
grdReceipt.ForceInitialize();
grdViewReceipt.Columns["CostCentreId"].Visible = false;
grdViewReceipt.Columns["ReceiptId"].Visible = false;
grdViewReceipt.Columns["ReceiptNo"].Width = 80;
grdViewReceipt.Columns["ReceiptDate"].Width = 50;
grdViewReceipt.Columns["CostCentreName"].Width = 200;
grdViewReceipt.Columns["PaidAmount"].Width = 80;
grdViewReceipt.Columns["ReceiptDate"].Caption = "Date";
grdViewReceipt.Columns["FlatNo"].Caption = CommFun.m_sFuncName + " No";
grdViewReceipt.Columns["PaidAmount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewReceipt.Columns["PaidAmount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewReceipt.Appearance.HeaderPanel.Font = new Font(grdViewReceipt.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdViewReceipt.Appearance.FocusedCell.BackColor = Color.Teal;
grdViewReceipt.Appearance.FocusedCell.ForeColor = Color.White;
grdViewReceipt.Appearance.FocusedRow.ForeColor = Color.White;
grdViewReceipt.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewReceipt.OptionsSelection.EnableAppearanceHideSelection = false;
}
private void PopulateFlat()
{
DataTable dtF = new DataTable();
dtF = PMSReceiptBL.GetFlat(Convert.ToInt32(cboCostCentre.EditValue));
cboFlatNo.Properties.DataSource = CommFun.AddSelectToDataTable(dtF);
cboFlatNo.Properties.DisplayMember = "FlatNo";
cboFlatNo.Properties.ValueMember = "FlatId";
cboFlatNo.Properties.PopulateColumns();
cboFlatNo.Properties.Columns["FlatId"].Visible = false;
cboFlatNo.Properties.ShowHeader = false;
cboFlatNo.Properties.ShowFooter = false;
}
public void UpdateReceipt()
{
try
{
oRptBO = new PMSReceiptDetailBO();
PMSReceiptDetailBO.ReceiptId = ReceiptId;
PMSReceiptDetailBO.ReceiptDate = String.Format("{0:dd-MMM-yyyy}", dateReceipt.EditValue); //dateReceipt
PMSReceiptDetailBO.ReceiptNo = CommFun.IsNullCheck(textReceiptNo.Text, CommFun.datatypes.vartypestring).ToString(); //textReceiptNo
PMSReceiptDetailBO.ChequeNo = CommFun.IsNullCheck(textChequeNo.Text, CommFun.datatypes.vartypestring).ToString(); //textChequeNo
PMSReceiptDetailBO.ChequeDate = String.Format("{0:dd-MMM-yyyy}", CommFun.IsNullCheck(dateCheque.EditValue, CommFun.datatypes.VarTypeDate)); // String.Format("{0:dd-MMM-yyyy}", dateCheque.Text);// dateCheque
PMSReceiptDetailBO.BankName = CommFun.IsNullCheck(textBankName.Text, CommFun.datatypes.vartypestring).ToString(); //textBankName
PMSReceiptDetailBO.CostCentreId = Convert.ToInt32(CommFun.IsNullCheck(cboCostCentre.EditValue, CommFun.datatypes.vartypenumeric));
PMSReceiptDetailBO.FlatId = Convert.ToInt32(CommFun.IsNullCheck(cboFlatNo.EditValue, CommFun.datatypes.vartypenumeric));
PMSReceiptDetailBO.PaymentMode = CommFun.IsNullCheck(cboMode.EditValue, CommFun.datatypes.vartypestring).ToString();
PMSReceiptDetailBO.Amount = Convert.ToDecimal(CommFun.IsNullCheck(gridViewReceipt.Columns["CurrentAmount"].SummaryText, CommFun.datatypes.vartypenumeric));//textAmt
PMSReceiptDetailBO.Narration = CommFun.IsNullCheck(txtNarration.Text, CommFun.datatypes.vartypestring).ToString();
if (ReceiptId == 0)
{
PMSReceiptBL.InsertReceipt(oRptBO, dtReceipt);
//ReceiptDetailBL.InsertReceiptDetails(oRptBO, dtReceipt, m_sBussinessType, dtRecp, dtInfo, dtReceiptType, dtQualifier, m_tQualAbs);
//CommFun.InsertLog(DateTime.Now, "Receipt Register-Add", "N", "Add ExtraItem Register", BsfGlobal.g_lUserId, 0, m_iCCId, 0, BsfGlobal.g_sCRMDBName);
BsfGlobal.UpdateMaxNo(26, oVType, 0, 0);
}
else
{
if (Convert.ToDateTime(PMSReceiptDetailBO.ReceiptDate) != Convert.ToDateTime(dateReceipt.EditValue))
{
oVType = new BsfGlobal.VoucherType();
if (oVType.PeriodWise == true)
{
if (BsfGlobal.CheckPeriodChange(Convert.ToDateTime(PMSReceiptDetailBO.ReceiptDate), Convert.ToDateTime(dateReceipt.EditValue)) == true)
{
oVType = BsfGlobal.GetVoucherNo(26, Convert.ToDateTime(dateReceipt.EditValue), 0, 0);
textReceiptNo.Text = oVType.VoucherNo;
BsfGlobal.UpdateMaxNo(26, oVType, 0, 0);
}
}
}
PMSReceiptBL.UpdateReceipt(oRptBO, dtReceipt);
//ReceiptDetailBL.UpdateReceiptDetails(oRptBO, dtReceipt, m_sBussinessType, dtInfo, dtReceiptType, dtQualifier, m_tQualAbs);
//CommFun.InsertLog(DateTime.Now, "Receipt Register-Edit", "E", "Edit ExtraItem Register", BsfGlobal.g_lUserId, 0, m_iCCId, 0, BsfGlobal.g_sCRMDBName);
}
}
catch (Exception e)
{
throw e;
}
}
public void GetCostCentre()
{
DataTable dt = new DataTable();
dt = PMSReceiptBL.GetCostCentre();
cboCostCentre.Properties.DataSource = CommFun.AddSelectToDataTable(dt);
cboCostCentre.Properties.PopulateColumns();
cboCostCentre.Properties.DisplayMember = "CostCentreName";
cboCostCentre.Properties.ValueMember = "CostCentreId";
cboCostCentre.Properties.Columns["CostCentreId"].Visible = false;
cboCostCentre.Properties.ShowHeader = false;
cboCostCentre.Properties.ShowFooter = false;
cboCostCentre.ItemIndex = 0;
}
private void cboFlatNo_EditValueChanged(object sender, EventArgs e)
{
if (Convert.ToInt32(cboFlatNo.EditValue) > 0)
{
m_iFlatId = Convert.ToInt32(cboFlatNo.EditValue);
if (m_iCCId > 0)
{
dtReceipt = new DataTable();
dtReceipt = PMSReceiptBL.GetSchedule(m_iFlatId);
Fill_Grid();
}
}
else
{
m_iFlatId = 0;
}
}
public void FillData()
{
DataSet dsE = new DataSet();
DataTable dt = new DataTable();
try
{
dsE = PMSReceiptBL.GetReceiptDetE(ReceiptId);
dt = dsE.Tables["Register"];
if (dsE.Tables.Count > 0)
{
if (dsE.Tables[0].Rows.Count > 0)
{
dateReceipt.EditValue = Convert.ToDateTime(dsE.Tables[0].Rows[0]["ReceiptDate"].ToString());
m_dOldDate = Convert.ToDateTime(dateReceipt.EditValue);
textReceiptNo.Text = dsE.Tables[0].Rows[0]["ReceiptNo"].ToString();
textChequeNo.Text = dsE.Tables[0].Rows[0]["ChequeNo"].ToString();
dateCheque.EditValue = Convert.ToDateTime(dsE.Tables[0].Rows[0]["ChequeDate"].ToString());
cboMode.EditValue = dsE.Tables[0].Rows[0]["PaymentMode"].ToString();
textBankName.Text = dsE.Tables[0].Rows[0]["BankName"].ToString();
cboCostCentre.EditValue = Convert.ToInt32(dsE.Tables[0].Rows[0]["CostCentreId"].ToString());
PopulateFlat();
cboFlatNo.EditValue = Convert.ToInt32(dsE.Tables[0].Rows[0]["FlatId"]);
textAmt.Text = dsE.Tables[0].Rows[0]["PaidAmount"].ToString();
txtNarration.Text = dsE.Tables[0].Rows[0]["Narration"].ToString();
}
}
if (dtReceipt != null)
{
dtReceipt.Rows.Clear();
}
dtReceipt = dsE.Tables["RegisterTrans"];
Fill_Grid();
panelControl3.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnDelete_ItemClick(object sender, ItemClickEventArgs e)
{
if (BsfGlobal.FindPermission("Buyer-Receipt-Delete") == false)
{
MessageBox.Show("You don't have Rights to Buyer-Receipt-Delete");
return;
}
if (Convert.ToInt32(grdViewReceipt.FocusedRowHandle) < 0)
{
return;
}
int iRepceiptId = Convert.ToInt32(CommFun.IsNullCheck(grdViewReceipt.GetFocusedRowCellValue("ReceiptId"), CommFun.datatypes.vartypenumeric));
//string sAppr = ReceiptDetailBL.GetApprove(iRepceiptId);
//if (sAppr =="P" || sAppr=="Y") { MessageBox.Show("Approved Receipt should not be Deleted"); return; }
try
{
if (grdViewReceipt.FocusedRowHandle >= 0)
{
if (MessageBox.Show("Do you want to delete?", "Confirm delete", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
PMSReceiptBL.DeleteReceiptDetails(iRepceiptId);
grdViewReceipt.DeleteRow(grdViewReceipt.FocusedRowHandle);
int iCCId = Convert.ToInt32(CommFun.IsNullCheck(grdViewReceipt.GetFocusedRowCellValue("CostCentreId"), CommFun.datatypes.vartypenumeric));
string sRecNo = CommFun.IsNullCheck(grdViewReceipt.GetFocusedRowCellValue("ReceiptNo"), CommFun.datatypes.vartypestring).ToString();
decimal dAmt = Convert.ToInt32(CommFun.IsNullCheck(grdViewReceipt.GetFocusedRowCellValue("Amount"), CommFun.datatypes.vartypenumeric));
//BsfGlobal.InsertLog(DateTime.Now, "Buyer-Receipt-Delete", "D", "Delete Receipt Register", Convert.ToInt32(DGvTransView.GetFocusedRowCellValue("ReceiptId")), iCCId, 0, BsfGlobal.g_sCRMDBName, sRecNo, BsfGlobal.g_lUserId, dAmt, 0);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
