public bool Delete(ContactsClass C) { bool isSuccessful = false; SqlConnection conn = new SqlConnection(myconnstring); try { string sql = "DELETE FROM Table_0 WHERE @Contactid=Contactid"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@Contactid", C.ContactsBox); //Open Connectiong conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccessful = true; } } catch (Exception ex) { } finally { conn.Close(); } return(isSuccessful); }
public bool Insert(ContactsClass C) { //Creating default return type and setting it's value to false bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstring); try { string sql = "INSERT INTO Table_0 (FirstName, Surname, ContactNumb,Address,Gender) VALUES (@FirstName, @Surname, @ContactNumb,@Address,@Gender)"; SqlCommand cmd = new SqlCommand(sql, conn); // Create parametrs to add data cmd.Parameters.AddWithValue("@FirstName", C.NamesBox); cmd.Parameters.AddWithValue("@Surname", C.SurnamesBox); cmd.Parameters.AddWithValue("@ContactNumb", C.NumbersBox); cmd.Parameters.AddWithValue("@Address", C.textsBox1); cmd.Parameters.AddWithValue("@Gender", C.ChoosesGender); conn.Open(); int rows = cmd.ExecuteNonQuery(); // if the query runs successfully than the number of rows will be greater than 0 if (rows > 0) { isSuccess = true; } } catch (Exception ex) { }finally { conn.Close(); } return(isSuccess); }
// Method to update info in the table public bool Update(ContactsClass C) { // Create default boolean bool isSuccessful = false; SqlConnection conn = new SqlConnection(myconnstring); try { String sql = "UPDATE Table_0 SET FirstName=@FirstName, Surname=@Surname, ContactNumb=@ContactNumb,Address=@Address,Gender=@Gender WHERE Contactid=@Contactid"; //Creating an SQL Command SqlCommand cmd = new SqlCommand(sql, conn); // Create Parametrs cmd.Parameters.AddWithValue("@FirstName", C.NamesBox); cmd.Parameters.AddWithValue("@Surname", C.SurnamesBox); cmd.Parameters.AddWithValue("@ContactNumb", C.NumbersBox); cmd.Parameters.AddWithValue("@Address", C.textsBox1); cmd.Parameters.AddWithValue("@Gender", C.ChoosesGender); cmd.Parameters.AddWithValue("@Contactid", C.ContactsBox); // Open Connection conn.Open(); int rows = cmd.ExecuteNonQuery(); // IF the size of the query is bigger than 0, than show smth if (rows > 0) { isSuccessful = true; } } catch (Exception ex) { } finally { conn.Close(); } return(isSuccessful); }