public static bool Insert(int Rating, string Subject, string Body) { try { using (RoundTheCornerEntities rc = new RoundTheCornerEntities()) { PL.TblReview newRow = new TblReview() { ReviewID = rc.TblReviews.Any() ? rc.TblReviews.Max(u => u.ReviewID) + 1 : 1, VendorID = 1, UserID = 1, Rating = Rating, Subject = Subject, Body = Body }; rc.TblReviews.Add(newRow); rc.SaveChanges(); return(true); } } catch (Exception ex) { throw ex; } }
public static ReviewModelDTO Create(TblReview review) { return(new ReviewModelDTO() { Id = review.Id, Reviewer = Create(review.Reviewer), Restaurant = Create(review.Restaurant), ReviewedDateTime = review.ReviewDateTime, Rating = review.Rating, ReviewText = review.ReviewText }); }
//[HostType("ASP.NET")] //[AspNetDevelopmentServerHost("C:\\Personal\\dev\\SignificantTrade\\SignificantTrade", "/")] //[UrlToTest("http://localhost:2625/")] public void DeleteAReview() { ITaxonRepository Taxon = new TaxonRepository(); TblReview r = Taxon.getReview(2); Taxon.deleteReview(r); TblReview r2 = Taxon.getReview(2); Assert.AreEqual(r2.Deleted, false); //Assert.AreEqual(count,0); }
public ReviewModelDTO AddReview(ReviewModelDTO newReview) { ReviewModelDTO ret = null; using (var db = new RestaurantReviewsContext()) { TblReview review = ModelFactory.Create(newReview); db.TblReview.Add(review); db.SaveChanges(); ret = ModelFactory.Create(review); } return(ret); }
//public int deleteReview(int id) //{ // return DB.Delete().From<Review>().Where(Review.IdColumn).IsEqualTo(id).Execute(); //} public void deleteReview(TblReview r) { r.DeletedDate = DateTime.Now; IReviewRepository reviews = new ReviewRepository(); int reviewID = r.Id; var paragraphs = reviews.getParagraphActionByReview(reviewID); foreach (var paragraphAction in paragraphs) { DB.Delete(paragraphAction); } DB.Save(r); DB.Delete(r); }
public ReviewModelDTO DeleteReview(int id) { ReviewModelDTO ret = null; using (var db = new RestaurantReviewsContext()) { TblReview review = db.TblReview.Find(id); if (review != null) { db.TblReview.Remove(review); db.SaveChanges(); ret = ModelFactory.Create(review); } } return(ret); }
public static bool Update(ReviewModel review) { try { if (review.ReviewID != 0) { using (RoundTheCornerEntities rc = new RoundTheCornerEntities()) { TblReview tblReview = rc.TblReviews.FirstOrDefault(u => u.ReviewID == review.ReviewID); if (tblReview != null) { tblReview.ReviewID = review.ReviewID; tblReview.UserID = review.UserID; tblReview.VendorID = review.VendorID; tblReview.Rating = review.Rating; tblReview.Subject = review.Subject; tblReview.Body = review.Body; rc.SaveChanges(); return(true); } else { throw new Exception("Review was not found"); } } } else { throw new Exception("Must have a valid id"); } } catch (Exception ex) { throw ex; } }
public int SaveReview(TblReview r) { return(DB.Save(r)); }
public static int InsertParagraphActionForm(FormCollection collection) { IReviewRepository reviews = new ReviewRepository(); IGenericRepository generics = new GenericRepository(); ParagraphAction pa = new ParagraphAction(); int palibid = int.Parse(collection["PALibID"]); int reviewid = int.Parse(collection["ReviewID"]); pa.PALibID = palibid; pa.DateStarted = DateTime.Parse(collection["pda_started_date"].ToString()); pa.DeadlineDate = DateTime.Parse(collection["pda_deadline_date"].ToString()); pa.MeetingID = int.Parse(collection["meetings"]); pa.ReviewID = reviewid; //string concern = collection["concerns"].ToString();) if (collection["concerns"] != null) { string concern = collection["concerns"].ToString(); switch(concern) { case UpdateUtils.URGENT_CONCERN: pa.ConcernID = UpdateUtils.URGENT_CONCERN_ID; break; case UpdateUtils.POSSIBLE_CONCERN: pa.ConcernID = UpdateUtils.POSSIBLE_CONCERN_ID; break; case UpdateUtils.LEAST_CONCERN: pa.ConcernID = UpdateUtils.LEAST_CONCERN_ID; break; case UpdateUtils.NOT_CLASSIFIED: pa.ConcernID = UpdateUtils.NOT_CLASSIFIED_ID; break; } TblReview review = reviews.getSingleReviewEdit(reviewid); review.ConcernID = pa.ConcernID; DB.Save(review); generics.resetCurrentConcernForReview(reviewid); pa.CurrentConcern = true; } else { pa.ConcernID = UpdateUtils.NOT_CLASSIFIED_ID; pa.CurrentConcern = true; } string completed = collection["completed"]; if ((completed!=null) && (completed.Equals("on"))) { DateTime dateCompleted = DateTime.Now; if (collection["pda_completed_date"] != null && collection["pda_completed_date"].Length > 0) { dateCompleted = DateTime.Parse(collection["pda_completed_date"]); pa.CompletedDate = dateCompleted; } else { pa.CompletedDate = dateCompleted; } pa.Completed = true; } pa.DateAdded = DateTime.Now; return reviews.SavePA(pa); }
public int SaveReview(TblReview r) { return DB.Save(r); }
public void Insert(int? PhaseID,int? CountryID,int? TaxonID,int? TaxonLevel,DateTime? DateAdded,int? AddedBy,int? KingdomID,bool Deleted,DateTime? DeletedDate,int? CommitteeID,DateTime? ReviewDate,int? ReviewType,int? ConcernID,int? OldSigMainID) { TblReview item = new TblReview(); item.PhaseID = PhaseID; item.CountryID = CountryID; item.TaxonID = TaxonID; item.TaxonLevel = TaxonLevel; item.DateAdded = DateAdded; item.AddedBy = AddedBy; item.KingdomID = KingdomID; item.Deleted = Deleted; item.DeletedDate = DeletedDate; item.CommitteeID = CommitteeID; item.ReviewDate = ReviewDate; item.ReviewType = ReviewType; item.ConcernID = ConcernID; item.OldSigMainID = OldSigMainID; item.Save(UserName); }
public int DeleteTblReview(TblReview rv) { return(Rd.DeleteReview(rv)); }
public int UpdateTblReview(TblReview rv) { return(Rd.UpdateReview(rv)); }
public int InsertTblReview(TblReview rv) { return(Rd.InsertReview(rv)); }