public IList<Core.Business.Rprovince> GetAllRprovince() { IList<Core.Business.Rprovince> rprovincelist = new List<Core.Business.Rprovince>(); ImportSqlServerUtility sql = new ImportSqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllRprovince); if(reader != null) { while(reader.Read()) { Core.Business.Rprovince rprovince = new Core.Business.Rprovince(); if (!reader.IsDBNull(0)) rprovince.NProcinceId = reader.GetGuid(0); if (!reader.IsDBNull(1)) rprovince.OProvinceId = reader.GetString(1); rprovince.MarkOld(); rprovincelist.Add(rprovince); } reader.Close(); } return rprovincelist; }
public Core.Business.Rprovince Select(System.Int32 id) { ImportSqlServerUtility sql = new ImportSqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectRprovince); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.Rprovince rprovince = new Core.Business.Rprovince(); if (!reader.IsDBNull(0)) rprovince.NProcinceId = reader.GetGuid(0); if (!reader.IsDBNull(1)) rprovince.OProvinceId = reader.GetString(1); reader.Close(); return rprovince; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }