public static IEnumerable <StatisticDto> GetOperations(string startDateString, string endDateString)
{
using (var context = new PawnShopContext())
{
MapperInitiliazer.InitializeStatistics();
context.Users.Attach(LoginUser.User);
var startDate = DateTime.Parse(startDateString);
var endDate = DateTime.Parse(endDateString);
if (startDate > endDate)
{
throw new InvalidOperationException("Invalid data provided.");
}
var operations =
context.CashOperations.Where(c => c.CashBox.Office.Name == LoginUser.User.Office.Name &&
(SqlFunctions.DateDiff("day", c.DateTime, startDate).Value <= 0 &&
SqlFunctions.DateDiff("day", c.DateTime, endDate).Value >= 0))
.OrderBy(c => c.DateTime)
.ProjectTo <StatisticDto>()
.ToList();
return(operations);
}
}