Example #1
0
 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 };
     }
 }
Example #2
0
 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 };
 }