public ObservableCollection <vo_HangHoa> GetAllHangHoa()
{
try
{
dao_HangHoa dao = new dao_HangHoa();
DataTable dt = dao.getAllHangHoa();
ObservableCollection <vo_HangHoa> dsHangHoa = new ObservableCollection <vo_HangHoa>();
foreach (DataRow dr in dt.Rows)
{
vo_HangHoa vo = new vo_HangHoa();
vo.Id = int.Parse(dr["ID"].ToString());
vo.IdLoaiHangHoa = int.Parse(dr["ID_LOAIHANGHOA"].ToString());
vo.LoaiHangHoa = dr["LOAIHANGHOA"].ToString();
vo.GiaVon = int.Parse(dr["GIAVON"].ToString());
vo.GiaBan = int.Parse(dr["GIABAN"].ToString());
vo.GiaGiam = int.Parse(dr["GIAGIAM"].ToString());
vo.GhiChu = dr["GHICHU"].ToString();
vo.MaHangHoa = dr["MAHANGHOA"].ToString();
vo.TenHangHoa = dr["TENHANGHOA"].ToString();
vo.UrlImage = dr["URL_IMAGE"].ToString();
vo.TonKho = int.Parse(dr["TONKHO"].ToString());
dsHangHoa.Add(vo);
}
return(dsHangHoa);
}
catch (Exception ex)
{
throw ex;
}
}
public vo_HangHoa getHangHoaById(int _id)
{
try
{
dao_HangHoa dao = new dao_HangHoa();
vo_HangHoa vo = new vo_HangHoa();
DataTable dt = dao.GetHangHoaById(_id);
vo.Id = int.Parse(dt.Rows[0]["ID"].ToString());
vo.IdLoaiHangHoa = int.Parse(dt.Rows[0]["ID_LOAIHANGHOA"].ToString());
vo.LoaiHangHoa = dt.Rows[0]["LOAIHANGHOA"].ToString();
vo.GiaVon = int.Parse(dt.Rows[0]["GIAVON"].ToString());
vo.GiaBan = int.Parse(dt.Rows[0]["GIABAN"].ToString());
vo.GiaGiam = int.Parse(dt.Rows[0]["GIAGIAM"].ToString());
vo.GhiChu = dt.Rows[0]["GHICHU"].ToString();
vo.MaHangHoa = dt.Rows[0]["MAHANGHOA"].ToString();
vo.TenHangHoa = dt.Rows[0]["TENHANGHOA"].ToString();
vo.UrlImage = dt.Rows[0]["URL_IMAGE"].ToString();
vo.TonKho = int.Parse(dt.Rows[0]["TONKHO"].ToString());
return(vo);
}
catch (Exception ex)
{
throw ex;
}
}
public int UpdateHangHoa(vo_HangHoa _vo)
{
try
{
dao_HangHoa _dao = new dao_HangHoa();
int id = _dao.UpdateHangHoa(_vo);
return(id);
}
catch (Exception ex)
{
throw ex;
}
}
public int DeleteHangHoa(int _id)
{
try
{
dao_HangHoa _dao = new dao_HangHoa();
int id = _dao.DeleteHangHoa(_id);
return(id);
}
catch (Exception ex)
{
throw ex;
}
}
public int AddHangHoa(vo_HangHoa vo)
{
try
{
dao_HangHoa dao = new dao_HangHoa();
int id = dao.InsertHangHoa(vo);
return(id);
}
catch (Exception ex)
{
throw ex;
}
}
public string GenerateMaHangHoa()
{
try
{
dao_HangHoa dao = new dao_HangHoa();
int id = dao.GetLastHangHoaID() + 1;
string code = "HH" + String.Format("{0:000000}", id);
return(code);
}
catch (Exception ex)
{
throw ex;
}
}
