public bool addRoom(int roomNumber, int numberOfBeds, string roomType, int roomPricePerNight, string roomDescirption)
{
MySqlCommand command = new MySqlCommand();
String insertQuery = "INSERT INTO `rooms`(`roomNumber`, `numberOfBeds`, `roomType`, `roomPricePerNight`, `roomDescription`) VALUES (@roomnum,@numbeds,@roomtype,@price,@roomdes)";
command.CommandText = insertQuery;
command.Connection = conn.getConnection();
command.Parameters.Add("@roomnum", MySqlDbType.Int32).Value = roomNumber;
command.Parameters.Add("@numbeds", MySqlDbType.Int32).Value = numberOfBeds;
command.Parameters.Add("@roomtype", MySqlDbType.VarChar).Value = roomType;
command.Parameters.Add("@price", MySqlDbType.Int32).Value = roomPricePerNight;
command.Parameters.Add("@roomdes", MySqlDbType.VarChar).Value = roomDescirption;
conn.openConnection();
if (command.ExecuteNonQuery() == 1)
{
conn.closeConnection();
return(true);
}
else
{
conn.closeConnection();
return(false);
}
}
//add res
public bool addReservation(int reservationId, int clientId, int roomNumber, string roomType, int dateIn, int dateOut)
{
MySqlCommand command = new MySqlCommand();
String insertQuery = "INSERT INTO `reservations`(`reservationId`, `clientId`, `roomNumber`, `roomType`, `dateIn`, `dateOut`) VALUES (@reservationid,@clientid,@roomnum,@roomtype,@datein,@dateout)";
command.CommandText = insertQuery;
command.Connection = conn.getConnection();
command.Parameters.Add("@reservationid", MySqlDbType.Int32).Value = reservationId;
command.Parameters.Add("@clientid", MySqlDbType.Int32).Value = clientId;
command.Parameters.Add("@roomnum", MySqlDbType.Int32).Value = roomNumber;
command.Parameters.Add("@roomtype", MySqlDbType.VarChar).Value = roomType;
command.Parameters.Add("@datein", MySqlDbType.VarChar).Value = dateIn;
command.Parameters.Add("@dateout", MySqlDbType.Int32).Value = dateOut;
conn.openConnection();
if (command.ExecuteNonQuery() == 1)
{
conn.closeConnection();
return(true);
}
else
{
conn.closeConnection();
return(false);
}
}
public bool insertClient(String fname, String sname, String phone, String email, String country)
{
MySqlCommand command = new MySqlCommand();
String insertQuery = "INSERT INTO `clients`(`forename`, `surname`, `phone`, `email`, `country`) VALUES (@fnm,@snm,@phn,@email,@country)";
command.CommandText = insertQuery;
command.Connection = conn.getConnection();
command.Parameters.Add("@fnm", MySqlDbType.VarChar).Value = fname;
command.Parameters.Add("@snm", MySqlDbType.VarChar).Value = sname;
command.Parameters.Add("@phn", MySqlDbType.VarChar).Value = phone;
command.Parameters.Add("@email", MySqlDbType.VarChar).Value = email;
command.Parameters.Add("@country", MySqlDbType.VarChar).Value = country;
conn.openConnection();
if (command.ExecuteNonQuery() == 1)
{
conn.closeConnection();
return(true);
}
else
{
conn.closeConnection();
return(false);
}
}
