public void FillData()
{
DGVTrans.DataSource = null;
BsfGlobal.OpenCRMDB();
string sql = "SELECT OtherCostId,OtherCostName,SysDefault FROM OtherCostMaster Where Area=" + iArea + " ORDER BY OtherCostName";
SqlDataAdapter sda = new SqlDataAdapter(sql, BsfGlobal.g_CRMDB);
dt = new DataTable();
sda.Fill(dt);
sda.Dispose();
BsfGlobal.g_CRMDB.Close();
if (dt == null)
{
return;
}
DGVTrans.DataSource = dt;
DGVTrans.ForceInitialize();
DGvTransView.PopulateColumns();
DGvTransView.Columns["OtherCostId"].Visible = false;
DGvTransView.Columns["SysDefault"].Visible = false;
dt.GetChanges();
DGvTransView.OptionsView.ShowFooter = false;
DGvTransView.OptionsSelection.InvertSelection = true;
DGvTransView.OptionsSelection.EnableAppearanceHideSelection = false;
DGvTransView.Appearance.FocusedRow.BackColor = Color.Teal;
DGvTransView.Appearance.FocusedRow.ForeColor = Color.White;
}
private void FillOtherExecregPost()
{
//deTo.EditValue = Convert.ToDateTime(DateTime.Now.ToShortDateString());
string fdate = string.Format("{0:dd MMM yyyy}", Convert.ToDateTime(deFrom.EditValue));
if (deTo.EditValue == null)
{
deTo.EditValue = Convert.ToDateTime(DateTime.Now);
}
string tdate = string.Format("{0:dd MMM yyyy}", Convert.ToDateTime(deTo.EditValue));//.AddDays(1));
dtCallSht = new DataTable();
dtCallSht = CallSheetEntryBL.GetOtherReportPost(fdate, tdate, Convert.ToBoolean(ChkExec.EditValue));
DGvTrans.DataSource = dtCallSht;
DGvTransView.PopulateColumns();
DGvTransView.Columns["ExecName"].Group();
DGvTransView.Columns["NextCallDate"].Group();
DGvTransView.ExpandAllGroups();
DGvTransView.Appearance.HeaderPanel.Font = new Font(DGvTransView.Appearance.HeaderPanel.Font, FontStyle.Bold);
DGvTransView.Appearance.FocusedCell.BackColor = Color.Teal;
DGvTransView.Appearance.FocusedCell.ForeColor = Color.White;
DGvTransView.Appearance.FocusedRow.ForeColor = Color.Teal;
DGvTransView.Appearance.FocusedRow.BackColor = Color.White;
DGvTransView.OptionsSelection.EnableAppearanceHideSelection = false;
}
private void FillEnquiry()
{
dt = new DataTable();
DGvTrans.DataSource = LeadDL.ShowLeadName();
DGvTrans.ForceInitialize();
DGvTransView.PopulateColumns();
DGvTransView.Columns["LeadId"].Visible = false;
DGvTransView.Columns["CostCentreId"].Visible = false;
}
public void FillData()
{
try
{
m_dt = new DataTable();
m_dt = ComplaintDetBL.Populate_ComplaintRegister(Convert.ToDateTime(dtpFrmDate.EditValue), Convert.ToDateTime(dtpToDate.EditValue));
DGvTrans.DataSource = m_dt;
DGvTransView.PopulateColumns();
DGvTransView.Columns["ComplaintId"].Visible = false;
DGvTransView.Columns["CostCentreId"].Visible = false;
DGvTransView.Columns["ComplaintNo"].Width = 75;
DGvTransView.Columns["CostCentreName"].Width = 100;
DGvTransView.Columns["AttendedBy"].Width = 100;
DGvTransView.Columns["FlatNo"].Caption = CommFun.m_sFuncName + " No";
DGvTransView.Columns["TransDate"].OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False;
DGvTransView.Columns["DateAttented"].OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False;
DGvTransView.Columns["Approve"].OptionsColumn.AllowGroup = DevExpress.Utils.DefaultBoolean.False;
DGvTransView.Columns["ComplaintNo"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["ComplaintNo"].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["TransDate"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["TransDate"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["DateAttented"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["DateAttented"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["Approve"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
DGvTransView.Columns["Approve"].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 btnFilter_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (BsfGlobal.FindPermission("Lead-Filter") == false)
{
MessageBox.Show("You don't have Rights to Lead-Filter");
return;
}
DataTable dt = new DataTable();
m_Filter = "";
frmFilter fFilter = new frmFilter();
if (m_dtFil.Rows.Count > 0)
{
fFilter.Exe(m_dtFil, fromDate, toDate);
}
m_Filter = fFilter.Execute(fromDate, toDate);
if (m_Filter != "")
{
m_dtFil = fFilter.m_dtFilter;
dt = CommFun.FillRecord(m_Filter);
DGvTrans.DataSource = dt;
DGvTrans.ForceInitialize();
DGvTransView.PopulateColumns();
DGvTransView.Columns["LeadId"].Visible = false;
DGvTransView.Columns["CostCentreId"].Visible = false;
panelLeadEntry.Controls.Clear();
frmLeadInfo LeadInfo = new frmLeadInfo()
{
TopLevel = false, FormBorderStyle = FormBorderStyle.None, Dock = DockStyle.Fill
};
panelLeadEntry.Controls.Add(LeadInfo);
LeadInfo.Execute("E", Convert.ToInt32(DGvTransView.GetFocusedRowCellValue("LeadId")), Convert.ToInt32(DGvTransView.GetFocusedRowCellValue("CostCentreId")), "LeadReg");
}
else
{
m_dtFil.Clear();
//FillEnquiry();
}
DGvTransView.FocusedRowHandle = i;
}
public void fillData()
{
try
{
dt = new DataTable();
dt = BankBL.GetBankRegister();
DGvTrans.DataSource = dt;
DGvTransView.PopulateColumns();
DGvTransView.Columns["BankId"].Visible = false;
DGvTransView.Columns["BranchId"].Visible = false;
DGvTransView.Appearance.HeaderPanel.Font = new Font(DGvTransView.Appearance.HeaderPanel.Font, FontStyle.Bold);
DGvTransView.Appearance.FocusedCell.BackColor = Color.Teal;
DGvTransView.Appearance.FocusedCell.ForeColor = Color.White;
DGvTransView.Appearance.FocusedRow.ForeColor = Color.Teal;
DGvTransView.Appearance.FocusedRow.BackColor = Color.White;
DGvTransView.OptionsSelection.EnableAppearanceHideSelection = false;
}
catch (Exception e)
{
throw e;
}
}
public void FillData()
{
try
{
m_dt = new DataTable();
m_dt = RentDetBL.PopulateRentRegister(Convert.ToDateTime(dtpFrmDate.EditValue), Convert.ToDateTime(dtpToDate.EditValue));
DGvTrans.DataSource = m_dt;
DGvTransView.PopulateColumns();
RepositoryItemTextEdit txtEditAdvAmt = new RepositoryItemTextEdit();
txtEditAdvAmt.LookAndFeel.UseDefaultLookAndFeel = false;
txtEditAdvAmt.Mask.EditMask = BsfGlobal.g_sDigitFormat;
txtEditAdvAmt.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
txtEditAdvAmt.Mask.UseMaskAsDisplayFormat = true;
RepositoryItemTextEdit txtEditAmt = new RepositoryItemTextEdit();
txtEditAmt.LookAndFeel.UseDefaultLookAndFeel = false;
txtEditAmt.Mask.EditMask = BsfGlobal.g_sDigitFormat;
txtEditAmt.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
txtEditAmt.Mask.UseMaskAsDisplayFormat = true;
DGvTransView.Columns["AdvanceAmount"].ColumnEdit = txtEditAdvAmt;
DGvTransView.Columns["Rent"].ColumnEdit = txtEditAmt;
DGvTransView.Columns["RentId"].Visible = false;
DGvTransView.Columns["CostCentreId"].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["Approve"].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.Columns["RentType"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
DGvTransView.Columns["RentType"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
//DGvTransView.Columns["Approve"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
//DGvTransView.Columns["Approve"].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 PopulateData()
{
m_bLayOut = false;
//dETo.EditValue = Convert.ToDateTime(DateTime.Now.ToShortDateString());
fromDate = Convert.ToDateTime(dEFrm.EditValue);
if (dETo.EditValue == null)
{
dETo.EditValue = Convert.ToDateTime(DateTime.Now);
}
toDate = Convert.ToDateTime(dETo.EditValue);
string fdate = string.Format("{0:dd MMM yyyy}", fromDate);
string tdate = string.Format("{0:dd MMM yyyy}", toDate);//.AddDays(1));
dt = new DataTable();
dt = LeadBL.ShowLeadDate(fdate, tdate, Convert.ToBoolean(chkExec.EditValue));
DGvTrans.DataSource = dt;
DGvTrans.ForceInitialize();
DGvTransView.PopulateColumns();
DGvTransView.Columns["LeadId"].Visible = false;
DGvTransView.Columns["CostCentreId"].Visible = false;
DGvTransView.Columns["LeadDate"].Visible = false;
DGvTransView.Columns["Mobile"].Visible = false;
DGvTransView.Columns["Email"].Visible = false;
DGvTransView.Columns["CostCentre"].Visible = false;
DGvTransView.Columns["ExecutiveName"].Visible = false;
DGvTransView.Columns["LeadName"].Width = 240;
DGvTransView.Columns["LeadId"].OptionsColumn.ShowInCustomizationForm = false;
DGvTransView.Columns["CostCentreId"].OptionsColumn.ShowInCustomizationForm = false;
DGvTransView.Columns["Email"].OptionsColumn.ShowInCustomizationForm = false;
DGvTransView.Columns["CostCentre"].OptionsColumn.ShowInCustomizationForm = false;
DGvTransView.Columns["ExecutiveName"].OptionsColumn.ShowInCustomizationForm = false;
DGvTransView.OptionsCustomization.AllowFilter = true;
DGvTransView.OptionsBehavior.AllowIncrementalSearch = true;
DGvTransView.OptionsView.ShowAutoFilterRow = true;
DGvTransView.OptionsView.ShowViewCaption = false;
DGvTransView.OptionsView.ShowFooter = true;
DGvTransView.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect;
DGvTransView.OptionsSelection.InvertSelection = false;
DGvTransView.OptionsView.ColumnAutoWidth = false;
DGvTransView.Appearance.HeaderPanel.Font = new Font(DGvTransView.Appearance.HeaderPanel.Font, FontStyle.Bold);
DGvTransView.FocusedRowHandle = 0;
DGvTransView.FocusedColumn = DGvTransView.VisibleColumns[0];
int m_LeadId = 0;
panelLeadEntry.Controls.Clear();
if (DGvTransView.FocusedRowHandle >= 0)
{
m_LeadId = Convert.ToInt32(DGvTransView.GetFocusedRowCellValue("LeadId"));
string s_LeadName = DGvTransView.GetFocusedRowCellValue("LeadName").ToString();
int iCCId = Convert.ToInt32(CommFun.IsNullCheck(DGvTransView.GetFocusedRowCellValue("CostCentreId"), CommFun.datatypes.vartypenumeric));
frmLeadInfo LeadInfo = new frmLeadInfo()
{
TopLevel = false, FormBorderStyle = FormBorderStyle.None, Dock = DockStyle.Fill
};
panelLeadEntry.Controls.Add(LeadInfo);
LeadInfo.Execute("E", m_LeadId, iCCId, "LeadReg");
}
DGvTransView.Appearance.HeaderPanel.Font = new Font(DGvTransView.Appearance.HeaderPanel.Font, FontStyle.Bold);
DGvTransView.Appearance.FocusedCell.BackColor = Color.Teal;
DGvTransView.Appearance.FocusedCell.ForeColor = Color.White;
DGvTransView.Appearance.FocusedRow.ForeColor = Color.Teal;
DGvTransView.Appearance.FocusedRow.BackColor = Color.White;
DGvTransView.OptionsSelection.EnableAppearanceHideSelection = false;
//DGvTransView.BestFitColumns();
BsfGlobal.RestoreLayout("CRMLeadRegister", DGvTransView);
m_bLayOut = true;
}