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;
}
