public bool ThemTheLoai(ref string err, string MaTheLoai, string TenTheLoai, int TinhTrang)
{
return(dal.MyExecuteNonQuery("spInsertTheLoai", CommandType.StoredProcedure, ref err,
new SqlParameter("@MaTheLoai", MaTheLoai),
new SqlParameter("@TenTheLoai", TenTheLoai),
new SqlParameter("@TinhTrang", TinhTrang)));
}
public bool ThemNXB(ref string err, string MaNXB, string TenNXB, int TinhTrang)
{
return(dal.MyExecuteNonQuery("spInsertNXB", CommandType.StoredProcedure, ref err,
new SqlParameter("@MaNXB", MaNXB),
new SqlParameter("@TenNXB", TenNXB),
new SqlParameter("@TinhTrang", TinhTrang)));
}
public bool ThemTaiKhoan(ref string err, string MaNV, string MatKhau, int Quyen)
{
return(dal.MyExecuteNonQuery("spInsertTaiKhoan", CommandType.StoredProcedure, ref err,
new SqlParameter("@MaNV", MaNV),
new SqlParameter("@MatKhau", MatKhau),
new SqlParameter("@Quyen", Quyen)));
}
public bool ThemTheLoai(ref string err, string MaTheLoai, string TenTheLoai)
{
return(db.MyExecuteNonQuery(
"spThemTheLoai",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaTheLoai", MaTheLoai),
new SqlParameter("@TenTheLoai", TenTheLoai)));
}
//
//Thêm khách hàng
public bool InsertTaiKhoan(ref string err, string MaNV, string TenTK, string Pass, string Quyen)
{
return(db.MyExecuteNonQuery("spInsertTaiKhoan", CommandType.StoredProcedure, ref err,
new SqlParameter("@MaNV", MaNV),
new SqlParameter("@TenTK", TenTK),
new SqlParameter("@Pass", Pass),
new SqlParameter("@Quyen", Quyen)));
}
public bool ThemNhaCC(ref string err, string MaNCC, string TenNCC, string DiaChi, string SDT, int TinhTrang)
{
return(dal.MyExecuteNonQuery("spInsertNhaCC", CommandType.StoredProcedure, ref err,
new SqlParameter("@MaNCC", MaNCC),
new SqlParameter("@TenNCC", TenNCC),
new SqlParameter("@DiaChi", DiaChi),
new SqlParameter("@SDT", SDT),
new SqlParameter("@TinhTrang", TinhTrang)));
}
public bool ThemTaiKhoan(ref string err, string TaiKhoan, string MatKhau, string Quyen)
{
return(db.MyExecuteNonQuery(
"spThemTaiKhoan",
CommandType.StoredProcedure, ref err,
new SqlParameter("@TaiKhoan", TaiKhoan),
new SqlParameter("@MatKhau", MatKhau),
new SqlParameter("@Quyen", Quyen)));
}
public bool ThemDichVu(ref string err, string MaDichVu, string TenDichVu, float GiaDV)
{
return(db.MyExecuteNonQuery(
"spThemDichVu",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaDichVu", MaDichVu),
new SqlParameter("@TenDichVu", TenDichVu),
new SqlParameter("@GiaDV", GiaDV)));
}
//
//Thêm khách hàng
public bool InsertNhaCungCap(ref string err, string MaNCC, string TenNCC, string DiaChi, byte[] Picture)
{
return(db.MyExecuteNonQuery("spInsertNhaCungCap", CommandType.StoredProcedure, ref err,
new SqlParameter("@MaNCC", MaNCC),
new SqlParameter("@TenNCC", TenNCC),
new SqlParameter("@DiaChi", DiaChi),
new SqlParameter("@Picture", Picture)
));
}
//
//Thêm khách hàng
public bool InsertKhachHang(ref string err, string MaKH, string MaLKH, string TenKH, string SDT, string DiaChi, string GioiTinh, string Email)
{
return(db.MyExecuteNonQuery("spInsertKhachHang", CommandType.StoredProcedure, ref err,
new SqlParameter("@MaKH", MaKH),
new SqlParameter("@MaLKH", MaLKH),
new SqlParameter("@TenKH", TenKH),
new SqlParameter("@SDT", SDT),
new SqlParameter("@DiaChi", DiaChi),
new SqlParameter("@GioiTinh", GioiTinh),
new SqlParameter("@Email", Email)));
}
public bool ThemSach(ref string err, string MaSach, string TenSach, string MaTheLoai,
string MaNXB, float GiaBan, int SoLuongTon, int TinhTrang)
{
return(dal.MyExecuteNonQuery("spInsertSach", CommandType.StoredProcedure, ref err,
new SqlParameter("@MaSach", MaSach),
new SqlParameter("@TenSach", TenSach),
new SqlParameter("@MaTheLoai", MaTheLoai),
new SqlParameter("@MaNXB", MaNXB),
new SqlParameter("@GiaBan", GiaBan),
new SqlParameter("@SoLuongTon", SoLuongTon),
new SqlParameter("@TinhTrang", TinhTrang)));
}
public bool ThemLichChieu(ref string err, string MaLichChieu, DateTime NgayChieu, string GioChieu,
string MaPhongChieu, string MaPhim)
{
return(db.MyExecuteNonQuery(
"spThemLichChieu",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaLichChieu", MaLichChieu),
new SqlParameter("@NgayChieu", NgayChieu),
new SqlParameter("@GioChieu", GioChieu),
new SqlParameter("@MaPhongChieu", MaPhongChieu),
new SqlParameter("@MaPhim", MaPhim)));
}
public bool ThemLoaiVe(ref string err, string MaLoaiVe, string TenLoai, string HangGhe, string NgayBan, string DoiTuong, float Gia)
{
return(db.MyExecuteNonQuery(
"spThemLoaiVe",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaLoaiVe", MaLoaiVe),
new SqlParameter("@TenLoai", TenLoai),
new SqlParameter("@HangGhe", HangGhe),
new SqlParameter("@NgayBan", NgayBan),
new SqlParameter("@DoiTuong", DoiTuong),
new SqlParameter("@Gia", Gia)));
}
public bool ThemHoaDonDichVu(ref string err, string MaHoaDonDichVu, string MaNhanVien, string MaDichVu, int SoLuong, float DonGia, float ThanhTien)
{
return(db.MyExecuteNonQuery(
"spThemHoaDonDichVu",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaHoaDonDichVu", MaHoaDonDichVu),
new SqlParameter("@MaNhanVien", MaNhanVien),
new SqlParameter("@MaDichVu", MaDichVu),
new SqlParameter("@SoLuong", SoLuong),
new SqlParameter("@DonGia", DonGia),
new SqlParameter("@ThanhTien", ThanhTien)));
}
//
//Thêm sản phẩm
public bool InsertSanPham(ref string err, string MaSP, string TenSP, string ThongTin,
Decimal GiaBan, string MaLoaiSP, int SoLuongTrongKho, byte[] Picture, string NhaCungCap)
{
return(db.MyExecuteNonQuery("spInsertSanPham", CommandType.StoredProcedure, ref err,
new SqlParameter("@MaSP", MaSP),
new SqlParameter("@TenSP", TenSP),
new SqlParameter("@ThongTin", ThongTin),
new SqlParameter("@GiaBan", GiaBan),
new SqlParameter("@MaLoaiSP", MaLoaiSP),
new SqlParameter("@SoLuongTrongKho", SoLuongTrongKho),
new SqlParameter("@Picture", Picture),
new SqlParameter("@NhaCungCap", NhaCungCap)));
}
public bool ThemVeBan(ref string err, string MaVe, string MaLichChieu, string MaLoaiVe, int SoLuong, string MaGhe,
string MaNhanVien, float Gia)
{
return(db.MyExecuteNonQuery(
"spThemVeBan",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaVe", MaVe),
new SqlParameter("@MaLichChieu", MaLichChieu),
new SqlParameter("@MaLoaiVe", MaLoaiVe),
new SqlParameter("@SoLuong", SoLuong),
new SqlParameter("@MaGhe", MaGhe),
new SqlParameter("@MaNhanVien", MaNhanVien),
new SqlParameter("@Gia", Gia)));
}
public bool ThemPhongChieu(ref string err, string MaPhongChieu, int SoCho, int SoDay, string MayChieu, string AmThanh, string DienTich,
bool TinhTrang, string ThietBiKhac)
{
return(db.MyExecuteNonQuery(
"spThemPhongChieu",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaPhongChieu", MaPhongChieu),
new SqlParameter("@SoCho", SoCho),
new SqlParameter("@SoDay", SoDay),
new SqlParameter("@MayChieu", MayChieu),
new SqlParameter("@AmThanh", AmThanh),
new SqlParameter("@DienTich", DienTich),
new SqlParameter("@TinhTrang", TinhTrang),
new SqlParameter("@ThietBiKhac", ThietBiKhac)));
}
public bool ThemNhanVien(ref string err, string MaNhanVien, string HoTenNhanVien, DateTime NgaySinh, bool GioiTinh, string CMND,
string SDT, byte[] HinhAnh, string ChucVu, string DiaChi)
{
return(db.MyExecuteNonQuery(
"spThemNhanVien",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaNhanVien", MaNhanVien),
new SqlParameter("@HoTenNhanVien", HoTenNhanVien),
new SqlParameter("@NgaySinh", NgaySinh),
new SqlParameter("@GioiTinh", GioiTinh),
new SqlParameter("@CMND", CMND),
new SqlParameter("@SDT", SDT),
new SqlParameter("@HinhAnh", HinhAnh),
new SqlParameter("@ChucVu", ChucVu),
new SqlParameter("@DiaChi", DiaChi)));
}
public bool ThemTaiKhoan(ref string err, string TaiKhoan, string PassWord, string Quyen)
{
return(db.MyExecuteNonQuery(
"spThemLichChieu",
CommandType.StoredProcedure, ref err,
new SqlParameter("@TaiKhoan", TaiKhoan),
new SqlParameter("@PassWord", PassWord),
new SqlParameter("@Quyen", Quyen)));
}
public bool ThemPhim(ref string err, string MaPhim, string TenPhim, string DaoDien, string MaTheLoai, string DienVien, string NoiDung,
byte[] Hinh, string Trailer, int NamSanXuat, string QuocGia, string ThoiLuong)
{
return(db.MyExecuteNonQuery(
"spThemPhim",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaPhim", MaPhim),
new SqlParameter("@TenPhim", TenPhim),
new SqlParameter("@DaoDien", DaoDien),
new SqlParameter("@MaTheLoai", MaTheLoai),
new SqlParameter("@DienVien", DienVien),
new SqlParameter("@NoiDung", NoiDung),
new SqlParameter("@Hinh", Hinh),
new SqlParameter("@Trailer", Trailer),
new SqlParameter("@NamSanXuat", NamSanXuat),
new SqlParameter("@QuocGia", QuocGia),
new SqlParameter("@ThoiLuong", ThoiLuong)));
}
public bool ThemHoaDonBan(ref string err, string MaHDB, string MaNV, string HoTenKH, DateTime NgayLapHD)
{
return(dal.MyExecuteNonQuery("spInsertHoaDonBan", CommandType.StoredProcedure, ref err,
new SqlParameter("@MaHDB", MaHDB),
new SqlParameter("@MaNV", MaNV),
new SqlParameter("@HoTenKH", HoTenKH),
new SqlParameter("@NgayLapHD", NgayLapHD)));
}
public bool ThemHoaDonNhap(ref string err, string MaHDN, string MaNCC, string MaNV, DateTime NgayLap)
{
return(dal.MyExecuteNonQuery("spInsertHoaDonNhap", CommandType.StoredProcedure, ref err,
new SqlParameter("@MaHDN", MaHDN),
new SqlParameter("@MaNCC", MaNCC),
new SqlParameter("@MaNV", MaNV),
new SqlParameter("@NgayLap", NgayLap)));
}
//
//Thêm hóa đơn
public bool InsertHoaDon(ref string err, string MaHD, DateTime NgayLapHD, string NguoiLapHD, string MaKH)
{
return(db.MyExecuteNonQuery("spInsertHoaDon", CommandType.StoredProcedure, ref err,
new SqlParameter("@MaHD", MaHD),
new SqlParameter("@NgayLapHD", NgayLapHD),
new SqlParameter("@NguoiLapHD", NguoiLapHD),
new SqlParameter("@MaKH", MaKH)
));
}
//
//Thêm loại sản phẩm
public bool InsertLoaiSP(ref string err, string MaLSP, string TenLSP)
{
return(db.MyExecuteNonQuery("spInsertLoaiSP", CommandType.StoredProcedure, ref err,
new SqlParameter("@MaLSP", MaLSP),
new SqlParameter("@TenLSP", TenLSP)));
}
public bool UpdateSanPhamSauKhiMua(ref string err, string MaSP, int SoLuong)
{
return(db.MyExecuteNonQuery("spUpdateSoLuong", CommandType.StoredProcedure, ref err,
new SqlParameter("@MaSP", MaSP),
new SqlParameter("@SoLuong", SoLuong)));
}