public string UpdateTask(CompetencyTask compTask) { // var result = (int?)null; string result = ""; try { // CompetencyTask cTask = new CompetencyTask(); using (var context = new SSITrainingEntities()) { compTask.ModifiedDateTime = DateTime.Now; compTask.ModifiedUserID = Convert.ToInt32(Session["USERID"]); context.CompetencyTasks.Attach(compTask); var entry = context.Entry(compTask); entry.Property(t => t.Task).IsModified = true; entry.Property(t => t.ModifiedUserID).IsModified = true; entry.Property(t => t.ModifiedDateTime).IsModified = true; entry.Property(t => t.Sort).IsModified = true; context.SaveChanges(); } } catch (Exception ex) { result = "Task Update Failed"; Console.WriteLine(result); } return(result); }
// GET: Group public JsonResult AddGroup(CompetencyGroup Group) { using (var context = new SSITrainingEntities()) { string name = Group.GroupName; Group.CreateDateTime = DateTime.Now; Group.CreateUserId = Convert.ToInt32(Session["USERID"]); context.CompetencyGroups.Add(Group); context.SaveChanges(); return(Json(new { status = "Group Added Successfully!!" })); } }
public void DeleteGroup(CompetencyGroup group) { var compGroup = new CompetencyGroup { CompetencyGroupID = group.CompetencyGroupID }; using (SSITrainingEntities context = new SSITrainingEntities()) { context.CompetencyGroups.Attach(compGroup); context.CompetencyGroups.Remove(compGroup); context.SaveChanges(); } }
public JsonResult AddTask(CompetencyTask compTask) { try { // CompetencyTask cTask = new CompetencyTask(); using (var context = new SSITrainingEntities()) { compTask.Sort = GetTaskMaxSort(compTask.CompDefHeaderID); compTask.CreateDateTime = DateTime.Now; compTask.CreateUserID = Convert.ToInt32(Session["USERID"]); context.CompetencyTasks.Add(compTask); context.SaveChanges(); return(Json(new { status = "Task Added Successfully!!" })); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(Json(new { status = ex.Message })); } }
public JsonResult EditGroup(CompetencyGroup updatedGroup) { CompetencyGroup group = new CompetencyGroup(); string status; using (SSITrainingEntities entity = new SSITrainingEntities()) { var result = entity.CompetencyGroups.SingleOrDefault(g => g.CompetencyGroupID == updatedGroup.CompetencyGroupID); if (result != null) { result.GroupName = updatedGroup.GroupName; result.ModifiedUserID = 137; result.ModifiedDateTime = DateTime.Now; entity.SaveChanges(); status = "Group Updated"; } else { status = "Cannot update this group b/c it no longer exists."; } } return(Json(new { status })); }