public static void ImportFixedData(string path) { //var excelFile = new ExcelQueryFactory(path) { TrimSpaces = TrimSpacesType.Both, ReadOnly = true }; //foreach (var row in excelFile.GetWorksheetNames() // .Select(worksheet => (from row in excelFile.Worksheet(worksheet) select row)).SelectMany(rows => rows)) { using (var ds = FillDataSet(path)) { for (var i = 1; i < ds.Tables[0].Rows.Count; i++) { using (var db = new SqLiteDbContext()) { var local = ds.Tables[0].Rows[i][1].ToString(); switch (local) { case "Klub": var club = new Club(); SetCommonData(club, ds.Tables[0].Rows[i], db); SetClubData(club, ds.Tables[0].Rows[i], db); db.Clubs.AddOrUpdate(x => x.Code, club); break; case "Pub": var pub = new Pub(); SetCommonData(pub, ds.Tables[0].Rows[i], db); SetPubData(pub, ds.Tables[0].Rows[i], db); db.Pubs.AddOrUpdate(x => x.Code, pub); break; case "Restaurant": var restaurant = new Restaurant(); SetCommonData(restaurant, ds.Tables[0].Rows[i], db); SetRestaurantData(restaurant, ds.Tables[0].Rows[i], db); db.Restaurants.AddOrUpdate(x => x.Code, restaurant); break; case "Kawiarnie": var café = new Cafe(); SetCommonData(café, ds.Tables[0].Rows[i], db); SetCaféData(café, ds.Tables[0].Rows[i], db); db.Cafes.AddOrUpdate(x => x.Code, café); break; case "Hotel": var hotel = new Hotel(); SetCommonData(hotel, ds.Tables[0].Rows[i], db); SetHotelData(hotel, ds.Tables[0].Rows[i], db); db.Hotels.AddOrUpdate(x => x.Code, hotel); break; } db.SaveChanges(); } } } } }
private static void SetRestaurantData(Restaurant restaurant, DataRow row, SqLiteDbContext db) { restaurant.MondayOpening = row[8].ToString(); restaurant.MondayClosing = row[9].ToString(); restaurant.ThusdayClosing = row[10].ToString(); restaurant.ThusdayOpening = row[11].ToString(); restaurant.WednesdayOpening = row[12].ToString(); restaurant.WednesdayClosing = row[13].ToString(); restaurant.ThursdayOpening = row[14].ToString(); restaurant.ThursdayClosing = row[15].ToString(); restaurant.FridayOpening = row[16].ToString(); restaurant.FridayClosing = row[17].ToString(); restaurant.SaturdayOpening = row[18].ToString(); restaurant.SaturdayClosing = row[19].ToString(); restaurant.SundayOpening = row[20].ToString(); restaurant.SundayClosing = row[21].ToString(); restaurant.AvailableCoupons = row[33].ToString().ToLower().Equals("yes"); string food = row[45].ToString(); var foodType = db.FoodTypes.FirstOrDefault(x => x.TypeOfFood.Equals(food)); if (foodType != null) { var foodTypeId = foodType.Id; restaurant.FoodTypeId = foodTypeId; } else restaurant.FoodType = new FoodType {TypeOfFood = food}; restaurant.PricesRange1 = row[46].ToString(); restaurant.PricesRange2 = row[47].ToString(); restaurant.CheckMenu = row[48].ToString(); }