// op = ALL: all items, op = DETERIORATED: all deteriorated items, op = FRESH: all fresh items public static List <materialItem> GetItems(SELECTCODE op = SELECTCODE.ALL) { List <materialItem> result = new List <materialItem>(); using (var custstmt = ((App)App.Current).conn.Prepare("SELECT Name, Number, Unit, PurchaseDate, WarrantPeriod, Price, Comment FROM MaterialItem")) { while (custstmt.Step() == SQLiteResult.ROW) { string temp = (string)custstmt[3]; string[] temparr = temp.Split('/', ' ', ':'); materialItem beCheck = new materialItem( (string)custstmt[0], (double)custstmt[1], (string)custstmt[2], new DateTime(int.Parse(temparr[0]), int.Parse(temparr[1]), int.Parse(temparr[2]), int.Parse(temparr[3]), int.Parse(temparr[4]), int.Parse(temparr[5])), (double)custstmt[4], (double)custstmt[5], (string)custstmt[6] ); if (op == SELECTCODE.ALL) { result.Add(beCheck); } else if (op == SELECTCODE.DETERIORATED && beCheck.isDeteriorated()) { result.Add(beCheck); } else if (op == SELECTCODE.FRESH && !beCheck.isDeteriorated()) { result.Add(beCheck); } } } return(result); }