public IActionResult UpdateInterval([FromBody] AutoImportIntervalViewModel interval)
{
if (interval == null)
{
return(BadRequest());
}
return(Ok(_service.UpdateInterval(interval)));
}
/// <summary>
/// Create new timer
/// </summary>
/// <param name="intervalModel">View model with information about interval from db.</param>
/// <returns>New timer with information about interval.</returns>
public TimerWithIntervalViewModel CreateTimer(AutoImportIntervalViewModel intervalModel)
{
TimerWithIntervalViewModel timer = new TimerWithIntervalViewModel();
timer.IntervalViewModel = intervalModel;
timer.Timer = new Timer(ImportDataFromBank, timer, 0, intervalModel.Interval);
return(timer);
}
public AutoImportIntervals UpdateInterval(AutoImportIntervalViewModel interval)
{
var change = _unitOfWork.ImportIntervalRepository.GetByOrgId(interval.OrgId);
change.Interval = interval.Interval;
var input = _unitOfWork.ImportIntervalRepository.Update(change);
_unitOfWork.SaveChanges();
return(input);
}
public IEnumerable <AutoImportIntervalViewModel> GetIntervals()
{
using (SqlConnection connection = new SqlConnection(_connectionString))
{
SqlCommand command = new SqlCommand(Constants.SelectAllIntervalsQuery, connection);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
AutoImportIntervalViewModel model;
List <AutoImportIntervalViewModel> intervals = new List <AutoImportIntervalViewModel>();
while (reader.Read())
{
model = new AutoImportIntervalViewModel();
model.Id = (int)reader[Constants.IdColumn];
model.Interval = ConvertToMiliseconds((int)reader[Constants.IntervalColumn]);
model.OrganizationId = (int)reader[Constants.OrgIdColumn];
//model.LastUpdateDate = (DateTime?)reader[Constants.LastUpdateColumn];
intervals.Add(model);
}
return(intervals);
}
}
}
