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 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 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 DeleteGraduate(string id)
{
using (placementDepartmentDBEntities placementDepartmentDB = new placementDepartmentDBEntities())
{
try
{
Graduate graduate = placementDepartmentDB.Graduate.Find(id);
placementDepartmentDB.Graduate.Remove(graduate);
placementDepartmentDB.SaveChanges();
}
catch (DbUpdateException ex)
{
var sqlException = ex.GetBaseException() as SqlException;
if (sqlException != null)
{
if (sqlException.Number == 547)
{
throw new DbUpdateException("547");
}
}
}
}
}
