public JsonResult getOrgDetail(int id) { try { using (TaskManagementSystemDB db = new TaskManagementSystemDB()) { int value = db.Organisations.Count(); if (value > 0) { var OrgDetails = db.Organisations.Where(a => a.ORG_ID.Equals(id)).FirstOrDefault(); return new JsonResult { Data = OrgDetails, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } } return new JsonResult { Data = null, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } catch (Exception ex) { return new JsonResult { Data = ex, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } }
public JsonResult RegisterUser(User RegisterData) { var dat = new List<object>(); string msg = ""; bool RegisterStatus = false; try { using (TaskManagementSystemDB db = new TaskManagementSystemDB()) { if (ModelState.IsValid) { var RegisterUser = db.Users.Where(a => a.U_LOGIN_NAME.Equals(RegisterData.U_LOGIN_NAME)).FirstOrDefault(); if (RegisterUser == null) { User newUser = new User(); newUser.U_EMAIL = RegisterData.U_EMAIL; newUser.U_FIRST_NAME = RegisterData.U_FIRST_NAME; newUser.U_LAST_NAME = RegisterData.U_LAST_NAME; newUser.U_LOGIN_NAME = RegisterData.U_LOGIN_NAME; newUser.U_PASSWORD = RegisterData.U_PASSWORD; newUser.U_POSITION = RegisterData.U_POSITION; newUser.U_REGISTER_DATE = DateTime.Now; db.Users.Add(newUser); db.SaveChanges(); RegisterStatus = true; msg = "Success"; } else { msg = "Username already exist!"; } } else { msg = "Failed!"; } } } catch (Exception ex) { msg = ex.Message; dat.Add(new { Status = RegisterStatus, Username = "******", Message = msg }); } dat.Add(new { Status = RegisterStatus, Username = RegisterData.U_LOGIN_NAME, Message = msg }); return new JsonResult { Data = dat }; //, JsonRequestBehavior.AllowGet); // //return new JsonResult { Data = message }; }
public JsonResult RecentlyUpdatedTasks(int id) { List<User> task = new List<User>(); try { using (TaskManagementSystemDB db = new TaskManagementSystemDB()) { var updatedTasks = (from TaskAssign in db.TaskAssigned join Tasks in db.Tasks on TaskAssign.TASK_ID_ASSIGNED equals Tasks.TASK_ID where TaskAssign.TASK_UP_DATE != null select ( new { TASK_USER = TaskAssign.TASK_USER_ID, USER_TASK_STATUS = TaskAssign.TASK_STATUS, USER_UPDATE_DATE = TaskAssign.TASK_UP_DATE, TASK_ASSIGN_DATE = TaskAssign.TASK_ASSIGN_DATE, TASK_ID = TaskAssign.TASK_ID_ASSIGNED, TASK_NAME = Tasks.TASK_NAME, TASK_STATUS = Tasks.TASK_STATUS, PROJECT_ID = Tasks.TASK_PROJECT_ID, TASK_HOUR_CONSUMED = TaskAssign.TASK_HOUR_CONSUMED, TASK_DESCRIPTION = Tasks.TASK_DESCRIPTION, TASK_END_DATE = Tasks.TASK_END_DATE, TASK_START_DATE = Tasks.TASK_START_DATE })).OrderByDescending(USER_UPDATE_DATE => USER_UPDATE_DATE).ToList(); return new JsonResult { Data = updatedTasks, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } } catch (Exception ex) { task = null; } return new JsonResult { Data = task, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; }
public JsonResult GetUserType(string uname ) { List<User> user = new List<User>(); try { using (TaskManagementSystemDB db = new TaskManagementSystemDB()) { var LoggedInUser = db.Users.Where( a => a.U_LOGIN_NAME.Equals(uname)) .FirstOrDefault(); if (LoggedInUser != null) user = db.Users.Where(a => a.U_LOGIN_NAME.Equals(uname)).ToList(); return new JsonResult { Data = uname, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } } catch (Exception Ex) { // return Ex.ToString(); Response.Write(Ex); return new JsonResult { Data = false, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } }
public JsonResult IsUserAvailable(User LoginData) { bool status = false; try { using (TaskManagementSystemDB db = new TaskManagementSystemDB()) { var LoggedInUser = db.Users.Where( a => a.U_LOGIN_NAME.Equals(LoginData.U_LOGIN_NAME)) .FirstOrDefault(); if (LoggedInUser != null) status = true; return new JsonResult { Data = status, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } } catch (Exception) { return new JsonResult { Data = status, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } }
public JsonResult GetUserDetails(int id) { List<User> user = new List<User>(); try { using (TaskManagementSystemDB db = new TaskManagementSystemDB()) { var RegisterUser = db.Users.Where(a => a.U_ID.Equals(id)).FirstOrDefault(); if (RegisterUser != null) { user = db.Users.Where(a => a.U_ID.Equals(id)).OrderBy(a => a.U_LOGIN_NAME).ToList(); } else { user = null; } } } catch (Exception ex) { user = null; } return new JsonResult { Data = user, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; }
public JsonResult UpcomingTaskDeadlines(int id) { List<Task> project = new List<Task>(); try { using (TaskManagementSystemDB db = new TaskManagementSystemDB()) { var TaskList = db.TaskAssigned.Where(a => a.TASK_USER_ID.Equals(id)).Count(); if (TaskList > 0) { var dprojects = (from TaskAssign in db.TaskAssigned join Tasks in db.Tasks on TaskAssign.TASK_ID_ASSIGNED equals Tasks.TASK_ID where TaskAssign.TASK_USER_ID == id && (DbFunctions.DiffDays(DateTime.Now, Tasks.TASK_END_DATE).Value > 0 && DbFunctions.DiffDays(DateTime.Now, Tasks.TASK_END_DATE).Value <20) select (new { TASK_ASSIGN_DATE = TaskAssign.TASK_ASSIGN_DATE, TASK_HOUR_CONSUMED = TaskAssign.TASK_HOUR_CONSUMED, TASK_ID_ASSIGNED = TaskAssign.TASK_ID_ASSIGNED, TASK_STATUS = TaskAssign.TASK_STATUS, PROJECT_ID = TaskAssign.PROJECT_ID, ID = TaskAssign.ID, TASK_NAME = Tasks.TASK_NAME, TASK_START_DATE = Tasks.TASK_START_DATE, TASK_END_DATE = Tasks.TASK_END_DATE, TASK_DESCRIPTION = Tasks.TASK_DESCRIPTION, TASK_PRIORITY = Tasks.TASK_PRIORITY, U_TASK_CREATE_DATE = Tasks.U_TASK_CREATE_DATE, TASK_USER_ID = Tasks.TASK_USER_ID, TASK_ESTIMATED_HOUR = Tasks.TASK_ESTIMATED_HOUR, Days = DbFunctions.DiffDays(DateTime.Now, Tasks.TASK_END_DATE).Value })).OrderByDescending(TASK_END_DATE => TASK_END_DATE).ToList(); return new JsonResult { Data = dprojects, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } else { return new JsonResult { Data = null, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } } } catch (Exception ex) { return new JsonResult { Data = null, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } }
public ActionResult GetTaskDetails(int id) { List<Task> task = new List<Task>(); try { using (TaskManagementSystemDB db = new TaskManagementSystemDB()) { var TaskDetails = db.Tasks.Where(a => a.TASK_ID.Equals(id)).FirstOrDefault(); if (TaskDetails != null) { task = db.Tasks.Where(a => a.TASK_ID.Equals(id)).OrderBy(a => a.TASK_ID).ToList(); } else { task = null; } } } catch (Exception ex) { task = null; } return new JsonResult { Data = task, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; }
public JsonResult AssignedTaskList(int id) { List<Task> task = new List<Task>(); try { using (TaskManagementSystemDB db = new TaskManagementSystemDB()) { var MyAssignedTaskList = db.TaskAssigned.Where(a => a.TASK_USER_ID.Equals(id)).FirstOrDefault(); if (MyAssignedTaskList != null) { var assignedtasks = (from TaskAssigned in db.TaskAssigned join Task in db.Tasks on TaskAssigned.TASK_ID_ASSIGNED equals Task.TASK_ID where TaskAssigned.TASK_USER_ID == id select ( new { TASK_ID = Task.TASK_ID, TASK_NAME = Task.TASK_NAME, TASK_PROJECT_ID = Task.TASK_PROJECT_ID, TASK_START_DATE = Task.TASK_START_DATE, TASK_END_DATE = Task.TASK_END_DATE, TASK_PRIORITY = Task.TASK_PRIORITY, TASK_STATUS = Task.TASK_STATUS, TASK_ESTIMATED_HOUR= Task.TASK_ESTIMATED_HOUR, TASK_USER_ID = Task.TASK_USER_ID, TASK_DESCRIPTION = Task.TASK_DESCRIPTION, PROJECT_PHASE = Task.PROJECT_PHASE, U_TASK_CREATE_DATE = Task.U_TASK_CREATE_DATE, TASK_ASSIGN_DATE = TaskAssigned.TASK_ASSIGN_DATE, TASK_HOUR_CONSUMED = TaskAssigned.TASK_HOUR_CONSUMED, ID = TaskAssigned.ID, USER_TASK_STATUS = TaskAssigned.TASK_STATUS })).ToList(); return new JsonResult { Data = assignedtasks, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } else { task = null; } } } catch (Exception ex) { task = null; } return new JsonResult { Data = task, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; }
/*** listing tasks of a project **/ public JsonResult getTaskofproject(int id) { List<Task> task = new List<Task>(); try { using (TaskManagementSystemDB db = new TaskManagementSystemDB()) { var TaskList = db.Tasks.Where(a => a.TASK_PROJECT_ID.Equals(id)).OrderBy(a =>a.U_TASK_CREATE_DATE).FirstOrDefault(); if (TaskList != null){ task = db.Tasks.Where(a => a.TASK_PROJECT_ID.Equals(id)).OrderBy(a => a.TASK_NAME).ToList(); } else { task = null; } } } catch (Exception ex) { task = null; } return new JsonResult { Data = task, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; }
public JsonResult MyCreatedTasks(int id) //project manager id { List<User> task = new List<User>(); try { using (TaskManagementSystemDB db = new TaskManagementSystemDB()){ var createdTasks = db.Projects.Where(a => a.PROJECT_MANAGER.Equals(id)).FirstOrDefault(); if (createdTasks != null) { var tasks = (from Project in db.Projects join Task in db.Tasks on Project.PROJECT_ID equals Task.TASK_PROJECT_ID where Project.PROJECT_MANAGER == id select new{ Project, Task }).ToList(); return new JsonResult { Data = tasks, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } else { task = null; } } } catch (Exception ex) { task = null; } return new JsonResult { Data = task, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; }
public ActionResult GetAssignedUsers(int id) //project id { List<User> task = new List<User>(); try { using (TaskManagementSystemDB db = new TaskManagementSystemDB()) { var TaskDetails = db.Tasks.Where(a => a.TASK_ID.Equals(id)).FirstOrDefault(); if (TaskDetails != null) { var users = (from TaskAssign in db.TaskAssigned join User in db.Users on TaskAssign.TASK_USER_ID equals User.U_ID where TaskAssign.TASK_ID_ASSIGNED == id select new { TaskAssign.TASK_USER_ID, User.U_LOGIN_NAME, User.U_FIRST_NAME, User.U_LAST_NAME, }).ToList(); return new JsonResult { Data = users, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; }else { task = null; } } } catch (Exception ex) { task = null; } return new JsonResult { Data = task, JsonRequestBehavior = JsonRequestBehavior.AllowGet }; }