public static void Restaurants(McDonaldsContext context) { List <Restaurant> restaurantList = new List <Restaurant>(); try { DataTable deploiementTable = ExcelParserHelper .ReadExcelFile(@"" + AppSettings.ReadSetting <string>(AppSettingConstants.ListRestaurantFile, default(string))) .Tables["Déploiement"]; for (int i = 2; i < deploiementTable.Rows.Count; i++) { restaurantList.Add(new Restaurant() { RestaurantId = Convert.ToInt32(deploiementTable.Rows[i][0]), ServerIpAddress = IpAddressHelper.CcToIp(Convert.ToInt32(deploiementTable.Rows[i][0]), 71).ToString(), Nom = Convert.ToString(deploiementTable.Rows[i][1]), }); } restaurantList.Add(new Restaurant() { RestaurantId = 9, ServerIpAddress = "10.19.9.71", Nom = "ParisC", }); context.Set <Restaurant>().AddOrUpdate(r => r.RestaurantId, restaurantList.Where(r => r.RestaurantId != 0).ToArray()); } catch (Exception ex) { throw ex; } }
public static bool CheckDeploiementDate(int restaurantId, DateTime currentDate) { DeploimentDateModel model = new DeploimentDateModel() { RestaurantId = restaurantId, }; DataTable deploiementTable = ExcelParserHelper .ReadExcelFile ( AppSettings.ReadSetting <string>(AppSettingConstants.ListRestaurantFile, default(string)) ).Tables["Déploiement"]; for (int i = 2; i < deploiementTable.Rows.Count; i++) { if (Convert.ToInt32(deploiementTable.Rows[i][0]) == restaurantId) { for (int j = 1; j < deploiementTable.Columns.Count; j++) { if (deploiementTable.Rows[i][j] is DateTime && ((DateTime)deploiementTable.Rows[i][j]).Date == currentDate.Date) { model.DeploimentDate = Convert.ToDateTime(deploiementTable.Rows[i][j]); break; } } break; } } ; return(model.DeploimentDate.HasValue); }