public static List <cls_rooms> GetRooms_records()
{
List <cls_rooms> rooms = new List <cls_rooms>();
String query = "SELECT * FROM rooms";
MySqlCommand cmd = new MySqlCommand(query, cls_connection.Connection);
cls_connection.Connection.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int id = (int)reader["ID_r"];
String name = reader["name"].ToString();
String des = reader["description"].ToString();
float rate = (float)reader["rate"];
String s = reader["status"].ToString();
cls_rooms u = new cls_rooms(id, name, des, rate, s);
rooms.Add(u);
}
reader.Close();
cls_connection.Connection.Close();
return(rooms);
}
public static cls_rooms Insert(String n, string d, string r, string s)
{
String query = string.Format("INSERT INTO rooms(name,description, rate,status) VALUES ('{0}', '{1}','{2}','{3}')", n, d, r, s);
MySqlCommand cmd = new MySqlCommand(query, cls_connection.Connection);
cls_connection.Connection.Open();
cmd.ExecuteNonQuery();
int id = (int)cmd.LastInsertedId;
float ra = float.Parse(r);
cls_rooms user = new cls_rooms(id, n, d, ra, s);
cls_connection.Connection.Close();
return(user);
}
