Beispiel #1
0
        public C_SubLogicType GetSubLogicType(string id)
        {
            SqlParameter[] parms = { new SqlParameter("@Id", SqlDbType.VarChar, 100) };
            parms[0].Value = SqlTypeConverter.DBNullStringChecker(id);

            C_SubLogicType entity = null;

            using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_C_LogicType_Repository_GetSubLogicType, parms)) {
                if (rdr.Read())
                {
                    entity             = new C_SubLogicType();
                    entity.Id          = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
                    entity.Name        = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
                    entity.LogicTypeId = SqlTypeConverter.DBNullStringHandler(rdr["LogicTypeId"]);
                }
            }
            return(entity);
        }