public List<Room> GetRoomList() { List<Room> rooms = new List<Room>(); SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM Room"; connection.Open(); SqlCommand command = new SqlCommand(query, connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Room room=new Room(); room.Id = int.Parse(reader["Id"].ToString()); room.RoomNo = int.Parse(reader["RoomNo"].ToString()); room.CategoryId = int.Parse(reader["CategoryId"].ToString()); room.Description = reader["Description"].ToString(); rooms.Add(room); } reader.Close(); connection.Close(); return rooms; }
public string Insert(Room room) { if (room.RoomNo.ToString() == "") { return "Enter a room no "; } else if (room.CategoryId.ToString()=="") { return "Select a category"; } else if (roomGateway.HasThisRoomExists(room.RoomNo)) { return "Room number must be unique"; } else { int value = roomGateway.Insert(room); if (value > 0) { return "Room Saved Successfully"; } else { return "Operation Failed"; } } }
public int Insert(Room room) { SqlConnection connection=new SqlConnection(connectionString); string query = "INSERT INTO Room VALUES('"+room.RoomNo+"','"+room.CategoryId+"','"+room.Description+"')"; SqlCommand command=new SqlCommand(query,connection); connection.Open(); int rowsAffected = command.ExecuteNonQuery(); connection.Close(); return rowsAffected; }