public static Tiquete getTiqueteFromDB(int ID)
{
SqlDataReader reader = null;
SqlConnection connection = new SqlConnection();
connection.ConnectionString = "Data Source=.;Initial Catalog=TECAirlines;Integrated Security=SSPI";
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.Text;
var query = "SELECT * FROM Tiquete WHERE ID='@ID'";
query = query.Replace("@ID", ID.ToString());
sqlCmd.CommandText = query;
sqlCmd.Connection = connection;
connection.Open();
reader = sqlCmd.ExecuteReader();
Tiquete tiquete = null;
while (reader.Read())
{
tiquete = new Tiquete();
tiquete.ID = Convert.ToInt32(reader.GetValue(0));
tiquete.Asiento = Convert.ToInt32(reader.GetValue(1));
}
connection.Close();
return(tiquete);
}
public async Task <IActionResult> PutTiquete(string id, Tiquete tiquete)
{
if (id != tiquete.id)
{
return(BadRequest());
}
_context.Entry(ruta).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TiqueteExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public TiqueteViewModel(Tiquete tiquete)
{
codigo = tiquete.codigo;
ruta = tiquete.ruta;
valor = tiquete.valor;
idCliente = tiquete.idCliente;
}
public static List <Tiquete> getAllTiquetesFromDB()
{
SqlDataReader reader = null;
SqlConnection connection = new SqlConnection();
connection.ConnectionString = "Data Source=.;Initial Catalog=TECAirlines;Integrated Security=SSPI";
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.Text;
var query = "SELECT * FROM Tiquete ";
sqlCmd.CommandText = query;
sqlCmd.Connection = connection;
connection.Open();
reader = sqlCmd.ExecuteReader();
List <Tiquete> listaTiquetes = new List <Tiquete>();
while (reader.Read())
{
Tiquete tiquete = null;
tiquete = new Tiquete();
tiquete.ID = Convert.ToInt32(reader.GetValue(0));
tiquete.Asiento = Convert.ToInt32(reader.GetValue(1));
listaTiquetes.Add(tiquete);
}
connection.Close();
return(listaTiquetes);
}
public static bool addTiqueteToDB(Tiquete tiquete)
{
var connectionString = "Data Source=.;Initial Catalog=TECAirlines;Integrated Security=SSPI";
var query = "INSERT INTO Tiquete (ID, Asiento) VALUES ('@ID', '@Asiento')";
query = query.Replace("@ID", tiquete.ID.ToString())
.Replace("@Asiento", tiquete.Asiento.ToString());
SqlConnection connection = new SqlConnection(connectionString);
try
{
connection.Open();
SqlCommand command = new SqlCommand(query, connection);
command.ExecuteNonQuery();
command.Dispose();
connection.Close();
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult Delete2Confirmed(string id)
{
Tiquete tiquete = db.Tiquete.Find(id);
db.Tiquete.Remove(tiquete);
db.SaveChanges();
return(RedirectToAction("Index2"));
}
public bool Post(Tiquete Tiquete)
{
if (Tiquete != null)
{
return(TiqueteRepository.addTiqueteToDB(Tiquete));
}
else
{
return(false);
}
}
public GuardarTiqueteResponse Guardar(Tiquete tiquete)
{
try {
_conexion.Open();
_repositorio.Guardar(tiquete);
_conexion.Close();
return(new GuardarTiqueteResponse(tiquete));
} catch (Exception e) {
return(new GuardarTiqueteResponse($"Error de la Aplicacion: {e.Message}"));
} finally { _conexion.Close(); }
}
public ActionResult <TiqueteViewModel> Post(TiqueteInputModel tiqueteInput)
{
Tiquete tiquete = MapearTiquete(tiqueteInput);
var response = _tiqueteService.Guardar(tiquete);
if (response.Error)
{
return(BadRequest(response.Mensaje));
}
return(Ok(response.Tiquete));
}
private Tiquete MapearTiquete(TiqueteInputModel tiqueteInput)
{
var tiquete = new Tiquete
{
codigo = tiqueteInput.codigo,
ruta = tiqueteInput.ruta,
valor = tiqueteInput.valor,
idCliente = tiqueteInput.idCliente
};
return(tiquete);
}
public ActionResult Edit([Bind(Include = "Numero_Tiquete,Hora_Ingreso_Tiquete,Hora_salida_Tiquete,Valor_Hora_Tiquete,Id_Parqueadero,Placa_Vehiculo")] Tiquete tiquete)
{
if (ModelState.IsValid)
{
db.Entry(tiquete).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id_Parqueadero = new SelectList(db.Parqueadero, "Id_Parqueadero", "Nombre_Parqueadero", tiquete.Id_Parqueadero);
ViewBag.Placa_Vehiculo = new SelectList(db.Vehiculo, "Placa_Vehiculo", "Tipo_Vehiculo", tiquete.Placa_Vehiculo);
return(View(tiquete));
}
private Tiquete MapearTiquete(TiqueteInputModel tiqueteInput)
{
var tiquete = new Tiquete
{
Codigo = tiqueteInput.codigo,
Ruta = tiqueteInput.ruta,
IdCliente = tiqueteInput.idCliente,
Nombre = tiqueteInput.nombre,
Valor = tiqueteInput.valor
};
return(tiquete);
}
public void Guardar(Tiquete tiquete)
{
using (var command = _connection.CreateCommand())
{
command.CommandText = @"Insert Into tiquete (codigo, ruta, valor, idCliente)
values (@codigo, @ruta, @valor, @idcliente)";
command.Parameters.AddWithValue("@codigo", tiquete.codigo);
command.Parameters.AddWithValue("@ruta", tiquete.ruta);
command.Parameters.AddWithValue("@valor", tiquete.valor);
command.Parameters.AddWithValue("@idCliente", tiquete.idCliente);
var filas = command.ExecuteNonQuery();
}
}
public ResumenCompraPage(Funcion func, int cantid, Cartelera cartelera)
{
InitializeComponent();
datos.BindingContext = cartelera;
funcion.BindingContext = func;
Tiquete tiquete = new Tiquete();
tiquete.Precio = func.Precio;
tiquete.Cantidad = cantid;
tiquete.TotalPago = func.Precio * cantid;
tiquetes.BindingContext = tiquete;
}
private Tiquete DataReaderMapToPerson(SqlDataReader dataReader)
{
if (!dataReader.HasRows)
{
return(null);
}
Tiquete tiquete = new Tiquete();
tiquete.codigo = (int)dataReader["codigo"];
tiquete.ruta = (string)dataReader["ruta"];
tiquete.valor = (double)dataReader["valor"];
tiquete.idCliente = (string)dataReader["idCliente"];
return(tiquete);
}
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Tiquete tiquete = db.Tiquete.Find(id);
if (tiquete == null)
{
return(HttpNotFound());
}
return(View(tiquete));
}
public ActionResult <TiqueteViewModel> Post(TiqueteInputModel tiqueteInput)
{
Tiquete tiquete = MapearTiquete(tiqueteInput);
var response = _tiqueteService.Guardar(tiquete);
if (response.Error)
{
ModelState.AddModelError("Guardar Tiquete", response.Mensaje);
var problemDetails = new ValidationProblemDetails(ModelState)
{
Status = StatusCodes.Status400BadRequest,
};
return(BadRequest(response.Mensaje));
}
return(Ok(response.Tiquete));
}
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Tiquete tiquete = db.Tiquete.Find(id);
if (tiquete == null)
{
return(HttpNotFound());
}
ViewBag.Id_Parqueadero = new SelectList(db.Parqueadero, "Id_Parqueadero", "Nombre_Parqueadero", tiquete.Id_Parqueadero);
ViewBag.Placa_Vehiculo = new SelectList(db.Vehiculo, "Placa_Vehiculo", "Tipo_Vehiculo", tiquete.Placa_Vehiculo);
return(View(tiquete));
}
public GuardarTiqueteResponse Guardar(Tiquete tiquete)
{
try
{
var tiqueteBuscado = _context.Tiquetes.Find(tiquete.Codigo);
if (tiqueteBuscado != null)
{
return(new GuardarTiqueteResponse("Error, el tiquete ya se encuentra registrado"));
}
_context.Tiquetes.Add(tiquete);
_context.SaveChanges();
return(new GuardarTiqueteResponse(tiquete));
}
catch (Exception e)
{
return(new GuardarTiqueteResponse($"Error de la Aplicacion: {e.Message}"));
}
}
public async Task <ActionResult <TiqueteViewModel> > PostAsync(TiqueteInputModel tiqueteInput)
{
Tiquete tiquete = MapearTiquete(tiqueteInput);
var response = _tiqueteService.Guardar(tiquete);
if (response.Error)
{
ModelState.AddModelError("Guardar Tiquete", response.Mensaje);
var problemDetails = new ValidationProblemDetails(ModelState)
{
Status = StatusCodes.Status400BadRequest,
};
return(BadRequest(response.Mensaje));
}
var tiqueteViewModel = new TiqueteViewModel(response.Tiquete);
await _hubContext.Clients.All.SendAsync("TiqueteRegistrado", tiqueteViewModel);
return(Ok(tiqueteViewModel));
}
public List <Tiquete> ConsultarTodos()
{
SqlDataReader dataReader;
List <Tiquete> tiquetes = new List <Tiquete>();
using (var command = _connection.CreateCommand())
{
command.CommandText = "Select * from tiquete ";
dataReader = command.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
Tiquete tiquete = DataReaderMapToPerson(dataReader);
tiquetes.Add(tiquete);
}
}
}
return(tiquetes);
}
/// <summary>
/// Agrega un nuevo tiquete
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public bool AddTicket(TicketData data)
{
using (tecAirlinesEntities entities = new tecAirlinesEntities())
{
Tiquete newTicket = new Tiquete();
newTicket.C_Reserva = data.C_Reserva;
newTicket.N_Asiento = data.N_Asiento;
try
{
entities.Tiquetes.Add(newTicket);
entities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
}
public async Task <ActionResult <Tiquete> > PostTiquete(TiqueteViewModel request)
{
var tiquete = new Tiquete()
{
Id = request.Id,
Ruta = request.RutaViewMode,
Pasajero = request.ClienteViewModel,
Cantidad = request.number,
total = request.number
};
_context.Tiquete.Add(tiquete);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (RutaExists(tiquete.Id))
{
ModelState.AddModelError("Tiquete", "El codigo de tiquete ya se necuentra registrado");
var problemDetails = new ValidationProblemDetails(ModelState)
{
Status = StatusCodes.Status400BadRequest,
};
return(BadRequest(problemDetails));
}
else
{
ModelState.AddModelError("Tiquete", "Existe un problema con el tiquete");
var problemDetails = new ValidationProblemDetails(ModelState)
{
Status = StatusCodes.Status400BadRequest,
};
return(BadRequest(problemDetails));
}
}
return(CreatedAtAction("GetRuta", new { id = Tiquete.Id }, tiquete));
}
public async Task <ActionResult <Tiquete> > PostHistoria(TiqueteRequest tiquete)
{
var cliente = await _context.Clientes.FindAsync(tiquete.IdentificacionCliente);
var ruta = await _context.Rutas.FindAsync(tiquete.RutaId);
if (cliente == null)
{
ModelState.AddModelError("Cliente", "El cliente no exite, no se encontro");
}
if (ruta == null)
{
ModelState.AddModelError("Ruta", "La ruta no exite, no se encontro");
}
if (!ModelState.IsValid)
{
var problemDetails = new ValidationProblemDetails(ModelState)
{
Status = StatusCodes.Status400BadRequest,
};
return(BadRequest(problemDetails));
}
var nuevoTiquete = new Tiquete {
Cliente = cliente,
Ruta = ruta,
Cantidad = tiquete.Cantidad
};
_context.Tiquetes.Add(nuevoTiquete);
await _context.SaveChangesAsync();
return(CreatedAtAction(nameof(GetTiqueteItem), new { id = tiquete.Id }, tiquete));
}
public GuardarTiqueteResponse(bool error, string mensaje, Tiquete _tiquete)
{
this.Error = error;
this.Mensaje = mensaje;
this._tiquete = _tiquete;
}
public GuardarTiqueteResponse(Tiquete tiquete)
{
Error = false;
_tiquete = tiquete;
}
