상속: DbContext
예제 #1
0
        public static void fullyDeletePD_Process(PDesignerDb db, int PD_ProcessId)
        {
            var messages = db.PD_Messages.Where(r => r.PD_Process_Id == PD_ProcessId);

            db.PD_Messages.RemoveRange(messages);

            var messageTypes = db.PD_MessageTypes.Where(r => r.PD_Process_Id == PD_ProcessId);

            db.PD_MessageTypes.RemoveRange(messageTypes);

            var transitions = db.PD_Transitions.Where(r => r.PD_Process_Id == PD_ProcessId);

            db.PD_Transitions.RemoveRange(transitions);

            var states = db.PD_States.Where(r => r.PD_Process_Id == PD_ProcessId);

            db.PD_States.RemoveRange(states);

            var subjects = db.PD_Subjects.Where(r => r.PD_Process_Id == PD_ProcessId);

            db.PD_Subjects.RemoveRange(subjects);

            var process = db.PD_Processes.Find(PD_ProcessId);

            db.PD_Processes.Remove(process);

            db.SaveChanges();
        }
예제 #2
0
 public static int getTransitionId(PDesignerDb db, int PD_ProcessId, int PD_SubjectId)
 {
     try
     {
         int max = db.PD_Subjects.Find(PD_ProcessId, PD_SubjectId).Transitions.Max(r => r.Id);
         return max +1;
     }
     catch (Exception e)
     {
         return 1;
     }
 }
예제 #3
0
 public static int getMessageId(PDesignerDb db, int PD_ProcessId)
 {
     try
     {
         int max = db.PD_Processes.Find(PD_ProcessId).Messages.Max(r => r.Id);
         return max + 1;
     }
     catch (Exception e)
     {
         return 1;
     }
 }
예제 #4
0
 public static int getTransitionId(PDesignerDb db, int PD_ProcessId, int PD_SubjectId)
 {
     try
     {
         int max = db.PD_Subjects.Find(PD_ProcessId, PD_SubjectId).Transitions.Max(r => r.Id);
         return(max + 1);
     }
     catch (Exception e)
     {
         return(1);
     }
 }
예제 #5
0
 public static int getMessageId(PDesignerDb db, int PD_ProcessId)
 {
     try
     {
         int max = db.PD_Processes.Find(PD_ProcessId).Messages.Max(r => r.Id);
         return(max + 1);
     }
     catch (Exception e)
     {
         return(1);
     }
 }
예제 #6
0
        public static void fullyDeletePD_Process(PDesignerDb db ,int PD_ProcessId)
        {
            var messages = db.PD_Messages.Where(r => r.PD_Process_Id == PD_ProcessId);
            db.PD_Messages.RemoveRange(messages);

            var messageTypes = db.PD_MessageTypes.Where(r => r.PD_Process_Id == PD_ProcessId);
            db.PD_MessageTypes.RemoveRange(messageTypes);

            var transitions = db.PD_Transitions.Where(r => r.PD_Process_Id == PD_ProcessId);
            db.PD_Transitions.RemoveRange(transitions);

            var states = db.PD_States.Where(r => r.PD_Process_Id == PD_ProcessId);
            db.PD_States.RemoveRange(states);

            var subjects = db.PD_Subjects.Where(r => r.PD_Process_Id == PD_ProcessId);
            db.PD_Subjects.RemoveRange(subjects);

            var process = db.PD_Processes.Find(PD_ProcessId);
            db.PD_Processes.Remove(process);

            db.SaveChanges();
            
        }