private void DeleteReportsFromLocalProfile(string strSQLProfileName) { try { FormAppByLocation AppByLocation = new FormAppByLocation(); AppByLocation.LoadAllSavedSQLProfiles(); if (AppByLocation.DeleteFromProfileList(strSQLProfileName)) { AppByLocation.SaveAllSQLProfilesFromTheList(); } } catch (Exception) { } }
private void RunApplicationByLocationOption(string reportName) { //MessageBox.Show("Assets By Location Selected"); //Hide the tab first //Display the asset selection dialog.. FormAppByLocation AppByLocation = new FormAppByLocation(); if (AppByLocation.ShowDialog() == DialogResult.OK) { //run the query based on for the recordset.. string strQuery = "SELECT APP._PUBLISHER, APP._NAME + ' (' + APP._VERSION + ')' AS [Application & Version], A._NAME AS Asset, L._NAME AS Location " + "FROM APPLICATIONS APP " + "INNER JOIN APPLICATION_INSTANCES APPI ON (APP._APPLICATIONID = APPI._APPLICATIONID) " + "INNER JOIN ASSETS A ON (A._ASSETID = APPI._ASSETID) " + "INNER JOIN LOCATIONS L ON (A._LOCATIONID = L._LOCATIONID) " + "WHERE APP._IGNORED = 0 "; string strSelectedApplicationSQL = ""; string strSelectedLocationSQL = ""; if (AppByLocation.LastSavedSelectionItem.ApplicationItemList.Count > 0) { strSelectedApplicationSQL = "AND ("; for (int i = 0; i < AppByLocation.LastSavedSelectionItem.ApplicationItemList.Count - 1; i++) { strSelectedApplicationSQL += "APP._NAME ='"; strSelectedApplicationSQL += AppByLocation.LastSavedSelectionItem.ApplicationItemList[i].ApplicationName; strSelectedApplicationSQL += "' OR "; } strSelectedApplicationSQL += "APP._NAME ="; strSelectedApplicationSQL += AuditWizardDataAccess.PrepareSqlString(AppByLocation.LastSavedSelectionItem.ApplicationItemList[AppByLocation.LastSavedSelectionItem.ApplicationItemList.Count - 1].ApplicationName); //strSelectedApplicationSQL += ""; strSelectedApplicationSQL += " )"; strQuery += strSelectedApplicationSQL; } if (AppByLocation.LastSavedSelectionItem.LocationNames.Count > 0) { strSelectedLocationSQL = "AND ("; for (int i = 0; i < AppByLocation.LastSavedSelectionItem.LocationNames.Count - 1; i++) { strSelectedLocationSQL += "L._NAME ='"; strSelectedLocationSQL += AppByLocation.LastSavedSelectionItem.LocationNames[i]; strSelectedLocationSQL += "' OR "; } strSelectedLocationSQL += "L._NAME ='"; strSelectedLocationSQL += AppByLocation.LastSavedSelectionItem.LocationNames[AppByLocation.LastSavedSelectionItem.LocationNames.Count - 1]; strSelectedLocationSQL += "'"; strSelectedLocationSQL += " )"; strQuery += strSelectedLocationSQL; } strQuery += "ORDER BY L._NAME"; ReportsWorkItemController wiController = (ReportsWorkItemController)workItem.Controller; wiController.RunSQLReport(reportName, strQuery); //Filter the recodset based on the dialog settings if (AppByLocation.SaveAsUserDefinedReport) { List <string> _filterConditions = new List <string>(); _filterConditions.Add(strQuery); BinaryFormatter bf = new BinaryFormatter(); MemoryStream mem = new MemoryStream(); bf.Serialize(mem, _filterConditions); string lReportData = Convert.ToBase64String(mem.ToArray()); new ReportsDAO().Insert(AppByLocation.UserDefinedReportName, ReportsDAO.ReportType.SqlReport, lReportData); RefreshView(); AppByLocation.SaveAllSQLProfilesFromTheList(); } AppByLocation.SaveItemSelection(); //Fill the Report grid //Show the grid to the user } else { } }