public ActionResult AddOrEdit(UserViewModel uv) { tblUser tb = new tblUser(); tb.Username = uv.Username; tb.Password = uv.Password; HttpPostedFileBase fup = Request.Files["Photo"]; if (fup != null) { if (fup.FileName != "") { tb.Photo = fup.FileName; fup.SaveAs(Server.MapPath("~/images/UserImages/" + fup.FileName)); } } _db.tblUsers.Add(tb); _db.SaveChanges(); UserRole ud = new UserRole(); ud.Userid = tb.UserId; ud.UserRoleId = 1; _db.UserRoles.Add(ud); _db.SaveChanges(); ViewBag.Message = "User Created Successfully"; return(View()); }
public ActionResult Signup(UserViewModel uv) { tblUser tbl = _db.tblUsers.Where(u => u.Username == uv.Username).FirstOrDefault(); if (tbl != null) { return Json(new { success = false, message = "User Already Register" }, JsonRequestBehavior.AllowGet); } else { tblUser tb = new tblUser(); tb.Username = uv.Username; tb.Password = uv.Password; _db.tblUsers.Add(tb); _db.SaveChanges(); UserRole ud = new UserRole(); ud.Userid = tb.UserId; ud.UserRoleId = 2; _db.UserRoles.Add(ud); _db.SaveChanges(); return Json(new { success = true, message = "User Register Successfully" }, JsonRequestBehavior.AllowGet); } }
public ActionResult AddOrEdit(tblSubMenu sm) { using (OnlineVehicleDBEntities db = new OnlineVehicleDBEntities()) { if (sm.SubMenuId == 0) { db.tblSubMenus.Add(sm); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { db.Entry(sm).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult Delete(int id) { using (OnlineVehicleDBEntities db = new OnlineVehicleDBEntities()) { tblSubMenu sm = db.tblSubMenus.Where(x => x.SubMenuId == id).FirstOrDefault(); db.tblSubMenus.Remove(sm); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult AddOrEdit(SubMenuViewModel sm) { using (OnlineVehicleDBEntities db = new OnlineVehicleDBEntities()) { if (sm.SubMenuId == 0) { tblSubMenu tb = new tblSubMenu(); tb.SubMenuName = sm.SubMenuName; db.tblSubMenus.Add(tb); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { tblSubMenu tbm = db.tblSubMenus.Where(m => m.SubMenuId == sm.SubMenuId).FirstOrDefault(); tbm.SubMenuName = sm.SubMenuName; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult ViewOrder_Post(int id) { using (OnlineVehicleDBEntities db = new OnlineVehicleDBEntities()) { tblOrder sm = db.tblOrders.Where(x => x.OrderId == id).FirstOrDefault(); sm.DeliveredStatus = "Confirmed"; db.SaveChanges(); return(RedirectToAction("ManageOrder", "Order")); } }
public ActionResult AddressAndPayment(OrderViewModel ovm) { var cart = ShoppingCart.GetCart(this.HttpContext); tblOrder tb = new tblOrder(); tb.Username = Session["username"].ToString(); tb.Firstname = ovm.Firstname; tb.Lastname = ovm.Lastname; tb.Address = ovm.Address; tb.Phone = ovm.Phone; tb.Total = cart.GetTotal(); tb.OrderDate = DateTime.Today.ToShortDateString(); tb.DeliveredStatus = "Pending"; storeDB.tblOrders.Add(tb); storeDB.SaveChanges(); List <tblCart> lst = cart.GetCartItems(); foreach (var item in lst) { tblOrderDetail tbord = new tblOrderDetail(); tbord.OrderId = tb.OrderId; tbord.VehicleId = item.VehicleId; tbord.Quantity = item.Count; tbord.UnitPrice = item.tblVehicle.Price; storeDB.tblOrderDetails.Add(tbord); storeDB.SaveChanges(); } ViewBag.Message = "Your Ordered Done Successfully, It Takes 2/3 Hours In Our working Days"; return(View()); }
public ActionResult ChangePassword(ChangePasswordViewModel ch) { int userid = Convert.ToInt32(Session["userid"].ToString()); tblUser us = _db.tblUsers.Where(u => u.UserId == userid && u.Password == ch.OldPassword).FirstOrDefault(); if (us != null) { us.Password = ch.NewPassword; _db.SaveChanges(); } else { ViewBag.Message = "Wrong Old Password"; } return(Json(new { success = true, message = "Password Changed Successfully" }, JsonRequestBehavior.AllowGet)); }
public ActionResult AddOrEdit(ItemViewModel ivm) { using (OnlineVehicleDBEntities db = new OnlineVehicleDBEntities()) { if (ivm.ItemId == 0) { tblVehicle itm = new tblVehicle(); itm.SubmenuId = Convert.ToInt32(ivm.SubMenuId); itm.Title = ivm.Title; itm.Price = ivm.Price; itm.Description = ivm.Description; HttpPostedFileBase fup = Request.Files["SmallImage"]; if (fup != null) { if (fup.FileName != "") { fup.SaveAs(Server.MapPath("~/images/ItemImages/" + fup.FileName)); itm.SmallImage = fup.FileName; } } HttpPostedFileBase fup1 = Request.Files["LargeImage"]; if (fup1 != null) { if (fup1.FileName != "") { fup1.SaveAs(Server.MapPath("~/images/ItemImages/" + fup1.FileName)); itm.LargeImage = fup1.FileName; } } itm.IsAvailable = "Available"; db.tblVehicles.Add(itm); db.SaveChanges(); ViewBag.Message = "Updated Successfully"; } else { tblVehicle itm = db.tblVehicles.Where(i => i.VehicleId == ivm.ItemId).FirstOrDefault(); itm.SubmenuId = Convert.ToInt32(ivm.SubMenuId); itm.Title = ivm.Title; itm.Price = ivm.Price; itm.Description = ivm.Description; HttpPostedFileBase fup = Request.Files["SmallImage"]; if (fup != null) { if (fup.FileName != "") { fup.SaveAs(Server.MapPath("~/images/ItemImages/" + fup.FileName)); itm.SmallImage = fup.FileName; } } HttpPostedFileBase fup1 = Request.Files["LargeImage"]; if (fup1 != null) { if (fup1.FileName != "") { fup1.SaveAs(Server.MapPath("~/images/ItemImages/" + fup1.FileName)); itm.LargeImage = fup1.FileName; } } db.SaveChanges(); ViewBag.Message = "Updated Successfully"; } ViewBag.SubMenus = db.tblSubMenus.ToList(); return(View(new ItemViewModel())); } }