public void FillData()
{
try
{
m_dt = new DataTable();
m_dt = MaintenanceBL.PopulateMainRegister(Convert.ToDateTime(dtpFrmDate.EditValue), Convert.ToDateTime(dtpToDate.EditValue));
DGvTrans.DataSource = m_dt;
DGvTransView.PopulateColumns();
DGvTransView.Columns["MaintenanceId"].Visible = false;
DGvTransView.Columns["CostCentreId"].Visible = false;
DGvTransView.Columns["FlatId"].Visible = false;
DGvTransView.Columns["Approve"].Visible = false;
DGvTransView.Columns["FlatNo"].Caption = CommFun.m_sFuncName + " No";
DGvTransView.Columns["Date"].OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False;
DGvTransView.Columns["StartDate"].OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False;
DGvTransView.Columns["EndDate"].OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False;
DGvTransView.Columns["RefNo"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["RefNo"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["FlatNo"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["FlatNo"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["Date"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["Date"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["StartDate"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["StartDate"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["EndDate"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["EndDate"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.OptionsCustomization.AllowFilter = true;
DGvTransView.OptionsBehavior.AllowIncrementalSearch = true;
DGvTransView.OptionsView.ShowAutoFilterRow = true;
DGvTransView.OptionsView.ShowViewCaption = false;
DGvTransView.OptionsView.ShowFooter = false;
DGvTransView.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect;
DGvTransView.OptionsSelection.InvertSelection = false;
DGvTransView.OptionsView.ColumnAutoWidth = true;
DGvTransView.Appearance.HeaderPanel.Font = new Font(DGvTransView.Appearance.HeaderPanel.Font, FontStyle.Bold);
DGvTransView.FocusedRowHandle = 0;
DGvTransView.FocusedColumn = DGvTransView.VisibleColumns[0];
DGvTransView.Appearance.FocusedCell.BackColor = Color.Teal;
DGvTransView.Appearance.FocusedCell.ForeColor = Color.White;
DGvTransView.Appearance.FocusedRow.ForeColor = Color.Black;
DGvTransView.Appearance.FocusedRow.BackColor = Color.White;
DGvTransView.OptionsSelection.EnableAppearanceHideSelection = false;
}
catch (Exception ex)
{
BsfGlobal.CustomException(ex.Message, ex.StackTrace);
}
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (DGvTransView.FocusedRowHandle < 0)
{
return;
}
if (BsfGlobal.FindPermission("CRM-Maintenance-Bill-Delete") == false)
{
MessageBox.Show("You don't have Rights to CRM-Maintenance-Bill-Delete", "Information", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
try
{
int i_RegId = Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "MaintenanceId"), CommFun.datatypes.vartypenumeric));
string m_sIssNo = "";
int m_iCCId1 = 0;
string Apv = "";
m_iCCId1 = Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "CostCentreId"), CommFun.datatypes.vartypenumeric));
m_sIssNo = Convert.ToString(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "RefNo"), CommFun.datatypes.vartypestring));
Apv = Convert.ToString(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "Approve"), CommFun.datatypes.vartypestring));
if (Apv == "Y")
{
MessageBox.Show("Already Approved, Do Not Delete", "Information", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
if (MessageBox.Show("Do you want to delete?", "Confirm delete", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
if (MaintenanceBL.DeleteRegister(i_RegId, m_iCCId1, m_sIssNo) == true)
{
DGvTransView.DeleteRow(DGvTransView.FocusedRowHandle);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void barButtonItem5_ItemClick(object sender, ItemClickEventArgs e)
{
if (DGvTransView.FocusedRowHandle < 0)
{
return;
}
int p_FlatId = 0; DataTable dt = new DataTable();
int p_MaintanceId = 0;
string s = ""; frmReport objReport; ReportDocument cryRpt;
decimal dBillAmount = 0, dArrear = 0;
DateTime dStartDate = DateTime.Today;; DateTime dEndDate = DateTime.Today;;
string[] DataFiles;
string sHeader = "";
int sMonth = 0;
int sYear = 0;
DateTime sFifetDate = DateTime.Today;
p_FlatId = Convert.ToInt32(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "FlatId"));
p_MaintanceId = Convert.ToInt32(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "MaintenanceId"));
dt = MaintenanceBL.GetReport(p_FlatId, p_MaintanceId);
if (dt.Rows.Count > 0)
{
dBillAmount = Convert.ToDecimal(CommFun.IsNullCheck(dt.Rows[0]["BillAmount"], CommFun.datatypes.vartypenumeric));
dArrear = Convert.ToDecimal(CommFun.IsNullCheck(dt.Rows[0]["Arrear"], CommFun.datatypes.vartypenumeric));
if (dArrear == 0)
{
dStartDate = Convert.ToDateTime(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "StartDate"), CommFun.datatypes.VarTypeDate));
dEndDate = Convert.ToDateTime(CommFun.IsNullCheck(DGvTransView.GetRowCellValue(DGvTransView.FocusedRowHandle, "EndDate"), CommFun.datatypes.VarTypeDate));
sMonth = dStartDate.Month;
sYear = dStartDate.Year;
sFifetDate = Convert.ToDateTime("15" + "/" + sMonth + "/" + sYear);
}
else
{
dStartDate = Convert.ToDateTime(CommFun.IsNullCheck(dt.Rows[0]["FromDate"], CommFun.datatypes.VarTypeDate));
dEndDate = Convert.ToDateTime(CommFun.IsNullCheck(dt.Rows[0]["ToDate"], CommFun.datatypes.VarTypeDate));
sMonth = dEndDate.Month;
sYear = dEndDate.Year;
sFifetDate = Convert.ToDateTime("15" + "/" + sMonth + "/" + sYear);
}
//dEndDate = Convert.ToDateTime(CommFun.IsNullCheck(dt.Rows[0]["ToDate"], CommFun.datatypes.VarTypeDate));
}
decimal dTotalPayAmt = Convert.ToDecimal(dBillAmount + dArrear);
objReport = new frmReport();
string strReportPath = Application.StartupPath + "\\Maintenance.Rpt";
cryRpt = new ReportDocument();
cryRpt.Load(strReportPath);
s = "{MaintenanceDet.FlatId}=" + p_FlatId + " ";
DataFiles = new string[] { BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName, BsfGlobal.g_sCRMDBName,
BsfGlobal.g_sCRMDBName, BsfGlobal.g_sWorkFlowDBName,
BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sWorkFlowDBName, BsfGlobal.g_sCRMDBName };
objReport.ReportConvert(cryRpt, DataFiles);
if (s.Length > 0)
{
cryRpt.RecordSelectionFormula = s;
}
objReport.rptViewer.ReportSource = null;
objReport.rptViewer.SelectionFormula = s;
objReport.rptViewer.ReportSource = cryRpt;
cryRpt.DataDefinition.FormulaFields["Decimal"].Text = string.Format(CommFun.g_iCurrencyDigit.ToString());
cryRpt.DataDefinition.FormulaFields["MainAmt"].Text = "'" + string.Format(dBillAmount.ToString()) + "'";
cryRpt.DataDefinition.FormulaFields["Arrear"].Text = "'" + string.Format(dArrear.ToString()) + "'";
cryRpt.DataDefinition.FormulaFields["TotalPay"].Text = "'" + string.Format(dTotalPayAmt.ToString()) + "'";
if (dArrear == 0)
{
cryRpt.DataDefinition.FormulaFields["EndFiftenDate"].Text = String.Format("'{0}'", sHeader = sHeader = String.Format(" {0} ", sFifetDate.ToString("dd-MMM-yyyy")));
cryRpt.DataDefinition.FormulaFields["StartfiftenDate"].Text = String.Format("'{0}'", sHeader = sHeader = String.Format(" {0} ", sFifetDate.ToString("dd-MMM-yyyy")));
}
else
{
cryRpt.DataDefinition.FormulaFields["EndFiftenDate"].Text = String.Format("'{0}'", sHeader = sHeader = String.Format(" {0} ", sFifetDate.ToString("dd-MMM-yyyy")));
cryRpt.DataDefinition.FormulaFields["StartfiftenDate"].Text = String.Format("'{0}'", sHeader = sHeader = String.Format(" {0} ", sFifetDate.ToString("dd-MMM-yyyy")));
}
cryRpt.DataDefinition.FormulaFields["Period"].Text = String.Format("'{0}'", sHeader = sHeader = String.Format(" {0} to {1} ", dStartDate.ToString("dd-MMM-yyyy"), dEndDate.ToString("dd-MMM-yyyy")));
objReport.WindowState = FormWindowState.Maximized;
objReport.rptViewer.Refresh();
objReport.Show();
}
