public void ClearEntitiesInDatabase()
{
using (var db = new SpContext())
{
Console.WriteLine("This action wil clear the entire SmartPool user database (yes/no).");
if (SecurityCheck() == true)
{
db.Database.ExecuteSqlCommand("DELETE [MonitorUnits]");
Console.WriteLine("Clearing MonitorUnits...");
db.Database.ExecuteSqlCommand("DELETE [Pools]");
Console.WriteLine("Clearing pools...");
db.Database.ExecuteSqlCommand("DELETE [UserEntities]");
Console.WriteLine("Clearing UserEntities...");
db.Database.ExecuteSqlCommand("DELETE [RealNames]");
Console.WriteLine("Clearing RealNames");
Console.WriteLine("************************************************************");
Console.WriteLine("******************** All tables cleared! *******************");
db.SaveChanges();
}
else
{
return;
}
}
}
public void AddUserToDatabase(UserEntity userEntity)
{
using (var db = new SpContext())
{
db.UserEntities.Add(userEntity);
db.SaveChanges();
}
}