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