//public virtual ObjectResult<int> Skills_Save(Nullable<int> iD, string description, Nullable<int> userID, Nullable<int> companyID, SqlParameter skillId) //{ // var iDParameter = iD.HasValue ? // new SqlParameter("ID", iD) : // new SqlParameter("ID", typeof(int)); // var descriptionParameter = description != null ? // new SqlParameter("Description", description) : // new SqlParameter("Description", typeof(string)); // var userIDParameter = userID.HasValue ? // new SqlParameter("UserID", userID) : // new SqlParameter("UserID", typeof(int)); // var companyIDParameter = companyID.HasValue ? // new SqlParameter("CompanyID", companyID) : // new SqlParameter("CompanyID", typeof(int)); // return ((IObjectContextAdapter)this).ObjectContext.ExecuteStoreQuery<int>("Skills_Save", iDParameter, descriptionParameter, userIDParameter, companyIDParameter, skillId); //} public virtual Skill Skills_Save(int iD, string description, Nullable<int> userID, Nullable<int> companyID, SqlParameter skillId) { //using (NuvolaResumeContext context = new NuvolaResumeContext()) { Skill item = new Skill(); if (iD > 0) { //Find the item item = Skills_Get(iD); } //Update / Set properties item.UserID = userID.Value; item.CompanyID = companyID; if (item.ID > 0) { //Add the new item to the database _context.Skills.Add(item); } _context.SaveChanges(); return (item); } }
public virtual Skill Skills_Get(int Id) { Skill item = new Skill(); if (Id < 1) return (item); //using (NuvolaResumeContext context = new NuvolaResumeContext()) { _context.Configuration.ProxyCreationEnabled = false; item = _context.Skills.Include(x => x.Company).SingleOrDefault(x => x.ID == Id); if (item == null) return (new Skill()); return (item); } }