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); }
public bool Insert( string Name) { EmployeeDocumentTypeDAC employeedocumenttypeComponent = new EmployeeDocumentTypeDAC(); int EmployeeDocumentTypeID = 0; return employeedocumenttypeComponent.InsertNewEmployeeDocumentType( ref EmployeeDocumentTypeID, Name); }
public void Delete(int Original_EmployeeDocumentTypeID) { EmployeeDocumentTypeDAC employeedocumenttypeComponent = new EmployeeDocumentTypeDAC(); employeedocumenttypeComponent.DeleteEmployeeDocumentType(Original_EmployeeDocumentTypeID); }
public int UpdateDataset(System.Data.DataSet dataset) { EmployeeDocumentTypeDAC employeedocumenttypecomponent = new EmployeeDocumentTypeDAC(); return employeedocumenttypecomponent.UpdateDataset(dataset); }
public bool Update( string Name, int Original_EmployeeDocumentTypeID) { EmployeeDocumentTypeDAC employeedocumenttypeComponent = new EmployeeDocumentTypeDAC(); return employeedocumenttypeComponent.UpdateEmployeeDocumentType( Name, Original_EmployeeDocumentTypeID); }