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