private String BuildInsertCommand1(ClassSubjects classSUbObj) // שלב 1 - נעביר את כל המערך לדטה בייס //POST // - לא קבוע ! מפרק את המידע ויוצר שאילתה { ////עובר שורה שורה String command; StringBuilder sb = new StringBuilder(); // use a string builder to create the dynamic string sb.AppendFormat("Values('{0}','{1}','{2}','{3}','{4}','{5}')", classSUbObj.Name, classSUbObj.Number, classSUbObj.ClassType, classSUbObj.Profession, classSUbObj.Id_teacher, classSUbObj.Teacher_name); // לפי האובייקט במחלקה String prefix = "INSERT INTO classProfession" + "(ClassName,ClassNum,ClassType,Profession,Id_teacher,Teacher_name)"; // לפי העמודות בSQL command = prefix + sb.ToString(); return(command); }
public List <ClassSubjects> getCSFromDB(string name, string num) { //יצירת רשימה לשמירת הנתונים List <ClassSubjects> listClassSubj = new List <ClassSubjects>(); SqlConnection con = null; //שורה קבועה try { //שורה קבועה con = connect("DBConnectionString"); // create a connection to the database using the connection String defined in the web config file String selectSTR = $@"SELECT * FROM classProfession where ClassName = '{name}' and ClassNum='{num}'"; //שורה קבועה SqlCommand cmd = new SqlCommand(selectSTR, con); //קורא שורה סוגר וככה הלאה //שורה קבועה SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) {// Read till the end of the data into a row ClassSubjects CS = new ClassSubjects(); CS.Name = (string)dr["className"]; CS.Number = (string)dr["classNum"]; CS.Profession = (string)dr["Profession"]; listClassSubj.Add(CS); } } catch (Exception ex) { throw (ex); } finally { if (con != null) { con.Close(); } } return(listClassSubj); // מחזיר מערך }
public void Add() { if (GroupIndex >= 0) { var gAndS = GroupsAndSubjects[GroupIndex]; var context = new GroupsAndSubjectsVM(ClassSubjects.ToArray()); var wind = new NewGroupsAndSubjects() { DataContext = context }; wind.ShowDialog(); if (wind.DialogResult == true) { bool exist = false; foreach (var value in gAndS.InformationAboutSubjects) { if (value.Subject.CodeOfSubject == context.InformationAboutSubjects.Subject.CodeOfSubject) { exist = true; MessageBox.Show("Такой предмет уже есть! Добавьте тот предмет которого ещё нету в списке", "Ошибка добавления предмета"); break; } } if ((context.InformationAboutSubjects != null) && (exist == false)) { var items = gAndS.InformationAboutSubjects.Append(context.InformationAboutSubjects).ToArray(); foreach (var item in items) { if (RequestToDataBase.Instance.requestInsertIntoGroupsAndSubjects(gAndS, item)) { RefreshGroupsAndSubjects(); } } } } } }
public void Post([FromBody] List <ClassSubjects> classSUbObj) { ClassSubjects C = new ClassSubjects(); C.insertClassSub(classSUbObj); }
public int deleteTask(string class1, string numClass, string sub, int num) //מורה { ClassSubjects C = new ClassSubjects(); return(C.deleteTaskGroup(class1, numClass, sub, num)); }
public DataTable DeleteTeachFromCS(int TeacherId, string TeacherSubj) //מורה { ClassSubjects CS = new ClassSubjects(); return(CS.deleteT_CS(TeacherId, TeacherSubj)); }
public List <ClassSubjects> GetCS(string name, string num) { ClassSubjects CS = new ClassSubjects(); return(CS.ReadCS(name, num)); // Read from Models/Counrty }
public DataTable GetClass(int id) { ClassSubjects C = new ClassSubjects(); return(C.tacherClass(id)); }
public List <ClassSubjects> get_proff(int teachrID) { ClassSubjects CS = new ClassSubjects(); return(CS.ReadCS_Teacher(teachrID)); // Read from Models/Counrty }
public List <ClassSubjects> GetCS(string name, string num, int teachrID) { ClassSubjects CS = new ClassSubjects(); return(CS.ReadCSTeacher(name, num, teachrID)); // Read from Models/Counrty }
public void Edit() { if (GroupIndex >= 0 && SubjectIndex >= 0) { var gAndS = GroupsAndSubjects[GroupIndex]; var context = new GroupsAndSubjectsVM(gAndS.InformationAboutSubjects[SubjectIndex], ClassSubjects.ToArray()); var wind = new NewGroupsAndSubjects() { DataContext = context }; wind.GAS.IsEnabled = false; wind.ShowDialog(); if (wind.DialogResult == true) { if ((context.InformationAboutSubjects != null)) { gAndS.InformationAboutSubjects[SubjectIndex] = context.InformationAboutSubjects; if (RequestToDataBase.Instance.requestUpdateGroupsAndSubjects(gAndS, gAndS.InformationAboutSubjects[SubjectIndex])) { RefreshGroupsAndSubjects(); } } } } }