public void GetAllPresentations_returns_empty_if_thereAreNoPresentations()
{
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
try
{
var options = new DbContextOptionsBuilder <PlanificatorDbContext>()
.UseSqlite(connection)
.Options;
using (var context = new PlanificatorDbContext(options))
{
context.Database.EnsureCreated();
var query = new PresentationRepository(context);
Assert.Empty(query.GetAllPresentations());
}
}
finally
{
connection.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
int gelenid = Convert.ToInt32(Request.QueryString["id"]);
PresentationRepository islem = new PresentationRepository();
Presentation sunum = islem.TekGetir(gelenid);
string filePath = sunum.FileUrl;
Response.ContentType = ContentType;
Response.AppendHeader("Content-Disposition", "attachment; filename=" + Path.GetFileName(filePath));
Response.WriteFile(filePath);
Response.End();
}
public async Task GetAllPresentations_returns_all_presentationsAsync()
{
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
try
{
var options = new DbContextOptionsBuilder <PlanificatorDbContext>()
.UseSqlite(connection)
.Options;
using (var context = new PlanificatorDbContext(options))
{
context.Database.EnsureCreated();
var service = new PresentationManager(context);
var query = new PresentationRepository(context);
var testData1 = new PresentationRepositoryTestsData();
var testData2 = new PresentationRepositoryTestsData();
var testData3 = new PresentationRepositoryTestsData();
List <Presentation> presentations = new List <Presentation>();
presentations.Add(testData1.presentation);
presentations.Add(testData2.presentation);
presentations.Add(testData3.presentation);
await service.AddPresentation(testData1.presentationTags);
await service.AddPresentation(testData2.presentationTags);
await service.AddPresentation(testData3.presentationTags);
context.SaveChanges();
Assert.Equal(context.Presentations.Count(), query.GetAllPresentations().Count());
Assert.Equal(presentations, query.GetAllPresentations());
}
}
finally
{
connection.Close();
}
}
public async Task AddPresentation_writes_to_databaseAsync()
{
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
try
{
var options = new DbContextOptionsBuilder <PlanificatorDbContext>()
.UseSqlite(connection)
.Options;
using (var context = new PlanificatorDbContext(options))
{
context.Database.EnsureCreated();
var service = new PresentationManager(context);
var query = new PresentationRepository(context);
var testData = new PresentationRepositoryTestsData();
await service.AddPresentation(testData.presentationTags);
context.SaveChanges();
List <string> tagsNames = testData.tags.Select(tag => tag.TagName).ToList();
Assert.Equal(tagsNames.Count, query.GetAllTagsNames(testData.presentation.PresentationId).Count());
Assert.Equal(tagsNames, query.GetAllTagsNames(testData.presentation.PresentationId));
}
}
finally
{
connection.Close();
}
}
public PresentationService(PresentationRepository presentRepo, SlotRepository slotRepo)
{
_presentRepo = presentRepo;
_slotRepo = slotRepo;
}
