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