public DataTable returnResult(string query, out string mensaje)
{
try
{
using (TdConnection cn = new TdConnection(conn.StringConnection))
{
cn.Open();
TdCommand cmd = cn.CreateCommand();
cmd.CommandText = @query;
cmd.CommandTimeout = 100000;
TdDataAdapter adapter = new TdDataAdapter();
adapter.SelectCommand = cmd;
DataSet ds = new DataSet();
adapter.Fill(ds);
var dt = ds.Tables[0];
mensaje = "Se consultaron " + dt.Rows.Count.ToString() + " registros.";
return(dt);
}
}
catch (Exception e)
{
mensaje = e.Message;
return(null);
}
}
public bool doesWorkflowExist(String folder, String workflow)
{
String folder_name = "'" + folder + "'";
String workflow_name = "'" + workflow + "'";
try
{
cn.Open();
TdCommand cmd = cn.CreateCommand();
cmd.CommandText = "SELECT count(*) from edw_auv_d.INFA_SESSION_LOG where subject_area = " + folder_name + " and workflow_name =" + workflow_name + ";";
Int32 count = (Int32)cmd.ExecuteScalar();
cn.Close();
if (count > 0)
{
return(true);
}
return(false);
}catch (Exception ex)
{
cn.Close();
MessageBox.Show(ex.Message);
return(false);
}
}
