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