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