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 FillData()
{
LeadBO oleedBO = new LeadBO();
if (TableName == "Religion")
{
dt_Religion = LeadDL.GetReligion();
DGVTrans.DataSource = dt_Religion;
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Name"].Width = 280;
oPickListBL.DtGetData.GetChanges();
}
if (TableName == "Acheivement")
{
oPickListBL.GetAcheivement(BsfGlobal.OpenCRMDB());
dt = oPickListBL.DtGetData;
DGVTrans.DataSource = oPickListBL.DtGetData;
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Description"].Width = 280;
}
if (TableName == "Country")
{
dt_Country = LeadDL.GetCountry();
DGVTrans.DataSource = dt_Country;
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Name"].Width = 280;
}
if (TableName == "Employment")
{
dt_Employ = LeadDL.GetEmpStatus();
DGVTrans.DataSource = dt_Employ;
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Name"].Width = 280;
}
if (TableName == "ApartmentType")
{
dt_ApaType = LeadDL.GetApartmentType();
DGVTrans.DataSource = dt_ApaType;
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Name"].Width = 280;
}
if (TableName == "Apartment")
{
dt_Apat = LeadDL.GetApartment();
DGVTrans.DataSource = dt_Apat;
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Name"].Width = 280;
}
if (TableName == "Stay")
{
dt_Stay = LeadDL.GetStay();
DGVTrans.DataSource = dt_Stay;
DGVTrans.ForceInitialize();
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Name"].Width = 280;
}
if (TableName == "GuestHouse")
{
dt_GHouse = LeadDL.GetGuestHouse();
DGVTrans.DataSource = dt_GHouse;
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Name"].Width = 280;
}
if (TableName == "PossessMaster")
{
dt_PossMas = LeadDL.GetPossessMaster();
DGVTrans.DataSource = dt_PossMas;
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Sel"].Visible = false;
dgvTransView.Columns["Name"].Width = 280;
}
if (TableName == "Possess")
{
oleedBO.i_LeadId = i_mId;
dt_Pose = LeadDL.ShowPossess(oleedBO);
DGVTrans.DataSource = dt_Pose;
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Sel"].Visible = false;
dgvTransView.Columns["LeadId"].Visible = false;
dgvTransView.Columns["Name"].Width = 280;
}
if (TableName == "FacilityMaster")
{
dt_FaciliMas = LeadDL.GetFacilityMaster();
DGVTrans.DataSource = dt_FaciliMas;
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Sel"].Visible = false;
dgvTransView.Columns["Name"].Width = 280;
}
if (TableName == "Facility")
{
oleedBO.i_LeadId = i_mId;
dt_Facili = LeadDL.ShowFacility(oleedBO);
DGVTrans.DataSource = dt_Facili;
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Sel"].Visible = false;
dgvTransView.Columns["LeadId"].Visible = false;
dgvTransView.Columns["Name"].Width = 280;
}
if (TableName == "LeadAreaMaster")
{
dt_AreaMas = LeadDL.GetAreaMaster();
DGVTrans.DataSource = dt_AreaMas;
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Sel"].Visible = false;
dgvTransView.Columns["LeadId"].Visible = false;
dgvTransView.Columns["Name"].Width = 280;
//oleedBO.i_LeadId = i_mId;
//dt_Ares = LeadDL.ShowArea(oleedBO);
//DGVTrans.DataSource = dt_Ares;
//dgvTransView.Columns["Id"].Visible = false;
//dgvTransView.Columns["Sel"].Visible = false;
//dgvTransView.Columns["LeadId"].Visible = false;
//dgvTransView.Columns["Name"].Width = 280;
}
if (TableName == "Area")
{
oleedBO.i_LeadId = i_mId;
dt_Ares = LeadDL.ShowArea(oleedBO);
DGVTrans.DataSource = dt_Ares;
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Sel"].Visible = false;
dgvTransView.Columns["LeadId"].Visible = false;
dgvTransView.Columns["Name"].Width = 280;
}
if (TableName == "Cost_Centre")
{
oPickListBL.GetCostCentre();
dtData = oPickListBL.DtGetData;
DGVTrans.DataSource = oPickListBL.DtGetData;
dgvTransView.Columns["Id"].Visible = false;
dgvTransView.Columns["Description"].Width = 250;
dgvTransView.Columns["Sel"].Width = 60;
dgvTransView.OptionsView.NewItemRowPosition = DevExpress.XtraGrid.Views.Grid.NewItemRowPosition.None;
dgvTransView.Columns["Description"].OptionsColumn.ReadOnly = true;
oPickListBL.DtGetData.AcceptChanges();
dtData.AcceptChanges();
}
}
