public int InsertCountry(Country data)
{
MySqlManager db = new MySqlManager(DbConnectionString);
StringBuilder sbQuery = new StringBuilder();
int nRows = 0;
try
{
DataTable dtParameters = db.ConfigTableForParameters();
dtParameters.Rows.Add("@NameEn", data.NameEn, MySqlDbType.VarChar);
dtParameters.Rows.Add("@NameEs", data.NameEs, MySqlDbType.VarChar);
dtParameters.Rows.Add("@ISO2", data.ISO2, MySqlDbType.VarChar);
dtParameters.Rows.Add("@ISO3", data.ISO3, MySqlDbType.VarChar);
string query = db.InsertQueryBuilder("soundbeats.country", dtParameters);
// Apertura de conexión
if (db.Open())
{
db.TableAddInParameters(dtParameters);
nRows = db.ExecuteNonQuery(CommandType.Text, query);
if (nRows == -1)
{
ErrorMessage = db.ErrorMessage;
}
db.Close();
}
else
{
// Error at Connect to SQL-Server Server
ErrorMessage = db.ErrorMessage;
return(-1);
}
}
catch
{
ErrorMessage = db.ErrorMessage;
return(-1);
}
return(nRows);
}
public int InsertMusician(Musician data)
{
MySqlManager db = new MySqlManager(DbConnectionString);
int nRows = 0;
try
{
DataTable dtParameters = db.ConfigTableForParameters();
dtParameters.Rows.Add("@FirstName", data.FirstName, MySqlDbType.VarChar);
dtParameters.Rows.Add("@LastName", data.LastName, MySqlDbType.VarChar);
dtParameters.Rows.Add("@BirthDate", data.BirthDate.ToString("yyyy-MM-dd HH:mm:ss"), MySqlDbType.DateTime);
dtParameters.Rows.Add("@BirthPlace", data.BirthPlace, MySqlDbType.VarChar);
string query = db.InsertQueryBuilder("soundbeats.musician", dtParameters);
// Apertura de conexión
if (db.Open())
{
db.TableAddInParameters(dtParameters);
nRows = db.ExecuteNonQuery(CommandType.Text, query);
if (nRows == -1)
{
ErrorMessage = db.ErrorMessage;
}
db.Close();
}
else
{
// Error at Connect to SQL-Server Server
ErrorMessage = db.ErrorMessage;
return(-1);
}
}
catch
{
ErrorMessage = db.ErrorMessage;
return(-1);
}
return(nRows);
}
