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]); }