public static CategoryReduction GetCategoryReductionByCategoryReductionId(int categoryReductionId) { Database db = DatabaseFactory.CreateDatabase("SPARInsightManagement"); string sqlCommand = "GetCategoryReductionByCategoryReductionId"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@CategoryReductionId", DbType.Int32, categoryReductionId); db.AddOutParameter(dbCommand, "@Description", DbType.String, 50); db.ExecuteNonQuery(dbCommand); CategoryReduction categoryReduction = new CategoryReduction(); categoryReduction.CategoryReductionId = categoryReductionId; categoryReduction.Description = db.GetParameterValue(dbCommand, "Description").ToString(); return(categoryReduction); }
public static List <CategoryReduction> GetCategoryReductionList() { List <CategoryReduction> list = new List <CategoryReduction>(); Database db = DatabaseFactory.CreateDatabase("SPARInsightManagement"); string sqlCommand = "GetCategoryReductionList"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { while (dataReader.Read()) { CategoryReduction categoryReduction = new CategoryReduction(); categoryReduction.CategoryReductionId = Convert.ToInt32(dataReader["CategoryReductionId"]); categoryReduction.Description = dataReader["Description"].ToString(); list.Add(categoryReduction); } } return(list); }