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 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 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 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 DataTable GetKid(int TestID)
{
string com = "select * from TestKid where TestID = " + TestID;
return(OLEDBHelper.GetTable(com));
}
public static DataTable GetAllParents()
{
string com = "select * from Parents";
return(OLEDBHelper.GetTable(com));
}
public static DataTable GetTest(string Theme)
{
string com = "select * from Tests where Theme = '" + Theme + "'";
return(OLEDBHelper.GetTable(com));
}
public static DataTable GetKid(int ParentID)
{
string com = "select * from ParentKid where ParentID = " + ParentID;
return(OLEDBHelper.GetTable(com));
}
