public void Get_ValidInput_ReturnPeople()
{
// Arrange
var personEntity = MockDataFactory.GetTestPerson();
// Act
var result = PeopleFactory.Get(personEntity).ToList();
// Assert
Assert.IsAssignableFrom <IEnumerable <Person> >(result);
Assert.NotNull(result);
Assert.Equal(result.Count(), personEntity.Addresses.Count());
Assert.Equal(result.First().FirstName, personEntity.FirstName);
Assert.Equal(result.First().LastName, personEntity.LastName);
Assert.Equal(result.First().Phone, personEntity.Phones?.FirstOrDefault().PhoneNumber);
Assert.Equal(result.First().AgeRange, personEntity.AgeRange);
foreach (var addressEntity in personEntity.Addresses)
{
var exists = result.Exists(x => x.Address1 == addressEntity.Address1 &&
x.Address2 == addressEntity.Address2 &&
x.City == addressEntity.City &&
x.State == addressEntity.State &&
x.Zip == addressEntity.Zip &&
x.Plus4 == addressEntity.Plus4 &&
x.Country == addressEntity.Country &&
x.Latitude == addressEntity.Latitude &&
x.Longitude == addressEntity.Longitude);
Assert.True(exists);
}
}
public void Add(PersonModel model)
{
var entity = PeopleFactory.Create(model);
_personRepository.Add(entity);
model.Id = entity.Id;
}
void Start()
{
Player = new Player(StateMachine);
PeopleFactory = new PeopleFactory(DataManager);
GestureFactory = new GestureFactory(Player, StateMachine);
ScoreController = new ScoreController(UIController);
GestureAdapter = new GestureAdapter(FingersScript);
InputController = new InputController(Camera, Player, GestureAdapter, StateMachine);
}
public HttpResponseMessage GetPersonById(int id)
{
var person = PeopleRepository.FindPeopleById(id);
if (person == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
return(Request.CreateResponse(HttpStatusCode.OK, new { person = PeopleFactory.Create(person) }));
}
/// <summary>
/// LoadContent will be called once per game and is the place to load
/// all of your content.
/// </summary>
protected override void LoadContent()
{
IsMouseVisible = true;
_pauseMenuTexture = Content.Load <Texture2D>("PauseTexture");
_pauseMenuRectangle = new Rectangle(0, 0, _pauseMenuTexture.Width, _pauseMenuTexture.Height);
_cleaner = new Cleaner()
{
Position = new Vector2(5, 2), VasteLocatie = new Vector2(5, 2)
};
_cleaner2 = new Cleaner()
{
Position = new Vector2(5, 5), VasteLocatie = new Vector2(5, 5)
};
// Create a new SpriteBatch, which can be used to draw textures.
spriteBatch = new SpriteBatch(GraphicsDevice);
_persons = new List <IPerson>();
_cleaners = new List <Cleaner>();
_hotel.Areas = new LayoutReader().GetAllObjects(@"Content\Hotel3.layout");
AreaFactory areaFactory = new AreaFactory();
_elevator = (Elevator)areaFactory.Create("Elevator");
_stairs = (Stairs)areaFactory.Create("Stairs");
_lobby = (Lobby)areaFactory.Create("Lobby");
_elevator.Dimension = new Vector2(1, _hotel.Areas.OrderByDescending(x => x.Dimension.Y + x.Position.Y).First().Dimension.Y + _hotel.Areas.OrderByDescending(x => x.Dimension.Y + x.Position.Y).First().Position.Y);
_stairs.Position = new Vector2(_hotel.Areas.OrderByDescending(x => x.Position.X + x.Dimension.X).First().Dimension.X + _hotel.Areas.OrderByDescending(x => x.Position.X + x.Dimension.X).First().Position.X, 0);
_stairs.Dimension = new Vector2(1, _hotel.Areas.OrderByDescending(x => x.Dimension.Y + x.Position.Y).First().Dimension.Y + _hotel.Areas.OrderByDescending(x => x.Dimension.Y + x.Position.Y).First().Position.Y);
_lobby.Dimension = new Vector2(_stairs.Position.X - 1, 1);
_hotel.Areas.Add(_elevator);
_hotel.Areas.Add(_stairs);
_hotel.Areas.Add(_lobby);
_persons.Add(_cleaner);
_persons.Add(_cleaner2);
_cleaners.Add(_cleaner);
_cleaners.Add(_cleaner2);
foreach (IArea area in _hotel.Areas)
{
area.LoadContent(Content);
}
_hotel.Load();
_hotel.AddToGraph(_simplePath);
PeopleFactory peopleFactory = new PeopleFactory();
// nog even uitzoeken waar dit het best kan
foreach (IPerson person in _persons)
{
person.LoadContent(Content);
}
_elevator.Attach(_cleaner);
_elevator.Attach(_cleaner2);
_menuForm = new MenuForm(_hotel, _cleaners, _customers, _persons, _stairs, _simplePath);
_menuForm.Show();
// TODO: use this.Content to load your game content here
}
public HttpResponseMessage GetPeople()
{
var people = PeopleRepository
.FindPeopleV2()
.Select(p => PeopleFactory.Create(p));
if (people == null)
{
return(Request.CreateResponse(HttpStatusCode.NoContent));
}
return(Request.CreateResponse(HttpStatusCode.OK, new { people = people }));
}
public void Create_NonexistingKey()
{
//arrange
PeopleFactory peopleFactory = new PeopleFactory();
Person undifinedPerson = new Customer();
Type expected = undifinedPerson.GetType();
IPerson actual;
//act
actual = peopleFactory.Create("RandomKeyNotInFact");
//assert
Assert.IsInstanceOfType(actual, expected);
}
public void Create_ExistingKey()
{
//arrange
PeopleFactory peopleFactory = new PeopleFactory();
Person person = new Customer();
Type expected = person.GetType();
peopleFactory.internalFactory.Add <Customer>("key");
IPerson actual;
//act
actual = peopleFactory.Create("key");
//assert
Assert.IsInstanceOfType(actual, expected);
}
/// <summary>
/// Gets the people.
/// </summary>
/// <param name="searchJobId">The search job identifier.</param>
/// <returns></returns>
public IEnumerable <Models.Domain.Person> GetPeople()
{
var peopleEntities = Repository.GetAll <Models.Entities.Person>(includeProperties: "Addresses, Phones, Associates");
var people = new List <Models.Domain.Person>();
foreach (var personEntity in peopleEntities)
{
var peopleConversion = PeopleFactory.Get(personEntity);
people.AddRange(peopleConversion);
}
var distinctPeople = people.Distinct().ToList();
return(distinctPeople);
}
public void Setup()
{
if (CurrentGameState == GameState.Setup)
{
Player = References.Player;
GestureFactory = References.GestureFactory;
PeopleFactory = References.PeopleFactory;
DataManager = References.DataManager;
ScoreController = References.ScoreController;
InputController = References.InputController;
InputController.GestureList = GestureFactory.createGestureList();
DataManager.Load();
CurrentGuest = PeopleFactory.createRandom(ScoreController.GetCombo());
ScoreController.PeopleList.Add(CurrentGuest);
AnimationController.SetGuest(CurrentGuest.Type);
CurrentGameState = GameState.ButtonClick;
}
}
public void Update(PersonModel model)
{
var entity = PeopleFactory.Create(model);
_personRepository.Update(entity);
}
public PersonModel Get(int id)
{
var entity = _personRepository.Get(id);
return(PeopleFactory.Create(entity));
}
static void Main(string[] args)
{
/*
* If we wanted to create a BabyGirl we can easly interchange the below code without worrying
* that it would break things since they both implement the same interface.
*/
var babyBoy = PeopleFactory.CreateBabyBoy();
babyBoy.Name = "Michael";
babyBoy.Age = 1;
var boy = PeopleFactory.CreateBoy();
boy.Name = "John";
boy.Age = 6;
var girl = PeopleFactory.CreateGirl();
girl.Name = "Nina";
girl.Age = 5;
var sportsBoy = PeopleFactory.CreateSportsBoy();
sportsBoy.Name = "Ben";
sportsBoy.Age = 9;
sportsBoy.FavouriteSports = "Soccer";
var sportsGirl = PeopleFactory.CreateSportGirl();
sportsGirl.Name = "Jill";
sportsGirl.Age = 7;
sportsGirl.FavouriteSports = "Netball";
var personList = new List <IPerson>
{
babyBoy,
boy,
girl,
sportsBoy,
sportsGirl
};
foreach (var person in personList)
{
if (!(person is IGreetablePerson) && person is IPerson ungreatablePerson)
{
Console.WriteLine($"{ungreatablePerson.Name} at age {ungreatablePerson.Age} cannot greet.");
}
if (person is IGreetablePerson greetablePerson)
{
greetablePerson.Greet();
}
if (person is IGreetableSportsPerson sportsPerson)
{
sportsPerson.SayFavouriteSports();
}
}
}
private async void Delete_Click(object sender, EventArgs e)
{
/*
* if (!backgroundWorker1.IsBusy)
* {
* backgroundWorker1.RunWorkerAsync();
* }
* else
* {
* label4.Text = "Processing, please wait";
* }*/
/*
* SaleForceConnect con = SaleForceConnect.getInstance(ConfigurationManager.AppSettings["UserName"], ConfigurationManager.AppSettings["Password"], ConfigurationManager.AppSettings["ServerURL"]);
*
* SforceService connection = con.getCon();
*/
/*
* String stringExcelPath = "CeciReportingTestLOG_deletion.txt";
* AccountFactory a = new AccountFactory(connection);
* a.loadAccount();
* a.deleteAccount(stringExcelPath, a.getAccount());*/
/*
* PrivateReportFactory prf = new PrivateReportFactory(connection);
* prf.loadPrivateReport();
* PublicReportFactory pr90 = new PublicReportFactory(connection);
* pr90.loadPublicReport(Convert.ToInt32(publicParams.Text)); // tread initialize on the Go click event
* PublicDashboardComponentFactory pdcf = new PublicDashboardComponentFactory(connection);
* pdcf.loadPublicDashboardComponents();
* PublicDashboardFactory pdf = new PublicDashboardFactory(connection);
* pdf.loadPublicDashboard();
* PrivateDashboardComponentFactory prdcf = new PrivateDashboardComponentFactory(connection);
* prdcf.loadPrivateDashboardComponent();
* PrivateDashboardFactory prdf = new PrivateDashboardFactory(connection);
* prdf.loadPrivateDashboard();
* PeopleFactory p = new PeopleFactory(connection);
* p.loadPeople(); // tread initialize on the Go click event // with backgroundworker
* UserFactory u = new UserFactory(connection);
* u.loadUser(); // tread initialize on the Go click event// with backgroundworker
*/
label4.Text = "Processing, please wait";
progressBar1.Value = 0;
dgv.Rows.Clear();
dgv.Refresh();
SaleForceConnect con = SaleForceConnect.getInstance(ConfigurationManager.AppSettings["UserName"], ConfigurationManager.AppSettings["Password"], ConfigurationManager.AppSettings["ServerURLsoap"]);
SforceService connection = con.getCon();
PrivateReportFactory prf = new PrivateReportFactory(connection);
await Task.Factory.StartNew(() => prf.loadPrivateReport()).ContinueWith(t => progressBar1.Value += 5, TaskScheduler.FromCurrentSynchronizationContext());
PublicReportFactory pr = new PublicReportFactory(connection);
await Task.Factory.StartNew(() => pr.loadPublicReport(Convert.ToInt32(publicParams.Text))).ContinueWith(t => progressBar1.Value += 5, TaskScheduler.FromCurrentSynchronizationContext());
PeopleFactory p = new PeopleFactory(connection);
await Task.Factory.StartNew(() => p.loadPeopleAsync()).ContinueWith(t => progressBar1.Value += 5, TaskScheduler.FromCurrentSynchronizationContext());
UserFactory u = new UserFactory(connection);
await Task.Factory.StartNew(() => u.loadUser()).ContinueWith(t => progressBar1.Value += 5, TaskScheduler.FromCurrentSynchronizationContext());
PublicDashboardComponentFactory pdcf = new PublicDashboardComponentFactory(connection);
await Task.Factory.StartNew(() => pdcf.loadPublicDashboardComponents()).ContinueWith(t => progressBar1.Value += 10, TaskScheduler.FromCurrentSynchronizationContext());
//pdcf.loadPublicDashboardComponents();
PublicDashboardFactory pdf = new PublicDashboardFactory(connection);
await Task.Factory.StartNew(() => pdf.loadPublicDashboard()).ContinueWith(t => progressBar1.Value += 10, TaskScheduler.FromCurrentSynchronizationContext());
//pdf.loadPublicDashboard();
PrivateDashboardComponentFactory prdcf = new PrivateDashboardComponentFactory(connection);
await Task.Factory.StartNew(() => prdcf.loadPrivateDashboardComponent()).ContinueWith(t => progressBar1.Value += 10, TaskScheduler.FromCurrentSynchronizationContext());
prdcf.loadPrivateDashboardComponent();
PrivateDashboardFactory prdf = new PrivateDashboardFactory(connection);
await Task.Factory.StartNew(() => prdf.loadPrivateDashboard()).ContinueWith(t => progressBar1.Value += 50, TaskScheduler.FromCurrentSynchronizationContext());
//prdf.loadPrivateDashboard();
String fileName;
if (listQuery.SelectedItem.ToString().Equals("1a - Inactive Employees (Retired, withdrawn)"))
{
//clear columns
dgv.Columns.Clear();
//clear rows
DataGridViewHandler dgv1 = new DataGridViewHandler();
ListasSfCollectionObjects sfQuery1a = new ListasSfCollectionObjects();
fileName = "Query 1a";
dgv1.dgvQuery1a(sfQuery1a.query1a(prf.getPrivateReport(), p.getPeople(), u.getUser(), IgnoreIds), dgv, label4);
dgv1.excelFile(fileName, dgv);
//Meesage box
DialogResult result = MessageBox.Show("This is going to be delete, are you agree?", "Deletion alert", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
/*
* String stringExcelPath1 = "privateDashboardIDQuery1aLOG_Deletion.txt";
* prdf.deletePrivateDashboard(stringExcelPath1, sfQuery1a.queryID1aDeletePrivateDashboard(prf.getPrivateReport(), prdcf.getPrivateDashboardComponent(),
* prdf.GetPrivateDashboards(), p.getPeople(), u.getUser()));
*
* String stringExcelPath2 = "publicDashboardIDQuery1aLOG_Deletion.txt";
* pdf.deletePublicDashboard(stringExcelPath2, sfQuery1a.queryID1aDeletePublicDashboard(prf.getPrivateReport(), pdf.GetPublicDashboards(),
* pdcf.GetPublicDashboardComponent(), p.getPeople(), u.getUser()));*/
String stringExcelPath3 = "PrivateReportQuery1aLOG_deletion.txt";
await Task.Run(() => prf.deletePrivateReports(stringExcelPath3, sfQuery1a.queryID1aDeletePrivateReports(prf.getPrivateReport(), p.getPeople(), u.getUser())));
}
else
{
MessageBox.Show("The deletion hasn't been done", "Declined Deletion", MessageBoxButtons.OK);
}
}
if (listQuery.SelectedItem.ToString().Equals("1b - Inactive Employees (but not Retired, Withdrawn)"))
{
//clear columns
dgv.Columns.Clear();
//clear rows
dgv.Rows.Clear();
DataGridViewHandler dgv2 = new DataGridViewHandler();
ListasSfCollectionObjects sfQuery1b = new ListasSfCollectionObjects();
fileName = "Query 1b";
dgv2.dgvQuery1b(sfQuery1b.query1b_deletion(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds), dgv, label4);
dgv2.excelFile(fileName, dgv);
//Meesage box
DialogResult result = MessageBox.Show("This is going to be delete, are you agree?", "Deletion alert", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
/*
* String stringExcelPath1 = "privateDashboardIDQuery1bLOG_Deletion.txt";
* prdf.deletePrivateDashboard(stringExcelPath1, sfQuery1b.queryID1bDeletePrivateDashboard(prf.getPrivateReport(), prdcf.getPrivateDashboardComponent(),
* prdf.GetPrivateDashboards(), p.getPeople(), u.getUser(),Convert.ToInt32(privateParams.Text)));
*
* String stringExcelPath2 = "publicDashboardIDQuery1bLOG_Deletion.txt";
* pdf.deletePublicDashboard(stringExcelPath2, sfQuery1b.queryID1bDeletePublicDashboard(prf.getPrivateReport(), pdf.GetPublicDashboards(),
* pdcf.GetPublicDashboardComponent(), p.getPeople(), u.getUser(),Convert.ToInt32(privateParams.Text)));
*
*/
String stringExcelPath3 = "PrivateReportQuery1bLOG_deletion.txt";
await Task.Run(() => prf.deletePrivateReports(stringExcelPath3, sfQuery1b.queryID1bDeletePrivateReports(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds)));
}
else
{
MessageBox.Show("The deletion hasn't been done", "Declined Deletion", MessageBoxButtons.OK);
}
}
if (listQuery.SelectedItem.ToString().Equals(" 2 - Inactive MMS users - last login is >180 days"))
{
//clear columns
dgv.Columns.Clear();
//clear rows
dgv.Rows.Clear();
DataGridViewHandler dgv3 = new DataGridViewHandler();
ListasSfCollectionObjects sfQuery2 = new ListasSfCollectionObjects();
fileName = "Query 2";
dgv3.dgvQuery2(sfQuery2.query2_delete(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds), dgv, label4);
dgv3.excelFile(fileName, dgv);
//Meesage box
DialogResult result = MessageBox.Show("This is going to be delete, are you agree?", "Deletion alert", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
String stringExcelPath1 = "privateDashboardIDQuery2LOG_Deletion.txt";
await Task.Run(() => prdf.deletePrivateDashboard(stringExcelPath1, sfQuery2.queryID2DeletePrivateDashboard(prf.getPrivateReport(), prdcf.getPrivateDashboardComponent(),
prdf.GetPrivateDashboards(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds)));
String stringExcelPath2 = "publicDashboardIDQuery2LOG_Deletion.txt";
await Task.Run(() => pdf.deletePublicDashboard(stringExcelPath2, sfQuery2.queryID2DeletePublicDashboard(prf.getPrivateReport(), pdf.GetPublicDashboards(),
pdcf.GetPublicDashboardComponent(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds)));
String stringExcelPath3 = "PrivateReportIDQuery2LOG_deletion.txt";
await Task.Run(() => prf.deletePrivateReports(stringExcelPath3, sfQuery2.queryID2DeletePrivateReports(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds)));
}
else
{
MessageBox.Show("The deletion hasn't been done", "Declined Deletion", MessageBoxButtons.OK);
}
}
if (listQuery.SelectedItem.ToString().Equals(" 3 - Active MMS Users - Reports not run in more than 180 days"))
{
//clear columns
dgv.Columns.Clear();
//clear rows
dgv.Rows.Clear();
DataGridViewHandler dgv4 = new DataGridViewHandler();
ListasSfCollectionObjects sfQuery3 = new ListasSfCollectionObjects();
fileName = "Query 3";
dgv4.dgvQuery3(sfQuery3.query3_deletion(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds), dgv, label4);
dgv4.excelFile(fileName, dgv);
//Meesage box
DialogResult result = MessageBox.Show("This is going to be delete, are you agree?", "Deletion alert", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
String stringExcelPath3 = "PrivateReportIDQuery3LOG_deletion.txt";
await Task.Run(() => prf.deletePrivateReports(stringExcelPath3, sfQuery3.queryID3DeletePrivateReports(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds)));
}
else
{
MessageBox.Show("The deletion hasn't been done", "Declined Deletion", MessageBoxButtons.OK);
}
}
if (listQuery.SelectedItem.ToString().Equals(" 4 - Public Reports not run in more than 90 Days"))
{
//clear columns
dgv.Columns.Clear();
//clear rows
dgv.Rows.Clear();
DataGridViewHandler dgv5 = new DataGridViewHandler();
ListasSfCollectionObjects sfQuery4 = new ListasSfCollectionObjects();
fileName = "Query 4";
dgv5.dgvQuery4(sfQuery4.query4(pr.getPublicReport(), u.getUser(), IgnoreIds), dgv, label4);
dgv5.excelFile(fileName, dgv);
//Meesage box
DialogResult result = MessageBox.Show("This is going to be delete, are you agree?", "Deletion alert", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
String stringExcelPath3 = "PublicReportIDQuery4LOG_deletion.txt";
await Task.Run(() => pr.deletePublicReport(stringExcelPath3, sfQuery4.queryID4DeletePublicReports(pr.getPublicReport(), u.getUser(), IgnoreIds)));
}
else
{
MessageBox.Show("The deletion hasn't been done", "Declined Deletion", MessageBoxButtons.OK);
}
}
if (listQuery.SelectedItem.ToString().Equals(" 5 - Public and private Dashboard"))
{
/*
* //clear columns
* dgv.Columns.Clear();
* //clear rows
* dgv.Rows.Clear();
*
*
*
* DataGridViewHandler dgv6 = new DataGridViewHandler();
* ListasSfCollectionObjects sfQuery5 = new ListasSfCollectionObjects();
* fileName = "Query 5";
*
* dgv6.dgvQuery5(sfQuery5.query5_deletion(pdcf.GetPublicDashboardComponent(),
* pr.getPublicReport(), pdf.GetPublicDashboards(), prdcf.getPrivateDashboardComponent(), prdf.GetPrivateDashboards(),
* prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), Convert.ToInt32(publicParams.Text)), dgv, label4);
* dgv6.excelFile(fileName, dgv);
* //Meesage box
*
* DialogResult result = MessageBox.Show("This is going to be delete, are you agree?", "Deletion alert", MessageBoxButtons.YesNo);
* if (result == DialogResult.Yes)
* {
* String stringExcelPath1 = "privateDashboardIDQuery5LOG_Deletion.txt";
* prdf.deletePrivateDashboard(stringExcelPath1, sfQuery5.queryID5DeletePrivateDashboard(prf.getPrivateReport(), prdcf.getPrivateDashboardComponent(),
* prdf.GetPrivateDashboards(), pr.getPublicReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), Convert.ToInt32(publicParams.Text)));
*
* String stringExcelPath2 = "publicDashboardIDQuery5LOG_Deletion.txt";
* pdf.deletePublicDashboard(stringExcelPath2, sfQuery5.queryID5DeletePublicDashboard(u.getUser(), p.getPeople(), pdcf.GetPublicDashboardComponent(), pr.getPublicReport(),
* pdf.GetPublicDashboards(), prf.getPrivateReport(), Convert.ToInt32(privateParams.Text), Convert.ToInt32(publicParams.Text)));
*
*
* }
* else
* {
* MessageBox.Show("The deletion hasn't been done", "Declined Deletion", MessageBoxButtons.OK);
*
* }
*/
MessageBox.Show("This functionality is not implemented", "Declined Deletion", MessageBoxButtons.OK);
}
}
private async void bLogin_Click(object sender, EventArgs e)
{
label4.Text = "Processing, please wait";
progressBar1.Value = 0;
progressBar1.Visible = true;
dgv.Rows.Clear();
dgv.Refresh();
SaleForceConnect con = SaleForceConnect.getInstance(ConfigurationManager.AppSettings["UserName"], ConfigurationManager.AppSettings["Password"], ConfigurationManager.AppSettings["ServerURLsoap"]);
SforceService connection = con.getCon();
PrivateReportFactory prf = new PrivateReportFactory(connection);
await Task.Factory.StartNew(() => prf.loadPrivateReport()).ContinueWith(t => progressBar1.Value += 25, TaskScheduler.FromCurrentSynchronizationContext());
PublicReportFactory pr = new PublicReportFactory(connection);
await Task.Factory.StartNew(() => pr.loadPublicReport(Convert.ToInt32(publicParams.Text))).ContinueWith(t => progressBar1.Value += 25, TaskScheduler.FromCurrentSynchronizationContext());
PeopleFactory p = new PeopleFactory(connection);
await Task.Factory.StartNew(() => p.loadPeopleAsync()).ContinueWith(t => progressBar1.Value += 25, TaskScheduler.FromCurrentSynchronizationContext());
UserFactory u = new UserFactory(connection);
await Task.Factory.StartNew(() => u.loadUser()).ContinueWith(t => progressBar1.Value += 25, TaskScheduler.FromCurrentSynchronizationContext());
/* if (backgroundWorker1.IsBusy != true)
* {
*
* bgw.RunWorkerAsync();*/
// stopwatchLoadPrivateReport.Start();
// PrivateReportFactory prf = new PrivateReportFactory(connection);
// prf.loadPrivateReport(/*bgw*/);
// stopwatchLoadPrivateReport.Stop();
//PublicReportFactory pr = new PublicReportFactory(connection);
// stopwatchLoadPublicReport.Start();
//pr.loadPublicReport(Convert.ToInt32(publicParams.Text)/*, bgw*/);
//stopwatchLoadPublicReport.Stop();
// PeopleFactory p = new PeopleFactory(connection);
// stopwatchLoadPeople.Start();
// p.loadPeople(/*bgw*/);
// stopwatchLoadPeople.Stop();
//UserFactory u = new UserFactory(connection);
//stopwatchLoadUser.Start();
//u.loadUser(/*bgw*/);
// stopwatchLoadUser.Stop();
// }
/*
* Console.WriteLine("Time elapsed in private report loading: {0:hh\\:mm\\:ss}", stopwatchLoadPrivateReport.Elapsed);
* Console.WriteLine("Time elapsed in public report loading: {0:hh\\:mm\\:ss}", stopwatchLoadPublicReport.Elapsed);
* Console.WriteLine("Time elapsed in User loading: {0:hh\\:mm\\:ss}", stopwatchLoadUser.Elapsed);
* Console.WriteLine("Time elapsed in people loading: {0:hh\\:mm\\:ss}", stopwatchLoadPeople.Elapsed);
*/
//authenticate();
if (listQuery.SelectedItem.ToString().Equals("1a - Inactive Employees (Retired, withdrawn)"))
{
//clear columns
dgv.Columns.Clear();
//clear rows
DataGridViewHandler dgv1 = new DataGridViewHandler();
ListasSfCollectionObjects sfQuery1a = new ListasSfCollectionObjects();
//stopwatchQuery1a.Start();
dgv1.dgvQuery1a(sfQuery1a.query1a(prf.getPrivateReport(), p.getPeople(), u.getUser(), IgnoreIds), dgv, label4);
// stopwatchQuery1a.Stop();
//Console.WriteLine("Time elapsed in execution query1a: {0:hh\\:mm\\:ss}", stopwatchQuery1a.Elapsed);
}
if (listQuery.SelectedItem.ToString().Equals("1b - Inactive Employees (but not Retired, Withdrawn)"))
{
//clear columns
dgv.Columns.Clear();
//clear rows
dgv.Rows.Clear();
DataGridViewHandler dgv2 = new DataGridViewHandler();
ListasSfCollectionObjects sfQuery1b = new ListasSfCollectionObjects();
//stopwatchQuery1b.Start();
dgv2.dgvQuery1b(sfQuery1b.query1b(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds), dgv, label4);
//stopwatchQuery1b.Stop();
// Console.WriteLine("Time elapsed in execution query1b: {0:hh\\:mm\\:ss}", stopwatchQuery1b.Elapsed);
}
if (listQuery.SelectedItem.ToString().Equals(" 2 - Inactive MMS users - last login is >180 days"))
{
//clear columns
dgv.Columns.Clear();
//clear rows
dgv.Rows.Clear();
DataGridViewHandler dgv3 = new DataGridViewHandler();
ListasSfCollectionObjects sfQuery2 = new ListasSfCollectionObjects();
//stopwatchQuery2.Start();
dgv3.dgvQuery2(sfQuery2.query2(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds), dgv, label4);
// stopwatchQuery2.Stop();
//Console.WriteLine("Time elapsed in execution query2: {0:hh\\:mm\\:ss}", stopwatchQuery2.Elapsed);
}
if (listQuery.SelectedItem.ToString().Equals(" 3 - Active MMS Users - Reports not run in more than 180 days"))
{
//clear columns
dgv.Columns.Clear();
//clear rows
dgv.Rows.Clear();
DataGridViewHandler dgv4 = new DataGridViewHandler();
ListasSfCollectionObjects sfQuery3 = new ListasSfCollectionObjects();
//stopwatchQuery3.Start();
dgv4.dgvQuery3(sfQuery3.query3(prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds), dgv, label4);
//stopwatchQuery3.Stop();
//Console.WriteLine("Time elapsed in execution query3: {0:hh\\:mm\\:ss}", stopwatchQuery3.Elapsed);
}
if (listQuery.SelectedItem.ToString().Equals(" 4 - Public Reports not run in more than 90 Days"))
{//clear columns
dgv.Columns.Clear();
//clear rows
dgv.Rows.Clear();
DataGridViewHandler dgv5 = new DataGridViewHandler();
ListasSfCollectionObjects sfQuery4 = new ListasSfCollectionObjects();
//stopwatchQuery4.Start();
dgv5.dgvQuery4(sfQuery4.query4(pr.getPublicReport(), u.getUser(), IgnoreIds), dgv, label4);
//stopwatchQuery3.Stop();
//Console.WriteLine("Time elapsed in execution query4: {0:hh\\:mm\\:ss}", stopwatchQuery4.Elapsed);
}
if (listQuery.SelectedItem.ToString().Equals(" 5 - Public and private Dashboard"))
{
//clear columns
dgv.Columns.Clear();
//clear rows
dgv.Rows.Clear();
DataGridViewHandler dgv6 = new DataGridViewHandler();
ListasSfCollectionObjects sfQuery5 = new ListasSfCollectionObjects();
PublicDashboardComponentFactory pdcf = new PublicDashboardComponentFactory(connection);
//stopwatchLoadPrivateDashboardComponent.Start();
pdcf.loadPublicDashboardComponents();
//stopwatchLoadPublicDashboardComponent.Stop();
PublicDashboardFactory pdf = new PublicDashboardFactory(connection);
//stopwatchLoadPublicDashboard.Start();
pdf.loadPublicDashboard();
//stopwatchLoadPublicDashboard.Stop();
PrivateDashboardComponentFactory prdcf = new PrivateDashboardComponentFactory(connection);
//stopwatchLoadPrivateDashboardComponent.Start();
prdcf.loadPrivateDashboardComponent();
// stopwatchLoadPrivateDashboardComponent.Stop();
PrivateDashboardFactory prdf = new PrivateDashboardFactory(connection);
//stopwatchLoadPrivateDashboard.Start();
prdf.loadPrivateDashboard();
//stopwatchLoadPrivateDashboard.Stop();
//stopwatchQuery5.Start();
dgv6.dgvQuery5(sfQuery5.query5(u.getUser(), pdcf.GetPublicDashboardComponent(),
pr.getPublicReport(), pdf.GetPublicDashboards(), prdcf.getPrivateDashboardComponent(), prdf.GetPrivateDashboards(),
prf.getPrivateReport(), p.getPeople(), u.getUser(), Convert.ToInt32(privateParams.Text), IgnoreIds), dgv, label4);
//stopwatchQuery5.Stop();
// Write hours, minutes and seconds.
/*
* Console.WriteLine("Time elapsed in public dashboard component: {0:hh\\:mm\\:ss}", stopwatchLoadPublicDashboardComponent.Elapsed);
* Console.WriteLine("Time elapsed in private dashboard component: {0:hh\\:mm\\:ss}", stopwatchLoadPrivateDashboardComponent.Elapsed);
* Console.WriteLine("Time elapsed in public dashboard: {0:hh\\:mm\\:ss}", stopwatchLoadPublicDashboard.Elapsed);
* Console.WriteLine("Time elapsed in public dashboard: {0:hh\\:mm\\:ss}", stopwatchLoadPrivateDashboard.Elapsed);
* Console.WriteLine("Time elapsed in public dashboard: {0:hh\\:mm\\:ss}", stopwatchQuery5.Elapsed);
*/
}
}
