public static void Deletethienboat_GenreBythienboatID(string thienboatID)
{
DataProvider.ExecuteNonQuery("DELETE dbo.PhanLoaiTauWHERE idTau = '" + thienboatID + "'");
}
public static bool InsertGenre(string id, string name, string desc)
{
int result = DataProvider.ExecuteNonQuery("EXEC USP_InsertGenre @idGenre , @ten , @moTa ", new object[] { id, name, desc });
return(result > 0);
}
public static bool InsertAccount(string username, int accountType, string staffID)
{
int result = DataProvider.ExecuteNonQuery("EXEC USP_InsertAccount @username , @loaiTK , @idnv ", new object[] { username, accountType, staffID });
return(result > 0);
}
public static bool InsertFormatMovie(string id, string idMovie, string idScreen)
{
int result = DataProvider.ExecuteNonQuery("EXEC USP_InsertFormatMovie @id , @idPhim , @idLoaiManHinh ", new object[] { id, idMovie, idScreen });
return(result > 0);
}
public static bool InsertStaff(string id, string hoTen, DateTime ngaySinh, string diaChi, string sdt, int cmnd)
{
int result = DataProvider.ExecuteNonQuery("EXEC USP_InsertStaff @idStaff , @hoTen , @ngaySinh , @diaChi , @sdt , @cmnd ", new object[] { id, hoTen, ngaySinh, diaChi, sdt, cmnd });
return(result > 0);
}
public static bool ResetPassword(string username)
{
int result = DataProvider.ExecuteNonQuery("USP_ResetPasswordtAccount @username", new object[] { username });
return(result > 0);
}
public static int InsertTicketByShowTimes(string showTimesID, string seatName)
{
string query = "USP_InsertTicketByShowTimes @idlichChieu , @maGheNgoi";
return(DataProvider.ExecuteNonQuery(query, new object[] { showTimesID, seatName }));
}
public static bool InsertShowtime(string id, string cinemaID, string formatMovieID, DateTime time, float ticketPrice)
{
int result = DataProvider.ExecuteNonQuery("EXEC USP_InsertShowtime @id , @idPhong , @idDinhDang , @thoiGianChieu , @giaVe ", new object[] { id, cinemaID, formatMovieID, time, ticketPrice });
return(result > 0);
}
public static bool DeleteCustomer(string id)
{
int result = DataProvider.ExecuteNonQuery("DELETE dbo.KhachHang WHERE id = '" + id + "'");
return(result > 0);
}
public static bool UpdateMovie(string id, string name, string desc, float length, DateTime startDate, DateTime endDate, string productor, string director, int year, byte[] image)
{
int result = DataProvider.ExecuteNonQuery("EXEC USP_UpdateMovie @id , @tenPhim , @moTa , @thoiLuong , @ngayKhoiChieu , @ngayKetThuc , @sanXuat , @daoDien , @namSX , @apPhich ", new object[] { id, name, desc, length, startDate, endDate, productor, director, year, image });
return(result > 0);
}
public static bool InsertCustomer(string id, string hoTen, DateTime ngaySinh, string diaChi, string sdt, string email)
{
int result = DataProvider.ExecuteNonQuery("EXEC USP_InsertCustomer @idCus , @hoTen , @ngaySinh , @diaChi , @sdt , @email ", new object[] { id, hoTen, ngaySinh, diaChi, sdt, email });
return(result > 0);
}
public static bool InsertFormatthienboat(string id, string idthienboat, string idScreen)
{
int result = DataProvider.ExecuteNonQuery("EXEC USP_InsertFormatthienboat @id , @idTau , @idLoaiTau ", new object[] { id, idthienboat, idScreen });
return(result > 0);
}
public static bool Insertthienboat(string id, string name, string desc, float length, DateTime startDate, DateTime endDate, string productor, string director, int year, byte[] image)
{
int result = DataProvider.ExecuteNonQuery("EXEC USP_Insertthienboat @id , @tenTau , @moTa , @thoiLuong , @NgayDi , @ngayKetThuc , @sanXuat , @ThuyenTruong , @namSX , @apPhich ", new object[] { id, name, desc, length, startDate, endDate, productor, director, year, image });
return(result > 0);
}
public static bool InsertCinema(string id, string name, string idMH, int seats, int status, int numberOfRows, int seatsPerRow)
{
int result = DataProvider.ExecuteNonQuery("EXEC USP_InsertCinema @idCinema , @tenPhong , @idMH , @soChoNgoi , @tinhTrang , @soHangGhe , @soGheMotHang", new object[] { id, name, idMH, seats, status, numberOfRows, seatsPerRow });
return(result > 0);
}
public static int DeleteTicketsByShowTimes(string showTimesID)
{
string query = "USP_DeleteTicketsByShowTimes @idlichChieu";
return(DataProvider.ExecuteNonQuery(query, new object[] { showTimesID }));
}
public static int UpdateStatusShowTimes(string showTimesID, int status)
{
string query = "USP_UpdateStatusShowTimes @idLichChieu , @status";
return(DataProvider.ExecuteNonQuery(query, new object[] { showTimesID, status }));
}
public static bool DeleteAccount(string username)
{
int result = DataProvider.ExecuteNonQuery("DELETE dbo.TaiKhoan WHERE UserName = N'" + username + "'");
return(result > 0);
}
public static bool InsertScreenType(string id, string name)
{
int result = DataProvider.ExecuteNonQuery("EXEC USP_InsertScreenType @idScreenType , @ten", new object[] { id, name });
return(result > 0);
}
public static void DeleteMovie_GenreByMovieID(string movieID)
{
DataProvider.ExecuteNonQuery("DELETE dbo.PhanLoaiPhim WHERE idPhim = '" + movieID + "'");
}