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);
}
}
}
