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