public List<EmployeeDocument> GetAll()
{
EmployeeDocumentDAC _employeeDocumentComponent = new EmployeeDocumentDAC();
IDataReader reader = _employeeDocumentComponent.GetAllEmployeeDocument().CreateDataReader();
List<EmployeeDocument> _employeeDocumentList = new List<EmployeeDocument>();
while(reader.Read())
{
if(_employeeDocumentList == null)
_employeeDocumentList = new List<EmployeeDocument>();
EmployeeDocument _employeeDocument = new EmployeeDocument();
if(reader["EmployeeDocumentID"] != DBNull.Value)
_employeeDocument.EmployeeDocumentID = Convert.ToInt32(reader["EmployeeDocumentID"]);
if(reader["EmployeeDocumentTypeID"] != DBNull.Value)
_employeeDocument.EmployeeDocumentTypeID = Convert.ToInt32(reader["EmployeeDocumentTypeID"]);
if(reader["EmployeeID"] != DBNull.Value)
_employeeDocument.EmployeeID = Convert.ToInt32(reader["EmployeeID"]);
if(reader["Name"] != DBNull.Value)
_employeeDocument.Name = Convert.ToString(reader["Name"]);
if(reader["Path"] != DBNull.Value)
_employeeDocument.Path = Convert.ToString(reader["Path"]);
_employeeDocument.NewRecord = false;
_employeeDocumentList.Add(_employeeDocument);
} reader.Close();
return _employeeDocumentList;
}
public bool Insert(EmployeeDocument employeedocument)
{
int autonumber = 0;
EmployeeDocumentDAC employeedocumentComponent = new EmployeeDocumentDAC();
bool endedSuccessfuly = employeedocumentComponent.InsertNewEmployeeDocument( ref autonumber, employeedocument.EmployeeDocumentTypeID, employeedocument.EmployeeID, employeedocument.Name, employeedocument.Path);
if(endedSuccessfuly)
{
employeedocument.EmployeeDocumentID = autonumber;
}
return endedSuccessfuly;
}
public EmployeeDocument GetByID(int _employeeDocumentID)
{
EmployeeDocumentDAC _employeeDocumentComponent = new EmployeeDocumentDAC();
IDataReader reader = _employeeDocumentComponent.GetByIDEmployeeDocument(_employeeDocumentID);
EmployeeDocument _employeeDocument = null;
while(reader.Read())
{
_employeeDocument = new EmployeeDocument();
if(reader["EmployeeDocumentID"] != DBNull.Value)
_employeeDocument.EmployeeDocumentID = Convert.ToInt32(reader["EmployeeDocumentID"]);
if(reader["EmployeeDocumentTypeID"] != DBNull.Value)
_employeeDocument.EmployeeDocumentTypeID = Convert.ToInt32(reader["EmployeeDocumentTypeID"]);
if(reader["EmployeeID"] != DBNull.Value)
_employeeDocument.EmployeeID = Convert.ToInt32(reader["EmployeeID"]);
if(reader["Name"] != DBNull.Value)
_employeeDocument.Name = Convert.ToString(reader["Name"]);
if(reader["Path"] != DBNull.Value)
_employeeDocument.Path = Convert.ToString(reader["Path"]);
_employeeDocument.NewRecord = false; } reader.Close();
return _employeeDocument;
}
public bool Update(EmployeeDocument employeedocument ,int old_employeeDocumentID)
{
EmployeeDocumentDAC employeedocumentComponent = new EmployeeDocumentDAC();
return employeedocumentComponent.UpdateEmployeeDocument( employeedocument.EmployeeDocumentTypeID, employeedocument.EmployeeID, employeedocument.Name, employeedocument.Path, old_employeeDocumentID);
}