public IList<Core.Business.InstrumentCode> GetAllInstrumentCode() { IList<Core.Business.InstrumentCode> instrumentCodelist = new List<Core.Business.InstrumentCode>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectInstrumentCodesAll"); if(reader != null) { while(reader.Read()) { Core.Business.InstrumentCode instrumentCode = new Core.Business.InstrumentCode(); if (!reader.IsDBNull(0)) instrumentCode.Id = reader.GetGuid(0); instrumentCode.MarkOld(); instrumentCodelist.Add(instrumentCode); } reader.Close(); } return instrumentCodelist; }
public Core.Business.InstrumentCode Select(Guid id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@InstruId", SqlDbType.UniqueIdentifier, id); SqlDataReader reader = sql.ExecuteSPReader("usp_SelectInstrumentCode"); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.InstrumentCode instrumentCode = new Core.Business.InstrumentCode(); if (!reader.IsDBNull(0)) instrumentCode.Id = reader.GetGuid(0); reader.Close(); return instrumentCode; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }