protected void btnSubmit_Click(object sender, EventArgs e)
{
string comment = txtComment.Text;
int point = Int32.Parse(drRate.SelectedValue);
KifuRating kifuRating = new KifuRating(KifuID, Session["user"].ToString(), point, comment);
FavouriteKifuService.RatingAndCommnent(kifuRating);
}
public DataTable Select(KifuRating kifuRating)
{
string sql = "SELECT * FROM KifuRating WHERE KifuID=@kifuID AND Username=@username";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@kifuID", kifuRating.KifuID);
parameters[1] = new SqlParameter("@username", kifuRating.Username);
return(SqlHelper.ExecuteDataTable(sql, parameters));
}
public int Insert(object obj)
{
KifuRating kifuRating = (KifuRating)obj;
string sql = "INSERT INTO KifuRating VALUES(@kifuID,@username,@ratePoint,@comment)";
SqlParameter[] parameters = new SqlParameter[4];
parameters[0] = new SqlParameter("@kifuID", kifuRating.KifuID);
parameters[1] = new SqlParameter("@username", kifuRating.Username);
parameters[2] = new SqlParameter("@ratePoint", kifuRating.RatePoint);
parameters[3] = new SqlParameter("@comment", kifuRating.Comment);
return(SqlHelper.ExecuteNonQuery(sql, parameters));
}
public int Update(object obj)
{
KifuRating kifuRating = (KifuRating)obj;
string sql = "UPDATE KifuRating SET RatePoint=@ratePoint, Comment=@comment" +
" WHERE KifuID=@kifuID AND Username=@username";
SqlParameter[] parameters = new SqlParameter[4];
parameters[0] = new SqlParameter("@kifuID", kifuRating.KifuID);
parameters[1] = new SqlParameter("@username", kifuRating.Username);
parameters[2] = new SqlParameter("@ratePoint", kifuRating.RatePoint);
parameters[3] = new SqlParameter("@comment", kifuRating.Comment);
return(SqlHelper.ExecuteNonQuery(sql, parameters));
}
public static int RatingAndCommnent(KifuRating kifuRating)
{
KifuRatingDAL dal = new KifuRatingDAL();
if (dal.Select(kifuRating).Rows.Count != 1)
{
return(dal.Insert(kifuRating));
}
else
{
return(dal.Update(kifuRating));
}
}
