private void SaveSuites() { var suiteNameSet = new HashSet <string>(); foreach (var item in _testsFromXml.ListOfTests) { suiteNameSet.Add(item.TestSuite); } using (var db = new testsettingsEntities()) { foreach (var name in suiteNameSet) { var inDb = db.testsuites.FirstOrDefault(i => i.testsuitename == name); // Item already in db if (inDb != null) { continue; } // Item not in db db.testsuites.Add(new testsuite { testsuitename = name }); db.SaveChanges(); } } }
private void SaveTests() { using (var db = new testsettingsEntities()) { foreach (var item in _testsFromXml.ListOfTests) { var inDb = db.testcases.FirstOrDefault(i => i.testcasename.Equals(item.TestName)); // Item alrady in db if (inDb != null) { continue; } // Item not in db var suite = db.testsuites.FirstOrDefault(i => i.testsuitename == item.TestSuite); if (suite == null) { throw new Exception("TestSuite not found"); } db.testcases.Add(new testcase { testcasename = item.TestName, belongstosuite = suite.testsuiteid, testcasedescription = item.TestCaseDescription, testsuite = suite }); db.SaveChanges(); } } }
private void SaveResults() { var db = new testsettingsEntities(); db.testruns.Add(_result); db.SaveChanges(); db.Dispose(); }
public static void DeactivateAll() { var db = new testsettingsEntities(); var toUpdate = db.settings.Where(item => item.isActive == 1).ToList(); toUpdate.ForEach(i => i.isActive = 0); db.SaveChanges(); db.Dispose(); }
public ActionResult DeleteConfirmed(int id) { using (var db = new testsettingsEntities()) { var item = db.settings.Find(id); if (item == null) { throw new NoNullAllowedException("Id field can't be null."); } db.settings.Remove(item); db.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Edit([Bind(Include = "id,targetBrowser,operatingSystem,seleniumHubUri,screenshotFolder,isActive")] setting setting) { if (!ModelState.IsValid) { return(View(setting)); } using (var db = new testsettingsEntities()) { if (setting.isActive == 1) { Database.DbHelpers.DeactivateAll(); } db.Entry(setting).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult Create([Bind(Include = "id,targetBrowser,operatingSystem,seleniumHubUri,screenshotFolder,isActive")] setting setting) { setting.id = Database.DbHelpers.GetNextId(); using (var db = new testsettingsEntities()) { if (ModelState.IsValid) { if (setting.isActive == 1) { Database.DbHelpers.DeactivateAll(); } db.settings.Add(setting); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(setting)); } }