public EligibleRequestStatusHistory GetByID(int _eligibilityRequestStatusId)
{
EligibleRequestStatusHistoryDAC _eligibleRequestStatusHistoryComponent = new EligibleRequestStatusHistoryDAC();
IDataReader reader = _eligibleRequestStatusHistoryComponent.GetByIDEligibleRequestStatusHistory(_eligibilityRequestStatusId);
EligibleRequestStatusHistory _eligibleRequestStatusHistory = null;
while (reader.Read())
{
_eligibleRequestStatusHistory = new EligibleRequestStatusHistory();
if (reader["EligibilityRequestStatusId"] != DBNull.Value)
{
_eligibleRequestStatusHistory.EligibilityRequestStatusId = Convert.ToInt32(reader["EligibilityRequestStatusId"]);
}
if (reader["EligibilityStatusId"] != DBNull.Value)
{
_eligibleRequestStatusHistory.EligibilityStatusId = Convert.ToInt32(reader["EligibilityStatusId"]);
}
if (reader["EligibileId"] != DBNull.Value)
{
_eligibleRequestStatusHistory.EligibileId = Convert.ToInt32(reader["EligibileId"]);
}
if (reader["CreationDate"] != DBNull.Value)
{
_eligibleRequestStatusHistory.CreationDate = Convert.ToDateTime(reader["CreationDate"]);
}
if (reader["Notes"] != DBNull.Value)
{
_eligibleRequestStatusHistory.Notes = Convert.ToString(reader["Notes"]);
}
_eligibleRequestStatusHistory.NewRecord = false;
}
reader.Close();
return(_eligibleRequestStatusHistory);
}
public bool Insert(EligibleRequestStatusHistory eligiblerequeststatushistory)
{
int autonumber = 0;
EligibleRequestStatusHistoryDAC eligiblerequeststatushistoryComponent = new EligibleRequestStatusHistoryDAC();
bool endedSuccessfuly = eligiblerequeststatushistoryComponent.InsertNewEligibleRequestStatusHistory(ref autonumber, eligiblerequeststatushistory.EligibilityStatusId, eligiblerequeststatushistory.EligibileId, eligiblerequeststatushistory.CreationDate, eligiblerequeststatushistory.Notes);
if (endedSuccessfuly)
{
eligiblerequeststatushistory.EligibilityRequestStatusId = autonumber;
}
return(endedSuccessfuly);
}
public List <EligibleRequestStatusHistory> GetAll()
{
EligibleRequestStatusHistoryDAC _eligibleRequestStatusHistoryComponent = new EligibleRequestStatusHistoryDAC();
IDataReader reader = _eligibleRequestStatusHistoryComponent.GetAllEligibleRequestStatusHistory().CreateDataReader();
List <EligibleRequestStatusHistory> _eligibleRequestStatusHistoryList = new List <EligibleRequestStatusHistory>();
while (reader.Read())
{
if (_eligibleRequestStatusHistoryList == null)
{
_eligibleRequestStatusHistoryList = new List <EligibleRequestStatusHistory>();
}
EligibleRequestStatusHistory _eligibleRequestStatusHistory = new EligibleRequestStatusHistory();
if (reader["EligibilityRequestStatusId"] != DBNull.Value)
{
_eligibleRequestStatusHistory.EligibilityRequestStatusId = Convert.ToInt32(reader["EligibilityRequestStatusId"]);
}
if (reader["EligibilityStatusId"] != DBNull.Value)
{
_eligibleRequestStatusHistory.EligibilityStatusId = Convert.ToInt32(reader["EligibilityStatusId"]);
}
if (reader["EligibileId"] != DBNull.Value)
{
_eligibleRequestStatusHistory.EligibileId = Convert.ToInt32(reader["EligibileId"]);
}
if (reader["CreationDate"] != DBNull.Value)
{
_eligibleRequestStatusHistory.CreationDate = Convert.ToDateTime(reader["CreationDate"]);
}
if (reader["Notes"] != DBNull.Value)
{
_eligibleRequestStatusHistory.Notes = Convert.ToString(reader["Notes"]);
}
_eligibleRequestStatusHistory.NewRecord = false;
_eligibleRequestStatusHistoryList.Add(_eligibleRequestStatusHistory);
}
reader.Close();
return(_eligibleRequestStatusHistoryList);
}
public bool Update(EligibleRequestStatusHistory eligiblerequeststatushistory, int old_eligibilityRequestStatusId)
{
EligibleRequestStatusHistoryDAC eligiblerequeststatushistoryComponent = new EligibleRequestStatusHistoryDAC();
return(eligiblerequeststatushistoryComponent.UpdateEligibleRequestStatusHistory(eligiblerequeststatushistory.EligibilityStatusId, eligiblerequeststatushistory.EligibileId, eligiblerequeststatushistory.CreationDate, eligiblerequeststatushistory.Notes, old_eligibilityRequestStatusId));
}