public long UpdateCity(TblCity entity) { var city = da.TblCity.Find(entity.ID); if (city != null) { try { // set data city.Name = entity.Name; city.Level = entity.Level; city.Status = entity.Status; city.PriceShip = entity.PriceShip; city.del_flg = Constant.DeleteFlag.NON_DELETE; city.ModifiedDate = DateTime.Now; city.ModifiedBy = CmnEntityModel.ID; da.SaveChanges(); } catch (Exception ex) { throw ex; } } else { return(0); } return(entity.ID); }
public async Task <IActionResult> Edit(int id, [Bind("CityId,CityName,StateId,CreateDate,UpdateDate,IsActive,IsDelete")] TblCity tblCity) { if (id != tblCity.CityId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(tblCity); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblCityExists(tblCity.CityId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["StateId"] = new SelectList(_context.TblState, "StateId", "StateId", tblCity.StateId); return(View(tblCity)); }
public async Task <DtoTblCity> AddCity(TblCity city) { HttpResponseMessage httpResponseMessage = await _httpClient.PostAsJsonAsync("api/CityCore/AddCity", city); DtoTblCity ans = await httpResponseMessage.Content.ReadAsAsync <DtoTblCity>(); return(ans); }
public DtoTblCity(TblCity city, HttpStatusCode statusEffect) { id = city.id; Name = city.Name; CountryId = city.CountryId; StatusEffect = statusEffect; }
public ActionResult AddCity(TblCity tblCity) { if (ModelState.IsValid) { //db.Fun_InsertCity(null, tblCity.CityName); db.TblCities.Add(tblCity); db.SaveChanges(); return(RedirectToAction("Create", "Home")); } return(View()); }
public long InsertCity(TblCity entity) { entity.CreatedDate = DateTime.Now; entity.CreatedBy = CmnEntityModel.ID; entity.ModifiedDate = DateTime.Now; entity.ModifiedBy = CmnEntityModel.ID; da.TblCity.Add(entity); da.SaveChanges(); return(entity.ID); }
public async Task <IActionResult> Create([Bind("CityId,CityName,StateId,CreateDate,UpdateDate,IsActive,IsDelete")] TblCity tblCity) { if (ModelState.IsValid) { _context.Add(tblCity); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["StateId"] = new SelectList(_context.TblState, "StateId", "StateName", tblCity.StateId); return(View(tblCity)); }
public async Task <bool> UpdateCity(TblCity city, int logId) { List <object> cityAndLogId = new List <object>(); cityAndLogId.Add(city); cityAndLogId.Add(logId); HttpResponseMessage httpResponseMessage = await _httpClient.PostAsJsonAsync("api/CityCore/UpdateCity", cityAndLogId); bool ans = await httpResponseMessage.Content.ReadAsAsync <bool>(); return(ans); }
internal CityModal GetCityByCityName(string cityname) { TblCity tblCity = _db.TblCities.Where(t => t.CityName == cityname).FirstOrDefault(); CityModal cityModal = new CityModal() { CityId = tblCity.Id, CityName = tblCity.CityName, State = tblCity.StateName }; return(cityModal); }
public ActionResult Edit(CityModel model) { try { using (ManageDistrictService service = new ManageDistrictService()) { if (ModelState.IsValid) { bool isNew = false; TblCity entity = new TblCity(); if (model.ID == 0) { isNew = true; model.CITY_ID = 1; model.Level = Constant.CityLevel.District; service.InsertCity(model); JsonResult result = Json(new { isNew = isNew }, JsonRequestBehavior.AllowGet); return(result); } else { isNew = false; model.CITY_ID = 1; model.Level = Constant.CityLevel.District; service.UpdateCity(model); JsonResult result = Json(new { isNew = isNew }, JsonRequestBehavior.AllowGet); return(result); } } else { var ErrorMessages = ModelState.Where(x => x.Value.Errors.Count > 0).Select(x => new { x.Key, x.Value.Errors }).ToArray(); } return(new EmptyResult()); } } catch (Exception ex) { Response.StatusCode = (int)System.Net.HttpStatusCode.BadRequest; System.Web.HttpContext.Current.Session["ERROR"] = ex; return(new EmptyResult()); } }
public IHttpActionResult AddCity(TblCity city) { var task = Task.Run(() => new CityService().AddCity(city)); if (task.Wait(TimeSpan.FromSeconds(10))) { if (task.Result.id != -1) { return(Ok(new DtoTblCity(city, HttpStatusCode.OK))); } else { return(Conflict()); } } return(StatusCode(HttpStatusCode.RequestTimeout)); }
public IHttpActionResult UpdateCity(List <object> cityLogId) { TblCity city = JsonConvert.DeserializeObject <TblCity>(cityLogId[0].ToString()); int logId = JsonConvert.DeserializeObject <int>(cityLogId[1].ToString()); var task = Task.Run(() => new CityService().UpdateCity(city, logId)); if (task.Wait(TimeSpan.FromSeconds(10))) { if (task.Result) { return(Ok(true)); } else { return(Conflict()); } } return(StatusCode(HttpStatusCode.RequestTimeout)); }
public static List<TblCity> GetCityListData(int districtId) { List<TblCity> list = new List<TblCity>(); var jss = new JavaScriptSerializer(); var dict = jss.Deserialize<dynamic>(BizDictionary.GetCityListByDistrictJS(districtId)); foreach (var itm in dict) { TblCity tbl = new TblCity(); tbl.Id = itm["Id"]; tbl.Name = itm["Name"]; tbl.CountryId = itm["CountryId"]; tbl.RegionId = itm["RegionId"]; tbl.Description = itm["Description"]; tbl.Latitude = itm["Latitude"]; tbl.Longitude = itm["Longitude"]; tbl.IsCapital = itm["IsCapital"]; list.Add(tbl); } var q = from p in list orderby p.IsCapital select p; return q.ToList(); }
public long UpdateCity(CityModel model) { long res = 0; // Declare new DataAccess object ManageDistrictDa dataAccess = new ManageDistrictDa(); using (var transaction = new TransactionScope()) { try { TblCity city = new TblCity(); city.ID = model.ID; city.Parent_Code = model.CITY_ID; city.Name = model.Name; city.Level = model.Level; city.Status = model.Status; city.PriceShip = model.PriceShip; city.del_flg = Constant.DeleteFlag.NON_DELETE; res = dataAccess.UpdateCity(city); if (res <= 0) { transaction.Dispose(); } transaction.Complete(); } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { transaction.Dispose(); } } return(res); }
public bool UpdateCity(TblCity city, int logId) { return(new CityRepo().UpdateCity(city, logId)); }
public TblCity AddCity(TblCity city) { return(new CityRepo().AddCity(city)); }
public bool UpdateCity(TblCity city, int logId) { return(new MainProvider().Update(city, logId)); }
public virtual TblCity AddCity(TblCity city) { return((TblCity) new MainProvider().Add(city)); }
public TblCity getCityByID(long Id) { TblCity product = da.TblCity.Where(s => s.ID == Id).SingleOrDefault(); return(product); }