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