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