public int themNhanVien(NhanVien nv)
{
//string query = string.Format("INSERT dbo.NhanVien(MaNV, TenNV, DiaChi, SDT, NgaySinh,GT, ChucVu, Luongcb, PhuCap, HSLuong, Thuong) VALUES ( N'{0}' , N'{1}' , N'{2}' , N'{3}' , '{4}' ,N'{5}' , N'{6}' , {7} , {8} , {9} , {10} )",nv.maNV,nv.tenNV,nv.diaChi,nv.sDT,nv.ngaySinh,nv.gT,nv.chucVu,nv.luongCB,nv.phuCap,nv.hSLuong,nv.thuong);
string query = "INSERT dbo.NhanVien(MaNV, TenNV, DiaChi, SDT, NgaySinh,GT, ChucVu, Luongcb, PhuCap, HSLuong, Thuong) VALUES ( @manv , @tennv , @dc , @sdt , @ns , @gt , @cv , @lcb , @pc , @hsl , @thuong )";
return(DatabaseDAL.executeNonQuery(query, nv.maNV, nv.tenNV, nv.diaChi, nv.sDT, nv.ngaySinh, nv.gT, nv.chucVu, nv.luongCB, nv.phuCap, nv.hSLuong, nv.thuong));
}
public int SuaChungLoai(ChungLoai ch)
{
string query = " UPDATE dbo.ChungLoai " +
" SET TenLoai = @ten " +
" WHERE MaLoai = @ma ";
return(DatabaseDAL.executeNonQuery(query, ch.tenLoai, ch.maLoai));
}
public int ThemChungLoai(ChungLoai ch)
{
string query = "INSERT INTO dbo.ChungLoai" +
"(MaLoai, TenLoai)" +
" VALUES(@ma, @ten) ";
return(DatabaseDAL.executeNonQuery(query, ch.maLoai, ch.tenLoai));
}
public int SuaHangHoa(HangHoa hh)
{
string query = "UPDATE dbo.HangHoa" +
" SET TenHang=@tenhang , MaLoai=@maloai , NSX=@nsx ,HSD=@hsd ,SoLuong=@sl ,Gia=@gia ,MaNsx=@man ,Vitri= @vitri " +
"WHERE MaHang =@ma";
return(DatabaseDAL.executeNonQuery(query, hh.tenHang, hh.maLoai, hh.NSX, hh.HSD, hh.soLuong, hh.gia, hh.maNSX, hh.viTri, hh.maHang));
}
public int ThemHangHoa(HangHoa hh)
{
string query = "INSERT INTO dbo.HangHoa" +
"(MaHang, TenHang, MaLoai, NSX, HSD, SoLuong, Gia, MaNsx, Vitri)" +
" VALUES(@ma, @ten, @maloai, @nsx, @hsd, @sl, @gia, @mansx, @vitri)";
return(DatabaseDAL.executeNonQuery(query, hh.maHang, hh.tenHang, hh.maLoai, hh.NSX, hh.HSD, hh.soLuong, hh.gia, hh.maNSX, hh.viTri));
}
public int XoaChungLoai(string ma)
{
string query = " DELETE dbo.ChungLoai WHERE MaLoai = @ma";
return(DatabaseDAL.executeNonQuery(query, ma));
}
public int XoaHangHoa(string ma)
{
string query = "DELETE dbo.HangHoa WHERE MaHang = @ma";
return(DatabaseDAL.executeNonQuery(query, ma));
}
public int xoaNhanVien(string maNV)
{
string query = "UPDATE dbo.HoaDon SET MaNV=NULL WHERE MaNV=@manv DELETE FROM dbo.NhanVien WHERE MaNV = @manv";
return(DatabaseDAL.executeNonQuery(query, maNV));
}
public int suaNhanVien(NhanVien nv)
{
string query = "UPDATE dbo.NhanVien SET TenNV=@ten,DiaChi=@dc,SDT=@sdt,NgaySinh=@ns,GT=@gt,ChucVu=@chv,Luongcb=@lucb,PhuCap=@pc,HSLuong=@hsl,Thuong=@thug WHERE MaNV=@manv";
return(DatabaseDAL.executeNonQuery(query, nv.tenNV, nv.diaChi, nv.sDT, nv.ngaySinh, nv.gT, nv.chucVu, nv.luongCB, nv.phuCap, nv.hSLuong, nv.thuong, nv.maNV));
}
