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