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);
}
}
