public SponsorApi(IUnitOfWorkFactory unitOfWorkFactory, BursifyUserRepository userRepository, Repository <UserAddress> userAddressRepository, CampaignRepository campaignRepository, CampaignSponsorRepository campaignSponsorRepository, SponsorshipRepository sponsorshipRepository, StudentSponsorshipRepository studentSponsorshipRepository, Repository <Student> studentRepository, BridgeRepository <CampaignReport> campaignReportBridgeRepository, SponsorRepository sponsorRepository, NotificationRepository notificationRepository) : base(unitOfWorkFactory, userRepository, userAddressRepository, campaignRepository, campaignSponsorRepository, notificationRepository) { this.sponsorshipRepository = sponsorshipRepository; this.studentSponsorshipRepository = studentSponsorshipRepository; this.studentRepository = studentRepository; this.campaignReportBridgeRepository = campaignReportBridgeRepository; this.sponsorRepository = sponsorRepository; }
public void GetAll_returns_all_sponsors() { // Arrange var repository = new SponsorRepository(activeSessionManager); // Act var sponsors = repository.GetAll(); // Assert Assert.That(sponsors.Count(), Is.EqualTo(2)); }
public void AddSponsor_saves_sponsor_to_database() { // Arrange var repository = new SponsorRepository(activeSessionManager); var sponsor = new Sponsor() {Name = "Sample Sponsor"}; // Act int returnedId = repository.Add(sponsor); // Assert Assert.That(returnedId, Is.EqualTo(sponsor.SponsorId)); }
public void GetAll_ShouldReturn_All_Sponsors_InThe_Database() { //Arrange int expectedCount; using (DayOfDotNetDataContext dc = new DayOfDotNetDataContext()) { expectedCount = (from x in dc.Sponsors select x).Count(); } //Act ISponsorRepository repo = new SponsorRepository(); IList<SponsorDTO> sponsors = repo.GetAll(); //Assert sponsors.Count.ShouldEqual(expectedCount, "Wrong number of sponsors"); }
public void GetById_returns_a_sponsor() { // Arrange var repository = new SponsorRepository(activeSessionManager); // Act var sponsor = repository.GetById(3); // Assert Assert.That(sponsor.Name, Is.EqualTo("TekSystems")); Assert.That(sponsor.Url, Is.EqualTo("http://teksystems.com")); Assert.That(sponsor.Description, Is.EqualTo("TekSystem is your one stop staffing shop.")); }
public void GetAllThatProvidedSwag_ShouldReturn_All_Sponsors_InThe_Database_Where_ProvidedSwag_Equals_True() { //Arrange int expectedCount; using (DayOfDotNetDataContext dc = new DayOfDotNetDataContext()){ expectedCount = (from x in dc.Sponsors where x.ProvidedSwag select x).Count(); } //Act ISponsorRepository repo = new SponsorRepository(); IList<SponsorDTO> sponsors = repo.GetAllThatProvidedSwag(); //Assert sponsors.Count.ShouldEqual(expectedCount, "Wrong number of sponsors"); (from x in sponsors where !x.ProvidedSwag select x).Count().ShouldEqual(0, "Expected 0 Sponsors that did not provide swag!"); }
public async Task GetSponsorByName_Should_Get_Sponsor_By_Given_Name() { var memoryDatabaseProvider = new InMemoryDatabaseProvider(_database); var sponsorRepository = new SponsorRepository(memoryDatabaseProvider); var name = "Tekna"; Sponsor sponsor = await sponsorRepository.GetSponsorByName(name); Sponsor dbSponsor = _database.Sponsors.FirstOrDefault(m => m.Name == name); Assert.NotNull(sponsor); Assert.NotNull(dbSponsor); Assert.Equal(sponsor.Id, dbSponsor.Id); Assert.Equal(sponsor.Name, dbSponsor.Name); Assert.Equal(sponsor.LogoUrl, dbSponsor.LogoUrl); }
public static void AddSponsorToSeason(int companyId, int seasonId, int sponsorProfileId) { using (var db = new CSBCDbContext()) { var rep = new SponsorRepository(db); if (!(rep.IsSeasonSponsor(seasonId, sponsorProfileId))) { var sponsor = rep.Insert( new Sponsor { SponsorProfileID = sponsorProfileId, SeasonID = seasonId, CompanyID = companyId } ); } } }
public async Task GetMeetups_Should_Get_All_Sponsors() { var memoryDatabaseProvider = new InMemoryDatabaseProvider(_database); var sponsorRepository = new SponsorRepository(memoryDatabaseProvider); IList <Sponsor> sponsors = (await sponsorRepository.GetSponsors()).ToList(); foreach (Sponsor dbSponsor in _database.Sponsors.ToList()) { Sponsor sponsor = sponsors.FirstOrDefault(m => m.Id == dbSponsor.Id); Assert.NotNull(sponsor); Assert.NotNull(dbSponsor); Assert.Equal(sponsor.Id, dbSponsor.Id); Assert.Equal(sponsor.Name, dbSponsor.Name); Assert.Equal(sponsor.LogoUrl, dbSponsor.LogoUrl); } Assert.Equal(sponsors.Count, _database.Sponsors.Length); Assert.Contains(sponsors, sponsor => _database.Sponsors.Select(s => s.Id).Contains(sponsor.Id)); }
public async Task GetMeetupsByIds_Should_Get_Sponsors_By_Given_Id_List() { var memoryDatabaseProvider = new InMemoryDatabaseProvider(_database); var sponsorRepository = new SponsorRepository(memoryDatabaseProvider); var ids = new[] { 1, 3 }; IList <Sponsor> sponsors = (await sponsorRepository.GetSponsorsByIds(ids)).ToList(); IList <Sponsor> dbSponsors = _database.Sponsors.Where(sponsor => ids.Contains(sponsor.Id)).ToList(); foreach (Sponsor dbSponsor in dbSponsors) { Sponsor sponsor = sponsors.FirstOrDefault(m => m.Id == dbSponsor.Id); Assert.NotNull(sponsor); Assert.NotNull(dbSponsor); Assert.Equal(sponsor.Id, dbSponsor.Id); Assert.Equal(sponsor.Name, dbSponsor.Name); Assert.Equal(sponsor.LogoUrl, dbSponsor.LogoUrl); } Assert.Equal(sponsors.Count, dbSponsors.Count); Assert.Contains(sponsors, sponsor => ids.Contains(sponsor.Id)); }
private void UpdateRow(int rowId) { using (var db = new CSBCDbContext()) { var repSponsorProfile = new SponsorProfileRepository(db); var repSponsor = new SponsorRepository(db); try { var sponsorProfile = CreateSponsorProfileObjectFromRow(); var sponsorProfileId = repSponsorProfile.Insert(sponsorProfile); var sponsor = CreateSponsorObjectFromRow(sponsorProfileId.SponsorProfileID); //sponsor.SpoAmount = cmbFees.SelectedItem.Text; // fee need to check //need to update both tables //oSponsors.UpdRow(RowID, Session["CompanyID"], Session["TimeZone"]); Master.SponsorId = sponsor.SponsorID; Master.SponsorProfileId = sponsorProfile.SponsorProfileID; } catch (Exception ex) { ErrorMessage = "UpdRow::" + ex.Message; } } }
private void LoadSponsors() { var rep = new SponsorRepository(new CSBCDbContext()); var sponsors = rep.GetSeasonSponsors(Master.SeasonId).ToList(); try { var _with1 = grdSponsors; _with1.DataSource = sponsors; _with1.DataBind(); } catch (Exception ex) { lblError.Text = "LoadSponsors::" + ex.Message; } }
private void LoadRow(int sponsorId) { Contract.Ensures(sponsorId != 0); try { var rep = new SponsorRepository(new CSBCDbContext()); var sponsor = rep.GetById(sponsorId); if (sponsor != null) { Master.SponsorId = sponsorId; txtSponsorName.Text = sponsor.SponsorProfile.SpoName; Master.SponsorProfileId = sponsor.SponsorProfileID; txtContact.Text = sponsor.SponsorProfile.ContactName; txtAddress.Text = sponsor.SponsorProfile.Address; txtCity.Text = sponsor.SponsorProfile.City; txtState.Text = sponsor.SponsorProfile.State; txtZip.Text = sponsor.SponsorProfile.Zip; txtPhone.Text = sponsor.SponsorProfile.Phone; txtWebsite.Text = sponsor.SponsorProfile.URL; txtEmail.Text = sponsor.SponsorProfile.EMAIL; txtUniformName.Text = sponsor.ShirtName; var balance = rep.GetSponsorBalance(sponsor.SponsorProfile.SponsorProfileID); //lblBalance.Text = sponsor.SpoAmount.ToString(); lblBalance.Text = balance.ToString("C"); if (balance > 0) lblBalance.ForeColor = System.Drawing.Color.Red; if (balance == 0) lblBalance.ForeColor = System.Drawing.Color.Black; if (balance < 0) lblBalance.ForeColor = System.Drawing.Color.DarkGreen; cmbColors.SelectedValue = sponsor.Color1; cmbColors2.SelectedValue = sponsor.Color2; cmbSizes.SelectedValue = sponsor.ShirtSize; if (sponsor.FeeID != null) { cmbFees.SelectedValue = LoadFee((decimal)sponsor.FeeID); } else { cmbFees.SelectedIndex = 0; } } //If IsNumeric(rsData.Rows(0).Item("Master.SponsorId")) Then // Master.SponsorId = rsData.Rows(0).Item("Master.SponsorId") //End If lnkComments.Enabled = true; txtComments.Enabled = true; btnPayments.Enabled = true; Session.Add("LinkName", txtSponsorName.Text); } catch (Exception ex) { lblError.Text = "LoadRow::" + ex.Message; } GetKids(Master.SponsorId); }
private void LoadProfile(int sponsorProfileId) { try { using (var db = new CSBCDbContext()) { var rep = new SponsorProfileRepository(db); var sponsorProfile = rep.GetById(sponsorProfileId); if (sponsorProfile != null) { txtSponsorName.Text = sponsorProfile.SpoName; Master.SponsorProfileId = sponsorProfile.SponsorProfileID; txtContact.Text = sponsorProfile.ContactName; txtAddress.Text = sponsorProfile.Address; txtCity.Text = sponsorProfile.City; txtState.Text = sponsorProfile.State; txtZip.Text = sponsorProfile.Zip; txtPhone.Text = sponsorProfile.Phone; txtWebsite.Text = sponsorProfile.URL; txtEmail.Text = sponsorProfile.EMAIL; //need to call function that gets balance var repSponsor = new SponsorRepository(db); var balance = repSponsor.GetSponsorBalance(sponsorProfile.SponsorProfileID); lblBalance.Text = balance.ToString("C"); if (balance > 0) lblBalance.ForeColor = System.Drawing.Color.Red; if (balance == 0) lblBalance.ForeColor = System.Drawing.Color.Black; if (balance < 0) lblBalance.ForeColor = System.Drawing.Color.DarkGreen; } } } catch (Exception ex) { lblError.Text = "LoadProfile::" + ex.Message; } }
public SponsorsController(SponsorRepository sponsorRepository, FileUtility fileUtility, IConfiguration configuration) { _sponsorRepository = sponsorRepository; _fileUtility = fileUtility; _configuration = configuration; }
protected void cmbSponsors_SelectedIndexChanged1(object sender, EventArgs e) { var sponsorId = Convert.ToInt32(cmbSponsors.SelectedValue); using (var db = new CSBCDbContext()) { var rep = new SponsorRepository(db); var sponsor = rep.GetById(sponsorId); if (sponsor.Color1 != null) lblColors.Text = sponsor.Color1; } }
private async Task LoadAppResources() { try { LocationServiceProxy locationService = (LocationServiceProxy)_container.Resolve <ILocationService>(); //CardReaderService cardReaderService = (CardReaderService)_container.Resolve<ICardReaderService>(); //List<MSRReader> readers = await cardReaderService.Connect(); //string result = string.Empty; //foreach (MSRReader reader in readers) //{ // result += await cardReaderService.ListenForInput(reader); // result += Environment.NewLine; //} //int length = result.Length; //await Task.Delay(2000); if (locationService.GetIsInternetConnected()) { await Task.Delay(2000); Vereniging vereniging = null; object VerenigingsId; VerenigingRepository verenigingRepository = (VerenigingRepository)_container.Resolve <IVerenigingRepository>(); if (ApplicationData.Current.LocalSettings.Values.TryGetValue("VerenigingsId", out VerenigingsId)) { vereniging = await verenigingRepository.GetVerenigingByNummerAsync(VerenigingsId.ToString()); } else { Geoposition position = await locationService.GetLocationAsync(); vereniging = await verenigingRepository.GetVerenigingByLocatieAsync(position.Coordinate.Point.Position.Longitude, position.Coordinate.Point.Position.Latitude); } while (vereniging == null) { } ; BaanRepository baanRepository = (BaanRepository)_container.Resolve <IBaanRepository>(); await baanRepository.GetBanenAsync(vereniging.Id, vereniging.AccommodatieId); ReserveringRepository reserveringRepository = (ReserveringRepository)_container.Resolve <IReserveringRepository>(); await reserveringRepository.GetReserveringenAsync(); SponsorRepository sponsorRepository = (SponsorRepository)_container.Resolve <ISponsorRepository>(); await sponsorRepository.GetSponsorsAsync(vereniging.Id); try { verenigingRepository.UpdateStoreAgentAsync(); } catch { } } await Task.Delay(2000); } catch (Exception ex) { string messsage = ex.Message; //throw; } }