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);
}
