public JsonResult ApproveChange(int changeId, bool approve) { using (Entity context = new Entity()) { try { t_observation_change change = context.t_observation_change.Find(changeId); if (change == null) { throw new ArgumentException("Invalid attachmentId: " + changeId.ToString()); } change.approved = approve; change.updatedby_userid = CurrentUser.Id; change.updated_date = DateTime.Now; context.SaveChanges(); context.Entry(change).Reference(n => n.updatedby).Load(); return(Json(new { success = true, Approved = change.approved, UpdatedBy = change.updatedby.full_name, UpdatedOn = change.updated_date.Value.ToString("d") })); } catch (Exception ex) { return(GetJsonResult(ex)); } } }
public JsonResult EditChange(ObservationChange model) { using (Entity context = new Entity()) { try { t_observation_change change = context.t_observation_change.Find(model.ChangeId); if (change == null) { throw new ArgumentException("Invalid changeId: " + model.ChangeId.ToString()); } change.start_date = model.StartDate; change.description = model.Description; change.updatedby_userid = CurrentUser.Id; change.updated_date = DateTime.Now; context.SaveChanges(); context.Entry(change).Reference(n => n.updatedby).Load(); return(Json(new { success = true, StartDate = change.start_date.ToString("d"), Description = change.description, UpdatedBy = change.updatedby.full_name, UpdatedOn = change.updated_date.Value.ToString("d") })); } catch (Exception ex) { return(GetJsonResult(ex)); } } }
public CoachReportChange(t_observation_change change) { Date = change.start_date; IndicatorId = change.observation.indicator_id; IndicatorName = change.observation.indicator.name; Change = change.description; CreatedBy = change.createdby.full_name; }
public ObservationChange(t_observation_change change) { ChangeId = change.observation_change_id; ObservationId = change.observation_id; Description = change.description; StartDate = change.start_date; CreatedByUserId = change.createdby_userid; CreatedOn = change.created_date; UpdatedByUserId = change.updatedby_userid; UpdatedOn = change.updated_date; Approved = change.approved; }
private int?UpsertChange(dynamic model) { // "New" changes are always new (no collisions). Check if "updated" changes // exist before updating; if they no longer exist for some reason, re-create. t_observation_change entity = null; int changeId; if (Int32.TryParse(model.ChangeId.ToString(), out changeId)) { entity = Context.t_observation_change.Find(changeId); } bool isNew = entity == null; if (isNew) { entity = new t_observation_change() { observation_id = model.ObservationId, approved = false, createdby_userid = CurrentUserId, created_date = Convert.ToDateTime(model.CreatedOn) }; Context.t_observation_change.Add(entity); } else { entity.updatedby_userid = CurrentUserId; entity.updated_date = Convert.ToDateTime(model.UpdatedOn); } entity.start_date = Convert.ToDateTime(model.StartDate); entity.description = model.Description; Context.SaveChanges(); if (isNew) { return(entity.observation_change_id); } else { return(null); } }
public JsonResult DeleteChange(int changeId) { using (Entity context = new Entity()) { try { t_observation_change change = context.t_observation_change.Find(changeId); if (change != null) { context.t_observation_change.Remove(change); context.SaveChanges(); } return(Json(new { success = true })); } catch (Exception ex) { return(GetJsonResult(ex)); } } }
public JsonResult AddChange(ObservationChange model) { using (Entity context = new Entity()) { try { t_observation_change change = new t_observation_change(); change.observation_id = model.ObservationId; change.start_date = model.StartDate; change.description = model.Description; change.createdby_userid = CurrentUser.Id; change.created_date = DateTime.Now; change.approved = true; // all changes automatically approved context.t_observation_change.Add(change); context.SaveChanges(); context.Entry(change).Reference(n => n.createdby).Load(); return(Json(new { success = true, ChangeId = change.observation_change_id, ObservationId = change.observation_id, StartDate = change.start_date.ToString("d"), Description = change.description, CreatedBy = change.createdby.full_name, CreatedOn = change.created_date.ToString("d") })); } catch (Exception ex) { return(GetJsonResult(ex)); } } }