public async Task <IActionResult> Edit(Guid id, [Bind("Id,Description,Quantity,Points,Period,SelectedVerificationType")] CreateActivityRequests createActivityRequests)
{
if (id != createActivityRequests.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(createActivityRequests);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CreateActivityRequestsExists(createActivityRequests.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(createActivityRequests));
}
public async Task <IActionResult> Create([Bind("Id,Description,Quantity,Points,Period,SelectedVerificationType")] CreateActivityRequests createActivityRequests)
{
if (ModelState.IsValid)
{
createActivityRequests.Id = Guid.NewGuid();
_context.Add(createActivityRequests);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(createActivityRequests));
}
public async Task <JsonResult> UploadFile(IFormFile file)
{
try
{
var filePath = Path.GetTempFileName();
IList <string> erros = new List <string>();
if (file.Length > 0)
{
using (var stream = new FileStream(filePath, FileMode.Create))
{
await file.CopyToAsync(stream);
try
{
var activities = new List <CreateActivityRequests>();
using (ExcelPackage xlPackage = new ExcelPackage(stream))
{
var myWorksheet = xlPackage.Workbook.Worksheets.First();
var totalRows = myWorksheet.Dimension.End.Row;
var totalColumns = myWorksheet.Dimension.End.Column;
var sb = new StringBuilder();
for (int rowNum = 1; rowNum <= totalRows; rowNum++)
{
var row = myWorksheet.Cells[rowNum, 1, rowNum, totalColumns].Select(c => c.Value == null ? string.Empty : c.Value.ToString());
if (row.Count() > 0 && !string.IsNullOrEmpty(row.ToList()[0]))
{
var request = new CreateActivityRequests();
request.Description = row.ToList()[0];
request.Quantity = Convert.ToInt32(row.ToList()[1]);
request.Points = Convert.ToInt32(row.ToList()[2]);
request.Period = Convert.ToInt32(row.ToList()[3]);
activities.Add(request);
}
}
foreach (var activity in activities)
{
//Chama o service da atividade para salvar o registro
}
}
}
catch (Exception ex)
{
throw ex;
}
}
}
//if (_serviceCity.Notifications.Any())
//{
// foreach (var notification in _serviceCity.Notifications)
// {
// erros.Add(notification.Message);
// }
//}
return(Json(erros));
}
catch (Exception ex)
{
ViewBag.Message = "File upload failed!!";
return(Json("Erro"));
}
}
