public bool TheoDoiPhim(PhimTheoDoi phimTheoDoi, ThanhVien thanhvien) { int i = LayMaTV(thanhvien); OpenConnected(); SqlCommand sql = TaoCommand("PhimTheoDoi_Insert"); sql.Parameters.Add("@MaTV", SqlDbType.Int).Value = i; sql.Parameters.Add("@MaPhim", SqlDbType.Int).Value = phimTheoDoi.MaPhim; sql.Parameters.Add("@HinhAnh", SqlDbType.VarChar).Value = phimTheoDoi.HinhAnh.Trim(); sql.Parameters.Add("@TenPhim", SqlDbType.NVarChar).Value = phimTheoDoi.TenPhim.Trim(); sql.Parameters.Add("@SoTap", SqlDbType.Char).Value = phimTheoDoi.SoTap.Trim(); int kq = sql.ExecuteNonQuery(); return(kq > 0); }
public bool PhimTheoDoi_Search(ThanhVien tv, int ma) { int i = LayMaTV(tv); OpenConnected(); PhimTheoDoi phimTheoDoi = new PhimTheoDoi(); SqlCommand command = TaoCommand("PhimTheoDoi_Search"); command.Parameters.Add("@MaTV", SqlDbType.Int).Value = i; command.Parameters.Add("@MaPhim", SqlDbType.Int).Value = ma; SqlDataReader reader = command.ExecuteReader(); bool kq = reader.HasRows; reader.Close(); return(kq); }
public List <PhimTheoDoi> HienThiTatCaPhimTheoDoi_KeCaMATV() { List <PhimTheoDoi> phim = new List <PhimTheoDoi>(); OpenConnected(); SqlCommand sql = TaoCommand("PhimTheoDoi_Select_All"); SqlDataReader reader = sql.ExecuteReader(); while (reader.Read()) { PhimTheoDoi phimTheoDoi = new PhimTheoDoi(); phimTheoDoi.MaTV = reader.GetInt32(0); phimTheoDoi.MaPhim = reader.GetInt32(1); phimTheoDoi.HinhAnh = reader.GetString(2).Trim(); phimTheoDoi.TenPhim = reader.GetString(3).Trim(); phimTheoDoi.SoTap = reader.GetString(4).Trim(); phim.Add(phimTheoDoi); } reader.Close(); return(phim); }
protected void btnTheoDoi_Click(object sender, EventArgs e) { if (Session["KiemTra"] != null) { tv.UserName = Session["TenDangNhap"].ToString(); tv.Password = Session["MatKhau"].ToString(); Phim phim = new Phim(); phim.MaPhim = Int32.Parse(Request.QueryString["MaPhim"]); p = phimbll.HienThiTheoMaPhim(phim); if (!phimtheodoibll.PhimTheoDoi_Search(tv, p.MaPhim)) { PhimTheoDoi theoDoi = new PhimTheoDoi(); theoDoi.MaPhim = p.MaPhim; theoDoi.MaTV = phimtheodoibll.LayMaTV(tv); theoDoi.HinhAnh = p.HinhAnh; theoDoi.TenPhim = p.TenPhimGoc; string[] s = p.TrangThai.Split('/'); if (s[0].Trim().Equals('?')) { theoDoi.SoTap = "Trailer"; } else { theoDoi.SoTap = s[0].Trim(); } bool kq = phimtheodoibll.TheoDoiPhim(theoDoi, tv); if (kq) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Thành Công", "alert('" + "Đã Thêm Vào Kho" + "');", true); ((Button)frmviwNoiDungPhim.FindControl("btnTheoDoi")).Text = "Đang Theo Dõi"; ((Button)frmviwNoiDungPhim.FindControl("btnTheoDoi")).Enabled = false; } } } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "Error", "alert('" + "Yêu Cầu Phải Đăng Nhập" + "');", true); } }
public List <PhimTheoDoi> HienThiTatCaPhimTheoDoi(ThanhVien thanhvien) { int i = LayMaTV(thanhvien); List <PhimTheoDoi> phim = new List <PhimTheoDoi>(); OpenConnected(); SqlCommand sql = TaoCommand("PhimTheoDoi_Select"); sql.Parameters.Add("@MaTV", SqlDbType.Int).Value = i; SqlDataReader reader = sql.ExecuteReader(); while (reader.Read()) { PhimTheoDoi phimTheoDoi = new PhimTheoDoi(); phimTheoDoi.MaPhim = reader.GetInt32(0); phimTheoDoi.HinhAnh = reader.GetString(1).Trim(); phimTheoDoi.TenPhim = reader.GetString(2).Trim(); phimTheoDoi.SoTap = reader.GetString(3).Trim(); phim.Add(phimTheoDoi); } reader.Close(); return(phim); }
public List <PhimTheoDoi> HienThiPhimTheoDoi_TheoMaPhim(int maphim) { List <PhimTheoDoi> phim = new List <PhimTheoDoi>(); OpenConnected(); SqlCommand sql = TaoCommand("PhimTheoDoi_Search_MaPhim"); sql.Parameters.Add("@MaPhim", SqlDbType.Int).Value = maphim; SqlDataReader reader = sql.ExecuteReader(); while (reader.Read()) { PhimTheoDoi phimTheoDoi = new PhimTheoDoi(); phimTheoDoi.MaTV = reader.GetInt32(0); phimTheoDoi.MaPhim = reader.GetInt32(1); phimTheoDoi.HinhAnh = reader.GetString(2).Trim(); phimTheoDoi.TenPhim = reader.GetString(3).Trim(); phimTheoDoi.SoTap = reader.GetString(4).Trim(); phim.Add(phimTheoDoi); } reader.Close(); return(phim); }
public bool TheoDoiPhim(PhimTheoDoi phimTheoDoi, ThanhVien tv) { return(phim.TheoDoiPhim(phimTheoDoi, tv)); }