public ActionResult LeagueGroups(int?fedSeason, string season, FormCollection collection) { try { int fedId = 0; if (fedSeason != null) { fedId = Convert.ToInt32(fedSeason); } else { season = collection[0].Split(',')[0]; fedId = Convert.ToInt32(collection[1]); } List <string> group = new List <string>(); List <List <Score> > score = new List <List <Score> >(); List <List <Standings> > standingsGroups = new ServiceDatabase().CreateModelStandingsGroups(fedId, ref score, season, ref group); ViewBag.Score = score; ViewBag.Group = group; return(View("LeagueGroups", standingsGroups.ToList())); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult LeagueGroups(string sport, string fed, string tour, int?fedSeason) { try { if (fedSeason == null) { if (sport == null && fed == null && tour == null) { sport = "Football"; fed = "UEFA"; tour = "League"; } fedSeason = new ServiceDatabase().Find(sport, fed, tour); } List <string> group = new List <string>(); List <List <Score> > score = new List <List <Score> >(); List <List <Standings> > standingsGroups = new ServiceDatabase().CreateModelStandingsGroups(Convert.ToInt32(fedSeason), ref score, null, ref group); ViewBag.Score = score; ViewBag.Group = group; return(View("LeagueGroups", standingsGroups.ToList())); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult Result(FormCollection collection) { try { string season = collection[0]; int tour = Convert.ToInt32(collection[1]); int fedSeason = Convert.ToInt32(collection[2]); int countTour = 0; List <Score> result = new ServiceDatabase().Result(ref countTour, fedSeason, season, tour); string[] array = new string[countTour]; for (int i = 1; i <= countTour; i++) { array[i - 1] = Convert.ToString(i); } ViewData["myList"] = new SelectList(array.Select(x => new { value = x, text = x }), "value", "text", tour); return(View(result)); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult ProgressAway(int?fedSeason) { try { List <Progress> progresses = new ServiceDatabase().ProgressesAway(Convert.ToInt32(fedSeason)); return(View("Progress", progresses)); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult Team(int?fedSeason, int?TeamId) { try { ShowTeam team = new ServiceDatabase().CreateModelsShowTeam(Convert.ToInt32(TeamId), Convert.ToInt32(fedSeason), null); return(View(team)); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult Search(string edit) { try { List <List <List <string> > > search = new ServiceDatabase().Search(edit); return(View("Search", search)); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult Winners(int?fedSeason) { try { List <Winner> Winners = new ServiceDatabase().Winners(Convert.ToInt32(fedSeason)); return(View(Winners)); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult StandingsAway(int fedSeason) { try { List <Standings> standings = new ServiceDatabase().CreateModelStandingsAway(fedSeason); return(View("Standings", standings.ToList())); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult Standings(string sport, string fed, string tour, int?fedSeason) { try { List <Standings> standings = new ServiceDatabase().CreateModelStandings(sport, fed, tour, fedSeason); List <Standings> SortedList = standings.OrderByDescending(o => o.Point).ToList(); return(View(SortedList.ToList())); } catch (Exception e) { ViewBag.Error = myException.Message + " " + e.Message; return(View("Error")); } }
public ActionResult Scorers(int?fedSeason, FormCollection collection) { try { fedSeason = Convert.ToInt32(collection[1]); string season = collection[0]; List <Scorer> scorers = new ServiceDatabase().Scorers(fedSeason, season); return(View(scorers)); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult Team(FormCollection collection) { try { int TeamId = Convert.ToInt32(collection[2]); int fedSeason = Convert.ToInt32(collection[1]); string season = collection[0]; ShowTeam team = new ServiceDatabase().CreateModelsShowTeam(TeamId, fedSeason, season); return(View(team)); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult Player(FormCollection collection) { try { int PlayerId = Convert.ToInt32(collection[2]); int fedSeason = Convert.ToInt32(collection[1]); string season = collection[0]; ShowPlayer player = new ServiceDatabase().ShowPlayer(fedSeason, PlayerId, season); return(View(player)); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult Standings(FormCollection collection) { try { int fedSeason = Convert.ToInt32(collection[1]); string season = collection[0]; List <Standings> standings = new ServiceDatabase().CreateModelStandings(null, null, season, fedSeason); List <Standings> SortedList = standings.OrderByDescending(o => o.Point).ToList(); return(View(SortedList.ToList())); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult Match(int?MatchId) { try { ShowMatch Match = new ShowMatch(); if (MatchId != null) { Match = new ServiceDatabase().ShowMatch(Convert.ToInt32(MatchId)); } return(View(Match)); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult Player(int?fedSeason, int?PlayerId) { try { ShowPlayer player = new ShowPlayer(); if (fedSeason != null && PlayerId != null) { player = new ServiceDatabase().ShowPlayer(Convert.ToInt32(fedSeason), Convert.ToInt32(PlayerId), null); } return(View(player)); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult ArchScorers(int?fedSeason) { try { List <Scorer> scorers = new List <Scorer>(); if (fedSeason == null) { scorers = new ServiceDatabase().ArchScorers(10); } else { scorers = new ServiceDatabase().ArchScorers(Convert.ToInt32(fedSeason)); } return(View(scorers)); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public ActionResult Scorers(int?fedSeason) { try { string season = null; if (fedSeason == null) { if (Request.Cookies["Id"] != null) { fedSeason = Convert.ToInt32(Request.Cookies["Id"].Value); Response.Cookies["Id"].Expires = DateTime.Now.AddDays(-1); } } List <Scorer> scorers = new ServiceDatabase().Scorers(fedSeason, season); return(View(scorers)); } catch (Exception e) { ViewBag.Error = e.Message; return(View("Error")); } }
public void Existing_Database_Test() { ServiceDatabase sBase = new ServiceDatabase(); Assert.AreEqual("1110000\n1210000\n1310000\n1410000\n1610000\n1510000\n1810000\n", sBase.printServices(ServiceTypes.Donate)); Assert.AreEqual("2110000\n", sBase.printServices(ServiceTypes.Drive)); Assert.AreEqual("3110000\n3210000\n3310000\n", sBase.printServices(ServiceTypes.Educate)); Assert.AreEqual("4110000\n", sBase.printServices(ServiceTypes.Request)); Assert.AreEqual("1110000\n", sBase.printServices(ServiceTypes.Donate, DonationTypes.Toys)); Assert.AreEqual("1210000\n", sBase.printServices(ServiceTypes.Donate, DonationTypes.Clothes)); Assert.AreEqual("1310000\n", sBase.printServices(ServiceTypes.Donate, DonationTypes.Tech)); Assert.AreEqual("1410000\n", sBase.printServices(ServiceTypes.Donate, DonationTypes.FirstAid)); Assert.AreEqual("1510000\n", sBase.printServices(ServiceTypes.Donate, DonationTypes.Hygene)); Assert.AreEqual("1610000\n", sBase.printServices(ServiceTypes.Donate, DonationTypes.Food)); Assert.AreEqual("1810000\n", sBase.printServices(ServiceTypes.Donate, DonationTypes.Other)); Assert.AreEqual("2110000\n", sBase.printServices(ServiceTypes.Drive, DonationTypes.Goods)); Assert.AreEqual("3110000\n", sBase.printServices(ServiceTypes.Educate, DonationTypes.Math)); Assert.AreEqual("3210000\n", sBase.printServices(ServiceTypes.Educate, DonationTypes.Reading)); Assert.AreEqual("3310000\n", sBase.printServices(ServiceTypes.Educate, DonationTypes.Writing)); Assert.AreEqual("4110000\n", sBase.printServices(ServiceTypes.Request, DonationTypes.Donation)); Service toy = sBase.retrieveService("1110000"); Assert.AreEqual(toy, sBase.retrieveService("1110000")); Service clothes = sBase.retrieveService("1210000"); Assert.AreEqual(clothes, sBase.retrieveService("1210000")); Service tech = sBase.retrieveService("1310000"); Assert.AreEqual(tech, sBase.retrieveService("1310000")); Service faid = sBase.retrieveService("1410000"); Assert.AreEqual(faid, sBase.retrieveService("1410000")); Service hygiene = sBase.retrieveService("1510000"); Assert.AreEqual(hygiene, sBase.retrieveService("1510000")); Service food = sBase.retrieveService("1610000"); Assert.AreEqual(food, sBase.retrieveService("1610000")); Service other = sBase.retrieveService("1810000"); Assert.AreEqual(other, sBase.retrieveService("1810000")); Service drive = sBase.retrieveService("2110000"); Assert.AreEqual(drive, sBase.retrieveService("2110000")); Service math = sBase.retrieveService("3110000"); Assert.AreEqual(math, sBase.retrieveService("3110000")); Service read = sBase.retrieveService("3210000"); Assert.AreEqual(read, sBase.retrieveService("3210000")); Service write = sBase.retrieveService("3310000"); Assert.AreEqual(write, sBase.retrieveService("3310000")); Service request = sBase.retrieveService("4110000"); Assert.AreEqual(request, sBase.retrieveService("4110000")); string path = @"C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\CommonExtensions\Microsoft\TestWindow"; File.Delete(Path.Combine(path, "Toy_Dictionary.txt")); File.Delete(Path.Combine(path, "Clothes_Dictionary.txt")); File.Delete(Path.Combine(path, "Tech_Dictionary.txt")); File.Delete(Path.Combine(path, "FirstAid_Dictionary.txt")); File.Delete(Path.Combine(path, "Hygene_Dictionary.txt")); File.Delete(Path.Combine(path, "Food_Dictionary.txt")); File.Delete(Path.Combine(path, "Other_Dictionary.txt")); File.Delete(Path.Combine(path, "Goods_Dictionary.txt")); File.Delete(Path.Combine(path, "Math_Dictionary.txt")); File.Delete(Path.Combine(path, "Reading_Dictionary.txt")); File.Delete(Path.Combine(path, "Writing_Dictionary.txt")); File.Delete(Path.Combine(path, "Donation_Dictionary.txt")); File.Delete(Path.Combine(path, "serial_list.txt")); File.Delete(Path.Combine(path, "userlist.txt")); }
public ActionResult Stub(string stub) { List <string> list = new ServiceDatabase().Stub(stub); return(View(list)); }
public void Service_Database_Test() { ServiceDatabase sBase = new ServiceDatabase(); UserDatabase uBase = new UserDatabase();; User testUser = new User("Tester", "Password", "*****@*****.**", "123 Test St.", null, "Tacoma", "WA", "98422"); uBase.addUser(testUser); uBase.deleteUser(testUser.getEmail()); Service toy = new Service("Tester", "*****@*****.**"); Service clothes = new Service("Tester", "*****@*****.**"); Service faid = new Service("Tester", "*****@*****.**"); Service hygiene = new Service("Tester", "*****@*****.**"); Service tech = new Service("Tester", "*****@*****.**"); Service food = new Service("Tester", "*****@*****.**"); Service other = new Service("Tester", "*****@*****.**"); Service drive = new Service("Tester", "*****@*****.**"); Service math = new Service("Tester", "*****@*****.**"); Service read = new Service("Tester", "*****@*****.**"); Service write = new Service("Tester", "*****@*****.**"); Service request = new Service("Tester", "*****@*****.**"); sBase.createService(ServiceTypes.Donate, DonationTypes.Toys, testUser, toy); sBase.createService(ServiceTypes.Donate, DonationTypes.Clothes, testUser, clothes); sBase.createService(ServiceTypes.Donate, DonationTypes.Tech, testUser, tech); sBase.createService(ServiceTypes.Donate, DonationTypes.FirstAid, testUser, faid); sBase.createService(ServiceTypes.Donate, DonationTypes.Food, testUser, food); sBase.createService(ServiceTypes.Donate, DonationTypes.Hygene, testUser, hygiene); sBase.createService(ServiceTypes.Donate, DonationTypes.Other, testUser, other); sBase.createService(ServiceTypes.Drive, DonationTypes.Goods, testUser, drive); sBase.createService(ServiceTypes.Educate, DonationTypes.Math, testUser, math); sBase.createService(ServiceTypes.Educate, DonationTypes.Reading, testUser, read); sBase.createService(ServiceTypes.Educate, DonationTypes.Writing, testUser, write); sBase.createService(ServiceTypes.Request, DonationTypes.Tools, testUser, request); Assert.AreEqual("1110000\n1210000\n1310000\n1410000\n1610000\n1510000\n1810000\n", sBase.printServices(ServiceTypes.Donate)); Assert.AreEqual("2110000\n", sBase.printServices(ServiceTypes.Drive)); System.Console.WriteLine(sBase.retrieveService("3210000")); Assert.AreEqual("3110000\n3210000\n3310000\n", sBase.printServices(ServiceTypes.Educate)); Assert.AreEqual("4110000\n", sBase.printServices(ServiceTypes.Request)); Assert.AreEqual("1110000\n", sBase.printServices(ServiceTypes.Donate, DonationTypes.Toys)); Assert.AreEqual("1210000\n", sBase.printServices(ServiceTypes.Donate, DonationTypes.Clothes)); Assert.AreEqual("1310000\n", sBase.printServices(ServiceTypes.Donate, DonationTypes.Tech)); Assert.AreEqual("1410000\n", sBase.printServices(ServiceTypes.Donate, DonationTypes.FirstAid)); Assert.AreEqual("1510000\n", sBase.printServices(ServiceTypes.Donate, DonationTypes.Hygene)); Assert.AreEqual("1610000\n", sBase.printServices(ServiceTypes.Donate, DonationTypes.Food)); Assert.AreEqual("1810000\n", sBase.printServices(ServiceTypes.Donate, DonationTypes.Other)); Assert.AreEqual("2110000\n", sBase.printServices(ServiceTypes.Drive, DonationTypes.Goods)); Assert.AreEqual("3110000\n", sBase.printServices(ServiceTypes.Educate, DonationTypes.Math)); Assert.AreEqual("3210000\n", sBase.printServices(ServiceTypes.Educate, DonationTypes.Reading)); Assert.AreEqual("3310000\n", sBase.printServices(ServiceTypes.Educate, DonationTypes.Writing)); Assert.AreEqual("4110000\n", sBase.printServices(ServiceTypes.Request, DonationTypes.Donation)); Assert.AreEqual(toy, sBase.retrieveService("1110000")); Assert.AreEqual(clothes, sBase.retrieveService("1210000")); Assert.AreEqual(tech, sBase.retrieveService("1310000")); Assert.AreEqual(faid, sBase.retrieveService("1410000")); Assert.AreEqual(hygiene, sBase.retrieveService("1510000")); Assert.AreEqual(food, sBase.retrieveService("1610000")); Assert.AreEqual(other, sBase.retrieveService("1810000")); Assert.AreEqual(drive, sBase.retrieveService("2110000")); Assert.AreEqual(math, sBase.retrieveService("3110000")); Assert.AreEqual(read, sBase.retrieveService("3210000")); Assert.AreEqual(write, sBase.retrieveService("3310000")); Assert.AreEqual(request, sBase.retrieveService("4110000")); }
public ServiceDatabaseTest() { _sut = new ServiceDatabase(_mongoClientMock.Object); }
public void User_Setter_Getter_Test() { User test = new User(name, password, email, street, apartment, city, state, zipcode); UserDatabase uBase = new UserDatabase(); ServiceDatabase sBase = new ServiceDatabase(); uBase.addUser(test); test.setName("tester"); Assert.AreEqual("tester", test.getName()); test.setPassword("pass"); Assert.IsTrue(uBase.verifyUser("*****@*****.**", "pass")); test.setEmail("*****@*****.**"); Assert.AreEqual("*****@*****.**", test.getEmail()); test.setAddress("321 Test St", "#201", "Portland", "OR", "97501"); Assert.AreEqual("321 Test St, #201, Portland, OR, 97501", test.getAddress()); test.setVehicleType("Sedan"); Assert.AreEqual("Sedan", test.getVehicleType()); test.setCapacity("30"); Assert.AreEqual("30", test.getCapacity()); test.setTimeStart("1400"); Assert.AreEqual("1400", test.getTimeStart()); test.setTimeStop("2000"); Assert.AreEqual("2000", test.getTimeStop()); test.setLicenseFilePath("testing.jpeg"); Assert.AreEqual("testing.jpeg", test.getLicenseFilePath()); test.setAdmin(true); Assert.IsTrue(test.isAdmin()); Service toy = new Service("tester", "*****@*****.**"); sBase.createService(ServiceTypes.Donate, DonationTypes.Toys, test, toy); myServices = new List <Service>(); myServices.Add(toy); test.addService(toy); Assert.AreEqual(myServices[0], test.getServices()[0]); Assert.IsTrue(test.checkPassword("pass")); Assert.IsFalse(test.checkPassword("Password")); test.addDrive(vehichle, capacity, start, stop, license); Assert.AreEqual(vehichle, test.getVehicleType()); Assert.AreEqual(capacity, test.getCapacity()); Assert.AreEqual(start, test.getTimeStart()); Assert.AreEqual(stop, test.getTimeStop()); Assert.AreEqual(license, test.getLicenseFilePath()); string path = @"C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\CommonExtensions\Microsoft\TestWindow"; File.Delete(Path.Combine(path, "Toy_Dictionary.txt")); File.Delete(Path.Combine(path, "Clothes_Dictionary.txt")); File.Delete(Path.Combine(path, "Tech_Dictionary.txt")); File.Delete(Path.Combine(path, "First_Aid_Dictionary.txt")); File.Delete(Path.Combine(path, "Hygene_Dictionary.txt")); File.Delete(Path.Combine(path, "Food_Dictionary.txt")); File.Delete(Path.Combine(path, "Other_Dictionary.txt")); File.Delete(Path.Combine(path, "Goods_Dictionary.txt")); File.Delete(Path.Combine(path, "Math_Dictionary.txt")); File.Delete(Path.Combine(path, "Reading_Dictionary.txt")); File.Delete(Path.Combine(path, "Writing_Dictionary.txt")); File.Delete(Path.Combine(path, "Request_Dictionary.txt")); File.Delete(Path.Combine(path, "serial_list.txt")); File.Delete(Path.Combine(path, "userlist.txt")); }