public static IEnumerable<MigraineModel> GetOrderedMigrainesList(MigraineDiaryMVC_DBContext context)
{
try
{
var migraines = context.Migraines.OrderBy(m => m.DateStarted).ThenBy(m => m.TimeStarted).ToList();
return migraines;
}
catch (Exception e)
{
var connectionString = context.Database.Connection.ConnectionString;
var errorInfo = CreateInfoFromFullException(e);
var fullString = String.Format("ConnectionString: [{0}]. \r\n ErrorInfo: [{1}]", connectionString, errorInfo);
throw new Exception(fullString);
}
}
public TriggerRepository(MigraineDiaryMVC_DBContext context, bool saveOnChange = true)
: base(context, saveOnChange)
{
}
public static MigrainesModel GetMigrainesModelWithWarnings(MigraineDiaryMVC_DBContext context, params string[] warnings)
{
var model = GetBasicMigrainesModel(context);
model.Warnings.AddRange(warnings);
return model;
}
public static MigrainesModel GetMigrainesModelWithErrors(MigraineDiaryMVC_DBContext context, params string[] errors)
{
var model = GetBasicMigrainesModel(context);
model.Errors.AddRange(errors);
return model;
}
public static MigrainesModel GetBasicMigrainesModel(MigraineDiaryMVC_DBContext context)
{
var models = GetOrderedMigrainesList(context);
var model = new MigrainesModel(models);
return model;
}
public static MigraineModel FindFromGuid(MigraineDiaryMVC_DBContext context, string id = "")
{
try
{
var guid = String.IsNullOrWhiteSpace(id)
? Guid.Empty
: Guid.Parse(id);
var migraineModel = context.Migraines.Find(guid);
return migraineModel;
}
catch (Exception e)
{
//that wasn't a valid guid....
return null;
}
}
protected BaseDisposableRepository(MigraineDiaryMVC_DBContext context, bool saveOnChange = true)
{
this.Context = context;
this.SaveOnChange = saveOnChange;
}
