public List <C_EnumMethod> GetEnums() { var entities = new List <C_EnumMethod>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_C_EnumMethod_Repository_GetEnums, null)) { while (rdr.Read()) { var entity = new C_EnumMethod(); entity.Id = SqlTypeConverter.DBNullInt32Handler(rdr["Id"]); entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]); entity.TypeId = SqlTypeConverter.DBNullInt32Handler(rdr["TypeId"]); entity.Index = SqlTypeConverter.DBNullInt32Handler(rdr["Index"]); entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]); entities.Add(entity); } } return(entities); }
public C_EnumMethod GetEnumById(int id) { SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.Int) }; parms[0].Value = SqlTypeConverter.DBNullInt32Checker(id); C_EnumMethod entity = null; using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_C_EnumMethod_Repository_GetEnumById, parms)) { if (rdr.Read()) { entity = new C_EnumMethod(); entity.Id = SqlTypeConverter.DBNullInt32Handler(rdr["Id"]); entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]); entity.TypeId = SqlTypeConverter.DBNullInt32Handler(rdr["TypeId"]); entity.Index = SqlTypeConverter.DBNullInt32Handler(rdr["Index"]); entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]); } } return(entity); }
public List <C_EnumMethod> GetEnumsByType(EnmMethodType type, string comment) { SqlParameter[] parms = { new SqlParameter("@TypeId", SqlDbType.Int), new SqlParameter("@Comment", SqlDbType.VarChar, 512) }; parms[0].Value = (int)type; parms[1].Value = SqlTypeConverter.DBNullStringChecker(comment); var entities = new List <C_EnumMethod>(); using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_C_EnumMethod_Repository_GetEnumsByType, parms)) { while (rdr.Read()) { var entity = new C_EnumMethod(); entity.Id = SqlTypeConverter.DBNullInt32Handler(rdr["Id"]); entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]); entity.TypeId = SqlTypeConverter.DBNullInt32Handler(rdr["TypeId"]); entity.Index = SqlTypeConverter.DBNullInt32Handler(rdr["Index"]); entity.Comment = SqlTypeConverter.DBNullStringHandler(rdr["Desc"]); entities.Add(entity); } } return(entities); }