protected void Page_Load(object sender, EventArgs e)
{
KifuID = Int32.Parse(Request.QueryString["KifuID"]);
Content = KifuService.GetKifuContent(KifuID);
IsOwnKifu = false;
if (Session["user"] != null)
{
favourite = new FavouriteKifu(KifuID, Session["user"].ToString());
IsFavour = FavouriteKifuService.IsFavour(favourite);
IsOwnKifu = KifuService.IsOwnKifu(Session["user"].ToString(), KifuID);
}
if (!IsOwnKifu)
{
txtGameName.ReadOnly = true;
txtGameEvent.ReadOnly = true;
txtGameDate.ReadOnly = true;
}
if (!IsPostBack)
{
Content = KifuService.GetKifuContent(KifuID);
txtGameDate.Text = DateTime.Parse(CommonService.GetContentInBracket(Content, "DT")).ToString("yyyy-MM-dd");
txtGameName.Text = CommonService.GetContentInBracket(Content, "GN");
txtGameEvent.Text = CommonService.GetContentInBracket(Content, "EV");
}
rpComment.DataSource = FavouriteKifuService.GetKifuRating(KifuID);
rpComment.DataBind();
lblRate.Text = FavouriteKifuService.GroupPointOfKifu(KifuID) + "/5";
GetOpen();
}
public DataTable Select(FavouriteKifu favouriteKifu)
{
string sql = "SELECT * FROM FavouriteKifu WHERE KifuID=@kifuID AND Username=@username";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@kifuID", favouriteKifu.KifuID);
parameters[1] = new SqlParameter("@username", favouriteKifu.Username);
return(SqlHelper.ExecuteDataTable(sql, parameters));
}
public int Insert(object obj)
{
FavouriteKifu favouriteKifu = (FavouriteKifu)obj;
string sql = "INSERT INTO FavouriteKifu VALUES(@kifuID,@username)";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@kifuID", favouriteKifu.KifuID);
parameters[1] = new SqlParameter("@username", favouriteKifu.Username);
return(SqlHelper.ExecuteNonQuery(sql, parameters));
}
public int Delete(object obj)
{
FavouriteKifu favouriteKifu = (FavouriteKifu)obj;
string sql = "DELETE FROM FavouriteKifu WHERE KifuID=@kifuID AND Username=@username";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@kifuID", favouriteKifu.KifuID);
parameters[1] = new SqlParameter("@username", favouriteKifu.Username);
return(SqlHelper.ExecuteNonQuery(sql, parameters));
}
public static Boolean IsFavour(FavouriteKifu favourite)
{
DataTable dt = new FavouriteKifuDAL().Select(favourite);
if (dt.Rows.Count != 1)
{
return(false);
}
return(true);
}
public static int UnLikeKifu(FavouriteKifu favourite)
{
return(new FavouriteKifuDAL().Delete(favourite));
}
public static int LikeKifu(FavouriteKifu favourite)
{
return(new FavouriteKifuDAL().Insert(favourite));
}
