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