public bool Add(User suser) { int isExecuted = 0; db.Users.Add(suser); isExecuted = db.SaveChanges(); if (isExecuted > 0) { return(true); } else { return(false); } }
public bool Add(Category sCategory) { int isExecuted = 0; db.Categories.Add(sCategory); isExecuted = db.SaveChanges(); if (isExecuted > 0) { return(true); } else { return(false); } }
public ActionResult Register(User user) { if (ModelState.IsValid) { using (SBMS_DBContext db = new SBMS_DBContext()) { var get_user = db.Users.FirstOrDefault(p => p.UserName == user.UserName); if (get_user == null) { user.Password = user.Password; db.Users.Add(user); db.SaveChanges(); } else { ViewBag.Message = "UserName already exists"; return(View()); } } ModelState.Clear(); ViewBag.Message = "Successfully Registered Mr. " + user.FullName; } return(RedirectToAction("Login")); }
public ActionResult AddOrEdit(Product product) { using (SBMS_DBContext db = new SBMS_DBContext()) { if (product.Id == 0) { db.Products.Add(product); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { db.Entry(product).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult AddOrEdit(Customer customer) { using (SBMS_DBContext db = new SBMS_DBContext()) { if (customer.ClietId == 0) { db.Customers.Add(customer); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { db.Entry(customer).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult Delete(int id) { using (SBMS_DBContext db = new SBMS_DBContext()) { Customer customer = db.Customers.Where(x => x.ClietId == id).FirstOrDefault <Customer>(); db.Customers.Remove(customer); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }