private static CostcoDevStatusEntities createContext()
{
const string ConnectionString = "Server=tcp:costcosu.database.windows.net,1433;Database=CostcoDevStatus;User ID=SUAdmin@costcosu;Password=39ffbJeo;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
CostcoDevStatusEntities context = CostcoDevStatusEntities.Create(ConnectionString);
return(context);
}
private static bool deleteAllData()
{
try
{
CostcoDevStatusEntities context = createContext();
IEnumerable <StatusUpdate> updates = context.StatusUpdates;
foreach (StatusUpdate update in updates)
{
Console.WriteLine("Removing Status Update " + update.ProjectName + "," + update.UpdateKey);
context.StatusUpdates.Remove(update);
}
context.SaveChanges();
IEnumerable <ProjectPhase> statusSequences = context.ProjectPhases;
foreach (ProjectPhase statusSequence in statusSequences)
{
Console.WriteLine("Removing ProjectPhase record " + statusSequence.Project.ProjectName + "_"
+ statusSequence.UpdateKey);
context.ProjectPhases.Remove(statusSequence);
}
context.SaveChanges();
IEnumerable <Project> projects = context.Projects;
foreach (Project project in projects)
{
Console.WriteLine("Removing Project " + project.ProjectName);
context.Projects.Remove(project);
}
context.SaveChanges();
}
catch (Exception e)
{
errorMessage = e.Message;
return(false);
}
return(true);
}
public AccessService()
{
context = CostcoDevStatusEntities.Create(ConnectionString);
}
