public void SavePrograms(List <ProgramTvDto> programs) { using (var context = new Model2()) { using (var tran = context.Database.BeginTransaction()) { try { foreach (ProgramTvDto programDto in programs) { Program_tv program_tv = Mapper.Map <ProgramTvDto, Program_tv>(programDto); Program_type program_Type = context .Program_type .Where(x => x.name.Equals(programDto.type_name)) .FirstOrDefault(); program_tv.Program_type = program_Type; context.Program_tv.Add(program_tv); } context.SaveChanges(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } } } }
public void SaveProgramTypes(List <ProgramTypeDto> programTypes) { using (var context = new Model2()) { using (var tran = context.Database.BeginTransaction()) { try { foreach (ProgramTypeDto programTypeDTO in programTypes) { Program_type program_Type = context .Program_type .Where(x => x.name.Equals(programTypeDTO.name)) .FirstOrDefault(); if (program_Type == null) { program_Type = Mapper.Map <ProgramTypeDto, Program_type>(programTypeDTO); context.Program_type.Add(program_Type); } } context.SaveChanges(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } } } }