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 GetMorim()
{
string x = string.Format("SELECT id, FirstName, LastName FROM tblMorimProject");
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 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 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 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 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 GetIdAndName()
{
string x = string.Format("select id, FirstName, LastName from tblMorimProject");
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 void AddMorim(string id, string shem, string lastshem, string address, string num1, string num2)
{
string x = string.Format("insert into tblMorimProject(id, FirstName, LastName, Address, Num1,Num2) values ('{0}','{1}','{2}','{3}','{4}','{5}')", id, shem, lastshem, address, num1, num2);
//MessageBox.Show(x);
DataSherut.ExecuteNonQuery(x);
}
public void Update(string tz, string firstname, string lastname, string address, string num1, string num2)
{
string x = string.Format("update tblMorimProject set firstname='{1}', lastname='{2}', address='{3}', Num1='{4}', Num2='{5}' where id='{0}' ", tz, firstname, lastname, address, num1, num2);
//MessageBox.Show(x);
DataSherut.ExecuteNonQuery(x);
}
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 void Update(string kod, string shem)
{
string x = string.Format("update tbllevelsproject set rama='{0}' where Code= {1}", shem, kod);
//MessageBox.Show(x);
DataSherut.ExecuteNonQuery(x);
}
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 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 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 void AddStudent(string id, string shem, string lastshem, string bday, string num1, string num2, string address)
{
string x = string.Format("insert into tblStudents(tz, shem, mish, yom, mobile_telephone, home_telephone, ktovet) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", id, shem, lastshem, bday, num1, num2, address);
//MessageBox.Show(x);
DataSherut.ExecuteNonQuery(x);
}
public DataTable GetMikzoot()
{
string x = string.Format("select mikCode, mikName from tblMikProject");
DataSet ds = DataSherut.GetDataSet(x);
return(ds.Tables[0]);
}
public void Update(string tz, string firstname, string lastname, string bday, string num1, string num2, string address)
{
string x = string.Format("update tblStudents set shem='{1}', mish='{2}', yom='{3}', mobile_telephone='{4}', home_telephone='{5}',ktovet='{6}' where tz='{0}' ", tz, firstname, lastname, bday, num1, num2, address);
//MessageBox.Show(x);
DataSherut.ExecuteNonQuery(x);
}
public DataTable GetKita()
{
string x = string.Format("select Code, class from tblagesproject");
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 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 GetLevels()
{
string x = string.Format("select Code, rama from tblLevelsProject");
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 void Delete(string kod)
{
string x = string.Format("delete * from tblLesson where kod= {0}", kod);
DataSherut.ExecuteNonQuery(x);
}
public void AddLessons(string teacher, string student, int mik, int kita, int level, string date, int start, int end, string notes)
{
string x = string.Format("insert into tblLesson(teacher_id,student_id,kod_mik,kod_kita,kod_level,due_date,start_time,end_time,notes) values ('{0}','{1}',{2},{3},{4},'{5}',{6},{7},'{8}')", teacher, student, mik, kita, level, date, start, end, notes);
DataSherut.ExecuteNonQuery(x);
}
public void Update(string kod, string shem)
{
string x = string.Format("update tblagesproject set class='{0}' where Code= {1}", shem, kod);
DataSherut.ExecuteNonQuery(x);
}
public void Delete(string kod)
{
string x = string.Format("delete code from tblagesproject where Code= {0}", kod);
DataSherut.ExecuteNonQuery(x);
}