public DataTable GetPanuiForDay(int day, string id)
{
string x = string.Format("select shaa from tblPanuiProject where yom={0} and id='{1}'", day, id);
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetMikzoot()
{
string x = string.Format("select mikCode, mikName from tblMikProject");
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetLessonTimeDetailsForTeacher(string id)
{
string x = string.Format("SELECT due_date,start_time,end_time FROM tblLesson where teacher_id='{0}' ", id);
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetPanui(string tz)
{
string x = string.Format("select yom, shaa from tblPanuiProject where id='{0}'", tz);
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetLessonsByStudentId(string id)
{
string x = string.Format("SELECT * from tblLesson where student_id='{0}' ", id);
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetLevelByCode(string code)
{
string x = string.Format("select rama from tblLevelsProject where Code ={0}", code);
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetStudentsByID(string tz)
{
string x = string.Format("select tz, shem, mish from tblStudents where tz='{0}'", tz);
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetKitaByCode(string code)
{
string x = string.Format("select class from tblagesproject where code= {0}", code);
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetNameById(string id)
{
string x = string.Format("select FirstName, LastName from tblMorimProject where id='{0}'", id);
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetStudents()
{
string x = string.Format("select tz, shem, mish, yom, mobile_telephone, home_telephone, ktovet from tblStudents");
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetIdAndName()
{
string x = string.Format("select id, FirstName, LastName from tblMorimProject");
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetMorim()
{
string x = string.Format("select id, FirstName, LastName, Address, Num1, Num2 from tblMorimProject");
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetAll(string id)
{
string x = string.Format("SELECT tblCanTeachProject.MikCode, tblCanTeachProject.LevelCode, tblCanTeachProject.KitaCode FROM (tblMorimProject INNER JOIN tblCanTeachProject ON tblCanTeachProject.id = tblMorimProject.id) where tblMorimProject.id='{0}'", id);
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetMikByCode(string code)
{
string x = string.Format("select mikName from tblMikProject where mikCode={0}", code);
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetMorim()
{
string x = string.Format("SELECT id, FirstName, LastName FROM tblMorimProject");
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetKita()
{
string x = string.Format("select Code, class from tblagesproject");
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetLessonsByTeacherIdAndDate(string id, string due)
{
string x = string.Format("SELECT * from tblLesson where teacher_id='{0}' and due_date='{1}' ", id, due);
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetLessonsTeachersStudentId()
{
string x = string.Format("SELECT teacher_id , student_id, due_date from tblLesson");
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetMorim(int MikCode, int LevelCode, int KitaCode)
{
string x = string.Format("SELECT tblMorimProject.id, tblMorimProject.FirstName, tblMorimProject.LastName FROM (tblCanTeachProject INNER JOIN tblMorimProject ON tblCanTeachProject.id = tblMorimProject.id) where tblCanTeachProject.MikCode = {0} and tblCanTeachProject.LevelCode = {1} and tblCanTeachProject.KitaCode = {2}", MikCode, LevelCode, KitaCode);
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetLessonsByString(string field, string value)
{
string x = string.Format("SELECT * from tblLesson where {0} = {1} ", field, value);
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public DataTable GetLevels()
{
string x = string.Format("select Code, rama from tblLevelsProject");
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
