public ActionResult Rate(int?itemid, string userid)
{
var currentUser = manager.FindById(User.Identity.GetUserId());
Rated rated = new Rated();
var listItem = db.List_Items.Find(itemid);
var obj = db.RatedList.Where(r => r.ListItem.ID == (int)itemid && r.User.Id == currentUser.Id).ToList();
if (obj.Count == 0)
{
ListUserHasRated luhr = new ListUserHasRated();
rated.ListItem = listItem;
rated.User = currentUser;
listItem.Rating += 1;
luhr.List = db.TopTenList.Find(listItem.TTList.ID);
luhr.User = currentUser;
db.UserRatedLists.Add(luhr);
db.RatedList.Add(rated);
db.SaveChanges();
return(Redirect("Index"));
}
else
{
return(View(obj));
}
}
public void InvokeRated()
{
if (_rated)
{
return;
}
_rated = true;
Rated?.Invoke();
}
public static Rated getRatedByID(int id)
{
string sql = "SELECT * FROM dbo.Rated WHERE id = @id";
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@id", SqlDbType.Int),
};
param[0].Value = id;
DataTable dt = DataAccess.ReadDataBySQLWithParameter(sql, param);
Rated r = new Rated();
foreach (DataRow dr in dt.Rows)
{
r.ID = Convert.ToInt32(dr["id"].ToString());
r.Title = dr["title"].ToString();
r.Image = dr["image"].ToString();
}
return(r);
}
public void OnPointerClick(PointerEventData eventData)
{
Rated?.Invoke(_starNumber);
}
