public EligibleFiles GetByID(int _eligibleFileId)
{
EligibleFilesDAC _eligibleFilesComponent = new EligibleFilesDAC();
IDataReader reader = _eligibleFilesComponent.GetByIDEligibleFiles(_eligibleFileId);
EligibleFiles _eligibleFiles = null;
while (reader.Read())
{
_eligibleFiles = new EligibleFiles();
if (reader["EligibleFileId"] != DBNull.Value)
{
_eligibleFiles.EligibleFileId = Convert.ToInt32(reader["EligibleFileId"]);
}
if (reader["EligibleId"] != DBNull.Value)
{
_eligibleFiles.EligibleId = Convert.ToInt32(reader["EligibleId"]);
}
if (reader["FileName"] != DBNull.Value)
{
_eligibleFiles.FileName = Convert.ToString(reader["FileName"]);
}
if (reader["FileDescription"] != DBNull.Value)
{
_eligibleFiles.FileDescription = Convert.ToString(reader["FileDescription"]);
}
if (reader["FilePath"] != DBNull.Value)
{
_eligibleFiles.FilePath = Convert.ToString(reader["FilePath"]);
}
_eligibleFiles.NewRecord = false;
}
reader.Close();
return(_eligibleFiles);
}
public bool Insert(EligibleFiles eligiblefiles)
{
int autonumber = 0;
EligibleFilesDAC eligiblefilesComponent = new EligibleFilesDAC();
bool endedSuccessfuly = eligiblefilesComponent.InsertNewEligibleFiles(ref autonumber, eligiblefiles.EligibleId, eligiblefiles.FileName, eligiblefiles.FileDescription, eligiblefiles.FilePath);
if (endedSuccessfuly)
{
eligiblefiles.EligibleFileId = autonumber;
}
return(endedSuccessfuly);
}
public List <EligibleFiles> GetAllByPatientId(int EligibleId)
{
EligibleFilesDAC _eligibleFilesComponent = new EligibleFilesDAC();
IDataReader reader = _eligibleFilesComponent.GetAllEligibleFiles("EligibleId = " + EligibleId).CreateDataReader();
List <EligibleFiles> _eligibleFilesList = new List <EligibleFiles>();
while (reader.Read())
{
if (_eligibleFilesList == null)
{
_eligibleFilesList = new List <EligibleFiles>();
}
EligibleFiles _eligibleFiles = new EligibleFiles();
if (reader["EligibleFileId"] != DBNull.Value)
{
_eligibleFiles.EligibleFileId = Convert.ToInt32(reader["EligibleFileId"]);
}
if (reader["EligibleId"] != DBNull.Value)
{
_eligibleFiles.EligibleId = Convert.ToInt32(reader["EligibleId"]);
}
if (reader["FileName"] != DBNull.Value)
{
_eligibleFiles.FileName = Convert.ToString(reader["FileName"]);
}
if (reader["FileDescription"] != DBNull.Value)
{
_eligibleFiles.FileDescription = Convert.ToString(reader["FileDescription"]);
}
if (reader["FilePath"] != DBNull.Value)
{
_eligibleFiles.FilePath = Convert.ToString(reader["FilePath"]);
}
_eligibleFiles.NewRecord = false;
_eligibleFilesList.Add(_eligibleFiles);
}
reader.Close();
return(_eligibleFilesList);
}
public bool Update(EligibleFiles eligiblefiles, int old_eligibleFileId)
{
EligibleFilesDAC eligiblefilesComponent = new EligibleFilesDAC();
return(eligiblefilesComponent.UpdateEligibleFiles(eligiblefiles.EligibleId, eligiblefiles.FileName, eligiblefiles.FileDescription, eligiblefiles.FilePath, old_eligibleFileId));
}
