protected EntityList GetList(string cmdText, CommandType cmdType, IDbDataParameter[] cmdParams, DistributedTransaction DT) { EntityList theList = new EntityList(); EntityBase result = null; IDataReader reader = DataAccessHelper.ExecuteReader(cmdText, cmdType, cmdParams, DT); SafeDataReader safeReader = new SafeDataReader(reader); while (safeReader.Read()) { result = this.CreateAndBuildEntity(safeReader); theList.Add(result); } safeReader.Close(); return(theList); }
public ICollection <PhoneType> GetData() { var command = _dbPhoneTypeCommandProvider.GetGetDataDbCommand(); command.Connection = _dbConnHolder.Connection; _dbConnHolder.Open(); var entList = new Collection <PhoneType>(); var reader = new SafeDataReader(command.ExecuteReader(CommandBehavior.CloseConnection)); while (reader.Read()) { var tempEntity = new PhoneType(reader.GetInt32("Id"), reader.GetString("Name")); entList.Add(tempEntity); } reader.Close(); return(entList); }
public ICollection <ReportingParty> Search(string searchValue) { var command = _dbReportingPartyCommandProvider.GetSearchDbCommand(searchValue); command.Connection = _dbConnHolder.Connection; _dbConnHolder.Open(); var entList = new Collection <ReportingParty>(); var reader = new SafeDataReader(command.ExecuteReader(CommandBehavior.CloseConnection)); while (reader.Read()) { var tempEntity = new ReportingParty(reader.GetInt32("Id"), reader.GetString("Name"), reader.GetString("Email"), reader.GetString("Phone"), reader.GetNullableInt32("PhoneTypeId")); entList.Add(tempEntity); } reader.Close(); return(entList); }
public ICollection <ComplaintDetail> GetData() { var command = _dbComplaintDetailCommandProvider.GetGetDataDbCommand(); command.Connection = _dbConnHolder.Connection; _dbConnHolder.Open(); var entList = new Collection <ComplaintDetail>(); var reader = new SafeDataReader(command.ExecuteReader(CommandBehavior.CloseConnection)); while (reader.Read()) { var tempEntity = new ComplaintDetail(reader.GetInt32("Id"), reader.GetString("Name"), reader.GetString("Description"), reader.GetString("LocationDetails"), reader.GetString("ReportingParty")); entList.Add(tempEntity); } reader.Close(); return(entList); }
public PagedResult <PhoneType> GetDataPageable(string sortExpression, int page, int pageSize) { var command = _dbPhoneTypeCommandProvider.GetGetDataPageableDbCommand(sortExpression, page, pageSize); command.Connection = _dbConnHolder.Connection; _dbConnHolder.Open(); var entList = new Collection <PhoneType>(); var reader = new SafeDataReader(command.ExecuteReader(CommandBehavior.CloseConnection)); while (reader.Read()) { var tempEntity = new PhoneType(reader.GetInt32("Id"), reader.GetString("Name")); entList.Add(tempEntity); } reader.Close(); var totalCount = GetRowCount(); var pagedResults = new PagedResult <PhoneType>(page, pageSize, totalCount, entList); return(pagedResults); }
public PagedResult <Complaint> GetDataPageable(string sortExpression, int page, int pageSize) { var command = _dbComplaintCommandProvider.GetGetDataPageableDbCommand(sortExpression, page, pageSize); command.Connection = _dbConnHolder.Connection; _dbConnHolder.Open(); var entList = new Collection <Complaint>(); var reader = new SafeDataReader(command.ExecuteReader(CommandBehavior.CloseConnection)); while (reader.Read()) { var tempEntity = new Complaint(reader.GetInt32("Id"), reader.GetInt32("ComplaintTypeId"), reader.GetString("Description"), reader.GetString("LocationDetails"), reader.GetInt32("ReportingPartyId")); entList.Add(tempEntity); } reader.Close(); var totalCount = GetRowCount(); var pagedResults = new PagedResult <Complaint>(page, pageSize, totalCount, entList); return(pagedResults); }
public PagedResult <ReportingParty> GetDataByPhoneTypeIdPageable(int phoneTypeId, string sortExpression, int page, int pageSize) { var command = _dbReportingPartyCommandProvider.GetGetDataByPhoneTypeIdPageableDbCommand(phoneTypeId, sortExpression, page, pageSize); command.Connection = _dbConnHolder.Connection; _dbConnHolder.Open(); var entList = new Collection <ReportingParty>(); var reader = new SafeDataReader(command.ExecuteReader(CommandBehavior.CloseConnection)); while (reader.Read()) { var tempEntity = new ReportingParty(reader.GetInt32("Id"), reader.GetString("Name"), reader.GetString("Email"), reader.GetString("phone"), reader.GetNullableInt32("phoneTypeId")); entList.Add(tempEntity); } reader.Close(); var totalCount = GetDataByPhoneTypeIdRowCount(phoneTypeId); var pagedResults = new PagedResult <ReportingParty>(page, pageSize, totalCount, entList); return(pagedResults); }