private void FillCall()
{
m_bLayout = false;
DataTable dtCall = new DataTable();
dtCall = CallSheetEntryBL.PostGetCall();
grdCall.DataSource = null;
grdViewCall.Columns.Clear();
grdCall.DataSource = dtCall;
grdViewCall.PopulateColumns();
grdViewCall.Columns["LeadId"].Visible = false;
grdViewCall.Columns["CostCentreId"].Visible = false;
grdViewCall.Columns["NatureId"].Visible = false;
grdViewCall.Columns["CallTypeId"].Visible = false;
grdViewCall.Columns["FlatId"].Visible = false;
grdViewCall.Columns["PlotDetailsId"].Visible = false;
grdViewCall.Columns["FollowUpReq"].Visible = false;
grdViewCall.Columns["NextCallDate"].Visible = false;
grdViewCall.Columns["BuyerDate"].Visible = false;
grdViewCall.Columns["Remarks"].Visible = false;
grdViewCall.Columns["Mobile"].Visible = false;
grdViewCall.Columns["Email"].Visible = false;
grdViewCall.Columns["LeadId"].OptionsColumn.ShowInCustomizationForm = false;
grdViewCall.Columns["CostCentreId"].OptionsColumn.ShowInCustomizationForm = false;
grdViewCall.Columns["NatureId"].OptionsColumn.ShowInCustomizationForm = false;
grdViewCall.Columns["CallTypeId"].OptionsColumn.ShowInCustomizationForm = false;
grdViewCall.Columns["FlatId"].OptionsColumn.ShowInCustomizationForm = false;
grdViewCall.Columns["PlotDetailsId"].OptionsColumn.ShowInCustomizationForm = false;
grdViewCall.OptionsCustomization.AllowFilter = false;
grdViewCall.OptionsBehavior.AllowIncrementalSearch = true;
grdViewCall.OptionsView.ShowAutoFilterRow = false;
grdViewCall.OptionsView.ShowViewCaption = false;
grdViewCall.OptionsView.ShowFooter = false;
grdViewCall.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect;
grdViewCall.OptionsSelection.InvertSelection = false;
grdViewCall.OptionsView.ColumnAutoWidth = true;
grdViewCall.Appearance.HeaderPanel.Font = new Font(grdViewCall.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdViewCall.FocusedRowHandle = 0;
grdViewCall.FocusedColumn = grdViewCall.VisibleColumns[0];
grdViewCall.Appearance.FocusedCell.BackColor = Color.Teal;
grdViewCall.Appearance.FocusedCell.ForeColor = Color.White;
grdViewCall.Appearance.FocusedRow.ForeColor = Color.White;
grdViewCall.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewCall.OptionsSelection.EnableAppearanceHideSelection = false;
BsfGlobal.RestoreLayout("PostFollowup", grdViewCall);
m_bLayout = true;
}
private void PopulateBuyerCostSheet()
{
m_bLayout = false;
DataTable dt = new DataTable();
dt = FlatTypeBL.BuyerGetCostSheet(m_iCCId, m_bPayTypewise, m_iFlatId);
grdF1.DataSource = null;
grdViewF1.Columns.Clear();
DataView dv = new DataView(dt);
dv.RowFilter = "((ActualValue<>0 And DiscountValue<>0 And Type=true) or (Type=false))";
dt = dv.ToTable();
grdF1.DataSource = dt;
grdF1.ForceInitialize();
grdViewF1.PopulateColumns();
grdViewF1.Columns["ActualValue"].Visible = false;
grdViewF1.Columns["DiscountValue"].Visible = false;
grdViewF1.Columns["Type"].Visible = false;
grdViewF1.Columns["Description"].Width = 500;
grdViewF1.Columns["Actual"].Width = 250;
grdViewF1.Columns["Discount"].Width = 250;
grdViewF1.Columns["Discount"].Caption = "After Discount";
grdViewF1.Columns["Description"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["Actual"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["Discount"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.OptionsView.ShowFooter = true;
grdViewF1.OptionsView.ColumnAutoWidth = false;
grdViewF1.FocusedRowHandle = 0;
grdViewF1.FocusedColumn = grdViewF1.VisibleColumns[0];
grdViewF1.OptionsCustomization.AllowColumnMoving = true;
grdViewF1.OptionsSelection.InvertSelection = true;
grdViewF1.OptionsSelection.EnableAppearanceHideSelection = false;
grdViewF1.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewF1.Appearance.FocusedRow.ForeColor = Color.White;
BsfGlobal.RestoreLayout("Format1", grdViewF1);
m_bLayout = true;
}
private void PopulateGrid()
{
GrdLeadRegister.ForceInitialize();
grdLeadRegView.PopulateColumns();
grdLeadRegView.Columns["LeadName"].Group();
grdLeadRegView.ExpandAllGroups();
grdLeadRegView.Columns["LeadId"].Visible = false;
grdLeadRegView.Columns["CostCentreId"].Visible = false;
grdLeadRegView.Columns["CallTypeId"].Visible = false;
grdLeadRegView.Columns["LeadId"].OptionsColumn.ShowInCustomizationForm = false;
grdLeadRegView.Columns["CostCentreId"].OptionsColumn.ShowInCustomizationForm = false;
grdLeadRegView.Columns["CallTypeId"].OptionsColumn.ShowInCustomizationForm = false;
grdLeadRegView.Columns["LeadName"].Width = 200;
grdLeadRegView.Columns["LeadDate"].Width = 100;
grdLeadRegView.Columns["CampaignName"].Width = 150;
grdLeadRegView.Columns["Mobile"].Width = 120;
grdLeadRegView.Columns["Email"].Width = 150;
grdLeadRegView.Columns["CostCentre"].Width = 200;
grdLeadRegView.Columns["ExecutiveName"].Width = 150;
grdLeadRegView.Columns["Remarks"].Width = 150;
grdLeadRegView.Columns["Address1"].Width = 200;
grdLeadRegView.Columns["Address2"].Width = 200;
grdLeadRegView.Columns["Locality"].Width = 200;
grdLeadRegView.Columns["City"].Width = 150;
grdLeadRegView.Columns["PinCode"].Width = 100;
grdLeadRegView.Columns["Gender"].Width = 100;
grdLeadRegView.OptionsView.ShowFooter = true;
grdLeadRegView.Appearance.HeaderPanel.Font = new Font(grdLeadRegView.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdLeadRegView.OptionsSelection.InvertSelection = true;
grdLeadRegView.OptionsSelection.EnableAppearanceHideSelection = false;
grdLeadRegView.Appearance.FocusedRow.BackColor = Color.Teal;
grdLeadRegView.Appearance.FocusedRow.ForeColor = Color.White;
grdLeadRegView.OptionsView.ColumnAutoWidth = false;
//grdLeadRegView.BestFitColumns();
grdLeadRegView.FocusedRowHandle = 0;
grdLeadRegView.FocusedColumn = grdLeadRegView.VisibleColumns[0];
grdLeadRegView.Focus();
BsfGlobal.RestoreLayout("CRMLeadRegister", grdLeadRegView);
m_bLayOut = true;
}
private void PopulateAECostSheet()
{
m_bLayout = false;
DataTable dt = new DataTable();
if (m_sType == "AsOn")
{
dt = FlatTypeBL.GetAECostSheet(m_iCCId, m_bPayTypewise, Convert.ToDateTime(deDate.EditValue));
}
else
{
dt = FlatTypeBL.GetBWAECostSheet(m_iCCId, m_bPayTypewise, Convert.ToDateTime(deFrom), Convert.ToDateTime(deTo));
}
//DataView dv = new DataView(dt);
//dv.RowFilter = "PaidNetAmount<>0";
//dt = dv.ToTable();
grdF2.DataSource = null;
grdF2.DataSource = dt;
grdF2.ForceInitialize();
grdViewF2.PopulateColumns();
grdViewF2.Columns["FlatId"].Visible = false;
grdViewF2.Columns["FlatId"].OptionsColumn.ShowInCustomizationForm = false;
grdViewF2.Columns["BlockName"].Visible = false;
grdViewF2.Columns["LevelName"].Visible = false;
grdViewF2.Columns["Campaign"].Visible = false;
grdViewF2.Columns["Executive"].Visible = false;
if (Convert.ToBoolean(dt.Columns.Contains("Registration")) == false)
{
}
else
{
grdViewF2.Columns["Registration"].Visible = false;
}
grdViewF2.Columns["LeadName"].Caption = "BUYER NAME";
grdViewF2.Columns["FlatNo"].Caption = CommFun.m_sFuncName.ToUpper() + " NO";
grdViewF2.Columns["TypeName"].Caption = "TYPE NAME";
grdViewF2.Columns["BookingDate"].Caption = "BOOKING DATE";
grdViewF2.Columns["Area"].Caption = "AREA SQ.FT";
grdViewF2.Columns["Rate"].Caption = "RATE PER SQFT";
grdViewF2.Columns["BaseAmt"].Caption = "AMOUNT(RS)";
grdViewF2.Columns["LeadName"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF2.Columns["FlatNo"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF2.Columns["TypeName"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF2.Columns["Area"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF2.Columns["Rate"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF2.Columns["BaseAmt"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF2.Columns["BookingDate"].ColumnEdit = repositoryItemDateEdit2;
grdViewF2.Columns["Area"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewF2.Columns["Area"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewF2.Columns["Area"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewF2.Columns["Rate"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewF2.Columns["Rate"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewF2.Columns["Rate"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewF2.Columns["BaseAmt"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewF2.Columns["BaseAmt"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewF2.Columns["BaseAmt"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewF2.Columns["Area"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewF2.Columns["Area"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewF2.Columns["Rate"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewF2.Columns["Rate"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewF2.Columns["BaseAmt"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewF2.Columns["BaseAmt"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
for (int i = 9; i < dt.Columns.Count; i++)
{
grdViewF2.Columns[i].Caption = grdViewF2.Columns[i].FieldName.ToUpper();
grdViewF2.Columns[i].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewF2.Columns[i].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewF2.Columns[i].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewF2.Columns[i].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewF2.Columns[i].ColumnEdit = repositoryItemMemoEdit2;
if (Convert.ToDecimal(grdViewF2.Columns[i].SummaryItem.SummaryValue) == 0)
{
grdViewF2.Columns[i].Visible = false;
}
}
grdViewF2.Columns["AmountReceivedLand"].Caption = "AMOUNT RECEIVED FOR LAND ON REGN";
grdViewF2.Columns["LeadName"].Width = 200;
int x = grdViewF2.Columns["GrandTotal"].VisibleIndex;
grdViewF2.Columns["UDS"].VisibleIndex = x + 1;
int x1 = grdViewF2.Columns["UDS"].VisibleIndex;
grdViewF2.Columns["LandValue"].VisibleIndex = x1 + 1;
grdViewF2.OptionsView.RowAutoHeight = true;
grdViewF2.OptionsView.ShowFooter = true;
grdViewF2.OptionsView.ColumnAutoWidth = false;
grdViewF2.FocusedRowHandle = 0;
grdViewF2.FocusedColumn = grdViewF2.VisibleColumns[0];
grdViewF2.OptionsCustomization.AllowColumnMoving = true;
grdViewF2.OptionsSelection.InvertSelection = true;
grdViewF2.OptionsSelection.EnableAppearanceHideSelection = false;
grdViewF2.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewF2.Appearance.FocusedRow.ForeColor = Color.White;
grdViewF2.BestFitColumns();
BsfGlobal.RestoreLayout("Format2", grdViewF2);
m_bLayout = true;
}
private void PopulateCostSheet()
{
m_bLayout = false;
DataTable dt = new DataTable();
dt = FlatTypeBL.GetCostSheet(m_iCCId, m_bPayTypewise);
grdF1.DataSource = null;
grdViewF1.Columns.Clear();
grdF1.DataSource = dt;
grdF1.ForceInitialize();
grdViewF1.PopulateColumns();
grdViewF1.Columns["BlockName"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["LevelName"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["TypeName"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["FlatNo"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["Status"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["Area"].ColumnEdit = repositoryItemMemoEdit1;
grdViewF1.Columns["FlatId"].Visible = false;
grdViewF1.Columns["FlatId"].OptionsColumn.ShowInCustomizationForm = false;
grdViewF1.Columns["Area"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewF1.Columns["Area"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewF1.Columns["Area"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewF1.Columns["Area"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewF1.Columns["Area"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
for (int i = 6; i < dt.Columns.Count; i++)
{
string sName = grdViewF1.Columns[i].FieldName;
grdViewF1.Columns[sName].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewF1.Columns[sName].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewF1.Columns[sName].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewF1.Columns[sName].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewF1.Columns[sName].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewF1.Columns[sName].ColumnEdit = repositoryItemMemoEdit1;
if (Convert.ToDecimal(grdViewF1.Columns[sName].SummaryItem.SummaryValue) == 0)
{
grdViewF1.Columns[sName].Visible = false;
}
}
grdViewF1.Columns["Total"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewF1.Columns["Total"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewF1.Columns["Total"].Caption = "Grand Total";
grdViewF1.Columns["FlatNo"].Caption = CommFun.m_sFuncName + " No";
grdViewF1.OptionsView.RowAutoHeight = true;
grdViewF1.OptionsView.ShowFooter = true;
grdViewF1.OptionsView.ColumnAutoWidth = false;
grdViewF1.FocusedRowHandle = 0;
grdViewF1.FocusedColumn = grdViewF1.VisibleColumns[0];
grdViewF1.OptionsCustomization.AllowColumnMoving = true;
grdViewF1.OptionsSelection.InvertSelection = true;
grdViewF1.OptionsSelection.EnableAppearanceHideSelection = false;
grdViewF1.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewF1.Appearance.FocusedRow.ForeColor = Color.White;
grdViewF1.BestFitColumns();
BsfGlobal.RestoreLayout("Format1", grdViewF1);
m_bLayout = true;
}
public void FillData()
{
m_bLayOut = false;
grdReceipt.DataSource = null;
dt = new DataTable();
dt = ReceiptDetailBL.GetReceiptRegister();
if (dt == null)
{
return;
}
Cursor.Current = Cursors.WaitCursor;
grdReceipt.DataSource = dt;
grdReceipt.ForceInitialize();
grdViewReceipt.PopulateColumns();
grdViewReceipt.Columns["ReceiptId"].Visible = false;
grdViewReceipt.Columns["ReceiptId"].OptionsColumn.ShowInCustomizationForm = false;
grdViewReceipt.Columns["Narration"].Visible = false;
grdViewReceipt.Columns["ReceiptDate"].Width = 50;
grdViewReceipt.Columns["ReceiptDate"].Caption = "Ref. Date";
grdViewReceipt.Columns["ReceiptDate"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
grdViewReceipt.Columns["ReceiptDate"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
grdViewReceipt.Columns["ReceiptNo"].Width = 60;
grdViewReceipt.Columns["ReceiptNo"].Caption = "Ref. No";
grdViewReceipt.Columns["ReceiptNo"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
grdViewReceipt.Columns["ReceiptNo"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
grdViewReceipt.Columns["CostCentreId"].Visible = false;
grdViewReceipt.Columns["CostCentreId"].OptionsColumn.ShowInCustomizationForm = false;
grdViewReceipt.Columns["BuyerName"].Width = 150;
grdViewReceipt.Columns["BuyerName"].Caption = "Buyer";
grdViewReceipt.Columns["BuyerName"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
grdViewReceipt.Columns["BuyerName"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
grdViewReceipt.Columns["FlatNo"].Width = 80;
grdViewReceipt.Columns["FlatNo"].Caption = CommFun.m_sFuncName + " No";
grdViewReceipt.Columns["FlatNo"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
grdViewReceipt.Columns["FlatNo"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
grdViewReceipt.Columns["CostCentreName"].Width = 170;
grdViewReceipt.Columns["CostCentreName"].Caption = "Project";
grdViewReceipt.Columns["CostCentreName"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
grdViewReceipt.Columns["CostCentreName"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
grdViewReceipt.Columns["Amount"].Width = 70;
grdViewReceipt.Columns["Amount"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewReceipt.Columns["Amount"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
grdViewReceipt.Columns["Amount"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewReceipt.Columns["Amount"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewReceipt.Columns["Amount"].DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
grdViewReceipt.Columns["Amount"].DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
grdViewReceipt.Columns["PaymentAgainst"].Width = 100;
grdViewReceipt.Columns["PaymentAgainst"].Caption = "Pay Type";
grdViewReceipt.Columns["PaymentAgainst"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
grdViewReceipt.Columns["PaymentAgainst"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
grdViewReceipt.Columns["Approve"].Width = 80;
grdViewReceipt.Columns["Approve"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdViewReceipt.Columns["Approve"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdViewReceipt.Columns["ChequeDisbursement"].Width = 100;
grdViewReceipt.Columns["ChequeDisbursement"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdViewReceipt.Columns["ChequeDisbursement"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
grdViewReceipt.OptionsBehavior.AllowIncrementalSearch = true;
grdViewReceipt.OptionsView.ShowAutoFilterRow = true;
grdViewReceipt.FocusedRowHandle = 0;
grdViewReceipt.FocusedColumn = grdViewReceipt.VisibleColumns[0];
grdViewReceipt.OptionsSelection.InvertSelection = true;
grdViewReceipt.OptionsSelection.EnableAppearanceHideSelection = false;
grdViewReceipt.Appearance.FocusedRow.BackColor = Color.Teal;
grdViewReceipt.Appearance.FocusedRow.ForeColor = Color.White;
BsfGlobal.RestoreLayout("CRMReceiptRegister", grdViewReceipt);
m_bLayOut = true;
Cursor.Current = Cursors.Default;
}
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;
}