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