예제 #1
0
 public static void ImportTemplate(DbProviderFactory factory, ImporterSettingsFactory settings)
 {
     using (var conn = factory.CreateConnection())
     {
         Debug.Assert(conn != null, "conn != null");
         conn.ConnectionString = settings.ConnectionString.ConnectionString;
         var reservationsList = conn.Query<StayData>(settings.QueryString, null);
         var map = reservationsList
             .GroupBy(x => x.HotelId)
             .ToDictionary(x => x.Key, x => x.ToList());
         ResultLogger resultsLogger = new StringBuildResults();
         foreach (var key in map.Keys)
         {
             var reservationsByHotel = new List<StayData>();
             foreach (var reserv in map[key])
             {
                 if (string.IsNullOrEmpty(reserv.HotelId) ||
                     string.IsNullOrEmpty(reserv.ExternalKey) ||
                     reserv.PeriodStart.Equals(DateTime.MinValue) ||
                     reserv.PeriodEnd.Equals(DateTime.MinValue))
                 {
                     resultsLogger.AddResponse(new StayImportResultDto
                     {
                         Success = false,
                         ExternalKey = reserv.ExternalKey,
                         GuestEmail = reserv.GuestEmail,
                         Message = @"Reservation has invalid values.",
                         Data = StayDataToString(reserv)
                     });
                     continue;
                 }
                 reserv.Reservation = reserv.Reservation ?? reserv.ExternalKey;
                 reservationsByHotel.Add(reserv);
             }
             var recordCount = reservationsByHotel.Count;
             const int batchSize = 100;
             for (var index = 0; index < recordCount; index += batchSize)
             {
                 var stays = reservationsByHotel.GetRange(index, Math.Min(batchSize, recordCount - index));
                 ImportStaysBatch(settings.HotelMapping(key), stays, resultsLogger, settings.BaseUri);
             }
         }
         Log.AppendLine();
         Log.Append(resultsLogger);
     }
 }
예제 #2
0
        public static void ImportTemplateWithDataReader(DbProviderFactory factory, ImporterSettingsFactory settings)
        {
            using (var connection = factory.CreateConnection())
            {
                Debug.Assert(connection != null, "connection != null");
                connection.ConnectionString = settings.ConnectionString.ConnectionString;
                var command = factory.CreateCommand();
                Debug.Assert(command != null, "command != null");
                command.Connection = connection;
                command.CommandText = settings.QueryString;
                connection.Open();
                using (var reader = command.ExecuteReader())
                {
                    List<StayData> stays = new List<StayData>();
                    int recordCount = 0;
                    int recordErrors = 0;
                    ResultLogger resultsLogger = new StringBuildResults();
                    while (reader.Read())
                    {
                        recordCount++;
                        try
                        {
                            var stay = new StayData
                            {
                                Room = reader.IsDBNull(0) ? string.Empty : reader.GetString(0),
                                Reservation = reader.IsDBNull(1) ? string.Empty : reader.GetString(1),
                                PeriodStart = reader.GetDateTime(2),
                                PeriodEnd = reader.GetDateTime(3),
                                IsCheckedIn = Convert.ToBoolean(reader.GetByte(4)),
                                AllowExpressCheckout = Convert.ToBoolean(reader.GetByte(5)),
                                CurrentBillValue = (reader.IsDBNull(6) ? (double?)null : reader.GetDouble(6)),
                                CurrentBillDate = reader.IsDBNull(7) ? (DateTime?)null : reader.GetDateTime(7),
                                CurrentBillCurrency = reader.IsDBNull(8) ? string.Empty : reader.GetString(8),
                                IsBreakfastIncluded = Convert.ToBoolean(reader.GetByte(9)),
                                GuestEmail = reader.IsDBNull(10) ? string.Empty : reader.GetString(10),
                                GuestFirstName = reader.IsDBNull(11) ? string.Empty : reader.GetString(11),
                                GuestLastName = reader.IsDBNull(12) ? string.Empty : reader.GetString(12),
                                GuestPhoneNumber = reader.IsDBNull(13) ? string.Empty : reader.GetString(13),
                                ExternalKey = reader.IsDBNull(14) ? string.Empty : reader.GetString(14),
                                State = (StayStates)Enum.Parse(typeof(StayStates), reader.GetString(15))
                            };
                            stays.Add(stay);
                        }
                        catch (Exception e)
                        {
                            //Log.AppendFormat("Error read {0}(Message:{1})", reader.GetString(14), e.Message);
                            //Log.AppendLine();
                            //SendToRaygun(e);
                            System.Console.WriteLine(e.Message);
                            recordErrors++;
                        }

                        if (1 == stays.Count)
                        {
                            //ImportStayBatch(settings, stays, resultsLogger);
                            stays.Clear();
                        }
                    }
                    reader.Close();
                    if (0 < stays.Count)
                    {
                        //ImportStayBatch(settings, stays, resultsLogger);
                    }
                    Log.AppendLine();
                    Log.AppendFormat("Found {0} records to import.", recordCount);
                    Log.AppendLine();
                    Log.AppendFormat("Found {0} records with errors.", recordErrors);
                    Log.Append(resultsLogger);
                }
            }
        }