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)); }