public EmployeeContract GetByID(int _employeeContractID) { EmployeeContractDAC _employeeContractComponent = new EmployeeContractDAC(); IDataReader reader = _employeeContractComponent.GetByIDEmployeeContract(_employeeContractID); EmployeeContract _employeeContract = null; while(reader.Read()) { _employeeContract = new EmployeeContract(); if(reader["EmployeeContractID"] != DBNull.Value) _employeeContract.EmployeeContractID = Convert.ToInt32(reader["EmployeeContractID"]); if(reader["EmployeeID"] != DBNull.Value) _employeeContract.EmployeeID = Convert.ToInt32(reader["EmployeeID"]); if(reader["ContractID"] != DBNull.Value) _employeeContract.ContractID = Convert.ToInt32(reader["ContractID"]); if(reader["ContractStatusTypeID"] != DBNull.Value) _employeeContract.ContractStatusTypeID = Convert.ToInt32(reader["ContractStatusTypeID"]); if(reader["NetSalary"] != DBNull.Value) _employeeContract.NetSalary = Convert.ToDecimal(reader["NetSalary"]); if(reader["GrossSalary"] != DBNull.Value) _employeeContract.GrossSalary = Convert.ToDecimal(reader["GrossSalary"]); if(reader["OfferDate"] != DBNull.Value) _employeeContract.OfferDate = Convert.ToDateTime(reader["OfferDate"]); if(reader["AcceptanceDate"] != DBNull.Value) _employeeContract.AcceptanceDate = Convert.ToDateTime(reader["AcceptanceDate"]); if(reader["IsAccepted"] != DBNull.Value) _employeeContract.IsAccepted = Convert.ToBoolean(reader["IsAccepted"]); if(reader["StartDate"] != DBNull.Value) _employeeContract.StartDate = Convert.ToDateTime(reader["StartDate"]); if(reader["EndDate"] != DBNull.Value) _employeeContract.EndDate = Convert.ToDateTime(reader["EndDate"]); _employeeContract.NewRecord = false; } reader.Close(); return _employeeContract; }
public List<EmployeeContract> GetAll() { EmployeeContractDAC _employeeContractComponent = new EmployeeContractDAC(); IDataReader reader = _employeeContractComponent.GetAllEmployeeContract().CreateDataReader(); List<EmployeeContract> _employeeContractList = new List<EmployeeContract>(); while(reader.Read()) { if(_employeeContractList == null) _employeeContractList = new List<EmployeeContract>(); EmployeeContract _employeeContract = new EmployeeContract(); if(reader["EmployeeContractID"] != DBNull.Value) _employeeContract.EmployeeContractID = Convert.ToInt32(reader["EmployeeContractID"]); if(reader["EmployeeID"] != DBNull.Value) _employeeContract.EmployeeID = Convert.ToInt32(reader["EmployeeID"]); if(reader["ContractID"] != DBNull.Value) _employeeContract.ContractID = Convert.ToInt32(reader["ContractID"]); if(reader["ContractStatusTypeID"] != DBNull.Value) _employeeContract.ContractStatusTypeID = Convert.ToInt32(reader["ContractStatusTypeID"]); if(reader["NetSalary"] != DBNull.Value) _employeeContract.NetSalary = Convert.ToDecimal(reader["NetSalary"]); if(reader["GrossSalary"] != DBNull.Value) _employeeContract.GrossSalary = Convert.ToDecimal(reader["GrossSalary"]); if(reader["OfferDate"] != DBNull.Value) _employeeContract.OfferDate = Convert.ToDateTime(reader["OfferDate"]); if(reader["AcceptanceDate"] != DBNull.Value) _employeeContract.AcceptanceDate = Convert.ToDateTime(reader["AcceptanceDate"]); if(reader["IsAccepted"] != DBNull.Value) _employeeContract.IsAccepted = Convert.ToBoolean(reader["IsAccepted"]); if(reader["StartDate"] != DBNull.Value) _employeeContract.StartDate = Convert.ToDateTime(reader["StartDate"]); if(reader["EndDate"] != DBNull.Value) _employeeContract.EndDate = Convert.ToDateTime(reader["EndDate"]); _employeeContract.NewRecord = false; _employeeContractList.Add(_employeeContract); } reader.Close(); return _employeeContractList; }
public bool Update(EmployeeContract employeecontract ,int old_employeeContractID) { EmployeeContractDAC employeecontractComponent = new EmployeeContractDAC(); return employeecontractComponent.UpdateEmployeeContract( employeecontract.EmployeeID, employeecontract.ContractID, employeecontract.ContractStatusTypeID, employeecontract.NetSalary, employeecontract.GrossSalary, employeecontract.OfferDate, employeecontract.AcceptanceDate, employeecontract.IsAccepted, employeecontract.StartDate, employeecontract.EndDate, old_employeeContractID); }
public bool Insert(EmployeeContract employeecontract) { int autonumber = 0; EmployeeContractDAC employeecontractComponent = new EmployeeContractDAC(); bool endedSuccessfuly = employeecontractComponent.InsertNewEmployeeContract( ref autonumber, employeecontract.EmployeeID, employeecontract.ContractID, employeecontract.ContractStatusTypeID, employeecontract.NetSalary, employeecontract.GrossSalary, employeecontract.OfferDate, employeecontract.AcceptanceDate, employeecontract.IsAccepted, employeecontract.StartDate, employeecontract.EndDate); if(endedSuccessfuly) { employeecontract.EmployeeContractID = autonumber; } return endedSuccessfuly; }