static void Find()
{
Console.WriteLine("Enter the name of the book to find in DB: ");
string input = Console.ReadLine();
using (var db = new BookAppDBEntities())
{
var newBook = new BookTable()
{
// var input = Console.ReadLine();
Id = Guid.NewGuid(),
Name = input
};
// var b = db.BookTables.Where(x => x.Name == input).FirstOrDefault();
//var b = db.BookTables
// .Select(x => x.Name == input).FirstOrDefault();
//Console.WriteLine($"{b}");
// db.SaveChanges();
var book = db.BookTables.SingleOrDefault(p => p.Name == input);
//Console.WriteLine("{0} was found.", book.Name);
Console.WriteLine("{0} was found.");
}
}
static void Update()
{
//Console.WriteLine("Nothing");
Console.WriteLine("What book do you want to update: ");
string oldName = Console.ReadLine();
using (var db = new BookAppDBEntities())
{
var book = db.BookTables
.Where(x => x.Name == oldName).FirstOrDefault();
db.BookTables.Remove(book);
db.SaveChanges();
Console.WriteLine("Enter the new name: ");
string newName = Console.ReadLine();
if (book != null)
{
var newBook = new BookTable()
{
// var input = Console.ReadLine();
Id = Guid.NewGuid(),
Name = newName
};
db.BookTables.Add(newBook);
db.SaveChanges();
Console.WriteLine($"{newName} was being updated.");
}
// Console.WriteLine($"{newName} was being updated.");
}
}
static void Main(string[] args)
{
//Console.WriteLine("Enter a book name: ");
using (var db = new BookAppDBEntities())
{
var b1 = new BookTable()
{
Id = Guid.NewGuid(),
Name = "Cplusplus"
};
var b2 = new BookTable()
{
Id = Guid.NewGuid(),
Name = "C Objective"
};
var b3 = new BookTable()
{
Id = Guid.NewGuid(),
Name = "F sharp"
};
Guid id = Guid.Parse("00000000-0000-0000-0000-000000000000");
//var bk = db.BookTables.Where(x => x.Id == id).FirstOrDefault();
//bk.Name = "C sharp";
db.BookTables.Add(b1);
db.BookTables.Add(b2);
db.BookTables.Add(b3);
db.SaveChanges();
}
}
static void Display()
{
//Console.WriteLine("Nothing");
using (var db = new BookAppDBEntities())
{
foreach (var books in db.BookTables)
{
Console.WriteLine(books.Name);
}
;
}
}
static void Add()
{
//Console.WriteLine("Nothing");
Console.WriteLine("Enter a book name: ");
string input = Console.ReadLine();
using (var db = new BookAppDBEntities())
{
var book = new BookTable()
{
// var input = Console.ReadLine();
Id = Guid.NewGuid(),
Name = input
};
db.BookTables.Add(book);
db.SaveChanges();
Console.WriteLine($"{input} was being added.");
}
}
static void Update()
{
//Console.WriteLine("Nothing");
Console.WriteLine("What book do you want to update: ");
string oldName = Console.ReadLine();
using (var db = new BookAppDBEntities())
{
var book = db.BookTables
.Where(x => x.Name == oldName).FirstOrDefault();
Console.WriteLine("Enter the new name: ");
string newName = Console.ReadLine();
if (book != null)
{
db.Entry(oldName).CurrentValues.SetValues(newName);
db.SaveChanges();
}
Console.WriteLine($"{newName} was being updated.");
}
}
static void Remove()
{
//Console.WriteLine("Nothing");
Console.WriteLine("What book do you want to remove: ");
string input = Console.ReadLine();
using (var db = new BookAppDBEntities())
{
//var book = new BookTable()
//{
// Id = Guid.NewGuid(),
// Name = Console.ReadLine()
//};
//db.BookTables.Remove(book);
//db.SaveChanges();
var book = db.BookTables
.Where(x => x.Name == input).FirstOrDefault();
db.BookTables.Remove(book);
db.SaveChanges();
Console.WriteLine($"{input} was being removed.");
}
}