public List <User> GetUsers() { using (var context = new CostaContext()) { return(context.Users.ToList()); } }
public int InsertNote(Note note) { using (var context = new CostaContext()) { context.Notes.Add(note); context.SaveChanges(); return(note.NoteId); } }
public void UpdateWorkflowVersion(int workflowVersionId, int newWorkflowStepId) { using (var context = new CostaContext()) { var std = context.WorkflowVersions.First(x => x.WorkflowVersionId == workflowVersionId); std.CurrentWorkflowStepId = newWorkflowStepId; context.SaveChanges(); } }
public int InsertWorkflowStep(WorkflowStep step) { using (var context = new CostaContext()) { context.WorkflowSteps.Add(step); context.SaveChanges(); return(step.WorkflowStepId); } }
public int InsertWorkflowCategory(WorkflowCategory workflowcategory) { using (var context = new CostaContext()) { context.WorkflowCategories.Add(workflowcategory); context.SaveChanges(); return(workflowcategory.WorkflowCategoryId); } }
public int InsertWorkflowVersion(WorkflowVersion item) { using (var context = new CostaContext()) { context.WorkflowVersions.Add(item); context.SaveChanges(); return(item.WorkflowVersionId); } }
public int InsertForm(COSTAForm item) { using (var context = new CostaContext()) { context.OSTForms.Add(item); context.SaveChanges(); return(item.OSTFormId); } }
public int InsertWorkflowDocument(WorkflowDocument workflowdocument) { using (var context = new CostaContext()) { context.WorkflowDocuments.Add(workflowdocument); context.SaveChanges(); return(workflowdocument.WorkflowDocumentId); } }
public List <Workflow> GetWorkflows() { { using (var context = new CostaContext()) { List <Workflow> workflows = (from f in context.OSTForms.Where(x => x.DepartmentTypeId == 1) join w in context.Workflows on f.WorkflowId equals w.WorkflowId select w).ToList(); return(workflows); } } }