public virtual ActionResult Manage(PaymentSearchFilter filter) { ViewBag.WithoutAddButton = true; if (!Request.IsAjaxRequest()) { return(View(_paymentSrv.Get(filter))); } else { return(PartialView("Partials/_List", _paymentSrv.Get(filter))); } }
public PaymentModel GetItemsAndCount(PaymentSearchFilter filter) { var q = _appContext.Set <Payment>() .AsNoTracking() .Include(x => x.PaymentGateway) .Include(x => x.Order) .Include(x => x.Order.User) .Include(x => x.Order.Store) .Include(x => x.Order.Store.User) .AsQueryable(); if (filter != null) { if (filter.UserId != null) { q = q.Where(x => x.Order.Store.UserId == filter.UserId); } if (filter.StoreId != null) { q = q.Where(x => x.Order.StoreId == filter.StoreId); } if (!string.IsNullOrWhiteSpace(filter.FromDateSh)) { var dt = PersianDateTime.Parse(filter.FromDateSh).ToDateTime(); q = q.Where(x => x.InsertDateMi >= dt); } if (!string.IsNullOrWhiteSpace(filter.ToDateSh)) { var dt = PersianDateTime.Parse(filter.ToDateSh).ToDateTime(); q = q.Where(x => x.InsertDateMi <= dt); } if (!string.IsNullOrWhiteSpace(filter.TransactionId)) { q = q.Where(x => x.TransactionId == filter.TransactionId); } if (filter.PaymentStatus != null) { q = q.Where(x => x.PaymentStatus == filter.PaymentStatus); } } return(new PaymentModel { PagedList = q.ToPagingListDetails(filter), TotalPrice = q.Sum(x => x.Price) }); }
public PaymentModel Get(PaymentSearchFilter filter) => _paymentRepo.GetItemsAndCount(filter);