private static IEnumerable<Order> ConvertToCollection(object[,] valueArray) { var orderList = new List<Order>(); var sqlGirlRepo = new GenericRepository<Girl>(new GirlsAgencyContext()); var sqlCustomerRepo = new GenericRepository<Customer>(new GirlsAgencyContext()); for (var row = 0; row < valueArray.GetLength(0); row++) { var girlFirstName = valueArray[row, 0].ToString(); var girlLastName = valueArray[row, 1].ToString(); var customerFirstName = valueArray[row, 2].ToString(); var customerLastName = valueArray[row, 3].ToString(); var duration = Convert.ToInt32(valueArray[row, 4]); var dateTime = Convert.ToDateTime(valueArray[row, 5]); var girlId = sqlGirlRepo.Search(n => n.FirstName == girlFirstName && n.LastName == girlLastName).First().Id; var girlOBJ = sqlGirlRepo.Search(n => n.FirstName == girlFirstName && n.LastName == girlLastName).First(); var customerId = sqlCustomerRepo.Search(n => n.FirstName == customerFirstName && n.LastName == customerLastName).First().Id; var order = new Order { GirlId = girlId, CustomerId = customerId, Duration = duration, Date = dateTime }; var baihoi = sqlGirlRepo.GetCustomer(customerId); girlOBJ.Customers.Add(baihoi); sqlGirlRepo.SaveChanges(); //order.Girl.Customers.Add(sqlCustomerRepo.GetCustomer(customerId)); orderList.Add(order); } return orderList; }
private static void ExportOrdersFromMSSqlToMySql(GenericRepository<Order> sqlOrdersRepo, GenericRepository<Order> mysSqlOrdersRepo) { var girlsMysql = new GenericRepository<Girl>(new GirlAgencyMySql.Data.MySql()); var customersMysq = new GenericRepository<Customer>(new GirlAgencyMySql.Data.MySql()); foreach (var orderFromSql in sqlOrdersRepo.GetAll().ToList()) { //Console.WriteLine(orderFromSql.); var order = new Order() { GirlId = girlsMysql .GetAll() .FirstOrDefault(g => g.FirstName == orderFromSql.Girl.FirstName && g.LastName == orderFromSql.Girl.LastName).Id, CustomerId = customersMysq .GetAll() .FirstOrDefault(c => c.FirstName == orderFromSql.Customer.FirstName && c.LastName == orderFromSql.Customer.LastName).Id, Duration = orderFromSql.Duration, Date = orderFromSql.Date }; mysSqlOrdersRepo.Add(order); } mysSqlOrdersRepo.SaveChanges(); }