//public void Calc(Schedule schedule)
//{
// var connection = new SqlConnection(connectionString);
// var calcCommand = new SqlCommand("ScheduleCalc", connection)
// {
// CommandType = CommandType.StoredProcedure,
// CommandTimeout = Settings.CommandTimeout
// };
// calcCommand.Parameters.AddWithValue("@ScheduleID", schedule.Id);
// try
// {
// connection.Open();
// calcCommand.ExecuteNonQuery();
// }
// catch (Exception ex)
// {
// throw LogException(MethodBase.GetCurrentMethod().Name, typeof(Schedule), ex);
// }
// finally
// {
// connection.Close();
// }
//}
public void Calc(ScheduleVisit scheduleVisit)
{
var connection = new SqlConnection(connectionString);
var calcCommand = new SqlCommand("ScheduleCalcByVisit", connection)
{
CommandType = CommandType.StoredProcedure,
CommandTimeout = Settings.CommandTimeout
};
calcCommand.Parameters.AddWithValue("@ScheduleVisitID", scheduleVisit.Id);
try
{
connection.Open();
calcCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
throw LogException(MethodBase.GetCurrentMethod().Name, typeof(Schedule), ex);
}
finally
{
connection.Close();
}
}
public ActionResult CalcScheduleByVisit(ScheduleVisit scheduleVisit)
{
if (scheduleVisit.Id == null)
{
throw new DataException("Не выбран базовый визит для расчета или не назначена дата");
}
DataProvider.Calc(scheduleVisit);
return(Json(new[] { scheduleVisit }));
}
public JsonResult ConfirmVisit(ConfirmVisitModel model)
{
if (model == null || model.ScheduleItemId <= 0)
{
return(Json(new { Status = Constant.RESPONSE_ERROR, Description = "Invalid schedule data. Please correct the entries and try again." }));
}
var date = DateTime.Parse(DateTime.Now.ToShortDateString());
if (_dataContext.ScheduleVisits.Where(p => p.ScheduleItemId == model.ScheduleItemId && p.Deleted == false && p.Date == date).Count() > 0)
{
return(Json(new { Status = Constant.RESPONSE_ERROR, Description = "The schedule item was already marked as visited." }));
}
else
{
var scheduleVisit = new ScheduleVisit();
scheduleVisit.ScheduleItemId = model.ScheduleItemId;
scheduleVisit.Date = date;
_dataContext.ScheduleVisits.Add(scheduleVisit);
_dataContext.SaveChanges();
return(Json(new { Status = Constant.RESPONSE_OK, Description = "The schedule is marked as visited.", ScheduleItemId = model.ScheduleItemId, Visited = true, Date = date }));
}
}
public ActionResult DeleteScheduleVisit([DataSourceRequest] DataSourceRequest request, ScheduleVisit scheduleVisit)
{
if (scheduleVisit != null)
{
if (!scheduleVisit.Id.HasValue)
{
throw new DataException("Невозможно удалить дату у незапланированного визита ");
}
DataProvider.Delete(scheduleVisit);
}
return(Json(new[] { scheduleVisit }.ToDataSourceResult(request, ModelState)));
}
public ActionResult UpdateScheduleVisit([DataSourceRequest] DataSourceRequest request, ScheduleVisit scheduleVisit)
{
if (scheduleVisit != null && ModelState.IsValid)
{
if (!scheduleVisit.ScheduleDate.HasValue)
{
throw new DataException("Дата планирования не задана");
}
if (scheduleVisit.Id.HasValue)
{
DataProvider.Update(scheduleVisit);
}
else
{
DataProvider.Add(scheduleVisit);
}
}
return(Json(new[] { scheduleVisit }.ToDataSourceResult(request, ModelState)));
}
public void Visit(ScheduleVisit visit)
{
Count++;
}
public void Visit(ScheduleVisit visit)
{
if (visit.StatementId == statementId) {
Count++;
}
}
//public void Calc(Schedule schedule)
//{
// dataProvider.Calc(schedule);
//}
public void Calc(ScheduleVisit scheduleVisit)
{
dataProvider.Calc(scheduleVisit);
}
public ActionResult UpdateScheduleVisit([DataSourceRequest] DataSourceRequest request, ScheduleVisit scheduleVisit)
{
//если дата не выбрана и не отменен визит
if (!scheduleVisit.ScheduleDate.HasValue && !scheduleVisit.Canceled)
{
ModelState.AddModelError("ScheduleDate", "Дата не введена");
}
if (ModelState.IsValid)
{
if (scheduleVisit.Id.HasValue)
{
DataProvider.Update(scheduleVisit);
}
else
{
DataProvider.Add(scheduleVisit);
}
}
return(Json(new[] { scheduleVisit }.ToDataSourceResult(request, ModelState)));
}
