public void Update(UpdateQuery update) { using (MySqlConnection con = Connect()) using (MySqlCommand cmd = new MySqlCommand()) { // Prepare query cmd.Connection = con; cmd.CommandText = update.GetQuery(); cmd.Prepare(); // Get values and fields List <string> valuesList = update.GetAllValues(); string[] valuesArray = valuesList.ToArray(); string[] fields = update.fields; // Enter parameters try { for (int i = 0; i < valuesArray.Length; ++i) { cmd.Parameters.AddWithValue("@" + fields[i], valuesArray[i]); } } catch (Exception ex) { Log.Error("Database Error: \r\nQuery: " + update.GetQuery() + "\r\n" + ex.ToString()); } // Execute query try { cmd.ExecuteNonQuery(); } catch (Exception ex) { Log.Error("Database Error: \r\nQuery: " + update.GetQuery() + "\r\n" + ex.ToString()); } con.Close(); } }
public void Update(UpdateQuery update) { using (MySqlConnection con = Connect()) using (MySqlCommand cmd = new MySqlCommand()) { // Prepare query cmd.Connection = con; cmd.CommandText = update.GetQuery(); cmd.Prepare(); // Get values and fields List<string> valuesList = update.GetAllValues(); string[] valuesArray = valuesList.ToArray(); string[] fields = update.fields; // Enter parameters try { for (int i = 0; i < valuesArray.Length; ++i) cmd.Parameters.AddWithValue("@" + fields[i], valuesArray[i]); } catch (Exception ex) { Log.Error("Database Error: \r\nQuery: " + update.GetQuery() + "\r\n" + ex.ToString()); } // Execute query try { cmd.ExecuteNonQuery(); } catch (Exception ex) { Log.Error("Database Error: \r\nQuery: " + update.GetQuery() + "\r\n" + ex.ToString()); } con.Close(); } }