public bool addNewATM(ATM newATM)
{
connect();
string addressInsertCommand = $"INSERT INTO Addresses (street, house_num, city, zip_code, lat, lng) VALUES ('{newATM.address.street}', {newATM.address.house_num}, '{newATM.address.city}', '{newATM.address.zip_code}', {newATM.address.lat}, {newATM.address.lng})";
string getLastInsert = "SELECT LAST_INSERT_ID()";
MySqlCommand getAddressID = new MySqlCommand(getLastInsert);
MySqlCommand addrsCommand = new MySqlCommand(addressInsertCommand);
MySqlCommand newAtmCommand = new MySqlCommand();
getAddressID.CommandType = CommandType.Text;
addrsCommand.CommandType = CommandType.Text;
if (conn != null)
{
addrsCommand.Connection = conn;
getAddressID.Connection = conn;
newAtmCommand.Connection = conn;
conn.Open();
try {
// Executing the query in the SQL server
addrsCommand.ExecuteNonQuery();
int addrsID = int.Parse(getAddressID.ExecuteScalar().ToString());
string newAtmString = $"INSERT INTO Atms (capacity, live_money_avilable, atm_size, brand, Addresses_id) VALUES ('{newATM.capacity}', '{newATM.live_money_avilable}', '{newATM.size}', '{newATM.brand}', {addrsID})";
newAtmCommand.CommandText = newAtmString;
newAtmCommand.CommandType = CommandType.Text;
newAtmCommand.ExecuteNonQuery();
} catch (MySqlException ex) {
throw ex;
}
// Closing SQL connection
conn.Close();
Console.WriteLine("new ATM has been created");
return(true);
}
return(false);
}
