//= new Dictionary<string, int>();
public static void Init()
{
GoogleSheet googleSheet = new GoogleSheet();
googleSheet.Url = "https://docs.google.com/spreadsheets/d/1lYBNEs-YhKCHwYCFeHQNZXM1wW1NnJH6LUsr8aix0-U";
//googleSheet.TabName = "2019";
googleSheet.TabName = "2020";
googleSheet.Range = "A2:J";
googleSheet.Init();
IList <IList <Object> > values = googleSheet.ResponseValues();
HashSet <string> namceounts = new HashSet <string>();
namceountKeyActualTimeValue = new Dictionary <string, int>();
if (values != null && values.Count > 0)
{
foreach (var row in values)
{
int countCell = 0;
foreach (var cell in row)
{
countCell++;
if (countCell == 4)
{
namceounts.Add(cell.ToString());
}
}
}
}
foreach (string namceount in namceounts)
{
namceountKeyActualTimeValue.Add(namceount, 0);
}
if (values != null && values.Count > 0)
{
foreach (var row in values)
{
int countCell = 0;
string namceount = "";
foreach (var cell in row)
{
countCell++;
if (countCell == 1)
{
namceount = "";
}
if (countCell == 4)
{
namceount = cell.ToString();
}
if (countCell == 7)
{
if (!namceountKeyActualTimeValue.ContainsKey(namceount))
{
continue;
}
int val = namceountKeyActualTimeValue[namceount];
try
{
val = val + int.Parse(cell.ToString());
}
catch (Exception e)
{
string g = e.Message;
}
namceountKeyActualTimeValue[namceount] = val;
}
}
}
}
}
public async Task <ActionResult> Data2019()
{
Services.GoogleSheet googleSheet = new GoogleSheet();
googleSheet.Url = "https://docs.google.com/spreadsheets/d/1lYBNEs-YhKCHwYCFeHQNZXM1wW1NnJH6LUsr8aix0-U";
googleSheet.TabName = "2019";
googleSheet.Range = "A2:J";
//googleSheet.Url = "https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms";
//googleSheet.TabName = "Class Data";
//googleSheet.Range = "A2:E";
googleSheet.Init();
ViewBag.Data2019 = googleSheet.ResponseValues();
IList <IList <Object> > values = googleSheet.ResponseValues();
HashSet <string> namceounts = new HashSet <string>();
Dictionary <string, int> namceountKeyActualTimeValue = new Dictionary <string, int>();
if (values != null && values.Count > 0)
{
foreach (var row in values)
{
int countCell = 0;
foreach (var cell in row)
{
countCell++;
if (countCell == 4)
{
namceounts.Add(cell.ToString());
}
}
}
}
foreach (string namceount in namceounts)
{
namceountKeyActualTimeValue.Add(namceount, 0);
}
if (values != null && values.Count > 0)
{
foreach (var row in values)
{
int countCell = 0;
string namceount = "";
foreach (var cell in row)
{
countCell++;
if (countCell == 1)
{
namceount = "";
}
if (countCell == 4)
{
namceount = cell.ToString();
}
if (countCell == 7)
{
if (!namceountKeyActualTimeValue.ContainsKey(namceount))
{
continue;
}
int val = namceountKeyActualTimeValue[namceount];
try
{
val = val + int.Parse(cell.ToString());
}
catch (Exception e)
{
string g = e.Message;
}
namceountKeyActualTimeValue[namceount] = val;
}
}
}
}
ViewBag.Total = namceountKeyActualTimeValue;
return(View());
}