/// <summary>
        /// Updates an item in the database
        /// </summary>
        /// <param name="item">the company that will be updated</param>
        /// <returns>true if it succeds</returns>
        public bool Update(Company item)
        {
            try
            {
                using (var ctx = new Context())
                {
                    Company result = ctx.Entry(item).Entity;
                   
                    if (result == null)
                    {
                        return false;
                    }
                    
                    foreach (var empsToAttach in item.Employees)
                    {
                        ctx.Employees.Attach(empsToAttach);
                    }

                    //sets the information
                    result.Employees = item.Employees;
                    result.Name = item.Name;
                    result.PhoneNr = item.PhoneNr;

                    ctx.Entry(result).State = EntityState.Modified;

                    ctx.SaveChanges();
                    return true;
                }
            }
            catch(Exception e) {
                return false;
            }
        }
        /// <summary>
        /// will deactivate an item
        /// </summary>
        /// <param name="item">the item to be deactivated</param>
        /// <returns>true if the item was successfully deactivated</returns>
        public bool ChangeState(Company item)
        {
            using (var ctx = new Context())
            {
                var result = ctx.Entry(item).Entity;
                if (result == null)
                {
                    return false;
                }
                if (result.Active) { 
                result.Active = false;
                }
                else {
                    result.Active = true;
                }

                ctx.Entry(result).State = EntityState.Modified;
                
                ctx.SaveChanges();
              
                return true;
            }
        }