public void Import(IEnumerable <ShoppingListItems> data)
{
using (var transaction = session.BeginTransaction())
{
var d = data.ToArray();
foreach (var row in d)
{
var dbItem = new Models.ShoppingListItems
{
ItemId = row.ItemId,
Raw = row.Raw,
Qty = row.Qty,
Unit = row.Unit,
UserId = row.UserId,
Ingredient = row.IngredientId.HasValue ? Models.Ingredients.FromId(row.IngredientId.Value) : null,
Recipe = row.RecipeId.HasValue ? Models.Recipes.FromId(row.RecipeId.Value) : null,
ShoppingList = row.ShoppingListId.HasValue ? Models.ShoppingLists.FromId(row.ShoppingListId.Value) : null,
CrossedOut = row.CrossedOut
};
session.Save(dbItem, row.ItemId);
}
Log.DebugFormat("Created {0} row(s) in ShoppingListItems", d.Count());
transaction.Commit();
session.Flush();
}
}
public void Import(IEnumerable<ShoppingListItems> data)
{
using (var transaction = this.session.BeginTransaction())
{
var shoppingListItemsArray = data.ToArray();
foreach (var shoppingListItems in shoppingListItemsArray)
{
var databaseShopingListItems = new Models.ShoppingListItems
{
ItemId = shoppingListItems.ItemId,
Raw = shoppingListItems.Raw,
Qty = shoppingListItems.Qty,
Unit = shoppingListItems.Unit,
UserId = shoppingListItems.UserId,
Ingredient =
shoppingListItems.IngredientId.HasValue
? Models.Ingredients.FromId(
shoppingListItems.IngredientId
.Value)
: null,
Recipe =
shoppingListItems.RecipeId.HasValue
? Models.Recipes.FromId(
shoppingListItems.RecipeId.Value)
: null,
ShoppingList =
shoppingListItems.ShoppingListId
.HasValue
? Models.ShoppingLists.FromId(
shoppingListItems.ShoppingListId
.Value)
: null,
CrossedOut = shoppingListItems.CrossedOut
};
this.session.Save(databaseShopingListItems, shoppingListItems.ItemId);
}
this.Log.DebugFormat("Created {0} row(s) in ShoppingListItems", shoppingListItemsArray.Count());
transaction.Commit();
this.session.Flush();
}
}
public void Import(IEnumerable<ShoppingListItems> data)
{
using (var transaction = session.BeginTransaction())
{
var d = data.ToArray();
foreach (var row in d)
{
var dbItem = new Models.ShoppingListItems
{
ItemId = row.ItemId,
Raw = row.Raw,
Qty = row.Qty,
Unit = row.Unit,
UserId = row.UserId,
Ingredient = row.IngredientId.HasValue ? Models.Ingredients.FromId(row.IngredientId.Value) : null,
Recipe = row.RecipeId.HasValue ? Models.Recipes.FromId(row.RecipeId.Value) : null,
ShoppingList = row.ShoppingListId.HasValue ? Models.ShoppingLists.FromId(row.ShoppingListId.Value) : null,
CrossedOut = row.CrossedOut
};
session.Save(dbItem, row.ItemId);
}
Log.DebugFormat("Created {0} row(s) in ShoppingListItems", d.Count());
transaction.Commit();
session.Flush();
}
}
