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