//----------------------------------------------------------------------------------------------
//Eliminar Abonado
public String EliminarAbonadoDAL(UTIL_Abonado utilAb)
{
ConnectionBD stringconn = new ConnectionBD();
NpgsqlConnection conn = new NpgsqlConnection(stringconn.Postgreconnection());
NpgsqlCommand postCommand = new NpgsqlCommand("Eliminar_Abonado", conn);
postCommand.CommandType = CommandType.StoredProcedure;
try
{
postCommand.Parameters.Add("_cedula", NpgsqlTypes.NpgsqlDbType.Integer).Value = UTIL.UTIL.ObtenerValor(utilAb.iCedula);
NpgsqlParameter message = postCommand.Parameters.Add("message", NpgsqlTypes.NpgsqlDbType.Text, 250);
message.Direction = ParameterDirection.Output;
conn.Open();
postCommand.ExecuteNonQuery();
messageOutput = postCommand.Parameters["message"].Value.ToString();
}
catch (Exception ex)
{
return(ex.Message);
throw new Exception(ex.Message);
}
finally
{
conn.Close();
}
return(messageOutput);
}
//----------------------------------------------------------------------------------------------
//Buscar Abonado por cedula
public DataTable BuscarAbonadoDAL(UTIL_Abonado utilAb)
{
ConnectionBD stringconn = new ConnectionBD();
NpgsqlConnection conn = new NpgsqlConnection(stringconn.Postgreconnection());
NpgsqlCommand postCommand = new NpgsqlCommand("buscar_abonado", conn);
postCommand.CommandType = CommandType.StoredProcedure;
try
{
postCommand.Parameters.Add("_cedula", NpgsqlTypes.NpgsqlDbType.Integer).Value = UTIL.UTIL.ObtenerValor(utilAb.iCedula);
NpgsqlParameter message = postCommand.Parameters.Add("message", NpgsqlTypes.NpgsqlDbType.Text, 250);
message.Direction = ParameterDirection.Output;
conn.Open();
postCommand.ExecuteNonQuery();
NpgsqlDataAdapter dta = new NpgsqlDataAdapter(postCommand);
dta.Fill(ds);
messageOutput = postCommand.Parameters["message"].Value.ToString();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
conn.Close();
}
if (ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
else
{
return(null);
}
}