コード例 #1
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]);
        }
コード例 #2
0
        public DataTable GetMorim()
        {
            string  x  = string.Format("SELECT id, FirstName, LastName FROM tblMorimProject");
            DataSet ds = DataSherut.GetDataSet(x);

            return(ds.Tables[0]);
        }
コード例 #3
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]);
        }
コード例 #4
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]);
        }
コード例 #5
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]);
        }
コード例 #6
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]);
        }
コード例 #7
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]);
        }
コード例 #8
0
        public DataTable GetIdAndName()
        {
            string  x  = string.Format("select id, FirstName, LastName from tblMorimProject");
            DataSet ds = DataSherut.GetDataSet(x);

            return(ds.Tables[0]);
        }
コード例 #9
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]);
        }
コード例 #10
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);
        }
コード例 #11
0
        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);
        }
コード例 #12
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]);
        }
コード例 #13
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]);
        }
コード例 #14
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);
        }
コード例 #15
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]);
        }
コード例 #16
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]);
        }
コード例 #17
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]);
        }
コード例 #18
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);
        }
コード例 #19
0
        public DataTable GetMikzoot()
        {
            string  x  = string.Format("select mikCode, mikName from tblMikProject");
            DataSet ds = DataSherut.GetDataSet(x);

            return(ds.Tables[0]);
        }
コード例 #20
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);
        }
コード例 #21
0
        public DataTable GetKita()
        {
            string  x  = string.Format("select Code, class from tblagesproject");
            DataSet ds = DataSherut.GetDataSet(x);

            return(ds.Tables[0]);
        }
コード例 #22
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]);
        }
コード例 #23
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]);
        }
コード例 #24
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]);
        }
コード例 #25
0
        public DataTable GetLevels()
        {
            string  x  = string.Format("select Code, rama from tblLevelsProject");
            DataSet ds = DataSherut.GetDataSet(x);

            return(ds.Tables[0]);
        }
コード例 #26
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]);
        }
コード例 #27
0
        public void Delete(string kod)
        {
            string x = string.Format("delete * from tblLesson where kod= {0}", kod);

            DataSherut.ExecuteNonQuery(x);
        }
コード例 #28
0
        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);
        }
コード例 #29
0
        public void Update(string kod, string shem)
        {
            string x = string.Format("update tblagesproject set class='{0}' where Code= {1}", shem, kod);

            DataSherut.ExecuteNonQuery(x);
        }
コード例 #30
0
        public void Delete(string kod)
        {
            string x = string.Format("delete code from tblagesproject where Code= {0}", kod);

            DataSherut.ExecuteNonQuery(x);
        }