public JsonResult UpdateTaskHourAction(Taskassign UpdateTask) { bool TaskHour = false; string msg = " "; var dat = new List<object>(); try { using (db) { if (ModelState.IsValid) { var Task = db.TaskAssigned.Where(a => a.ID.Equals(UpdateTask.ID) && a.TASK_ID_ASSIGNED.Equals(UpdateTask.TASK_ID_ASSIGNED)).FirstOrDefault(); if (Task != null) { Task.TASK_HOUR_CONSUMED = UpdateTask.TASK_HOUR_CONSUMED; Task.TASK_UP_DATE = DateTime.Now; db.SaveChanges(); TaskHour = true; msg = "Successfully updated status"; } else { msg = "Task not found"; } } else { msg = "Invalid modal state to update status"; } } dat.Add(new { Message = msg, Status = TaskHour }); return new JsonResult { Data = dat }; } catch (Exception ex) { dat.Add(new { Message = ex, Status = TaskHour }); return new JsonResult { Data = dat }; } }
public JsonResult AssignTaskAction(Taskassign assignData) { var dat = new List<object>(); string msg = ""; bool TaskAssignStatus = false; // int UID = Convert.ToInt32(this.Session["UserProfile"].ToString()); //user.getSession(); Taskassign assignTask = new Taskassign(); try { using (db) { if (ModelState.IsValid) { var assignExist = db.TaskAssigned .Where( a => a.TASK_ID_ASSIGNED.Equals(assignData.TASK_ID_ASSIGNED) && a.PROJECT_ID.Equals(assignData.PROJECT_ID) && a.TASK_USER_ID.Equals(assignData.TASK_USER_ID)) .FirstOrDefault(); //var LoggedInUser = db.Users.Where(a => a.U_LOGIN_NAME.Equals(LoginData.U_LOGIN_NAME) && a.U_PASSWORD.Equals(LoginData.U_PASSWORD)).FirstOrDefault(); if (assignExist == null) { assignTask.PROJECT_ID = assignData.PROJECT_ID; assignTask.TASK_ID_ASSIGNED = assignData.TASK_ID_ASSIGNED; assignTask.TASK_USER_ID = assignData.TASK_USER_ID; assignTask.TASK_ASSIGN_DATE = DateTime.Now; assignTask.TASK_HOUR_CONSUMED = 0; assignTask.TASK_STATUS = "NOT STARTED"; db.TaskAssigned.Add(assignTask); db.SaveChanges(); msg = "Success"; TaskAssignStatus = true; } else { msg = "User is already assigned"; } } else { msg = "Failed!"; } } } catch (Exception ex) { msg = ex.Message; } dat.Add(new { Message = msg, AssignStatus = TaskAssignStatus }); return new JsonResult { Data = dat }; }