public static bool XoaNCC(string maNhaCungCap) { string query = "EXEC usp_XoaNCC @maNCC"; // Truyền tham số List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maNCC", SqlDbType.VarChar) { IsNullable = false, Value = maNhaCungCap }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); return(true); } catch (Exception ex) { Utility.Log(ex); return(false); } }
public static DataTable XemNhaCungCap(string tenNhaCungCap, int pageNumber, int pageSize) { string query = "EXEC usp_LoadNCC @tenNhaCungCap,@pageNumber,@pageSize"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@tenNhaCungCap", SqlDbType.NVarChar) { IsNullable = false, Value = tenNhaCungCap }, new SqlParameter("@pageNumber", SqlDbType.Int) { IsNullable = false, Value = pageNumber }, new SqlParameter("@pageSize", SqlDbType.Int) { IsNullable = false, Value = pageSize }, }; DataTable data = new DataTable(); try { data = Dataprovider.ExcuteQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); } return(data); }
void LoadMenu() { string querry = "SELECT MASP AS[Mã sản phẩm],TENSP AS [Tên sản phẩm] ,HOADON AS [Hóa đơn],THELOAI AS [Thể loại] FROM dbo.MENU"; Dataprovider provide = new Dataprovider(); menuDGV.DataSource = provide.ExecuteQuerry(querry); }
/// <summary> /// Initializes a new instance of the MainViewModel class. /// </summary> public DetailVm() { CultureInfo.DefaultThreadCurrentCulture = new CultureInfo("de-DE"); CultureInfo.DefaultThreadCurrentUICulture = new CultureInfo("de-DE"); msg.Register <GenericMessage <OrderSummary> >(this, ChangeSelected); AllStatuses = new string[] { "Abgeschlossen", "Angenommen", "Nicht bestätigt", "Auftrag ablehnen" }; SelectedJob = new OrderSummary(); OS = new DetailedClass(); Dp = new Dataprovider(); BtnSyncWithBackend = new RelayCommand(() => StartSync()); MyClassInitialize(); BtnApplyChanges = new RelayCommand(() => ApplyChanges()); BtnCreateReport = new RelayCommand(() => CreateReport()); BtnAppendDocuments = new RelayCommand(() => AppendDocuments()); //CreateDemoData(); }
public static bool GiaoHang(string soPhieuNhap, string nguoiGiao) { string query = "EXEC uspGiaoNguyenLieu @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); }
/// <summary> /// Xem danh sách nguyên liệu /// </summary> /// <param name="maNhaCungCap">mã nhà cung cấp</param> /// <param name="loaiNL">loại nguyên liệu</param> /// <param name="isXemToiThieu">nếu true thì ta xem các nguyên liệu đạt ngưỡng tối thiểu</param> /// <returns></returns> public static DataTable XemNguyenLieu(string tenNguyenLieu, string maNhaCungCap, bool isXemToiThieu, int pageNumber, int pageSize) { string query = "EXEC uspXemNguyenLieu @tenNguyenLieu,@maNhaCungCap,@isXemToiThieu,@pageNumber,@pageSize"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@tenNguyenLieu", SqlDbType.NVarChar) { IsNullable = true, Value = tenNguyenLieu }, new SqlParameter("@maNhaCungCap", SqlDbType.VarChar) { IsNullable = true, Value = maNhaCungCap }, new SqlParameter("@isXemToiThieu", SqlDbType.Bit) { IsNullable = true, Value = isXemToiThieu }, new SqlParameter("@pageNumber", SqlDbType.Int) { IsNullable = true, Value = pageNumber }, new SqlParameter("@pageSize", SqlDbType.Int) { IsNullable = true, Value = pageSize }, }; return(Dataprovider.ExcuteQuery(query, parameters.ToArray())); }
public static int DemMonAn(string tenMonAn, string loaiMonAn, uint donGia = 0) { string query = "EXEC uspDemMonAn @tenMonAn,@loaiMonAn,@donGia"; //truyền tham số vào câu truy vấn List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@tenMonAn", SqlDbType.NVarChar) { IsNullable = false, Value = tenMonAn }, new SqlParameter("@loaiMonAn", SqlDbType.NVarChar) { IsNullable = false, Value = loaiMonAn }, new SqlParameter("@donGia", SqlDbType.Decimal) { IsNullable = false, Value = donGia }, }; int count = 0; try { count = int.Parse(Dataprovider.ExcuteScalar(query, parameters.ToArray()).ToString()); } catch (Exception ex) { Utility.Log(ex); } return(count); }
public static List <NguyenLieuMADataSource> XemNguyenLieuMonAn(string maMonAn) { string query = "EXEC uspXemChiTietMonAn @maMonAn"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maMonAn", SqlDbType.NVarChar) { IsNullable = false, Value = maMonAn }, }; List <NguyenLieuMADataSource> list = null; try { DataTable table = Dataprovider.ExcuteQuery(query, parameters.ToArray()); list = table.AsEnumerable().ToList().ConvertAll(x => new NguyenLieuMADataSource() { Ma = x[0].ToString(), Ten = x[1].ToString(), DonViTinh = x[2].ToString(), Gia = x[3].ToString(), SoLuong = x[4].ToString(), }); } catch (Exception ex) { Utility.Log(ex); } return(list); }
public static List <PhieuNhapHangDataSource> XemChiTietPhieuNhapNguyenlieu(string soPhieuDat) { string query = "EXEC uspXemChiTietPhieuNhapNguyenLieu @soPhieuDat"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@soPhieuDat", SqlDbType.VarChar) { IsNullable = false, Value = soPhieuDat }, }; List <PhieuNhapHangDataSource> list = null; try { list = Dataprovider.ExcuteQuery(query, parameters.ToArray()).AsEnumerable().ToList().ConvertAll(x => new PhieuNhapHangDataSource() { Ma = x[1].ToString(), Ten = x[2].ToString(), Loai = x[3].ToString(), DonViTinh = x[4].ToString(), Gia = x[5].ToString(), Soluong = x[6].ToString(), Thanhtien = x[7].ToString(), }); } catch (Exception ex) { Utility.Log(ex); } return(list); }
public static DataTable DemNguyenLieu(string tenNguyenLieu, string maNhaCungCap, bool isXemToiThieu) { string query = "EXEC uspDemNguyenLieu @tenNguyenLieu,@maNhaCungCap,@isXemToiThieu"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@tenNguyenLieu", SqlDbType.NVarChar) { IsNullable = true, Value = tenNguyenLieu }, new SqlParameter("@maNhaCungCap", SqlDbType.VarChar) { IsNullable = true, Value = maNhaCungCap }, new SqlParameter("@isXemToiThieu", SqlDbType.Bit) { IsNullable = true, Value = isXemToiThieu }, }; DataTable table = null; try { table = Dataprovider.ExcuteQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); } return(table); }
// Load thông tin nhân viên public static DataTable LoadNhanVien() { // string query = "SELECT * FROM NHANVIEN WHERE TENTK IS NOT NULL"; string query = "EXEC usp_LoadNhanVien"; return(Dataprovider.ExcuteQuery(query)); }
// Kiểm tra nhân viên public static bool KiemTraNhanVien(string maNV) { string query = "select COUNT(*) from NHANVIEN where MANV = @MANV"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@MANV", SqlDbType.Char) { Value = maNV }, }; int count = 0; try { count = int.Parse(Dataprovider.ExcuteScalar(query, parameters.ToArray()).ToString()); } catch (Exception ex) { Utility.Log(ex); } if (count == 0) { return(false); } else { return(true); } }
// Xóa nhân viên public static bool XoaNhanVien(string maNV, string tenTK) { string query = "EXEC usp_XoaNhanVien @MANV, @TENTK"; // Truyền tham số List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@MANV", SqlDbType.Char) { IsNullable = false, Value = maNV }, new SqlParameter("@TENTK", SqlDbType.VarChar) { IsNullable = false, Value = tenTK }, }; try { Dataprovider.ExcuteQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
public static bool ThemNCC(NhaCungCap ncc) { string query = "EXECUTE usp_ThemNCC @tenNCC,@sdt,@diaChi"; string tenNCC = ncc.Ten; string sdt = ncc.SDT; string diaChi = ncc.DiaChi; // Truyền tham số List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@tenNCC", SqlDbType.NVarChar) { IsNullable = false, Value = tenNCC }, new SqlParameter("@sdt", SqlDbType.NVarChar) { IsNullable = true, Value = sdt ?? (Object)DBNull.Value }, new SqlParameter("@diaChi", SqlDbType.NVarChar) { IsNullable = true, Value = diaChi ?? (Object)DBNull.Value }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); return(true); } catch (Exception ex) { Utility.Log(ex); } return(false); }
void LoadData() { string querry = "SELECT MANV AS [Mã nhân viên],TENNV AS[Tên nhân viên], NGAYSINH AS [Ngày sinh],GIOITINH AS[Giới tính],LUONG AS[Lương],VITRI AS [Vị trí] FROM NVINFO"; Dataprovider provide = new Dataprovider(); nhanVienDgv.DataSource = provide.ExecuteQuerry(querry); }
public static bool XoaNguyenLieu(string maNguyenLieu) { string query = "EXEC uspXoaNguyenLieu @maNguyenLieu"; //truyền tham số vào câu truy vấn List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maNguyenLieu", SqlDbType.NVarChar) { IsNullable = false, Value = maNguyenLieu } }; 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 XoaPhanCong(String maNV, String maCa, DateTime ngay) { string query = "EXEC usp_XoaPhanCong @maNV,@maCa,@ngay"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maNV", SqlDbType.VarChar) { IsNullable = false, Value = maNV }, new SqlParameter("@maCa", SqlDbType.VarChar) { IsNullable = false, Value = maCa }, new SqlParameter("@ngay", SqlDbType.DateTime) { IsNullable = false, Value = ngay }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); return(true); } catch (Exception ex) { Utility.Log(ex); } return(false); }
void LoadNV() { string querry = "SELECT TENSP AS [Tên sản phẩm] FROM dbo.MENU "; Dataprovider provide = new Dataprovider(); cbMenu.Text = provide.ExecuteQuerry(querry).ToString(); }
public static bool XoaCaLamViec(CaLamViec ca) { int rowCount = 0; int maCa = ca.MaCa; string tenCa = ca.TenCa; DateTime gioBD = ca.GioBD; DateTime gioKT = ca.GioKT; int tienLuong = ca.TienLuong; string query = "EXEC usp_XoaCaTruc @maCa"; List <SqlParameter> parameters = new List <SqlParameter> { new SqlParameter("@maCa", SqlDbType.Int) { IsNullable = false, Value = maCa }, }; try { rowCount = Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); } return(rowCount > 0 ? true : false); }
// Kiểm tra tài khoản public static bool KiemTraTaiKhoan(string tenTaiKhoan) { string query = "select COUNT(*) from TAIKHOAN where TENTK = @TENTK"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@TENTK", SqlDbType.VarChar) { Value = tenTaiKhoan }, }; int count = 0; try { count = int.Parse(Dataprovider.ExcuteScalar(query, parameters.ToArray()).ToString()); } catch (Exception ex) { Utility.Log(ex); } if (count == 0) { return(false); } else { return(true); } }
// Tạo tài khoản mới public static bool TaoTaiKhoan(TaiKhoan taiKhoan) { string query = "EXEC usp_TaoTaiKhoan @TENTK, @MATKHAU"; string tenTaiKhoan = taiKhoan.TenTaiKhoan; string matKhau = taiKhoan.MatKhau; // Truyền tham số List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@TENTK", SqlDbType.VarChar) { IsNullable = false, Value = tenTaiKhoan }, new SqlParameter("@MATKHAU", SqlDbType.VarChar) { IsNullable = false, Value = matKhau } }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
public static DataTable XemLuongTong(String maNV, String thangLuong) { string query = "EXECUTE usp_XemLuong @maNV ,@thangLuong"; List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maNV", SqlDbType.NVarChar) { IsNullable = true, Value = maNV ?? (Object)DBNull.Value }, new SqlParameter("@thangLuong", SqlDbType.NVarChar) { IsNullable = true, Value = thangLuong ?? (Object)DBNull.Value } }; DataTable table = null; try { table = Dataprovider.ExcuteQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); } return(table); }
public CompanyDataVm() { msg.Register <GenericMessage <string> >(this, ChangeData); BtnChangeClicked = new RelayCommand(() => UpdateCompanyData()); Datahandler = new Dataprovider(); GetCompanyData(); }
void LoadKPI() { string querry = " SELECT TONGKPI AS[Tổng doanh thu], KPIMOMO AS[Doanh thu MoMo],KPIVISA AS[Doanh thu visa], KPICASH AS[Doanh thu tiền mặt] FROM DOANHTHU"; Dataprovider provide = new Dataprovider(); doanhthuDgv.DataSource = provide.ExecuteQuerry(querry); }
public DetailVm() { CultureInfo.DefaultThreadCurrentCulture = new CultureInfo("de-DE"); CultureInfo.DefaultThreadCurrentUICulture = new CultureInfo("de-DE"); msg.Register<GenericMessage<OrderSummary>>(this, ChangeSelected); AllStatuses = new string[] { "Abgeschlossen", "Angenommen", "Nicht bestätigt", "Auftrag ablehnen" }; SelectedJob = new OrderSummary(); OS = new DetailedClass(); Dp = new Dataprovider(); BtnApplyChanges = new RelayCommand(() => ApplyChanges()); BtnCreateReport = new RelayCommand(() => CreateReport()); BtnAppendDocuments = new RelayCommand(() => AppendDocuments()); BtnAddPicture = new RelayCommand<OrderItemReport_>( (p) => { OpenFileDialog openFileDialog = new OpenFileDialog { Title = "Select a picture", Filter = "Image files (*.jpg, *.jpeg, *.jpe, *.jfif, *.png) | *.jpg; *.jpeg; *.jpe; *.jfif; *.png" }; if ((bool)openFileDialog.ShowDialog()) { int i = 0; foreach (var item in SelectedDetailed.OrderItemReports) { item.Visibility = "Collapsed"; if (p == item) { SelectedDetailed.OrderItemReports[i].Appendix.Add(new OrderItemReportAppendix() { OrderItemReportId = item.Id , Picture = ImageConverter.ImageToByteArray(new BitmapImage(new Uri(openFileDialog.FileName, UriKind.Absolute))) }); item.Visibility = "Visible"; //TODO: Does it work? RaisePropertyChanged(nameof(SelectedDetailed)); } RaisePropertyChanged(nameof(item.Visibility)); i++; } } }); CreateDateTime("4:45"); //CreateDemoData(); }
public static bool SuaMonAn(MonAn monAn, string listNguyenLieu, string listSoLuong) { //Thêm món ăn string query = " EXEC uspSuaMonAn @maMonAn,@listNguyenLieu,@listSoLuong,@tenmon,@loaimon,@anhminhhoa,@dongia"; //truyền tham số vào câu truy vấn List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@maMonAn", SqlDbType.VarChar) { IsNullable = false, Value = monAn.Ma }, new SqlParameter("@listNguyenLieu", SqlDbType.VarChar) { IsNullable = false, Value = listNguyenLieu }, new SqlParameter("@listSoLuong", SqlDbType.VarChar) { IsNullable = false, Value = listSoLuong }, new SqlParameter("@tenmon", SqlDbType.NVarChar) { IsNullable = false, Value = monAn.Ten }, new SqlParameter("@loaimon", SqlDbType.NVarChar) { IsNullable = false, Value = monAn.Loai }, new SqlParameter("@anhminhhoa", SqlDbType.VarChar) { IsNullable = false, Value = monAn.TenHinhAnh }, new SqlParameter("@dongia", SqlDbType.Decimal) { IsNullable = false, Value = monAn.Gia }, }; try { Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
public static DataTable LayThangHoaDon() { DataTable data = new DataTable(); string query = "EXEC usp_LayThangHoaDon"; try { data = Dataprovider.ExcuteQuery(query); }catch (Exception ex) { Utility.Log(ex); } return(data); }
// Cập nhật thông tin nhân viên public static bool CapNhatNhanVien(NhanVien nv, string maCV, string tenTK) { string query = "EXEC usp_CapNhatNhanVien @MANV, @TENTK, @MACV, @TENNV, @SDT, @DIACHI"; string maNV = nv.MaNV; string tenNV = nv.HoTen; string sdt = nv.SoDienThoai; string diaChi = nv.DiaChi; // Truyền tham số List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@MANV", SqlDbType.Char) { IsNullable = false, Value = maNV }, new SqlParameter("@TENTK", SqlDbType.VarChar) { IsNullable = false, Value = tenTK }, new SqlParameter("@MACV", SqlDbType.Char) { IsNullable = false, Value = maCV }, new SqlParameter("@TENNV", SqlDbType.NVarChar) { IsNullable = false, Value = tenNV }, new SqlParameter("@SDT", SqlDbType.NVarChar) { IsNullable = false, Value = sdt }, new SqlParameter("@DIACHI", SqlDbType.NVarChar) { IsNullable = false, Value = diaChi }, }; try { Dataprovider.ExcuteQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); return(false); } return(true); }
public static List <MonAn> XemMonAn(string tenMonAn, int loaiMonAn, int pageNumber, int pageSize, uint donGia = 0) { string query = "EXEC uspXemMonAn @tenMonAn,@loaiMonAn,@donGia,@pageNumber,@pageSize"; //truyền tham số vào câu truy vấn List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@tenMonAn", SqlDbType.NVarChar) { IsNullable = false, Value = tenMonAn }, new SqlParameter("@loaiMonAn", SqlDbType.Int) { IsNullable = false, Value = loaiMonAn }, new SqlParameter("@donGia", SqlDbType.Decimal) { IsNullable = false, Value = donGia }, new SqlParameter("@pageNumber", SqlDbType.Int) { IsNullable = false, Value = pageNumber }, new SqlParameter("@pageSize", SqlDbType.Int) { IsNullable = false, Value = pageSize }, }; List <MonAn> list = new List <MonAn>(); try { DataTable table = Dataprovider.ExcuteQuery(query, parameters.ToArray()); list = table.AsEnumerable().ToList().ConvertAll(x => new MonAn() { Ma = x[0].ToString(), Ten = x[1].ToString(), Loai = x[2].ToString(), TenHinhAnh = x[3].ToString(), Gia = uint.Parse(x[4].ToString()) }); } catch (Exception ex) { Utility.Log(ex); } return(list); }
/// <summary> /// Nhập nguyên liệu /// </summary> /// <param name="nguyenLieu"> các thông tin về nguyên liệu</param> /// <returns></returns> public static bool NhapNguyenLieu(NguyenLieu nguyenLieu) { string query = "insert into NGUYENLIEU(manl,mancc,tennl,dvt,dongia,slton,sltoithieu,dongianhap) " + "values (@manl,@mancc,@tennl,@dvt,@dongia,0,@sltoithieu,@donGiaNhap)"; //Tạo mã cho nguyên liệu string manl = TaoMa.TaoMaNguyenLieu(); //truyền tham số vào câu truy vấn List <SqlParameter> parameters = new List <SqlParameter>() { new SqlParameter("@manl", SqlDbType.NVarChar) { IsNullable = false, Value = manl }, new SqlParameter("@mancc", SqlDbType.NVarChar) { IsNullable = false, Value = nguyenLieu.NhaCungCap }, new SqlParameter("@tennl", SqlDbType.NVarChar) { IsNullable = false, Value = nguyenLieu.Ten }, new SqlParameter("@dvt", SqlDbType.NVarChar) { IsNullable = false, Value = nguyenLieu.DonViTinh }, new SqlParameter("@dongia", SqlDbType.Decimal) { IsNullable = false, Value = nguyenLieu.Dongia }, new SqlParameter("@sltoithieu", SqlDbType.Int) { IsNullable = false, Value = nguyenLieu.SoLuongToiThieu }, new SqlParameter("@donGiaNhap", SqlDbType.Int) { IsNullable = false, Value = nguyenLieu.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); }