public void AddJob(JobDTO job)
        {
            this.context.jobs.Add(Mapper.Map<job>(job));

            this.context.SaveChanges();
        }
        public void UpdateJob(JobDTO jobDto)
        {
            var job = Mapper.Map<job>(jobDto);

            this.context.jobs.Attach(job);
            this.context.Entry(job).State = System.Data.EntityState.Modified;
            this.context.ChangeTracker.DetectChanges();
            this.context.SaveChanges();
        }
        public void DeleteJob(JobDTO jobDto)
        {
            this.context.jobs.Remove(this.context.jobs.First(x => x.job_id == jobDto.ID));

            this.context.SaveChanges();
        }