public string Update <Reading_Order>(int id, Library.Models.Reading_Order order)
{
try
{
Library.Models.Reading_Order newOrder = context.ReadingOrders.Where(s => s.Id == id).FirstOrDefault();
if (newOrder == null)
{
return("Такого заказа нет");
}
using (var dbCtx = new LibraryContext())
{
newOrder.Id_book = order.Id_book;
newOrder.Id_employee = order.Id_employee;
dbCtx.Entry(newOrder).State = System.Data.Entity.EntityState.Modified;
dbCtx.SaveChanges();
}
context = new LibraryContext();
return("Данные изменены");
}
catch (Exception ex)
{
throw ex;
}
}
public string Insert <Reading_Order>(Library.Models.Reading_Order order)
{
try
{
context.ReadingOrders.Add(order);
context.SaveChanges();
return("Запись была добавлена");
}
catch (Exception ex)
{
throw ex;
}
}
public string Delete <Reading_Order>(Library.Models.Reading_Order order)
{
try
{
var delBook = context.ReadingOrders.Find(order.Id);
context.ReadingOrders.Remove(delBook);
context.SaveChanges();
return("Запись удалена");
}
catch (Exception ex)
{
throw ex;
}
}
static public string FromReadingOrder(int Id_employee, int Id_book)
{
try
{
DBManager manager = new DBManager();
var readingOrder = new Reading_Order();
readingOrder.Id_employee = Id_employee;
readingOrder.Id_book = Id_book;
return(manager.Insert <Reading_Order>(readingOrder));
}
catch (Exception ex)
{
return("Не удалось добавить новую запись. Ошибка: " + ex.Message);
}
}
static public string FromReadingOrder(int Id)
{
try
{
DBManager manager = new DBManager();
var readingOrder = new Reading_Order();
Reading_Order order = new Reading_Order {
Id = Id
};
return(manager.Delete <Reading_Order>(order));
}
catch (Exception ex)
{
return("Не удалось удалить запись. Ошибка: " + ex.Message);
}
}