/// <summary>
///
/// </summary>
/// <returns></returns>
public OperationCategoryCollection GetAllOperationCategories()
{
try
{
OperationCategoryCollection collection = new OperationCategoryCollection();
collection.Clear();
using (IDataReader dr = Database.ExecuteReader("UspGetAllOperationCategories", CommandType.StoredProcedure))
{
while (dr.Read())
{
OperationCategory category = Populate(dr);
collection.Add(category);
}
}
return(collection);
}
catch (Exception ex)
{
throw ex;
}
}
public OperationCategoryCollection GetOperationCategoriesByResourceTypeCode(string ResourceTypeCode)
{
try
{
OperationCategoryCollection collection = new OperationCategoryCollection();
// create sql parameters
SqlParameter prmResourceTypeCode = new SqlParameter("@ResourceTypeCode", SqlDbType.VarChar, 10);
prmResourceTypeCode.Direction = ParameterDirection.Input;
prmResourceTypeCode.Value = ResourceTypeCode;
using (IDataReader dr = Database.ExecuteReader("UspGetOperationCatByResourceType", CommandType.StoredProcedure, prmResourceTypeCode))
{
while (dr.Read())
{
OperationCategory operationCat = Populate(dr);
collection.Add(operationCat);
}
}
return(collection);
}
catch (Exception ex)
{
throw ex;
}
}
