public ActionResult DataSource(DataSource DataSource)
{
SqlConfidenceContext context = new SqlConfidenceContext();
if (!String.IsNullOrEmpty(DataSource.Name))
{
try
{
var original = context.DataSources.Find(DataSource.DataSourceId);
context.Entry(original).CurrentValues.SetValues(DataSource);
original.UpdatedBy = GetCurrentUser().Email;
original.UpdatedDate = DateTime.Now;
context.SaveChanges();
ViewBag.SuccessMessage = "Saved Successfully";
}
catch (Exception ex)
{
Trace.WriteLine("Error saving exercise - " + ex.Message);
ViewBag.ErrorMessage = "Error saving exercise, please check the logs";
}
}
DataSource = context.DataSources.Single(x => x.DataSourceId == DataSource.DataSourceId);
ISourceDataAccess dataAccess = SourceDataAccessFactory.CreateDataAccess(Common.Enums.SourceDatabaseType.TSQL);
ViewBag.Tables = dataAccess.ListAllTables();
return(View(DataSource));
}
public void Save(DataSourceTable DataSourceTable)
{
// Does it already exist?
var exists = DataSourceTable.DataSourceTableId != 0;
var context = new SqlConfidenceContext();
// Stop it saving any related objects
DataSourceTable.DataSource = null;
if (!exists)
{
context.DataSourceTables.Add(DataSourceTable);
}
else
{
context.DataSourceTables.Attach(DataSourceTable);
context.Entry(DataSourceTable).State = EntityState.Modified;
}
context.SaveChanges();
}
public void Save(Exercise Exercise)
{
// Does it already exist?
var exists = Exercise.ExerciseId != 0;
// Stop it saving any related objects
Exercise.ExerciseQuestions = null;
Exercise.DataSource = null;
if (!exists)
{
_context.Exercises.Add(Exercise);
}
else
{
_context.Exercises.Attach(Exercise);
_context.Entry(Exercise).State = EntityState.Modified;
}
_context.SaveChanges();
}
public void Save(ExerciseQuestionAnswered QuestionAnswered)
{
// Does it already exist?
var exists = QuestionAnswered.ExerciseQuestionAnsweredId != 0;
var context = new SqlConfidenceContext();
// Stop it saving any related objects
QuestionAnswered.ExerciseQuestion = null;
if (!exists)
{
context.ExerciseQuestionAnswereds.Add(QuestionAnswered);
}
else
{
context.ExerciseQuestionAnswereds.Attach(QuestionAnswered);
context.Entry(QuestionAnswered).State = EntityState.Modified;
}
context.SaveChanges();
}
public void Save(ExerciseQuestionChoice Choice)
{
// Does it already exist?
var exists = Choice.ExerciseQuestionChoiceId != Guid.Empty;
var context = new SqlConfidenceContext();
// Stop it saving any related objects
Choice.ExerciseQuestion = null;
if (!exists)
{
Choice.ExerciseQuestionChoiceId = Guid.NewGuid();
context.ExerciseQuestionChoices.Add(Choice);
}
else
{
context.ExerciseQuestionChoices.Attach(Choice);
context.Entry(Choice).State = EntityState.Modified;
}
context.SaveChanges();
}