protected MRS.Model.HspType Parse(SqlDataReader Reader) { MRS.Model.HspType hspType = new MRS.Model.HspType(); hspType.Id = Convert.ToInt32(Reader[DSL.HspType.ID_FIELD]); hspType.Name = Reader[DSL.HspType.NAME_FIELD].ToString().Trim(); return(hspType); }
public IList <MRS.Model.HspType> GetHspTypes() { IList <MRS.Model.HspType> hspTypes = new List <MRS.Model.HspType>(); using (SqlDataReader reader = SqlHelper.ExecuteReader(ConnectionString.ConnectionStringMRS, CommandType.StoredProcedure, DSL.CommandText.SELECT_HSPTYPE, null)) { while (reader.Read()) { MRS.Model.HspType hspType = Parse(reader); hspTypes.Add(hspType); } } return(hspTypes); }
public MRS.Model.HspType GetHspTypeById(int Id) { MRS.Model.HspType hspType = new MRS.Model.HspType(); SqlParameter id_parm = new SqlParameter(DSL.HspType.ID_PARM, SqlDbType.Int); id_parm.Value = Id; using (SqlDataReader reader = SqlHelper.ExecuteReader(ConnectionString.ConnectionStringMRS, CommandType.StoredProcedure, CommandText.SELECT_HSPTYPE_BY_ID, id_parm)) { if (reader.Read()) { hspType = Parse(reader); } } return(hspType); }