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;
}
}