public TypeCarrier Get(int id)
{
MySqlDataReader reader = null;
MySqlConnection myConnection = new MySqlConnection();
myConnection.ConnectionString = @"Server=127.0.0.1;Port=49489;Database=lean_tech_backend_test;Uid=azure;Pwd=6#vWHD_$;";
MySqlCommand sqlCmd = new MySqlCommand();
sqlCmd.CommandText = "SELECT * FROM type_carrier where id_type = " + id.ToString();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.Connection = myConnection;
myConnection.Open();
reader = sqlCmd.ExecuteReader();
TypeCarrier obj = null;
while (reader.Read())
{
obj = new TypeCarrier();
obj.id = Convert.ToInt32(reader.GetValue(0));
obj.name = reader.GetValue(1).ToString();
}
myConnection.Close();
return(obj);
}
public void Post(TypeCarrier obj)
{
MySqlConnection myConnection = new MySqlConnection();
myConnection.ConnectionString = @"Server=127.0.0.1;Port=49489;Database=lean_tech_backend_test;Uid=azure;Pwd=6#vWHD_$;";
MySqlCommand sqlCmd = new MySqlCommand();
sqlCmd.CommandType = CommandType.Text;
sqlCmd.CommandText = "INSERT INTO type_carrier (id_type, name_type) Values (@id_type, @name_type)";
sqlCmd.Connection = myConnection;
sqlCmd.Parameters.AddWithValue("@id_type", obj.id);
sqlCmd.Parameters.AddWithValue("@name_type", obj.name);
myConnection.Open();
int rowInserted = sqlCmd.ExecuteNonQuery();
myConnection.Close();
}
