public ViewResult Detail(int BranchId, int StaffId, string txtProductCode, string txtCode, string txtSearch) { CommisionDetailViewModel model = new CommisionDetailViewModel(); var listCommision = commisionRepository.GetAllCommision().Where(item => item.BranchId == BranchId && item.StaffId == StaffId).ToList(); model.StaffName = staffsRepository.GetAllStaffs().Where(item => item.Id == StaffId).Select(item => item.Name).FirstOrDefault(); model.StaffId = StaffId; model.DetailList = new List <CommisionViewModel>(); var productList = productRepository.GetAllvwProductAndService().Select(item => new { item.Id, item.Code, item.Name, item.PriceOutbound }).ToList(); if (!string.IsNullOrEmpty(txtCode)) { productList = productList.Where(x => x.Code.Contains(txtCode)).ToList(); } if (!string.IsNullOrEmpty(txtSearch)) { productList = productList.Where(x => x.Name.Contains(txtSearch)).ToList(); } foreach (var item in productList) { var commisionViewModel = new CommisionViewModel(); commisionViewModel.ProductId = item.Id; commisionViewModel.Name = item.Code + " - " + item.Name; commisionViewModel.Price = item.PriceOutbound.Value; commisionViewModel.IsMoney = false; var commision = listCommision.Where(i => i.ProductId == item.Id).FirstOrDefault(); if (commision != null) { commisionViewModel.Id = commision.Id; commisionViewModel.CommissionValue = commision.CommissionValue; commisionViewModel.IsMoney = commision.IsMoney == null ? false : commision.IsMoney; } model.DetailList.Add(commisionViewModel); } ViewBag.SuccessMessage = TempData["SuccessMessage"]; ViewBag.FailedMessage = TempData["FailedMessage"]; ViewBag.AlertMessage = TempData["AlertMessage"]; return(View(model)); }
public ViewResult Index(string txtSearch) { IQueryable <CommisionViewModel> q = CommisionRepository.GetAllCommision() .Select(item => new CommisionViewModel { Id = item.Id, CreatedUserId = item.CreatedUserId, //CreatedUserName = item.CreatedUserName, CreatedDate = item.CreatedDate, ModifiedUserId = item.ModifiedUserId, //ModifiedUserName = item.ModifiedUserName, ModifiedDate = item.ModifiedDate, Name = item.Name, }).OrderByDescending(m => m.ModifiedDate); ViewBag.SuccessMessage = TempData["SuccessMessage"]; ViewBag.FailedMessage = TempData["FailedMessage"]; ViewBag.AlertMessage = TempData["AlertMessage"]; return(View(q)); }