public ActionResult SpamReport(int nid, string SpamComments)
{
var emailid = User.Identity.Name.ToString();
Users obj = dbobj.Users.Where(x => x.EmailID == emailid).FirstOrDefault();
var oldspam = dbobj.SpamTable.Where(x => x.NoteID == nid && x.SpamBy == obj.ID).FirstOrDefault();
var book = dbobj.SellerNotes.Where(x => x.ID == nid).FirstOrDefault();
Users sellerobj = dbobj.Users.Where(x => x.ID == book.SellerID).FirstOrDefault();
if (oldspam == null) //New Spam
{
SpamTable spam = new SpamTable();
spam.NoteID = nid;
spam.SpamBy = obj.ID;
spam.Comments = SpamComments;
spam.CreatedDate = DateTime.Now;
dbobj.SpamTable.Add(spam);
dbobj.SaveChanges();
// Adding Ratings in note table
int total_spams = dbobj.SpamTable.Where(x => x.ID == nid).Count();
book.TotalSpams = total_spams;
dbobj.Entry(book).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
// ------------------------------------------------------------
NotifyAdmin(obj.FirstName, book.Title, sellerobj.FirstName);
return(RedirectToAction("MyDownloads"));
}
else //Update Old Spam
{
oldspam.Comments = SpamComments;
dbobj.Entry(oldspam).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
NotifyAdmin(obj.FirstName, book.Title, sellerobj.FirstName);
return(RedirectToAction("MyDownloads"));
}
}
public ActionResult DeleteSpamReports(int sid)
{
SpamTable report = dbobj.SpamTable.Where(x => x.ID == sid).FirstOrDefault();
int nid = report.NoteID;
dbobj.SpamTable.Remove(report);
dbobj.SaveChanges();
var book = dbobj.SellerNotes.Where(x => x.ID == nid).FirstOrDefault();
int total_spams = dbobj.SpamTable.Where(x => x.NoteID == nid).Count();
book.TotalSpams = total_spams;
dbobj.Entry(book).State = System.Data.Entity.EntityState.Modified;
dbobj.SaveChanges();
return(RedirectToAction("SpamReports"));
}
