public List <M_Formula> GetFormulas(string id, EnmSSH type) { SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100), new SqlParameter("@Type", SqlDbType.Int) }; parms[0].Value = id; parms[1].Value = (int)type; var entities = new List <M_Formula>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_M_Formula_Repository_GetFormulas, parms)) { while (rdr.Read()) { var entity = new M_Formula(); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.Type = SqlTypeConverter.DBNullEnmSSHHandler(rdr["Type"]); entity.FormulaType = SqlTypeConverter.DBNullEnmFormulaHandler(rdr["FormulaType"]); entity.ComputeType = SqlTypeConverter.DBNullEnmComputeHandler(rdr["ComputeType"]); entity.FormulaText = SqlTypeConverter.DBNullStringHandler(rdr["FormulaText"]); entity.FormulaValue = SqlTypeConverter.DBNullStringHandler(rdr["FormulaValue"]); entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]); entities.Add(entity); } } return(entities); }
public List <Formula> GetEntities() { var entities = new List <Formula>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_Formula_Repository_GetAllEntities, null)) { while (rdr.Read()) { var entity = new Formula(); entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]); entity.Type = SqlTypeConverter.DBNullEnmSSHHandler(rdr["Type"]); entity.FormulaType = SqlTypeConverter.DBNullEnmFormulaHandler(rdr["FormulaType"]); entity.ComputeType = SqlTypeConverter.DBNullEnmComputeHandler(rdr["ComputeType"]); entity.FormulaText = SqlTypeConverter.DBNullStringHandler(rdr["FormulaText"]); entity.FormulaValue = SqlTypeConverter.DBNullStringHandler(rdr["FormulaValue"]); entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Comment"]); entities.Add(entity); } } return(entities); }