//---------------------------------------------------------------------------------------------- //Insertar Factura public String CobrarFacturaDAL(UTIL_Factura utilFa) { ConnectionBD stringconn = new ConnectionBD(); NpgsqlConnection conn = new NpgsqlConnection(stringconn.Postgreconnection()); NpgsqlCommand postCommand = new NpgsqlCommand("erase_factura", conn); postCommand.CommandType = CommandType.StoredProcedure; try { postCommand.Parameters.Add("_cedula", NpgsqlTypes.NpgsqlDbType.Integer).Value = UTIL.UTIL.ObtenerValor(utilFa.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 Factura por cedula public DataTable BuscarFacturaDAL(UTIL_Factura utilFa) { DataSet ds = new DataSet(); ConnectionBD stringconn = new ConnectionBD(); NpgsqlConnection conn = new NpgsqlConnection(stringconn.Postgreconnection()); NpgsqlCommand postCommand = new NpgsqlCommand("buscar_factura", conn); postCommand.CommandType = CommandType.StoredProcedure; try { postCommand.Parameters.Add("_cedula", NpgsqlTypes.NpgsqlDbType.Integer).Value = UTIL.UTIL.ObtenerValor(utilFa.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); } }