Example #1
0
        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;
        }
Example #2
0
        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();
        }