private void fillDropdowns()
{
DC_Country_Search_RQ _objSearch = new DC_Country_Search_RQ();
_objSearch.PageNo = 0;
_objSearch.PageSize = 5000;
var result = _objMaster.GetCountryMasterData(_objSearch); //.Select(o => new { o.RegionCode, o.RegionName }).Where(y => y.RegionCode != null).Distinct();
divEntries.Style.Add(HtmlTextWriterStyle.Display, "block");
ddlRegion.DataSource = result.Select(o => new { o.RegionCode, o.RegionName }).Where(y => y.RegionCode != null && y.RegionCode != "").Distinct();
ddlRegion.DataValueField = "RegionCode";
ddlRegion.DataTextField = "RegionName";
ddlRegion.DataBind();
ddlKey.DataSource = result.Select(o => new { o.Key }).Where(y => y.Key != null && y.Key != "").Distinct();
ddlKey.DataValueField = "Key";
ddlKey.DataTextField = "Key";
ddlKey.DataBind();
ddlRank.DataSource = result.Select(o => new { o.Rank }).Where(y => y.Rank != null && y.Rank != "").Distinct();
ddlRank.DataValueField = "Rank";
ddlRank.DataTextField = "Rank";
ddlRank.DataBind();
ddlPriority.DataSource = result.Select(o => new { o.Priority }).Where(y => y.Priority != null && y.Priority != "").Distinct();
ddlPriority.DataValueField = "Priority";
ddlPriority.DataTextField = "Priority";
ddlPriority.DataBind();
}
private void fillCountryDetails(Guid newGuid)
{
try
{
var result = _objMaster.GetCountryMasterData(new MDMSVC.DC_Country_Search_RQ()
{
Country_Id = newGuid
});
if (result != null)
{
lblCountryName.InnerText = Convert.ToString(result[0].Name);
txtCountryName.Text = Convert.ToString(result[0].Name);
txtCountryCode.Text = Convert.ToString(result[0].Code);
txtRegionCode.Text = Convert.ToString(result[0].RegionCode);
txtRegionName.Text = Convert.ToString(result[0].RegionName);
txtRank.Text = Convert.ToString(result[0].Rank);
txtKey.Text = Convert.ToString(result[0].Key);
txtPriority.Text = Convert.ToString(result[0].Priority);
ddlStatus.SelectedValue = Convert.ToString(result[0].Status);
txt_ISOofficial_name_en.Text = Convert.ToString(result[0].ISOofficial_name_en);
txt_ISO3166_1_Alpha_2.Text = Convert.ToString(result[0].ISO3166_1_Alpha_2);
txt_ISO3166_1_Alpha_3.Text = Convert.ToString(result[0].ISO3166_1_Alpha_3);
txt_ISO3166_1_M49.Text = Convert.ToString(result[0].ISO3166_1_M49);
txt_ISO3166_1_ITU.Text = Convert.ToString(result[0].ISO3166_1_ITU);
txt_MARC.Text = Convert.ToString(result[0].MARC);
txt_WMO.Text = Convert.ToString(result[0].WMO);
txt_DS.Text = Convert.ToString(result[0].DS);
txt_Dial.Text = Convert.ToString(result[0].Dial);
txt_ISO4217_currency_alphabetic_code.Text = Convert.ToString(result[0].ISO4217_currency_alphabetic_code);
txt_ISO4217_currency_country_name.Text = Convert.ToString(result[0].ISO4217_currency_country_name);
txt_ISO4217_currency_minor_unit.Text = Convert.ToString(result[0].ISO4217_currency_minor_unit);
txt_ISO4217_currency_name.Text = Convert.ToString(result[0].ISO4217_currency_name);
txt_ISO4217_currency_numeric_code.Text = Convert.ToString(result[0].ISO4217_currency_numeric_code);
txt_ISO3166_1_Capital.Text = Convert.ToString(result[0].ISO3166_1_Capital);
txt_ISO3166_1_Continent.Text = Convert.ToString(result[0].ISO3166_1_Continent);
txt_ISO3166_1_TLD.Text = Convert.ToString(result[0].ISO3166_1_TLD);
txt_ISO3166_1_Languages.Text = Convert.ToString(result[0].ISO3166_1_Languages);
txt_ISO3166_1_Geoname_ID.Text = Convert.ToString(result[0].ISO3166_1_Geoname_ID);
txt_ISO3166_1_EDGAR.Text = Convert.ToString(result[0].ISO3166_1_EDGAR);
txt_GooglePlaceID.Text = Convert.ToString(result[0].GooglePlaceID);
}
}
catch
{
throw;
}
}
private void BindCountry()
{
var resultCountry = _objMaster.GetCountryMasterData(new MDMSVC.DC_Country_Search_RQ()
{
});
if (resultCountry != null)
{
if (resultCountry.Count > 0)
{
ddlCountryEdit.DataSource = resultCountry;
ddlCountryEdit.DataValueField = "Country_Id";
ddlCountryEdit.DataTextField = "Name";
ddlCountryEdit.DataBind();
ddlCountryEdit.Items.Insert(0, new ListItem {
Selected = true, Text = "- ALL -", Value = "0"
});
}
}
}
protected void frmvwCity_ItemCommand(object sender, FormViewCommandEventArgs e)
{
TextBox txtCityName = (TextBox)frmvwCity.FindControl("txtCityName");
TextBox txtCityCode = (TextBox)frmvwCity.FindControl("txtCityCode");
DropDownList ddlStates = (DropDownList)frmvwCity.FindControl("ddlStates");
DropDownList ddlStatus = (DropDownList)frmvwCity.FindControl("ddlStatus");
Guid ddlCountry_Id_Value = Guid.Parse(ddlCountry.SelectedValue);
if (Convert.ToString(e.CommandName) == "AddCity")
{
var stateid = Guid.Parse(Convert.ToString(ddlStates.SelectedValue).Trim());
var status = Convert.ToString(ddlStatus.SelectedValue);
MDMSVC.DC_City _objCityMaster = new MDMSVC.DC_City();
_objCityMaster.City_Id = Guid.NewGuid();
_objCityMaster.Name = Convert.ToString(txtCityName.Text).Trim();
_objCityMaster.Code = Convert.ToString(txtCityCode.Text).Trim();
_objCityMaster.State_Id = stateid;
//Get Country Details
var resultCountry = _objMasterData.GetCountryMasterData(new MDMSVC.DC_Country_Search_RQ()
{
Country_Id = ddlCountry_Id_Value
});
if (resultCountry != null)
{
_objCityMaster.Country_Id = ddlCountry_Id_Value;
_objCityMaster.CountryCode = resultCountry[0].Code;
_objCityMaster.CountryName = Convert.ToString(resultCountry[0].Name).Trim();
_objCityMaster.Google_PlaceId = Convert.ToString(resultCountry[0].GooglePlaceID);
}
//Get State detils
var resultState = _objMasterData.GetStatesMaster(new MDMSVC.DC_State_Search_RQ()
{
State_Id = stateid
});
if (resultState != null)
{
_objCityMaster.State_Id = stateid;
_objCityMaster.StateName = Convert.ToString(resultState[0].State_Name).Trim();
_objCityMaster.StateCode = Convert.ToString(resultState[0].State_Code).Trim();
}
_objCityMaster.Create_User = System.Web.HttpContext.Current.User.Identity.Name;
_objCityMaster.Create_Date = DateTime.Now;
_objCityMaster.Status = status;
MDMSVC.DC_Message _msg = _objMasterData.AddCityMasterData(_objCityMaster);
if (_msg.StatusCode == MDMSVC.ReadOnlyMessageStatusCode.Success)
{
fillgvCityyList(ddlCountry_Id_Value, 0);
hdnFlagCity.Value = "true";
dvMsgCity2.Visible = true;
BootstrapAlert.BootstrapAlertMessage(dvMsgCity2, _msg.StatusMessage, BootstrapAlertType.Success);
}
else
{
dvMsgCity2.Visible = true;
BootstrapAlert.BootstrapAlertMessage(dvmsgCityAlert, _msg.StatusMessage, (BootstrapAlertType)_msg.StatusCode);
}
}
txtCityName.Text = String.Empty;
txtCityCode.Text = String.Empty;
ddlStates.SelectedIndex = 0;
ddlStatus.SelectedIndex = 0;
}
