public DataRow GetSanPhamByMaSP(int MaSP)
{
string condition = "MaSP = " + MaSP;
DataRow[] dataRows = new SanPham_DAO().GetTableProduct().Select(condition);
return(dataRows[0]);
}
public string MaSPTiepTheo()
{
SanPham_DAO spDAO = new SanPham_DAO();
string MaLonNhat = spDAO.LayMaSPLonNhat();
if (string.IsNullOrEmpty(MaLonNhat))
{
// truong hop k co ma lon nhat
return("sp01");
}
else
{
int maso = int.Parse(MaLonNhat.Replace("sp", ""));
return("sp" + (maso + 1).ToString("00"));
}
}
public void ThemSanPham(SanPham_DTO sp, int trangthai)
{
SanPham_DAO dao = new SanPham_DAO();
dao.ThemSanPham(sp, trangthai);
}
public List <SanPham_DTO> LayDanhSachSanPham()
{
SanPham_DAO objsanPham_DAO = new SanPham_DAO();
return(objsanPham_DAO.layDanhSachSanPham());
}
public static DataTable timkiemNC(string ma, string ten, string loai, string from, string to, string sx, string soluong)
{
return(SanPham_DAO.timkiemNC(ma, ten, loai, from, to, sx, soluong));
}
public static DataTable timkiem(string ma)
{
return(SanPham_DAO.timkiem(ma));
}
public static void XoaSP(string MaSP)
{
SanPham_DAO.XoaSP(MaSP);
}
public List <SanPham_DTO> DanhSachSanPham()
{
SanPham_DAO spDAO = new SanPham_DAO();
return(spDAO.LayDanhSachSanPham());
}
public List <SanPham_DTO> TimSanPhamTheoMa(string MaSP)
{
SanPham_DAO objsanPham_DAO = new SanPham_DAO();
return(objsanPham_DAO.TimSanPhamTheoMa(MaSP));
}
public static DataTable hienthi()
{
return(SanPham_DAO.hienthi());
}
public List <SanPham_DTO> RetrieveTable_SanPham(List <string> condition)
{
SanPham_DAO obj = new SanPham_DAO();
return(obj.RetrieveTable_SanPham(condition));
}
public bool XoaSP(SanPham_DTO spDTO)
{
SanPham_DAO spDAO = new SanPham_DAO();
return(spDAO.XoaSP(spDTO));
}
public bool CapNhapSP(SanPham_DTO spDTO)
{
SanPham_DAO spDAO = new SanPham_DAO();
return(spDAO.CapNhapSP(spDTO));
}
public bool ThemSP(SanPham_DTO spDTO)
{
SanPham_DAO spDao = new SanPham_DAO();
return(spDao.ThemMoiSP(spDTO));
}
public void XoaSanPham(SanPham_DTO sp)
{
SanPham_DAO dao = new SanPham_DAO();
dao.XoaSanPham(sp);
}
public void SuaThongTinSanPham(SanPham_DTO sp)
{
SanPham_DAO dao = new SanPham_DAO();
dao.SuaThongTinSanPham(sp);
}
public static void ThemSP(SanPham_DTO sp)
{
SanPham_DAO.ThemSP(sp);
}
public static void SuaSP(SanPham_DTO sp, string macu)
{
SanPham_DAO.SuaSP(sp, macu);
}
public static DataTable timKiemSanPham(string tenSP, string loaiSP)
{
return(SanPham_DAO.timKiemSanPham(tenSP, loaiSP));
}
