public static int AddMatches(Match match, PlayerMatchType type)
{
MySqlConnection connection = DBConnection.getDbConnection().getConnection();
try
{
MySqlCommand command;
connection.Open();
String newMatchSql = null;
if (type == PlayerMatchType.Local)
{
newMatchSql = "INSERT INTO player_local_matches (matchName,venue,date,medal,member_athleticId) VALUES (@matchName,@venue,@date,@medal,@member_athleticId)";
command = connection.CreateCommand();
command.CommandText = newMatchSql;
command.Parameters.AddWithValue("@matchName", match.MatchName);
command.Parameters.AddWithValue("@venue", match.Venue);
command.Parameters.AddWithValue("@date", match.Date);
command.Parameters.AddWithValue("@medal", match.Medal);
command.Parameters.AddWithValue("@member_athleticId", match.AthleticId);
}
else
{
newMatchSql = "INSERT INTO player_international_matches (matchName,venue,date,medal,country,member_athleticId) VALUES (@matchName,@venue,@date,@medal,@country,@member_athleticId)";
command = connection.CreateCommand();
command.CommandText = newMatchSql;
command.Parameters.AddWithValue("@matchName", match.MatchName);
command.Parameters.AddWithValue("@venue", match.Venue);
command.Parameters.AddWithValue("@date", match.Date);
command.Parameters.AddWithValue("@medal", match.Medal);
command.Parameters.AddWithValue("@country", match.Country);
command.Parameters.AddWithValue("@member_athleticId", match.AthleticId);
}
return(command.ExecuteNonQuery());
}
catch (Exception ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
public static DataTable GetMatches(String id, PlayerMatchType type)
{
MySqlConnection connection = null;
DataTable dataTable = new DataTable();
try
{
connection = DBConnection.getDbConnection().getConnection();
if (!connection.Ping())
{
connection.Open();
}
MySqlCommand cmd = null;
if (type == PlayerMatchType.Local)
{
cmd = new MySqlCommand("SELECT matchName,venue,date,medal FROM player_local_matches WHERE member_athleticId ='" + id + "'", connection);
}
else if (type == PlayerMatchType.Forign)
{
cmd = new MySqlCommand("SELECT matchName,country,venue,date,medal FROM player_international_matches WHERE member_athleticId ='" + id + "'", connection);
}
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
dataTable.Load(reader);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
connection.Close();
}
return(dataTable);
}
