public static void DeleteBook(int bookId)
{
using (var dbcontext = new CrudAppDbContext())
{
var query = from b in dbcontext.Books orderby b.Id select b;
foreach (var b in query)
{
if (b.Id == bookId)
{
dbcontext.Remove(b);
break;
}
}
dbcontext.SaveChanges();
}
}
public static void UpdateBookDetails(int bookId, string title, string gener)
{
using (var dbcontext = new CrudAppDbContext())
{
var query = from b in dbcontext.Books orderby b.Id select b;
foreach (var b in query)
{
if (b.Id == bookId)
{
b.Title = title;
b.Gener = gener;
dbcontext.Update(b);
break;
}
}
dbcontext.SaveChanges();
}
}
public static void AddBook()
{
using (var dbcontext = new CrudAppDbContext())
{
Console.WriteLine("**********Enter Book details**********");
Console.WriteLine("--------------------------------------");
Console.Write("Book Title : ");
string title = Console.ReadLine();
Console.Write("Book Gener : ");
string gener = Console.ReadLine();
Console.WriteLine(" ");
var book = new Book {
Title = title, Gener = gener
};
dbcontext.Books.Add(book);
dbcontext.SaveChanges();
}
}
public static void AddMember()
{
using (var dbcontext = new CrudAppDbContext())
{
Console.WriteLine("**********Enter Member details**********");
Console.WriteLine("----------------------------------------");
Console.Write("Member Name : ");
string name = Console.ReadLine();
Console.Write("Member Contact No. : ");
string phoneno = Console.ReadLine();
Console.Write("Member City : ");
string city = Console.ReadLine();
var member = new Member {
Name = name, City = city, PhoneNo = phoneno
};
dbcontext.Members.Add(member);
dbcontext.SaveChanges();
}
}