public ActionResult EditProject(int?id) { OPTDBContext dbEntities = new OPTDBContext(); Project project = dbEntities.Projects.Find(id); return(View(project)); }
public ActionResult Edit(Employee employee) { try { ViewBag.Designations = GetDesignationList(); ViewBag.Managers = GetManagerList(); if (!ModelState.IsValid) { return(View()); } else { if (employee.Designation.Equals("Project Manager")) { employee.ManagerID = null; } using (OPTDBContext dbEntities = new OPTDBContext()) { dbEntities.Employees.Add(employee); dbEntities.Entry(employee).State = System.Data.Entity.EntityState.Modified; dbEntities.SaveChanges(); } TempData["employee_eidt_success"] = "Employee record updated successfully."; return(View(employee)); } } catch (System.Exception) { TempData["employee_eidt_error"] = "Employee record update failed."; return(View(employee)); } }
public ActionResult EditProject(Project project) { try { if (!ModelState.IsValid) { return(View()); } else { using (OPTDBContext dbEntities = new OPTDBContext()) { dbEntities.Projects.Add(project); dbEntities.Entry(project).State = System.Data.Entity.EntityState.Modified; dbEntities.SaveChanges(); } TempData["project_eidt_success"] = "Project updated successfully."; return(View(project)); } } catch (System.Exception) { TempData["project_eidt_error"] = "Project record update failed."; return(View(project)); } }
// GET: Projects public ActionResult Index() { OPTDBContext context = new OPTDBContext(); List <Project> projects = context.Projects.ToList(); return(View(projects)); }
public ActionResult UploadTask(ProjectTask projectTask) { try { OPTDBContext context = new OPTDBContext(); ProjectTask projectTaskDB = context.ProjectTasks.FirstOrDefault(pt => pt.ProjectTaskID == projectTask.ProjectTaskID); projectTaskDB.TaskCompletionDesciption = string.IsNullOrEmpty(projectTask.TaskCompletionDesciption) ? "" : projectTask.TaskCompletionDesciption; HttpPostedFileBase file = Request.Files["file"]; if (file != null && file.ContentLength > 0) { string FileName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + "-" + file.FileName; string path = Server.MapPath("~/Content/Uploads/" + FileName); file.SaveAs(path); projectTaskDB.TaskData = FileName; } context.SaveChanges(); TempData["data_upload_ok"] = "Ok"; return(View(projectTask)); } catch (System.Exception ex) { TempData["data_upload_error"] = ex.ToString(); return(View(new ProjectTask())); } }
public ActionResult EditStory(UserStory userStory) { List <SelectListItem> projects = GetProjectList(); projects.Find(p => p.Value == userStory.ProjectID.ToString()).Selected = true; ViewBag.Projects = projects; try { if (!ModelState.IsValid) { return(View()); } else { using (OPTDBContext dbEntities = new OPTDBContext()) { dbEntities.UserStories.Add(userStory); dbEntities.Entry(userStory).State = System.Data.Entity.EntityState.Modified; dbEntities.SaveChanges(); } TempData["story_eidt_success"] = "sucess"; return(View(userStory)); } } catch (System.Exception) { TempData["story_eidt_error"] = "failed."; return(View(userStory)); } }
public ActionResult Login(LoginViewModel model) { if (!ModelState.IsValid) { TempData["login_error"] = "Please fill all the fields"; return(View(model)); } else { OPTDBContext dbEntities = new OPTDBContext(); UserAccount user = dbEntities.UserAccounts.Where(account => account.Email == model.email && account.Password == model.password).SingleOrDefault(); if (user != null) { Session["user_id"] = user.EmployeeID; Session["user_email"] = user.Email; Session["name"] = user.Employee.EmployeeName; Session["role"] = user.Employee.Designation; return(RedirectToAction("Index", "Home")); } else { TempData["invalid_login"] = "******"; return(View(model)); } } }
public ActionResult AddNewProject(ProjectViewModel project) { try { if (!ModelState.IsValid) { return(View()); } else { OPTDBContext dbEntities = new OPTDBContext(); Project dbproject = new Project() { ProjectName = project.ProjectName, ClientName = project.ClientName, StartDate = project.StartDate, EndDate = project.EndDate, ProjectDescription = project.ProjectDescription }; dbEntities.Projects.Add(dbproject); dbEntities.SaveChanges(); TempData["newproject_success"] = "added"; return(View()); } } catch (System.Exception) { TempData["newproject_error"] = "error"; } return(View()); }
// GET: UserStories public ActionResult Index() { OPTDBContext context = new OPTDBContext(); List <UserStory> stories = context.UserStories.ToList(); return(View(stories)); }
// GET: Employee public ActionResult ViewAllEmployees() { OPTDBContext context = new OPTDBContext(); List <Employee> employees = context.Employees.Where(model => model.Designation != "Admin").ToList(); return(View(employees)); }
public ActionResult Edit(int?id) { ViewBag.Designations = GetDesignationList(); ViewBag.Managers = GetManagerList(); OPTDBContext dbEntities = new OPTDBContext(); Employee employee = dbEntities.Employees.Where(model => model.EmployeeID == id).SingleOrDefault(); return(View(employee)); }
public ActionResult EditStory(int?id) { OPTDBContext dbEntities = new OPTDBContext(); UserStory story = dbEntities.UserStories.Find(id); List <SelectListItem> projects = GetProjectList(); projects.Find(p => p.Value == story.ProjectID.ToString()).Selected = true; ViewBag.Projects = projects; return(View(story)); }
public FileResult DownloadTaskData(int id) { OPTDBContext context = new OPTDBContext(); ProjectTask projectTaskDB = context.ProjectTasks.FirstOrDefault(pt => pt.ProjectTaskID == id); string fileName = projectTaskDB.TaskData; string path = Server.MapPath("~/Content/Uploads/" + fileName); byte[] fileBytes = System.IO.File.ReadAllBytes(path); return(File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName)); //return File(path, System.Net.Mime.MediaTypeNames.Application.Octet, fileName); }
public ActionResult UploadTask(int id) { try { OPTDBContext context = new OPTDBContext(); ProjectTask projectTask = context.ProjectTasks.FirstOrDefault(pt => pt.ProjectTaskID == id); return(View(projectTask)); } catch (System.Exception) { return(View(new ProjectTask())); } }
// GET: ProjectTasks public ActionResult Index() { OPTDBContext context = new OPTDBContext(); List <ProjectTask> projectTasks; if (!Session["role"].ToString().Equals("Developer") && !Session["role"].ToString().Equals("Designer")) { projectTasks = context.ProjectTasks.ToList(); } else { int useID = int.Parse(Session["user_id"].ToString().Trim()); projectTasks = context.ProjectTasks.Where(task => task.AssignedTo == useID).ToList(); } return(View(projectTasks)); }
public ActionResult AddNewEmployee(EmployeeViewModel employee) { try { ViewBag.Designations = GetDesignationList(); ViewBag.Managers = GetManagerList(); if (!ModelState.IsValid) { return(View()); } else { OPTDBContext dbEntities = new OPTDBContext(); if (employee.Designation.Equals("Project Manager")) { employee.ManagerID = null; } Employee dbemployee = new Employee() { EmployeeName = employee.EmployeeName, Designation = employee.Designation, ContactNo = employee.ContactNo, EMailID = employee.EMailID, ManagerID = employee.ManagerID, SkillSets = employee.SkillSets }; dbEntities.Employees.Add(dbemployee); dbEntities.SaveChanges(); /// Create account ------ UserAccount userAccount = new UserAccount() { EmployeeID = dbemployee.EmployeeID, Email = dbemployee.EMailID, Password = "******", }; dbEntities.UserAccounts.Add(userAccount); dbEntities.SaveChanges(); TempData["newemployee_success"] = "added"; return(View()); } } catch (System.Exception) { TempData["newemployee_error"] = "error"; } return(View()); }
public ActionResult Delete(int?id) { if (id.HasValue) { OPTDBContext ctx = new OPTDBContext(); UserAccount userAccount = ctx.UserAccounts.Where(account => account.EmployeeID == id).SingleOrDefault(); Employee employee = ctx.Employees.Where(emp => emp.EmployeeID == id).SingleOrDefault(); if (userAccount != null && employee != null) { ctx.UserAccounts.Remove(userAccount); ctx.SaveChanges(); ctx.Employees.Remove(employee); ctx.SaveChanges(); } } return(RedirectToAction("ViewAllEmployees")); }
public JsonResult MarkCompleted(int task_id, int task_status) { try { OPTDBContext context = new OPTDBContext(); ProjectTask projectTask = context.ProjectTasks.FirstOrDefault(pt => pt.ProjectTaskID == task_id); if (projectTask != null) { projectTask.TaskStatus = task_status; context.SaveChanges(); return(Json(new { code = 200 })); } return(Json(new { code = 500 })); } catch (System.Exception) { return(Json(new { code = 200 })); } }
private List <SelectListItem> GetManagerList() { List <SelectListItem> managers = new List <SelectListItem>() { new SelectListItem { Text = "Please select", Value = "-1", Disabled = true, Selected = true } }; OPTDBContext dbEntities = new OPTDBContext(); List <Employee> dbmanagers = dbEntities.Employees.Where(employee => employee.Designation.Equals("Project Manager")).ToList(); foreach (Employee employee in dbmanagers) { managers.Add(new SelectListItem() { Text = employee.EmployeeName, Value = employee.EmployeeID.ToString() }); } return(managers); }
private List <SelectListItem> GetProjectList() { List <SelectListItem> projects = new List <SelectListItem>() { new SelectListItem { Text = "Please select", Value = "", Disabled = true, Selected = true } }; OPTDBContext dbEntities = new OPTDBContext(); List <Project> dbprojects = dbEntities.Projects.ToList(); foreach (Project project in dbprojects) { projects.Add(new SelectListItem() { Text = project.ProjectName, Value = project.ProjectID.ToString() }); } return(projects); }
private List <SelectListItem> GetUserStoriesList() { List <SelectListItem> userstories = new List <SelectListItem>() { new SelectListItem { Text = "Please select", Value = "", Disabled = true, Selected = true } }; OPTDBContext dbEntities = new OPTDBContext(); List <UserStory> dbuserstories = dbEntities.UserStories.ToList(); foreach (UserStory userStory in dbuserstories) { userstories.Add(new SelectListItem() { Text = userStory.Story, Value = userStory.UserStoryID.ToString() }); } return(userstories); }
private List <SelectListItem> GetEmployeeList() { List <SelectListItem> employees = new List <SelectListItem>() { new SelectListItem { Text = "Please select", Value = "", Disabled = true, Selected = true } }; OPTDBContext dbEntities = new OPTDBContext(); List <Employee> dbemployees = dbEntities.Employees.Where(emp => emp.Designation != "Project Manager" && emp.Designation != "Business Analyst" && emp.Designation != "Admin").ToList(); foreach (Employee employee in dbemployees) { employees.Add(new SelectListItem() { Text = employee.EmployeeName, Value = employee.EmployeeID.ToString() }); } return(employees); }
public ActionResult AddNewStory(UserStory userStory) { try { ViewBag.Projects = GetProjectList(); if (!ModelState.IsValid) { return(View()); } else { OPTDBContext dbEntities = new OPTDBContext(); dbEntities.UserStories.Add(userStory); dbEntities.SaveChanges(); TempData["newstory_success"] = "added"; } } catch (System.Exception) { TempData["newstory_error"] = "error"; } return(View()); }
public ActionResult AddNewTask(ProjectTask projectTask) { ViewBag.Employees = GetEmployeeList(); ViewBag.UserStories = GetUserStoriesList(); ViewBag.TaskTypes = GetTaskTypeList(); try { if (!ModelState.IsValid) { return(View()); } OPTDBContext dbEntities = new OPTDBContext(); dbEntities.ProjectTasks.Add(projectTask); dbEntities.SaveChanges(); TempData["newtask_success"] = "added"; } catch (System.Exception) { TempData["newtask_error"] = "error"; } return(View()); }
public ActionResult AddComment(ManagerComment managerComment) { ViewBag.TaskID = managerComment.ProjectTaskID; try { if (!ModelState.IsValid) { return(View()); } else { OPTDBContext dbEntities = new OPTDBContext(); dbEntities.ManagerComments.Add(managerComment); dbEntities.SaveChanges(); TempData["newcomment_success"] = "added"; return(View()); } } catch (System.Exception) { TempData["newcomment_error"] = "error"; } return(View()); }