// 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: Match
public ActionResult Index(int?matchStatus, string searchString, int pageIndex = 1, int pageSize = 10)
{
int totalRecord = 0;
var model = new MatchDao().ListAll(matchStatus, searchString, ref totalRecord, pageIndex, pageSize);
ViewBag.SearchString = searchString;
StatusCategory selectedMatchStatus = new StatusCategory()
{
Stt = 0, Name = "---Select one---"
};
if (matchStatus != null)
{
selectedMatchStatus = new StatusCategoryDao().GetByStt("Match", (int)matchStatus);
}
ViewBag.SelectedMatchStatus = selectedMatchStatus;
ViewBag.Total = totalRecord;
ViewBag.Page = pageIndex;
int maxPage = 5;
int totalPage = 0;
if (totalRecord % pageSize != 0)
{
totalPage = (int)(totalRecord / pageSize) + 1;
}
else
{
totalPage = (int)(totalRecord / pageSize);
}
ViewBag.TotalPage = totalPage;
ViewBag.MaxPage = maxPage;
ViewBag.First = 1;
ViewBag.Last = totalPage;
ViewBag.Next = pageIndex + 1;
ViewBag.Prev = pageIndex - 1;
return(View(model));
}
//Set options value for select list
public JsonResult SetOption(string forTable, int type)
{
var dao = new StatusCategoryDao();
var list = dao.ListStatus(forTable, type);
if (list != null)
{
return(Json(new
{
data = list,
status = true
}));
}
else
{
return(Json(new
{
status = false
}));
}
}
// 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());
}
////Other methods
//Set ViewBag for Status options
public void SetStatusViewBag(long?selectedId = null)
{
var dao = new StatusCategoryDao();
ViewBag.Status = new SelectList(dao.ListStatus(1), "ID", "Name");
}
// 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());
}
