public bool DeleteSkill(SKILL Entity) { using (KARYABDBEntities db = new KARYABDBEntities()) { try { db.Configuration.ProxyCreationEnabled = false; //var employer = new Employ { Id = 1 }; //ctx.Employ.Attach(employer); //ctx.Employ.Remove(employer); //ctx.SaveChanges(); SKILL entity = db.SKILLS.FirstOrDefault(q => q.ID == Entity.ID); OWNERSSKILL Owner = db.OWNERSSKILLS.FirstOrDefault(q => q.SKILLID == Entity.ID); db.OWNERSSKILLS.Attach(Owner); db.OWNERSSKILLS.Remove(Owner); db.SaveChanges(); db.SKILLS.Attach(entity); db.SKILLS.Remove(entity); db.SaveChanges(); return(true); } catch (Exception e) { return(false); } } }
public long SetSkill(SKILL Skill, long HumanID) { using (KARYABDBEntities db = new KARYABDBEntities()) { try { db.Configuration.ProxyCreationEnabled = false; db.SKILLS.Add(Skill); db.SaveChanges(); OWNERSSKILL owenersSkill = new OWNERSSKILL(); owenersSkill.SKILLID = Skill.ID; owenersSkill.SKILLOWNERID = HumanID; db.OWNERSSKILLS.Add(owenersSkill); db.SaveChanges(); return(Skill.ID); } catch { return(0); } } }