Exemple #1
0
 public List <Note> GetNotes()
 {
     using (var context = new OstContext())
     {
         return(context.Notes.ToList());
     }
 }
Exemple #2
0
 public List <Workflow> GetWorkflows()
 {
     using (var context = new OstContext())
     {
         List <Workflow> workflows = (from f in context.OSTForms.Where(x => x.EmployeeUserId != null)
                                      join w in context.Workflows.Where(x => x.StatusDescription == "Approved") on f.WorkflowId equals w.WorkflowId
                                      select w).ToList();
         return(workflows);
     }
 }
Exemple #3
0
 public List <WorkflowCategory> GetWorkflowCategories()
 {
     using (var context = new OstContext())
     {
         List <WorkflowCategory> workflowcategories = (from f in context.OSTForms.Where(x => x.EmployeeUserId != null)
                                                       join w in context.Workflows.Where(x => x.StatusDescription == "Approved") on f.WorkflowId equals w.WorkflowId
                                                       join wv in context.WorkflowVersions on w.WorkflowId equals wv.WorkflowId
                                                       join wc in context.WorkflowCategories on wv.WorkflowVersionId equals wc.WorkflowVersionId
                                                       select wc).ToList();
         return(workflowcategories);
     }
 }
Exemple #4
0
 public List <OstForm> GetOstForms()
 {
     {
         {
             using (var context = new OstContext())
             {
                 List <OstForm> ostForms = context.OSTForms.Where(x => x.EmployeeUserId != null).ToList();
                 return(ostForms);
             }
         }
     }
 }