public bool Insert(EmployeeDocumentType employeedocumenttype) { int autonumber = 0; EmployeeDocumentTypeDAC employeedocumenttypeComponent = new EmployeeDocumentTypeDAC(); bool endedSuccessfuly = employeedocumenttypeComponent.InsertNewEmployeeDocumentType( ref autonumber, employeedocumenttype.Name); if(endedSuccessfuly) { employeedocumenttype.EmployeeDocumentTypeID = autonumber; } return endedSuccessfuly; }
public EmployeeDocumentType GetByID(int _employeeDocumentTypeID) { EmployeeDocumentTypeDAC _employeeDocumentTypeComponent = new EmployeeDocumentTypeDAC(); IDataReader reader = _employeeDocumentTypeComponent.GetByIDEmployeeDocumentType(_employeeDocumentTypeID); EmployeeDocumentType _employeeDocumentType = null; while(reader.Read()) { _employeeDocumentType = new EmployeeDocumentType(); if(reader["EmployeeDocumentTypeID"] != DBNull.Value) _employeeDocumentType.EmployeeDocumentTypeID = Convert.ToInt32(reader["EmployeeDocumentTypeID"]); if(reader["Name"] != DBNull.Value) _employeeDocumentType.Name = Convert.ToString(reader["Name"]); _employeeDocumentType.NewRecord = false; } reader.Close(); return _employeeDocumentType; }
public List<EmployeeDocumentType> GetAll() { EmployeeDocumentTypeDAC _employeeDocumentTypeComponent = new EmployeeDocumentTypeDAC(); IDataReader reader = _employeeDocumentTypeComponent.GetAllEmployeeDocumentType().CreateDataReader(); List<EmployeeDocumentType> _employeeDocumentTypeList = new List<EmployeeDocumentType>(); while(reader.Read()) { if(_employeeDocumentTypeList == null) _employeeDocumentTypeList = new List<EmployeeDocumentType>(); EmployeeDocumentType _employeeDocumentType = new EmployeeDocumentType(); if(reader["EmployeeDocumentTypeID"] != DBNull.Value) _employeeDocumentType.EmployeeDocumentTypeID = Convert.ToInt32(reader["EmployeeDocumentTypeID"]); if(reader["Name"] != DBNull.Value) _employeeDocumentType.Name = Convert.ToString(reader["Name"]); _employeeDocumentType.NewRecord = false; _employeeDocumentTypeList.Add(_employeeDocumentType); } reader.Close(); return _employeeDocumentTypeList; }
public bool Update(EmployeeDocumentType employeedocumenttype ,int old_employeeDocumentTypeID) { EmployeeDocumentTypeDAC employeedocumenttypeComponent = new EmployeeDocumentTypeDAC(); return employeedocumenttypeComponent.UpdateEmployeeDocumentType( employeedocumenttype.Name, old_employeeDocumentTypeID); }