protected void txtLocationZipCode_TextChanged(object sender, EventArgs e)
{
DataTable dt = null;
dt = OrganizationInfo.GetCityStateAndCountryByZipCode(txtZipCode.Text.Trim(), _GlobalCountryID);
if (dt.Rows.Count > 0)
{
hdnLocationZipCodeID.Value = Convert.ToString(dt.Rows[0]["ZipcodeID"]);
// ToolkitScriptManager.RegisterStartupScript(this, this.GetType(), "txtLocationZipCode_TextChanged", String.Format("SetHiddenFieldValue('{0}','{1}');", hdnLocationZipCodeID.ClientID, Convert.ToString(dt.Rows[0]["ZipcodeID"])), true);
txtCity.Text = Convert.ToString(dt.Rows[0]["CityName"]);
//if (ddlLocationCountry.Items.FindByValue(Convert.ToString(dt.Rows[0]["CountryId"])) != null)
// ddlLocationCountry.SelectedValue = Convert.ToString(dt.Rows[0]["CountryId"]);
//if (Convert.ToBoolean(dt.Rows[0]["IsETF"]) == true)
//{
// chkboxetf.Checked = true;
//}
//else
//{
// chkboxetf.Checked = false;
//}
System.Data.SqlClient.SqlParameter[] prm;
prm = new System.Data.SqlClient.SqlParameter[1];
prm[0] = new System.Data.SqlClient.SqlParameter("@CountryId", _GlobalCountryID);
Utils.GetLookUpData <DropDownList>(ref ddlState, LookUps.State, prm);
prm = null;
if (ddlState.Items.FindByValue(Convert.ToString(dt.Rows[0]["StateId"])) != null)
{
ddlState.SelectedValue = Convert.ToString(dt.Rows[0]["StateId"]);
}
txtPhoneNum.Focus();
lblLocationZipCode.Text = "";
}
else
{
lblLocationZipCode.Text = "* Zipcode does not exist.";
}
}
protected void txtBusinessZipCode_TextChanged(object sender, EventArgs e)
{
DataTable dt = null;
double stateId = OrganizationInfo.getStateId(OrganizationID);
dt = OrganizationInfo.GetCityStateAndCountryByZipCode(txtZipCode.Text.Trim(), GlobalCountryID, stateId);
if (dt.Rows.Count > 0)
{
hdnBusinessZipCodeId.Value = Convert.ToString(dt.Rows[0]["ZipcodeID"]);
txtCity.Text = Convert.ToString(dt.Rows[0]["CityName"]);
if (ddlCountry.Items.FindByValue(Convert.ToString(dt.Rows[0]["CountryId"])) != null)
{
ddlCountry.SelectedValue = Convert.ToString(dt.Rows[0]["CountryId"]);
}
System.Data.SqlClient.SqlParameter[] prm;
prm = new System.Data.SqlClient.SqlParameter[1];
prm[0] = new System.Data.SqlClient.SqlParameter("@CountryId", ddlCountry.SelectedValue);
Utils.GetLookUpData <DropDownList>(ref ddlState, LookUps.State, prm);
prm = null;
if (ddlState.Items.FindByValue(Convert.ToString(dt.Rows[0]["StateId"])) != null)
{
ddlState.SelectedValue = Convert.ToString(dt.Rows[0]["StateId"]);
}
txtBusinessAddress1.Focus();
lblBusinessZipCode.Text = "";
}
else
{
txtZipCode.Text = "";
txtZipCode.Focus();
lblBusinessZipCode.Text = "* Zipcode does not exist in this state.";
}
lblinfo.Visible = false;
}
protected void lnkbtnUpdate_Click(object sender, EventArgs e)
{
// int stateId = OrganizationInfo.getStateId(OrganizationID);
//int organizationIdWithSimilerEmail = OrganizationInfo.getOrganizationIdByEmail(txtPrimaryEmail.Text.Trim(), stateId);
//if (organizationIdWithSimilerEmail > 0)
//{
// lblemailalreadyexists.Text = "Email already exists for this state. Choose another";
// lblemailalreadyexists.Visible = true;
// return;
//}
DataTable dt = null;
double stateId = OrganizationInfo.getStateId(OrganizationID);
dt = OrganizationInfo.GetCityStateAndCountryByZipCode(txtZipCode.Text.Trim(), GlobalCountryID, stateId);
if (dt.Rows.Count > 0)
{
}
else
{
txtZipCode.Text = "";
txtZipCode.Focus();
lblBusinessZipCode.Text = "* Zipcode does not exist in this state.";
return;
}
OrganizationInfo objOrg = new OrganizationInfo(OrganizationID);
if (dddlcelltextmsgs.SelectedValue == "1")
{
objOrg.CellAcceptTextMessages = true;
}
else
{
objOrg.CellAcceptTextMessages = false;
}
if (ddlbusinesstextmsgs.SelectedValue == "1")
{
objOrg.AcceptTextMessages = true;
}
else
{
objOrg.AcceptTextMessages = false;
}
objOrg.OrganizationId = OrganizationID;
// objOrg.Fax = txtFax.Text.Trim();
// objOrg.Address = txtAddress.Text.Trim();
// objOrg.BusinessType = txtBusinessType.Text.Trim();
// objOrg.BillMailAddress = txtBillingMailAddress.Text.Trim();
// objOrg.BillingContact = txtBillingContact.Text.Trim();
// objOrg.CellExtension = txtCellPhoneExtension.Text.Trim();
objOrg.LegalName = txtBusinessName.Text.Trim();
objOrg.DBAName = txtDBAName.Text.Trim();
objOrg.Website = txtWebsite.Text.Trim();
objOrg.IsActive = true;
objOrg.IsOrganization = true;
objOrg.LanguageId = LanguageId;
objOrg.ContactTitleName = txtContactTitle.Text.Trim();
objOrg.RoleId = Conversion.ParseInt(UserInfo.UserRole.Stewardship);
objOrg.UpdateOrganizationInfo();
ContactInfo objPrimaryContact = new ContactInfo();
objPrimaryContact.FirstName = txtFirstName.Text.Trim();
objPrimaryContact.LastName = txtLastName.Text.Trim();
objPrimaryContact.Email = txtPrimaryEmail.Text.Trim();
objPrimaryContact.IsActive = true;
objPrimaryContact.IsPrimary = true;
objPrimaryContact.LanguageId = LanguageId;
objPrimaryContact.ContactTypeId = Convert.ToInt32(LookupsManagement.LookupType.ContactTypes_Business);
Phones objPrimaryContactBusinessPhone = new Phones();
objPrimaryContactBusinessPhone.Number = txtPhoneNumber.Text.Trim().ToString();
objPrimaryContactBusinessPhone.Extension = txtPhoneExtension.Text.Trim().ToString();
objPrimaryContactBusinessPhone.IsActive = true;
objPrimaryContactBusinessPhone.PhoneTypeId = Convert.ToInt32(LookupsManagement.LookupType.PhoneType_Business);
Phones objPrimaryContactCellPhone = new Phones();
objPrimaryContactCellPhone.Number = txtCellPhoneNumber.Text.Trim();
objPrimaryContactCellPhone.IsActive = true;
objPrimaryContactCellPhone.PhoneTypeId = Convert.ToInt32(LookupsManagement.LookupType.PhoneType_Cell);
ContactInfo objBillingContact = new ContactInfo();
// objBillingContact.Email = txtBillingMailAddress.Text.Trim();
objBillingContact.IsActive = true;
objBillingContact.IsPrimary = false;
objBillingContact.LanguageId = LanguageId;
objBillingContact.ContactTypeId = Convert.ToInt32(ContactInfo.ContactTypes.Billing);
objBillingContact.ContactTypeId = Convert.ToInt32(LookupsManagement.LookupType.ContactTypes_Billing);
Phones objBillingContactBusinessPhone = new Phones();
objBillingContactBusinessPhone.IsActive = true;
objBillingContactBusinessPhone.PhoneTypeId = Convert.ToInt32(LookupsManagement.LookupType.PhoneType_Business);
Phones objBillingContactCellPhone = new Phones();
objBillingContactCellPhone.IsActive = true;
objBillingContactCellPhone.PhoneTypeId = Convert.ToInt32(LookupsManagement.LookupType.PhoneType_Cell);
OrganizationInfo.Organization_Address objBusinessOrganization_Address = new OrganizationInfo.Organization_Address();
objBusinessOrganization_Address.ZipCodeID = Convert.ToInt32(hdnBusinessZipCodeId.Value);
objBusinessOrganization_Address.ZipPostalCode = txtZipCode.Text.Trim().ToString();
objBusinessOrganization_Address.Address1 = txtBusinessAddress1.Text.Trim();
objBusinessOrganization_Address.Address2 = txtBusinessAddress2.Text.Trim();
objBusinessOrganization_Address.City = txtCity.Text.Trim().ToString();
objBusinessOrganization_Address.StateID = Convert.ToInt32(ddlState.SelectedValue);
objBusinessOrganization_Address.CountryID = Convert.ToInt32(ddlCountry.SelectedValue);
objBusinessOrganization_Address.DateCreated = DateTime.Now;
objBusinessOrganization_Address.IsActive = true;
objBusinessOrganization_Address.Organization_AddressTypeId = Convert.ToInt32(LookupsManagement.LookupType.OrganizationAddressType_Business);
OrganizationInfo.Organization_Address objMailingOrganization_Address = new OrganizationInfo.Organization_Address();
objMailingOrganization_Address.DateCreated = DateTime.Now;
objMailingOrganization_Address.IsActive = true;
objMailingOrganization_Address.Organization_AddressTypeId = Convert.ToInt32(LookupsManagement.LookupType.OrganizationAddressType_Mailing);
OrganizationInfo.UpdateStewardshipInfo(objOrg, objPrimaryContact, objPrimaryContactBusinessPhone, objPrimaryContactCellPhone, objBillingContact, objBillingContactBusinessPhone, objBillingContactCellPhone, objBusinessOrganization_Address, objMailingOrganization_Address);
lblinfo.Visible = true;
lblinfo.Text = "Successfully updated";
viewStakeholdersForApproval();
pnlDisplay.Visible = true;
pnlEdit.Visible = false;
}