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); */ } }