private void FillEnquiry()
{
dt = new DataTable();
DGvTrans.DataSource = LeadDL.ShowLeadName();
DGvTrans.ForceInitialize();
DGvTransView.PopulateColumns();
DGvTransView.Columns["LeadId"].Visible = false;
DGvTransView.Columns["CostCentreId"].Visible = false;
}
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;
}
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;
}