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 void Put([FromBody] FullGraduateDto graduateDto)
{
GraduateDtoManager.GraduateDtoEditing(graduateDto);
}
public FullGraduateDto Post([FromBody] FullGraduateDto graduateDto)
{
var userId = Int32.Parse(HttpContext.Current.User.Identity.Name);
return(GraduateDtoManager.NewGraduateDto(graduateDto, userId));
}
public ImportRes execut(Dictionary <string, string> keyValues,//Dictionary<key -name of field, value - char of column>
Stream fileStream,
int rowStart,
int rowEnd /*include*/)
{
WorkBook workbook = WorkBook.Load(fileStream);
WorkSheet sheet = workbook.WorkSheets[0];
List <int> errLine = new List <int>();
FullGraduateDto graduateDto;
List <FullGraduateDto> fullGraduateDtos = new List <FullGraduateDto>();
for (int i = rowStart; i <= rowEnd; i++)
{
graduateDto = new FullGraduateDto();
try
{
foreach (var item in keyValues)
{
switch (item.Key)
{
case "City":
graduateDto.City = new CityDto();
graduateDto.City.Id = findCItyIdByName(sheet[item.Value + i].Value.ToString());
break;
case "Branch":
graduateDto.Branch = new BranchDto();
graduateDto.Branch.Id = int.Parse(item.Value);
break;
case "Expertise":
graduateDto.Expertise = new ExpertiseDto();
graduateDto.Expertise.Id = int.Parse(item.Value);
break;
case "gender":
graduateDto.gender = item.Value;
break;
case "didGraduate":
graduateDto.didGraduate = bool.Parse(item.Value);
break;
case "hasDiploma":
case "isWorkerInProfession":
case "placedByThePlacementDepartment":
case "hasExperience":
graduateDto.GetType().GetProperty(item.Key).SetValue(
graduateDto,
convertHEBoolToBool(sheet[item.Value + i].Value.ToString())
);
break;
case "phone":
graduateDto.phone = sheet[item.Value + i].Value.ToString().Replace("-", "");
break;
default:
graduateDto.GetType().GetProperty(item.Key).SetValue(
graduateDto, Convert.ChangeType(
sheet[item.Value + i].Value,
graduateDto.GetType().GetProperty(item.Key).PropertyType
)
);
break;
}
}
graduateDto.isActive = false;
GraduateManager.NewGraduate(graduateDto);
fullGraduateDtos.Add(graduateDto);
}
catch (Exception)
{
errLine.Add(i);
}
}
return(new ImportRes()
{
errLine = errLine,
readLine = fullGraduateDtos
});
}
public static void GraduateDtoEditing(FullGraduateDto graduateDto)
{
GraduateManager.GraduateEditing(graduateDto);
}
public static FullGraduateDto NewGraduateDto(FullGraduateDto graduateDto, int userId)
{
return(GraduateManager.NewGraduate(graduateDto));
}
