public static List<TestEnvironment> GetAllEnvironments()
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.TestEnvironments.ToList<TestEnvironment>();
}
}
public static Release GetReleaseById(int id)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Releases.Find(id);
}
}
public static Release GetReleaseByName(string name)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Releases.Where(r => r.Name.ToLower() == name.ToLower()).FirstOrDefault();
}
}
public static List<Project> GetAllProjects()
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Projects.OrderBy(p => p.ProjectId).ToList();
}
}
public static Provider GetProviderById(int id)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Providers.Find(id);
}
}
public static ProjectEnvironmentMap GetProductEnvironmentMapById(int id)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.ProjectEnvironmentMaps.Find(id);
}
}
public static List<Product> GetAllProducts()
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Products.ToList<Product>();
}
}
public static List<Ranking> GetAllRankings()
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Rankings.OrderBy(r => r.Name).ToList<Ranking>();
}
}
public static Ranking GetRankingById(int id)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Rankings.Find(id);
}
}
public static SupportedEnvironment GetSupportedEnvironmentById(int environmentId)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.SupportedEnvironments.Find(environmentId);
}
}
public static List<SupportedEnvironment> GetSupportedEnvironments()
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.SupportedEnvironments.ToList<SupportedEnvironment>();
}
}
public static SupportedEnvironment Add(SupportedEnvironment supportedEnvironment)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
int environmentId = 0;
try
{
environmentId = (from e in context.SupportedEnvironments select e.EnvironmentId).Max() + 1;
}
catch (Exception e)
{
ATFEnvironment.Log.logger.Error(e);
environmentId = 1;
}
if (SupportedEnvironment.GetSupportedEnvironmentById(environmentId) != null)
{
return null;
}
supportedEnvironment.EnvironmentId = environmentId;
SupportedEnvironment supportEnvironmentAdded = context.SupportedEnvironments.Add(supportedEnvironment);
context.SaveChanges();
return supportEnvironmentAdded;
}
}
public static Subscriber GetSubscriberById(int id)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Subscribers.Find(id);
}
}
public static List<Subscriber> GetAllSubscribers()
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Subscribers.ToList();
}
}
public static void Delete(int userId)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
Delete(GetUserById(userId));
}
}
public static List<Branch> GetAllBranches()
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Branches.ToList<Branch>();
}
}
public static List<ProjectEnvironmentMap> GetAllProductEnvironmentMap()
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.ProjectEnvironmentMaps.ToList<ProjectEnvironmentMap>();
}
}
public static Branch GetBranchById(int id)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Branches.Find(id);
}
}
/// <summary>
/// Get all the branches for the product
/// </summary>
/// <param name="productID">product ID</param>
/// <returns>List<Build>List of branches</returns>
public static List<Branch> GetAllBranchesForProduct(int productID, int type)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Branches.Where(b => b.ProductId == productID && b.Type== type).OrderBy(b => b.Name).ToList();
}
}
public static Branch GetBranchByName(string name)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Branches.Where(b => b.Name.ToLower() == name.ToLower()).FirstOrDefault();
}
}
/// <summary>
/// Get all the releases for the product
/// </summary>
/// <param name="productID">product ID</param>
/// <returns>List<Build>List of releases</returns>
public static List<Release> GetAllReleasesForProduct(int productID, int type)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Releases.Where(r => r.ProductId == productID && r.Type == type).OrderBy(r => r.Name).ToList();
}
}
public static List<Release> GetAllReleases()
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.Releases.ToList<Release>();
}
}
public static List<AutomationTask> GetLatestNAutomationTasksForProject(int projectId, int count)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
IList<AutomationTask> tasks = (from task in context.AutomationTasks
from build in context.Builds
where task.BuildId == build.BuildId &&
task.ProjectId == projectId &&
//task.NotifyStakeholders == true &&
(task.Status == (int)TaskStatus.Complete || task.Status == (int)TaskStatus.End || task.Status == (int)TaskStatus.Failed) &&
task.RecurrencePattern.Value == (int)RecurrencePattern.AtOnce
orderby task.TaskId descending
select task).ToList();
IList<Build> builds = (from task in context.AutomationTasks
from build in context.Builds
where task.BuildId == build.BuildId &&
task.ProjectId == projectId &&
//task.NotifyStakeholders == true &&
(task.Status == (int)TaskStatus.Complete || task.Status == (int)TaskStatus.End || task.Status == (int)TaskStatus.Failed) &&
task.RecurrencePattern.Value == (int)RecurrencePattern.AtOnce
orderby task.TaskId descending
select build).ToList();
int r;
List<AutomationTask> nTasks = (from build in builds
from task in tasks
where build.BuildId == task.BuildId
orderby (int.TryParse(build.Number, out r) ? r : 0) descending
select task).Take(count).ToList();
return nTasks;
}
}
public static void Delete(int buildId)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
Delete(GetBuildById(buildId));
}
}
public static DiagnosticLog GetDiagnosticLogById(int id)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.DiagnosticLogs.Find(id);
}
}
public static void Delete(int environmentId)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
Delete(GetEnvironmentById(environmentId));
}
}
public static List<DiagnosticLog> GetAllDiagnosticLogs()
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
return context.DiagnosticLogs.ToList();
}
}
public static void ClearDiagnosticLog()
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
context.DiagnosticLogs.RemoveRange(context.DiagnosticLogs);
context.SaveChanges();
}
}
public static Build GetLatestBuildByProductBranchAndRelease(int productId, int branchId, int releaseId)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
IList<Build> builds = context.Builds.Where(b => b.ProductId == productId && b.BranchId == branchId && b.ReleaseId == releaseId).ToList();
return builds.OrderByDescending(b => int.Parse(b.Number.Split(new string[] { "." }, StringSplitOptions.None)[b.Number.Split(new string[] { "." }, StringSplitOptions.None).Length - 1])).FirstOrDefault();
}
}
public static DiagnosticLog AddDiagnosticLog(DiagnosticLog log)
{
using (ES1AutomationEntities context = new ES1AutomationEntities())
{
context.DiagnosticLogs.Add(log);
context.SaveChanges();
return log;
}
}
