public static void InsertData(Teamdirection Teamdirection, MySqlConnection myConnection)
{
try
{
string query = "INSERT INTO teamdirection (DirectionId, DirectionteamName)";
query += " VALUES (@DirectionId, @DirectionteamName)";
MySqlCommand myCommand = new MySqlCommand(query, myConnection);
myCommand.Parameters.AddWithValue("@DirectionId", Teamdirection.DirectionId);
myCommand.Parameters.AddWithValue("@DirectionteamName", Teamdirection.DirectionteamName);
int row = myCommand.ExecuteNonQuery();
}
catch (Exception e)
{
string error = "Exception Occre while Inserting in table teamdirection :" + e.Message + "\t" + e.GetType();
}
}
public static void InsertData(IConfigurationRoot configuration, Teamdirection Teamdirection)
{
MySqlConnection myConnection = new MySqlConnection(configuration["connectionString"]);
try
{
myConnection.Open();
ConnectionState State = myConnection.State;
string query = "INSERT INTO teamdirection (DirectionId, DirectionteamName)";
query += " VALUES (@DirectionId, @DirectionteamName)";
MySqlCommand myCommand = new MySqlCommand(query, myConnection);
myCommand.Parameters.AddWithValue("@DirectionId", Teamdirection.DirectionId);
myCommand.Parameters.AddWithValue("@DirectionteamName", Teamdirection.DirectionteamName);
int row = myCommand.ExecuteNonQuery();
}
catch (Exception e)
{
string error = "Exception Occre while Inserting in table:" + e.Message + "\t" + e.GetType();
}
}
