/// <summary>
/// Új yacht beírása az adatbázisba
/// </summary>
/// <param name="yacht"></param>
/// <returns></returns>
public bool MysqlAddYacht(Yacht yacht)
{
try
{
string query = "INSERT INTO enYacht(yacht_id, name, producer, ower, seats, width, lenght, dive, speed) VALUES (?yacht_id, ?name, ?producer, ?ower, ?seats, ?width, ?lenght, ?dive, ?speed);";
Globals.connect.Open();
using (MySqlCommand cmd = new MySqlCommand(query, Globals.connect))
{
cmd.Parameters.Add("?yacht_id", MySqlDbType.Int16).Value = MysqlGeneral.MysqlNextId("enYacht", "yacht_id");
cmd.Parameters.Add("?name", MySqlDbType.VarChar).Value = yacht.nev;
cmd.Parameters.Add("?producer", MySqlDbType.VarChar).Value = yacht.gyarto;
cmd.Parameters.Add("?ower", MySqlDbType.Int16).Value = yacht.member_id;
cmd.Parameters.Add("?seats", MySqlDbType.Int16).Value = yacht.ferohely;
cmd.Parameters.Add("?width", MySqlDbType.Float).Value = yacht.szeles;
cmd.Parameters.Add("?lenght", MySqlDbType.Float).Value = yacht.hossz;
cmd.Parameters.Add("?dive", MySqlDbType.Float).Value = yacht.merules;
cmd.Parameters.Add("?speed", MySqlDbType.Int16).Value = yacht.sebesseg;
cmd.ExecuteNonQuery();
}
}
catch (MySqlException ex)
{
MessageBox.Show("Error in adding mysql row. Error: " + ex.Message);
return(false);
}
finally
{
Globals.connect.Close();
}
return(true);
}
/// <summary>
/// Új szállitóeszköz beírása az adatbázisba
/// </summary>
/// <param name="device"></param>
/// <returns></returns>
public int MysqlAddDevice(Device device)
{
int id = 0;
try
{
string query = "INSERT INTO enDevice(device_id, type, ower, max_lenght, max_weight) VALUES (?device_id, ?type, ?ower, ?max_lenght, ?max_weight);";
Globals.connect.Open();
using (MySqlCommand cmd = new MySqlCommand(query, Globals.connect))
{
id = MysqlGeneral.MysqlNextId("enDevice", "device_id");
cmd.Parameters.Add("?device_id", MySqlDbType.Int16).Value = id;
cmd.Parameters.Add("?type", MySqlDbType.VarChar).Value = device.tipus;
cmd.Parameters.Add("?ower", MySqlDbType.Int16).Value = device.member_id;
cmd.Parameters.Add("?max_lenght", MySqlDbType.VarChar).Value = device.max_hossz;
cmd.Parameters.Add("?max_weight", MySqlDbType.Int16).Value = device.max_suly;
cmd.ExecuteNonQuery();
}
}
catch (MySqlException)
{
return(0);
}
finally
{
Globals.connect.Close();
}
return(id);
}
/// <summary>
/// Új Felhasználói login beírása a Login táblába
/// </summary>
/// <param name="regisztration">Az új felhasználó</param>
public void MysqlRegisztracioLogin(Felhasznalo regisztration)
{
try
{
string query = "INSERT INTO enLogin(login_id, login_name, password, email, admin) VALUES (?login_id, ?login_name,?password,?email, ?admin);";
Globals.connect.Open();
int id = MysqlGeneral.MysqlNextId("enLogin", "login_id");
using (MySqlCommand cmd = new MySqlCommand(query, Globals.connect))
{
cmd.Parameters.Add("?login_id", MySqlDbType.Int16).Value = id;
cmd.Parameters.Add("?login_name", MySqlDbType.VarChar).Value = regisztration.login.felhasznalonev;
cmd.Parameters.Add("?password", MySqlDbType.VarChar).Value = Globals.Encryption(regisztration.login.jelszo);
cmd.Parameters.Add("?email", MySqlDbType.VarChar).Value = regisztration.login.email;
cmd.Parameters.Add("?admin", MySqlDbType.Bit).Value = regisztration.login.admin ? 1 : 0;
cmd.ExecuteNonQuery();
}
MysqlRegisztracionUser(regisztration, id);
}
catch (MySqlException ex)
{
MessageBox.Show("Error in adding mysql row. Error: " + ex.Message);
}
finally
{
Globals.connect.Close();
}
}
public void MysqlNewMessage(Message uzenet)
{
try
{
string query = "INSERT INTO enMessage(message_id, price, sender, addressee, yacht_id, device_id, start_date, end_date, from_port, to_port) VALUES (?message_id, ?price, ?sender, ?addressee, ?yacht_id, ?device_id, ?start_date, ?end_date, ?from_port, ?to_port);";
Globals.connect.Open();
int id = MysqlGeneral.MysqlNextId("enMessage", "message_id");
using (MySqlCommand cmd = new MySqlCommand(query, Globals.connect))
{
cmd.Parameters.Add("?message_id", MySqlDbType.Int16).Value = id;
cmd.Parameters.Add("?price", MySqlDbType.Int16).Value = uzenet.price;
cmd.Parameters.Add("?sender", MySqlDbType.Int16).Value = Globals.User.member_id;
cmd.Parameters.Add("?addressee", MySqlDbType.Int16).Value = uzenet.cimzett_id;
if (uzenet.yacht_id != -1)
{
cmd.Parameters.Add("?yacht_id", MySqlDbType.Int16).Value = uzenet.yacht_id;
cmd.Parameters.Add("?device_id", MySqlDbType.Int16).Value = DBNull.Value;
}
else if (uzenet.device_id != -1)
{
cmd.Parameters.Add("?yacht_id", MySqlDbType.Int16).Value = DBNull.Value;
cmd.Parameters.Add("?device_id", MySqlDbType.Int16).Value = uzenet.device_id;
}
if (uzenet.honnan_id != -1 && uzenet.hova_id != -1)
{
cmd.Parameters.Add("?from_port", MySqlDbType.Int16).Value = uzenet.honnan_id;
cmd.Parameters.Add("?to_port", MySqlDbType.Int16).Value = uzenet.hova_id;
}
else
{
cmd.Parameters.Add("?from_port", MySqlDbType.Int16).Value = DBNull.Value;
cmd.Parameters.Add("?to_port", MySqlDbType.Int16).Value = DBNull.Value;
}
cmd.Parameters.Add("?start_date", MySqlDbType.DateTime).Value = uzenet.kezdete;
cmd.Parameters.Add("?end_date", MySqlDbType.DateTime).Value = uzenet.vege;
cmd.ExecuteNonQuery();
}
}
catch (MySqlException ex)
{
MessageBox.Show("Error in adding mysql row. Error: " + ex.Message);
}
finally
{
Globals.connect.Close();
}
}
/// <summary>
/// Új felhasználó beszurása a YachClubTag táblába
/// </summary>
/// <param name="regisztration">A felhasználó adatai</param>
/// <param name="id">A hozzá tartozó login id</param>
private void MysqlRegisztracionUser(Felhasznalo regisztration, int id)
{
try
{
string query = "INSERT INTO enYacht_Club_Tag(member_id, login_id, nickname, last_name, first_name, birthday, zip_code, address, country) VALUES (?member_id, ?login_id, ?nickname, ?last_name, ?first_name, ?birthday, ?zip_code, ?address, ?country);";
using (MySqlCommand cmd = new MySqlCommand(query, Globals.connect))
{
cmd.Parameters.Add("?member_id", MySqlDbType.Int16).Value = MysqlGeneral.MysqlNextId("enYacht_Club_Tag", "member_id");
cmd.Parameters.Add("?login_id", MySqlDbType.Int16).Value = id;
cmd.Parameters.Add("?nickname", MySqlDbType.VarChar).Value = regisztration.nickname;
cmd.Parameters.Add("?last_name", MySqlDbType.VarChar).Value = regisztration.kereszt_nev;
cmd.Parameters.Add("?first_name", MySqlDbType.VarChar).Value = regisztration.veztek_nev;
cmd.Parameters.Add("?birthday", MySqlDbType.DateTime).Value = regisztration.szuletesdt;
cmd.Parameters.Add("?zip_code", MySqlDbType.Int16).Value = regisztration.iranyitoszm;
cmd.Parameters.Add("?address", MySqlDbType.VarChar).Value = regisztration.lakcim;
cmd.Parameters.Add("?country", MySqlDbType.VarChar).Value = regisztration.orszag;
cmd.ExecuteNonQuery();
}
}
catch (MySqlException ex)
{
MessageBox.Show("Error in adding mysql row. Error: " + ex.Message);
}
}