public static List <tblCategory> GetMenus() { using (var context = new E_CommerceWebsiteEntities()) { return(context.tblCategories.ToList()); } }
public ActionResult Login(Models.ViewModel.LoginViewModel iv, string ReturnUrl = "") { using (E_CommerceWebsiteEntities db = new E_CommerceWebsiteEntities()) { var user = db.tblUsers.Where(a => a.UserName == iv.UserName && a.Password == iv.Password).FirstOrDefault(); if (user != null) { Session.Add("FullName", user.Fullname); Session.Add("UserName", user.UserName); FormsAuthentication.SetAuthCookie(iv.UserName, iv.RememberMe); if (Url.IsLocalUrl(ReturnUrl)) { return(Redirect(ReturnUrl)); } else { if (user.tblUserRoles.Where(r => r.RoleId == 1).FirstOrDefault() != null) { return(RedirectToAction("Dashboard", "Admin")); } else { return(RedirectToAction("Index", "Home")); } } } else { ModelState.AddModelError("", "Invalid User"); ViewBag.Action = "Invalid User"; } return(View()); } }
public ActionResult Delete(int id) { using (E_CommerceWebsiteEntities db = new E_CommerceWebsiteEntities()) { tblOrder sm = db.tblOrders.Where(x => x.OrderId == id).FirstOrDefault(); db.tblOrders.Remove(sm); db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult ViewOrder_Post(int id) { using (E_CommerceWebsiteEntities db = new E_CommerceWebsiteEntities()) { tblOrder sm = db.tblOrders.Where(x => x.OrderId == id).FirstOrDefault(); sm.DeliveredStatus = "Confirmed"; db.SaveChanges(); return(RedirectToAction("ManageOrder", "Order")); } }
public JsonResult GetData() { using (E_CommerceWebsiteEntities db = new E_CommerceWebsiteEntities()) { db.Configuration.LazyLoadingEnabled = false; List <OrderViewModel> lstorder = new List <OrderViewModel>(); var empList = db.tblOrders.Select(x => new { OrderId = x.OrderId, Firstname = x.Firstname, Lastname = x.Lastname, Address = x.Address, Phone = x.Phone, Total = x.Total, OrderDate = x.OrderDate, DeliveredStatus = x.DeliveredStatus }).ToList(); foreach (var item in empList) { lstorder.Add(new OrderViewModel() { OrderId = item.OrderId, Firstname = item.Firstname, Lastname = item.Lastname, Address = item.Address, Phone = item.Phone, Total = item.Total.ToString(), OrderDate = item.OrderDate.ToString(), DeliveredStatus = item.DeliveredStatus }); } return(Json(new { data = lstorder }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetData() { using (E_CommerceWebsiteEntities db = new E_CommerceWebsiteEntities()) { db.Configuration.LazyLoadingEnabled = false; List <UserViewModel> lstitem = new List <UserViewModel>(); var lst = db.tblUsers.ToList(); foreach (var item in lst) { lstitem.Add(new UserViewModel() { UserId = item.UserId, UserName = item.UserName, FullName = item.Fullname, Email = item.Email }); } return(Json(new { data = lstitem }, JsonRequestBehavior.AllowGet)); } }
public ActionResult ViewOrder(int id) { using (E_CommerceWebsiteEntities db = new E_CommerceWebsiteEntities()) { List <OrderDetailsViewModel> lstod = new List <OrderDetailsViewModel>(); var empList = db.tblOrderDetails.Where(x => x.OrderId == id).ToList(); foreach (tblOrderDetail item in empList) { lstod.Add(new OrderDetailsViewModel() { ItemId = Convert.ToInt32(item.ProductId), ItemName = item.tblProduct.ProductName, Quantity = Convert.ToInt32(item.Quantity), UnitPrice = Convert.ToDecimal(item.UnitPrice) }); } Session.Add("itemlist", lstod); Session.Add("orderid", id); return(View(lstod)); } }
public ActionResult AddOrEdit(UserViewModel uv) { using (E_CommerceWebsiteEntities db = new E_CommerceWebsiteEntities()) { tblUser tb = new tblUser(); tb.UserName = uv.UserName; tb.Password = uv.Password; tb.Fullname = uv.FullName; tb.Email = uv.Email; db.tblUsers.Add(tb); db.SaveChanges(); tblUserRole ud = new tblUserRole(); ud.UserId = tb.UserId; ud.RoleId = 1; db.tblUserRoles.Add(ud); db.SaveChanges(); ViewBag.Message = "User Created Successfully"; return(RedirectToAction("ManageUser")); } }