// 플레이어 얻어오기
public void SelectPlayer()
{
Crawler.Manager mgr = new Crawler.Manager();
try
{
Util.DataBaseManager dbMgr = new Util.DataBaseManager();
dbMgr.DataContext.ExecuteCommand("TRUNCATE TABLE PLAYER", new Object[] { });
var player_Ws = dbMgr.SelectAll <Player_W>();
List <Player> players = new List <Player>();
for (Int32 i = 0; i < player_Ws.Count();)
{
foreach (var player_W in player_Ws)
{
var player = mgr.GetPlayer(player_W);
players.Add(player);
}
}
dbMgr.Save <Player>(players);
}
finally
{
mgr.Dispose();
}
}
// BoxScore 불러오기
public void SelectBoxScore_W()
{
Crawler.Manager mgr = new Crawler.Manager();
try
{
Util.DataBaseManager dbMgr = new Util.DataBaseManager();
var schedules = from schedule in dbMgr.SelectAll <Schedule>()
join boxScore in dbMgr.SelectAll <BoxScore_W>()
on schedule.GameId equals boxScore.GameId into t
from subBoxScore in t.DefaultIfEmpty()
where schedule.LeagueId == 1 && schedule.SeriesId == 0 &&
schedule.Href != null && subBoxScore.AwayHitter == null
select schedule;
schedules = from schedule in schedules
where schedule.Year >= 2013
select schedule;
foreach (var schedule in schedules)
{
List <BoxScore_W> boxScore_Ws = new List <BoxScore_W>();
var situation_W = GetBoxScore_W(mgr, schedule, 5);
boxScore_Ws.Add(situation_W);
dbMgr.Save <BoxScore_W>(boxScore_Ws);
}
}
finally
{
mgr.Dispose();
}
}
// 플레이어 리스트 얻어오기
public void SelectPlayer_W()
{
Crawler.Manager mgr = new Crawler.Manager();
try
{
Util.DataBaseManager dbMgr = new Util.DataBaseManager();
dbMgr.DataContext.ExecuteCommand("TRUNCATE TABLE PLAYER_W", new Object[] { });
foreach (String team in Util.Util.Teams)
{
var players = mgr.GetPlayer_W(team);
dbMgr.Save<Player_W>(players);
}
}
finally
{
mgr.Dispose();
}
}
// 플레이어 리스트 얻어오기
public void SelectPlayer_W()
{
Crawler.Manager mgr = new Crawler.Manager();
try
{
Util.DataBaseManager dbMgr = new Util.DataBaseManager();
dbMgr.DataContext.ExecuteCommand("TRUNCATE TABLE PLAYER_W", new Object[] { });
foreach (String team in Util.Util.Teams)
{
var players = mgr.GetPlayer_W(team);
dbMgr.Save <Player_W>(players);
}
}
finally
{
mgr.Dispose();
}
}
// 플레이어 얻어오기
public void SelectPlayer()
{
Crawler.Manager mgr = new Crawler.Manager();
try
{
Util.DataBaseManager dbMgr = new Util.DataBaseManager();
dbMgr.DataContext.ExecuteCommand("TRUNCATE TABLE PLAYER", new Object[] { });
var player_Ws = dbMgr.SelectAll<Player_W>();
List<Player> players = new List<Player>();
for(Int32 i = 0; i < player_Ws.Count(); )
foreach (var player_W in player_Ws)
{
var player = mgr.GetPlayer(player_W);
players.Add(player);
}
dbMgr.Save<Player>(players);
}
finally
{
mgr.Dispose();
}
}
// 일정불러오기
public void SelectSchedule()
{
Crawler.Manager mgr = new Crawler.Manager();
Util.DataBaseManager dbMgr = new Util.DataBaseManager();
// 일정불러오기
var allSchedule = dbMgr.SelectAll<Schedule>();
Int32 year = 2010;
Int32 month = 3;
if(allSchedule.Count() > 0)
{
year = (from schedule in allSchedule select schedule.Year).Max();
month = (from schedule in allSchedule where schedule.Year == year select schedule.Month).Max();
}
DateTime startDate = new DateTime(year, month, 1);
DateTime endDate = DateTime.Now;
try
{
Int32 errorCount = 0;
while (startDate <= endDate)
{
try
{
var data = mgr.GetSchedule(startDate.Year, startDate.Month);
var scheduleTable = dbMgr.DataContext.GetTable<Schedule>();
var delSchedule = from schedule in allSchedule
where schedule.Year == startDate.Year && schedule.Month == startDate.Month
select schedule;
foreach (var schedule in delSchedule)
{
scheduleTable.DeleteOnSubmit(schedule);
}
dbMgr.DataContext.SubmitChanges();
dbMgr.Save(data);
startDate = startDate.AddMonths(1);
errorCount = 0;
}
catch (OpenQA.Selenium.StaleElementReferenceException exception)
{
if (errorCount < 10)
{
errorCount++;
continue;
}
else
{
throw exception;
}
}
}
}
finally
{
mgr.Dispose();
}
}
// BoxScore 불러오기
public void SelectBoxScore_W()
{
Crawler.Manager mgr = new Crawler.Manager();
try
{
Util.DataBaseManager dbMgr = new Util.DataBaseManager();
var schedules = from schedule in dbMgr.SelectAll<Schedule>()
join boxScore in dbMgr.SelectAll<BoxScore_W>()
on schedule.GameId equals boxScore.GameId into t
from subBoxScore in t.DefaultIfEmpty()
where schedule.LeagueId == 1 && schedule.SeriesId == 0
&& schedule.Href != null && subBoxScore.AwayHitter == null
select schedule;
schedules = from schedule in schedules
where schedule.Year >= 2013
select schedule;
foreach (var schedule in schedules)
{
List<BoxScore_W> boxScore_Ws = new List<BoxScore_W>();
var situation_W = GetBoxScore_W(mgr, schedule, 5);
boxScore_Ws.Add(situation_W);
dbMgr.Save<BoxScore_W>(boxScore_Ws);
}
}
finally
{
mgr.Dispose();
}
}
// 일정불러오기
public void SelectSchedule()
{
Crawler.Manager mgr = new Crawler.Manager();
Util.DataBaseManager dbMgr = new Util.DataBaseManager();
// 일정불러오기
var allSchedule = dbMgr.SelectAll <Schedule>();
Int32 year = 2010;
Int32 month = 3;
if (allSchedule.Count() > 0)
{
year = (from schedule in allSchedule select schedule.Year).Max();
month = (from schedule in allSchedule where schedule.Year == year select schedule.Month).Max();
}
DateTime startDate = new DateTime(year, month, 1);
DateTime endDate = DateTime.Now;
try
{
Int32 errorCount = 0;
while (startDate <= endDate)
{
try
{
var data = mgr.GetSchedule(startDate.Year, startDate.Month);
var scheduleTable = dbMgr.DataContext.GetTable <Schedule>();
var delSchedule = from schedule in allSchedule
where schedule.Year == startDate.Year && schedule.Month == startDate.Month
select schedule;
foreach (var schedule in delSchedule)
{
scheduleTable.DeleteOnSubmit(schedule);
}
dbMgr.DataContext.SubmitChanges();
dbMgr.Save(data);
startDate = startDate.AddMonths(1);
errorCount = 0;
}
catch (OpenQA.Selenium.StaleElementReferenceException exception)
{
if (errorCount < 10)
{
errorCount++;
continue;
}
else
{
throw exception;
}
}
}
}
finally
{
mgr.Dispose();
}
}