public AirLineCrawler(int startDay)
{
if (startDay == 29)
startDay = 28;
monthInfo = new MonthInfo(startDay);
domesticRoute = ListDomesticRoute.getListDomesticRoute().First();
indexDomesticRoute = 0;
}
public void Next()
{
indexDomesticRoute++;
countTotal++;
if (indexDomesticRoute >= ListDomesticRoute.getListDomesticRoute().Length)
{
monthInfo.month++;
if (monthInfo.month > 12)
monthInfo.month = 1;
indexDomesticRoute = 0;
}
domesticRoute = ListDomesticRoute.getListDomesticRoute()[indexDomesticRoute];
}
public static DomesticRoute[] getListDomesticRoute()
{
if (_listDomesticRoute == null)
{
DataTable dt = DBHelper.GetDataTableSP("GetDomesticRoute");
List<DomesticRoute> li = new List<DomesticRoute>();
foreach(DataRow dr in dt.Rows)
{
DomesticRoute dmr = new DomesticRoute();
dmr.Id=(int)dr["Id"];
dmr.IsBL=(bool)dr["IsBL"];
dmr.IsVJ=(bool)dr["IsVJ"];
dmr.IsVN=(bool)dr["IsVN"];
dmr.ArrivalAirport = (string)dr["ArrivalAirport"];
dmr.DepartureAirport = (string)dr["DepartureAirport"];
li.Add(dmr);
}
_listDomesticRoute = li.ToArray();
}
return _listDomesticRoute;
}
public void UpdateToDatabase(RootMinPrice root, bool isVN, bool isVJ, bool isBL, DomesticRoute domesticRoute)
{
if(root==null||root.departurePrices==null||root.departurePrices.prices==null||root.departurePrices.prices.Count==0)
{
countNull++;
return;
}
foreach (MinPriceDetail mpd in root.departurePrices.prices)
{
try
{
if (mpd.Price == "" || mpd.Price == "0")
continue;
List<SqlParameter> sps = new List<SqlParameter>();
sps.Add(new SqlParameter("@DomesticRouteId", domesticRoute.Id));
sps.Add(new SqlParameter("@Date", mpd.Date.Day));
sps.Add(new SqlParameter("@Month", mpd.Date.Month));
if (isVN)
{
sps.Add(new SqlParameter("@VN", mpd.Price));
}
else if (isVJ)
{
sps.Add(new SqlParameter("@VJ", mpd.Price));
}
else if (isBL)
{
sps.Add(new SqlParameter("@BL", mpd.Price));
}
DBHelper.ExecuteNonQuery("InsertOrUpdateToMinPrice", sps);
}
catch(Exception ex)
{
}
}
}
