public DataTable insertarpqr(e_PQR user)
{
DataTable pqr = new DataTable();
NpgsqlConnection conectar = new NpgsqlConnection(ConfigurationManager.ConnectionStrings["Postgres"].ConnectionString);
try
{
NpgsqlDataAdapter dataAdapter = new NpgsqlDataAdapter("seguridad.agregar_pqr", conectar);
dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
dataAdapter.SelectCommand.Parameters.Add("_correo", NpgsqlDbType.Varchar).Value = user.Correo;
dataAdapter.SelectCommand.Parameters.Add("_queja", NpgsqlDbType.Varchar).Value = user.Queja;
;
conectar.Open();
dataAdapter.Fill(pqr);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (conectar != null)
{
conectar.Close();
}
}
return(pqr);
}
public DataTable Insertarpqr1(String correo, String queja)
{
e_PQR nuevo = new e_PQR();
D_PQR pqr = new D_PQR();
nuevo.Correo = correo;
nuevo.Queja = queja;
DataTable Datos = pqr.insertarpqr(nuevo);
return(Datos);
}
public DataTable Insertarpqr(String correo, String queja)
{
e_PQR nuevo = new e_PQR();
D_PQR pqr = new D_PQR();
nuevo.Correo = correo;
nuevo.Queja = queja;
DataTable Datos = pqr.insertarpqr(nuevo);
//ClientScriptManager cm = this.ClientScript;
///cm.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('PQR recibido,en breve responderemos tu Pqr al correo ');window.location=\"PQR_visitante.aspx\"</script>");
return(Datos);
}
