public string InsertOrUpdate(CityModel CM) { string result = string.Empty; bool IsExsit = false; tbl_City City; City = this.GetById(CM.CityID.Trim()); if (City != null) { IsExsit = true; } else { City = new tbl_City(); } City.CityID = CM.CityID; City.CityName = CM.CityName; if (!IsExsit) { return(result = this.Insert(City)); } else { return(result = this.Update(City)); } }
public string InsertOrUpdateCity(CityModel CM) { tbl_City City = new tbl_City(); City.CityID = CM.CityID; City.CityName = CM.CityName; return(CityBL.InsertOrUpdate(CM)); }
public ActionResult DeleteTT(int id) { tbl_City tbl_City = db.tbl_City.Find(id); db.tbl_City.Remove(tbl_City); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ID_City,City_Name,CreateBy,UpdateBy,CreateDate,UpdateDate,Status")] tbl_City tbl_City) { if (ModelState.IsValid) { tbl_City.UpdateDate = DateTime.Now; db.Entry(tbl_City).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbl_City)); }
public ActionResult Create([Bind(Include = "ID_City,City_Name,CreateBy,UpdateBy,CreateDate,UpdateDate,Status")] tbl_City tbl_City) { if (ModelState.IsValid) { tbl_City.CreateDate = DateTime.Now; db.tbl_City.Add(tbl_City); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tbl_City)); }
// GET: Admin/tbl_Citys/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_City tbl_City = db.tbl_City.Find(id); if (tbl_City == null) { return(HttpNotFound()); } return(View(tbl_City)); }
public PartialViewResult GetCityById(string CityID) { CityModel CM = new CityModel(); tbl_City city; city = CityBL.GetById(CityID); if (city == null) { city = new tbl_City(); } CM.CityID = city.CityID; CM.CityName = city.CityName; return(PartialView("~/Views/City/Partial/_CityDetailsPartial.cshtml", CM)); }
/// <summary> /// Update City /// </summary> /// <param name="City"></param> /// <returns></returns> public string Update(tbl_City city) { try { Context.City.Update(city); Context.City.Save(); return(city.CityID + " Updated Successfully!!"); } catch (Exception ex) { //POS Log Exception to db table return("Error in saving details, Please try again!!"); } finally { // Context = null; } }
public long SaveUpdateCity(CityModel model) { ShomaRMEntities db = new ShomaRMEntities(); var userNameExists = db.tbl_City.Where(p => p.ID != model.ID && p.CityName == model.CityName).FirstOrDefault(); if (userNameExists == null) { if (model.ID == 0) { var userData = new tbl_City() { CityName = model.CityName, StateID = model.StateID, }; db.tbl_City.Add(userData); db.SaveChanges(); model.ID = userData.ID; } else { var cityInfo = db.tbl_City.Where(p => p.ID == model.ID).FirstOrDefault(); if (cityInfo != null) { cityInfo.CityName = model.CityName; cityInfo.StateID = model.StateID; db.SaveChanges(); } else { throw new Exception(model.CityName + " not exists in the system."); } } return(model.ID); } else { throw new Exception(model.CityName + " already exists in the system."); } }