public void InsertEntry(MySqlConnection conn, Versions version, string endpoint, string DatabaseName) { using (var insertComm = new MySqlCommand($"INSERT INTO `{DatabaseName}_builds` (`branch`, `buildconfig`, `cdnconfig`, `buildid`, `versionsname`, `productconfig`) VALUES " + $"(@branch, @buildConfig, @CDNConfig, @buildid, @versionsName, @productConfig)", conn)) { insertComm.Parameters.AddWithValue("@branch", MySqlMisc.GetBranch(endpoint)); insertComm.Parameters.AddWithValue("@buildconfig", version.BuildConfig); insertComm.Parameters.AddWithValue("@CDNConfig", version.CDNConfig); insertComm.Parameters.AddWithValue("@buildid", version.BuildId); insertComm.Parameters.AddWithValue("@versionsName", version.VersionsName); insertComm.Parameters.AddWithValue("@productConfig", version.ProductConfig); insertComm.ExecuteNonQuery(); Console.WriteLine($"{endpoint} : {version.VersionsName} has been added to the Database."); } }
public void UpdateEntry(MySqlConnection conn, Versions version, string endpoint, string DatabaseName) { try { using (var updateComm = new MySqlCommand($"UPDATE `{DatabaseName}_builds` SET `branch` = @Branch, `buildconfig` = @BuildConfig, `cdnconfig` = @CdnConfig, " + $"`buildid` = @BuildId, `versionsname` = @Version, `productconfig` = @ProductConfig " + $"WHERE `buildconfig` = @BuildConfig", conn)) { updateComm.Parameters.AddWithValue("@Branch", MySqlMisc.GetBranch(endpoint)); updateComm.Parameters.AddWithValue("@BuildConfig", version.BuildConfig); updateComm.Parameters.AddWithValue("@CdnConfig", version.CDNConfig); updateComm.Parameters.AddWithValue("@BuildId", version.BuildId); updateComm.Parameters.AddWithValue("@Version", version.VersionsName); updateComm.Parameters.AddWithValue("@ProductConfig", version.ProductConfig); updateComm.ExecuteNonQuery(); Console.WriteLine($"{endpoint} : {version.VersionsName} has been updated."); } } catch (Exception ex) { Console.WriteLine(ex); }; }