public async Task <IActionResult> EditDestino(Destinos Destinos)
{
try
{
var destinos = _dataContext.Destinos.FirstOrDefault(x => x.Codigo == Destinos.Codigo);
if (destinos != null)
{
destinos.DestinoName = Destinos.DestinoName;
await _dataContext.SaveChangesAsync();
return(Ok(new
{
Data = new
{
destinos.ID,
destinos.Codigo,
destinos.DestinoName
},
Success = true
}));
}
else
{
return(BadRequest(new { Data = "El registro no existe", Success = false }));
}
}
catch (Exception ex)
{
return(BadRequest(new { Data = ex.ToString(), Success = false }));
}
}
public async Task <ActionResult> Create(Paqueterias paqueterias, FormCollection fc)
{
if (ModelState.IsValid)
{
string[] ids = fc.Get("Destinos").Trim().Split(',').ToArray();
//string numero = fc["Destinos"];
foreach (var item in ids)
{
Debug.WriteLine("------->" + item);
int d1 = Convert.ToInt32(item);
Destinos n = await db.Destinos.FindAsync(d1);
paqueterias.des.Add(n);
}
paqueterias.Activo = true;
db.Paqueterias.Add(paqueterias);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.Id = new SelectList(db.Paquete, "PaqueteriasId", "PaqueteriasId", paqueterias.Id);
ViewBag.Id = new SelectList(db.Telefonos, "PaqueteriasId", "PaqueteriasId", paqueterias.Id);
ViewBag.Id = new SelectList(db.Correos, "PaqueteriasId", "PaqueteriasId", paqueterias.Id);
return(View(paqueterias));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Destinos destinos = await db.Destinos.FindAsync(id);
db.Destinos.Remove(destinos);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <List <Destinos> > getVuelosByDestination(Destinos destinos)//hay que cambiarlo a vuelos
{
var content = await _httpClient.PostAsync($"/api/Destinations/FindFlightsByDestinations", new StringContent(JsonConvert.SerializeObject(destinos)));
content.EnsureSuccessStatusCode();
var response = await content.Content.ReadAsStringAsync();
return(JsonConvert.DeserializeObject <List <Destinos> >(response));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,Region")] Destinos destinos)
{
if (ModelState.IsValid)
{
db.Entry(destinos).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(destinos));
}
public async Task <ActionResult> Create([Bind(Include = "Id,Region")] Destinos destinos)
{
if (ModelState.IsValid)
{
db.Destinos.Add(destinos);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(destinos));
}
public async Task <IActionResult> CreatePuerto(Destinos Destino)
{
try
{
Destinos D = await Create(Destino);
return(Ok(new { Data = D, Success = true }));
}
catch (Exception ex)
{
return(BadRequest(new { Data = ex.ToString(), Success = false }));
}
}
// GET: Destinos/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Destinos destinos = await db.Destinos.FindAsync(id);
if (destinos == null)
{
return(HttpNotFound());
}
return(View(destinos));
}
public async Task <Destinos> Create(Destinos Destino)
{
if (!this.ExistDestino(Destino.Codigo))
{
_dataContext.Destinos.Add(Destino);
}
else
{
return(_dataContext.Destinos.FirstOrDefault(x => x.Codigo == Destino.Codigo));
}
await _dataContext.SaveChangesAsync();
return(Destino);
}
//Select para destinos, combo
public List <Destinos> ObtenerDestinos()
{
List <Destinos> lista = new List <Destinos>();
SqlConnection conex = new SqlConnection("Data Source=138.99.7.66;Initial Catalog=TUP_VUELOS;User ID=tup_final;Password=@tup_prog3");
try
{
SqlCommand comand = new SqlCommand();
string SQL = "SELECT * FROM Destinos ";
comand.Parameters.Clear();
comand.CommandType = System.Data.CommandType.Text;
comand.CommandText = SQL;
conex.Open();
comand.Connection = conex;
SqlDataReader dr = comand.ExecuteReader();
if (dr != null)
{
while (dr.Read())
{
Destinos d = new Destinos();
d.IdDestino = int.Parse(dr["Id"].ToString());
d.Nombre = dr["Nombre"].ToString();
lista.Add(d);
}
}
}
catch (Exception)
{
throw;
}
finally
{
conex.Close();
}
return(lista);
}
public async Task <List <Destinos> > getByDestination([FromBody] Destinos destinos)//debe retornar vuelos
{
return(await _destinos.getVuelosByDestination(destinos));
}
public async Task <string> CreateMasivo(List <CreatePomas> Pomas)
{
ExportadorController exportadorController = new ExportadorController(_dataContext);
PuertoController puertoController = new PuertoController(_dataContext);
BuqueController buqueController = new BuqueController(_dataContext);
DestinoController destinoController = new DestinoController(_dataContext);
FrutasController frutasController = new FrutasController(_dataContext);
FincaController fincaController = new FincaController(_dataContext);
PaletController paletController = new PaletController(_dataContext);
List <Vehiculos> ListPoma = new List <Vehiculos>();
foreach (var Poma in Pomas)
{
try
{
Vehiculos Vehiculo = new Vehiculos();
Vehiculos V = new Vehiculos();
V.Placa = Poma.Placa;
Vehiculo = await this.Create(V);
Fincas Finca = new Fincas();
Fincas F = new Fincas();
F.Codigo = Poma.Finca.Codigo;
F.FincaName = Poma.Finca.FincaName;
Finca = await fincaController.Create(F);
Puertos Puerto = new Puertos();
Puertos PU = new Puertos();
PU.Codigo = Poma.Puerto.Codigo;
PU.PuertoName = Poma.Puerto.PuertoName;
Puerto = await puertoController.Create(PU);
Destinos Destino = new Destinos();
Destinos D = new Destinos();
D.Codigo = Poma.Destino.Codigo;
D.DestinoName = Poma.Destino.DestinoName;
Destino = await destinoController.Create(D);
Buques Buque = new Buques();
Buques B = new Buques();
B.Codigo = Poma.Buque.Codigo;
B.BuqueName = Poma.Buque.BuqueName;
Buque = await buqueController.Create(B);
Exportadores Exportador = new Exportadores();
Exportadores E = new Exportadores();
E.Codigo = Poma.Exportador.Codigo;
E.ExportadorName = Poma.Exportador.ExportadorName;
Exportador = await exportadorController.Create(E);
TransportGuide TransportGuide = new TransportGuide();
TransportGuide.Vehiculo = Vehiculo;
TransportGuide.Numero = Poma.Numero;
TransportGuide.Estado = (int)EstadosPoma.NoChequeado;
TransportGuide.FechaRegistro = DateTime.UtcNow;
TransportGuide.Recibido = false;
TransportGuide.LlegadaCamion = Poma.LlegadaCamion.ToUniversalTime();
TransportGuide.SalidaFinca = Poma.SalidaFinca.ToUniversalTime();
TransportGuide.Estimado = Poma.Estimado.ToUniversalTime();
TransportGuide.LlegadaTerminal = null;
TransportGuide.Finca = Finca;
TransportGuide.Puerto = Puerto;
TransportGuide.Buque = Buque;
TransportGuide.Destino = Destino;
TransportGuide.Exportador = Exportador;
bool EditTG = false;
TransportGuide valTG = this.ExistTransportGuide(Poma.Numero);
if (valTG == null)
{
_dataContext.TransportGuides.Add(TransportGuide);
await _dataContext.SaveChangesAsync();
}
else
{
var currentDate = DateTime.UtcNow.ToLocalTime();
var StartDate = new DateTime(currentDate.Year, currentDate.Month, currentDate.Day, 3, 0, 0);
var EndDate = StartDate.AddDays(1);
EndDate = new DateTime(EndDate.Year, EndDate.Month, EndDate.Day, 2, 59, 0);
if (currentDate < StartDate)
{
StartDate = StartDate.AddDays(-1);
EndDate = EndDate.AddDays(-1);
}
if ((valTG.FechaRegistro >= StartDate && valTG.FechaRegistro <= EndDate) && valTG.Estado == 0)
{
EditTG = true;
}
else
{
return("La poma ya existe");
}
}
foreach (var detail in Poma.DetailPoma)
{
Frutas Fruta = new Frutas();
Frutas FR = new Frutas();
FR.Codigo = detail.Frutas.Codigo;
FR.FrutaName = detail.Frutas.FrutaName;
Fruta = await frutasController.Create(FR);
DetailTransportGuide valDTG = null;
DetailTransportGuide DetailTG = new DetailTransportGuide();
DetailTG.Fruta = Fruta;
if (EditTG)
{
valDTG = this.ExistDetailTransportGuide(valTG.ID, Fruta.ID);
if (valDTG == null)
{
DetailTG.TransportGuide = valTG;
_dataContext.DetailTransportGuide.Add(DetailTG);
await _dataContext.SaveChangesAsync();
}
}
else
{
DetailTG.TransportGuide = TransportGuide;
_dataContext.DetailTransportGuide.Add(DetailTG);
await _dataContext.SaveChangesAsync();
}
foreach (var palet in detail.Palets)
{
Pallets Palet = new Pallets();
Palet.CodigoPalet = palet.CodigoPalet;
Palet.UsuarioLectura = "";
Palet.LecturaPalet = DateTime.UtcNow;
Palet.UsuarioInspeccion = "";
Palet.InspeccionPalet = DateTime.UtcNow;
Palet.CaraPalet = palet.CaraPalet;
Palet.NumeroCajas = palet.NumeroCajas;
Palet.Carga = palet.Carga;
Palet.Tipo = palet.Tipo;
Palet.Perfilar = false;
if (EditTG)
{
if (valDTG == null)
{
Palet.DetailTransportGuide = DetailTG;
}
else
{
Palet.DetailTransportGuide = valDTG;
}
}
else
{
Palet.DetailTransportGuide = DetailTG;
}
_dataContext.Palets.Add(Palet);
}
}
}
catch (Exception ex)
{
continue;
}
}
await _dataContext.SaveChangesAsync();
try
{
await _NotificationHubContext.Clients.All.BroadcastMessage(Get());
}
catch (Exception ex)
{
return(ex.Message);
}
return("Ejecutado correctamente");
}
