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