Part 6. Admin Panel (Allocate Subject to a Staff/Teacher) Part - V

In this Attendance Management System Project's video, we are going to see how admin can allocate a subject to a teacher/staff for a particular class.

Source Code Starts Here :-

TeacherSubject.aspx <center> <div style="background-image: url('Images/background1.jpg'); width: 1200px"> <table align="center" style="height: 340px; width: 392px"> <tr> <td colspan="2" align="center"> <h2> Allocate Subject</h2> <br /> </td> </tr> <tr> <td> <b>Teacher: &nbsp;&nbsp;&nbsp;</b></td> <td> <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" Height="40px" Width="197px"> </asp:DropDownList> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="Select Teacher Name " ControlToValidate="DropDownList1" ForeColor="Red">*</asp:RequiredFieldValidator> </td> </tr> <tr> <td> <b>Course: &nbsp;&nbsp;&nbsp;</b></td> <td> <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" Height="40px" Width="197px"> </asp:DropDownList> <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="Select Course" ControlToValidate="DropDownList2" ForeColor="Red">*</asp:RequiredFieldValidator> </td> </tr> <tr> <td> <b>Year: &nbsp;&nbsp;&nbsp;</b></td> <td> <asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="True" Height="40px" Width="197px" onselectedindexchanged="DropDownList3_SelectedIndexChanged"> <asp:ListItem Value="0" >Select Year</asp:ListItem> <asp:ListItem Value="1">First Year</asp:ListItem> <asp:ListItem Value="2">Second Year</asp:ListItem> <asp:ListItem Value="3">Third Year</asp:ListItem> </asp:DropDownList> <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ErrorMessage="Select of Year" ControlToValidate="DropDownList3" ForeColor="Red">*</asp:RequiredFieldValidator> </td> </tr> <tr> <td> <b>Semester: &nbsp;&nbsp;&nbsp;</b></td> <td> <asp:DropDownList ID="DropDownList5" runat="server" AutoPostBack="True" Height="40px" Width="197px" onselectedindexchanged="DropDownList5_SelectedIndexChanged"> <asp:ListItem Value="0" >Select Semester</asp:ListItem> </asp:DropDownList> <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ErrorMessage="Select Semester" ControlToValidate="DropDownList5" ForeColor="Red">*</asp:RequiredFieldValidator> </td> </tr> <tr> <td> <b>Subject: &nbsp;&nbsp;&nbsp;</b></td> <td> <asp:DropDownList ID="DropDownList4" runat="server" AutoPostBack="True" Height="40px" Width="197px"> </asp:DropDownList> <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ErrorMessage="Select Subject" ControlToValidate="DropDownList4" ForeColor="Red">*</asp:RequiredFieldValidator> </td> </tr> <tr> <td colspan="2" align="center"> <asp:Button ID="Button1" runat="server" Text="Add" Font-Bold="True" Height="47px" Width="86px" onclick="Button1_Click" /> </td> </tr> <tr> <td colspan="2" align="center"> <asp:Label ID="Label1" runat="server" Font-Bold="True"></asp:Label></td> </tr> <tr> <td colspan="2"> <asp:ValidationSummary ID="ValidationSummary1" runat="server" ForeColor="Red" /> </td> </tr> <tr> <td colspan="2" align="center"> <asp:GridView ID="GridView1" runat="server"> </asp:GridView> </td> </tr> </table> <br /> <br /> <br /> <br /> <br /> <br /> <br /> </div> </center> TeacherSubject.aspx.cs String str = ConfigurationManager.ConnectionStrings["connection"].ConnectionString; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DropDownTeacherShow(); DropDownCourseShow(); ShowTeacherSubject(); } } private void DropDownTeacherShow() { SqlConnection con = new SqlConnection(str); con.Open(); SqlCommand cmd = new SqlCommand("select * from Teacher", con); DropDownList1.DataSource = cmd.ExecuteReader(); DropDownList1.DataTextField = "TName"; DropDownList1.DataValueField = "TID"; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, "Select Teacher"); con.Close(); } private void DropDownCourseShow() { SqlConnection con = new SqlConnection(str); con.Open(); SqlCommand cmd = new SqlCommand("select * from Course", con); DropDownList2.DataSource = cmd.ExecuteReader(); DropDownList2.DataTextField = "CourseName"; DropDownList2.DataValueField = "CID"; DropDownList2.DataBind(); DropDownList2.Items.Insert(0, "Select Course"); con.Close(); } protected void Button1_Click(object sender, EventArgs e) { if (DropDownList1.SelectedValue == "Select Teacher" && DropDownList2.SelectedValue == "Select Course" && DropDownList5.SelectedValue == "Select Semester" && DropDownList4.SelectedValue == "Select Subject") { Label1.Text = "Plz Select All The Fields."; Label1.ForeColor = System.Drawing.Color.Red; } else if (DropDownList1.SelectedValue == "Select Teacher") { Label1.Text = "Plz Select All The Fields."; Label1.ForeColor = System.Drawing.Color.Red; } else if (DropDownList2.SelectedValue == "Select Course") { Label1.Text = "Plz Select All The Fields."; Label1.ForeColor = System.Drawing.Color.Red; } else if (DropDownList4.SelectedValue == "Select Subject") { Label1.Text = "Plz Select All The Fields."; Label1.ForeColor = System.Drawing.Color.Red; } else { SqlConnection con1 = new SqlConnection(str); SqlDataAdapter sda = new SqlDataAdapter("select * from TeacherSubject where Teacher='" + DropDownList1.SelectedItem.Text + "' and Course='" + DropDownList2.SelectedItem.Text + "' and Year='" + DropDownList3.SelectedItem.Text + "' and Sem='" + DropDownList5.SelectedItem.Text + "' and Subject='" + DropDownList4.SelectedItem.Text + "' ", con1); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count == 1) { Label1.Text = "Selected Teacher is already assigned to the selected Subject."; Label1.ForeColor = System.Drawing.Color.Red; } else { SqlConnection con = new SqlConnection(str); con.Open(); SqlCommand cmd = new SqlCommand("insert into TeacherSubject(Teacher,Course,Year,Sem,Subject) values(@1,@2,@3,@4,@5)", con); cmd.Parameters.AddWithValue("@1", DropDownList1.SelectedItem.Text); cmd.Parameters.AddWithValue("@2", DropDownList2.SelectedItem.Text); cmd.Parameters.AddWithValue("@3", DropDownList3.SelectedItem.Text); cmd.Parameters.AddWithValue("@4", DropDownList5.SelectedItem.Text); cmd.Parameters.AddWithValue("@5", DropDownList4.SelectedItem.Text); cmd.ExecuteNonQuery(); con.Close(); DropDownList1.SelectedValue = "Select Teacher"; DropDownList2.SelectedValue = "Select Course"; DropDownList4.SelectedValue = "Select Subject"; Label1.Text = "Successfully Added"; Label1.ForeColor = System.Drawing.Color.Green; } } } protected void DropDownList5_SelectedIndexChanged(object sender, EventArgs e) { try { int courseID = Convert.ToInt32(DropDownList2.SelectedValue); string year = DropDownList3.SelectedItem.Text; string sem = DropDownList5.SelectedItem.Text; SqlConnection con = new SqlConnection(str); con.Open(); SqlCommand cmd = new SqlCommand("select * from Subject where CID='" + courseID + "' and Year='" + year + "' and Sem='" + sem + "'", con); DropDownList4.DataSource = cmd.ExecuteReader(); DropDownList4.DataTextField = "SubjectName"; DropDownList4.DataValueField = "SID"; DropDownList4.DataBind(); DropDownList4.Items.Insert(0, "Select Subject"); con.Close(); } catch (Exception ex) { Label1.Text = "Before selecting Year you must select Teacher and Course field."; Label1.ForeColor = System.Drawing.Color.Red; } } protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e) { if (int.Parse(DropDownList3.SelectedValue) > 0) { DataTable statedt = new DataTable(); statedt.Columns.Add("SemId", typeof(int)); statedt.Columns.Add("SemName"); if (DropDownList3.SelectedValue == "1") { statedt.Rows.Add(0, "Select Semester"); statedt.Rows.Add(1, "Sem I"); statedt.Rows.Add(2, "Sem II"); } if (DropDownList3.SelectedValue == "2") { statedt.Rows.Add(0, "Select Semester"); statedt.Rows.Add(3, "Sem III"); statedt.Rows.Add(4, "Sem IV"); } if (DropDownList3.SelectedValue == "3") { statedt.Rows.Add(0, "Select Semester"); statedt.Rows.Add(5, "Sem V"); statedt.Rows.Add(6, "Sem VI"); } DropDownList5.DataSource = statedt; DropDownList5.DataTextField = "SemName"; DropDownList5.DataValueField = "SemId"; DropDownList5.DataBind(); if (DropDownList3.SelectedValue == "0") { Label1.Text = "Please select proper Semester field."; } } } private void ShowTeacherSubject() { SqlConnection con = new SqlConnection(str); SqlDataAdapter sda = new SqlDataAdapter("select Teacher,Course,Year,Sem as Semester,Subject from TeacherSubject", con); con.Open(); DataTable dt = new DataTable(); sda.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); }

Thanks for visiting:)