static void Main(string[] args)
{
if (inDebug)
{
AccessService dbService = new AccessService();
//
var projectUpdates = dbService.GetProjectUpdates("0a9514be-0e61-4ffc-9d7b-8e151a126038");
UpdatePackage package = new UpdatePackage();
package.ProjectName = "we done testing";
package.Subject = "Deployment";
package.Body = "Environment:br549|Jimmy, toloose";
package.Updates.Add("VerticalID", "-1");
package.Updates.Add( "PhaseID", "0");
package.Updates.Add( "Environment", "Joe's Computer");
package.Updates.Add("Some Key","Some Value" );
dbService.RecordUpdatePackage(package);
var db = 1;
}
//AccessService dataAccess = new AccessService();
int actionOption = 1;
while (actionOption > 0)
{
Console.WriteLine("Select action to take:");
Console.WriteLine("--> 1) Clear all data");
Console.WriteLine("--> 2) Create sample data");
Console.WriteLine("--> 3) Delete Project by ID");
Console.WriteLine("--> 4) Delete Project by Name");
Console.WriteLine("--> 5) Exit application");
Console.WriteLine("??\n");
try
{
string input = Console.ReadLine();
actionOption = Convert.ToInt16(input);
}
catch (Exception)
{
Console.WriteLine("Integers only please");
Console.WriteLine("-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-\n");
continue;
}
bool success = false;
switch (actionOption)
{
case 1:
success = deleteAllData();
if (!success)
{
Console.WriteLine("Problem deleting data: " + errorMessage);
errorMessage = "";
}
break;
case 2:
success = writeSampleData();
if (!success)
{
Console.WriteLine("Problem writing sample data: " + errorMessage);
errorMessage = "";
}
break;
case 3:
Console.WriteLine("Enter ProjectID Guid");
string projectID = Console.ReadLine();
try
{
deleteProject(projectID, null);
}
catch (Exception e)
{
Console.WriteLine("Error deleting project, " + e.Message);
continue;
}
break;
case 4:
Console.WriteLine("Enter Project Name");
string projectName = Console.ReadLine();
try
{
deleteProject(null, projectName);
}
catch (Exception e)
{
Console.WriteLine("Error deleting project, " + e.Message);
continue;
}
break;
case 5:
return;
default:
return;
}
success = false;
}
}
public void UpdateProjectVerticalTest()
{
AccessService dbService = new AccessService();
//var projectUpdates = dbService.GetProjectUpdates("6a8a7e56-e9ac-4385-a8be-5be702c1f2e6");
UpdatePackage package = new UpdatePackage();
package.ProjectName = "Test Getting Project Updates";
package.Subject = "Deployment";
package.Body = "Environment:br549|Jimmy, toloose";
package.Updates.Add("verticalID", "3");
package.Updates.Add("Environment", "br549");
package.Updates.Add("Author", "Samantha");
package.Updates.Add("Manager", "Bocephus");
//__Adding this package should create a new Project and return the ProjectID as string
string stId = dbService.RecordUpdatePackage(package);
Guid projectID = Guid.Parse(stId);
// In theory there should be an easy way to check a project vertical, but there isn't
//now the actual test
dbService.UpdateProjectVertical(5, projectID);
List<ProjectUpdate> pjUpdates = dbService.GetProjectUpdates(stId);
Assert.IsTrue(pjUpdates[0].Project.VerticalID == 5);
dbService.UpdateProjectVertical(7, projectID);
List<ProjectUpdate> pjUpdates2 = dbService.GetProjectUpdates(stId);
Assert.IsTrue(pjUpdates2[0].Project.VerticalID == 7);
dbService.DeleteProject(projectID);
}
public void GetAllUpdatesFromEmailTest()
{
AccessService dbService = new AccessService();
UpdatePackage package = new UpdatePackage();
package.ProjectName = "Test Get All Updates from Email";
package.Subject = "Deployment";
package.Body = "Environment:br549|Jimmy, toloose";
package.Updates.Add("verticalID", "3");
package.Updates.Add("Environment", "br549");
package.Updates.Add("Author", "Samantha");
package.Updates.Add("Manager", "Bocephus");
//__Adding this package should create a new Project and return the ProjectID as string
string stId = dbService.RecordUpdatePackage(package);
Guid projectID = Guid.Parse(stId);
List<ProjectUpdate> pUpdate = dbService.GetProjectUpdates(stId);
Assert.AreEqual(dbService.GetAllUpdatesFromEmail(pUpdate[0].ProjectUpdateID).Count, 4);
dbService.DeleteProject(projectID);
}
public void ChangeProjectUpdatePhaseTest1()
{
AccessService dbService = new AccessService();
//var projectUpdates = dbService.GetProjectUpdates("6a8a7e56-e9ac-4385-a8be-5be702c1f2e6");
UpdatePackage package = new UpdatePackage();
package.ProjectName = "Test Getting Project Updates";
package.Subject = "Deployment";
package.Body = "Environment:br549|Jimmy, toloose";
package.Updates.Add("verticalID", "3");
package.Updates.Add("Environment", "br549");
package.Updates.Add("Author", "Samantha");
package.Updates.Add("Manager", "Bocephus");
//__Adding this package should create a new Project and return the ProjectID as string
string stId = dbService.RecordUpdatePackage(package);
Guid projectID = Guid.Parse(stId);
// Gotta convert this to a Project Update as opposed to a plain Update Project
List<ProjectUpdate> pjUpdates = dbService.GetProjectUpdates(stId);
pjUpdates[0].PhaseID = 4;
pjUpdates[0].Phase = "Build_and_Test"; // Don't think this needs to be done
dbService.ChangeProjectUpdatePhase(pjUpdates[0]);
List<ProjectUpdate> pjUpdateChanges = dbService.GetProjectUpdates(stId);
Assert.IsTrue(pjUpdateChanges[0].PhaseID == 4);
pjUpdateChanges[0].PhaseID = 5;
dbService.ChangeProjectUpdatePhase(pjUpdateChanges[0]);
List<ProjectUpdate> pjUpdateChangesMore = dbService.GetProjectUpdates(stId);
Assert.IsTrue(pjUpdateChangesMore[0].PhaseID == 5);
dbService.DeleteProject(projectID);
}
public void GetProjectUpdatesTest()
{
AccessService dbService = new AccessService();
//var projectUpdates = dbService.GetProjectUpdates("6a8a7e56-e9ac-4385-a8be-5be702c1f2e6");
UpdatePackage package = new UpdatePackage();
package.ProjectName = "Test Getting Project Updates";
package.Subject = "Deployment";
package.Body = "Environment:br549|Jimmy, toloose";
package.Updates.Add("verticalID", "3");
package.Updates.Add("Environment", "br549");
package.Updates.Add("Author", "Samantha");
package.Updates.Add("Manager", "Bocephus");
//__Adding this package should create a new Project and return the ProjectID as string
string stId = dbService.RecordUpdatePackage(package);
List<ProjectUpdate> list = dbService.GetProjectUpdates(stId);
Assert.AreEqual(list[0].StatusUpdates.Count, 4);
Guid projectID = Guid.Parse(stId);
dbService.DeleteProject(projectID);
}