public async Task <IActionResult> Post(DadosAeroporto dados) { _db.Add(dados); await _db.SaveChangesAsync(); return(Ok(dados)); }
public async Task <IActionResult> Put(DadosAeroporto dados) { _db.Entry(dados).State = EntityState.Modified; await _db.SaveChangesAsync(); return(Ok(dados)); }
private void AddExcelToDB(IExcelDataReader excelReader) { DataTable excelTable = excelReader.AsDataSet().Tables[0]; for (int i = 1; i < excelTable.Rows.Count; i++) { string mov = (string)excelTable.Rows[i].ItemArray[0]; string reg = (string)excelTable.Rows[i].ItemArray[1]; string voo = (string)excelTable.Rows[i].ItemArray[3]; DateTime?estimatedTime = IsItDateNull((string)excelTable.Rows[i].ItemArray[9]); DateTime?scheduleTime = IsItDateNull((string)excelTable.Rows[i].ItemArray[10]); DateTime?actualTime = IsItDateNull((string)excelTable.Rows[i].ItemArray[11]); DateTime?blockTime = IsItDateNull((string)excelTable.Rows[i].ItemArray[13]); DateTime?beginBRD = IsItDateNull((string)excelTable.Rows[i].ItemArray[14]); DateTime?endBRD = IsItDateNull((string)excelTable.Rows[i].ItemArray[15]); DateTime?estimatedTimeUTC = IsItDateNull((string)excelTable.Rows[i].ItemArray[25]); DateTime?scheduleTimeUTC = IsItDateNull((string)excelTable.Rows[i].ItemArray[26]); DateTime?actualTimeUTC = IsItDateNull((string)excelTable.Rows[i].ItemArray[27]); DateTime?blockTimeUTC = IsItDateNull((string)excelTable.Rows[i].ItemArray[28]); DateTime?beginBRDUTC = IsItDateNull((string)excelTable.Rows[i].ItemArray[29]); DateTime?endBRDUTC = IsItDateNull((string)excelTable.Rows[i].ItemArray[30]); DadosAeroporto currentExcel = new DadosAeroporto { Mov = mov, Reg = reg, Voo = voo, EstimatedTime = estimatedTime, ScheduleTime = scheduleTime, ActualTime = actualTime, BlockTime = blockTime, BeginBRD = beginBRD, EndBRD = endBRD, EstimatedTimeUTC = estimatedTimeUTC, ScheduleTimeUTC = scheduleTimeUTC, ActualTimeUTC = actualTimeUTC, BlockTimeUTC = blockTimeUTC, BeginBRDUTC = beginBRDUTC, EndBRDUTC = endBRDUTC }; //db.DadosAeroportos.Add(currentExcel); string regv = currentExcel.Reg; string movv = currentExcel.Mov; DateTime?scheduleTimeUTCv = (DateTime)currentExcel.ScheduleTimeUTC; if (!db.DadosAeroportos.Any(e => e.Reg == regv && e.Mov == movv && e.ScheduleTimeUTC == scheduleTimeUTCv)) { db.DadosAeroportos.Add(currentExcel); } } db.SaveChanges(); }
public async Task <IActionResult> Delete(Guid id) { var dados = new DadosAeroporto { ID = id }; _db.Remove(dados); await _db.SaveChangesAsync(); return(NoContent()); }
private async Task AddAirportData(DataTable excelTable) { for (int i = 0; i < excelTable.Rows.Count; i++) { string mov = (string)excelTable.Rows[i].ItemArray[0]; string reg = (string)excelTable.Rows[i].ItemArray[1]; string voo = (string)excelTable.Rows[i].ItemArray[3]; DateTime estimatedTime = DateTime.Parse((string)excelTable.Rows[i].ItemArray[9]); DateTime scheduleTime = DateTime.Parse((string)excelTable.Rows[i].ItemArray[10]); DateTime actualTime = DateTime.Parse((string)excelTable.Rows[i].ItemArray[11]); DateTime blockTime = DateTime.Parse((string)excelTable.Rows[i].ItemArray[13]); DateTime beginBRD = DateTime.Parse((string)excelTable.Rows[i].ItemArray[14]); DateTime endBRD = DateTime.Parse((string)excelTable.Rows[i].ItemArray[15]); DateTime estimatedTimeUTC = DateTime.Parse((string)excelTable.Rows[i].ItemArray[25]); DateTime scheduleTimeUTC = DateTime.Parse((string)excelTable.Rows[i].ItemArray[26]); DateTime actualTimeUTC = DateTime.Parse((string)excelTable.Rows[i].ItemArray[27]); DateTime blockTimeUTC = DateTime.Parse((string)excelTable.Rows[i].ItemArray[28]); DateTime beginBRDUTC = DateTime.Parse((string)excelTable.Rows[i].ItemArray[29]); DateTime endBRDUTC = DateTime.Parse((string)excelTable.Rows[i].ItemArray[30]); DadosAeroporto currentExcel = new() { Mov = mov, Reg = reg, Voo = voo, EstimatedTime = estimatedTime, ScheduleTime = scheduleTime, ActualTime = actualTime, BlockTime = blockTime, BeginBRD = beginBRD, EndBRD = endBRD, EstimatedTimeUTC = estimatedTimeUTC, ScheduleTimeUTC = scheduleTimeUTC, ActualTimeUTC = actualTimeUTC, BlockTimeUTC = blockTimeUTC, BeginBRDUTC = beginBRDUTC, EndBRDUTC = endBRDUTC }; DadosAeroporto exists = new DadosAeroporto(); exists = _db.DadosAeroportos .Where(d => d.Mov == mov && d.Reg == reg && d.Voo == voo && d.ScheduleTime == scheduleTime && d.ScheduleTimeUTC == scheduleTimeUTC ).FirstOrDefault(); if (exists != null) { if (exists.ID != default || exists.ID != Guid.Empty) { exists.Mov = currentExcel.Mov; exists.Reg = currentExcel.Reg; exists.Voo = currentExcel.Voo; exists.EstimatedTime = currentExcel.EstimatedTime; exists.ScheduleTime = currentExcel.ScheduleTime; exists.ActualTime = currentExcel.ActualTime; exists.BlockTime = currentExcel.BlockTime; exists.BeginBRD = currentExcel.BeginBRD; exists.EndBRD = currentExcel.EndBRD; exists.EstimatedTimeUTC = currentExcel.EstimatedTimeUTC; exists.ScheduleTimeUTC = currentExcel.ScheduleTimeUTC; exists.ActualTimeUTC = currentExcel.ActualTimeUTC; exists.BlockTimeUTC = currentExcel.BlockTimeUTC; exists.BeginBRDUTC = currentExcel.BeginBRDUTC; exists.EndBRDUTC = currentExcel.EndBRDUTC; Updated++; _db.Entry(exists).State = EntityState.Modified; } } else { Inserted++; _db.Add(currentExcel); } } await _db.SaveChangesAsync(); } }