public async Task <IActionResult> Put(AssistenciasPRM assistencia)
{
_db.Entry(assistencia).State = EntityState.Modified;
await _db.SaveChangesAsync();
return(Ok(assistencia));
}
public async Task <IActionResult> Post(AssistenciasPRM assistencia)
{
_db.Add(assistencia);
await _db.SaveChangesAsync();
return(Ok(assistencia));
}
public async Task <IActionResult> Delete(Guid id)
{
var assistencia = new AssistenciasPRM {
ID = id
};
_db.Remove(assistencia);
await _db.SaveChangesAsync();
return(NoContent());
}
public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
AssistenciasPRM = await _context.AssistenciasPRMS.FirstOrDefaultAsync(m => m.ID == id);
if (AssistenciasPRM == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
AssistenciasPRM = await _context.AssistenciasPRMS.FindAsync(id);
if (AssistenciasPRM != null)
{
_context.AssistenciasPRMS.Remove(AssistenciasPRM);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
private void AddExcelToDB(IExcelDataReader excelReader)
{
DataTable excelTable = excelReader.AsDataSet().Tables[0];
for (int i = 1; i < excelTable.Rows.Count; i++)
{
string aeroporto = (string)excelTable.Rows[i].ItemArray[0];
string msg = (string)excelTable.Rows[i].ItemArray[1];
string notif = (string)excelTable.Rows[i].ItemArray[2];
DateTime data = (DateTime)excelTable.Rows[i].ItemArray[3];
string voo = (string)excelTable.Rows[i].ItemArray[4];
string mov = (string)excelTable.Rows[i].ItemArray[5];
string origDest = (string)excelTable.Rows[i].ItemArray[6];
string pax = (string)excelTable.Rows[i].ItemArray[7];
string ssr = (string)excelTable.Rows[i].ItemArray[8];
string ac = (string)excelTable.Rows[i].ItemArray[9];
string stand = (string)excelTable.Rows[i].ItemArray[10];
if (string.IsNullOrEmpty(stand))
{
stand = "000";
}
string exit = (string)excelTable.Rows[i].ItemArray[11];
string ckin = (string)excelTable.Rows[i].ItemArray[12];
string gate = (string)excelTable.Rows[i].ItemArray[13];
string transferencia = (string)excelTable.Rows[i].ItemArray[14];
DateTime horaEmbarque = data.AddMinutes(-BrdTime(gate));
DateTime saidaStaging = data.AddMinutes(-StagingTime(gate));
DateTime estimaApresentacao = data.AddMinutes(-EstimaTime(gate));
AssistenciasPRM currentExcel = new AssistenciasPRM
{
Aeroporto = aeroporto,
Msg = msg,
Notif = notif,
Data = data,
Voo = voo,
Mov = mov,
OrigDest = origDest,
Pax = pax,
SSR = ssr,
AC = ac,
Stand = stand,
Exit = exit,
CkIn = ckin,
Gate = gate,
Transferencia = transferencia,
HoraEmbarque = horaEmbarque,
SaidaStaging = saidaStaging,
EstimaApresentacao = estimaApresentacao
};
int current = db.AssistenciasPRMS.Where(d => d.Data.Date.Day == data.Date.Day).Count();
if (current > 0)
{
db.AssistenciasPRMS.RemoveRange(db.AssistenciasPRMS.Where(d => d.Data.Date == data.Date));
db.AssistenciasPRMS.Add(currentExcel);
}
else
{
db.AssistenciasPRMS.Add(currentExcel);
}
}
db.SaveChanges();
}
private async Task AddAssistenciasPRM(DataTable excelTable)
{
for (int i = 0; i < excelTable.Rows.Count; i++)
{
string aeroporto = (string)excelTable.Rows[i].ItemArray[0];
string msg = (string)excelTable.Rows[i].ItemArray[1];
string notif = (string)excelTable.Rows[i].ItemArray[2];
DateTime data = DateTime.Parse((string)excelTable.Rows[i].ItemArray[3]);
string voo = (string)excelTable.Rows[i].ItemArray[4];
string mov = (string)excelTable.Rows[i].ItemArray[5];
string origDest = (string)excelTable.Rows[i].ItemArray[6];
string pax = (string)excelTable.Rows[i].ItemArray[7];
string ssr = (string)excelTable.Rows[i].ItemArray[8];
string ac = (string)excelTable.Rows[i].ItemArray[9];
string stand = (string)excelTable.Rows[i].ItemArray[10];
if (string.IsNullOrEmpty(stand))
{
stand = "000";
}
string exit = (string)excelTable.Rows[i].ItemArray[11];
string ckin = (string)excelTable.Rows[i].ItemArray[12];
string gate = (string)excelTable.Rows[i].ItemArray[13];
string transferencia = (string)excelTable.Rows[i].ItemArray[14];
DateTime horaEmbarque = data.AddMinutes(-BrdTime(gate));
DateTime saidaStaging = data.AddMinutes(-StagingTime(gate));
DateTime estimaApresentacao = data.AddMinutes(-EstimaTime(gate));
AssistenciasPRM currentExcel = new()
{
Aeroporto = aeroporto,
Msg = msg,
Notif = notif,
Data = data,
Voo = voo,
Mov = mov,
OrigDest = origDest,
Pax = pax,
SSR = ssr,
AC = ac,
Stand = stand,
Exit = exit,
CkIn = ckin,
Gate = gate,
Transferencia = transferencia,
HoraEmbarque = horaEmbarque,
SaidaStaging = saidaStaging,
EstimaApresentacao = estimaApresentacao
};
AssistenciasPRM exists = new AssistenciasPRM();
exists = _db.AssistenciasPRMS
.Where(d =>
d.Aeroporto == aeroporto &&
d.Data.Date.Day == data.Date.Day &&
d.Voo == voo &&
d.Mov == mov &&
d.Pax == pax
).FirstOrDefault();
if (exists != null)
{
if (exists.ID != default || exists.ID != Guid.Empty)
{
exists.Aeroporto = currentExcel.Aeroporto;
exists.Msg = currentExcel.Msg;
exists.Notif = currentExcel.Notif;
exists.Data = currentExcel.Data;
exists.Voo = currentExcel.Voo;
exists.Mov = currentExcel.Mov;
exists.OrigDest = currentExcel.OrigDest;
exists.Pax = currentExcel.Pax;
exists.SSR = currentExcel.SSR;
exists.AC = currentExcel.AC;
exists.Stand = currentExcel.Stand;
exists.Exit = currentExcel.Exit;
exists.CkIn = currentExcel.CkIn;
exists.Gate = currentExcel.Gate;
exists.Transferencia = currentExcel.Transferencia;
exists.HoraEmbarque = currentExcel.HoraEmbarque;
exists.SaidaStaging = currentExcel.SaidaStaging;
exists.EstimaApresentacao = currentExcel.EstimaApresentacao;
Updated++;
_db.Entry(exists).State = EntityState.Modified;
}
}
else
{
Inserted++;
_db.Add(currentExcel);
}
}
await _db.SaveChangesAsync();
}
