private void LoadData()
{
double fromTimeStamp = Utils.ConvertToTimestamp(DateTime.Now.AddDays(-7));
double toTimeStamp = Utils.ConvertToTimestamp(DateTime.Now);
lblServerTime.Text = DateTime.Now.ToUniversalTime().ToString("yyyy-MM-dd HH:mm:ss");
lblProcessing.Visible = true;
List <ObjectResult> objectResultsMinute5 = null;
List <ObjectResult> objectResultsMinute15 = null;
List <ObjectResult> objectResultsMinute30 = null;
List <ObjectResult> objectResultsHour = null;
List <ObjectResult> objectResultsHour2 = null;
List <ObjectResult> objectResultsHour4 = null;
List <ObjectResult> objectResultsDay = null;
List <ObjectResult> objectResultsWeek = null;
List <ObjectResult> objectResultsMonth = null;
try
{
foreach (var coin in GetCoins())
{
if (!string.IsNullOrEmpty(coin))
{
string url = string.Format("https://poloniex.com/public?command=returnTradeHistory¤cyPair={0}_{1}&start={2}&end={3}", cbCoinType.Text, coin, fromTimeStamp, toTimeStamp);
DataTable dt = ServiceHelper.GetJsonData(url);
objectResultsMinute5 = new List <ObjectResult>();
objectResultsMinute15 = new List <ObjectResult>();
objectResultsMinute30 = new List <ObjectResult>();
objectResultsHour = new List <ObjectResult>();
objectResultsHour2 = new List <ObjectResult>();
objectResultsHour4 = new List <ObjectResult>();
objectResultsDay = new List <ObjectResult>();
objectResultsWeek = new List <ObjectResult>();
objectResultsMonth = new List <ObjectResult>();
if (dt != null)
{
//Load 5 minutes
var listMinutes5 = dt.AsEnumerable().Where(x => Convert.ToDateTime(x.Field <string>("date")) >= Constant.Minutes5);
if (listMinutes5 != null && listMinutes5.Count() > 0)
{
DataTable dtMinute5 = listMinutes5.CopyToDataTable();
objectResultsMinute5.Add(GetObjectResult(coin, dtMinute5));
}
//Load 15 minutes
var listMinutes15 = dt.AsEnumerable().Where(x => Convert.ToDateTime(x.Field <string>("date")) >= Constant.Minutes15);
if (listMinutes15 != null && listMinutes15.Count() > 0)
{
DataTable dtMinute15 = listMinutes15.CopyToDataTable();
objectResultsMinute15.Add(GetObjectResult(coin, dtMinute15));
}
//Load 30 minutes
var listMinutes30 = dt.AsEnumerable().Where(x => Convert.ToDateTime(x.Field <string>("date")) >= Constant.Minutes30);
if (listMinutes30 != null && listMinutes30.Count() > 0)
{
DataTable dtMinute30 = listMinutes30.CopyToDataTable();
objectResultsMinute30.Add(GetObjectResult(coin, dtMinute30));
}
//Load 1 hour
var listHour = dt.AsEnumerable().Where(x => Convert.ToDateTime(x.Field <string>("date")) >= Constant.Hour);
if (listHour != null && listHour.Count() > 0)
{
DataTable dtHour = listHour.CopyToDataTable();
objectResultsHour.Add(GetObjectResult(coin, dtHour));
}
//Load 2 hour
var listHour2 = dt.AsEnumerable().Where(x => Convert.ToDateTime(x.Field <string>("date")) >= Constant.Hour2);
if (listHour2 != null && listHour2.Count() > 0)
{
DataTable dtHour2 = listHour2.CopyToDataTable();
objectResultsHour2.Add(GetObjectResult(coin, dtHour2));
}
//Load 4 hour
var listHour4 = dt.AsEnumerable().Where(x => Convert.ToDateTime(x.Field <string>("date")) >= Constant.Hour4);
if (listHour4 != null && listHour4.Count() > 0)
{
DataTable dtHour4 = listHour4.CopyToDataTable();
objectResultsHour4.Add(GetObjectResult(coin, dtHour4));
}
//Load Day
var listDay = dt.AsEnumerable().Where(x => Convert.ToDateTime(x.Field <string>("date")) >= Constant.Day);
if (listDay != null && listDay.Count() > 0)
{
DataTable dtDay = listDay.CopyToDataTable();
objectResultsDay.Add(GetObjectResult(coin, dtDay));
}
//Load Week
var listWeek = dt.AsEnumerable().Where(x => Convert.ToDateTime(x.Field <string>("date")) >= Constant.Week);
if (listWeek != null && listWeek.Count() > 0)
{
DataTable dtWeek = listWeek.CopyToDataTable();
objectResultsWeek.Add(GetObjectResult(coin, dtWeek));
}
////Load Month
//var listMonth = dt.AsEnumerable().Where(x => Convert.ToDateTime(x.Field<string>("date")) >= Month);
//if (listMonth != null && listMonth.Count() > 0)
//{
// DataTable dtMonth = listMonth.CopyToDataTable();
// objectResultsMonth.Add(GetObjectResult(coin, dtMonth));
//}
}
}
}
gvMinute5.DataSource = GridHelper.ConvertListToDataTable(objectResultsMinute5);
gvMinute15.DataSource = GridHelper.ConvertListToDataTable(objectResultsMinute15);
gvMinute30.DataSource = GridHelper.ConvertListToDataTable(objectResultsMinute30);
gvHour.DataSource = GridHelper.ConvertListToDataTable(objectResultsHour);
gvHour2.DataSource = GridHelper.ConvertListToDataTable(objectResultsHour2);
gvHour4.DataSource = GridHelper.ConvertListToDataTable(objectResultsHour4);
gvDay.DataSource = GridHelper.ConvertListToDataTable(objectResultsDay);
gvWeek.DataSource = GridHelper.ConvertListToDataTable(objectResultsWeek);
//gvMonth.DataSource = ConvertListToDataTable(objectResultsMonth);
lblProcessing.Visible = false;
}
catch (WebException webex)
{
MessageBox.Show("Get data error!!!");
}
}