public async Task <IActionResult> BangGia()
{
var checkDaiLy = false;
if (User.Identity.IsAuthenticated)
{
var user = await _userManager.GetUserAsync(HttpContext.User);
checkDaiLy = _userManager.IsInRoleAsync(user, "Đại lý").Result;
}
var cards = _cardRepository.Cards().ToList();
var menhgias = _menhgiaRepository
.MenhGias().
Where(x => x.DaiLy == checkDaiLy).
OrderBy(x => x.Price).
ToList();
var menhgia_cardVM = new MenhGia_CardViewModels
{
Cards = cards,
DsMenhGia = menhgias
};
ViewBag.data = menhgia_cardVM;
return(View());
}
public IActionResult GetCard()
{
var cards = _cardRepository.Cards().Where(x => x.Status).ToList();
return(Json(new
{
data = cards
}));
}
public IActionResult Index()
{
var cards = _CardRepository.Cards();
var menhgias = (from mg in _menhgiaRepository.MenhGias()
orderby mg.Price
group mg by mg.DaiLy into dl
select new DaiLyThe
{
LoaiTaiKhoan = dl.Key ? "Đại lý" : "Thường dân",
key = dl.Key?"true":"false",
MenhGias = dl.Where(x => x.DaiLy == dl.Key).ToList()
}).ToList();
var cardVM = new CardViewModels
{
Cards = cards,
DaiLyThes = menhgias
};
return(View(cardVM));
}
public IActionResult GetAll(string filter, int page, int pageSize = 10, int statusRad = 0)
{
var totalRows = 0;
var NopCard = _NopCardRepository.NopCards();
var users = _userManager.Users;
var menhgias = _menhGiaRepository.MenhGias();
var cards = _cardRepository.Cards();
var data = from nc in NopCard
join user in users on nc.UserId equals user.Id
join mg in menhgias on nc.menhgiaId equals mg.Id
join c in cards on nc.cardId equals c.Id
where (statusRad == 1?nc.Status == true:nc.Status == false)
where (filter != null?user.UserName.Contains(filter):true)
orderby nc.NgayNopCard descending
select new NopCardViewModels
{
Id = nc.Id,
UserName = user.UserName,
LoaiThe = c.Name,
MenhGia = mg.Price,
NgayNopThe = String.Format("{0:d/M/yyyy h:mm:ss}", nc.NgayNopCard),
SoDienThoai = nc.Phone,
requiredLabel = nc.Required == "0"? "không":"nhanh",
SoLuong = nc.warenty,
TrangThai = nc.Status
};
totalRows = data.Count();
var model = data.Skip((page - 1) * pageSize).Take(pageSize).ToList();
return(Json(new
{
data = model,
total = totalRows,
status = true
}));
}
public IViewComponentResult Invoke()
{
var nopcards = _nopCardRepository.NopCards();
var cards = _cardRepository.Cards();
var data = (from card in cards
select new ChartCardViewModel
{
Label = card.Name,
Data = nopcards.Where(x => x.cardId == card.Id).Count()
}).ToList();
return(View(data));
}
public IActionResult LoadChartCart()
{
var nopcards = _nopCardRepository.NopCards();
var cards = _cardRepository.Cards();
var data = (from card in cards
select new ChartCardViewModel
{
Label = card.Name,
Data = nopcards.Where(x => x.cardId == card.Id).Count()
}).ToList();
return(Json(new
{
status = true,
data = data
}));
}
public IViewComponentResult Invoke()
{
var nopthetrongngay = _noptheRepository.NopCards().
Where(x => x.NgayNopCard.Subtract(DateTime.Now.Date).Days == 0 && x.ViewStatus == false && x.Status == false).ToList();
var data = from napthe in nopthetrongngay
join user in _userManager.Users on napthe.UserId equals user.Id
join card in _cardRepository.Cards() on napthe.cardId equals card.Id
join mg in _menhgiaRepository.MenhGias() on napthe.menhgiaId equals mg.Id
select new NopTheViewModels
{
id = napthe.Id,
loaithe = card.Name,
menhgia = mg.Price,
ngaynop = String.Format("{0:d/M/yyyy h:mm:ss}", napthe.NgayNopCard),
userName = user.UserName,
avatar = user.UrlAvatar,
soluong = napthe.warenty
};
return(View(data));
}
public IActionResult LichSuNapThe(string userId, int page, int pageSize = 5)
{
var totalRows = 0;
var napthes = _NopCardRepository.NopCards();
var menhgias = _menhgiaRepository.MenhGias();
var cards = _cardRepository.Cards();
var data = from nc in napthes
join mg in menhgias on nc.menhgiaId equals mg.Id
join c in cards on nc.cardId equals c.Id
where nc.UserId == userId
orderby nc.NgayNopCard descending
select new NopCardViewModels
{
Id = nc.Id,
LoaiThe = c.Name,
MenhGia = mg.Price,
GiaChietKhau = mg.unit_Price,
NgayNopThe = String.Format("{0:d/M/yyyy h:mm:ss}", nc.NgayNopCard),
SoDienThoai = nc.Phone,
requiredLabel = nc.Required == "0" ? "không" : "nhanh",
SoLuong = nc.warenty,
TrangThai = nc.Status,
Notes = nc.NoiDung
};
totalRows = data.Count();
var models = data.Skip(pageSize * (page - 1)).Take(pageSize).ToList();
return(Json(new
{
data = models,
total = totalRows,
page = page,
status = true
}));
}