Inheritance: INotifyPropertyChanging, INotifyPropertyChanged
 public static void InsertCollection(Collection c)
 {
     naturenet_dataclassDataContext db = new naturenet_dataclassDataContext();
     db.Collections.InsertOnSubmit(c);
     Action a = new Action();
     a.date = DateTime.Now; a.type_id = 1; a.object_type = c.GetType().ToString();
     a.user_id = c.user_id;
     try { db.SubmitChanges(); a.object_id = c.id; db.Actions.InsertOnSubmit(a); db.SubmitChanges(); }
     catch (Exception e) { log.WriteErrorLog(e); }
 }
 partial void DeleteCollection(Collection instance);
 partial void UpdateCollection(Collection instance);
 partial void InsertCollection(Collection instance);
		private void detach_Collections(Collection entity)
		{
			this.SendPropertyChanging();
			entity.Activity = null;
		}
		private void attach_Collections(Collection entity)
		{
			this.SendPropertyChanging();
			entity.User = this;
		}
Esempio n. 7
0
        public static int get_or_create_collection(naturenet_dataclassDataContext db, string user_name, string avatar, int activity_id, DateTime dt)
        {
            int user_id =0;
            var ru = from u in db.Users
                     where u.name == user_name
                     select u;
            if (ru.Count() == 0)
            {
                return 0;
            }
            else
            {
                user_id = ru.First<User>().id;
            }

            var r = from c in db.Collections
                    where ((c.user_id == user_id) && c.activity_id == activity_id)
                    orderby c.date descending
                    select c;
            if (r.Count() != 0)
            {
                foreach (Collection col in r)
                {
                    if (configurations.GetDate_Formatted(col.date) == configurations.GetDate_Formatted(dt))
                        return col.id;
                }
            }

            // create new collection
            Collection cl = new Collection();
            cl.activity_id = activity_id;
            cl.date = dt;
            cl.name = configurations.GetDate_Formatted(dt);
            cl.user_id = user_id;
            database_manager.InsertCollection(cl);
            return cl.id;
        }
Esempio n. 8
0
        public static int get_or_create_collection(int user_id, int activity_id, DateTime dt)
        {
            naturenet_dataclassDataContext db = new naturenet_dataclassDataContext();
            var r = from c in db.Collections
                    where ((c.user_id == user_id) && c.activity_id == activity_id)
                    orderby c.date descending
                    select c;
            if (r.Count() != 0)
            {
                foreach (Collection col in r)
                {
                    if (configurations.GetDate_Formatted(col.date) == configurations.GetDate_Formatted(dt))
                        return col.id;
                }
            }

            // create new collection
            Collection cl = new Collection();
            cl.activity_id = activity_id;
            cl.date = dt;
            cl.name = configurations.GetDate_Formatted(dt);
            cl.user_id = user_id;
            database_manager.InsertCollection(cl);
            return cl.id;
        }