public Boolean ActualizarOrdenPago(OrdenPago OrdenPago)
{
try
{
using (SqlConnection conn = new SqlConnection(strConnection))
{
conn.Open();
SqlCommand command = new SqlCommand("USP_ACTUALIZAR_ORDENPAGO", conn);
command.CommandType = CommandType.StoredProcedure;
//command.CommandText = "USP_INSERTAR_BANCO";
command.Connection = conn;
command.Parameters.AddWithValue("@Id", OrdenPago.Id);
command.Parameters.AddWithValue("@Monto", OrdenPago.Monto);
command.Parameters.AddWithValue("@Moneda", OrdenPago.Moneda);
command.Parameters.AddWithValue("@estado", OrdenPago.estado);
command.Parameters.AddWithValue("@FechaPago", OrdenPago.FechaPago);
command.ExecuteNonQuery();
conn.Close();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
public OrdenPago ObtenerPorId(int Id)
{
try
{
using (SqlConnection conn = new SqlConnection(strConnection))
{
conn.Open();
SqlCommand command = new SqlCommand("USP_OBTENER_ORDENPAGO_ID", conn);
command.CommandType = CommandType.StoredProcedure;
command.Connection = conn;
command.Parameters.AddWithValue("@Id", Id);
IDataReader lector = command.ExecuteReader();
OrdenPago beOrdenPago = null;
while (lector.Read())
{
beOrdenPago = new OrdenPago()
{
Id = lector.GetInt32(0),
Monto = lector.GetDecimal(1),
Moneda = lector.GetString(2),
estado = lector.GetString(3),
FechaPago = lector.GetDateTime(4),
};
}
conn.Close();
return(beOrdenPago);
}
}
catch (Exception ex)
{
throw;
}
}
public List <OrdenPago> ListarOrdenPago()
{
try
{
using (SqlConnection conn = new SqlConnection(strConnection))
{
conn.Open();
SqlCommand command = new SqlCommand("USP_LISTAR_ORDENPAGO", conn);
command.CommandType = CommandType.StoredProcedure;
command.Connection = conn;
List <OrdenPago> lstOrdenPago = new List <OrdenPago>();
IDataReader lector = command.ExecuteReader();
while (lector.Read())
{
OrdenPago beOrdenPago = new OrdenPago()
{
Id = lector.GetInt32(0),
Monto = lector.GetDecimal(1),
Moneda = lector.GetString(2),
estado = lector.GetString(3),
FechaPago = lector.GetDateTime(4),
};
lstOrdenPago.Add(beOrdenPago);
}
conn.Close();
return(lstOrdenPago);
}
}
catch (Exception ex)
{
throw;
}
}
public Boolean EliminarOrdenPago(OrdenPago OrdenPago)
{
try
{
using (SqlConnection conn = new SqlConnection(strConnection))
{
conn.Open();
SqlCommand command = new SqlCommand("USP_ELIMINAR_ORDENPAGO", conn);
command.CommandType = CommandType.StoredProcedure;
//command.CommandText = "USP_INSERTAR_BANCO";
command.Connection = conn;
command.Parameters.AddWithValue("@Id", OrdenPago.Id);
command.ExecuteNonQuery();
conn.Close();
return(true);
}
}
catch (Exception ex)
{
return(false);
}
}
