//----------------------------------------------- #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; } }