public FirstTypeChart(int type)
{
currentFile = new EfCurrentFile();
this.type = type;
string path = HostingEnvironment.ApplicationPhysicalPath + currentFile.GetCurrentFile().Path1;
FileStream stream = File.Open(path, FileMode.Open, FileAccess.Read);
IExcelDataReader dataReader = null;
if (path.EndsWith(".xls"))
{
dataReader = ExcelReaderFactory.CreateBinaryReader(stream);
}
else if (path.EndsWith(".xlsx"))
{
dataReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
}
EndMonth.Add(January);
EndMonth.Add(February);
EndMonth.Add(March);
EndMonth.Add(April);
EndMonth.Add(May);
EndMonth.Add(June);
EndMonth.Add(July);
EndMonth.Add(August);
EndMonth.Add(September);
EndMonth.Add(Oktober);
EndMonth.Add(November);
EndMonth.Add(December);
for (int i = 1; i < 13; i++)
{
var temp = new DateTime(2017, i, 1, 00, 00, 00);
StartMonth.Add(temp);
}
ds = dataReader.AsDataSet();
dataReader.Close();
}