private List <objCategory> Select_liObj(IDataReader idr)
{
List <objCategory> rt = new List <objCategory>();
bool rtNull = true;
if (idr != null)
{
while (idr.Read())
{
objCategory o = new objCategory();
if (idr["accCatID"] != DBNull.Value)
{
o.accCatID = Convert.ToInt32(idr["accCatID"]);
}
if (idr["accCatTitle"] != DBNull.Value)
{
o.accCatTitle = Convert.ToString(idr["accCatTitle"]);
}
if (idr["accCatDescription"] != DBNull.Value)
{
o.accCatDescription = Convert.ToString(idr["accCatDescription"]);
}
rtNull = false;
rt.Add(o);
}
}
if (rtNull)
{
rt = null;
}
return(rt);
}
public objCategory Select(int catId)
{
IDataReader idr = db.Select(catId);
objCategory objCat = new objCategory();
objCat = Select_Obj(idr);
return(objCat);
}
public void Update(objCategory i)
{
db.Update(
i.accCatID, i.accCatTitle, i.accCatDescription);
}
public void Add(objCategory i)
{
db.Add(
i.accCatID, i.accCatTitle, i.accCatDescription);
}