public async Task <IActionResult> SubjectList()
{
List <Subject_Teacher> ilIst = new List <Subject_Teacher>(); //Creiamo una lista di Materia_Professore
var listData = await(from emp in _context.Subject
join pro in _context.Teacher on emp.InsegnateId equals pro.InsegnateId
select new
{
emp.MateriaId,
emp.Denominazione,
emp.Crediti,
emp.Semestre,
emp.Anno,
pro.Nome,
pro.Cognome
}
).ToListAsync();
listData.ForEach(x =>
{
Subject_Teacher Obj = new Subject_Teacher();
Obj.MateriaId = x.MateriaId;
Obj.Denominazione = x.Denominazione;
Obj.Crediti = x.Crediti;
Obj.Semestre = x.Semestre;
Obj.Anno = x.Anno;
Obj.Nome = x.Nome;
Obj.Cognome = x.Cognome;
ilIst.Add(Obj);
});
return(Json(ilIst));
}
protected void Button1_Click1(object sender, EventArgs e)
{
Teachers teachers = new Teachers();
teachers.id = Request.QueryString["id"];
teachers.account = Label1.Text;
teachers.name = Label2.Text;
teachers.pwd = TextBox2.Text;
List <Subject_Teacher> list = new List <Subject_Teacher>();
Subject_Teacher subject_Teacher;
for (int i = 0; i < CheckBoxList1.Items.Count; i++)
{
if (CheckBoxList1.Items[i].Selected)
{
subject_Teacher = new Subject_Teacher();
subject_Teacher.subjectName = CheckBoxList1.Items[i].Value;
subject_Teacher.TeacherId = teachers.id;
list.Add(subject_Teacher);
}
}
// Response.Write(teachers.id);
if (list.Count > 0)
{
}
else
{
subject_Teacher = new Subject_Teacher();
subject_Teacher.TeacherId = teachers.id;
list.Add(subject_Teacher);
}
teacherDalServer.AddSubject_Teacher(list);
teacherDalServer.UpdateTeacherForDB(teachers);
Server.Transfer("TeacherManage.aspx");
}
