public IList <Position> GetUserPositions(List <int> list) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { IList <Position> positionlist = session.QueryOver <Position>().WhereRestrictionOn(x => x.Id_position).IsIn(list).List(); transaction.Commit(); return(positionlist); } } }
public IList <Task> GetUserTasks(User user) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { IList <Task> tasklist = session.QueryOver <Task>().Where(x => x.Id_user.Id_user == user.Id_user).List(); transaction.Commit(); return(tasklist); } } }
public void Delete <T>(T element) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { session.Delete(element); transaction.Commit(); } } }
public Position FindPositionById(int id) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { Position p = session.QueryOver <Position>().Where(x => x.Id_position == id).List().First(); transaction.Commit(); return(p); } } }
public Document GetDocumentByName(string name) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { Document doc = session.QueryOver <Document>().Where(x => x.Name.IsLike(name)).List().First(); transaction.Commit(); return(doc); } } }
public User GetUserById(int id) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { User user = session.QueryOver <User>().Where(x => x.Id_user == id).List().First(); transaction.Commit(); return(user); } } }
public IList <Task> GetTasksByPositionId(Position pos) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { IList <Task> user = session.QueryOver <Task>().Where(x => x.Id_position.Id_position == pos.Id_position).List(); transaction.Commit(); return(user); } } }
public Flow FindFlowById(int id) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { Flow f = session.QueryOver <Flow>().Where(x => x.id_flow == id).List().First(); transaction.Commit(); return(f); } } }
public IList <Attributes> GetAttributesByFlow(int id) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { IList <Attributes> list = session.QueryOver <Attributes>().Where(x => x.Id_workflow.id_flowDefinition == id).List(); transaction.Commit(); return(list); } } }
public IList <Flow> GetUserActiveFlows(Position position) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { IList <Flow> flows = session.QueryOver <Flow>().Where(f => f.id_position.Id_position == position.Id_position).List(); transaction.Commit(); return(flows); } } }
public Attributes FindAttributeByName(string name) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { Attributes attr = session.QueryOver <Attributes>().Where(x => x.Name.IsLike(name)).List().First(); transaction.Commit(); return(attr); } } }
public List <Attributes> GetTableAttributes(int id) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { var list = session.QueryOver <Attributes>().Where(x => x.Id_workflow.id_flowDefinition == id && x.Type == "Table" && x.Parent == null).List().ToList(); transaction.Commit(); return(list); } } }
public FlowExtension Flowextension(int id) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { FlowExtension fe = session.QueryOver <FlowExtension>().Where(x => x.id_attribute.Id_attribute == id).List().First(); transaction.Commit(); return(fe); } } }
public List <Attributes> GetChildsAttribute(int id) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { var list = session.QueryOver <Attributes>().Where(x => x.Parent.Id_attribute == id).List().ToList(); transaction.Commit(); return(list); } } }
public FlowDefinition GetFlowDefinition(int id) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { FlowDefinition flow = session.QueryOver <FlowDefinition>().Where(x => x.id_flowDefinition == id).List().First(); transaction.Commit(); return(flow); } } }
public IList <ListElement> GetAttributeList(int id) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { IList <ListElement> list = session.QueryOver <ListElement>().Where(x => x.Id_attribute.Id_attribute == id).List(); transaction.Commit(); return(list); } } }
public Document GetDocumentById(int id) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { Document doc = session.QueryOver <Document>().Where(x => x.Id_document == id).List().First(); transaction.Commit(); return(doc); } } }
public Position GetPositionidFlow(int id) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { Position positionlist = session.QueryOver <Position>().Where(x => x.Id_position == id).List().First(); transaction.Commit(); return(positionlist); } } }
public Attributes GetAttributeid(int id) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { Attributes positionlist = session.QueryOver <Attributes>().Where(x => x.Id_attribute == id).List().First(); transaction.Commit(); return(positionlist); } } }
public IList <T> GetList <T>() where T : class { IList <T> listposition = new List <T>(); using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { listposition = session.QueryOver <T>().List(); } } return(listposition); }
public List <int> GetUsersByPosition(int position) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { List <int> list = new List <int>(); IList <Task> tasks = session.QueryOver <Task>().Where(f => f.Id_position.Id_position == position).List(); foreach (Task t in tasks) { list.Add(t.Id_user.Id_user); } return(list); } } }
public List <FlowExtension> flowextensionAttributesTable(int id_flow, List <Attributes> attributes) { var keys = attributes.Select(x => x.Id_attribute).ToList(); using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { var list = session.QueryOver <FlowExtension>() .Where(x => x.id_flow.id_flow == id_flow) .And(Restrictions.On <FlowExtension>(y => y.id_attribute.Id_attribute).IsIn(keys)) //&& x.id_attribute.Id_attribute==id_attribute) .List().ToList(); transaction.Commit(); return(list); } } }
public Step FindStep(Position position) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { try { Step step = session.QueryOver <Step>().Where(x => x.Start_position_id.Id_position == position.Id_position).List().First(); transaction.Commit(); return(step); } catch (Exception e) { return(null); } } } }
public FlowExtension FindExtension(int id_flow, int id_attr) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { try { FlowExtension ext = session.QueryOver <FlowExtension>().Where(x => (x.id_attribute.Id_attribute == id_attr && x.id_flow.id_flow == id_flow)).List().First(); transaction.Commit(); return(ext); } catch (Exception e) { return(null); } } } }
public Step FindStepById(int id) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { try { Step step = session.QueryOver <Step>().Where(x => x.Id_step == id).List().First(); transaction.Commit(); return(step); } catch (Exception e) { return(null); } } } }
public Access GetAttributeAccess(int id_pos, int id_attr) { using (ISession session = InitNH.OppenSession()) { using (ITransaction transaction = session.BeginTransaction()) { Access acc = new Access(); try { acc = session.QueryOver <Access>().Where(x => (x.Id_attributes.Id_attribute == id_attr && x.Id_position.Id_position == id_pos)).List().First(); } catch (Exception e) { Console.Write(e); return(new Access()); } transaction.Commit(); return(acc); } } }