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 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 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 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 void AddKita(string shem)
{
string x = string.Format("insert into tblagesproject(class) values ('{0}')", shem);
DataSherut.ExecuteNonQuery(x);
}
public void Update(string kod, string shem)
{
string x = string.Format("update tblMikProject set mikName='{0}' where mikCode= {1}", shem, kod);
DataSherut.ExecuteNonQuery(x);
}
public void AddMikzoa(string shem)
{
string x = string.Format("insert into tblMikProject(mikname) values ('{0}')", shem);
DataSherut.ExecuteNonQuery(x);
}
public void Delete(string id, int yom, int shaa)
{
string x = string.Format("delete * from tblPanuiProject where id='{0}' and yom={1} and shaa={2}", id, yom, shaa);
DataSherut.ExecuteNonQuery(x);
}
public void Add(string id, int yom, int shaa)
{
string x = string.Format("insert into tblPanuiProject(id, yom, shaa) values ('{0}', {1}, {2})", id, yom, shaa);
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 DeleteButton(string tz)
{
string x = string.Format("delete * from tblMorimProject where id= '{0}'", tz);
DataSherut.ExecuteNonQuery(x);
}
public void AddCanTeachProject(int kitaCode, int levelCode, int mikCode, string id)
{
string x = string.Format("insert into tblCanTeachProject(id,MikCode,LevelCode,KitaCode) values ('{0}', {1},{2},{3})", id, mikCode, levelCode, kitaCode);
DataSherut.ExecuteNonQuery(x);
}
public void DeleteCanTeach(int kitaCode, int levelCode, int mikCode, string id)
{
string x = string.Format("delete * from tblCanTeachProject where MikCode= {0} and LevelCode={1} and KitaCode={2} and id='{3}'", mikCode, levelCode, kitaCode, id);
DataSherut.ExecuteNonQuery(x);
}
public void Delete(string kod)
{
string x = string.Format("delete code from tblagesproject where Code= {0}", kod);
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 tz)
{
string x = string.Format("delete * from tblStudents where tz= '{0}'", tz);
DataSherut.ExecuteNonQuery(x);
}
public void Delete(string kod)
{
string x = string.Format("delete * from tblLesson where kod= {0}", kod);
DataSherut.ExecuteNonQuery(x);
}
public void AddLevel(string shem)
{
string x = string.Format("insert into tblLevelsProject(rama) values ('{0}')", shem);
DataSherut.ExecuteNonQuery(x);
}
