public static DataTable GetallHebrew(int KidId) { string com = "SELECT KidsID as [תז של הילד], KidsName as [שם הילד], KidsLast as [שם משפחה], TestDate as [תאריך השלמת המשחק], Theme as [נושא המשחק], TestResult as [(תוצאה (מתוך 100] from KidDidTest WHERE KidsID = " + KidId + " AND Theme = 'Hebrew' ORDER BY TestDate DESC"; DataTable dt = OLEDBHelper.GetTable(com); return(dt); }
public static int GetKidId(int ParentID) { string com = "select * from ParentKid where ParentsID = " + ParentID; DataTable dt = OLEDBHelper.GetTable(com); DataRow dr = dt.Rows[0]; return(int.Parse(dr["KidsID"].ToString())); }
public static DataTable AllKidsName(int ParentID) { string com = "SELECT ParentKid.ParentsID, Kids.KidsID, Kids.KidsName FROM Kids INNER JOIN ParentKid ON Kids.KidsID = ParentKid.KidsID WHERE ParentKid.ParentsID = " + ParentID; DataTable dt = OLEDBHelper.GetTable(com); return(dt); }
public static int HowMuch(int ParentID) { string com = "select * from ParentKid where ParentsID = " + ParentID; DataTable dt = OLEDBHelper.GetTable(com); return(dt.Rows.Count); }
public static void GetInfo(int KidId) { string s = "SELECT * from KidDidTest WHERE KidsID = " + KidId + ""; ; DataTable dt = OLEDBHelper.GetTable(s); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; dr["KidsName"].ToString(); } }
public static bool checkID(int KidsID) { string s = "SELECT * from Kids WHERE KidsID = " + KidsID + ""; DataTable dt = OLEDBHelper.GetTable(s); if (dt.Rows.Count > 0) { return(true); } else { return(false); } }
public static bool check(string ParentsName, int ParentsID) { string s = "SELECT * from Parents WHERE ParentsName = '" + ParentsName + "' AND ParentsID = " + ParentsID + ""; DataTable dt = OLEDBHelper.GetTable(s); if (dt.Rows.Count > 0) { return(true); } else { return(false); } }
public static string FindKid(int KidsID) { string s = "SELECT * from Kids WHERE KidsID = " + KidsID + ""; DataTable dt = OLEDBHelper.GetTable(s); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; return(dr["KidsName"].ToString()); } else { return(""); } }
public static void AddParentKid(int ParentsID, int KidsID) { string com = "insert into ParentKid (ParentsID , KidsID) VALUES ('" + ParentsID + "' , '" + KidsID + "')"; OLEDBHelper.Execute(com); }
public static void AddTest(string Theme) { string com = "insert into Tests (Theme) VALUES ('" + Theme + "')"; OLEDBHelper.Execute(com); }
public static DataTable GetKid(int TestID) { string com = "select * from TestKid where TestID = " + TestID; return(OLEDBHelper.GetTable(com)); }
public static void DeleteTestKid(int KidsID) { string com = "Delete From TestKid where KidsID = " + KidsID; OLEDBHelper.Execute(com); }
public static void AddTestKid(int KidsID, int TestID, int TestResult) { string com = "insert into TestKid (KidsID , TestID, TestResult, TestDate) VALUES ('" + KidsID + "' , '" + TestID + "', " + TestResult + ", '" + DateTime.Today.ToString("dd/MM/yyyy") + "')"; OLEDBHelper.Execute(com); }
public static void DeleteParent(int ParentsID) { string com = "Delete From Parents where ParentsID =" + ParentsID; OLEDBHelper.Execute(com); }
public static void UpdateParent(int ParentsID, string ParentsName, string ParentsLast) { string com = "update Parents set ParentsName = '" + ParentsName + "' , ParentsLast = '" + ParentsLast + "' where ParentsID=" + ParentsID; OLEDBHelper.Execute(com); }
public static DataTable GetAllParents() { string com = "select * from Parents"; return(OLEDBHelper.GetTable(com)); }
public static void AddParent(int ParentsID, string ParentsName, string ParentsLast) { string com = "insert into Parents (ParentsID , ParentsName , ParentsLast) VALUES ('" + ParentsID + "', '" + ParentsName + "' , '" + ParentsLast + "')"; OLEDBHelper.Execute(com); }
public static DataTable GetKid(int ParentID) { string com = "select * from ParentKid where ParentID = " + ParentID; return(OLEDBHelper.GetTable(com)); }
public static void UpdateKid(int KidsID, string KidsName, string KidsLast) { string com = "update Kids set KidsName = '" + KidsName + "' , KidsLast = '" + KidsLast + "' where KidsID=" + KidsID; OLEDBHelper.Execute(com); }
public static void AddKid(int KidsID, string KidsName, string KidsLast) { string com = "insert into Kids (KidsID , KidsName , KidsLast) VALUES ('" + KidsID + "', '" + KidsName + "' , '" + KidsLast + "')"; OLEDBHelper.Execute(com); }
public static DataTable GetTest(string Theme) { string com = "select * from Tests where Theme = '" + Theme + "'"; return(OLEDBHelper.GetTable(com)); }
public static void DeleteTest(string Theme) { string com = "Delete From Tests where Theme = '" + Theme + "'"; OLEDBHelper.Execute(com); }