public static TestSuite CreateSuite(TestSuite instance)
{
try
{
TestSuite ts = null;
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
instance.IsActive = true;
ts = context.TestSuites.Add(instance);
context.SaveChanges();
}
if (ts.Type == (int)SuiteType.Dynamic || ts.Type == (int) SuiteType.NotExisting)//user created test suite
{
TestSuite root = TestSuite.GetRootNodeOfUserCustomizedTestSuites();
root.AddSubTestSuite(ts.SuiteId);
}
return ts;
}
catch (Exception e)
{
ATFEnvironment.Log.logger.Error(e);
return null;
}
}
public static List<TestCaseExecution> GetAllExecutions()
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
List<TestCaseExecution> exes = context.TestCaseExecutions.ToList<TestCaseExecution>();
return exes;
}
}
public static AutomationTask CreateTask(AutomationTask instance)
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
AutomationTask task = context.AutomationTasks.Add(instance);
context.SaveChanges();
return task;
}
}
public static AutomationJob CreateJob(AutomationJob instance)
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
AutomationJob job = context.AutomationJobs.Add(instance);
context.SaveChanges();
return job;
}
}
public static TestCaseExecution CreateExecution(TestCaseExecution instance)
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
TestCaseExecution execution = context.TestCaseExecutions.Add(instance);
context.SaveChanges();
return execution;
}
}
public static bool Delete(int id)
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
AutomationJob task = context.AutomationJobs.Find(id);
if (task == null)
{
return false;
}
context.AutomationJobs.Remove(task);
context.SaveChanges();
}
return true;
}
public static List<TaskJobMap> GetAllMaps()
{
try
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
List<TaskJobMap> maps = context.TaskJobMaps.ToList<TaskJobMap>();
return maps;
}
}
catch (Exception ex)
{
ATFEnvironment.Log.logger.Error(ex);
}
return null;
}
public static Build GetBuildByExecutionId(int id)
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
return (from b in context.Builds
where (from t in context.AutomationTasks
where(from m in context.TaskJobMaps
where(from e in context.TestCaseExecutions
where e.ExecutionId == id
select e
).FirstOrDefault().JobId == m.JobId
select m
).FirstOrDefault().TaskId == t.TaskId
select t).FirstOrDefault().BuildId == b.BuildId
select b).FirstOrDefault();
}
}
public static TestResult CreateRunResult(TestResult instance)
{
try
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
TestResult result = context.TestResults.Add(instance);
context.SaveChanges();
return result;
}
}
catch (Exception e)
{
ATFEnvironment.Log.logger.Error(e);
return null;
}
}
public static bool CreateMap(TaskJobMap instance)
{
try
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
context.TaskJobMaps.Add(instance);
context.SaveChanges();
}
}
catch (Exception e)
{
ATFEnvironment.Log.logger.Error(e);
return false;
}
return true;
}
public static TestCase CreateCase(TestCase instance)
{
try
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
instance.IsActive = true;
TestCase tc = context.TestCases.Add(instance);
context.SaveChanges();
return tc;
}
}
catch (Exception e)
{
ATFEnvironment.Log.logger.Error(e);
return null;
}
}
public static bool Delete(int resultId)
{
try
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
TestResult testResult = context.TestResults.Find(resultId);
if (testResult == null)
return false;
context.TestResults.Attach(testResult);
context.TestResults.Remove(testResult);
context.SaveChanges();
}
}
catch (Exception e)
{
ATFEnvironment.Log.logger.Error(e);
return false;
}
return true;
}
public static bool Delete(TaskJobMap instance)
{
try
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
//if (!context.TaskJobMaps.Contains(instance))
// return false;
context.TaskJobMaps.Attach(instance);
context.TaskJobMaps.Remove(instance);
context.SaveChanges();
}
}
catch (Exception e)
{
ATFEnvironment.Log.logger.Error(e);
return false;
}
return true;
}
//public bool Update()
//{
// return true;
//}
public static bool Delete(int mapId)
{
try
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
TaskJobMap map = context.TaskJobMaps.Find(mapId);
if (map == null)
return false;
context.TaskJobMaps.Remove(map);
context.SaveChanges();
}
}
catch (Exception e)
{
ATFEnvironment.Log.logger.Error(e);
return false;
}
return true;
}
public static bool Delete(TestCase instance)
{
try
{
List<TestSuite> parentSuites = null;
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
if (TestCase.GetTestCase(instance.TestCaseId) == null)
return false;
instance.IsActive = false;
//context.TestCases.Remove(instance);
//context.SaveChanges();
string sId = instance.TestCaseId.ToString();
// Remove CaseId from test suites
parentSuites = (from ts in context.TestSuites
where ts.TestCases.Contains(sId)
select ts).ToList();
context.SaveChanges();
}
foreach (TestSuite ts in parentSuites)
{
ts.DeleteSubTestCase(instance.TestCaseId);
}
}
catch (Exception e)
{
ATFEnvironment.Log.logger.Error(e);
return false;
}
return true;
}
public static List<TestSuite> GetAllTestSuites()
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
return (from ts in context.TestSuites
where ts.Type == (int)SuiteType.Static
select ts).OrderBy(ts=>ts.SourceId).ToList();
}
}
public bool Update()
{
try
{
// Entity context
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
context.TestSuites.Attach(this);
context.Entry(this).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
catch (Exception e)
{
ATFEnvironment.Log.logger.Error(e);
return false;
}
return true;
}
public bool DeleteSubTestCase(int testCaseId)
{
try
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
// Check the test cases
TestCase testCase = context.TestCases.Find(testCaseId);
if (testCase == null)
return false;
}
// Get all test cases
List<int> allcases = SplitStringToIntList(TestCases);
if (allcases.Contains(testCaseId))
allcases.Remove(testCaseId);
else
return false;
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
TestCases = CreateStringFromIntList(allcases);
context.Entry(this).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
catch (Exception )
{
}
return true;
}
public bool DeleteSubTestSuite(int testSuiteId)
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
// Check the test suite
TestSuite testSuite = context.TestSuites.Find(testSuiteId);
if (testSuite == null)
{
return false;
}
}
// Get all test suite
List<int> allSubSuite = SplitStringToIntList(SubSuites);
if (allSubSuite.Contains(testSuiteId))
{
allSubSuite.Remove(testSuiteId);
}
else
{
return false;
}
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
SubSuites = CreateStringFromIntList(allSubSuite);
context.Entry(this).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
return true;
}
public static List<TestResult> GetAllResults()
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
List<TestResult> allResults = context.TestResults.ToList<TestResult>();
return allResults;
}
}
public bool AddSubTestSuite(int testSuiteId)
{
try
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
// Check the test suites
TestSuite testSuite = context.TestSuites.Find(testSuiteId);
if (testSuite == null)
{
return false;
}
}
// Get all test cases
List<int> allSubSuite = SplitStringToIntList(SubSuites);
if (!allSubSuite.Contains(testSuiteId))
{
allSubSuite.Add(testSuiteId);
}
else
{
return false;
}
SubSuites = CreateStringFromIntList(allSubSuite);
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
context.Entry(this).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
catch (Exception )
{
return false;
}
return true;
}
/// <summary>
/// get the test suites by ProviderId and suite type
/// </summary>
/// <param name="providerId"></param>
/// <param name="suiteType"></param>
/// <returns></returns>
public static IList<TestSuite> GetTestSuitesByProviderIdAndType(int providerId, SuiteType suiteType)
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
return context.TestSuites.Where(ts => ts.ProviderId == providerId && ts.Type == (int)suiteType && ts.IsActive == true).OrderBy(ts=>ts.SourceId).ToList();
}
}
public static TestSuite Update(int id, Object instance)
{
try
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
TestSuite t = context.TestSuites.Find(id);
if (t != null)
{
context.Entry(t).CurrentValues.SetValues(instance);
context.SaveChanges();
return t;
}
return null;
}
}
catch (Exception e)
{
ATFEnvironment.Log.logger.Error(e);
return null;
}
}
/// <summary>
/// Get TestSuites by provider id
/// </summary>
/// <param name="providerId"></param>
/// <returns></returns>
public static IList<TestSuite> GetTestSuitesByProviderId(int providerId)
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
return context.TestSuites.Where(ts => ts.ProviderId == providerId).OrderBy(ts=>ts.SourceId).ToList();
}
}
/// <summary>
/// Get test suite by provider id and source id
/// </summary>
/// <param name="providerId"></param>
/// <param name="sourceId"></param>
/// <returns></returns>
public static TestSuite GetTestSuiteByProviderIdSourceIdAndType(int providerId, string sourceId, int suiteType)
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
return context.TestSuites.Where(ts => ts.ProviderId == providerId && ts.SourceId == sourceId && ts.Type == (int)suiteType).FirstOrDefault();
}
}
public static TestResult GetTestResult(int resultId)
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
return context.TestResults.Find(resultId);
}
}
public static TestResult GetTestResultByJobIdAndTestCaseId(int jobId, int testcaseId)
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
return (from result in context.TestResults
where (from excution in context.TestCaseExecutions
where excution.TestCaseId == testcaseId && excution.JobId == jobId
select excution.ExecutionId).Contains(result.ExecutionId)
select result).FirstOrDefault();
}
}
public static void DisableTestSutiesByProviderAndType(int providerId, SuiteType suiteType)
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
var suites = context.TestSuites.Where(ts => ts.ProviderId == providerId && ts.Type == (int)suiteType).Update(ts => new TestSuite { IsActive = false });
}
}
public static TaskJobMap GetTaskJobMaps(int mapId)
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
return context.TaskJobMaps.Find(mapId);
}
}
public static TestSuite GetTestSuite(int id)
{
using (ES1AutomationEntities context = new Core.Model.ES1AutomationEntities())
{
return context.TestSuites.Find(id);
}
}
