public bool agregarPago(Epagos _epagos)
{
cmd.Connection = cnx;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "pr_pagos_new";
try
{
cmd.Parameters.Add(new SqlParameter("@idConcepto", SqlDbType.Int));
cmd.Parameters["@idConcepto"].Value = _epagos.idConcepto;
cmd.Parameters.Add(new SqlParameter("@idmatricula", SqlDbType.Int));
cmd.Parameters["@idmatricula"].Value = _epagos.idMatricula;
cmd.Parameters.Add(new SqlParameter("@fecha", SqlDbType.DateTime));
cmd.Parameters["@fecha"].Value = _epagos.fecha;
cmd.Parameters.Add(new SqlParameter("@hora", SqlDbType.VarChar, 10));
cmd.Parameters["@hora"].Value = _epagos.hora;
cmd.Parameters.Add(new SqlParameter("@total", SqlDbType.Decimal));
cmd.Parameters["@total"].Value = _epagos.Total;
cnx.Open();
cmd.ExecuteNonQuery();
exito = true;
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
finally
{
if (cnx.State == ConnectionState.Open)
{
cnx.Close();
}
cmd.Parameters.Clear();
}
return(exito);
}
public bool addPago(Epagos epagos)
{
return(_pagosDatos.agregarPago(epagos));
}
