public ObservableCollection <Pages.DocsTable> TestDocsTableOnlyBooks()
{
ObservableCollection <Pages.DocsTable> temp_table = new ObservableCollection <Pages.DocsTable>();
var load_user_docs = from b in db.documents
select new
{
b.Id,
b.Title,
b.DocType,
b.IsReference
};
foreach (var element in load_user_docs)
{
checkouts checkoutInfo = GetOwnerInfo(element.Id);
Pages.DocsTable row = new Pages.DocsTable
{
docID = element.Id,
docTitle = element.Title,
docType = TypeString(element.DocType),
docOwnerID = checkoutInfo == null ? -1 : checkoutInfo.userID,
dateTaked = checkoutInfo == null ? DateTime.Now : (System.DateTime)checkoutInfo.dateTaked,
timeToBack = checkoutInfo == null ? DateTime.Now : (System.DateTime)checkoutInfo.timeToBack,
isReference = element.IsReference
};
temp_table.Add(row);
}
return(temp_table);
}
/// <summary>
/// Change fields in DB when some user check out docs.
/// Start timer for check out and get reference for book
/// on it's owner.
/// </summary>
/// <param name="docID"></param>
protected void SetCheckOut(int docID, int user_id, int weeks)
{
System.DateTime time = System.DateTime.Now;
checkouts chk = new checkouts();
chk.userID = user_id;
chk.bookID = docID;
chk.isReturned = false;
chk.dateTaked = time;
chk.timeToBack = time.AddDays(weeks * 7);
uDB.checkouts.InsertOnSubmit(chk);
uDB.SubmitChanges();
}
