public static void InsertGiaVeCuaGhe(KeHoachVe keHoach, Ghe ghe, int giaGhe)
{
string sql = @"INSERT INTO [dbo].[giaVeCuaGhe]
([gheID]
,[tenPhim]
,[tenRap]
,[khanDaiID]
,[ngayChieu]
,[suatChieu]
,[giaVeCuaGhe]
,[trangThai])
VALUES
(@gheID
,@tenPhim
,@tenRap
,@khanDaiID
,@ngayChieu
,@suatChieu
,@giaVeCuaGhe
,'chua')";
SqlParameter pr1 = new SqlParameter("@tenPhim", SqlDbType.NVarChar);
pr1.Value = keHoach.TenPhim;
SqlParameter pr2 = new SqlParameter("@tenRap", SqlDbType.NVarChar);
pr2.Value = keHoach.TenRap;
SqlParameter pr3 = new SqlParameter("@khanDaiID", SqlDbType.NVarChar);
pr3.Value = keHoach.KhanDai;
SqlParameter pr4 = new SqlParameter("@ngayChieu", SqlDbType.DateTime);
pr4.Value = keHoach.NgayChieu;
SqlParameter pr5 = new SqlParameter("@suatChieu", SqlDbType.NVarChar);
pr5.Value = keHoach.SuatChieu;
SqlParameter pr6 = new SqlParameter("@giaVeCuaGhe", SqlDbType.Int);
pr6.Value = giaGhe;
SqlParameter pr7 = new SqlParameter("@gheID", SqlDbType.NVarChar);
pr7.Value = ghe.GheID;
DAO.ExecuteSQLWithParameters(sql, pr1, pr2, pr3, pr4, pr5, pr6, pr7);
}
public static void InsertKeHoachVe(KeHoachVe keHoach)
{
string sql = @"INSERT INTO [dbo].[keHoachVe]
([tenPhim]
,[tenRap]
,[khanDaiID]
,[ngayChieu]
,[suatChieu]
,[loaiPhim]
,[phuDe])
VALUES
(@tenPhim
,@tenRap
,@khanDaiID
,@ngayChieu
,@suatChieu
,@loaiPhim
,@phuDe)";
SqlParameter pr1 = new SqlParameter("@tenPhim", SqlDbType.NVarChar);
pr1.Value = keHoach.TenPhim;
SqlParameter pr2 = new SqlParameter("@tenRap", SqlDbType.NVarChar);
pr2.Value = keHoach.TenRap;
SqlParameter pr3 = new SqlParameter("@khanDaiID", SqlDbType.NVarChar);
pr3.Value = keHoach.KhanDai;
SqlParameter pr4 = new SqlParameter("@ngayChieu", SqlDbType.DateTime);
pr4.Value = keHoach.NgayChieu;
SqlParameter pr5 = new SqlParameter("@suatChieu", SqlDbType.NVarChar);
pr5.Value = keHoach.SuatChieu;
SqlParameter pr6 = new SqlParameter("@loaiPhim", SqlDbType.NVarChar);
pr6.Value = keHoach.LoaiPhim;
SqlParameter pr7 = new SqlParameter("@phuDe", SqlDbType.Bit);
pr7.Value = keHoach.PhuDe;
DAO.ExecuteSQLWithParameters(sql, pr1, pr2, pr3, pr4, pr5, pr6, pr7);
}
