public ActionResult DeleteConfirmed(int id) { tbl_Reg tbl = db_obj.tbl_Reg.Find(id); db_obj.tbl_Reg.Remove(tbl); db_obj.SaveChanges(); return(RedirectToAction("Viewallfamily")); }
public ActionResult Deletedata(int?id) { tbl_Reg tbl = db_obj.tbl_Reg.Find(id); if (tbl == null) { return(HttpNotFound()); } return(View(tbl)); }
public ActionResult Addnewfamily(tbl_Reg tbl, FormCollection collection) { if (tbl.file.ContentLength > 0) { string fileName = Path.GetFileNameWithoutExtension(tbl.file.FileName); string extension = Path.GetExtension(tbl.file.FileName); fileName = fileName + DateTime.Now.ToString("yymmssff") + extension; tbl.Image = "~/App_file/images/" + fileName; fileName = Path.Combine(Server.MapPath("~/App_file/images/"), fileName); tbl.file.SaveAs(fileName); } var value = collection["Wardname"]; var text = collection["hidText"]; // ----------- -----// //save values to table try { if (ModelState.IsValid) { db_obj.tbl_Reg.Add(new tbl_Reg() { WardName = text, WardNumber = tbl.WardNumber, FamilyName = tbl.FamilyName, FamilyHead = tbl.FamilyHead, H_father_name = tbl.H_father_name, H_mother_name = tbl.H_mother_name, H_wife_name = tbl.H_wife_name, W_familyName = tbl.W_familyName, W_place = tbl.W_place, W_parish = tbl.W_parish, Mob_nob = tbl.Mob_nob, Landline = tbl.Landline, City = tbl.City, State = tbl.State, Town = tbl.Town, PO = tbl.PO, Landmark = tbl.Landmark, Prev_Parish = tbl.Prev_Parish, Prev_Dioceses = tbl.Prev_Dioceses, email = tbl.email, Occupation = tbl.Occupation, MonthlyIncome = tbl.MonthlyIncome, Image = tbl.Image, Time = DateTime.Now, }); db_obj.SaveChanges(); return(RedirectToAction("Addnewfamily")); } return(View(tbl)); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } }
public ActionResult Editdetail(tbl_Reg tbl) { db_obj.Entry(tbl).State = EntityState.Modified; db_obj.SaveChanges(); return(RedirectToAction("Viewallfamily")); }