コード例 #1
0
ファイル: Database.cs プロジェクト: rudel/ScrumNotes
        /// <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;
            }
        }
コード例 #2
0
ファイル: Database.cs プロジェクト: rudel/ScrumNotes
        /// <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;
            }
        }
コード例 #3
0
ファイル: Database.cs プロジェクト: rudel/ScrumNotes
 /// <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;
     }
 }
コード例 #4
0
ファイル: Database.cs プロジェクト: rudel/ScrumNotes
 /// <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;
     }
 }
コード例 #5
0
ファイル: Database.cs プロジェクト: rudel/ScrumNotes
        /// <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;
        }
コード例 #6
0
ファイル: Database.cs プロジェクト: rudel/ScrumNotes
 /// <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;
 }
コード例 #7
0
ファイル: Database.cs プロジェクト: rudel/ScrumNotes
 /// <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;
 }
コード例 #8
0
ファイル: Database.cs プロジェクト: rudel/ScrumNotes
 /// <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;
 }
コード例 #9
0
ファイル: Database.cs プロジェクト: rudel/ScrumNotes
 /// <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;
 }
コード例 #10
0
ファイル: Database.cs プロジェクト: rudel/ScrumNotes
 /// <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;
 }
コード例 #11
0
ファイル: Database.cs プロジェクト: rudel/ScrumNotes
 /// <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;
 }
コード例 #12
0
ファイル: Database.cs プロジェクト: rudel/ScrumNotes
 /// <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;
     }
 }
コード例 #13
0
ファイル: Database.cs プロジェクト: rudel/ScrumNotes
 /// <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;
     }
 }