public static void UserEditing(UserDto userDto) { User user = AutoMapperConfiguration.mapper.Map <User>(userDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { try { placementDepartmentDB.Configuration.ValidateOnSaveEnabled = false; placementDepartmentDB.User.Attach(user); placementDepartmentDB.Entry(user).Property(x => x.name).IsModified = true; placementDepartmentDB.Entry(user).Property(x => x.email).IsModified = true; placementDepartmentDB.Entry(user).Property(x => x.permissionId).IsModified = true; placementDepartmentDB.Entry(user).Property(x => x.isActive).IsModified = true; placementDepartmentDB.SaveChanges(); } catch (DbUpdateException ex) { var sqlException = ex.GetBaseException() as SqlException; if (sqlException != null) { if (sqlException.Number == 2627) { throw new Exception("Duplicate"); } } } } }
public static FullGraduateDto NewGraduate(FullGraduateDto graduateDto) { Graduate graduate = AutoMapperConfiguration.mapper.Map <Graduate>(graduateDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { try { graduate.dateOfRegistration = graduate.lastUpdate = DateTime.Now; var res = placementDepartmentDB.Graduate.Add(graduate); placementDepartmentDB.SaveChanges(); return(AutoMapperConfiguration.mapper.Map <FullGraduateDto>(res)); } catch (DbUpdateException ex) { var sqlException = ex.GetBaseException() as SqlException; if (sqlException != null) { if (sqlException.Number == 2627) { throw new Exception("Duplicate"); } } return(null); } } }
public static void NewUser(UserDto userDto) { User user = AutoMapperConfiguration.mapper.Map <User>(userDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { try { placementDepartmentDB.Configuration.ValidateOnSaveEnabled = false; placementDepartmentDB.User.Add(user); placementDepartmentDB.SaveChanges(); } catch (DbUpdateException ex) { var sqlException = ex.GetBaseException() as SqlException; if (sqlException != null) { if (sqlException.Number == 2627) { throw new Exception("Duplicate"); } } } } }
public static void placedGraduateJob(List <int> idCRDs) { using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { foreach (var idCRD in idCRDs) { CoordinatingJobsForGraduates coordinating = placementDepartmentDB.CoordinatingJobsForGraduates.Find(idCRD); coordinating.placementStatus = 6; coordinating.JobCoordinationStatus = null; coordinating.lastUpdateDate = DateTime.Now; //Job coordinating.Job.isActive = false; coordinating.Job.reasonForClosing = 5; //work coordinating.Job.ReasonForClosingThePosition = null; coordinating.Job.lastUpdateDate = DateTime.Now; //Graduate coordinating.Graduate.isWorkerInProfession = true; coordinating.Graduate.placedByThePlacementDepartment = true; coordinating.Graduate.lastUpdate = DateTime.Now; coordinating.Graduate.companyName = coordinating.Job.Contact.Company.name; coordinating.Graduate.role = coordinating.Job.Subject.name; placementDepartmentDB.SaveChanges(); } } }
public static void JobsCoordinationUpdate(List <int> idCoordinatingJobsForGraduate, int statusId) { if (statusId == 6)//work { placedGraduateJob(idCoordinatingJobsForGraduate); } else { List <CoordinatingJobsForGraduates> coordinations = new List <CoordinatingJobsForGraduates>(); foreach (var item in idCoordinatingJobsForGraduate) { coordinations.Add(new CoordinatingJobsForGraduates() { Id = item, placementStatus = statusId, lastUpdateDate = DateTime.Now }); } using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { foreach (var coordination in coordinations) { placementDepartmentDB.Configuration.ValidateOnSaveEnabled = false; placementDepartmentDB.CoordinatingJobsForGraduates.Attach(coordination); placementDepartmentDB.Entry(coordination).Property(x => x.placementStatus).IsModified = true; placementDepartmentDB.Entry(coordination).Property(x => x.lastUpdateDate).IsModified = true; } placementDepartmentDB.SaveChanges(); } } }
public static void NewCompany(CompanyDto companyDto) { Company company = AutoMapperConfiguration.mapper.Map <Company>(companyDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { placementDepartmentDB.Company.Add(company); placementDepartmentDB.SaveChanges(); } }
public static void DeleteEwithS(int idExpertise, int idSubject) { using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { Expertise expertise = placementDepartmentDB.Expertise.Find(idExpertise); Subject subject = expertise.Subject.Single(s => s.Id == idSubject); expertise.Subject.Remove(subject); placementDepartmentDB.SaveChanges(); } }
public static void CompanyEditing(CompanyDto companyDto) { Company company = AutoMapperConfiguration.mapper.Map <Company>(companyDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { placementDepartmentDB.Company.Attach(company); placementDepartmentDB.Entry(company).State = EntityState.Modified; placementDepartmentDB.SaveChanges(); } }
public static List <CoordinatingJobsForGraduates> NewJobsCoordination(List <CoordinatingJobsForGraduates> JobsCoordination) { List <CoordinatingJobsForGraduates> res; using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { res = placementDepartmentDB.CoordinatingJobsForGraduates.AddRange(JobsCoordination).ToList(); placementDepartmentDB.SaveChanges(); return(res); } }
public static int NewExpertise(ExpertiseDto expertiseDto) { Expertise expertise = AutoMapperConfiguration.mapper.Map <Expertise>(expertiseDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { expertise = placementDepartmentDB.Expertise.Add(expertise); placementDepartmentDB.SaveChanges(); return(expertise.Id); } }
public static void editLanguage(LanguageDto LanguageDto) { Language Language = AutoMapperConfiguration.mapper.Map <Language>(LanguageDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { placementDepartmentDB.Language.Attach(Language); placementDepartmentDB.Entry(Language).State = EntityState.Modified; placementDepartmentDB.SaveChanges(); } }
public static int NewLanguage(LanguageDto LanguageDto) { Language Language = AutoMapperConfiguration.mapper.Map <Language>(LanguageDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { Language = placementDepartmentDB.Language.Add(Language); placementDepartmentDB.SaveChanges(); return(Language.Id); } }
public static void editCity(CityDto CityDto) { City City = AutoMapperConfiguration.mapper.Map <City>(CityDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { placementDepartmentDB.City.Attach(City); placementDepartmentDB.Entry(City).State = EntityState.Modified; placementDepartmentDB.SaveChanges(); } }
public static void editExpertise(ExpertiseDto expertiseDto) { Expertise expertise = AutoMapperConfiguration.mapper.Map <Expertise>(expertiseDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { placementDepartmentDB.Expertise.Attach(expertise); placementDepartmentDB.Entry(expertise).State = EntityState.Modified; placementDepartmentDB.SaveChanges(); } }
public static void NewContact(ContactDto contactDto) { Contact contact = AutoMapperConfiguration.mapper.Map <Contact>(contactDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { placementDepartmentDB.Configuration.ValidateOnSaveEnabled = false; placementDepartmentDB.Contact.Add(contact); placementDepartmentDB.SaveChanges(); } }
public static int NewCity(CityDto CityDto) { City City = AutoMapperConfiguration.mapper.Map <City>(CityDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { City = placementDepartmentDB.City.Add(City); placementDepartmentDB.SaveChanges(); return(City.Id); } }
public static int NewBranch(BranchDto branchDto) { Branch branch = AutoMapperConfiguration.mapper.Map <Branch>(branchDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { branch = placementDepartmentDB.Branch.Add(branch); placementDepartmentDB.SaveChanges(); return(branch.Id); } }
public static void editBranch(BranchDto branchDto) { Branch branch = AutoMapperConfiguration.mapper.Map <Branch>(branchDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { placementDepartmentDB.Branch.Attach(branch); placementDepartmentDB.Entry(branch).State = EntityState.Modified; placementDepartmentDB.SaveChanges(); } }
public static int NewSubject(SubjectDto SubjectDto) { Subject Subject = AutoMapperConfiguration.mapper.Map <Subject>(SubjectDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { Subject = placementDepartmentDB.Subject.Add(Subject); placementDepartmentDB.SaveChanges(); return(Subject.Id); } }
public static void editSubject(SubjectDto SubjectDto) { Subject Subject = AutoMapperConfiguration.mapper.Map <Subject>(SubjectDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { placementDepartmentDB.Subject.Attach(Subject); placementDepartmentDB.Entry(Subject).State = EntityState.Modified; placementDepartmentDB.SaveChanges(); } }
public static void JobEditing(JobDto JobDto) { Job Job = AutoMapperConfiguration.mapper.Map <Job>(JobDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { Job.lastUpdateDate = DateTime.Now; placementDepartmentDB.Job.Attach(Job); placementDepartmentDB.Entry(Job).State = EntityState.Modified; placementDepartmentDB.SaveChanges(); } }
public static void DeleteJobsCoordination(List <int> ids) { using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { foreach (var id in ids) { CoordinatingJobsForGraduates JobsCoordination = placementDepartmentDB.CoordinatingJobsForGraduates.Find(id); placementDepartmentDB.CoordinatingJobsForGraduates.Remove(JobsCoordination); } placementDepartmentDB.SaveChanges(); } }
public static void GraduateEditing(FullGraduateDto graduateDto) { ReGraduateLanguages(graduateDto.Id, graduateDto.Languages); Graduate graduate = AutoMapperConfiguration.mapper.Map <Graduate>(graduateDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { graduate.lastUpdate = DateTime.Now; placementDepartmentDB.Graduate.Attach(graduate); placementDepartmentDB.Entry(graduate).State = EntityState.Modified; placementDepartmentDB.SaveChanges(); } }
public static void ReGraduateLanguages(string graduateId, List <GraduateLanguagesDto> languages) { List <GraduateLanguages> graduateLanguages = AutoMapperConfiguration.mapper.Map <List <GraduateLanguages> >(languages); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { placementDepartmentDB.GraduateLanguages.RemoveRange( placementDepartmentDB.GraduateLanguages.Where(gl => gl.graduateId == graduateId ).ToList() ); placementDepartmentDB.GraduateLanguages.AddRange(graduateLanguages); placementDepartmentDB.SaveChanges(); } }
public static int NewJob(JobDto JobDto) { int newJobId; Job Job = AutoMapperConfiguration.mapper.Map <Job>(JobDto); using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { placementDepartmentDB.Configuration.ValidateOnSaveEnabled = false; Job.dateReceived = Job.lastUpdateDate = DateTime.Now; Job = placementDepartmentDB.Job.Add(Job); placementDepartmentDB.SaveChanges(); newJobId = Job.Id; } return(newJobId); }
public static void JobUpdate(int idJob, bool didSendCV) { Job job = new Job() { Id = idJob, didSendCV = didSendCV, lastUpdateDate = DateTime.Now }; using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { placementDepartmentDB.Configuration.ValidateOnSaveEnabled = false; placementDepartmentDB.Job.Attach(job); placementDepartmentDB.Entry(job).Property(x => x.didSendCV).IsModified = true; placementDepartmentDB.Entry(job).Property(x => x.lastUpdateDate).IsModified = true; placementDepartmentDB.SaveChanges(); } }
public static void GraduateUploudFile(string graduateId, string filePath) { Graduate graduate = new Graduate() { Id = graduateId, linkToCV = filePath, lastUpdate = DateTime.Now }; using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { placementDepartmentDB.Configuration.ValidateOnSaveEnabled = false; placementDepartmentDB.Graduate.Attach(graduate); placementDepartmentDB.Entry(graduate).Property(x => x.linkToCV).IsModified = true; placementDepartmentDB.Entry(graduate).Property(x => x.lastUpdate).IsModified = true; placementDepartmentDB.SaveChanges(); } }
public static void GraduateEditingtrue(string id, bool isint) { Graduate graduate = new Graduate() { Id = id, isActive = isint, lastUpdate = DateTime.Now }; using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { placementDepartmentDB.Configuration.ValidateOnSaveEnabled = false; placementDepartmentDB.Graduate.Attach(graduate); placementDepartmentDB.Entry(graduate).Property(x => x.isActive).IsModified = true; placementDepartmentDB.Entry(graduate).Property(x => x.lastUpdate).IsModified = true; placementDepartmentDB.SaveChanges(); } }
public static void NewEwithS(int idExpertise, SubjectDto subjectDto) { using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { Expertise expertise = placementDepartmentDB.Expertise.Find(idExpertise); Subject subject = placementDepartmentDB.Subject.Find(subjectDto.Id); if (!expertise.Subject.Contains(subject)) { expertise.Subject.Add(subject); placementDepartmentDB.SaveChanges(); } else { throw new Exception("Duplicate"); } } }
public static void ChangePassword(int id, bool isInit, string hashPassword) { User user = new User() { Id = id, isInitialPassword = isInit, password = hashPassword }; using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities()) { placementDepartmentDB.Configuration.ValidateOnSaveEnabled = false; placementDepartmentDB.User.Attach(user); placementDepartmentDB.Entry(user).Property(x => x.isInitialPassword).IsModified = true; placementDepartmentDB.Entry(user).Property(x => x.password).IsModified = true; placementDepartmentDB.SaveChanges(); } }