/* GET ALL */ public static List <SchoolYear> ShowAll() { var client = ConnectNeo4J.Connection(); List <SchoolYear> list_school_year = client.Cypher.Match("(year:School_Year)").Return <SchoolYear>("year").Results.ToList(); return(list_school_year); }
/* SEARCH */ public static Student Find(string Id) { var client = ConnectNeo4J.Connection(); var lop = client.Cypher.Match("(a:Student)").Where("a.id = {ID}").WithParam("ID", Id).Return <Student>("a").Results.SingleOrDefault(); return(lop); }
/* GET ALL */ public static List <Student> GetAll() { var client = ConnectNeo4J.Connection(); var lop = client.Cypher.Match("(n:Student)").Return <Student>("n").Results.ToList(); return(lop); }
/* UPDATE */ //public static void Update_Year_Term(int Year_Term, string Day_Start, string Day_End) //{ // var client = ConnectNeo4J.Connection(); // var term = new YearTerm { day_start = Day_Start, day_end = Day_End }; // client.Cypher.Match("(a:Year_Term)") // .Where((YearTerm item) => item.id == Id) // .Set("a = {tmp}") // .WithParam("tmp", term) // .ExecuteWithoutResultsAsync(); //} /* SEARCH */ public static List <YearTerm> Find(int Id) { var client = ConnectNeo4J.Connection(); var term = client.Cypher.Match("(a:YearTerm)").Where("a.year_term = {ID}").WithParam("ID", Id).Return <YearTerm>("a").Results.ToList(); return(term); }
/* SEARCH */ //public static RegSectorSubject Find(string Id) //{ // var client = ConnectNeo4J.Connection(); // var term = client.Cypher.Match("(a:RegSectorSubject)").Where("a.id = {ID}").WithParam("ID", Id).Return<RegSectorSubject>("a").Results.SingleOrDefault(); // return term; //} /* GET ALL */ public static List <RegSectorSubject> GetAll() { var client = ConnectNeo4J.Connection(); var term = client.Cypher.Match("(a:RegSectorSubject)").Return <RegSectorSubject>("a").Results.ToList(); return(term); }
/* SEARCH */ public static Specialized Find(string Id) { var client = ConnectNeo4J.Connection(); var term = client.Cypher.Match("(a:Specialized)").Where("a.id = {ID}").WithParam("ID", Id).Return <Specialized>("a").Results.SingleOrDefault(); return(term); }
public static List <Specialized> GetAll() { var client = ConnectNeo4J.Connection(); var tmp = client.Cypher.Match("(a:Specialized)").Return <Specialized>("a").Results.ToList(); return(tmp); }
/* GET ALL */ public static List <News> ShowAll() { var client = ConnectNeo4J.Connection(); var lop = client.Cypher.Match("(n:News)").Return <News>("n").Results.ToList(); return(lop); }
public static List <Class> GetAll() { var client = ConnectNeo4J.Connection(); var tmp = client.Cypher.Match("(a:Class)").Return <Class>("a").Results.ToList(); return(tmp); }
/* SEARCH */ public static SectorSubject Find(int Id) { var client = ConnectNeo4J.Connection(); var term = client.Cypher.Match("(a:Sector_Subject)").Where("a.numb_student = {ID}").WithParam("ID", Id).Return <SectorSubject>("a").Results.SingleOrDefault(); return(term); }
/* SEARCH */ public static News Find(string Title) { var client = ConnectNeo4J.Connection(); var lop = client.Cypher.Match("(a:News)").Where("a.title = {ID}").WithParam("ID", Title).Return <News>("a").Results.SingleOrDefault(); return(lop); }
/* SEARCH */ public static Major Find(string Id) { var client = ConnectNeo4J.Connection(); var term = client.Cypher.Match("(a:Major)").Where("a.name = {ID}").WithParam("ID", Id).Return <Major>("a").Results.SingleOrDefault(); return(term); }
/* GET ALL */ public static List <Graduate> ShowAll() { var client = ConnectNeo4J.Connection(); var graduate = client.Cypher.Match("(a:Graduate)").Return <Graduate>("a").Results.ToList(); return(graduate); }
/* SEARCH */ public static Graduate Find(string Id) { var client = ConnectNeo4J.Connection(); var graduate = client.Cypher.Match("(a:Graduate)").Where("a.id = {ID}").WithParam("ID", Id).Return <Graduate>("a").Results.SingleOrDefault(); return(graduate); }
/* SEARCH */ public static Degree Find(int Id) { var client = ConnectNeo4J.Connection(); var degree = client.Cypher.Match("(a:Degree)").Where("a.id = {ID}").WithParam("ID", Id).Return <Degree>("a").Results.SingleOrDefault(); return(degree); }
/* GET ALL */ public static List <YearTerm> GetAll() { var client = ConnectNeo4J.Connection(); var term = client.Cypher.Match("(a:YearTerm)").Return <YearTerm>("a").Results.ToList(); return(term); }
/* GET ALL */ public static List <Rule3> ShowAll() { var client = ConnectNeo4J.Connection(); var term = client.Cypher.Match("(a:Rule_3)").Return <Rule3>("a").Results.ToList(); return(term); }
/* SEARCH */ public static Rule3 Find(int Id) { var client = ConnectNeo4J.Connection(); var term = client.Cypher.Match("(a:Rule_3)").Where("a.id = {ID}").WithParam("ID", Id).Return <Rule3>("a").Results.SingleOrDefault(); return(term); }
/* GET ALL */ public static List <Degree> ShowAll() { var client = ConnectNeo4J.Connection(); var degree = client.Cypher.Match("(a:Degree)").Return <Degree>("a").Results.ToList(); return(degree); }
/* CREATE */ public static void Regist_Subject(string Id_Subject, string Id_Class, string Id_Teacher) { var client = ConnectNeo4J.Connection(); var mh = new RegisterSubject { id_subject = Id_Subject, id_class = Id_Class, id_teacher = Id_Teacher }; client.Cypher.Create("(:RegisterSubject {mh})").WithParam("mh", mh).ExecuteWithoutResultsAsync().Wait(); /* relation between subject -> register */ client.Cypher.Match("(a:Subject)", "(b:RegisterSubject)"). Where((Subject a) => a.id == Id_Subject). AndWhere((RegisterSubject b) => b.id_subject == Id_Subject && b.id_class == Id_Class). Create("(a)-[:Subject_Regist]->(b)").ExecuteWithoutResults(); /* relation between teacher -> register */ client.Cypher.Match("(a:Teacher)", "(b:RegisterSubject)"). Where((Teacher a) => a.id == Id_Teacher). AndWhere((RegisterSubject b) => b.id_teacher == Id_Teacher). Create("(a)<-[:Teacher_Subject]-(b)").ExecuteWithoutResults(); /* relation between class -> register */ client.Cypher.Match("(a:Class)", "(b:RegisterSubject)"). Where((Class a) => a.id == Id_Class). AndWhere((RegisterSubject b) => b.id_class == Id_Class). Create("(a)-[:Class_Regist]->(b)").ExecuteWithoutResults(); client.Dispose(); }
public static int CountUser() { var client = ConnectNeo4J.Connection(); var cnt = client.Cypher.Match("(a:User)").Return <int>("count(a)").Results.FirstOrDefault <int>(); return(cnt); }
/* GET ALL */ public static List <User> GetAll() { var client = ConnectNeo4J.Connection(); List <User> tmp = client.Cypher.Match("(user:User)").Return <User>("user").Results.ToList(); return(tmp); }
public static User CheckLogin(string Id_Number, string Password) { User user = null; var client = ConnectNeo4J.Connection(); user = client.Cypher.Match("(a:User)").Where("a.id_number = {ID}").WithParam("ID", Id_Number).AndWhere("a.password = {Pass}").WithParam("Pass", MD5Hash(Password)).Return <User>("a").Results.SingleOrDefault(); return(user); }
/* SEARCH */ public static User Find(string Id_Number) { var client = ConnectNeo4J.Connection(); var tmp = client.Cypher.Match("(user:User)") .Where("user.id_number = {ID}").WithParam("ID", Id_Number).Return <User>("user").Results.SingleOrDefault(); return(tmp); }
/* SEARCH */ public static SchoolYear Find(int Id) { var client = ConnectNeo4J.Connection(); var tmp = client.Cypher.Match("(year:School_Year)") .Where("year.school_year = {ID}").WithParam("ID", Id).Return <SchoolYear>("year").Results.SingleOrDefault(); return(tmp); }
/* CREATE */ public static void Add_Rule_2(int Id, int Term_In_Year, int Min_Student, int Max_Student) { var client = ConnectNeo4J.Connection(); var rule = new Rule2 { id = Id, term_in_year = Term_In_Year, min_students = Min_Student, max_students = Max_Student, isDelete = false }; client.Cypher.Create("(:Rule_2 {rule})").WithParam("rule", rule).ExecuteWithoutResultsAsync().Wait(); }
/* CREATE */ public static void Add_User(string Id_Number, string Sub_Name, string Name, string Password, string Role) { var client = ConnectNeo4J.Connection(); var user = new User { id_number = Id_Number, sub_name = Sub_Name, name = Name, password = MD5Hash(Password), status = "none", role = Role, isDelete = false }; client.Cypher.Create("(:User {user})").WithParam("user", user).ExecuteWithoutResultsAsync().Wait(); }
/* SEARCH*/ public static RegisterSubject Find(string Id_subject, string Id_Class) { var client = ConnectNeo4J.Connection(); var tmp = client.Cypher.Match("(a:Registersubject)"). Where((RegisterSubject a) => a.id_subject == Id_subject && a.id_class == Id_Class).Return <RegisterSubject>("a").Results.FirstOrDefault(); client.Dispose(); return(tmp); }
/* CREATE */ public static void Add_Degree(int Id, string Name) { var client = ConnectNeo4J.Connection(); var degree = new Degree { id = Id, name = Name, isDelete = false }; client.Cypher.Create("(:Degree {degree})").WithParam("degree", degree).ExecuteWithoutResultsAsync().Wait(); }
/* CREATE */ public static void Add_Rule_3(int Id, int Max_Subject) { var client = ConnectNeo4J.Connection(); var rule = new Rule3 { id = Id, max_subject = Max_Subject, isDelete = false }; client.Cypher.Create("(:Rule_3 {rule})").WithParam("rule", rule).ExecuteWithoutResultsAsync().Wait(); }