public List <ATADataModel.Project> GetAllProjectsByTeamId(ATAEntities context, int teamId)
{
var team = context.Teams.Where(t => t.TeamId.Equals(teamId)).FirstOrDefault();
var projects = team.Projects;
return(projects.ToList());
}
public void ActivateUser(ATAEntities context, string userName)
{
Member memberToBeApproved = GetMemberByUserName(context, userName);
memberToBeApproved.StatusId = (int)Statuses.Active;
context.SaveChanges();
}
public List <Test> GetAllTestsByProjectName(ATAEntities context, string projectName)
{
ATADataModel.Project p = ATACore.Managers.ProjectManager.GetByName(context, projectName);
List <Test> tests = p.Tests.Where(t => t.DeletionDate.Equals(DateTime.MinValue)).ToList();
return(tests);
}
public void AddNew(ATAEntities context, string agentMachineName, string ip, string workingDir)
{
//try
//{
AgentMachine am = new AgentMachine()
{
Name = agentMachineName,
Ip = ip,
WorkingDirPath = workingDir
};
context.AgentMachines.Add(am);
context.SaveChanges();
//}
//catch (DbEntityValidationException e)
//{
// foreach (var eve in e.EntityValidationErrors)
// {
// StreamWriter sw = new StreamWriter("validationErros.txt");
// sw.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
// eve.Entry.Entity.GetType().Name, eve.Entry.State);
// foreach (var ve in eve.ValidationErrors)
// {
// sw.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
// ve.PropertyName, ve.ErrorMessage);
// }
// sw.Close();
// }
// throw;
//}
}
public List <ATADataModel.AgentMachine> GetAllAgentMachinesByTeamId(ATAEntities context, int teamId)
{
var team = context.Teams.Where(t => t.TeamId.Equals(teamId)).FirstOrDefault();
var agentMachines = team.AgentMachines;
return(agentMachines.ToList());
}
private void btnLogin_Click(object sender, RoutedEventArgs e)
{
ResetValidationMessage();
MemberProxy.Password = tbPassword.Password;
bool areFilled = MemberProxy.AreRequiredCredentialsFieldsFilled();
if (!areFilled)
{
DisplayValidationMessage(RequiredFieldsValidationMessage);
return;
}
var context = new ATAEntities();
Member currentMember = ATACore.Managers.MemberManager.RetrieveMemberByCredentials(ATACore.Managers.ContextManager.Context, this.tbMemberUserName.Text, tbPassword.Password);
ATACore.Managers.ContextManager.Context.Dispose();
if (currentMember != null)
{
ResolveStatus(currentMember);
}
else
{
DisplayIncorrectUserCredentialsMessage();
}
}
public Member RetrieveMemberByCredentials(ATAEntities context, string userName, string password)
{
string currentUserHashedPassword = CreatePasswordHash(password);
Member currentMember = context.Members.Where(m => m.UserName.Equals(userName) && m.Password.Equals(currentUserHashedPassword)).FirstOrDefault();
return(currentMember);
}
public List <ATADataModel.AdditionalPath> GetAllAdditionalPathsByProjectId(ATAEntities context, int projectId)
{
IQueryable <ATADataModel.Project> projects = context.Projects.Where(p => p.ProjectId.Equals(projectId));
var additionalPaths = projects.FirstOrDefault().AdditionalPaths;
return(additionalPaths.ToList());
}
public void AddNewTest(ATAEntities context, int projectId, Test testToAdd)
{
ATADataModel.Project p = ATACore.Managers.ProjectManager.GetById(context, projectId);
testToAdd.AdditionDate = DateTime.Now;
p.Tests.Add(testToAdd);
context.SaveChanges();
}
private static void AddTeamsToNewMember(ATAEntities context, List <string> teams, Member newMember)
{
teams.ForEach(t =>
{
Team currentTeam = ATACore.Managers.TeamManager.GetTeamByName(context, t);
newMember.Teams.Add(currentTeam);
});
}
private static void AddAgentMachinesToNewTeam(ATAEntities context, List <string> agentMachines, Team team)
{
agentMachines.ForEach(t =>
{
ATADataModel.AgentMachine currentAgentMachine = ATACore.Managers.AgentMachineManager.GetByName(context, t);
team.AgentMachines.Add(currentAgentMachine);
});
}
private static void AddAdditionalPathsToNewProject(ATAEntities context, List <string> addiotionalPaths, ATADataModel.Project project)
{
addiotionalPaths.ForEach(t =>
{
ATADataModel.AdditionalPath currentAdditionalPath = ATACore.Managers.AdditionalPathManager.GetByName(context, t);
project.AdditionalPaths.Add(currentAdditionalPath);
});
}
private static void AddProjectsToNewTeam(ATAEntities context, List <string> projects, Team team)
{
projects.ForEach(t =>
{
ATADataModel.Project currentProject = ATACore.Managers.ProjectManager.GetByName(context, t);
team.Projects.Add(currentProject);
});
}
public List <string> GetRoles()
{
if (Roles == null)
{
var context = new ATAEntities();
Roles = context.MemberRoles.Select(x => x.Role).ToList();
}
return(Roles);
}
private void MarkAsDeletedMissingTests(List <Test> allTests)
{
ATAEntities context = ATACore.Managers.ContextManager.Context;
foreach (var cT in allTests)
{
ATACore.Managers.TestManager.RemoveTest(context, ProjectId, cT);
}
context.Dispose();
}
public void ApproveUser(ATAEntities context, string userName, MemberRoles newMemberRole)
{
Member memberToBeApproved = context.Members.Where(x => x.UserName.Equals(userName)).FirstOrDefault();
ActivationCode ac = GenerateNewActivationCode();
memberToBeApproved.ActivationCodes.Add(ac);
memberToBeApproved.UserMemberRole = newMemberRole;
memberToBeApproved.StatusId = (int)Statuses.PendingActivation;
SendActivationEmail(memberToBeApproved);
context.SaveChanges();
}
public void AddNew(ATAEntities context, string tfsPath, string tfsUrl)
{
AdditionalPath ap = new AdditionalPath()
{
TfsPath = tfsPath,
TfsUrl = tfsUrl
};
context.AdditionalPaths.Add(ap);
context.SaveChanges();
}
public bool IsActivationCodeValid(string userName, string code)
{
bool isValid = true;
using (ATAEntities context = new ATAEntities())
{
Member m = ATACore.Managers.MemberManager.GetMemberByUserName(context, userName);
var query = m.ActivationCodes.Where(c => c.Code.Equals(code) && c.ExpirationDate > DateTime.Now);
isValid = query.ToList().Count > 0 ? true : false;
}
return(isValid);
}
public void AddNew(ATAEntities context, string projectName, string tfsPath, string tfsUrl, List <string> addiotionalPaths)
{
ATADataModel.Project project = new ATADataModel.Project()
{
Name = projectName,
TfsPath = tfsPath,
TfsUrl = tfsUrl
};
AddAdditionalPathsToNewProject(context, addiotionalPaths, project);
context.Projects.Add(project);
context.SaveChanges();
}
public List <ExecutionResultRun> GetAllByTeams(ATAEntities context, List <Team> teams)
{
List <ExecutionResultRun> executionResultRuns = new List <ExecutionResultRun>();
foreach (Team cTeam in teams)
{
var allExecutionResultRunsForTeam = context.ExecutionResultRuns.Where(e => e.Member.Teams.Where(t => t.TeamId.Equals(cTeam.TeamId)).Count() > 0);
executionResultRuns.AddRange(allExecutionResultRunsForTeam.ToList());
}
return(executionResultRuns);
}
public void AddNew(ATAEntities context, string teamName, List <string> projectNames, List <string> agentMachines)
{
Team team = new Team()
{
Name = teamName
};
AddProjectsToNewTeam(context, projectNames, team);
AddAgentMachinesToNewTeam(context, agentMachines, team);
context.Teams.Add(team);
context.SaveChanges();
}
public List <Team> GetAllUserTeams(ATAEntities context, string userName)
{
Member member = ATACore.Managers.MemberManager.GetMemberByUserName(context, userName);
if (member.UserMemberRole.Equals(MemberRoles.Admin))
{
return(context.Teams.ToList());
}
else
{
return(member.Teams.ToList());
}
}
public List <CheckedItem> GetTeams()
{
if (teams == null)
{
var context = new ATAEntities();
var query = from x in context.Teams
select new CheckedItem
{
Description = x.Name,
Selected = false
};
teams = query.ToList();
}
return(teams);
}
public Member CreateUser(ATAEntities context, string userName, string password, string email, string tfsUserName, string role, List <string> teams, string comment)
{
string hashedPassword = CreatePasswordHash(password);
MemberRole currentMemberRole = ATACore.Managers.MemberRoleManager.GetMemberRoleByRoleName(context, role);
Member newMember = new Member()
{
UserName = userName,
Password = hashedPassword,
Email = email,
Comment = comment,
TfsUserName = tfsUserName,
MemberRoleId = currentMemberRole.MemberRoleId
};
newMember.StatusId = (int)Statuses.ToBeApproved;
AddTeamsToNewMember(context, teams, newMember);
context.Members.Add(newMember);
context.SaveChanges();
return(newMember);
}
public Member GetMemberByUserName(ATAEntities context, string userName)
{
Member member = context.Members.Where(x => x.UserName.Equals(userName)).FirstOrDefault();
return(member);
}
public string GetTfsUserNameByUserName(ATAEntities context, string currentUserName)
{
Member m = GetMemberByUserName(context, currentUserName);
return(m.TfsUserName);
}
public List <Member> GetAllMembersForApproval(ATAEntities context)
{
var query = context.Members.Where(m => m.StatusId.Equals(2));
return(query.ToList());
}
public void Save(ATAEntities context, TestResultRun testResultRun)
{
context.TestResultRuns.Add(testResultRun);
context.SaveChanges();
}
public List <TestResultRun> GetRunsByExecutionResultRun(ATAEntities context, string executionResultRunId)
{
List <TestResultRun> testResultRuns = context.TestResultRuns.Where(t => t.ExecutionResultRunId.Equals(executionResultRunId)).ToList();
return(testResultRuns);
}
public Team GetTeamByName(ATAEntities context, string name)
{
Team currentTeam = context.Teams.Where(x => x.Name.Equals(name)).FirstOrDefault();
return(currentTeam);
}
