public void Execute(IJobExecutionContext context)
{
DirectionToPayRepository repository = new DirectionToPayRepository(false);
var cancelStatus = repository
.GetDirectionToPayStatuses()
.FirstOrDefault(s => s.Code == Dictionary.ExpDirectionToPayStatus.Canceled && s.ExpireDate == null);
if (cancelStatus != null)
{
// TODO 40 дней перенести в настройки
var sqlScript = string.Format(@"UPDATE [dbo].[EXP_DirectionToPays] SET [StatusId] = '{0}', [StatusValue] = '{1}' WHERE [DirectionDate] < DATEADD(DAY, {2}, GETDATE()) AND StatusId <> '{0}'", cancelStatus.Id, cancelStatus.Name, "-40");
repository.RunSqlScript(sqlScript);
}
}
//DirectionToPayRepository _repository = new DirectionToPayRepository();
// GET: DirectionToPay
public ActionResult Index()
{
var guid = Guid.NewGuid();
DirectionToPayRepository repository = new DirectionToPayRepository();
ViewBag.DirectionToPayStatuses =
repository.GetDirectionToPayStatuses().ToList().OrderBy(o => o.Name)
.Select(o => new Item()
{
Id = o.Id.ToString(), Name = o.Name
}).ToList();
return(PartialView(guid));
}
