public Post( int postId, int userId, int textBookId, ActionBy actionBy, int price, BookCondition bookCondition, int isTransacting, int isActive, int isDeleted, DateTime createdDate, DateTime modifiedDate) { PostId = postId; UserId = userId; TextBookId = textBookId; ActionBy = actionBy; Price = price; BookCondition = bookCondition; IsTransacting = isTransacting; IsActive = isActive; IsDeleted = isDeleted; CreatedDate = createdDate; ModifiedDate = modifiedDate; }
public void AddBookConditionTest() { BookCondition testBC = new BookCondition(new Book("Test Author", "1234567890", "Test Title", "2019")); dataRepository.AddBookCondition(testBC); Assert.AreEqual(testBC, dataRepository.GetBookCondition(0)); }
public async Task <IActionResult> PutBookCondition([FromRoute] int id, [FromBody] BookCondition bookCondition) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != bookCondition.BookConditionId) { return(BadRequest()); } _context.Entry(bookCondition).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!BookConditionExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> Edit(int id, [Bind("BookConditionId,Condition")] BookCondition bookCondition) { if (id != bookCondition.BookConditionId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(bookCondition); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!BookConditionExists(bookCondition.BookConditionId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(bookCondition)); }
public async Task <IActionResult> Create([Bind("BookConditionId,Condition")] BookCondition bookCondition) { if (ModelState.IsValid) { _context.Add(bookCondition); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(bookCondition)); }
public async Task <IActionResult> PostBookCondition([FromBody] BookCondition bookCondition) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.BookCondition.Add(bookCondition); await _context.SaveChangesAsync(); return(CreatedAtAction("GetBookCondition", new { id = bookCondition.BookConditionId }, bookCondition)); }
// POST: odata/BookConditions public IHttpActionResult Post(BookCondition bookCondition) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.BookConditions.Add(bookCondition); db.SaveChanges(); return(Created(bookCondition)); }
public void UpdateBookCondition(List <string> barcodes, BookCondition bookCondition, DateTime damLostDate) { foreach (var barcode in barcodes) { var book = Container.Books.Where(x => x.Barcode == barcode).FirstOrDefault(); if (book != null) { book.BookCondition_Id = bookCondition.Id; book.DamLostDate = damLostDate; Container.UpdateObject(book); } } Container.SaveChanges(); }
// DELETE: odata/BookConditions(5) public IHttpActionResult Delete([FromODataUri] int key) { BookCondition bookCondition = db.BookConditions.Find(key); if (bookCondition == null) { return(NotFound()); } db.BookConditions.Remove(bookCondition); db.SaveChanges(); return(StatusCode(HttpStatusCode.NoContent)); }
public void DeleteBookConditionByBCTest() { List <BookCondition> testList = MakeBookConditionList(); foreach (var bc in testList) { dataRepository.AddBookCondition(bc); } BookCondition testBC = dataRepository.GetBookCondition(0); dataRepository.DeleteBookCondition(testBC); dataRepository.GetBook(0); }
public void SearchAvailableBooksTest() { Random rand = new Random(); dataService = new DataService(new DataRepository(new DataContext(), new RandomFiller(5, 5))); dataService.Fill(); BookCondition randomBC = dataService.GetBookCondition(rand.Next(5)); dataService.CreateEvent(Event.Type.Borrow, randomBC, dataService.GetClient(rand.Next(5))); foreach (var book in dataService.SearchAvailableBooks()) { Assert.AreNotSame(randomBC.Book, book); } }
public void UpdateBookConditionTest() { List <BookCondition> testList = MakeBookConditionList(); foreach (var bc in testList) { dataRepository.AddBookCondition(bc); } BookCondition testBC = new BookCondition(new Book("Test 3", "1234567890", "Test 3", "1999")); int bcNumber = 0; dataRepository.UpdateBookCondition(bcNumber, testBC); Assert.AreEqual(testBC, dataRepository.GetBookCondition(bcNumber)); }
public static Post getPost(int postId) { Post post = null; try { DataAccess da = new DataAccess(); DataTable dt = da.select(String.Format("PostId = '{0}' AND IsDeleted = 0", postId), "Posts", NumRows: 1); if (dt != null && dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; int profileId = Convert.ToInt32(row["UserId"]); int textbookId = Convert.ToInt32(row["TextBookId"]); ActionBy actionBy = (ActionBy)Convert.ToInt32(row["ActionBy"]); int price = Convert.ToInt32(row["Price"]); BookCondition bookCondition = (BookCondition)Convert.ToInt32(row["BookCondition"]); int isTransacting = Convert.ToInt32(row["IsTransacting"]); int isActive = Convert.ToInt32(row["IsActive"]); int isDeleted = Convert.ToInt32(row["IsDeleted"]); DateTime createdDate = (DateTime)row["CreatedDate"]; DateTime modifiedDate = (DateTime)row["ModifiedDate"]; post = new Post( postId, profileId, textbookId, actionBy, price, bookCondition, isTransacting, isActive, isDeleted, createdDate, modifiedDate ); } } catch (Exception ex) { Console.Write(ex.Message + " " + ex.StackTrace); } return(post); }
public string GetConditionDescription(BookCondition cond) { switch (cond) { case BookCondition.New: return("New"); case BookCondition.Fine: return("Fine"); case BookCondition.VeryGood: return("Very Good"); case BookCondition.Good: return("Good"); case BookCondition.Fair: return("Fair"); case BookCondition.Poor: return("Poor"); default: return(string.Empty); } }
public IHttpActionResult Patch([FromODataUri] int key, Delta <BookCondition> patch) { Validate(patch.GetEntity()); if (!ModelState.IsValid) { return(BadRequest(ModelState)); } BookCondition bookCondition = db.BookConditions.Find(key); if (bookCondition == null) { return(NotFound()); } patch.Patch(bookCondition); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!BookConditionExists(key)) { return(NotFound()); } else { throw; } } return(Updated(bookCondition)); }
public void ComplexTypesSerializationTest() { string filename = "complexTestWrite.txt"; BookCondition bcOrig = new BookCondition(new Book("A", "B", "C", "D")); Event eventOrig = new Event(Event.Type.Borrow, bcOrig, new Client("X", "Y", "Z")); { Serializator ser = new Serializator(); ser.Add(bcOrig); ser.Add(eventOrig); ser.SetFilename(filename); ser.Write(); } { Serializator ser = new Serializator(); ser.SetFilename(filename); ser.Read(); BookCondition bcNew = (BookCondition)ser.GetNext(); Event eventNew = (Event)ser.GetNext(); Assert.AreEqual(bcOrig.ToString(), bcNew.ToString()); Assert.AreEqual(eventOrig.ToString(), eventNew.ToString()); Assert.AreSame(bcNew.Book, eventNew.BookCondition.Book); Assert.AreSame(bcNew, eventNew.BookCondition); } }
public JsonResult UpdateBookCondition(List <string> barcodes, BookCondition bookCondition, DateTime damLostDate) { bookRepository.UpdateBookCondition(barcodes, bookCondition, damLostDate); return(Json("")); }
public static Post findMatchingPost(Post post) { Post matchingPost = null; try { var counterparty = post.ActionBy == ActionBy.Buyer ? ActionBy.Seller : ActionBy.Buyer; string query = String.Format("UserId <> {0} AND TextBookId = {1} AND ActionBy = {2} " + "AND IsTransacting = 0 AND IsActive = 1 AND IsDeleted = 0", post.UserId, post.TextBookId, (int)counterparty ); List <SortColumn> sortColumns = new List <SortColumn>(); if (post.ActionBy == ActionBy.Buyer) //buyer { query += String.Format("AND Price <= {0} AND BookCondition >= {1}", post.Price, (int)post.BookCondition ); sortColumns.Add(new SortColumn("Price", "ASC")); } else //seller { query += String.Format("AND Price >= {0} AND BookCondition <= {1}", post.Price, (int)post.BookCondition ); sortColumns.Add(new SortColumn("Price", "DESC")); } DataAccess da = new DataAccess(); DataTable dt = da.select(query, "Posts", NumRows: 1, SortColumns: sortColumns); if (dt != null && dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; int postId = Convert.ToInt32(row["PostId"]); int profileId = Convert.ToInt32(row["UserId"]); int textBookId = Convert.ToInt32(row["TextBookId"]); ActionBy actionBy = (ActionBy)Convert.ToInt32(row["ActionBy"]); int price = Convert.ToInt32(row["Price"]); BookCondition bookCondition = (BookCondition)Convert.ToInt32(row["BookCondition"]); int isTransacting = Convert.ToInt32(row["IsTransacting"]); int isActive = Convert.ToInt32(row["IsActive"]); int isDeleted = Convert.ToInt32(row["IsDeleted"]); DateTime createdDate = (DateTime)row["CreatedDate"]; DateTime modifiedDate = (DateTime)row["ModifiedDate"]; matchingPost = new Post( postId, profileId, textBookId, actionBy, price, bookCondition, isTransacting, isActive, isDeleted, createdDate, modifiedDate ); } } catch (Exception ex) { Console.Write(ex.Message + " " + ex.StackTrace); } return(matchingPost); }