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();
}
}
