public void Destroyproject(ProjectControlViewModel product)
        {
            var entity = new ProjectControl_Table();

            entity.ProjectControlID = product.ID;

            entities.ProjectControl_Table.Attach(entity);

            entities.ProjectControl_Table.Remove(entity);

            entities.SaveChanges();
        }
        public void Updateproject(ProjectControlViewModel control)
        {
            var entity = new ProjectControl_Table();

            entity.ProjectControlID = control.ID;
            entity.ProjectID        = control.ProID;
            entity.UserID           = control.UserID;
            entity.status           = control.Status;

            entities.ProjectControl_Table.Attach(entity);
            entities.Entry(entity).State = EntityState.Modified;
            entities.SaveChanges();
        }
        public void Createproject(ProjectControlViewModel control)
        {
            try
            {
                //  تم اضافة هذا الاستعلام لعدم تكرار المشروع للمستخدم
                var project = entities.ProjectControl_Table
                              .Single(i => i.UserID == control.UserID &&
                                      i.ProjectID == control.ProID);
                control.ID = 0;
            }
            catch (Exception)
            {
                var entity = new ProjectControl_Table();

                entity.ProjectID = control.ProID;
                entity.UserID    = control.UserID;
                entity.status    = control.Status;

                entities.ProjectControl_Table.Add(entity);
                entities.SaveChanges();

                control.ID = entity.ProjectControlID;
            }
        }