Ejemplo n.º 1
0
 //      public TItem TableItem { get; set; }
 //        public Type curr_type { get { return typeof(Item); } }
 //        public Guid guid { get; private set; }
 //        public string name { get; set; }
 //        public Guid parentGuid { get; private set; }
 //        public DateTime dateTime { get; private set; }
 //public Item(string _name = "new")
 //{
 //    this.name = _name;
 //}
 //public Item(string _name, Guid _parentGuid):this(_name)
 //{
 //    this.parentGuid = _parentGuid;
 //}
 //public Item(string _name, Guid _parentGuid, DateTime _dt):this(_name, _parentGuid)
 //{
 //    this.dateTime = _dt;
 //}
 //public Item(string _name, Guid _parentGuid, DateTime _dt, Guid _id):this(_name, _parentGuid, _dt)
 //{
 //    this.guid = _id;
 //}
 //static public List<Item> ListLoadFromDataBase()
 //{
 //    List<Item> _listItems = new List<Item>();
 //    using (var _db = new DataClasses1DataContext())
 //    {
 //        var _allItems = from items in _db.TItems select items;
 //        foreach (TItem _resItem in _allItems)
 //        {
 //            Item _item = new Item(_resItem.name, _resItem.parent_id, _resItem.dt, _resItem.id);
 //            _listItems.Add(_item);
 //        }
 //    }
 //    return _listItems;
 //}
 //static public void FillTreeView(TreeNodeCollection Node, List<Item> NodeList, Guid key)
 //{
 //    foreach (Item _items in NodeList)
 //    {
 //        if (_items.parentGuid.CompareTo(key)==0)
 //        {
 //            TreeNodeCollection ChildNode = Node.Add(_items.guid.ToString(), _items.name).Nodes;
 //            FillTreeView(ChildNode, NodeList, _items.guid);
 //        }
 //    }
 //}
 //public void FillTreeView(TreeNodeCollection Node)
 //{
 //    FillTreeView(Node, ListLoadFromDataBase(), this.guid);
 //}
 //static public void FillListView(ListView _listView, List<baseElement> _listItems)
 //{
 //    _listView.Clear();
 //    _listView.BeginUpdate();
 //    foreach (var row in _listItems)
 //    {
 //        var item = new ListViewItem(row.name);
 //        _listView.Items.Add(item);
 //    }
 //    _listView.EndUpdate();
 //}
 public static List<IBaseElement> ListLoadFromDataBase()
 {
     var _listItems = new List<IBaseElement>();
     using (var _db = new DataClasses1DataContext())
     {
         var _allItems = from items in _db.TItems select items;
         foreach (var _resItem in _allItems)
         {
             IBaseElement _el = new Item()
             {
                 name = _resItem.name,
                 id = _resItem.id,
             };
             _listItems.Add(_el);
         }
     }
     return _listItems;
 }
Ejemplo n.º 2
0
 public void SaveToDB()
 {
     using (var _db = new DataClasses1DataContext())
     {
         try
         {
         var _item = _db.TItems.Single(x => x.id == this.id);
             _item.name = this.name;
         }
         catch
         {
             var _item = new TItem();
             _item.name = this.name;
             _db.TItems.InsertOnSubmit(_item);
         }
         _db.SubmitChanges();
     }
 }
Ejemplo n.º 3
0
 //static public void DelFromDB(Guid _id)
 //{
 //    using (var _db = new DataClasses1DataContext())
 //    {
 //        TItem _item = _db.TItems.SingleOrDefault(x => x.id == _id);
 //        _db.TItems.DeleteOnSubmit(_item);
 //        _db.SubmitChanges();
 //    }
 //}
 public static void UpdGroups(Guid _item_id, Guid _group_id, bool _action)
 {
     using (var _db = new DataClasses1DataContext())
     {
         if (_action)
         {
             var _grp = new RItemsGroup();
             _grp.Item_id = _item_id;
             _grp.Group_id = _group_id;
             _db.RItemsGroups.InsertOnSubmit(_grp);
         }else
         {
             var _item = _db.RItemsGroups.Single(x => ((x.Item_id == _item_id) && (x.Group_id == _group_id)));
             _db.RItemsGroups.DeleteOnSubmit(_item);
         }
         _db.SubmitChanges();
     }
 }
Ejemplo n.º 4
0
 public void DeleteFromDB()
 {
     using (var _db = new DataClasses1DataContext())
     {
         TItem _item = new TItem() { id = this.id };
         _db.TItems.Attach(_item);
         _db.TItems.DeleteOnSubmit(_item);
         _db.SubmitChanges();
     }
 }
Ejemplo n.º 5
0
        public static IBaseElement LoadFromDB(Guid _id)
        {
            using (var _db = new DataClasses1DataContext())
            {
                var _item = from items in _db.TItems where items.id == _id select items;
                if (_item.Count() == 1)
                {
                    return new Item()
                    {
                        id = _item.Single().id,
                        name = _item.Single().name
                    };
                }else
                {
                    return null;
                }

            }
        }