public DataTable GetPervasiveRecords(string dataObject = "", string jobNumber = "")
{
try
{
var pervasiveQuery = GetPervasiveQueryString(dataObject, jobNumber);
if (String.IsNullOrEmpty(pervasiveQuery))
{
return(null);
}
PervasiveClient pervasiveClient = new PervasiveClient();
var pervasiveRecords = pervasiveClient.QueryPervasiveADO(pervasiveQuery);
if (pervasiveRecords is null)
{
return(null);
}
if (pervasiveRecords.Rows.Count == 0)
{
return(null);
}
return(pervasiveRecords);
}
catch (Exception ex)
{
return(null);
}
}
public string GetCompanyByJob(string jobNumber)
{
try
{
if (string.IsNullOrEmpty(jobNumber))
{
return(null);
}
var sql = "exec CS_getCompanyByJob('" + jobNumber + "');";
PervasiveClient pervasiveClient = new PervasiveClient();
DataTable jobCompanyData = pervasiveClient.QueryPervasiveADO(sql);
if (jobCompanyData is null || jobCompanyData.Rows.Count == 0)
{
return(null);
}
return(jobCompanyData.Rows[0]["CompanyName"].ToString());
}
catch (Exception ex)
{
return(null);
}
}
