//To delete records of Database public bool Delete(ContactKeeper c) { //Declaring default boolean variable and initializing it false bool isSucess = false; //MySQL Connection MySqlConnection conn = new MySqlConnection(connectionString); try { //SQL Query string SQLQuery = "DELETE FROM Users WHERE Contact_ID=@Contact_ID"; //MySQL Command MySqlCommand cmd = new MySqlCommand(SQLQuery, conn); //Creating parameters to add data cmd.Parameters.AddWithValue("@Contact_ID", c.ContactID); //Open Connection conn.Open(); //Execute Query //and ExecuteNonQuery() returns the number of rows affected int row = cmd.ExecuteNonQuery(); isSucess = row > 0 ? true : false; } catch (Exception ex) { MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { //Close Connection conn.Close(); } return(isSucess); }
//To insert records in Database public bool Insert(ContactKeeper c) { //declaring a default bool variable and initializing false bool isSucess = false; //MySQL Connection MySqlConnection conn = new MySqlConnection(connectionString); try { //SQL Query string SQLQuery = "INSERT INTO Users(First_Name,Last_Name,Contact_Number,Address,Gender) VALUES(@First_Name,@Last_Name,@Contact_Number,@Address,@Gender)"; //MYSQL Command MySqlCommand cmd = new MySqlCommand(SQLQuery, conn); //Creating parameters to add data cmd.Parameters.AddWithValue("@First_Name", c.FirstName); cmd.Parameters.AddWithValue("@Last_Name", c.LastName); cmd.Parameters.AddWithValue("@Contact_Number", c.ContactNumber); cmd.Parameters.AddWithValue("@Address", c.Address); cmd.Parameters.AddWithValue("@Gender", c.Gender); //Connection Open conn.Open(); //Execute Query //Here ExecuteNonQuery() returns the number of rows affected int row = cmd.ExecuteNonQuery(); isSucess = row > 0 ? true : false; } catch (Exception ex) { MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { //Close connection conn.Close(); } return(isSucess); }
//To update records of Database public bool Update(ContactKeeper c) { //Declaring default boolean variable and initializing false bool isSucess = false; //MySQL Connection MySqlConnection conn = new MySqlConnection(connectionString); try { //SQLQuery string SQLQuery = "UPDATE Users SET First_Name=@First_Name,Last_Name=@Last_Name,Contact_Number=@Contact_Number,Address=@Address,Gender=@Gender WHERE Contact_ID=@Contact_ID"; //SQL Command MySqlCommand cmd = new MySqlCommand(SQLQuery, conn); //Creating parameters to add Data cmd.Parameters.AddWithValue("@First_Name", c.FirstName); cmd.Parameters.AddWithValue("@Last_Name", c.LastName); cmd.Parameters.AddWithValue("@Contact_Number", c.ContactNumber); cmd.Parameters.AddWithValue("@Address", c.Address); cmd.Parameters.AddWithValue("@Gender", c.Gender); cmd.Parameters.AddWithValue("@Contact_ID", c.ContactID); //Connection Open conn.Open(); //Execute Query //and ExecuteNonQuery() returns the number of rows affected int row = cmd.ExecuteNonQuery(); isSucess = row > 0 ? true : false; } catch (Exception ex) { MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { //Close connection conn.Close(); } return(isSucess); }