public ActionResult AddReview(string Comments, string rate, string DonwloadID)
{
if (Comments != "" && rate != null)
{
int IDofDownload = int.Parse(DonwloadID);
var reviewRecored = db.SellerNotesReviews.Where(m => m.AgainstDownloadsID == IDofDownload).SingleOrDefault();
if (reviewRecored != null)
{
reviewRecored.Ratings = int.Parse(rate);
reviewRecored.Comments = Comments;
reviewRecored.ModifiedBy = reviewRecored.ReviewedByID;
reviewRecored.ModifiedDate = DateTime.Now;
db.SellerNotesReviews.Attach(reviewRecored);
db.Entry(reviewRecored).State = EntityState.Modified;
db.SaveChanges();
}
else
{
var downloadRecored = db.Downloads.Where(m => m.id == IDofDownload).SingleOrDefault();
var review = new SellerNotesReview();
review.NoteID = downloadRecored.NoteID;
review.ReviewedByID = downloadRecored.Downloader;
review.AgainstDownloadsID = downloadRecored.id;
review.Ratings = int.Parse(rate);
review.Comments = Comments;
review.CreatedDate = DateTime.Now;
review.CreatedBy = downloadRecored.Downloader;
review.IsActive = true;
db.SellerNotesReviews.Add(review);
db.SaveChanges();
}
}
else
{
TempData["addReview"] = DonwloadID;
}
return(RedirectToAction("MyDonwloads", "User"));
}
public ActionResult AddReview(int id)
{
SellerNotesReview sellerNotesReview = new SellerNotesReview();
//Auth User
User user = db.Users.FirstOrDefault(x => x.Email == User.Identity.Name);
//Find Note in Download Table
var download = db.Downloads.Where(x => x.ID == id).FirstOrDefault();
int rate = Convert.ToInt32(Request.Form["rate"]);
string comment = Request.Form["cmt"];
if (rate == 0)
{
return(Content("Please give Rating"));
}
if (string.IsNullOrEmpty(comment))
{
return(Content("Please Enter Comment"));
}
//Save Info on SellerNoteReview Table
sellerNotesReview.NoteID = download.NoteID;
sellerNotesReview.ReviewedByID = user.ID;
sellerNotesReview.AgainstDownloadsID = download.ID;
sellerNotesReview.Ratings = rate;
sellerNotesReview.Comments = comment;
sellerNotesReview.CreatedDate = DateTime.Now;
sellerNotesReview.CreatedBy = user.ID;
sellerNotesReview.ModifiedDate = DateTime.Now;
sellerNotesReview.ModifiedBy = user.ID;
sellerNotesReview.IsActive = true;
db.SellerNotesReviews.Add(sellerNotesReview);
db.SaveChanges();
return(RedirectToAction("Index", "MyDownload"));
}
public ActionResult Review(int id, string comments, int rate)
{
Download objdownload = dbobj.Downloads.Where(x => x.NoteId == id).FirstOrDefault();
var Emailid = User.Identity.Name.ToString();
User user = dbobj.Users.Where(x => x.EmailId == Emailid).FirstOrDefault();
SellerNote sellrnote = dbobj.SellerNotes.Where(x => x.Id == id).FirstOrDefault();
SellerNotesReview objseller = dbobj.SellerNotesReviews.Where(x => x.NoteId == sellrnote.Id && x.ReviewedByid == user.ID).FirstOrDefault();
if (objseller != null)
{
objseller.Ratings = rate;
objseller.Comments = comments;
objseller.ModifiedBy = user.ID;
objseller.Modifieddate = DateTime.Now;
dbobj.Entry(objseller).State = EntityState.Modified;
dbobj.SaveChanges();
}
else
{
SellerNotesReview objseller1 = new SellerNotesReview
{
NoteId = sellrnote.Id,
Ratings = rate,
Comments = comments,
ReviewedByid = user.ID,
AgainstDownloadsId = objdownload.Id,
CreatedBy = objdownload.downloader,
CreatedDate = DateTime.Now,
IsActive = true
};
dbobj.SellerNotesReviews.Add(objseller1);
dbobj.SaveChanges();
}
return(RedirectToAction("Dashboard", "Notes"));
}
public ActionResult AddReview(SellerNotesReview notereview)
{
// check if comment is null or not
if (String.IsNullOrEmpty(notereview.Comments))
{
return(RedirectToAction("MyDownloads"));
}
// check if rating is between 1 to 5
if (notereview.Ratings < 1 || notereview.Ratings > 5)
{
return(RedirectToAction("MyDownloads"));
}
// get Download object for check if user is downloaded note or not
var notedownloaded = _dbcontext.Downloads.Where(x => x.ID == notereview.AgainstDownloadsID && x.IsAttachementDownload == true).FirstOrDefault();
// user can provide review after downloading the note
if (notedownloaded != null)
{
//get logged in user
var user = _dbcontext.Users.Where(x => x.EmailID == User.Identity.Name).FirstOrDefault();
// check if user already provided review or not
var alreadyprovidereview = _dbcontext.SellerNotesReviews.Where(x => x.AgainstDownloadsID == notereview.AgainstDownloadsID && x.IsActive == true).FirstOrDefault();
// if user not provide review then add review
if (alreadyprovidereview == null)
{
// create a sellernotesreview object and initialize it
SellerNotesReview review = new SellerNotesReview();
review.NoteID = notereview.NoteID;
review.AgainstDownloadsID = notereview.AgainstDownloadsID;
review.ReviewedByID = user.UserID;
review.Ratings = notereview.Ratings;
review.Comments = notereview.Comments;
review.CreatedDate = DateTime.Now;
review.CreatedBy = user.UserID;
review.IsActive = true;
// save sellernotesreview into database
_dbcontext.SellerNotesReviews.Add(review);
_dbcontext.SaveChanges();
return(RedirectToAction("MyDownloads"));
}
// if user is already provided review then edit it
else
{
alreadyprovidereview.Ratings = notereview.Ratings;
alreadyprovidereview.Comments = notereview.Comments;
alreadyprovidereview.ModifiedDate = DateTime.Now;
alreadyprovidereview.ModifiedBy = user.UserID;
// update review and save in database
_dbcontext.Entry(alreadyprovidereview).State = EntityState.Modified;
_dbcontext.SaveChanges();
return(RedirectToAction("MyDownloads"));
}
}
return(RedirectToAction("MyDownloads"));
}
