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