public static bool AddReview(ItemReview GetReview)
{
try
{
var dc = new ManagementContext();
if (GetReview.ReviewId > 0)
{
var review = dc.Reviews.Where(x => x.ReviewId == GetReview.ReviewId).FirstOrDefault();
review.comment = GetReview.comment;
review.title = GetReview.title;
review.rate = GetReview.rate;
review.StoreItem = review.StoreItem;
}
else
{
DataModels.Store.Review con = new DataModels.Store.Review();
con.rate = GetReview.rate;
int s = GetReview.StoreItemId;
con.StoreItem = dc.StoreItems.Where(x => x.StoreItemId == GetReview.StoreItemId).FirstOrDefault();
con.comment = GetReview.comment;
con.Member = dc.Members.Where(x => x.MemberId == GetReview.MemberId).FirstOrDefault();
con.title = GetReview.title;
con.ItemReviewed = dc.InvoiceItems.Where(x => x.InvoiceItemId == GetReview.InvoiceItemId).FirstOrDefault();
dc.Reviews.Add(con);
}
int c = dc.SaveChanges();
return c > 0;
}
catch (Exception exception)
{
ErrorDatabaseManager.AddException(exception, exception.GetType());
}
return false;
}
public ActionResult Review(StoreItem form)//RDN.Library.DataModels.Store.Review review
{
//http://localhost:8847/product-review/tdp1medium/10/e6cab01ce0044bd6a5d31970a7fe8dc0
ItemReview oReview = new ItemReview();
var memId = RDN.Library.Classes.Account.User.GetMemberId();
oReview.MemberId = memId;
oReview.rate = form.ratings;
oReview.StoreItemId = form.StoreItemId;
oReview.title = form.ReviewTitle;
oReview.comment = form.ReviewComment;
oReview.InvoiceItemId = form.InvoiceItemId;
oReview.ReviewId = form.ReviewId;
bool execute = RDN.Library.Classes.Store.ItemReview.AddReview(oReview);
return Redirect(Url.Content("~/?u=" + SiteMessagesEnum.re));
}
public static ItemReview DisplayReviewList(DataModels.Store.Review ReviewList)
{
ItemReview bl = new ItemReview();
bl.StoreItemId = ReviewList.StoreItem.StoreItemId;
bl.rate = ReviewList.rate;
bl.title = ReviewList.title;
bl.comment = ReviewList.comment;
bl.IsDeleted = ReviewList.IsDeleted;
bl.IsPublished = ReviewList.IsPublished;
bl.ReviewId = ReviewList.ReviewId;
bl.Created = ReviewList.Created;
if (ReviewList.Member != null)
{
bl.MemberId = ReviewList.Member.MemberId;
bl.userName = ReviewList.Member.DerbyName;
}
else
{
bl.userName = "******";
}
return bl;
}