//-----------------------------------------------
#endregion
#region ---------------LoadData---------------
//-----------------------------------------------
//LoadData
//-----------------------------------------------
protected void LoadData()
{
if (MoversFW.Components.UrlManager.ChechIsValidIntegerParameter("id"))
{
int cityID = Convert.ToInt32(Request.QueryString["id"]);
CitiesEntity cities = CitiesFactory.GetObject(cityID);
if (cities != null)
{
trCountryID.Visible = CitiesOptions.HasCountryID;
{
LoadCountries();
ddlCountries.SelectedValue = cities.CountryID.ToString();
}
txtNameAr.Text = cities.NameAr;
txtNameEn.Text = cities.NameEn;
txtGoogleMapHorizontal.Text = cities.GoogleMapHorizontal.ToString();
txtGoogleMapVertical.Text = cities.GoogleMapVertical.ToString();
}
else
{
Response.Redirect("default.aspx");
}
}
else
{
Response.Redirect("default.aspx");
}
}
//-----------------------------------------------
#endregion
protected void btnSave_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
CitiesEntity cities = new CitiesEntity();
if (CitiesOptions.HasCountryID)
{
cities.CountryID = Convert.ToInt32(ddlCountries.SelectedValue);
}
cities.NameAr = txtNameAr.Text;
cities.NameEn = txtNameEn.Text;
if (!string.IsNullOrEmpty(txtGoogleMapHorizontal.Text))
{
cities.GoogleMapHorizontal = Convert.ToDouble(txtGoogleMapHorizontal.Text);
}
if (!string.IsNullOrEmpty(txtGoogleMapVertical.Text))
{
cities.GoogleMapVertical = Convert.ToDouble(txtGoogleMapVertical.Text);
}
bool status = CitiesFactory.Create(cities);
if (status)
{
General.MakeAlertSucess(lblResult, Resources.AdminText.SavingDataSuccessfuly);
ClearControls();
}
else
{
General.MakeAlertError(lblResult, Resources.AdminText.SavingDataFaild);
}
}
private CityDTO ToDTO(CitiesEntity ce)
{
CityDTO cdto = new CityDTO();
cdto.CreateDateTime = ce.CreateDateTime;
cdto.Id = ce.Id;
cdto.Name = ce.Name;
return(cdto);
}
//--------------------------------------------------------
#endregion
#region --------------dgCities_DeleteCommand--------------
//---------------------------------------------------------
//dgCities_DeleteCommand
//---------------------------------------------------------
protected void dgCities_DeleteCommand(object source, DataGridCommandEventArgs e)
{
int cityID = Convert.ToInt32(dgCities.DataKeys[e.Item.ItemIndex]);
CitiesEntity cities = CitiesFactory.GetObject(cityID);
if (CitiesFactory.Delete(cityID))
{
General.MakeAlertSucess(lblResult, Resources.AdminText.DeletingOprationDone);
//if one item in datagrid
if (dgCities.Items.Count == 1)
{
--pager.CurrentPage;
}
LoadData();
}
else
{
General.MakeAlertError(lblResult, Resources.AdminText.DeletingOprationFaild);
}
}
/// <summary>
/// 新增城市，返回新增的城市的ID
/// </summary>
/// <param name="cityName"></param>
/// <returns></returns>
public long AddNew(string cityName)
{
using (MyDbContext ctx = new MyDbContext())
{
BaseService <CitiesEntity> bs = new BaseService <CitiesEntity>(ctx);
//判断是否已经存在cityname名字的城市
//where(c=>c.Name==cityName).Count()>0,数据大时效率略低
//只是判断是否存在用any比where再count效率高
bool exists = bs.GetAll().Any(c => c.Name == cityName);
if (exists)
{
throw new ArgumentException("城市已经存在");
}
CitiesEntity city = new CitiesEntity();
city.Name = cityName;
ctx.Cities.Add(city);
ctx.SaveChanges();
//EF对自动增长的列SaveChanges之后，会把自动增长的列的值赋值回去
return(city.Id);
}
}
//-----------------------------------------------
#endregion
protected void btnSave_Click(object sender, EventArgs e)
{
if (MoversFW.Components.UrlManager.ChechIsValidIntegerParameter("id"))
{
if (!Page.IsValid)
{
return;
}
CitiesEntity cities = new CitiesEntity();
cities.CityID = Convert.ToInt32(Request.QueryString["id"]);
if (CitiesOptions.HasCountryID)
{
cities.CountryID = Convert.ToInt32(ddlCountries.SelectedValue);
}
cities.NameAr = txtNameAr.Text;
cities.NameEn = txtNameEn.Text;
if (!string.IsNullOrEmpty(txtGoogleMapHorizontal.Text))
{
cities.GoogleMapHorizontal = Convert.ToDouble(txtGoogleMapHorizontal.Text);
}
if (!string.IsNullOrEmpty(txtGoogleMapVertical.Text))
{
cities.GoogleMapVertical = Convert.ToDouble(txtGoogleMapVertical.Text);
}
bool status = CitiesFactory.Update(cities);
if (status)
{
Response.Redirect("default.aspx");
}
else
{
lblResult.CssClass = "lblResult_Faild";
lblResult.Text = Resources.AdminText.SavingDataFaild;
}
}
else
{
Response.Redirect("default.aspx");
}
}
//--------------------------------------------------------
#endregion
#region --------------dgCities_DeleteCommand--------------
//---------------------------------------------------------
//dgCities_DeleteCommand
//---------------------------------------------------------
protected void dgCities_DeleteCommand(object source, DataGridCommandEventArgs e)
{
int cityID = Convert.ToInt32(dgCities.DataKeys[e.Item.ItemIndex]);
CitiesEntity cities = CitiesFactory.GetObject(cityID);
if (CitiesFactory.Delete(cityID))
{
lblResult.ForeColor = Color.Blue;
lblResult.Text = Resources.AdminText.DeletingOprationDone;
//if one item in datagrid
if (dgCities.Items.Count == 1)
{
--pager.CurrentPage;
}
LoadData();
}
else
{
lblResult.CssClass = "lblResult_Faild";
lblResult.Text = Resources.AdminText.DeletingOprationFaild;
}
}
