コード例 #1
0
 public long SetExperience(EXPERIENCE Experience, long HumanID)
 {
     using (KARYABDBEntities db = new KARYABDBEntities())
     {
         try
         {
             db.Configuration.ProxyCreationEnabled = false;
             db.EXPERIENCES.Add(Experience);
             db.SaveChanges();
             OWNERSEXPERIENCE owenersExperience = new OWNERSEXPERIENCE();
             owenersExperience.EXPERIENCEID      = Experience.ID;
             owenersExperience.EXPERIENCEOWNERID = HumanID;
             db.OWNERSEXPERIENCES.Add(owenersExperience);
             db.SaveChanges();
             return(Experience.ID);
         }
         catch
         {
             return(0);
         }
     }
 }
コード例 #2
0
        public bool DeleteExperience(EXPERIENCE Entity)
        {
            using (KARYABDBEntities db = new KARYABDBEntities())
            {
                try
                {
                    db.Configuration.ProxyCreationEnabled = false;
                    EXPERIENCE       entity = db.EXPERIENCES.FirstOrDefault(q => q.ID == Entity.ID);
                    OWNERSEXPERIENCE Owner  = db.OWNERSEXPERIENCES.FirstOrDefault(q => q.EXPERIENCEID == Entity.ID);
                    db.OWNERSEXPERIENCES.Attach(Owner);
                    db.OWNERSEXPERIENCES.Remove(Owner);
                    db.SaveChanges();
                    db.EXPERIENCES.Attach(entity);
                    db.EXPERIENCES.Remove(entity);
                    db.SaveChanges();

                    return(true);
                }
                catch (Exception e)
                {
                    return(false);
                }
            }
        }