public ActionResult AddSubCategoryAdmin() { string name = Request.Form["username"]; int category = NumberHelper.getInt(Request.Form["category"]); int status = NumberHelper.getInt(Request.Form["status"]); SubCategory subCategory = new SubCategory(category, name, status); bool check = new SubCategoryDao().insert(subCategory); if (check) { //response.sendRedirect("get-sub-category"); Response.Redirect("https://localhost:44394/GetSubCategoryAdmin/GetSubCategoryAdmin"); } else { ViewData["error"] = "Add Sub Category Failed!"; ViewData["message"] = "Please go to dashboard and try again!"; //todo //Response.Redirect("https://localhost:44394/admin/ErrorAdmin.jsp"); } return(View()); }
// GET: GetAccountAdmin public ActionResult GetAccountAdmin() { List <Account> listAccount = new AccountDao().getAll(); List <StatusAccount> listStatusAccount = new StatusAccountDao().getAll(); List <RoleAccount> listRoleAccount = new RoleAccountDao().getAll(); List <Product> listProduct = new ProductDao().getAll(); List <Category> listCategory = new CategoryDao().getAll(); List <SubCategory> listSubCategory = new SubCategoryDao().getAll(); List <StatusProduct> listStatusProduct = new StatusProductDao().getAll(); List <StatusCategory> listStatusCategory = new StatusCategoryDao().getAll(); List <StatusSubCategory> listStatusSubCategory = new StatusSubCategoryDao().getAll(); int numOfOrder = new OrderDao().countOrderWatting(); Account accountEdit = TempData["accountEdit"] as Account; ViewData["accountEdit"] = accountEdit; ViewData["numOfOrder"] = numOfOrder; ViewData["listAccount"] = listAccount; ViewData["listStatusAccount"] = listStatusAccount; ViewData["listRoleAccount"] = listRoleAccount; ViewData["listProduct"] = listProduct; ViewData["listCategory"] = listCategory; ViewData["listSubCategory"] = listSubCategory; ViewData["listStatusProduct"] = listStatusProduct; ViewData["listStatusCategory"] = listStatusCategory; ViewData["listStatusSubCategory"] = listStatusSubCategory; return(View()); }
// GET: GetSubCategoryAdmin public ActionResult GetSubCategoryAdmin() { List <SubCategory> listSubCategory = new SubCategoryDao().getAll(); List <StatusProduct> listStatusProduct = new StatusProductDao().getAll(); List <StatusCategory> listStatusCategory = new StatusCategoryDao().getAll(); List <StatusSubCategory> listStatusSubCategory = new StatusSubCategoryDao().getAll(); int numOfOrder = new OrderDao().countOrderWatting(); ViewData["numOfOrder"] = numOfOrder; ViewData["listSubCategory"] = listSubCategory; ViewData["listStatusProduct"] = listStatusProduct; ViewData["listStatusCategory"] = listStatusCategory; ViewData["listStatusSubCategory"] = listStatusSubCategory; return(View()); }
// GET: ProcessOrderAdmin public ActionResult ProcessOrderAdmin() { Account account = (Account)Session["account"]; List <Product> listProduct = new ProductDao().getAll(); List <Category> listCategory = new CategoryDao().getAll(); List <SubCategory> listSubCategory = new SubCategoryDao().getAll(); List <StatusProduct> listStatusProduct = new StatusProductDao().getAll(); List <StatusCategory> listStatusCategory = new StatusCategoryDao().getAll(); List <StatusSubCategory> listStatusSubCategory = new StatusSubCategoryDao().getAll(); List <StatusAccount> listStatusAccount = new StatusAccountDao().getAll(); int check = NumberHelper.getInt(Request.QueryString["check"]); List <Order> listOrderWatting = null; if (check == 0) { listOrderWatting = new OrderDao().getAllSucces(); } else { if (check == 1) { listOrderWatting = new OrderDao().getAllOrderShipping(); } else { listOrderWatting = new OrderDao().getAllOrderNotAcceptYet(); } } int numOfOrder = new OrderDao().countOrderWatting(); ViewData["check"] = check; ViewData["numOfOrder"] = numOfOrder; ViewData["listOrderWatting"] = listOrderWatting; ViewData["listProduct"] = listProduct; ViewData["listCategory"] = listCategory; ViewData["listSubCategory"] = listSubCategory; ViewData["listStatusProduct"] = listStatusProduct; ViewData["listStatusCategory"] = listStatusCategory; ViewData["listStatusSubCategory"] = listStatusSubCategory; ViewData["listStatusAccount"] = listStatusSubCategory; return(View()); }
// GET: Filter public ActionResult FilterByCategory() { SubCategoryDao subCategoryDao = new SubCategoryDao(); int pageindex = NumberHelper.getInt(Request.QueryString["page"]); List <int> listCount = new List <int>(); int pageCount; if (pageindex == -1) { pageindex = 1; } int id = NumberHelper.getInt(Request.QueryString["id"]); int cid = NumberHelper.getInt(Request.QueryString["cid"]); if (id == -1 && cid == -1) { Response.Redirect("Error"); } else { List <Product> listProduct; List <Category> listCategory; if (cid == -1) { if (id == 0) { listProduct = new ProductDao().getAllPaging(pageindex, 20); pageCount = new ProductDao().countPage(); } else { listProduct = new ProductDao().getAllByCategoryIdPaging(id, pageindex, 20); pageCount = new ProductDao().countPageByCategory(id); } } else { if (cid == 0) { listProduct = new ProductDao().getAllPaging(pageindex, 20); pageCount = new ProductDao().countPage(); } else { listProduct = new ProductDao().getAllBySubCategoryIdPaging(cid, pageindex, 20); pageCount = new ProductDao().countPageBySubCategory(id); } } pageCount = (pageCount % 20 == 0) ? pageCount / 20 : pageCount / 20 + 1; for (int i = 1; i <= pageCount; i++) { listCount.Add(i); } listCategory = new CategoryDao().getAll(); ViewData["id"] = id; ViewData["cid"] = id; ViewData["page"] = pageindex; ViewData["listCount"] = listCount; ViewData["listProduct"] = listProduct; ViewData["listCategory"] = listCategory; } return(View()); }
// GET: GetChartAdmin public ActionResult GetChartAdmin() { List <Product> listProduct = new ProductDao().getAll(); List <Category> listCategory = new CategoryDao().getAll(); List <SubCategory> listSubCategory = new SubCategoryDao().getAll(); List <StatusProduct> listStatusProduct = new StatusProductDao().getAll(); List <StatusCategory> listStatusCategory = new StatusCategoryDao().getAll(); List <StatusSubCategory> listStatusSubCategory = new StatusSubCategoryDao().getAll(); // List<Order> listOrderWatting = new OrderDao().getOrderNotSuccesYetByCustomer(account.getUserName(), 4); int numOfOrder = new OrderDao().countOrderWatting(); int count = new ViewDao().getView(); int count2 = new ProductDao().countProduct(); int count3 = new AccountDao().countAccount(); int count4 = new SubCategoryDao().countSubCategory(); string label = ""; string soluong = ""; List <int> soluongProduct = new ProductDao().countProductGroupByCategoryId(); foreach (Category C in listCategory) { label += "" + C.category + ","; } label.Remove(label.Length - 1); label.Substring(0, label.Length - 1); foreach (int integer in soluongProduct) { soluong += (double)Math.Round((((double)integer / count2) * 100) * 100) / 100 + ","; } soluong.Substring(0, soluong.Length - 1); List <double> listRevenue = new List <double>(); double a = new OrderDao().calRevenueInMonth(4); listRevenue.Add(a); string revenue = ""; foreach (Double double1 in listRevenue) { revenue += (double)Math.Round(double1 * 100) / 100 + ","; } revenue.Substring(0, revenue.Length - 1); string thu = ""; string data = ""; List <ThongkeOrder> listThongKe = new ThongKeOrderDao().getAll(); foreach (ThongkeOrder T in listThongKe) { thu += T.thu + ","; data += T.numOfOrder + ","; } thu = thu.Remove(thu.Length - 1); ViewData["thu"] = thu; ViewData["data"] = data; ViewData["label"] = label; ViewData["soluong"] = soluong; ViewData["revenue"] = revenue; ViewData["view"] = count; ViewData["numSubCategory"] = count4; ViewData["numAccount"] = count3; ViewData["numProduct"] = count2; ViewData["numOfOrder"] = numOfOrder; ViewData["listProduct"] = listProduct; ViewData["listCategory"] = listCategory; ViewData["listSubCategory"] = listSubCategory; ViewData["listSubCategory"] = listSubCategory; ViewData["listStatusCategory"] = listStatusCategory; ViewData["listStatusSubCategory"] = listStatusSubCategory; return(View()); }
// GET: Manager public ActionResult ManagerAdmin() { Account account = (Account)Session["account"]; if (account != null) { List <Account> listAccounts = new AccountDao().getAll(); int check = 0; foreach (Account A in listAccounts) { if (A.userName.Equals(account.userName) && A.password.Equals(account.password) && account.roleId == 1) { check = 1; List <Product> listProduct = new ProductDao().getAll(); List <Category> listCategory = new CategoryDao().getAll(); List <SubCategory> listSubCategory = new SubCategoryDao().getAll(); List <StatusProduct> listStatusProduct = new StatusProductDao().getAll(); List <StatusCategory> listStatusCategory = new StatusCategoryDao().getAll(); List <StatusSubCategory> listStatusSubCategory = new StatusSubCategoryDao().getAll(); List <Order> listOrderWatting = new OrderDao().getOrderNotSuccesYetByCustomer(account.userName, 4); List <StatusAccount> listStatusAccount = new StatusAccountDao().getAll(); List <RoleAccount> listRoleAccount = new RoleAccountDao().getAll(); int numOfOrder = new OrderDao().countOrderWatting(); int count = new ViewDao().getView(); int count2 = new ProductDao().countProduct(); int count3 = new AccountDao().countAccount(); int count4 = new SubCategoryDao().countSubCategory(); string thu = ""; string data = ""; List <ThongkeOrder> listThongKe = new ThongKeOrderDao().getAll(); foreach (ThongkeOrder T in listThongKe) { thu += T.thu + ","; data += T.numOfOrder + ","; } thu = thu.Remove(thu.Length - 1); ViewData["thu"] = thu; ViewData["data"] = data; ViewData["view"] = count; ViewData["numSubCategory"] = count4; ViewData["numAccount"] = count3; ViewData["numProduct"] = count2; ViewData["numOfOrder"] = numOfOrder; ViewData["listOrderWatting"] = listOrderWatting; ViewData["listProduct"] = listProduct; ViewData["listCategory"] = listCategory; ViewData["listSubCategory"] = listSubCategory; ViewData["listStatusProduct"] = listStatusProduct; ViewData["listStatusCategory"] = listStatusCategory; ViewData["listStatusSubCategory"] = listStatusSubCategory; ViewData["listStatusAccount"] = listStatusAccount; ViewData["listRoleAccount"] = listRoleAccount; } } if (check == 0) { //response.sendRedirect("client/error.jsp"); } } else { //response.sendRedirect("login"); Response.Redirect("~/Login/Login"); } return(View()); }