public void GivenContextWhenDescriptionsAccessedThenDoesNotThrowErrors()
{
using (var ctx = new FoodContext())
{
var listOfFoodDescriptions = ctx.FoodDescriptions.ToList();
Assert.IsNotNull(listOfFoodDescriptions);
}
}
public ActionResult FoodDescriptions([DataSourceRequest]DataSourceRequest request)
{
try
{
using (var context = new FoodContext())
{
return Json(context.FoodDescriptions.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest, ex.Message);
}
}
private static void Main()
{
var parse = "FOOD_DES.txt".AsEnumerableLinesForFile().ToList();
Console.WriteLine("Parsing {0} food descriptions.", parse.Count());
using (var context = new FoodContext())
{
if (context.FoodDescriptions.Any())
{
Console.WriteLine("Food descriptions already exist.");
}
else
{
foreach (var item in parse.Select(description => description.Split('^'))
.Select(parts => new FoodDescription
{
Number = parts[0].AsCleanField(),
Group = parts[1].AsCleanField(),
Description = parts[2].AsCleanField(),
Name = parts[3].AsCleanField(),
ProteinFactor = parts[11].SafeDecimal(),
FatFactor = parts[12].SafeDecimal(),
CarbFactor = parts[13].SafeDecimal(),
SomeDate = DateTimeOffset.Now
}))
{
context.FoodDescriptions.Add(item);
Console.Write(".");
}
Console.WriteLine("Saving changes...");
context.SaveChanges();
Console.WriteLine("Done!");
}
}
Console.ReadLine();
}
