public DataSet GetClosedIncidents(FilterState state, string storeFilter = null) { Program.Log.Info("Database.GetClosedIncidents()"); this.Open(); string sql = "select * from incidents where lower(status) = 'closed' {0}"; if (storeFilter == null) { sql = String.Format(sql, "{0} order by storeNumber"); } else { sql = String.Format(sql, "and storeNumber={0}"); sql = String.Format(sql, storeFilter); sql += " {0}"; } if (state.ShowAdditionalFilters == false) { sql = String.Format(sql, "and lower(status)!='level 3' and lower(status)!='level 4'"); } else { sql = String.Format(sql, ""); } SQLiteDataAdapter adap = new SQLiteDataAdapter(sql, this.db); DataSet ds = new DataSet(); adap.Fill(ds, "incidents"); return(ds); }
public Filters(FilterState state) { InitializeComponent(); State = state; showAdtFiltersBox.Checked = state.ShowAdditionalFilters; }
public NewMainForm() { InitializeComponent(); db = new Database(); state = new FilterState(); }