public static void AddDonater(Donater Donater)
{
using (BodonateDbContext db = new BodonateDbContext())
{
db.Donaters.Add(Donater);
db.SaveChanges();
}
}
public static void AddNewBook(Transfer transfer)
{
using (BodonateDbContext db = new BodonateDbContext())
{
db.Transfers.Add(transfer);
db.SaveChanges();
}
}
public static void AddNewBook(Book book)
{
using (BodonateDbContext db = new BodonateDbContext())
{
db.Books.Add(book);
db.SaveChanges();
}
}
public static void AddGenre(Genre Genre)
{
using (BodonateDbContext db = new BodonateDbContext())
{
db.Genres.Add(Genre);
db.SaveChanges();
}
}
public static void DeleteUserById(int Id)
{
using (BodonateDbContext db = new BodonateDbContext())
{
var UserToBeDeleted = db.Users.SingleOrDefault(u => u.Id == Id);
db.SaveChanges();
}
}
public static void AddUser(User User)
{
using (BodonateDbContext db = new BodonateDbContext())
{
db.Users.Add(User);
db.SaveChanges();
}
}
public static void DeleteTransfer(int id)
{
using (BodonateDbContext db = new BodonateDbContext())
{
var Transfer_To_Delete = db.Transfers.SingleOrDefault(t => t.Id == id);
db.Transfers.Remove(Transfer_To_Delete);
db.SaveChanges();
}
}
public static void DeleteGenreById(int Id)
{
using (BodonateDbContext db = new BodonateDbContext())
{
var GenreToBeDeleted = db.Genres.SingleOrDefault(g => g.Id == Id);
db.Genres.Remove(GenreToBeDeleted);
db.SaveChanges();
}
}
public static void DeleteBook(int id)
{
using (BodonateDbContext db = new BodonateDbContext())
{
var book_To_Delete = db.Books.SingleOrDefault(b => b.Id == id);
db.Books.Remove(book_To_Delete);
db.SaveChanges();
}
}
public static void UpdateBook(int id, Book updateBook)
{
using (BodonateDbContext db = new BodonateDbContext())
{
var book_To_Update = db.Books.SingleOrDefault(b => b.Id == id);
book_To_Update.Name = updateBook.Name;
book_To_Update.Genre.Id = updateBook.Genre.Id;
book_To_Update.Author = updateBook.Author;
db.SaveChanges();
}
}
public static void UpdateTransfer(int id, Transfer transfer)
{
using (BodonateDbContext db = new BodonateDbContext())
{
var Transfer_To_Update = db.Transfers.SingleOrDefault(t => t.Id == id);
Transfer_To_Update.Tracknumber = transfer.Tracknumber;
Transfer_To_Update.TransferDate = transfer.TransferDate;
Transfer_To_Update.UserDonated = transfer.UserDonated;
Transfer_To_Update.UserRequested = transfer.UserRequested;
db.SaveChanges();
}
}
public static void UpdateGenre(string userName, Genre Genre)
{
using (BodonateDbContext db = new BodonateDbContext())
{
var GenreToBeUpdated = db.Genres.SingleOrDefault(g => g.User.Username == userName);
GenreToBeUpdated.Name = Genre.Name;
GenreToBeUpdated.Id = Genre.Id;
GenreToBeUpdated.Checked = Genre.Checked;
GenreToBeUpdated.Message = Genre.Message;
db.SaveChanges();
}
}
public static void UpdateUser(string userName, User User)
{
using (BodonateDbContext db = new BodonateDbContext())
{
var UserToBeUpdated = db.Users.SingleOrDefault(u => u.Username == userName);
UserToBeUpdated.Name = User.Name;
UserToBeUpdated.SurName = User.SurName;
UserToBeUpdated.Password = User.Password;
UserToBeUpdated.Username = User.Username;
UserToBeUpdated.Transfers = User.Transfers;
UserToBeUpdated.Confirmpassword = User.Email;
db.SaveChanges();
}
}