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