public void Test3()
{
List <Author> authors = new List <Author>()
{
new Author()
{
Name = "A1"
},
new Author()
{
Name = "B2"
},
new Author()
{
Name = "B3"
}
};
database = GetDatabase(authors);
var service = new AuthorController(database, _logger);
var result = service.Get();
Assert.AreEqual(200, result.StatusCode);
var list = ((DbSet <Author>)result.Value).ToList();
Assert.AreEqual(authors.Count, list.Count);
for (int i = 0; i < authors.Count; i++)
{
Assert.AreEqual(authors[i].Name, list[i].Name);
}
}
protected void Page_Load(object sender, EventArgs e)
{
var authId = Request["AuthId"];
if (authId == null)
{
return;
}
FirstName.Text = authId;
int intAuthId;
int.TryParse(authId, out intAuthId);
var db = new AuthorsContext();
IList <Author> qAuthors = db.Authors.Select(p => p).ToList();
IList <Book> qBooks = db.Books.Select(p => p).ToList();
IList <AuthorBook> qAuthorBooks = db.AuthorBooks.Select(p => p).ToList();
var author = qAuthors.Single(p => p.AuthorID == intAuthId);
FirstName.Text = author.FirstName;
MiddleName.Text = author.MiddleName;
LastName.Text = author.LastName;
AuthorID.Text = author.AuthorID.ToString();
var bookId = qAuthorBooks.Where(s => s.AuthorID == author.AuthorID).Select(p => p.BookID);
var listBooks = bookId.Select(id => qBooks.Single(p => p.BookID == id)).ToList();
this.SubRepeater.DataSource = listBooks;
this.SubRepeater.DataBind();
}
public void Test6()
{
List <Author> authors = new List <Author>()
{
new Author()
{
Name = "A1"
},
new Author()
{
Name = "B2"
},
new Author()
{
Name = "B3"
}
};
database = GetDatabase(authors);
var service = new AuthorController(database, _logger);
var result = service.Get("B2");
Assert.AreEqual(200, result.StatusCode);
var author = (Author)result.Value;
Assert.AreEqual("B2", author.Name);
}
public void Test5()
{
List <Author> authors = new List <Author>()
{
new Author()
{
Name = "A1"
},
new Author()
{
Name = "B2"
},
new Author()
{
Name = "B3"
}
};
database = GetDatabase(authors);
var service = new AuthorController(database, _logger);
var result = service.Get("B400");
Assert.AreEqual(404, result.StatusCode);
Assert.AreEqual("No authors with this name found", result.Value);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, AuthorsContext context)
{
// context.Database.EnsureCreated ( );
context.Database.Migrate( ); //prilikom konfiguracije aplikacije izvrsice se sve potrebne migracije baze
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller=Home}/{action=Index}/{id?}");
});
}
protected void Page_Load(object sender, EventArgs e)
{
var _db = new AuthorsContext();
IQueryable <Author> qAuthors = _db.Authors;
List <Author> authors = new List <Author>();
foreach (var a in qAuthors)
{
authors.Add(a);
}
this.SubRepeater.DataSource = authors;
this.SubRepeater.DataBind();
}
public void Test8()
{
List <Author> authorsNew = new List <Author>()
{
new Author()
{
Name = "A1"
},
new Author()
{
Name = "B2"
},
new Author()
{
Name = "B3"
}
};
List <Author> authors = new List <Author>();
database = GetDatabase(authors);
var service = new AuthorController(database, _logger);
foreach (var author in authorsNew)
{
var code = service.Post(author);
Assert.AreEqual(200, code.StatusCode);
Assert.AreEqual("Succesful adding", code.Value);
}
var result = service.Get();
Assert.AreEqual(200, result.StatusCode);
Assert.AreEqual(authorsNew.Count, authors.Count);
for (int i = 0; i < authorsNew.Count; i++)
{
Assert.AreEqual(authorsNew[i].Name, authors[i].Name);
}
}
public GenreController(AuthorsContext context)
{
_context = context;
}
public BookController(AuthorsContext context)
{
_context = context;
}
protected void Save_OnClick(object sender, EventArgs e)
{
var db = new AuthorsContext();
int newAuthorID;
var authors = db.Authors.Select(s =>
s).ToList();
var author = authors.FirstOrDefault(p => p.FirstName == FirstName.Text && p.LastName == LastName.Text &&
p.MiddleName == MiddleName.Text);
if (author != null)
{
newAuthorID = author.AuthorID;
}
else
{
author = new Author
{
FirstName = FirstName.Text,
LastName = LastName.Text,
MiddleName = MiddleName.Text,
Birthday = new DateTime(1950, 5, 5)
};
db.Authors.AddOrUpdate(author);
db.SaveChanges();
newAuthorID = db.Authors.Select(s =>
s).First(p => p.FirstName == author.FirstName && p.LastName == author.LastName &&
p.MiddleName == author.MiddleName).AuthorID;
}
int i = 0;
for (;;)
{
i++;
var ctrlBookName = Page.Request.Form["BookName" + i];
var ctrlGenre = Page.Request.Form["Genre" + i];
int ctrlPages;
int.TryParse((Page.Request.Form["TotalPages" + i]), out ctrlPages);
if (ctrlBookName == null &&
ctrlGenre == null &&
ctrlPages == 0)
{
Response.Redirect("Default.aspx");
return;
}
int newBookID;
var books = db.Books.Select(s =>
s).ToList();
var book = books.FirstOrDefault(p => p.Name == ctrlBookName && p.Genre == ctrlGenre && p.TotalPages == ctrlPages);
if (book != null)
{
newBookID = book.BookID;
}
else
{
book = new Book
{
Name = ctrlBookName,
Genre = ctrlGenre,
TotalPages = ctrlPages
};
db.Books.AddOrUpdate(book);
db.SaveChanges();
newBookID =
db.Books.Select(s => s)
.First(
p =>
p.Name == ctrlBookName && p.Genre == ctrlGenre &&
p.TotalPages == ctrlPages)
.BookID;
}
var newAuthBooks = db.AuthorBooks.Select(s =>
s).ToList();
var newAuthBook = newAuthBooks.FirstOrDefault(p => p.AuthorID == newAuthorID && p.BookID == newBookID);
if (newAuthBook == null)
{
newAuthBook = new AuthorBook
{
AuthorID = author.AuthorID,
BookID = book.BookID
};
db.AuthorBooks.AddOrUpdate(newAuthBook);
db.SaveChanges();
}
}
}
public HomeController(AuthorsContext context)
{
_context = context;
}
public AuthorController(AuthorsContext nDatabase, ILogger <AuthorController> nLogger)
{
database = nDatabase;
_logger = nLogger;
}
public void Initialize()
{
_logger = Mock.Of <ILogger <AuthorController> >();
database = GetDatabase();
}
public AuthorController(AuthorsContext context)
{
_context = context;
}
public HomeController(ILogger <HomeController> logger, AuthorsContext context)
{
_logger = logger;
this.context = context;
}
