public static bool ThemHoaDonMonAn(string soHoaDon, string ma, int soLuong) { string query = "EXEC uspThemHangHoaDon @soHoaDon,@ma,@soLuong"; //truyền tham số vào câu truy vấn List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@soHoaDon", SqlDbType.VarChar) { IsNullable = false, Value = soHoaDon }, new SqlParameter("@ma", SqlDbType.VarChar) { IsNullable = false, Value = ma }, new SqlParameter("@soLuong", SqlDbType.Int) { IsNullable = false, Value = soLuong }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
//public static int TinhTienGio(string soHoaDon, DateTime, gioRa) //{ // string query = "EXEC uspThanhToanPhong @soHoaDon"; // List<SqlParameter> parameters = new List<SqlParameter>() // { // new SqlParameter("@soHoaDon",SqlDbType.VarChar){IsNullable=false,Value=soHoaDon } // }; // int result = 0; // try // { // result = (int)Dataprovider.ExcuteScalar(query, parameters.ToArray()); // } // catch (Exception ex) // { // Utility.Log(ex); // } // return result == 0 ? false : true; //} public static bool ThanhToan(string soHoaDon, DateTime gioRa, int thanhTien, int giamGia) { string query = "EXEC uspThanhToanPhong @soHoaDon,@gioRa,@thanhTien,@giamGia"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@soHoaDon", SqlDbType.VarChar) { IsNullable = false, Value = soHoaDon }, new SqlParameter("@gioRa", SqlDbType.DateTime) { IsNullable = false, Value = gioRa }, new SqlParameter("@thanhTien", SqlDbType.Int) { IsNullable = false, Value = thanhTien }, new SqlParameter("@giamGia", SqlDbType.Int) { IsNullable = false, Value = giamGia }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
public static bool GiaoHang(string soPhieuNhap, string nguoiGiao) { string query = "EXEC uspGiaoSanPham @soPhieuNhap,@nguoiGiao"; //truyền tham số vào câu truy vấn List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@soPhieuNhap", SqlDbType.NVarChar) { IsNullable = false, Value = soPhieuNhap }, new SqlParameter("@nguoiGiao", SqlDbType.NVarChar) { IsNullable = false, Value = nguoiGiao }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
public static bool NhanPhongDatTruoc(string soHoaDon) { string query = "EXEC uspNhanPhong @soHoaDon,@NgayNhan"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@soHoaDon", SqlDbType.VarChar) { Value = soHoaDon }, new SqlParameter("@soHoaDon", SqlDbType.DateTime) { Value = DateTime.Now }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
public static bool DatCocTien(uint tienDatCoc, string soHD) { string query = "UPDATE HOADON SET tienDatCoc=@tienDatCoc WHERE SOHD=@soHD"; int num = 0; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@tienDatCoc", SqlDbType.Int) { IsNullable = false, Value = tienDatCoc }, new SqlParameter("@soHD", SqlDbType.VarChar) { IsNullable = false, Value = soHD }, }; try { num = Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(num == 1 ? true : false); }
public static bool ChuyenPhong(string phongHienTai, string phongChuyen) { string query = "EXEC uspChuyenPhong @maPhongHienTai,@maPhongChuyen "; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maPhongHienTai", SqlDbType.VarChar) { Value = phongHienTai }, new SqlParameter("@maPhongChuyen", SqlDbType.VarChar) { Value = phongChuyen }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
public static bool ThemKhachHang(KhachHang khachHang) { int rowNum = 0; string query = "EXEC usp_ThemKhachHang @tenKH,@loaiKH,@sdt"; string tenKH = khachHang.Ten; int loaiKH = khachHang.LoaiKH; string sdt = khachHang.SDT; List <SqlParameter> parameters = new List <SqlParameter> { new SqlParameter("@tenKH", SqlDbType.NVarChar) { IsNullable = false, Value = tenKH }, new SqlParameter("@loaiKH", SqlDbType.Int) { IsNullable = true, Value = loaiKH != 0?loaiKH:0 }, new SqlParameter("@sdt", SqlDbType.NVarChar) { IsNullable = true, Value = sdt ?? (Object)DBNull.Value } }; try { rowNum = Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (SqlException ex) { Utility.Log(ex); } return(rowNum > 0 ? true : false); }
public static bool XoaKhuyenMai(int maKhuyenMai) { string query = "EXEC uspXoaKhuyenMai @maKhuyenMai"; //truyền tham số vào câu truy vấn List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maKhuyenMai", SqlDbType.Int) { IsNullable = false, Value = maKhuyenMai } }; try { //nếu số dòng thành công trả về lớn hơn 0 thì thành công Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
public static bool CapNhatLoaiKH(LoaiKhachHang loaiKhach) { int rowNum = 0; int maLoaiKH = loaiKhach.MaLoaiKH; string tenLoaiKH = loaiKhach.TenLoaiKH; float mucKM = loaiKhach.MucKM; string query = "EXEC usp_CapNhatLoaiKH @maLoaiKH,@tenLoaiKH,@mucKM"; List <SqlParameter> parameters = new List <SqlParameter> { new SqlParameter("@maLoaiKH", SqlDbType.Int) { Value = maLoaiKH }, new SqlParameter("@tenLoaiKH", SqlDbType.VarChar) { Value = tenLoaiKH }, new SqlParameter("@mucKM", SqlDbType.Float) { Value = mucKM }, }; try { rowNum = Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); } return(rowNum > 0 ? true : false); }
public static bool CapNhatSanPham(SanPham sanPham) { string query = "EXEC uspCapNhatSanPham @ma,@ten,@maNhaCungCap,@maLoai,@donViTinh,@donGia,@soLuongToiThieu,@anhMinhHoa,@donGiaNhap"; //truyền tham số vào câu truy vấn List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@ma", SqlDbType.NVarChar) { IsNullable = false, Value = sanPham.Ma }, new SqlParameter("@ten", SqlDbType.NVarChar) { IsNullable = false, Value = sanPham.Ten }, new SqlParameter("@maNhaCungCap", SqlDbType.NVarChar) { IsNullable = false, Value = sanPham.NhaCungCap }, new SqlParameter("@maLoai", SqlDbType.VarChar) { IsNullable = false, Value = sanPham.Loai }, new SqlParameter("@donViTinh", SqlDbType.NVarChar) { IsNullable = false, Value = sanPham.DonViTinh }, new SqlParameter("@donGia", SqlDbType.Int) { IsNullable = false, Value = sanPham.Gia }, new SqlParameter("@soLuongToiThieu", SqlDbType.Int) { IsNullable = false, Value = sanPham.SoLuongToiThieu }, new SqlParameter("@anhMinhHoa", SqlDbType.NVarChar) { IsNullable = false, Value = sanPham.TenHinhAnh }, new SqlParameter("@donGiaNhap", SqlDbType.Int) { IsNullable = false, Value = sanPham.DonGiaNhap }, }; //nếu số dòng thành công trả về lớn hơn 0 thì thành công int num = Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); if (num == 0) { return(false); } return(true); }
public static bool ThemPhong(Phong phong) { string query = "EXEC uspTaoPhong @maloaiphong"; string ma = TaoMa.TaoMaPhong(); List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maloaiphong", SqlDbType.NVarChar) { Value = phong.TenLoai } }; return(Dataprovider.ExcuteNonQuery(query, parameters.ToArray()) > 0); }
public static bool CapNhatkhuyenMai(KhuyenMai khuyenMai, List <int> listLoaiKhachHang, List <float> listMucKhuyenMai) { string query = "EXEC uspCapNhatKhuyenMai @maKhuyenMai,@tenKhuyenMai,@danhSachmaLoaiKhachHang,@danhSachMucKhuyenMai,@NgayBatDau,@NgayKetThuc"; string danhSachLoaiKhachHang = String.Join("|", listLoaiKhachHang); string danhSachMucKhuyenMai = String.Join("|", listMucKhuyenMai); // Truyền tham số List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maKhuyenMai", SqlDbType.NVarChar) { IsNullable = false, Value = khuyenMai.MaKhuyenMai }, new SqlParameter("@tenKhuyenMai", SqlDbType.NVarChar) { IsNullable = false, Value = khuyenMai.TenKhuyenMai }, new SqlParameter("@danhSachmaLoaiKhachHang", SqlDbType.VarChar) { IsNullable = false, Value = danhSachLoaiKhachHang }, new SqlParameter("@danhSachMucKhuyenMai", SqlDbType.VarChar) { IsNullable = false, Value = danhSachMucKhuyenMai }, new SqlParameter("@NgayBatDau", SqlDbType.DateTime2) { IsNullable = false, Value = khuyenMai.NgayBatDau }, new SqlParameter("@NgayKetThuc", SqlDbType.DateTime2) { IsNullable = false, Value = khuyenMai.NgayKetThuc }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
public static bool SuaThietBi(ThietBi thietBi) { string query = "EXEC [usp_SuaThietBi] @ma,@tenTB,@maNCC,@dvt ,@donGia"; string tenTB = thietBi.Ten; string maNCC = thietBi.MaNCC; string dvt = thietBi.DVT; string donGia = thietBi.DonGia; bool rs = false; // Truyền tham số List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@ma", SqlDbType.NVarChar) { IsNullable = false, Value = thietBi.Ma }, new SqlParameter("@tenTB", SqlDbType.NVarChar) { IsNullable = false, Value = tenTB }, new SqlParameter("@maNCC", SqlDbType.NVarChar) { IsNullable = false, Value = maNCC }, new SqlParameter("@dvt", SqlDbType.NVarChar) { IsNullable = false, Value = dvt }, new SqlParameter("@donGia", SqlDbType.BigInt) { IsNullable = false, Value = donGia }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); rs = true; } catch (Exception ex) { Utility.Log(ex); rs = false; } return(rs); }
public static bool ThemChiTietHoaDon(string mahd, List <string> listMa, List <string> listSoLuongMa, List <string> listSp, List <string> listSoLuongSp) { string query = "EXEC uspThemChiTietHoaDon @maHD,@danhSachMa,@danhSachSoLuongMa,@danhSachSp,@danhSachSoLuongSp"; string danhSachMa = String.Join("|", listMa); string danhSachSoLuongMa = String.Join("|", listSoLuongMa); string danhSachSp = String.Join("|", listSp); string danhSachSoLuongSp = String.Join("|", listSoLuongSp); //truyền tham số vào câu truy vấn List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maHD", SqlDbType.NVarChar) { IsNullable = false, Value = mahd }, new SqlParameter("@danhSachMa", SqlDbType.NVarChar) { IsNullable = false, Value = danhSachMa }, new SqlParameter("@danhSachSoLuongMa", SqlDbType.NVarChar) { IsNullable = false, Value = danhSachSoLuongMa }, new SqlParameter("@danhSachSp", SqlDbType.NVarChar) { IsNullable = false, Value = danhSachSp }, new SqlParameter("@danhSachSoLuongSp", SqlDbType.NVarChar) { IsNullable = false, Value = danhSachSoLuongSp }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
public static bool CapNhatPhong(Phong phong) { string query = "EXEC uspCapNhatPhong @maphong,@maloaiphong"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maphong", SqlDbType.NVarChar) { Value = phong.Ten }, new SqlParameter("@maloaiphong", SqlDbType.NVarChar) { Value = phong.TenLoai } }; return(Dataprovider.ExcuteNonQuery(query, parameters.ToArray()) > 0); }
public static string TaoHoaDon() { string query = "select macuoi,soma,tiento from taoma where id=3"; DataTable table = Dataprovider.ExcuteQuery(query); DataRow row = table.Rows[0]; int maCuoi = int.Parse(row["macuoi"].ToString()) + 1; int soMa = int.Parse(row["soma"].ToString()); string tienTo = row["tiento"].ToString(); string maMoi = tienTo + maCuoi.ToString().PadLeft(soMa, '0'); query = "update taoma set macuoi=macuoi+1 where id=3"; int num = Dataprovider.ExcuteNonQuery(query); if (num == 0) { maMoi = ""; } return(maMoi); }
public static bool GhiNhanDatPhong(KhachHang khachHang, string maPhong, string maNV) { string query = "EXEC uspGhiNhanDatPhong @maPhong,@tenKhachHang,@soDienThoai,@soHoaDon,@maNV"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maPhong", SqlDbType.VarChar) { Value = maPhong }, new SqlParameter("@tenKhachHang", SqlDbType.NVarChar) { Value = khachHang.Ten }, new SqlParameter("@soDienThoai", SqlDbType.VarChar) { Value = khachHang.SoDT }, new SqlParameter("@soHoaDon", SqlDbType.VarChar) { Value = "" }, new SqlParameter("@maNV", SqlDbType.VarChar) { Value = maNV }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
public static bool CapNhatSuDungThietBi(string maSuDung, string lyDo, List <string> listMa, List <string> listSoLuong) { string query = "EXEC uspCapNhatSuDungThietBi @maSuDung,@lyDo,@danhSachThietBi,@danhSachSoLuong"; string danhSachMa = String.Join("|", listMa); string danhSachSoLuong = String.Join("|", listSoLuong); //truyền tham số vào câu truy vấn List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maSuDung", SqlDbType.NVarChar) { IsNullable = false, Value = maSuDung }, new SqlParameter("@lyDo", SqlDbType.NVarChar) { IsNullable = false, Value = lyDo }, new SqlParameter("@danhSachThietBi", SqlDbType.NVarChar) { IsNullable = false, Value = danhSachMa }, new SqlParameter("@danhSachSoLuong", SqlDbType.NVarChar) { IsNullable = false, Value = danhSachSoLuong }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
public static bool NhapHang(string soPhieuNhap, List <string> listMa, List <string> listSoLuong, uint thanhTien) { string query = "EXEC uspNhapHangSanPham @soPhieuNhap,@danhSachMa,@danhSachSoLuong,@thanhTien"; string danhSachMa = String.Join("|", listMa); string danhSachSoLuong = String.Join("|", listSoLuong); //truyền tham số vào câu truy vấn List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@soPhieuNhap", SqlDbType.NVarChar) { IsNullable = false, Value = soPhieuNhap }, new SqlParameter("@danhSachMa", SqlDbType.NVarChar) { IsNullable = false, Value = danhSachMa }, new SqlParameter("@danhSachSoLuong", SqlDbType.NVarChar) { IsNullable = false, Value = danhSachSoLuong }, new SqlParameter("@thanhTien", SqlDbType.Int) { IsNullable = false, Value = thanhTien }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
public static bool XoaLoaiKH(LoaiKhachHang loaiKhach) { int rowNum = 0; int maLoaiKH = loaiKhach.MaLoaiKH; string query = "EXEC usp_XoaLoaiKH @maLoaiKH"; List <SqlParameter> parameters = new List <SqlParameter> { new SqlParameter("@maLoaiKH", SqlDbType.Int) { Value = maLoaiKH }, }; try { rowNum = Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); } return(rowNum > 0 ? true : false); }
public static bool XoaThietBi(ThietBi thietBi) { string query = "EXCUTE usp_XoaThietBi @maTB"; string maTB = thietBi.Ma; // Truyền tham số List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maTB", SqlDbType.Char) { IsNullable = false, Value = maTB }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); return(true); } catch (Exception ex) { Utility.Log(ex); return(false); } }
public static bool XoaKhachHang(KhachHang khachHang) { int rowNum = 0; string query = "EXEC usp_XoaKhachHang @maKH"; string maKH = khachHang.Ma; List <SqlParameter> parameters = new List <SqlParameter> { new SqlParameter("@maKH", SqlDbType.NVarChar) { IsNullable = false, Value = maKH }, }; try { rowNum = Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (SqlException ex) { Utility.Log(ex); } return(rowNum > 0 ? true : false); }