public IActionResult SalvarRodovia(RodoviaViewsModels rodoviaViewsModels)
{
var _rodovia = new Rodovia();
_rodovia.RodoviaId = rodoviaViewsModels.RodoviaId;
_rodovia.NomeRodovia = rodoviaViewsModels.NomeRodovia;
if (!String.IsNullOrEmpty(rodoviaViewsModels.NomeRodovia))
{
if (rodoviaViewsModels.RodoviaId == 0)
{
_rodoviaRepository.SalvarRodovia(_rodovia);
ViewBag.Aviso = "Cadastrado com Sucesso!! ";
}
else
{
_rodoviaRepository.EditarRodovia(_rodovia);
ViewBag.Aviso = "Alterdo com Sucesso!! ";
}
}
return(View(rodoviaViewsModels));
}
public List <RodoviasTarifas> LerExcelRodovia(ArquivosImportados arquivosImportados, Rodovia rodovia)
{
List <RodoviasTarifas> listaRodoviasTarifas = new List <RodoviasTarifas>();
FileInfo file = new FileInfo(Path.Combine(arquivosImportados.PastaImportacao, arquivosImportados.NomeGerado));
using (ExcelPackage package = new ExcelPackage(file))
{
ExcelWorksheet workSheet = package.Workbook.Worksheets[rodovia.NomeRodovia];
int totalRows = workSheet.Dimension.Rows;
int contRows = GetLastUsedRow(workSheet);
for (int i = 2; i <= contRows; i++)
{
if (!String.IsNullOrEmpty(workSheet.Cells[i, 1].Value.ToString()))
{
RodoviasTarifas rodoviasTarifas = new RodoviasTarifas();
rodoviasTarifas.AssociateCompKNownName = workSheet.Cells[i, 1].Value.ToString();;
rodoviasTarifas.Praca = workSheet.Cells[i, 2].Value.ToString();;
rodoviasTarifas.VehicleClassId = workSheet.Cells[i, 3].Value.ToString();;
rodoviasTarifas.Name = workSheet.Cells[i, 4].Value.ToString();
rodoviasTarifas.DateHourProgramStart = workSheet.Cells[i, 5].Value.ToString();
rodoviasTarifas.Value = workSheet.Cells[i, 6].Value.ToString();
rodoviasTarifas.RodoviaId = rodovia.RodoviaId;
listaRodoviasTarifas.Add(rodoviasTarifas);
}
}
}
return(listaRodoviasTarifas);
}
public void SalvarRodovia(Rodovia rodovia)
{
_context.Rodovias.Add(rodovia);
_context.SaveChangesAsync();
}
public void EditarRodovia(Rodovia rodovia)
{
_context.Rodovias.Update(rodovia);
_context.SaveChangesAsync();
}
