public bool Add(LibraryBookBLL item, out string serverSideError)
{
if (item.IsValid)
{
using (ProtoLibEntities context = new ProtoLibEntities())
{
if (DatabaseDependantValidation(item, context, out serverSideError))
{
LibraryBook newLibBook = new LibraryBook();
CrossLayerEntityConverter.LibraryBookBllToDal(context, item, newLibBook);
context.LibraryBooks.AddObject(newLibBook);
context.SaveChanges();
return true;
}
}
return false;
}
else
{
serverSideError = "The LibraryBook object is invalid";
return false;
}
}
public LibraryBookBLL GetByID(int id)
{
using (ProtoLibEntities context = new ProtoLibEntities())
{
LibraryBook libBook = (from lb in context.LibraryBooks
where lb.BookID == id
select lb).SingleOrDefault();
if (libBook != null)
{
LibraryBookBLL retLibBook = new LibraryBookBLL();
CrossLayerEntityConverter.LibraryBookDalToBll(context, retLibBook, libBook);
return retLibBook;
}
}
return null;
}
private bool DatabaseDependantValidation(LibraryBookBLL bllLibBook, ProtoLibEntities context,
out string error,
int idToExclude = 0)
{
error = null;
return true;
}
public bool Update(LibraryBookBLL newItem, out string serverSideError)
{
if (newItem.IsValid)
{
using (ProtoLibEntities context = new ProtoLibEntities())
{
if (DatabaseDependantValidation(newItem, context, out serverSideError, newItem.ItemID))
{
LibraryBook dalLibBook = (from lb in context.LibraryBooks
where lb.BookID == newItem.ItemID
select lb).Single();
CrossLayerEntityConverter.LibraryBookBllToDal(context, newItem, dalLibBook);
context.SaveChanges();
Debug.Assert(serverSideError == null);
return true;
}
else
return false;
}
}
serverSideError = "Item is in an invalid state!";
return false;
}
public List<LibraryBookBLL> GetPreviousItems(int beforeItemID, int numItems)
{
List<LibraryBookBLL> retList = new List<LibraryBookBLL>();
using (ProtoLibEntities context = new ProtoLibEntities())
{
var dalLibBooks = (from lb in context.LibraryBooks
where lb.BookID < beforeItemID
orderby lb.BookID descending
select lb).Take(numItems);
LibraryBookBLL bllLibBook = null;
foreach (LibraryBook dalLibBook in dalLibBooks)
{
bllLibBook = new LibraryBookBLL();
CrossLayerEntityConverter.LibraryBookDalToBll(context, bllLibBook, dalLibBook);
retList.Add(bllLibBook);
}
}
retList.Reverse();
return retList;
}
public List<LibraryBookBLL> GetFirstItems(int numItems)
{
List<LibraryBookBLL> retList = new List<LibraryBookBLL>();
using (ProtoLibEntities context = new ProtoLibEntities())
{
var dalLibBooks = (from lb in context.LibraryBooks
orderby lb.BookID
select lb).Take(numItems);
LibraryBookBLL bllLibBook = null;
foreach (LibraryBook dalLibBook in dalLibBooks)
{
bllLibBook = new LibraryBookBLL();
CrossLayerEntityConverter.LibraryBookDalToBll(context, bllLibBook, dalLibBook);
retList.Add(bllLibBook);
}
}
return retList;
}
public static void LibraryBookDalToBll(ProtoLibEntities context, LibraryBookBLL bllLibBook, LibraryBook dalLibBook)
{
bllLibBook.ItemID = dalLibBook.BookID;
bllLibBook.Price = dalLibBook.Price;
bllLibBook.ObtainedFrom = dalLibBook.ObtainedFrom;
bllLibBook.BookDetailsId = dalLibBook.BookInfoID;
bllLibBook.Status = (BookStatusBLL)(dalLibBook.StatusID);
}
public static void LibraryBookBllToDal(ProtoLibEntities context, LibraryBookBLL bllLibBook, LibraryBook dalLibBook)
{
dalLibBook.Price = bllLibBook.Price;
dalLibBook.ObtainedFrom = bllLibBook.ObtainedFrom;
dalLibBook.BookDetails = (from book in context.BookDetailsSet where book.BookDetailsID == bllLibBook.BookDetailsId select book).SingleOrDefault();
dalLibBook.BookStatus = (from st in context.BookStatus1 where st.StatusID == (int)bllLibBook.Status select st).Single();
//TODO: Implement branch stuff
dalLibBook.Branch = (from br in context.Branches where br.BranchID == 100 select br).First();
}
