public IActionResult submitDataNote(string[] note, string[] path, string[] filename, string[] fundcode, string usersub)
{
Console.WriteLine("************* POST DATA **************");
List <FileDirModel> dataFile = new List <FileDirModel>();
for (int i = 0; i < path.Length; i++)
{
FileDirModel map = new FileDirModel();
map.path = path[i];
map.fileName = filename[i];
map.fundcode = fundcode[i];
map.note = note[i];
dataFile.Add(map);
}
try {
using (var package = new ExcelPackage())
{
Debug.WriteLine(" dataFile :" + dataFile.Count);
Debug.WriteLine(" fund :" + fund.Count);
var workbook = package.Workbook;
foreach (fundcode fc in getFund())
{
createExcel(package, dataFile, fc.fundecode);
}
DateTime currDate = DateTime.Now;
string dateNow = currDate.Year + "-" + currDate.Month + "-" + currDate.Day;
FileInfo newFile = new FileInfo(@"\\192.168.96.7\Datawarehouse\Report\Upload_Wait_Report_" + dateNow + "___" + usersub + ".xlsx");
file_name = "Upload_Wait_Report_" + dateNow + "___" + usersub + ".xlsx";
ViewBag.file_name = file_name;
package.SaveAs(newFile);
}
return(RedirectToAction("Index", "Home", new { name = file_name }));
} catch (Exception ex) {
return(RedirectToAction("Index", "Home", new { name = ex }));
}
//file_name = "Upload Wait Report.xlsx";
}
public List <FileDirModel> GetDirInWait(DirectoryInfo rootDir, string fundcode)
{
DirectoryInfo[] sub2 = rootDir.GetDirectories("*.*");
if (sub2.Length > 0)
{
foreach (DirectoryInfo sb2 in sub2)
{
// Debug.WriteLine("==================" + sb2.FullName+"===============" );
DirectoryInfo[] sub3 = sb2.GetDirectories("*.*");
if (sub3.Length > 0)
{
FileInfo[] getFileW = sb2.GetFiles("*.*");
int i = 0;
foreach (FileInfo files2 in getFileW)
{
FileDirModel mapping = new FileDirModel();
if (i == 0)
{
mapping.path = sb2.FullName;
mapping.fileName = files2.Name;
mapping.fundcode = fundcode;
}
else
{
mapping.path = "";
mapping.fileName = files2.Name;
mapping.fundcode = fundcode;
}
i++;
// Debug.WriteLine("************************* " + files2.Name);
ListFile.Add(mapping);
}
GetDirInWait(sb2, fundcode);
}
else
{
FileInfo[] getFileW = sb2.GetFiles("*.*");
int i = 0;
foreach (FileInfo files2 in getFileW)
{
FileDirModel mapping = new FileDirModel();
//Debug.WriteLine("************************* " + files2.Name);
if (i == 0)
{
mapping.path = sb2.FullName;
mapping.fileName = files2.Name;
mapping.fundcode = fundcode;
}
else
{
mapping.path = "";
mapping.fileName = files2.Name;
mapping.fundcode = fundcode;
}
i++;
ListFile.Add(mapping);
}
}
}
}
else
{
FileDirModel mapping = new FileDirModel();
FileInfo[] getFileW = rootDir.GetFiles("*.*");
int i = 0;
foreach (FileInfo files2 in getFileW)
{
if (i == 0)
{
mapping.path = rootDir.FullName;
mapping.fileName = files2.Name;
mapping.fundcode = fundcode;
}
else
{
mapping.path = " ";
mapping.fileName = files2.Name;
mapping.fundcode = fundcode;
}
// Debug.WriteLine("************************* " + files2.Name);
i++;
}
ListFile.Add(mapping);
}
return(ListFile);
}
public IActionResult Index(string name)
{
ViewBag.title = "Datawarehouse";
string filePath = @"//192.168.96.7/Datawarehouse/";
Debug.WriteLine("Path : " + filePath);
DirectoryInfo dirInfo = new DirectoryInfo(filePath);
DirectoryInfo rootdir = dirInfo.Root;
DirectoryInfo[] dirInfos = rootdir.GetDirectories("*.*");
Debug.WriteLine("***************** Directory **************");
foreach (DirectoryInfo d in dirInfos)
{
if (d.Name.Length < 6)
{
//Debug.WriteLine("Direc Name : " + d.Name);
DirectoryInfo[] subDir = d.GetDirectories("*.*");
foreach (DirectoryInfo sb in subDir)
{
if (sb.Name == "Wait" || sb.Name == "wait")
{
// Debug.WriteLine("---------------- " + sb.Name);
fundcode fc = new fundcode();
fc.fundecode = d.Name;
fund.Add(fc);
DirectoryInfo[] sub2 = sb.GetDirectories("*.*");
if (sub2.Length > 0)
{
GetDirInWait(sb, d.Name);
}
else
{
FileInfo[] getFileW = sb.GetFiles("*.*");
int i = 0;
foreach (FileInfo files2 in getFileW)
{
FileDirModel map = new FileDirModel();
if (i == 0)
{
map.path = sb.FullName;
map.fileName = files2.Name;
map.fundcode = d.Name;
}
else
{
map.path = "";
map.fileName = files2.Name;
map.fundcode = d.Name;
}
i++;
ListFile.Add(map);
//Debug.WriteLine("************************* " + files2.Name);
}
}
}
}
}
}
file_name = name;
ViewBag.file_name = file_name;
ViewBag.fund = fund;
ViewBag.listfile = ListFile;
return(View());
}
