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