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