public async Task Guardar(ExemploViewModel obj) { var anoLectivo = _mapper.Map <Exemplo>(obj); await _exemploServico.Guardar(anoLectivo); if (!await _uow.Commit()) { await _uow.Rollback(); } }
public async void Remover(ExemploViewModel obj) { var anoLectivo = _mapper.Map <Exemplo>(obj); _exemploServico.Remover(anoLectivo); if (!await _uow.Commit()) { await _uow.Rollback(); } }
public ActionResult ExportarExcel2(ExemploListViewModel model) { var relatorio = _exemploRepository.ObterPorFiltro(model.Filtro); ExcelPackage excel = new ExcelPackage(); var workSheet = excel.Workbook.Worksheets.Add("Relatório Teste"); workSheet.TabColor = System.Drawing.Color.Black; workSheet.DefaultRowHeight = 12; var exModel = new ExemploViewModel(); //Header of table workSheet.Row(1).Height = 20; workSheet.Row(1).Style.HorizontalAlignment = ExcelHorizontalAlignment.Center; workSheet.Row(1).Style.Font.Bold = true; workSheet.Cells[1, 1].Value = exModel.DisplayNameFor(x => x.EXEMPLO_ID); workSheet.Cells[1, 2].Value = exModel.DisplayNameFor(x => x.NOME); workSheet.Cells[1, 3].Value = exModel.DisplayNameFor(x => x.DESCRICAO); workSheet.Cells[1, 4].Value = exModel.DisplayNameFor(x => x.ATIVO); //Size columns workSheet.Column(1).Width = 10; workSheet.Column(2).Width = 30; workSheet.Column(3).Width = 50; workSheet.Column(4).Width = 10; //Body of table int recordIndex = 2; foreach (var item in relatorio) { workSheet.Cells[recordIndex, 1].Value = item.EXEMPLO_ID; workSheet.Cells[recordIndex, 2].Value = item.NOME; workSheet.Cells[recordIndex, 3].Value = item.DESCRICAO; workSheet.Cells[recordIndex, 4].Value = (item.ATIVO) ? "Ativo" : "Inativo"; recordIndex++; } string excelName = string.Format("Relatório Teste {0}.xlsx", DateTime.Now.ToString("dd-MM-yyyy-HH-mm")); byte[] filecontent = excel.GetAsByteArray(); return(File(filecontent, MediaTypeNames.Application.Octet, excelName)); }
public ActionResult Create() { var model = new ExemploViewModel(); return(PartialView("_Create", model)); }