public Search()
{
string path = HostingEnvironment.ApplicationPhysicalPath + currentFile.GetCurrentFile().Path3;
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);
}
var conf = new ExcelDataSetConfiguration
{
ConfigureDataTable = _ => new ExcelDataTableConfiguration
{
UseHeaderRow = true
}
};
ds = dataReader.AsDataSet(conf);
dataReader.Close();
stream.Close();
}
public PartialViewResult GetCurrentFiles()
{
CurrentFile cur = current.GetCurrentFile();
string[] list = { cur.Path1.Split('/')[cur.Path1.Split('/').Length - 1], cur.Path2.Split('/')[cur.Path2.Split('/').Length - 1], cur.Path3.Split('/')[cur.Path3.Split('/').Length - 1] };
return(PartialView(list));
}
public DesignCities()
{
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);
string path = HostingEnvironment.ApplicationPhysicalPath + currentFile.GetCurrentFile().Path3;
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);
}
var conf = new ExcelDataSetConfiguration
{
ConfigureDataTable = _ => new ExcelDataTableConfiguration
{
UseHeaderRow = true
}
};
for (int i = 1; i < 13; i++)
{
var temp = new DateTime(2017, i, 1, 00, 00, 00);
StartMonth.Add(temp);
}
ds = dataReader.AsDataSet(conf);
dataReader.Close();
DataRow[] foundRows;
foundRows = ds.Tables[0].Select();
for (int jе = 0; jе < foundRows.Length; jе++)
{
Cities.Add(ds.Tables[0].Rows[jе].ItemArray[8].ToString().TrimEnd(' '));
}
Cities = Cities.Distinct().ToList();
}
public LetterChart2()
{
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);
string path = HostingEnvironment.ApplicationPhysicalPath + currentFile.GetCurrentFile().Path2;
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);
}
var conf = new ExcelDataSetConfiguration
{
ConfigureDataTable = _ => new ExcelDataTableConfiguration
{
UseHeaderRow = true
}
};
for (int i = 1; i < 13; i++)
{
var temp = new DateTime(2017, i, 1, 00, 00, 00);
StartMonth.Add(temp);
}
ds = dataReader.AsDataSet(conf);
stream.Close();
stream.Dispose();
dataReader.Close();
}
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();
}
public ReasonsChart()
{
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);
}
ds = dataReader.AsDataSet();
dataReader.Close();
}