public IActionResult Index() { NhanVienViewModel query = new NhanVienViewModel(db); ViewBag.List = query.GetDsNhanVien(); ChucVuViewModel query_cv = new ChucVuViewModel(db); ViewBag.ListPos = query_cv.GetChucVu(); return(View()); }
public async Task <APIResult <List <ChucVuViewModel> > > GetChucVuWithIDBP(int IDBP) { var query = await(from cv in _context.ChucVus where cv.IDBP == IDBP select cv).ToListAsync(); var list = new List <ChucVuViewModel>(); foreach (var data in query) { var cvvm = new ChucVuViewModel() { IDCV = data.IDCV, TenCV = data.TenCV }; list.Add(cvvm); } return(new APISuccessedResult <List <ChucVuViewModel> >(list)); }
public IActionResult Index() { ViewBag.EmployeeCount = (from nv in db.NhanVien select nv).Count(); var listEarning = new List <EarningMonth>(); GioHangViewModel query_gh = new GioHangViewModel(db); NhanVienViewModel query_nv = new NhanVienViewModel(db); double? totalEarning = 0.0; int?totalItems = 0; int totalOrders = 0; string[] monthNames = { "January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December" }; for (int i = 1; i <= 12; i++) { listEarning.Add(new EarningMonth { Month = monthNames[i - 1], Earning = Math.Round(query_gh.GetEarningByMonth(i).GetValueOrDefault(), 0), EmployeeCount = query_nv.GetCountEmployeeByMonth(i), ItemCount = query_gh.GetItemCountByMonth(i), OrderCount = query_gh.GetOrderCountByMonth(i) }); totalEarning += query_gh.GetEarningByMonth(i); totalItems += query_gh.GetItemCountByMonth(i); totalOrders += query_gh.GetOrderCountByMonth(i); } var query_cv = new ChucVuViewModel(db); var listCv = query_cv.GetChucVu(); var listPercent = new List <PositionPercent>(); foreach (var cv in listCv) { listPercent.Add(new PositionPercent { PositionName = cv.TenChucVu, Percent = Convert.ToInt32(query_nv.GetPercentEmployeePosition(cv.MaChucVu)) }); } ViewBag.TotalEarning = totalEarning; ViewBag.TotalItems = totalItems; ViewBag.TotalOrders = totalOrders; ViewBag.PositionName = JsonConvert.SerializeObject(listPercent.Select(x => x.PositionName)); ViewBag.Percent = JsonConvert.SerializeObject(listPercent.Select(x => x.Percent)); return(View(listEarning)); }