// Thêm một hóa đơn bán hàng
public bool ThemHoaDonBanHang(ref string erro, string maHoaDon, DateTime ngayLapHD, string maKhachHang, string maNhanVien)
{
return(db.MyExecuteNonQuery("spThemHoaDonBanHang", CommandType.StoredProcedure, ref erro,
new SqlParameter("@MaHD", maHoaDon),
new SqlParameter("@NgayLapHD", ngayLapHD),
new SqlParameter("@MaKH", maKhachHang),
new SqlParameter("@MaNV", maNhanVien)
));
}
// Thêm chi tiết hóa đơn bán hàng
public bool ThemChiTietHDBanHang(ref string erro, string maHoaDon, string maSanPham, double donGia, int soLuong)
{
return(db.MyExecuteNonQuery("spThemChiTietHDBanHang", CommandType.StoredProcedure, ref erro,
new SqlParameter("@MaHD", maHoaDon),
new SqlParameter("@MaSP", maSanPham),
new SqlParameter("@DonGia", donGia),
new SqlParameter("@SoLuong", soLuong)
));
}
// Thêm chi tiết đơn nhập
public bool ThemChiTietNhap(ref string error, string MaDonNhap, string MaSP, int SoLuong, double DonGia, double TongTien)
{
return(db.MyExecuteNonQuery("spTaoChiTietNhap", CommandType.StoredProcedure, ref error,
new SqlParameter("@MaDonNhap", MaDonNhap),
new SqlParameter("@MaSP", MaSP),
new SqlParameter("@DonGia", DonGia),
new SqlParameter("@SoLuong", SoLuong),
new SqlParameter("@ThanhTien", TongTien)
));
}
public bool ThemHoaDonNhapHang(ref string error, string MaHD, string NguoiGiao, double TongTien, double DaTra, double ConNo, DateTime ThoiGian, string NhanVienId, string MaNCC)
{
return(db.MyExecuteNonQuery("spTaoHoaDonNhap", CommandType.StoredProcedure, ref error,
new SqlParameter("@MaDonNhap", MaHD),
new SqlParameter("@ThoiGian", ThoiGian),
new SqlParameter("@NhaCC", MaNCC),
new SqlParameter("@NguoiGiao", NguoiGiao),
new SqlParameter("@NhanVienGiamSat", NhanVienId),
new SqlParameter("@TongTien", TongTien)
));
}
public bool ThemThanhToan(ref string error, string MaThanhToan, string MaNCC, DateTime ThoiGian, string NguoiNhan, string MaNV, double CongNo, double TienThanhToan)
{
return(db.MyExecuteNonQuery("spThemThanhToan", CommandType.StoredProcedure, ref error,
new SqlParameter("MaThanhToan", MaThanhToan),
new SqlParameter("MaNCC", MaNCC),
new SqlParameter("ThoiGian", ThoiGian),
new SqlParameter("NguoiNhan", NguoiNhan),
new SqlParameter("MaNV", MaNV),
new SqlParameter("CongNo", CongNo),
new SqlParameter("TienThanhToan", TienThanhToan)
));
}
public bool ThemBaoHanh(ref string error, string SoPhieu, string MaKH, string MaSP, DateTime BatDau, DateTime KetThuc, string TinhTrang, string CachBH, int SoLanBH, string GhiChu)
{
return(db.MyExecuteNonQuery("spThemBaoHanh", CommandType.StoredProcedure, ref error,
new SqlParameter("@SoPhieu", SoPhieu),
new SqlParameter("@MaKH", MaKH),
new SqlParameter("@MaSP", MaSP),
new SqlParameter("@BatDau", BatDau),
new SqlParameter("@KetThuc", KetThuc),
new SqlParameter("@TinhTrang", TinhTrang),
new SqlParameter("@CachBH", CachBH),
new SqlParameter("@SoLanBH", SoLanBH),
new SqlParameter("@GhiChu", GhiChu)));
}
public bool ThemNhanVienWithImage(ref string error, string NhanVienId, string TenNV, DateTime Birthday, string Address, string SDT
, byte[] photo, double luong, string email)
{
return(db.MyExecuteNonQuery("spThemNhanVienWithImage", CommandType.StoredProcedure, ref error,
new SqlParameter("@NhanVienId", NhanVienId),
new SqlParameter("@TenNV", TenNV),
new SqlParameter("@Birthday", Birthday),
new SqlParameter("@Address", Address),
new SqlParameter("@SDT", SDT),
new SqlParameter("@photo", photo),
new SqlParameter("@luong", luong),
new SqlParameter("@email", email)));
}
public bool XoaKhachHang(ref string error, string MaKH)
{
return(db.MyExecuteNonQuery("spXoaKhachHang", CommandType.StoredProcedure, ref error,
new SqlParameter("@MaKH", MaKH)));
}
public bool XoaSP(ref string error, string MaSP)
{
return(db.MyExecuteNonQuery("spXoaSP", CommandType.StoredProcedure, ref error,
new SqlParameter("@MaSP", MaSP)));
}
public bool CapNhatMatKhau(ref string error, string user, string pass)
{
return(db.MyExecuteNonQuery("spCapNhatMatKhau", CommandType.StoredProcedure, ref error,
new SqlParameter("@user", user),
new SqlParameter("@pass", pass)));
}
