/// <summary> /// The create user. /// </summary> /// <param name="user"> /// The user. /// </param> /// <returns> /// The <see cref="int"/>. /// </returns> public int CreateUser(NewUser user) { var createcontext = new ScrumNotesDbClassDataContext( ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString()); int users = (from u in createcontext.Users where u.ADUserName.Equals(user.ADname) select u).Count(); try { if (users != 0) { return 2; } int newid = createcontext.Users.Count() + 1; var record = new User { Id = newid, ADUserName = user.ADname, Allias = user.Name, Email = user.Email, Comments = user.Comments }; createcontext.Users.InsertOnSubmit(record); createcontext.Users.Context.SubmitChanges(); createcontext.Dispose(); return 0; } catch (Exception e) { return 1; } }
/// <summary> /// The create project. /// </summary> /// <param name="project"> /// The project. /// </param> /// <returns> /// The <see cref="int"/>. /// </returns> public int CreateProject(NewProject project) { // returns null if ok, 1 if fails, 2 if the project with similar name already exists try { project.ParsedStartDate = DateTime.Parse(project.StartDate); project.ParsedEstFinishDate = DateTime.Parse(project.EstFinishDate); var createcontext = new ScrumNotesDbClassDataContext( ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString()); int? id = createcontext.Projects.Count() + 1; IQueryable<Project> projects = from p in createcontext.Projects where p.Allias.Equals(project.Title) select p; if (projects.Count() != 0) { createcontext.Dispose(); return 2; } int newid = createcontext.Projects.Count() + 1; var record = new Project { Allias = project.Title, Comments = project.Comments, EstFinishDate = project.ParsedEstFinishDate, Id = newid, ProjectAdminId = project.Admin, StartDate = project.ParsedStartDate }; createcontext.Projects.InsertOnSubmit(record); createcontext.Projects.Context.SubmitChanges(); createcontext.Dispose(); return 0; } catch (Exception e) { return 1; } }
/// <summary> /// The modify user. /// </summary> /// <param name="user"> /// The user. /// </param> /// <returns> /// The <see cref="bool"/>. /// </returns> public bool ModifyUser(NewUser user) { try { var modifycontext = new ScrumNotesDbClassDataContext( ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString()); User userrecord = (from u in modifycontext.Users where u.Id.Equals(user.id) select u).Single(); userrecord.Allias = user.Name; userrecord.ADUserName = user.ADname; userrecord.Comments = user.Comments; userrecord.Email = user.Email; userrecord.ScrumAdmin = user.IsSCRUMadmin ?? false; modifycontext.SubmitChanges(); modifycontext.Dispose(); return true; } catch (Exception e) { return false; } }
/// <summary> /// The modify project. /// </summary> /// <param name="project"> /// The project. /// </param> /// <returns> /// The <see cref="bool"/>. /// </returns> public bool ModifyProject(NewProject project) { try { int id = project.id; var updatecontext = new ScrumNotesDbClassDataContext( ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString()); Project projectrecord = (from p in updatecontext.Projects where p.Id.Equals(id) select p).Single(); project.ParsedStartDate = DateTime.Parse(project.StartDate); project.ParsedEstFinishDate = DateTime.Parse(project.EstFinishDate); projectrecord.Allias = project.Title; projectrecord.Comments = project.Comments; projectrecord.EstFinishDate = project.ParsedEstFinishDate; projectrecord.ProjectAdminId = project.Admin; projectrecord.StartDate = project.ParsedStartDate; updatecontext.SubmitChanges(); updatecontext.Dispose(); return true; } catch (Exception e) { return false; } }
/// <summary> /// The get users list. /// </summary> /// <returns> /// The <see cref="UsersList"/>. /// </returns> public UsersList GetUsersList() { // Fetching users for Project Administrator listbox var selectioncontext = new ScrumNotesDbClassDataContext( ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString()); var userslist = new UsersList(); List<UserForModel> p2 = (from p in selectioncontext.Users select new UserForModel { ADUsername = p.ADUserName, Allias = p.Allias, Email = p.Email, Id = p.Id }).ToList(); // ADUserName = p.ADUserName, Allias = p.Allias, Email = p.Email, Id = p.Id}).ToList(); var p1 = new UsersList(); p1.UsersViewList = p2; selectioncontext.Dispose(); return p1; }
/// <summary> /// The get users in project. /// </summary> /// <param name="id"> /// The id. /// </param> /// <returns> /// The <see cref="UsersList"/>. /// </returns> public UsersList GetUsersInProject(int id) { var selectioncontext = new ScrumNotesDbClassDataContext( ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString()); List<UserForModel> p1 = (from u in selectioncontext.Users from r in selectioncontext.Roles where r.ProjectId.Equals(id) select new UserForModel { Allias = u.Allias }).ToList(); var userlist = new UsersList(); userlist.UsersViewList = p1; selectioncontext.Dispose(); return userlist; }
/// <summary> /// The get user info. /// </summary> /// <param name="userId"> /// The user id. /// </param> /// <returns> /// The <see cref="NewUser"/>. /// </returns> public NewUser GetUserInfo(int userId) { var selectioncontext = new ScrumNotesDbClassDataContext( ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString()); var user = new NewUser(); IQueryable<User> selectuser = from u in selectioncontext.Users where u.Id.Equals(userId) select u; user.Name = selectuser.FirstOrDefault().Allias; user.ADname = selectuser.FirstOrDefault().ADUserName; user.IsSCRUMadmin = selectuser.FirstOrDefault().ScrumAdmin; user.Email = selectuser.FirstOrDefault().Email; user.Comments = selectuser.FirstOrDefault().Comments; selectioncontext.Dispose(); return user; }
/// <summary> /// The get users for project roles. /// </summary> /// <param name="projectId"> /// The project id. /// </param> /// <returns> /// The <see cref="UsersListForProject"/>. /// </returns> public UsersListForProject GetUsersForProjectRoles(int projectId) { var selectioncontext = new ScrumNotesDbClassDataContext( ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString()); List<UsersViewListForProject> ulfp1; ulfp1 = (from u in selectioncontext.Users from r in selectioncontext.Roles where r.ProjectId.Equals(projectId) select new UsersViewListForProject { Id = u.Id, Allias = u.Allias, ADusername = u.ADUserName, Email = u.Email, Role = r.Name }).ToList(); var ulfp2 = new UsersListForProject(ulfp1); selectioncontext.Dispose(); return ulfp2; }
/// <summary> /// The get scheduling statuses. /// </summary> /// <param name="projectId"> /// The project id. /// </param> /// <returns> /// The <see cref="SchedulingStatusList"/>. /// </returns> public SchedulingStatusList GetSchedulingStatuses(int projectId) { var selectioncontext = new ScrumNotesDbClassDataContext( ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString()); List<SchedulingStatusViewList> ssl1 = (from s in selectioncontext.ScheduleStatus from p in selectioncontext.Projects where p.Id.Equals(projectId) select new SchedulingStatusViewList { Id = s.Id, Allias = s.Allias, DayOfWeek = s.DayOfWeek.ToString(), DayOfMonth = s.DayOfMonth.ToString(), ScheduledTime = s.ScheduledTime.ToString(), ProjectName = p.Allias }).ToList(); var ssl2 = new SchedulingStatusList(ssl1); selectioncontext.Dispose(); return ssl2; }
/// <summary> /// The get projects list. /// </summary> /// <returns> /// The <see cref="ProjectsList"/>. /// </returns> public ProjectsList GetProjectsList() { var selectioncontext = new ScrumNotesDbClassDataContext( ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString()); List<ProjectsViewList> p2 = (from p in selectioncontext.Projects from u in selectioncontext.Users where u.Id.Equals(p.ProjectAdminId) select new ProjectsViewList { Id = p.Id, Admin = u.Allias, Comments = p.Comments, Allias = p.Allias, EstFinishDate = p.EstFinishDate.ToString(), StartDate = p.StartDate.ToString() }).ToList(); var p1 = new ProjectsList(p2); selectioncontext.Dispose(); return p1; }
/// <summary> /// The get project info. /// </summary> /// <param name="projectId"> /// The project id. /// </param> /// <returns> /// The <see cref="NewProject"/>. /// </returns> public NewProject GetProjectInfo(int projectId) { var selectioncontext = new ScrumNotesDbClassDataContext( ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString()); var project = new NewProject(); IQueryable<Project> selectproject = from p in selectioncontext.Projects select p; project.Title = selectproject.FirstOrDefault().Allias; project.StartDate = selectproject.FirstOrDefault().StartDate.ToString(); project.EstFinishDate = selectproject.FirstOrDefault().EstFinishDate.ToString(); project.Comments = selectproject.FirstOrDefault().Comments; selectioncontext.Dispose(); return project; }
/// <summary> /// The delete user. /// </summary> /// <param name="userId"> /// The user id. /// </param> /// <returns> /// The <see cref="bool"/>. /// </returns> public bool DeleteUser(int userId) { try { var deletecontext = new ScrumNotesDbClassDataContext( ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString()); User user = (from u in deletecontext.Users where u.Id.Equals(userId) select u).FirstOrDefault(); deletecontext.Users.DeleteOnSubmit(user); deletecontext.SubmitChanges(); deletecontext.Dispose(); return true; } catch (Exception e) { return false; } }
/// <summary> /// The delete project. /// </summary> /// <param name="projectId"> /// The project id. /// </param> /// <returns> /// The <see cref="bool"/>. /// </returns> public bool DeleteProject(int projectId) { try { var deletecontext = new ScrumNotesDbClassDataContext( ConfigurationManager.ConnectionStrings["ScrumNotesCombinerConnectionString"].ToString()); Project project = (from p in deletecontext.Projects where p.Id.Equals(projectId) select p).FirstOrDefault(); deletecontext.Projects.DeleteOnSubmit(project); deletecontext.SubmitChanges(); deletecontext.Dispose(); return true; } catch (Exception e) { return false; } }