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();
}
