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