public ProductCategory Get(int nProductCategoryID, int nUserID)
{
Connection.Open();
Command.CommandText = ProductCategoryDA.Get(nProductCategoryID, nUserID);
SqlDataReader reader = Command.ExecuteReader();
ProductCategory _oProductCategory = new ProductCategory();
if (reader.HasRows)
{
_oProductCategory = MakeObject(reader);
}
reader.Close();
Connection.Close();
return(_oProductCategory);
}
public List <ProductCategory> GetsByProductType(int nProductType, int nUserID)
{
Connection.Open();
Command.CommandText = ProductCategoryDA.GetsByProductType(nProductType, nUserID);
SqlDataReader reader = Command.ExecuteReader();
ProductCategory _oProductCategory = new ProductCategory();
List <ProductCategory> _oProductCategorys = new List <ProductCategory>();
if (reader.HasRows)
{
_oProductCategorys = MakeObjects(reader);
}
reader.Close();
Connection.Close();
return(_oProductCategorys);
}
public ProductCategory IUD(ProductCategory oProductCategory, EnumDBOperation eDBAction, int userid)
{
Connection.Open();
Command.CommandText = ProductCategoryDA.IUD(oProductCategory, eDBAction, userid);
SqlDataReader reader = Command.ExecuteReader();
ProductCategory _oProductCategory = new ProductCategory();
if (reader.HasRows)
{
_oProductCategory = MakeObject(reader);
}
reader.Close();
Connection.Close();
return(_oProductCategory);
}
