public int dislike(int cmtId)//点灭
{
int user_auth = (Convert.ToBoolean(Session["user_auth"])) ? 1 : 0;
if (user_auth == 0)
{
return(-1);
}
int user_id = Convert.ToInt32(Session["user_id"].ToString());
int ID = cmtId;
int exist = db.Database.SqlQuery <int>("select count(*) from COMMENT_FEEDBACK where USER_ID=" + user_id.ToString() + " and COMMENT_ID=" + ID.ToString()).FirstOrDefault();
if (exist > 0)//已经对该评论有点赞或点灭
{
return(0);
}
COMMENT_FEEDBACK temp = new COMMENT_FEEDBACK();//新建点灭记录
temp.USER_ID = user_id;
temp.COMMENT_ID = ID;
temp.ATTITUDE = "DISLIKE";
temp.TIME = DateTime.Now.ToString();
db.COMMENT_FEEDBACK.Add(temp);
COMMENTS comment = db.COMMENTS.Find(ID);//获得该评论
int after = Convert.ToInt32(comment.TOTAL_DISLIKE) + 1;
comment.TOTAL_DISLIKE = after.ToString();
comment.TOTAL = comment.TOTAL - 1;
db.SaveChanges();
return(0);
}
//向数据库中添加用户的评论
public void AddComment(string user_id, string video_id, string comment_content)
{
COMMENTS cOMMENTS = new COMMENTS();
cOMMENTS.COMMENT_CONTENT = comment_content;
cOMMENTS.LIKES_NUM = 0;
cOMMENTS.COMMENT_ID = "0";
db.COMMENTS.Add(cOMMENTS);
db.SaveChanges();
SEND_COMMENT sEND_COMMENT = new SEND_COMMENT();
sEND_COMMENT.USER_ID = user_id;
var commentid = from c in db.COMMENTS
orderby c.COMMENT_ID descending
select c;
sEND_COMMENT.COMMENT_ID = commentid.ToList()[0].COMMENT_ID;
db.SEND_COMMENT.Add(sEND_COMMENT);
db.SaveChanges();
HAS_COMMENT hAS_COMMENT = new HAS_COMMENT();
hAS_COMMENT.VIDEO_ID = video_id;
var commentid2 = from c in db.COMMENTS
orderby c.COMMENT_ID descending
select c;
hAS_COMMENT.COMMENT_ID = commentid2.ToList()[0].COMMENT_ID;
hAS_COMMENT.COMMENT_TIME = DateTime.Now;
db.HAS_COMMENT.Add(hAS_COMMENT);
db.SaveChanges();
}
public void Publishcomt(int musicid, string value)
{
var id = (int)Session["account"];
var comments = new COMMENTS();
comments.MUSICID = musicid;
var maxid = db.Database.SqlQuery <int>("select max(COMMENTNUMBER) from COMMENTS").FirstOrDefault();
maxid++;
comments.COMMENTNUMBER = maxid;
comments.USERID = id;
comments.CONTENT = value;
comments.LIKES = 0;
db.COMMENTS.Add(comments);
db.SaveChanges();
// return View();
}
//Comment book
public void SetComment(int bookId, int grade, string content)
{
COMMENTS temp = new COMMENTS();
int max = db.Database.SqlQuery <int>("select max(ID) from COMMENTS").FirstOrDefault();
max++;//新评论的ID
temp.ID = max;
temp.USER_ID = user_id;
temp.BOOK_ID = bookId;
temp.CONTENT = content;
temp.TIME = DateTime.Now.ToString("u");
temp.SCORE = grade;
temp.TOTAL_LIKE = 0.ToString();
temp.TOTAL_DISLIKE = 0.ToString();
temp.TOTAL_LIKE = "0";
db.COMMENTS.Add(temp);
db.SaveChanges();
}
