public Survey Add(Survey survey)
{
using (var dbContextTransaction = _context.Database.BeginTransaction())
{
try
{
foreach (var answerGroup in survey.AnswerGroup)
{
_context.Address.Add(answerGroup.Address);
_context.SaveChanges();
answerGroup.AddressId = answerGroup.Address.Id;
}
_context.Survey.Add(survey);
_context.SaveChanges();
dbContextTransaction.Commit();
//todo get the id
//possibly add newAnswerGroups to the survey
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
throw;
}
return(survey);
}
}
public OptionGroup Add(OptionGroup optionGroup)
{
using (var dbContextTransaction = _context.Database.BeginTransaction())
{
try
{
_context.OptionGroup.Add(optionGroup);
_context.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
}
return(optionGroup);
}
}
public QuestionType Add(QuestionType questionType)
{
using (var dbContextTransaction = _context.Database.BeginTransaction())
{
try
{
_context.QuestionType.Add(questionType);
_context.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
}
return(questionType);
}
}
public AnswerSection Add(AnswerSection answerSection)
{
using (var dbContextTransaction = _context.Database.BeginTransaction())
{
try
{
_context.AnswerSection.Add(answerSection);
_context.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
throw;
}
return(answerSection);
}
}
public AnswerGroup Add(AnswerGroup answerGroup)
{
using (var dbContextTransaction = _context.Database.BeginTransaction())
{
try
{
var address = _context.Address.Add(answerGroup.Address);
answerGroup.AddressId = address.Entity.Id;
_context.AnswerGroup.Add(answerGroup);
_context.SaveChanges();
dbContextTransaction.Commit();
}
catch (Exception ex)
{
dbContextTransaction.Rollback();
}
return(answerGroup);
}
}
public Customer Add(Customer customer)
{
_context.Customer.Add(customer);
_context.SaveChanges();
return(customer);
}
public Comment Add(Comment comment)
{
_context.Comment.Add(comment);
_context.SaveChanges();
return(comment);
}