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