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(); } }