CodeImp.Gluon.GroceriesItem.FromDataRow C# (CSharp) Метод

        public static GroceriesItem FromDataRow(DataTableRow r)
        {
            GroceriesItem i = new GroceriesItem();
            i.name = r.GetString("name");
            i.count = r.GetLong("count");
            i.list = r.GetInt("list");
            return i;
        }

        // This returns all items by sql query
        private List <GroceriesItem> SelectItems(string sql)
        {
            General.DB.ConnectSafe();

            DataTable t = General.DB.Query(sql);

            if (t != null)
            {
                List <GroceriesItem> list = new List <GroceriesItem>(t.Count);

                foreach (DataTableRow r in t)
                {
                    list.Add(GroceriesItem.FromDataRow(r));
                }

                General.DB.Disconnect();
                return(list);
            }
            else
            {
                // Failed!
                General.DB.Disconnect();
                return(null);
            }
        }