/// <summary> /// Event Handler for click event on btnAdd which adds a new student in database /// </summary> /// <param name="sender">Control on which event occured</param> /// <param name="e">Args for event occured</param> protected void btnAdd_Click(object sender, EventArgs e) { //getting the entered information string fullname = txtFullName.Text; string fathersName = txtFathersName.Text; int rollNo = Convert.ToInt32(txtRollNo.Text); int age = Convert.ToInt16(txtAge.Text); int stream = Convert.ToInt32(listStream.SelectedValue); string address = txtAddress.Text; int state = Convert.ToInt32(listState.SelectedValue); //calling AddStudent() method to add the record to database StudentDataHandler studHandler = new StudentDataHandler(); bool result = studHandler.AddStudent(fullname, fathersName, rollNo, age, stream, address, state); if (result) { //if record gets added Response.Write(Messages.RecordAddSuccess); resetControls(); //resetting the controls for new student } else { //if record adding failed. Response.Write(Messages.RecordAddFailed); } }
/// <summary> /// CLick Event Handler for btnUpdate button to update record of a student /// </summary> /// <param name="source">Control attribute on which this event has occured</param> /// <param name="args">Event Args for the control</param> protected void btnUpdate_Click(object sender, EventArgs e) { //getting the newly entered data for student string fullname = txtFullName.Text; string fathersName = txtFathersName.Text; int rollNo = Convert.ToInt32(txtRollNo.Text); int age = Convert.ToInt16(txtAge.Text); int stream = Convert.ToInt32(listStream.SelectedValue); string address = txtAddress.Text; int state = Convert.ToInt32(listState.SelectedValue); //updating the Student object stud.FullName = fullname; stud.FathersName = fathersName; stud.RollNo = rollNo; stud.Age = age; stud.Stream = stream; stud.Address = address; stud.State = state; //calling the update method bool result = StudentDataHandler.UpdateStudent(stud); if (result) { // if result gets updated Response.Write(Messages.RecordUpdateSuccess); } else { //if updation gets failed. Response.Write(Messages.RecordUpdateFailed); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //checking whether there is any querystring or not if (Request.QueryString.Count == 0) { //Redirecting to AllStudents page to select a student to update Response.Redirect("AllStudents.aspx"); } AddStreams(); //to add streams to the respective listBox AddStates(); //to add states to the respective listBox //extracting the student ID from query string string queryData = Request.QueryString["StudID"]; int studID = Convert.ToInt32(queryData); //getting the Student record from the database stud = StudentDataHandler.FindStudent(studID); //filling up the controls with the old data txtFullName.Text = stud.FullName; txtFathersName.Text = stud.FathersName; txtRollNo.Text = stud.RollNo.ToString(); txtAge.Text = stud.Age.ToString(); listStream.SelectedValue = stud.Stream.ToString(); string address = txtAddress.Text = stud.Address; listState.SelectedValue = stud.State.ToString(); } }
/// <summary> /// SelctIndexChanged Event Handler for listStream to show the students from the selected stream /// </summary> /// <param name="sender">Control on which the event occured</param> /// <param name="e">Args for the event occured.</param> protected void listStream_SelectedIndexChanged(object sender, EventArgs e) { //creating a new DataTable for GridView DataTable studTable = new DataTable(); //settign the columns for the table studTable.Columns.Add("StudID", typeof(int)); studTable.Columns.Add("FullName", typeof(string)); studTable.Columns.Add("FathersName", typeof(string)); studTable.Columns.Add("RollNo", typeof(int)); studTable.Columns.Add("Age", typeof(int)); studTable.Columns.Add("Stream", typeof(string)); studTable.Columns.Add("Address", typeof(string)); studTable.Columns.Add("State", typeof(string)); //reading the data from database List <Student> students = StudentDataHandler.ListAllStudent(); if (listStream.SelectedIndex == 0) //if user selects 'All' { //adding rows to the DataTable foreach (Student item in students) { studTable.Rows.Add( item.StudID, item.FullName, item.FathersName, item.RollNo, item.Age, UtilityFunctions.GetStreamName(item.Stream), item.Address, UtilityFunctions.GetStateName(item.State) ); } } else //if user selects a specific stream { //adding rows to the DataTable foreach (Student item in students) { if (item.Stream == Convert.ToInt32(listStream.SelectedValue)) { studTable.Rows.Add( item.StudID, item.FullName, item.FathersName, item.RollNo, item.Age, UtilityFunctions.GetStreamName(item.Stream), item.Address, UtilityFunctions.GetStateName(item.State) ); } } } //setting up the DataSource for the GridView gridStudents.DataSource = studTable; gridStudents.DataBind(); }
/// <summary> /// SelectedIndexChanged Event Handler for listStreams /// </summary> /// <param name="sender">lisStream object</param> /// <param name="e">Args for event</param> protected void listStreams_SelectedIndexChanged(object sender, EventArgs e) { //reading the data from database List <Student> students = StudentDataHandler.ListAllStudent(); listStudLeft.Items.Clear(); listStudRight.Items.Clear(); if (listStreams.SelectedIndex == 0) //if user selects 'All' { //adding rows to the DataTable foreach (Student item in students) { listStudLeft.Items.Add(new ListItem(item.FullName, item.RollNo.ToString())); } } else //if user selects a specific stream { //adding rows to the DataTable foreach (Student item in students) { if (item.Stream == Convert.ToInt32(listStreams.SelectedValue)) { listStudLeft.Items.Add(new ListItem(item.FullName, item.RollNo.ToString())); } } } }
public static string DeleteStudents(string rollNos) { string result = Messages.RecordDeletedFailed; if (StudentDataHandler.DeleteStudent(rollNos)) { result = Messages.RecordDeletedSuccess; } return(result); }