public async Task <IActionResult> Edit(int id, [Bind("Id,LakeId,Hylak_id,Lake_name_ENG,Lake_name_RU,Lake_name_KZ,Country_ENG,Country_RU,Country_KZ,Continent_ENG,Continent_RU,Continent_KZ,Lake_area,Shore_len,Shore_dev,Vol_total,Depth_avg,Dis_avg,Res_time,Elevation,Slope_100,Wshd_area,Pour_long,Pour_lat")] LakesGlobalData lakesGlobalData)
{
if (id != lakesGlobalData.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(lakesGlobalData);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LakesGlobalDataExists(lakesGlobalData.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(lakesGlobalData));
}
public async Task <IActionResult> Create([Bind("Id,LakeId,Hylak_id,Lake_name_ENG,Lake_name_RU,Lake_name_KZ,Country_ENG,Country_RU,Country_KZ,Continent_ENG,Continent_RU,Continent_KZ,Lake_area,Shore_len,Shore_dev,Vol_total,Depth_avg,Dis_avg,Res_time,Elevation,Slope_100,Wshd_area,Pour_long,Pour_lat")] LakesGlobalData lakesGlobalData)
{
if (ModelState.IsValid)
{
_context.Add(lakesGlobalData);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(lakesGlobalData));
}
public async Task <IActionResult> Upload(bool FirstRowHeader, IFormFile File)
{
try
{
string sContentRootPath = _hostingEnvironment.WebRootPath;
sContentRootPath = Path.Combine(sContentRootPath, "Uploads");
DirectoryInfo di = new DirectoryInfo(sContentRootPath);
foreach (FileInfo filed in di.GetFiles())
{
try
{
filed.Delete();
}
catch
{
}
}
string path_filename = Path.Combine(sContentRootPath, Path.GetFileName(File.FileName));
using (var stream = new FileStream(Path.GetFullPath(path_filename), FileMode.Create))
{
await File.CopyToAsync(stream);
}
FileInfo fileinfo = new FileInfo(Path.Combine(sContentRootPath, Path.GetFileName(path_filename)));
using (ExcelPackage package = new ExcelPackage(fileinfo))
{
int start_row = 1;
if (FirstRowHeader)
{
start_row++;
}
List <LakesGlobalData> lakesGlobalDatas = new List <LakesGlobalData>();
for (int i = start_row; ; i++)
{
if (package.Workbook.Worksheets.FirstOrDefault().Cells[i, 1].Value == null)
{
break;
}
LakesGlobalData lakesGlobalData = new LakesGlobalData();
try
{
lakesGlobalData.LakeId = Convert.ToInt32(package.Workbook.Worksheets.FirstOrDefault().Cells[i, 1].Value);
lakesGlobalData.Hylak_id = Convert.ToInt32(package.Workbook.Worksheets.FirstOrDefault().Cells[i, 2].Value);
lakesGlobalData.Lake_name_ENG = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 3].Value?.ToString();
lakesGlobalData.Lake_name_RU = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 4].Value?.ToString();
lakesGlobalData.Lake_name_KZ = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 5].Value?.ToString();
lakesGlobalData.Country_ENG = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 6].Value?.ToString();
lakesGlobalData.Country_RU = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 7].Value?.ToString();
lakesGlobalData.Country_KZ = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 8].Value?.ToString();
lakesGlobalData.Continent_ENG = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 9].Value?.ToString();
lakesGlobalData.Continent_RU = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 10].Value?.ToString();
lakesGlobalData.Continent_KZ = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 11].Value?.ToString();
lakesGlobalData.Lake_area = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 12].Value == null ?
(int?)null :
Convert.ToInt32(package.Workbook.Worksheets.FirstOrDefault().Cells[i, 12].Value);
lakesGlobalData.Shore_len = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 13].Value == null ?
(int?)null :
Convert.ToInt32(package.Workbook.Worksheets.FirstOrDefault().Cells[i, 13].Value);
lakesGlobalData.Shore_dev = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 14].Value == null ?
(int?)null :
Convert.ToInt32(package.Workbook.Worksheets.FirstOrDefault().Cells[i, 14].Value);
lakesGlobalData.Vol_total = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 15].Value == null ?
(int?)null :
Convert.ToInt32(package.Workbook.Worksheets.FirstOrDefault().Cells[i, 15].Value);
lakesGlobalData.Depth_avg = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 16].Value == null ?
(int?)null :
Convert.ToInt32(package.Workbook.Worksheets.FirstOrDefault().Cells[i, 16].Value);
lakesGlobalData.Dis_avg = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 17].Value == null ?
(int?)null :
Convert.ToInt32(package.Workbook.Worksheets.FirstOrDefault().Cells[i, 17].Value);
lakesGlobalData.Res_time = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 18].Value == null ?
(int?)null :
Convert.ToInt32(package.Workbook.Worksheets.FirstOrDefault().Cells[i, 18].Value);
lakesGlobalData.Elevation = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 19].Value == null ?
(int?)null :
Convert.ToInt32(package.Workbook.Worksheets.FirstOrDefault().Cells[i, 19].Value);
lakesGlobalData.Slope_100 = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 20].Value == null ?
(int?)null :
Convert.ToInt32(package.Workbook.Worksheets.FirstOrDefault().Cells[i, 20].Value);
lakesGlobalData.Wshd_area = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 21].Value == null ?
(int?)null :
Convert.ToInt32(package.Workbook.Worksheets.FirstOrDefault().Cells[i, 21].Value);
lakesGlobalData.Pour_long = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 22].Value == null ?
(int?)null :
Convert.ToInt32(package.Workbook.Worksheets.FirstOrDefault().Cells[i, 22].Value);
lakesGlobalData.Pour_lat = package.Workbook.Worksheets.FirstOrDefault().Cells[i, 23].Value == null ?
(int?)null :
Convert.ToInt32(package.Workbook.Worksheets.FirstOrDefault().Cells[i, 23].Value);
}
catch (Exception e)
{
ViewBag.Error = $"{_sharedLocalizer["Row"]} {i.ToString()}: " + e.Message + (e.InnerException == null ? "" : ": " + e.InnerException.Message);
break;
}
lakesGlobalDatas.Add(lakesGlobalData);
_context.Add(lakesGlobalDatas.LastOrDefault());
}
if (string.IsNullOrEmpty(ViewBag.Error))
{
_context.SaveChanges();
ViewBag.Report = $"{_sharedLocalizer["UploadedCount"]}: {lakesGlobalDatas.Count()}";
}
}
foreach (FileInfo filed in di.GetFiles())
{
try
{
filed.Delete();
}
catch
{
}
}
}
catch (Exception e)
{
if (File != null)
{
ViewBag.Error = e.Message + (e.InnerException == null ? "" : ": " + e.InnerException.Message);
}
}
return(View());
}
