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); }