public void UpdateOpportunityType(OpportunityType opportunityType) { try { parameters.Add("@OpportunityName", opportunityType.OpportunityName); parameters.Add("@DateRegister", opportunityType.DateRegister.ToString()); parameters.Add("@OpportunityTypeStatus", opportunityType.OpportunityTypeStatus.ToString()); parameters.Add("@OpportunityTypeId", opportunityType.OpportunityTypeId.ToString()); _repositoryConncetion.SimpleExecuteCommand("UpdateOpportunityType", parameters); } catch (Exception ex) { throw ex; } }
public void UpdateCareer(Career career) { try { parameters.Add("@CareerName", career.CareerName); parameters.Add("@DateRegister", career.DateRegister.ToString()); parameters.Add("@CareerStatus", career.CareerStatus.ToString()); parameters.Add("@CareerId", career.CareerId.ToString()); _repositoryConnection.SimpleExecuteCommand("UpdateCareer", parameters); } catch (Exception ex) { throw ex; } }
public void UpdateService(Service service) { try { parameters.Add("@ServiceName", service.ServiceName); parameters.Add("@DateRegister", service.DateRegister.ToString()); parameters.Add("@ServiceStatus", service.ServiceStatus.ToString()); parameters.Add("@ServiceId", service.ServiceId.ToString()); _repositoryConnection.SimpleExecuteCommand("UpdateService", parameters); } catch (Exception ex) { throw ex; } }
public void UpdateProfessionalLevel(ProfessionalLevel professionalLevel) { try { parameters.Add("@ProfessionalLevelName", professionalLevel.ProfessionalLevelName); parameters.Add("@ProfessionalLevelSection", professionalLevel.ProfessionalLevelSection.ToString()); parameters.Add("@DateRegister", professionalLevel.DateRegister.ToString()); parameters.Add("@ProfessionalLevelStatus", professionalLevel.ProfessionalLevelStatus.ToString()); parameters.Add("@ProfessionalLevelId", professionalLevel.ProfessionalLevelId.ToString()); _repositoryConnection.SimpleExecuteCommand("UpdateProfessionalLevel", parameters); } catch (Exception ex) { throw ex; } }
public void InsertVacationOpportunity(VacationOpportunity vacationOpportunity) { try { parameters.Add("@VacationOpeningNumber", vacationOpportunity.VacationOpeningNumber); parameters.Add("@VacationOpeningDate", vacationOpportunity.VacationOpeningDate.ToString()); parameters.Add("@VacationOfferLetterDate", vacationOpportunity.VacationOfferLetterDate.ToString()); parameters.Add("@VacationLeader", vacationOpportunity.VacationLeader); parameters.Add("@VacationCancellationDate", vacationOpportunity.VacationCancellationDate.ToString()); parameters.Add("@VacationOpportunityStatus", vacationOpportunity.VacationOpportunityStatus.ToString()); parameters.Add("@OpportunityTypeId", vacationOpportunity.OpportunityType.OpportunityTypeId.ToString()); parameters.Add("@CareerId", vacationOpportunity.Career.CareerId.ToString()); parameters.Add("@ProfessionalLevelId", vacationOpportunity.ProfessionalLevel.ProfessionalLevelId.ToString()); _repositoryConnection.SimpleExecuteCommand("InsertVacationOpportunity", parameters); } catch (Exception ex) { throw ex; } }
public void InsertOpportunity(Opportunity opportunity) { try { parameters.Add("@OpportunityName", opportunity.OpportunityName); parameters.Add("@OpportunityRequirements", opportunity.OpportunityRequirements); parameters.Add("@DesirableRequirements", opportunity.DesirableRequirements); parameters.Add("@DateRegister", opportunity.DateRegister.ToString()); parameters.Add("@ClosingDate", opportunity.ClosingDate.ToString()); parameters.Add("@CancellationDate", opportunity.CancellationDate.ToString()); parameters.Add("@OpportunityStatus", opportunity.OpportunityStatus.ToString()); parameters.Add("@CareerId", opportunity.Career.CareerId.ToString()); parameters.Add("@ProfessionalLevelId", opportunity.ProfessionalLevel.ProfessionalLevelId.ToString()); parameters.Add("@ServiceId", opportunity.Service.ServiceId.ToString()); parameters.Add("@OpportunityTypeId", opportunity.OpportunityType.OpportunityTypeId.ToString()); _repositoryConnection.SimpleExecuteCommand("InsertOpportunity", parameters); } catch (Exception ex) { throw ex; } }