public async void AddAdvertisement()
{
var ctx = _fixture.ctx;
var advertisementRepository = new AdvertisementRepository(ctx);
var advert = new Advertisement
{
Id = 6,
UserId = 8,
Title = "test1",
DateCreated = DateTime.Now.AddMonths(-1),
ExchangeActive = true,
IsActive = true,
Price = 100,
Item = new Game()
{
Id = 6,
AdvertisementId = 6,
Description = "Hey",
GameRegionId = 1,
GenreId = 1,
}
};
await advertisementRepository.AddAsync(advert);
var ads = await advertisementRepository.GetAsync(6);
Assert.NotNull(ads);
}
public override void Startup(IService service)
{
var advertisementRepository = new AdvertisementRepository();
service
.AddSiteMenu(siteId => new Menu
{
Text = "广告管理",
IconClass = "fa fa-mouse-pointer",
Menus = new List <Menu>
{
new Menu
{
Text = "添加广告",
Href = "pages/advertisementAdd.html"
},
new Menu
{
Text = "广告列表",
Href = "pages/advertisement.html"
}
}
})
.AddDatabaseTable(advertisementRepository.TableName, advertisementRepository.TableColumns)
;
service.BeforeStlParse += Service_BeforeStlParse;
}
public static string GetData(int pageIndex)
{
var ads = new AdvertisementRepository().GetByPageIndex(pageIndex, PageSize);
FirstCount += PageSize;
StringBuilder sb = new StringBuilder();
foreach (Advertisement ad in ads)
{
{
sb.AppendFormat(@"<div class=""col-sm-2 un-pad"">");
{
sb.AppendFormat(@"<div class=""list-item-bg"">");
{
sb.AppendFormat(@"<div class=""frame-size"">");
{
sb.AppendFormat(@"<div>");
sb.AppendFormat(@"<img src=""Content/Images/" + (ad.Id - 1).ToString() + @".jpg"" class="" img-size""/>");
sb.AppendFormat(@"</div>");
}
sb.AppendFormat(@"</div>");
}
{
sb.AppendFormat(@"<div class=""item-border""></div>");
}
{
sb.AppendFormat(@"<div style=""background: #f5f5f5; border-bottom-left-radius: 4px; border-bottom-right-radius: 4px;"">");
{
sb.AppendFormat(@"<p style=""text-align: center"">");
sb.AppendFormat(@ad.Name);
sb.AppendFormat(@"</p>");
}
{
sb.AppendFormat(@"<div class=""item-border""></div>");
}
// <%--محله:--%>
{
sb.AppendFormat(@"<div style=""background: #dcebf9; border-bottom-left-radius: 4px; border-bottom-right-radius: 4px;"">");
{
sb.AppendFormat(@"<p style=""padding-right: 5%; padding-bottom: 5%; color: #8c9fe4"">");
//sb.AppendFormat(ad.AdvArea);
sb.AppendFormat(@"</p>");
}
sb.AppendFormat(@"</div>");
}
sb.AppendFormat(@"</div>");
}
sb.AppendFormat(@"</div>");
}
sb.AppendFormat(@"</div>");
}
}
return(sb.ToString());
}
public bool update(int id, string title, string description)
{
var advertisement = AdvertisementRepository.find(id);
if (advertisement.Status == "Inactive")
{
return(false);
}
AdvertisementRepository.update(id, title, description);
return(true);
}
public bool remove(int id)
{
var advertisement = AdvertisementRepository.find(id);
if (advertisement.Status == "Inactive")
{
return(false);
}
AdvertisementRepository.remove(id);
return(true);
}
public UnitOfWork()
{
_context = new FBruContext();
Advertisements = new AdvertisementRepository(_context);
Blogs = new BlogRepository(_context);
Categories = new CategoryRepository(_context);
Dishes = new DishRepository(_context);
Images = new ImageRepository(_context);
Keywords = new KeywordRepository(_context);
Restaurants = new RestaurantRepository(_context);
Users = new UserRepository(_context);
UserGroups = new UserGroupRepository(_context);
}
public async void GetRecommendedAdsForUserPositive()
{
var ctx = _fixture.ctx;
var advertisementRepository = new AdvertisementRepository(ctx);
var adsForUser = await advertisementRepository.GetRecommendedAdvertisements(1, 0, 10);
// should return 3
// 1 for owned system (other one is inactive)
// 1 for liked genre
// 1 for observed users
Assert.Equal(3, adsForUser.Count());
}
public async void GetAdsForUserTest()
{
var ctx = _fixture.ctx;
var advertisementRepository = new AdvertisementRepository(ctx);
var adsActiveForUser = await advertisementRepository.GetAdsForUser(userId : 8, page : 0, pageSize : 10, skipInactive : true);
var adsInActiveForUser =
await advertisementRepository.GetAdsForUser(userId : 8, page : 0, pageSize : 10, skipInactive : false);
Assert.Equal(4, adsActiveForUser.Count());
Assert.Equal(3, adsInActiveForUser.Count());
}
public async void SearchAccessoriesNegative()
{
var ctx = _fixture.ctx;
var advertisementRepository = new AdvertisementRepository(ctx);
var accessories = await advertisementRepository.GetQueriedAds(new AdQueryOptions()
{
Type = "accessory",
Systems = new int[0],
Genres = new int[0]
}) as List <Advertisement>;
Assert.Empty(accessories);
}
public IHttpActionResult Get()
{
try
{
AdvertisementRepository adRepo = new AdvertisementRepository();
var Ads = adRepo.FindAll();
return(Ok(Ads));
}
catch (Exception)
{
return(InternalServerError());
}
}
public UnitOfWork(LogDbContext dbContext)
{
_dbContext = dbContext;
Classes = new SchoolClassRepository(dbContext);
Users = new UserRepository(dbContext);
Students = new StudentRepository(dbContext);
Teachers = new TeacherRepository(dbContext);
Parents = new ParentRepository(dbContext);
Subjects = new SubjectRepository(dbContext);
SchoolGrades = new SchoolGradeRepository(dbContext);
Messages = new MessageRepository(dbContext);
Advertisements = new AdvertisementRepository(dbContext);
Files = new FileRepository(dbContext);
Questions = new QuestionRepository(dbContext);
QuestionAnswers = new QuestionAnswerRepository(dbContext);
Tests = new TestRepository(dbContext);
}
public static async Task Main(string[] args)
{
var services = new ServiceCollection();
//Adatbázis hozzáadása
services.AddDbContext <DatabaseContext>(ServiceLifetime.Scoped);
var serviceProvider = services.BuildServiceProvider();
var Context = serviceProvider.GetRequiredService <DatabaseContext>();
var subscriptionRepository = new SubscriptionRepository(Context);
var advertisementRepository = new AdvertisementRepository(Context);
var paymentService = new DemoPaymentService();
var SubscriptionService = new SubscriptionService(subscriptionRepository, advertisementRepository, paymentService);
//Hirdetések megjelenésének frissítése
await SubscriptionService.UpdateExpiredSubscriptions();
}
public async void SearchConsolesPositive()
{
// Arrange
var ctx = _fixture.ctx;
var advertisementRepository = new AdvertisementRepository(ctx);
// Act
var consoles = await advertisementRepository.GetQueriedAds(new AdQueryOptions()
{
Type = "console",
Systems = new int[0],
Genres = new int[0]
}) as List <Advertisement>;
// Assert
Assert.Equal(3, consoles.Count);
}
protected void Page_Load(object sender, EventArgs e)
{
var user = (RollingRides.WebApp.Components.Datalayer.Models.User)Session["User"];
var settings = new SettingsRepository().GetSettings();
if (settings != null)
{
companyLogo.ImageUrl = settings.CompanyLogoUrl;
}
var adRepo = new AdvertisementRepository();
var ad1 = adRepo.GetAdvertisement((int)LocationType.Top);
var ad2 = adRepo.GetAdvertisement((int)LocationType.SideBar);
var ad3 = adRepo.GetAdvertisement((int)LocationType.Footer);
if (ad1 != null)
{
litAd.Text = "<a href='" + ad1.Link + "' > <img src='" +
ad1.DisplayObjectUrl + "' /></a>";
}
if (ad2 != null)
{
litSideAd.Text = "<a href='" + ad2.Link + "' > <img src='" +
ad2.DisplayObjectUrl + "' /></a>";
}
if (ad3 != null)
{
litAd3.Text = "<a href='" + ad3.Link + "' > <img src='" +
ad3.DisplayObjectUrl + "' /></a>";
}
if (user == null)
{
lblUsername.Text = "Hello Guest";
btnSignOut.Visible = false;
return;
}
var name = user.Username;
if (!string.IsNullOrEmpty(user.LastName) && !string.IsNullOrEmpty(user.FirstName))
{
name = user.FirstName + " " + user.LastName;
}
lblUsername.Text = "Hello " + name;
}
public IHttpActionResult Post(PaymentDto paymentDto)
{
AdvertisementRepository adRepo = new AdvertisementRepository();
var Id = adRepo.GetId(paymentDto.Name);
Payment payment = new Payment
{
AdvertisementId = Id,
Amount = paymentDto.Amount,
PaymentDate = paymentDto.PaymentDate
};
try
{
repo.Create(payment);
return(Ok());
}
catch (Exception)
{
return(InternalServerError());
}
}
protected void Page_Load(object sender, EventArgs e)
{
var user = (RollingRides.WebApp.Components.Datalayer.Models.User) Session["User"];
var settings = new SettingsRepository().GetSettings();
if(settings != null)
{
companyLogo.ImageUrl = settings.CompanyLogoUrl;
}
var adRepo = new AdvertisementRepository();
var ad1 = adRepo.GetAdvertisement((int)LocationType.Top);
var ad2 = adRepo.GetAdvertisement((int)LocationType.SideBar);
var ad3 = adRepo.GetAdvertisement((int)LocationType.Footer);
if (ad1 != null)
{
litAd.Text = "<a href='" + ad1.Link + "' > <img src='" +
ad1.DisplayObjectUrl + "' /></a>";
}
if (ad2 != null)
{
litSideAd.Text = "<a href='" + ad2.Link + "' > <img src='" +
ad2.DisplayObjectUrl + "' /></a>";
}
if (ad3 != null)
{
litAd3.Text = "<a href='" + ad3.Link + "' > <img src='" +
ad3.DisplayObjectUrl + "' /></a>";
}
if (user == null)
{
lblUsername.Text = "Hello Guest";
btnSignOut.Visible = false;
return;
}
var name = user.Username;
if (!string.IsNullOrEmpty(user.LastName) && !string.IsNullOrEmpty(user.FirstName))
name = user.FirstName + " " + user.LastName;
lblUsername.Text = "Hello "+ name;
}
public CommonController()
{
advertisement = new AdvertisementRepository();
}
public AdvertisementService()
{
_advertisementRepository = new AdvertisementRepository();
}
public AdvertisementService(UserRepository userRepository, AdvertisementRepository advertisementRepository)
{
_advertisementRepository = advertisementRepository;
_userRepository = userRepository;
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.Configure <CookiePolicyOptions>(options =>
{
// This lambda determines whether user consent for non-essential cookies is needed for a given request.
options.CheckConsentNeeded = context => true;
options.MinimumSameSitePolicy = SameSiteMode.None;
});
services.AddScoped <IAdvertisementRepository, AdvertisementRepository>(sp => AdvertisementRepository.GetUser(sp));
services.AddScoped <IAccountRepository, AccountRepository>();
services.AddScoped <ICardRepository, CardRepository>();
services.AddScoped <IShoppingCartRepository, ShoppingCartRepository>();
//services.AddScoped<AdvertisementRepository>(sp => AdvertisementRepository.GetUser(sp));
services.AddScoped <ICardSystemAPI, CardSystemAPI>();
services.AddScoped <IAuctionRepository, AuctionRepository>();
services.AddScoped <IGameRepository, GameRepository>();
services.AddScoped <IGameVoteRepository, GameVoteRepository>();
services.AddDbContext <AppDbContext>(options =>
options.UseSqlServer(Configuration.GetConnectionString("DefaultConnection")));
services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1);
services.AddHttpContextAccessor();
services.AddHostedService <CheckWonAuctionsService>();
// services.AddDistributedMemoryCache();
services.AddSession(options =>
{
options.Cookie.HttpOnly = true;
options.Cookie.IsEssential = true;
});
}
public int getLastID()
{
AdvertisementRepository repository = new AdvertisementRepository();
return(repository.getLastID());
}
public List <Advertisement> getAllAdvertisement()
{
AdvertisementRepository repository = new AdvertisementRepository();
return(repository.getAllAdvertisement());
}
public AdvertisementController()
{
repo = new AdvertisementRepository();
}
public List <Advertisement> getAll()
{
return(AdvertisementRepository.getAll());
}
protected override void DoJob()
{
AdvertisementRepository rep = new AdvertisementRepository(OpConn);
ObjList = rep.GetList(obj);
}
public void RemoveSchoolData(int ClientId)
{
PictureRepository picrep = new PictureRepository();
picrep.RemoveSchoolPictures(ClientId);
NotificationsRepository nrep = new NotificationsRepository();
nrep.RemoveSchoolNotificationss(ClientId);
EventRepository erep = new EventRepository();
erep.RemoveSchoolEvents(ClientId);
AdvertisementRepository arep = new AdvertisementRepository();
arep.RemoveClientAdvertisement(ClientId);
NewsRepository nerep = new NewsRepository();
nerep.RemoveSchoolNewss(ClientId);
ContactRepository crep = new ContactRepository();
crep.RemoveSchoolContacts(ClientId);
}
public Advertisement addAdvertisement(Advertisement advertisement)
{
AdvertisementRepository repository = new AdvertisementRepository();
return(repository.addAdvertisement(advertisement));
}
public CianParser()
{
repository = new AdvertisementRepository();
}
public List <Advertisement> GetAdds()
{
return(AdvertisementRepository.GetAdds());
}
public void add(string title, string description)
{
Advertisement a = AdvertisementFactory.create(title, description);
AdvertisementRepository.add(a);
}
public AdvertisementRepositoryTests(ClassTestFixture testFixture)
{
_dbContext = testFixture.Context;
_advertisementRepository = new AdvertisementRepository(_dbContext, new AdvertisementMapper());
_fixture = new Fixture();
}
public IEnumerable <Advertisement> GetByCategory(int catId, int pageNumber, int pageSize)
{
var res = new AdvertisementRepository().GetByPageIndex(catId, pageNumber, pageSize).ToList();
return(res);
}
