public string DeleteTask(CompetencyTask compTask) { // var result = (int?)null; string result = ""; try { // CompetencyTask cTask = new CompetencyTask(); using (var context = new SSITrainingEntities()) { context.sp_CACompetency_DeleteTask(compTask.CompDefTaskID, compTask.CompDefHeaderID, Convert.ToInt32(Session["UserID"])); //compTask.Active = false; //compTask.ModifiedDateTime = DateTime.Now; //compTask.ModifiedUserID = Convert.ToInt32(Session["USERID"]); //context.CompetencyTasks.Attach(compTask); //var entry = context.Entry(compTask); //entry.Property(t => t.Active).IsModified = true; //entry.Property(t => t.ModifiedUserID).IsModified = true; //entry.Property(t => t.ModifiedDateTime).IsModified = true; //context.SaveChanges(); } } catch (Exception ex) { result = "Task Update Failed"; Console.WriteLine(result); } return(result); }
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 })); } }