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); } } }
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(); } }
public users GetUser(int id) { using (var db = new scheduler_v2Entities()) { users user = db.users.Find(id); Debug.WriteLine(user.username); return(user); } }
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); } }
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); } }
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); } }
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); } }
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); } }
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); } }
//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); }
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); } } }
//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); } } }
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); } }
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); } }
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); } }