public string AddOrUpdateBookToDatabase(Book newBook) { string res; Table <DAL.Book> bookTable = GetBookTable(); var matchedBook = (from bk in bookTable where bk.bookID == newBook.BookID select bk).SingleOrDefault(); if (matchedBook == null) // Add { try { res = AddOrUpdateBookDetails(newBook.GetBookDetails()); if (res != "") { return(res); } DAL.Book addData = new DAL.Book(); Random data = new Random(); addData.bookID = data.Next().ToString(); // Dummy id init addData.location = newBook.Location; addData.bookStatusCode = GetBookStatusCodeFromStatusName(newBook.Status); addData.bookDetailsID = GetBookDetailsIDFromBookName(newBook.GetBookDetails().Name); bookTable.InsertOnSubmit(addData); bookTable.Context.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } } else if (matchedBook != null) // Update { try { res = AddOrUpdateBookDetails(newBook.GetBookDetails()); if (res != "") { return(res); } matchedBook.location = newBook.Location; matchedBook.bookStatusCode = GetBookStatusCodeFromStatusName(newBook.Status); matchedBook.bookDetailsID = GetBookDetailsIDFromBookName(newBook.GetBookDetails().Name); db.SubmitChanges(); } catch (Exception ex) { return(ex.Message); } } return(""); }
public Out(DAL.Out i, DAL.Book book, DAL.Chitatel st, DAL.Outtype ot) { Id = i.Id; Id_book = i.Id_book; Id_chit = i.Id_chit; Date = i.Date; Name_book = book.Name; Name_student = st.FIO; Outtype_id = i.Outtype_id; Outtype_name = ot.Name; }
public Book(DAL.Book i, DAL.Izdatelstvo iz, DAL.Book_status st, DAL.Rubrika r) { Name = i.Name; Autor = i.Autor; Id = i.Id; God = i.God; Annot = i.Annot; Rubrika_id = i.Rubrika_id; Rubrika_name = r.Name; Status_id = i.Status_id; Status_name = st.Name; Izdatelstvo_id = i.Izdatelstvo_id; Izdatelstvo_name = iz.Name; }