public static async Task <bool> SyncFigthersAsync()
{
string fightersUrl = ConfigurationManager.AppSettings["HemaRatingsFightersUrl"];
var response = await GetResponse(fightersUrl);
List <HtmlNode> figtherNodes = GetNodes(response);
List <HemaRatingsFighterEntity> hemaFigthers = new List <HemaRatingsFighterEntity>();
int i = 1;
foreach (var node in figtherNodes)
{
var li = node.Descendants("td").ToList();
if (li.Count > 0)
{
var name_surname = li[0].InnerText;
string nationality = GetNationality(li);
var figtherId = GetId(li);
int clubId = GetClubId(li);
hemaFigthers.Add(new HemaRatingsFighterEntity
{
Id = figtherId,
IdClub = clubId,
Name = name_surname.Replace("'", "''"),
Nationality = nationality.Replace("'", "''")
});
}
}
return(SqlDal_HemaRatings.InsertFightersIntoDB(hemaFigthers));
}
public static async Task <bool> SyncClubsAsync()
{
string clubsUrl = ConfigurationManager.AppSettings["HemaRatingsClubUrl"];
var response = await GetResponse(clubsUrl);
List <HtmlNode> clubNodes = GetNodes(response);
List <HemaRatingsClubEntity> hemaClubs = new List <HemaRatingsClubEntity>();
int i = 1;
foreach (var node in clubNodes)
{
var li = node.Descendants("td").ToList();
if (li.Count > 0)
{
var clubName = li[0].InnerText.Replace("\r\n", "").Trim();
var clubId = GetId(li);
var country = GetCountry(li);
var state = GetState(li);
var city = GetCity(li);
hemaClubs.Add(new HemaRatingsClubEntity
{
Id = clubId,
Name = clubName.Replace("'", "''"),
Country = country.Replace("'", "''"),
State = state.Replace("'", "''"),
City = city.Replace("'", "''")
});
}
}
return(SqlDal_HemaRatings.InsertClubsIntoDB(hemaClubs));
}
