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);
}
