public void CrawlGolfBettingMarketName()
{
string url = "";
string htmlcontent = Helper.GetWebSiteContent(url);
HtmlAgilityPack.HtmlDocument doc = Helper.LoadHtml(htmlcontent);
XmlDocument xmldoc = new XmlDocument();
CrawlAllMarketsData crawldata = new CrawlAllMarketsData();
var row11 = doc.DocumentNode.SelectSingleNode("//ul[@class='more-outrights 1']");
var rows = row11.SelectNodes("./a");
if (rows != null)
{
List <MarketMaster> lit = new List <MarketMaster>();
for (int i = 0; i < rows.Count; i++)
{
MarketMaster market = new MarketMaster();
string li = rows[i].InnerText;
var linkrow = rows[i].SelectNodes("./span");
market.MarketMarketName = linkrow[0].InnerText;
market.MarketResultLink = "http://www.oddschecker.com" + rows[0].Attributes["href"].Value;
market.MarketSportID = 29;
InsertMasterMarket(market);
lit.Add(market);
}
xmldoc = GenerateXmlGolfMarketMaster(lit);
}
}
/// <summary>
/// dev
/// </summary>
/// <param name="marketid"></param>
/// <returns></returns>
///
public void InsertMasterMarket(MarketMaster market)
{
using (SqlConnection objConn = new SqlConnection(OddsConnection.GetConnectionString()))
{
objConn.Open();
SqlCommand cmd = new SqlCommand("sp_MasterMarket", objConn);
cmd.Parameters.AddWithValue("@SportID", market.MarketSportID);
cmd.Parameters.AddWithValue("@ResultName", market.MarketMarketName);
cmd.Parameters.AddWithValue("@ResultLink", market.MarketResultLink);
cmd.Parameters.AddWithValue("@Mode", "Insert");
cmd.ExecuteNonQuery();
objConn.Close();
cmd.Dispose();
}
}
/// <summary>
/// エクセルモデルから市場マスタを作成
/// </summary>
/// <returns></returns>
public List <MarketMaster> ExcelModelToMarketModel(List <TokyoStockExchangeExcelModel> excelList)
{
List <MarketMaster> result = new List <MarketMaster>();
var marketGroup = excelList.GroupBy(x => x.MarketName).ToList();
for (int i = 0; i <= marketGroup.Count - 1; i++)
{
MarketMaster list = new MarketMaster();
list.MarketId = i.ToString();
list.MarketName = marketGroup[i].Key;
result.Add(list);
}
return(result);
}
