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