public async Task <IActionResult> PutDetallePagos([FromRoute] long id, [FromBody] DetallePagos detallePagos) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != detallePagos.IdAlumno_master) { return(BadRequest()); } _context.Entry(detallePagos).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DetallePagosExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public PagosForm(decimal pTotal, DetallePagos pPagoRepo, int idCaja, string idCliente) { InitializeComponent(); total = pTotal; curPagoRepo = pPagoRepo; curCaja = idCaja; curCliente = idCliente; }
public async Task <ActionResult <DetallePagos> > PostDetallePagos([FromBody] DetallePagos detallePagos) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.DetallesAlumno.Add(detallePagos); await _context.SaveChangesAsync(); return(CreatedAtAction("GetDetallePagos", new { id = detallePagos.IdAlumno_master }, detallePagos)); }
public void insertarPago(Pagos pg, DetallePagos dp) { string sql; sql = "CALL insertarPago(?,?,?,?,?,?,?,?,?,?)"; cmd = new MySqlCommand(); try { cmd.Connection = databaseConnection; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "INS_PAGO"; databaseConnection.Open(); MySqlParameter[] pms = new MySqlParameter[8]; //pms[0] = new MySqlParameter("nidDetalle", MySqlDbType.Int32); //pms[0].Value = dp.IdDetallePago; //pms[1] = new MySqlParameter("nidPago", MySqlDbType.Int32); //pms[1].Value = pg.IdPago; pms[0] = new MySqlParameter("nidconcepto", MySqlDbType.Int32); pms[0].Value = dp.IdConcepto; pms[1] = new MySqlParameter("nidcolono", MySqlDbType.Int32); pms[1].Value = pg.IdColono; pms[2] = new MySqlParameter("nidmes", MySqlDbType.Int32); pms[2].Value = dp.Idmes; pms[3] = new MySqlParameter("ncantidad", MySqlDbType.Int32); pms[3].Value = dp.Cantidad; pms[4] = new MySqlParameter("ncostoUn", MySqlDbType.Double); pms[4].Value = dp.CostoUnitario; pms[5] = new MySqlParameter("ncostoTotal", MySqlDbType.Double); pms[5].Value = dp.CostoUnitario; pms[6] = new MySqlParameter("nTotal", MySqlDbType.Double); pms[6].Value = dp.Total1; pms[7] = new MySqlParameter("nidtipo", MySqlDbType.Int32); pms[7].Value = dp.Idtipo; cmd.Parameters.AddRange(pms); cmd.ExecuteNonQuery(); //MySqlDataReader myReader = cmd.ExecuteReader(); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Pago Realizado Exitosamente"); } else { MessageBox.Show("No se pudo realizar el pago"); } cmd.CommandTimeout = 60; databaseConnection.Close(); } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message + " " + ex.StackTrace); databaseConnection.Close(); } finally { databaseConnection.Close(); } }