public string Update <Issued_book>(int id, Library.Models.Issued_book book)
{
try
{
Library.Models.Issued_book newBook = context.IssuedBooks.Find(id);
if (newBook == null)
{
return("Такой книги нет");
}
using (var dbCtx = new LibraryContext())
{
newBook.Id_book = book.Id_book;
newBook.Id_employee = book.Id_employee;
newBook.Deadline = book.Deadline;
dbCtx.Entry(newBook).State = System.Data.Entity.EntityState.Modified;
dbCtx.SaveChanges();
}
context = new LibraryContext();
return("Данные изменены");
}
catch (Exception ex)
{
throw ex;
}
}
public string Insert <Issued_book>(Library.Models.Issued_book book)
{
try
{
context.IssuedBooks.Add(book);
context.SaveChanges();
return("Запись была добавлена");
}
catch (Exception ex)
{
throw ex;
}
}
public string Delete <Issued_book>(Library.Models.Issued_book book)
{
try
{
var delBook = context.IssuedBooks.Find(book.Id);
context.IssuedBooks.Remove(delBook);
context.SaveChanges();
return("Запись удалена");
}
catch (Exception ex)
{
throw ex;
}
}
static public string FromIssued(int Id)
{
try
{
DBManager manager = new DBManager();
var book = new Issued_book {
Id = Id
};
return(manager.Delete <Issued_book>(book));
}
catch (Exception ex)
{
return("Не удалось удалить запись. Ошибка: " + ex.Message);
}
}
static public string FromIssued(int Id_book, int Id_employee, string Deadline)
{
try
{
DBManager manager = new DBManager();
var book = new Issued_book();
book.Id_book = Id_book;
book.Id_employee = Id_employee;
book.Deadline = System.DateTime.Parse(Deadline);
//return manager.Update<Employee>(manager.GetIdElement(TablesNames.Employees, updateName), empl);
return(manager.Insert <Issued_book>(book));
}
catch (Exception ex)
{
return("Не удалось добавить новую запись. Ошибка: " + ex.Message);
}
}
