public ResponseDTO List(int?referansNo, string beyannameNo, string siparisNo) { try { var context = new ChepContext(); context.Database.SetCommandTimeout(TimeSpan.FromMinutes(3)); var entities = context.ChepStokCikis .Include(x => x.ChepStokCikisDetay) .Include(x => x.IhracatciFirmaNavigation) .ToList(); if (referansNo.HasValue && referansNo.Value > 0) { entities = entities.Where(x => x.ReferansNo.Equals(referansNo.Value)).ToList(); } if (!string.IsNullOrEmpty(beyannameNo)) { beyannameNo = beyannameNo.ToLower(); entities = entities.Where(x => x.BeyannameNo != null).Where(x => x.BeyannameNo.ToLower().Contains(beyannameNo)).ToList(); } if (!string.IsNullOrEmpty(siparisNo)) { siparisNo = siparisNo.ToLower(); entities = entities.Where(x => x.SiparisNo != null).Where(x => x.SiparisNo.ToLower().Contains(siparisNo)).ToList(); } var list = new List <ChepStokCikisDTO>(); foreach (var item in entities) { var obj = Map(item); list.Add(obj); } return(Success(list)); } catch (Exception ex) { return(Error(ex)); } }
public Repository(ChepContext context) { _context = context; }
public UnitOfWork() { _context = new ChepContext(); }