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"));
}
}
