//Updates existing save game
public void UpdateSaveFileList(int gameFileSelection)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
//Open connection
conn.Open();
//Calls private instance variable from above to input SQL command
SqlCommand cmd = new SqlCommand(SQL_ReSaveGameFIle, conn);
cmd.Parameters.AddWithValue("@save_id", PlayerClass.SaveID);
cmd.Parameters.AddWithValue("@player_name", PlayerClass.PlayerName);
cmd.Parameters.AddWithValue("@player_level", PlayerClass.PlayerLevel);
cmd.Parameters.AddWithValue("@player_money", PlayerClass.PlayerMoney);
cmd.Parameters.AddWithValue("@owned_weapon_type", PlayerClass.OwnedWeaponType);
cmd.Parameters.AddWithValue("@owned_weapon_damage", PlayerClass.OwnedWeaponDamage);
cmd.Parameters.AddWithValue("@owned_armor_type", PlayerClass.OwnedArmorType);
cmd.Parameters.AddWithValue("@owned_armor_value", PlayerClass.OwnedArmorValue);
cmd.ExecuteNonQuery();
PlayerClass.CheckSave(PlayerClass.SaveID);
}
}
catch
{
Console.Clear();
Console.WriteLine("\n Sorry, the game failed to save. It was probably your fault.");
Thread.Sleep(2000);
Console.Clear();
}
}
