protected void fillGrid()
{
ArrayList mBEList = BackEndObjects.MainBusinessEntity.getMainBusinessEntityListbyNameWithAddrDetailsDB(TextBox_Search_Contact.Text,
Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
if (mBEList == null || mBEList.Count == 0)
{
Label_Status_Search.Visible = true;
Label_Status_Search.ForeColor = System.Drawing.Color.Red;
Label_Status_Search.Text = "No company found for the given id";
GridView1.Visible = false;
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("Name");
dt.Columns.Add("Country");
dt.Columns.Add("State");
dt.Columns.Add("City");
dt.Columns.Add("Locality");
dt.Columns.Add("Street Name");
dt.Columns.Add("Mob");
dt.Columns.Add("Email");
dt.Columns.Add("Contact Exists?");
dt.Columns.Add("localId");
dt.Columns.Add("ContactEntId");
for (int i = 0; i < mBEList.Count; i++)
{
//MainBusinessEntity mBEObj = BackEndObjects.MainBusinessEntity.getMainBusinessEntitybyIdwithLessDetailsDB(TextBox_Search_Contact.Text);
MainBusinessEntity mBEObj = (MainBusinessEntity)mBEList[i];
AddressDetails mBEAddr = mBEObj.getAddressDetails();
Contacts contactObj = Contacts.
getContactDetailsforContactEntityDB(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString(), mBEObj.getEntityId());
Label_Status_Search.Visible = false;
BackEndObjects.Localities localObj = null;
BackEndObjects.City cityObj = null;
BackEndObjects.State stateObj = null;
BackEndObjects.Country countryObj = null;
if (mBEAddr.getLocalityId() != null && !mBEAddr.getLocalityId().Equals(""))
{
localObj = Localities.getLocalitybyIdDB(mBEAddr.getLocalityId());
cityObj = BackEndObjects.Localities.getCityDetailsforLocalitywoOtherAsscLocalitiesDB(mBEAddr.getLocalityId());
stateObj = BackEndObjects.City.getStateDetailsforCitywoOtherAsscCitiesDB(cityObj.getCityId());
countryObj = BackEndObjects.State.getCountryDetailsforStatewoOtherAsscStatesDB(stateObj.getStateId());
//Session[SessionFactory.CREATE_CONTACT_LOCALITY_ID] = localObj.getLocalityId();
//Session[SessionFactory.CREATE_CONTACT_ADDRESS_LINE1] = mBEAddr.getAddrLine1();
}
dt.Rows.Add();
dt.Rows[i]["Name"] = mBEObj.getEntityName();
if (mBEAddr.getLocalityId() != null && !mBEAddr.getLocalityId().Equals(""))
{
dt.Rows[i]["Country"] = countryObj.getCountryName();
dt.Rows[i]["State"] = stateObj.getStateName();
dt.Rows[i]["City"] = cityObj.getCityName();
dt.Rows[i]["Locality"] = localObj.getLocalityName();
dt.Rows[i]["Street Name"] = mBEAddr.getAddrLine1();
dt.Rows[i]["localId"] = mBEAddr.getLocalityId();
dt.Rows[i]["ContactEntId"] = mBEAddr.getMainBusinessId();
}
else
{
dt.Rows[i]["Country"] = "N/A";
dt.Rows[i]["State"] = "N/A";
dt.Rows[i]["City"] = "N/A";
dt.Rows[i]["Locality"] = "N/A";
dt.Rows[i]["Street Name"] = "N/A";
dt.Rows[i]["localId"] = "";
dt.Rows[i]["ContactEntId"] = mBEObj.getEntityId();
}
dt.Rows[i]["Mob"] = mBEObj.getPhNo();
dt.Rows[i]["Email"] = mBEObj.getEmailId();
dt.Rows[i]["Contact Exists?"] = ((contactObj.getContactEntityId() != null && !contactObj.getContactEntityId().Equals("")) ? "Y" : "N");
}
GridView1.DataSource = dt;
GridView1.DataBind();
GridView1.Visible = true;
GridView1.Columns[10].Visible = false;
GridView1.Columns[11].Visible = false;
Session[SessionFactory.CREATE_CONTACT_DATA_GRID] = dt;
}
}
