public static DataTable GeNARContacts()
{
DataQueries dataAccess = new DataQueries();
string query = "SELECT FullName,title,IsDisabled,PositionId,PositionIdName,address1_telephone1,internalemailaddress,OrderBy " +
"FROM [PDF_RPT_DATA].[dbo].[View_CustomerWeekly_Contacts]";
DataTable dt = dataAccess.ReadDataTable(query, "CRM");
return(dt);
}
public static DataTable GetDetailsList(string listid)
{
DataQueries dataAccess = new DataQueries();
string query = "SELECT TOP 1 [list_id] ,[jobno] AS [job_number],[job_name] AS [project_name],[est_completion_date],[job_size] ,[job_type] ,[job_city] ,[job_state],[job_city] + ', ' +[job_state] AS [location] " +
" ,[NAR_JobProjectManagerId],[pm_name],[pm_email],[pm_phone],[pm_mobile],[nar_jobasstprojectmanagerid],[apm_name],[apm_email] " +
" ,[apm_phone],[apm_mobile],[total_squares],[percent_complete],[squares_installed],[week_ending],[ModifiedOn],[jobGUID] " +
" ,[job_type], [job_size] " +
" FROM [PDF_RPT_DATA].[dbo].[View_Customer_Weekly_Report_Data] " +
" WHERE [list_id] = " + listid +
" ORDER BY [ModifiedOn] DESC";
DataTable dt = dataAccess.ReadDataTable(query, "CRM");
return(dt);
}