public bool validRoomAd(RoomAd room)
{
bool status = true;
string query = "SELECT * FROM roomads WHERE StudentId = @StudentId AND Arrangement = @Arrangement AND PaymentType = @PaymentType AND RentAmount = @RentAmount";
using (MySqlCommand command = new MySqlCommand(query, new MySqlConnection(getConnectionString())))
{
command.Connection.Open();
command.Parameters.AddWithValue("@Arrangement", room.Arrangement);
command.Parameters.AddWithValue("@PaymentType", room.PaymentType);
command.Parameters.AddWithValue("@RentAmount", room.RentAmount);
command.Parameters.AddWithValue("@StudentId", room.StudentId);
command.CommandType = System.Data.CommandType.Text;
using (MySqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
if (reader.Read())
{
status = false;
}
}
reader.Close();
}
//Close Connection
command.Connection.Close();
}
return(status);
}
public bool postRoomAd(RoomAd room)
{
if (!validRoomAd(room))
{
return(false);
}
bool success = false;
query = @"INSERT INTO roomads(StudentId, Arrangement, DatePosted, Gender, Number, PaymentType, RentAmount) Values(@StudentId, @Arrangement, @DatePosted, @Gender, @Number, @PaymentType, @RentAmount)";
using (MySqlCommand command = new MySqlCommand(query, new MySqlConnection(getConnectionString())))
{
//General
command.Parameters.AddWithValue("@Arrangement", room.Arrangement);
command.Parameters.AddWithValue("@DatePosted", room.DatePosted);
command.Parameters.AddWithValue("@Gender", room.Gender);
command.Parameters.AddWithValue("@Number", room.Number);
command.Parameters.AddWithValue("@PaymentType", room.PaymentType);
command.Parameters.AddWithValue("@RentAmount", room.RentAmount);
command.Parameters.AddWithValue("@StudentId", room.StudentId);
command.Connection.Open();
command.CommandType = System.Data.CommandType.Text;
command.ExecuteNonQuery();
command.Connection.Close();
success = true;
}
return(success);
}
