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