/* 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();
}
