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