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")); } }