public static int CapNhatLoaiBA(LoaiBanAn_DTO loaiBA)
{
Provider provider = new Provider();
string sql = string.Format("update LoaiBan set SucChua={0} where Maloai='{1}'", loaiBA.SucChua, loaiBA.MaLoai);
SqlCommand cm = provider.CreateCommandStringSql(sql);
return(provider.ExecuteInsertUpdateDelete(cm));
}
public static int ThemLoaiBanAn(LoaiBanAn_DTO LoaiBA)
{
Provider provider = new Provider();
string sql = string.Format("insert into LoaiBan values ('{0}',{1})", LoaiBA.MaLoai, LoaiBA.SucChua);
SqlCommand cm = provider.CreateCommandStringSql(sql);
return(provider.ExecuteInsertUpdateDelete(cm));
}
public static int CapNhatLoaiBA(LoaiBanAn_DTO loaiBA)
{
return(LoaiBanAn_DAO.CapNhatLoaiBA(loaiBA));
}
public static int ThemLoaiBanAn(LoaiBanAn_DTO LoaiBA)
{
return(LoaiBanAn_DAO.ThemLoaiBanAn(LoaiBA));
}