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