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;
}
}
protected void Button_Change_Addr_Click(object sender, EventArgs e)
{
AddressDetails addrObj = BackEndObjects.AddressDetails.
getAddressforMainBusinessEntitybyIdDB(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
Dictionary <String, String> whereCls = new Dictionary <string, string>();
Dictionary <String, String> targetVals = new Dictionary <string, string>();
ArrayList addrObjList = new ArrayList();
Boolean update = false;
//If address is already present then its a update request
if (addrObj != null && addrObj.getMainBusinessId() != null)
{
update = true;
whereCls.Add(BackEndObjects.AddressDetails.ADDR_DETAILS_COL_BUSINESS_ID, Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
whereCls.Add(BackEndObjects.AddressDetails.ADDR_DETAILS_COL_CHAIN_ID, "");
targetVals.Add(BackEndObjects.AddressDetails.ADDR_DETAILS_COL_ADDR_LINE1, TextBox_Street_Name.Text);
targetVals.Add(BackEndObjects.AddressDetails.ADDR_DETAILS_COL_LOCALITY_ID, DropDownList_Locality.SelectedValue);
targetVals.Add(BackEndObjects.AddressDetails.ADDR_DETAILS_COL_BASE_CURR, DropDownList_Base_Curr.SelectedValue);
}
else
{
BackEndObjects.AddressDetails addressObj = new AddressDetails();
addressObj.setAddrLine1(TextBox_Street_Name.Text);
addressObj.setLocalityId(DropDownList_Locality.SelectedValue);
addressObj.setBaseCurrencyId(DropDownList_Base_Curr.SelectedValue);
addressObj.setMainBusinessId(Session[SessionFactory.MAIN_BUSINESS_ENTITY_ID_STRING].ToString());
addressObj.setSubEntityId(BackEndObjects.AddressDetails.DUMMY_CHAIN_ID);
addrObjList.Add(addressObj);
}
try
{
if (update)
{
BackEndObjects.AddressDetails.updateAddressEntityDB(targetVals, whereCls, DBConn.Connections.OPERATION_UPDATE);
}
else
{
BackEndObjects.AddressDetails.insertAddressEntityDB(addrObjList);
}
Label_Addr_Change_Stat.Visible = true;
Label_Addr_Change_Stat.Text = "Details updated successfully";
Label_Addr_Change_Stat.ForeColor = System.Drawing.Color.Green;
Label_Addr1.Text = TextBox_Street_Name.Text;
String localId = !DropDownList_Locality.SelectedValue.Equals("") ? DropDownList_Locality.SelectedValue :
!DropDownList_City.SelectedValue.Equals("") ? DropDownList_City.SelectedValue :
!DropDownList_State.SelectedValue.Equals("") ? DropDownList_State.SelectedValue : DropDownList_Country.SelectedValue;
loadLocalityDetails(localId);
}
catch (Exception ex)
{
Label_Addr_Change_Stat.Visible = true;
Label_Addr_Change_Stat.Text = "Update Failed";
Label_Addr_Change_Stat.ForeColor = System.Drawing.Color.Red;
}
}