protected void Button1_Click(object sender, EventArgs e)
{
dataconnection dc = new dataconnection();
try
{
string query = @"SELECT [s_name]
,[f_name]
,[m_name]
,[pre_addr]
,[par_addr]
,[postoffice]
,[postalcode]
,[dateofbirth]
,[f_phoneno]
,[m_phoneno]
,[dist]
,[nationality]
,[student_id]
,[pass]
,[class]
,[section]
FROM [dbo].[student_data] where [student_id] = '" + studentid.Text + "' or [student_name] = '" + studentid.Text + "' and [class] ='" + class_.SelectedItem.Value + "' and [section] = '" + section.SelectedItem.Value + "' ";
student_details.DataSource = dc.GetData(query);
student_details.DataBind();
}
catch (SqlException ex)
{
}
}
protected void Button1_Click(object sender, EventArgs e)
{
dataconnection dc = new dataconnection();
if (con_password.Text.Equals(password.Text))
{
string query = @"INSERT INTO [dbo].[teacher_data]
([t_name]
,[qualification]
,[cgpa]
,[teacher_id]
,[t_addr]
,[t_password]
,[teacher_post]
,[post_type])
VALUES ('" + t_name.Text + "', '" + qualification.Text + "', '" + cgpa.Text + "', '" + teacher_id.Text + "', '" + t_addr.Text + "', '" + password.Text + "', '" + teacher_post.Text + "', '" + post_type.Text + "')";
dc.executequary(query);
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "Data Saved" + "');", true);
}
else
{
massage.Text = "Password Not Matched";
}
}
protected void Button1_Click(object sender, EventArgs e)
{
dataconnection dc = new dataconnection();
if (confirmpassword.Text.Equals(password.Text))
{
string query = @"INSERT INTO [dbo].[student_data]
([s_name]
,[f_name]
,[m_name]
,[pre_addr]
,[par_addr]
,[postoffice]
,[postalcode]
,[dateofbirth]
,[f_phoneno]
,[m_phoneno]
,[dist]
,[nationality]
,[student_id]
,[pass]
,[class]
,[section])
VALUES ('" + s_name.Text + "', '" + f_name.Text + "', '" + m_name.Text + "', '" + pre_addr.Text + "', '" + par_addr.Text + "', '" + postoffice.Text + "', '" + postalcode.Text + "', '" + dateofbirth.Text + "', '" + f_phoneno.Text + "', '" + m_phoneno.Text + "', '" + dist.Text + "', '" + nationality.Text + "', '" + student_id.Text + "', '" + password.Text + "', '" + class_.SelectedItem.Value + "' ,'" + section.SelectedItem.Value + "')";
dc.executequary(query);
}
else
{
}
//Response.Redirect("ADMIN DASH.aspx");
}
protected void Button2_Click(object sender, EventArgs e)
{
dataconnection dc = new dataconnection();
string query = @"DELETE FROM [dbo].[teacher_data]
WHERE [teacher_id] = '" + delete_id.Text + "'";
dc.executequary(query);
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "Teacher Deleted" + "');", true);
}
public void noticegrid()
{
dataconnection dc = new dataconnection();
string query = @"SELECT [notice]
FROM [dbo].[notice]";
notice.DataSource = dc.GetData(query);
notice.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
dataconnection dc = new dataconnection();
string query = @"SELECT [sub_name]
FROM [dbo].[subjects] where class = '" + insertid.Text + "'";
subjects.DataSource = dc.GetData(query);
subjects.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
dataconnection dc = new dataconnection();
string query = @"INSERT INTO [dbo].[notice]
([notice])
VALUES ('" + notice.Text + "')";
dc.executequary(query);
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "Notice has been sent" + "');", true);
}
protected void teacher_button_Click(object sender, EventArgs e)
{
dataconnection dc = new dataconnection();
string query = @"SELECT [t_name]
,[qualification]
,[cgpa]
,[teacher_id]
,[t_addr]
,[teacher_post]
,[post_type]
FROM [dbo].[teacher_data]";
teacher.DataSource = dc.GetData(query);
teacher.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
dataconnection dc = new dataconnection();
string query = @"INSERT INTO [dbo].[payment]
([class]
,[section]
,[student_id]
,[payable]
,[due]
,[paid])
VALUES ('" + p_class.SelectedItem.Value + "', '" + p_section.SelectedItem.Value + "', '" + p_student_id.Text + "', '" + payable.Text + "', '" + due.Text + "','" + paid.Text + "')";
dc.executequary(query);
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "Saved" + "');", true);
}
public void dashshow()
{
dataconnection dc = new dataconnection();
String connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
SqlDataAdapter da = new SqlDataAdapter("select payable,due,paid from payment", conn);
DataTable dt = new DataTable();
da.Fill(dt);
TextBox1.Text = dt.Rows[0][0].ToString();
TextBox2.Text = dt.Rows[0][1].ToString();
TextBox3.Text = dt.Rows[0][2].ToString();
}
protected void Button1_Click(object sender, EventArgs e)
{
dataconnection dc = new dataconnection();
try
{
string query = @"SELECT [class]
,[classtest_one]
,[classtest_two]
,[classtest_three]
,[mid_exam]
,[final_exam]
,[sub_name]
FROM [dbo].[students_mark] where [student_id] = '" + student_id.Text + "' and [section] = '" + section.SelectedItem.Value + "' and [class] ='" + class_.SelectedItem.Value + "'";
student_result.DataSource = dc.GetData(query);
student_result.DataBind();
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "result Not Found" + "');", true);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
dataconnection dc = new dataconnection();
if (section.SelectedItem.Value == "- Select Section" && group.SelectedItem.Value != "- Select Group")
{
if (class_.SelectedItem.Text == "6" || class_.SelectedItem.Text == "7" || class_.SelectedItem.Text == "8")
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + " Select Class 9 or 10" + "');", true);
}
else
{
string query = @"INSERT INTO [dbo].[students_mark]
([class]
,[section]
,[student_id]
,[classtest_one]
,[classtest_two]
,[classtest_three]
,[mid_exam]
,[final_exam]
,[sub_name])
VALUES ('" + class_.SelectedItem.Value + "', '" + group.SelectedItem.Value + "', '" + student_id.Text + "', '" + classtest_one.Text + "', '" + classtest_two.Text + "', '" + classtest_three.Text + "', '" + mid_exam.Text + "', '" + final_exam.Text + "', '" + subject_.SelectedItem.Value + "')";
dc.executequary(query);
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "Data Saved" + "');", true);
}
}
else if (group.SelectedItem.Value == "- Select Group" && section.SelectedItem.Value != "- Select Section")
{
if (class_.SelectedItem.Text == "9" || class_.SelectedItem.Text == "10")
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "select Please Class 6 or 7 or 8" + "');", true);
}
else
{
string query = @"INSERT INTO [dbo].[students_mark]
([class]
,[section]
,[student_id]
,[classtest_one]
,[classtest_two]
,[classtest_three]
,[mid_exam]
,[final_exam]
,[sub_name])
VALUES ('" + class_.SelectedItem.Value + "', '" + section.SelectedItem.Value + "', '" + student_id.Text + "', '" + classtest_one.Text + "', '" + classtest_two.Text + "', '" + classtest_three.Text + "', '" + mid_exam.Text + "', '" + final_exam.Text + "', '" + subject_.SelectedItem.Value + "')";
dc.executequary(query);
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "Data Saved" + "');", true);
}
}
else if (group.SelectedItem.Value == "- Select Group" && section.SelectedItem.Value == "- Select Section")
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + " Select Section or Group" + "');", true);
}
else if (group.SelectedItem.Value != "- Select Group" && section.SelectedItem.Value != "- Select Section")
{
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + "Select a Section or a group" + "');", true);
}
}