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;
}
}
