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