protected void AssignStudent(object sender, EventArgs e) { Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('AssignStudentClass')", true); if (Page.IsValid) { DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.personalInfo t1 = new Entities.personalInfo() { pKId = Session["School"].ToString(), }; Entities.StudentSubject t2 = new Entities.StudentSubject() { pKId = SchoolID.Value, year = Year.Text, }; Entities.Class c1 = new Entities.Class() { className = DropDownList1.SelectedValue, }; Entities.Section s1 = new Entities.Section() { sectionName = DropDownList2.SelectedValue, }; db.AssignStudentClass(t1, t2, c1, s1); SqlDataSource6.DataBind(); GridView1.DataBind(); } }
public void InsertStudentGrade(Entities.StudentSubject c1) { using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertGrade]")) { s1.AddParameter("@subjectName", System.Data.SqlDbType.NVarChar, c1.subjectName); s1.AddParameter("@student", System.Data.SqlDbType.NVarChar, c1.pKId); s1.AddParameter("@grade", System.Data.SqlDbType.NVarChar, c1.grade); s1.Execute(); } }
public void AssignStudentClass(Entities.personalInfo p1, Entities.StudentSubject p2, Entities.Class c1, Entities.Section ss1) { using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spAssignClassSection]")) { s1.AddParameter("@iAm", System.Data.SqlDbType.NVarChar, p1.pKId); s1.AddParameter("@studentId", System.Data.SqlDbType.NVarChar, p2.pKId); s1.AddParameter("@className", System.Data.SqlDbType.NVarChar, c1.className); s1.AddParameter("@sectionName", System.Data.SqlDbType.NVarChar, ss1.sectionName); s1.AddParameter("@year", System.Data.SqlDbType.NVarChar, p2.year); s1.Execute(); } }
protected void UpdateGrades(object sender, EventArgs e) { foreach (GridViewRow row in GridView1.Rows) { if (row.RowType == DataControlRowType.DataRow) { string Marks = (row.FindControl("Grade") as TextBox).Text.Trim(); string SchoolID = (row.FindControl("SchoolID") as Label).Text.Trim(); string StudentName = (row.FindControl("StudentName") as Label).Text.Trim(); DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.StudentSubject s1 = new Entities.StudentSubject() { pKId = SchoolID, grade = Marks, subjectName = DropDownList7.SelectedValue, }; db.InsertStudentGrade(s1); } } Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('UpdateGrade')", true); }
protected void UpdateGrades(object sender, EventArgs e) { foreach (GridViewRow row in GridView1.Rows) { if (row.RowType == DataControlRowType.DataRow) { string Marks = (row.FindControl("Grade") as TextBox).Text.Trim(); string SchoolID = (row.FindControl("SchoolID") as Label).Text.Trim(); string StudentName = (row.FindControl("StudentName") as Label).Text.Trim(); DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.StudentSubject s1 = new Entities.StudentSubject() { pKId = SchoolID, grade = Marks, subjectName=DropDownList7.SelectedValue, }; db.InsertStudentGrade(s1); } } Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('UpdateGrade')", true); }
protected void AssignStudent(object sender, EventArgs e) { Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('AssignStudentClass')", true); if (Page.IsValid) { DBHandler.DBHandler db = new DBHandler.DBHandler(con); Entities.personalInfo t1 = new Entities.personalInfo() { pKId = Session["School"].ToString(), }; Entities.StudentSubject t2 = new Entities.StudentSubject() { pKId = SchoolID.Value, year=Year.Text, }; Entities.Class c1 = new Entities.Class() { className = DropDownList1.SelectedValue, }; Entities.Section s1 = new Entities.Section() { sectionName = DropDownList2.SelectedValue, }; db.AssignStudentClass(t1, t2, c1, s1); SqlDataSource6.DataBind(); GridView1.DataBind(); } }