protected void rpt_slider_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "ThemGH")
{
HttpCookie cookie = Request.Cookies["tenTK"];
if (cookie != null)
{
string tenTK = cookie.Value;
DTO_giohang gh = new DTO_giohang();
gh.Tentaikhoan = tenTK;
gh.Masp = e.CommandArgument.ToString();
gh.Soluong = 1;
if (BUS_giohang.themvaogiohang(gh))
{
Response.Write("<script>alert('thanh cong')</script>");
Response.Redirect("cart.aspx");
}
else
{
Response.Redirect("cart.aspx");
}
}
else
{
Response.Write("<script>warning('ban can phai dang nhap truoc')</script>");
Response.Redirect("../DangNhap.aspx");
}
}
}
public static DTO_giohang ConvertToDTO(DataRow dr)
{
DTO_giohang gh = new DTO_giohang();
gh.Tentaikhoan = dr["TenTaiKhoan"].ToString();
gh.Masp = dr["MaSP"].ToString();
gh.Soluong = Convert.ToInt32(dr["SoLuong"]);
return(gh);
}
public static bool KTGHTonTai(DTO_giohang gh)
{
string query = "SELECT COUNT(*) FROM GioHang WHERE TenTaiKhoan = @TenTaiKhoan AND MaSP = @MaSP";
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@TenTaiKhoan", gh.Tentaikhoan);
param[1] = new SqlParameter("@MaSP", gh.Masp);
return(Convert.ToInt32(DataProvider.ExecuteSelectQuery(query, param).Rows[0][0]) == 1);
}
public static bool SuaGH(DTO_giohang gh)
{
string query = "UPDATE GioHang SET SoLuong = SoLuong + @SoLuong WHERE TenTaiKhoan = @TenTaiKhoan AND MaSP = @MaSP";
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@TenTaiKhoan", gh.Tentaikhoan);
param[1] = new SqlParameter("@MaSP", gh.Masp);
param[2] = new SqlParameter("@SoLuong", gh.Soluong);
return(DataProvider.ExecuteUpdateQuery(query, param) == 1);
}
public static bool ThemGH(DTO_giohang gh)
{
string query = "INSERT INTO GioHang (TenTaiKhoan, MaSP, SoLuong) VALUES (@TenTaiKhoan, @MaSP, @SoLuong)";
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@TenTaiKhoan", gh.Tentaikhoan);
param[1] = new SqlParameter("@MaSP", gh.Masp);
param[2] = new SqlParameter("@SoLuong", gh.Soluong);
return(DataProvider.ExecuteInsertQuery(query, param) == 1);
}
public static bool themvaogiohang(DTO_giohang sp)
{
if (DAO_giohang.KTGHTonTai(sp))
{
return(DAO_giohang.SuaGH(sp));
}
else
{
return(DAO_giohang.ThemGH(sp));
}
}
