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