private void ImportInDB(DataRowCollection firstTableRows, DateTime dateTimeOfReports) { using (NitrogenNewEntities dbConnection = new NitrogenNewEntities()) { var nameOfPlace = firstTableRows[0].ItemArray[0].ToString(); var idOfThePlace = dbConnection.Places.Where(p => p.Name == nameOfPlace).Select(p => p.PlaceId).FirstOrDefault(); var idsOfProducts = dbConnection.Products.Select(x => x.ProductId).ToList(); Place newPlace = new Place(); if (idOfThePlace == 0) { newPlace = dbConnection.Places.Add(new Place() { Name = nameOfPlace, Address = "Undefined", }); } Sale theNewSale = new Sale(); for (int i = 2; i < firstTableRows.Count; i++) { theNewSale = new Sale(); var row = firstTableRows[i]; int reportProductId = int.Parse(row.ItemArray[0].ToString()); if (!idsOfProducts.Contains(reportProductId)) { Console.WriteLine( string.Format("The id: {0} is not contains in Products! Report cannot be processed.", reportProductId)); continue; } theNewSale.ProductId = reportProductId; theNewSale.Quantity = int.Parse(row.ItemArray[1].ToString()); theNewSale.PricePerUnit = decimal.Parse(row.ItemArray[2].ToString()); theNewSale.Sum = decimal.Parse(row.ItemArray[3].ToString()); theNewSale.PlaceId = idOfThePlace != 0 ? idOfThePlace : newPlace.PlaceId; theNewSale.Date = dateTimeOfReports; dbConnection.Sales.Add(theNewSale); } try { dbConnection.SaveChanges(); } catch (Exception ex) { this.ShowMessageException(ex); } } }
private void ImportInDB(DataRowCollection firstTableRows, DateTime dateTimeOfReports) { using (NitrogenNewEntities dbConnection = new NitrogenNewEntities()) { var nameOfPlace = firstTableRows[0].ItemArray[0].ToString(); var idOfThePlace = dbConnection.Places.Where(p => p.Name == nameOfPlace).Select(p => p.PlaceId).FirstOrDefault(); var idsOfProducts = dbConnection.Products.Select(x => x.ProductId).ToList(); Place newPlace = new Place(); if (idOfThePlace == 0) { newPlace = dbConnection.Places.Add(new Place() { Name = nameOfPlace, Address = "Undefined", }); } Sale theNewSale = new Sale(); for (int i = 2; i < firstTableRows.Count; i++) { theNewSale = new Sale(); var row = firstTableRows[i]; int reportProductId = int.Parse(row.ItemArray[0].ToString()); if (!idsOfProducts.Contains(reportProductId)) { Console.WriteLine( string.Format("The id: {0} is not contains in Products! Report cannot be processed.", reportProductId)); continue; } theNewSale.ProductId = reportProductId; theNewSale.Quantity = int.Parse(row.ItemArray[1].ToString()); theNewSale.PricePerUnit = decimal.Parse(row.ItemArray[2].ToString()); theNewSale.Sum = decimal.Parse(row.ItemArray[3].ToString()); theNewSale.PlaceId = idOfThePlace != 0 ? idOfThePlace : newPlace.PlaceId; theNewSale.Date = dateTimeOfReports; dbConnection.Sales.Add(theNewSale); } try { dbConnection.SaveChanges(); } catch (Exception ex) { this.ShowMessageException(ex); } } }