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 void Delete(int Original_EmployeeContractID) { EmployeeContractDAC employeecontractComponent = new EmployeeContractDAC(); employeecontractComponent.DeleteEmployeeContract(Original_EmployeeContractID); }
public int UpdateDataset(System.Data.DataSet dataset) { EmployeeContractDAC employeecontractcomponent = new EmployeeContractDAC(); return employeecontractcomponent.UpdateDataset(dataset); }
public bool Update( int EmployeeID, int ContractID, int ContractStatusTypeID, decimal NetSalary, decimal GrossSalary, DateTime OfferDate, DateTime AcceptanceDate, bool IsAccepted, DateTime StartDate, DateTime EndDate, int Original_EmployeeContractID) { EmployeeContractDAC employeecontractComponent = new EmployeeContractDAC(); return employeecontractComponent.UpdateEmployeeContract( EmployeeID, ContractID, ContractStatusTypeID, NetSalary, GrossSalary, OfferDate, AcceptanceDate, IsAccepted, StartDate, EndDate, Original_EmployeeContractID); }
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( int EmployeeID, int ContractID, int ContractStatusTypeID, decimal NetSalary, decimal GrossSalary, DateTime OfferDate, DateTime AcceptanceDate, bool IsAccepted, DateTime StartDate, DateTime EndDate) { EmployeeContractDAC employeecontractComponent = new EmployeeContractDAC(); int EmployeeContractID = 0; return employeecontractComponent.InsertNewEmployeeContract( ref EmployeeContractID, EmployeeID, ContractID, ContractStatusTypeID, NetSalary, GrossSalary, OfferDate, AcceptanceDate, IsAccepted, StartDate, EndDate); }
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; }