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 static IList <testrun> GetOrderedList()
{
using (var db = new testsettingsEntities())
{
return(db.testruns.OrderByDescending(testrun => testrun.starttime).ToList());
}
}
// GET: Settings
public ActionResult Index()
{
using (var db = new testsettingsEntities())
{
return(View(db.settings.ToList()));
}
}
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 ActionResult GenerateXml()
{
new AppConfigWriter().OutputXml();
using (var db = new testsettingsEntities())
{
return(View(db.settings.ToList()));
}
}
public ActionResult StopAutomatedTests()
{
RunTestsHelper.StopNunitTests(_processId);
using (var db = new testsettingsEntities())
{
return(View(db.settings.ToList()));
}
}
private static setting GetDataFromDb()
{
var db = new testsettingsEntities();
var setting = db.settings.FirstOrDefault(item => item.isActive == 1);
db.Dispose();
return(setting);
}
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();
}
private static setting GetDataFromDb()
{
var db = new testsettingsEntities();
var config = (from item in db.settings
where item.isActive == 1
select item).ToList().FirstOrDefault();
db.Dispose();
return(config);
}
public static int GetNextId()
{
var db = new testsettingsEntities();
var items = db.settings.OrderBy(item => item.id).ToList();
if (!items.Any())
{
return(1);
}
return(++items.Last().id);
}
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"));
}
}
// GET: Settings/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
using (var db = new testsettingsEntities())
{
var setting = db.settings.Find(id);
if (setting == null)
{
return(HttpNotFound());
}
return(View(setting));
}
}
// GET: Testruns/Delete/5
public ActionResult Delete(string guid)
{
using (var db = new testsettingsEntities())
{
if (string.IsNullOrWhiteSpace(guid))
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var testrun = db.testruns.Find(guid);
if (testrun == null)
{
return(HttpNotFound());
}
return(View(testrun));
}
}
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));
}
}
public ActionResult RunAutomatedTests()
{
// If you move or rename the root directory 'SeleniumAutomationToolbox', please update these paths
#if DEBUG
const string path = @"C:\SeleniumAutomationToolbox\src\NetFramework\Automation.Tests\bin\Debug\Automation.Tests.dll";
#endif
#if !DEBUG
const string path = @"C:\SeleniumAutomationToolbox\src\NetFramework\Automation.Tests\bin\Release\Automation.Tests.dll";
#endif
_processId = RunTestsHelper.RunNunitTests(
$"{path} " +
"--workers=30 " +
@"--work=C:\SeleniumAutomationToolbox\NunitWork " +
"--trace=Verbose",
ProcessWindowStyle.Normal);
using (var db = new testsettingsEntities())
{
return(View(db.settings.ToList()));
}
}
