//....................Insert Data into database.................... public bool Insert(LecturerClass l) { //creating default return type and setting its values to false bool isSuccess = false; //step 1: connect Database SqlConnection conn = new SqlConnection(myconnstring); try { //Step 2: create a sql query to insert data string sql = "INSERT INTO Lecturer (Title, Rank, FirstName, LastName, LectureID, Center, Faculty, Building, Department, LecLevel, ActiveDays, ActiveHours) VALUES (@Title, @Rank, @FirstName, @LastName, @LectureID, @Center, @Faculty, @Building, @Department, @LecLevel, @ActiveDays, @ActiveHours)"; //creating sql commend using sql and conn SqlCommand cmd = new SqlCommand(sql, conn); //Creat parameter to add data cmd.Parameters.AddWithValue("@Title", l.Title); cmd.Parameters.AddWithValue("@Rank", l.Rank); cmd.Parameters.AddWithValue("@FirstName", l.FirstName); cmd.Parameters.AddWithValue("@LastName", l.LastName); cmd.Parameters.AddWithValue("@LectureID", l.LectureID); cmd.Parameters.AddWithValue("@Center", l.Center); cmd.Parameters.AddWithValue("@Faculty", l.Faculty); cmd.Parameters.AddWithValue("@Building", l.Building); cmd.Parameters.AddWithValue("@Department", l.Department); cmd.Parameters.AddWithValue("@LecLevel", l.LecLevel); cmd.Parameters.AddWithValue("@ActiveDays", l.ActiveDays); cmd.Parameters.AddWithValue("@ActiveHours", l.ActiveHours); //open connection here conn.Open(); int rows = cmd.ExecuteNonQuery(); //if the query successfully then value of rows will be generate than zero else its value will be 0 if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { conn.Close(); } return(isSuccess); }
//....................Method to update data in database from our app.................... //Method to update data in database from our app public bool Update(LecturerClass l) { //create a default return type and set its default value to false bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { //sql to update data in our database string sql = "UPDATE Lecturer SET Title=@Title, Rank=@Rank, FirstName=@FirstName, LastName=@LastName, LectureID=@LectureID, Center=@Center, Faculty=@Faculty, Building=@Building, Department=@Department, LecLevel=@LecLevel WHERE Id=@Id"; //create sql commend SqlCommand cmd = new SqlCommand(sql, conn); //create parameters to add values cmd.Parameters.AddWithValue("@id", l.Id); cmd.Parameters.AddWithValue("@Title", l.Title); cmd.Parameters.AddWithValue("@Rank", l.Rank); cmd.Parameters.AddWithValue("@FirstName", l.FirstName); cmd.Parameters.AddWithValue("@LastName", l.LastName); cmd.Parameters.AddWithValue("@LectureID", l.LectureID); cmd.Parameters.AddWithValue("@Center", l.Center); cmd.Parameters.AddWithValue("@Faculty", l.Faculty); cmd.Parameters.AddWithValue("@Building", l.Building); cmd.Parameters.AddWithValue("@Department", l.Department); cmd.Parameters.AddWithValue("@LecLevel", l.LecLevel); //open database connection conn.Open(); int rows = cmd.ExecuteNonQuery(); //if the query rund successfylly then the value of rows will be grater than zero else values will be 0 if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { conn.Close(); } return(isSuccess); }
//....................method to delete data from database.................... public bool Delete(LecturerClass l) { //create a default values and set its values to false bool isSuccess = false; //create sql connection SqlConnection conn = new SqlConnection(myconnstring); try { //sql to delete data string sql = "DELETE FROM Lecturer WHERE Id=@Id"; //create sql commend SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@Id", l.Id); //open connection conn.Open(); int rows = cmd.ExecuteNonQuery(); //if the query rund successfylly then the value of rows will be grater than zero else values will be 0 if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { } finally { //cloase connection conn.Close(); } return(isSuccess); }