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 GetData() { using (SBMS_DBContext db = new SBMS_DBContext()) { List <Customer> customerList = db.Customers.ToList <Customer>(); return(Json(new { data = customerList }, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetData() { using (SBMS_DBContext db = new SBMS_DBContext()) { List <Product> prodList = db.Products.ToList <Product>(); return(Json(new { data = prodList }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int id) { using (SBMS_DBContext db = new SBMS_DBContext()) { Product product = db.Products.Where(x => x.Id == id).FirstOrDefault <Product>(); db.Products.Remove(product); db.SaveChanges(); return(Json(new { success = true, message = "Deleted 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)); } }
public ActionResult AddOrEdit(int id = 0) { if (id == 0) { return(View(new User())); } else { using (SBMS_DBContext db = new SBMS_DBContext()) { return(View(db.Users.Where(x => x.UserID == id).FirstOrDefault <User>())); } } }
public ActionResult AddOrEdit(int id = 0) { //Customer customer = new Customer(); if (id == 0) { return(View(new Customer())); } else { using (SBMS_DBContext db = new SBMS_DBContext()) { return(View(db.Customers.Where(x => x.ClietId == id).FirstOrDefault <Customer>())); } } }
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 Login(Login login) { using (SBMS_DBContext db = new SBMS_DBContext()) { var get_user = db.Users.SingleOrDefault(c => c.UserName == login.UserName && c.Password == login.Password); if (get_user != null) { Session["UserId"] = get_user.UserID.ToString(); Session["UserName"] = get_user.UserName.ToString(); Session["UserType"] = "Admin"; if (string.Equals(Convert.ToString(Session["UserType"]), "Admin")) { //return RedirectToAction("AdminDashboard", "Dashboard"); //FormsAuthentication.SetAuthCookie(login.UserName, true); int timeout = 1; // 525600 min = 1 year var ticket = new FormsAuthenticationTicket(login.UserName, false, timeout); string encrypted = FormsAuthentication.Encrypt(ticket); var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted); cookie.Expires = DateTime.Now.AddMinutes(timeout); cookie.HttpOnly = true; Response.Cookies.Add(cookie); //return RedirectToAction("LoggedIn", "Account"); return(RedirectToAction("AdminDashboard", "Dashboard")); } else { return(RedirectToAction("UserDashboard", "Dashboard")); } } else { ModelState.AddModelError("", "UserName or Password does not match."); return(View(login)); } } //return View(login); }
public ActionResult AddOrEdit(int id = 0) { Product product = new Product(); if (id == 0) { using (SBMS_DBContext db = new SBMS_DBContext()) { product.Categories = db.Categories.ToList <Category>(); return(View(product)); } } else { using (SBMS_DBContext db = new SBMS_DBContext()) { product.Categories = db.Categories.ToList <Category>(); return(View(db.Products.Where(x => x.Id == id).FirstOrDefault <Product>())); } } }