Beispiel #1
0
        public List <teams> GetTeamListByProjectId(int ProjectId)
        {
            using (scheduler_v2Entities db = new scheduler_v2Entities())
            {
                var listOfTeamIds = GetTeamIdsByProjectId(ProjectId);

                var listOfTeams = db.teams.Where(x => listOfTeamIds.Contains(x.id));

                project_teams projectTeam = (project_teams)db.project_teams.Where(x => x.project_id == ProjectId);
                if (listOfTeamIds == null)
                {
                    return(null);
                }
                else
                {
                    int          teamId = (int)projectTeam.team_id;
                    List <teams> teams  = new List <teams>();
                    foreach (var team in teams)
                    {
                        teams.Add(team);
                    }
                    return(teams);
                }
            }
        }
Beispiel #2
0
        public void AddUserToTeam(string TeamName, int Teamlead_id, int[] User_ids)
        {
            using (scheduler_v2Entities db = new scheduler_v2Entities())
            {
                UserManager umngr     = new UserManager();
                var         teamClass = new teams
                {
                    name        = TeamName,
                    teamlead_id = Teamlead_id
                };
                db.teams.Add(teamClass);
                db.teams.Attach(teamClass);
                var teamlead = new user_teams
                {
                    team_id = teamClass.id,
                    user_id = Teamlead_id
                };
                db.teams.Add(teamClass);
                db.user_teams.Add(teamlead);

                foreach (int id in User_ids)
                {
                    users person    = umngr.GetUser(id);
                    var   user_team = new user_teams
                    {
                        team_id = teamClass.id,
                        user_id = id
                    };
                    db.user_teams.Add(user_team);
                }

                db.SaveChanges();
            }
        }
Beispiel #3
0
 public users GetUser(int id)
 {
     using (var db = new scheduler_v2Entities())
     {
         users user = db.users.Find(id);
         Debug.WriteLine(user.username);
         return(user);
     }
 }
Beispiel #4
0
 public string GetProjectNameById(int projectId)
 {
     using (var db = new scheduler_v2Entities())
     {
         var name = (from item in db.projects
                     where item.id == projectId
                     select item.name).FirstOrDefault();
         return(name);
     }
 }
Beispiel #5
0
 public string GetActivityById(int activityId)
 {
     using (var db = new scheduler_v2Entities())
     {
         var name = (from item in db.activities
                     where item.id == activityId
                     select item.name).FirstOrDefault();
         return(name);
     }
 }
Beispiel #6
0
 public string GetUserRole(int id)
 {
     using (var db = new scheduler_v2Entities())
     {
         var role = (from item in db.users
                     where item.id == id
                     select item.roles).FirstOrDefault();
         return(role);
     }
 }
Beispiel #7
0
        public int GetAccountIdFromName(string accountName)
        {
            using (var db = new scheduler_v2Entities())
            {
                var userAccId = (from s in db.users
                                 where s.username == accountName
                                 select s.id).FirstOrDefault();

                return(userAccId);
            }
        }
Beispiel #8
0
 public string GetPassword(string accountName) // Gets password from DB
 {
     using (var db = new scheduler_v2Entities())
     {
         var password = db.users
                        .Where(s => s.username == accountName)
                        .Select(s => s.password)
                        .FirstOrDefault()
                        .ToString();
         return(password);
     }
 }
Beispiel #9
0
        public string GetCustomerNameByProjectId(int projectId)
        {
            using (var db = new scheduler_v2Entities())
            {
                var customerId = (from item in db.projects
                                  where item.id == projectId
                                  select item.customer_id).FirstOrDefault();

                var name = (from item in db.customers
                            where item.id == customerId
                            select item.name).FirstOrDefault();
                return(name);
            }
        }
Beispiel #10
0
        //Checks if there are matching team names in db
        public bool TeamNameExists(string TeamName)
        {
            bool exists = true;

            using (scheduler_v2Entities db = new scheduler_v2Entities())
            {
                var team = db.teams.Where(x => x.name == TeamName);
                if (team == null)
                {
                    exists = !exists;
                }
            }
            return(exists);
        }
Beispiel #11
0
 public List <int?> GetTeamIdsByProjectId(int ProjectId)
 {
     using (scheduler_v2Entities db = new scheduler_v2Entities())
     {
         var listOfIds = db.project_teams.Select(x => x.project_id).ToList();
         if (listOfIds.Count < 1)
         {
             return(null);
         }
         else
         {
             return(listOfIds);
         }
     }
 }
Beispiel #12
0
 //Returns team object by given id and returns null if not found
 public teams GetTeamById(int TeamId)
 {
     using (scheduler_v2Entities db = new scheduler_v2Entities())
     {
         teams team = (teams)db.teams.Where(x => x.id == TeamId);
         if (team == null)
         {
             return(null);
         }
         else
         {
             return(team);
         }
     }
 }
Beispiel #13
0
        public bool CheckIfAccountNameExists(string accountNameInput) // Check if account name exists in DB
        {
            bool accountNameIsNotOk = true;

            using (var db = new scheduler_v2Entities())
            {
                var accName = (from s in db.users
                               where s.username == accountNameInput
                               select s.username).DefaultIfEmpty(String.Empty).First();

                if (accName.Equals(String.Empty))
                {
                    accountNameIsNotOk = false;
                }
                ;

                return(accountNameIsNotOk);
            }
        }
Beispiel #14
0
        public bool CheckIfEmailExists(string emailInput) // check if email exists in db
        {
            bool emailExists = false;

            using (var db = new scheduler_v2Entities())
            {
                var email = (from s in db.users
                             where s.email == emailInput
                             select s.email).DefaultIfEmpty(String.Empty).First().ToString();

                if (email != (String.Empty))
                {
                    emailExists = true; // returns if linq query returns an email from DB
                }
                ;

                return(emailExists);
            }
        }
Beispiel #15
0
        public string GetUserSalt(string accountNameInput) // Gets salt from DB
        {
            string salt = null;

            using (var db = new scheduler_v2Entities())
            {
                try
                {
                    salt = db.users
                           .Where(s => s.username == accountNameInput)
                           .Select(s => s.salt)
                           .FirstOrDefault()
                           .ToString();
                }
                catch
                {
                    return(salt);
                }

                return(salt);
            }
        }