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