public void Update(Document product)
 {
     using (Cloud9Model context = new Cloud9Model())
     {
         context.Entry(product).State = EntityState.Modified;
     }
 }
 public void Create(Document item)
 {
     using (Cloud9Model context = new Cloud9Model())
     {
         context.Documents.Add(item);
         context.SaveChanges();
     }
 }
 public void Create(User item)
 {
     using (Cloud9Model context = new Cloud9Model())
     {
         context.Users.Add(item);
         context.SaveChanges();
     }
 }
        public List <Document> SelectAll()
        {
            List <Document> temp;

            using (Cloud9Model context = new Cloud9Model())
            {
                temp = context.Documents.ToList();
            }
            return(temp);
        }
        public List <User> SelectAll()
        {
            List <User> temp;

            using (Cloud9Model context = new Cloud9Model())
            {
                temp = context.Users.ToList();
            }
            return(temp);
        }
        public void Delete(int id)
        {
            Document result = new Document();

            using (Cloud9Model context = new Cloud9Model())
            {
                List <Document> temp = context.Documents.ToList();
                for (int i = 0; i < temp.Count; i++)
                {
                    if (temp[i].Id == id)
                    {
                        context.Documents.Remove(temp[i]);
                    }
                }
                context.SaveChanges();
            }
        }
        public Document Select(int id)
        {
            Document result = new Document();

            using (Cloud9Model context = new Cloud9Model())
            {
                List <Document> temp = context.Documents.ToList();
                for (int i = 0; i < temp.Count; i++)
                {
                    if (temp[i].Id == id)
                    {
                        result = temp[i];
                    }
                }
            }
            return(result);
        }
        public void Delete(int id)
        {
            User result = new User();

            using (Cloud9Model context = new Cloud9Model())
            {
                List <User> temp = context.Users.ToList();
                for (int i = 0; i < temp.Count; i++)
                {
                    if (temp[i].Id == id)
                    {
                        context.Users.Remove(temp[i]);
                    }
                }
                context.SaveChanges();
            }
        }
        public User Select(int id)
        {
            User result = new User();

            using (Cloud9Model context = new Cloud9Model())
            {
                List <User> temp = context.Users.ToList();
                for (int i = 0; i < temp.Count; i++)
                {
                    if (temp[i].Id == id)
                    {
                        result = temp[i];
                    }
                }
            }
            return(result);
        }