/// <summary> /// method to update record of any student /// </summary> /// <returns>whether record updated or not</returns> public bool UpdateStudent() { bool result = false; //SqlConnection object to hold the properties of the connect SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connectDB"].ToString()); try { conn.Open(); //opening the connection to the database //query to be excecuted string query = "update student_master set FullName=@fullname, FathersName=@fathersName,RollNo=@rollNo, Age=@age, Stream=@stream, Address=@address, State=@state where StudID=@studID"; //SqlCommand object to handle the execution of the query SqlCommand comm = new SqlCommand(query, conn); comm.Parameters.AddWithValue("fullname", this.fullName); comm.Parameters.AddWithValue("fathersName", this.fathersName); comm.Parameters.AddWithValue("rollNo", this.rollNo); comm.Parameters.AddWithValue("age", this.age); comm.Parameters.AddWithValue("stream", this.stream); comm.Parameters.AddWithValue("address", this.address); comm.Parameters.AddWithValue("state", this.state); comm.Parameters.AddWithValue("studID", this.StudID); int count = comm.ExecuteNonQuery(); //exceuting the query conn.Close(); //closing the connection with database if (count > 0) //checking whether any data got updated or not ? { result = true; } } catch (SqlException ex) { //if found any exception Console.WriteLine("{0} EX : {1} ", Messages.ConnToDBFailed, ex.ToString()); UtilityFunctions.LogToEventLog(ex); } return(result); //returning the result }
/// <summary> /// method to add a new Student record in the database /// </summary> /// <returns>whether record added or not.</returns> public bool AddStudent() { bool result = false; //SqlConnection object to hold the properties of the connect SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connectDB"].ToString()); try { //opeining the connection conn.Open(); //query to be executed string query = "insert into student_master values(@fullname,@fathersName,@rollNo,@age,@stream,@address,@state)"; //SqlCommand object to handle the query execution SqlCommand comm = new SqlCommand(query, conn); comm.Parameters.AddWithValue("fullname", this.fullName); comm.Parameters.AddWithValue("fathersName", this.fathersName); comm.Parameters.AddWithValue("rollNo", this.rollNo); comm.Parameters.AddWithValue("age", this.age); comm.Parameters.AddWithValue("stream", this.stream); comm.Parameters.AddWithValue("address", this.address); comm.Parameters.AddWithValue("state", this.state); int count = comm.ExecuteNonQuery(); //executing the query conn.Close(); //closing the connection with the database if (count > 0) //checking if any record got added or not? { result = true; } } catch (SqlException ex) { //if found any exception Console.WriteLine("{0} EX : {1} ", Messages.ConnToDBFailed, ex.ToString()); UtilityFunctions.LogToEventLog(ex); } return(result); //returning the result }
/// <summary> /// Method to retreave all the records of the students /// </summary> /// <returns>list of all students</returns> public static List <Student> ListAllStudents() { //list to store information of the students fetched from the database List <Student> students = new List <Student>(); //SqlConnection object to hold the properties of the connect SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["connectDB"].ToString()); try { conn.Open(); //opening the connection with the database //query to be executed string query = "select * from student_master"; SqlCommand comm = new SqlCommand(query, conn); SqlDataReader reader = comm.ExecuteReader(); //reading the data from DataReader after fetching while (reader.Read()) { //creating object of Student Student stud = new Student(Convert.ToInt32(reader["StudID"]), reader["FullName"].ToString(), reader["FathersName"].ToString(), Convert.ToInt32(reader["RollNo"]), Convert.ToInt32(reader["Age"]), Convert.ToInt32(reader["Stream"]), reader["Address"].ToString(), Convert.ToInt32(reader["State"])); students.Add(stud); //adding the object to List } reader.Close(); //closing the reader conn.Close(); //closing the connection } catch (SqlException ex) { //if found any exception in opening the connection Console.WriteLine("{0} EX : {1} ", Messages.ConnToDBFailed, ex.ToString()); UtilityFunctions.LogToEventLog(ex); } return(students); //returning the list }