public object DeleteDistrict(DistrictParam PM) { try { Tbl_District obj = db.Tbl_District.Where(r => r.DistrictID == PM.DistrictID).FirstOrDefault(); if (obj.Status == 1) { obj.Status = 0; } else { obj.Status = 1; } db.SaveChanges(); return(new Result() { IsSucess = true, ResultData = "District Deactivated Successfully." }); } catch (Exception e) { return(new Error() { IsError = true, Message = e.Message }); } }
// GET: District/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Tbl_District cat = db.Tbl_District.Find(id); if (cat == null) { return(HttpNotFound()); } return(View(cat)); }
// GET: District/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Tbl_District cat = db.Tbl_District.Find(id); db.Tbl_District.Remove(cat); db.SaveChanges(); if (cat == null) { return(HttpNotFound()); } return(RedirectToAction("Index")); }
public ActionResult Create(Tbl_District category) { try { if (ModelState.IsValid) { db.Tbl_District.Add(category); db.SaveChanges(); return(RedirectToAction("Index")); } // TODO: Add insert logic here return(View(category)); } catch { return(View()); } }
//District public object SaveDistrict(DistrictParam b) { if (b.District == null) { return(new Error() { IsError = true, Message = "Required District" }); } var data = db.Tbl_District.FirstOrDefault(r => r.District == b.District); if (data != null) { return(new Error() { IsError = true, Message = "Duplicate Entry Not Allowed" }); } try { Tbl_District obj = new Tbl_District(); obj.District = b.District; obj.StateID = b.StateID; obj.Status = 1; obj.CreatedBy = 1; obj.CreatedDate = System.DateTime.Today.Date; obj.ModifiedBy = null; obj.ModifiedDate = System.DateTime.Today.Date; db.Tbl_District.Add(obj); db.SaveChanges(); return(new Result() { IsSucess = true, ResultData = "Created District" }); } catch (Exception e) { return(new Error() { IsError = true, Message = e.Message }); } }
public ActionResult Edit(Tbl_District category) { try { if (ModelState.IsValid) { db.Entry(category).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } // TODO: Add update logic here return(View(category)); } catch { return(View()); } }