public void BrokedRoom(BrokedRoomDTO room) { try { string connectionString = ConfigurationManager.ConnectionStrings["ConnectToSQL"].ConnectionString; IRoomRepository repository = new RoomRepository(connectionString); NewRoom newRoom = new NewRoom(); newRoom.Fio = room.Fio; newRoom.NumberPhone = room.NumberPhone; newRoom.Email = room.Email; newRoom.DescriptionRommId = room.DescriptionRommId; newRoom.DateFrom = room.DateFrom; newRoom.DateTo = room.DateTo; newRoom.Reserve = room.Reserve; repository.BrokedRoom(newRoom); } catch (Exception e) { Exception baseException = e.GetBaseException(); throw new FaultException(e.Message); } }
public int GetId(int numRecord) { string connectionString = ConfigurationManager.ConnectionStrings["ConnectToSQL"].ConnectionString; IRoomRepository repository = new RoomRepository(connectionString); int _id = 0; int counter = 0; var rooms = repository.SelectAll(); var roomDTOs = new List<RoomDTO>(); foreach (var room in rooms) { counter++; roomDTOs.Add(new RoomDTO() { Id = room.Id, Name = room.Name, Price = room.Price, npp = counter}); } foreach (var item in roomDTOs) { if (item.npp == numRecord) { _id = item.Id; break; } } return _id; }
public RoomDTO[] GetRooms() { string connectionString = ConfigurationManager.ConnectionStrings["HotelDatabase"].ConnectionString; IRoomRepository repository = new RoomRepository(connectionString); var rooms = repository.GetRooms(); var RoomDTOs = new List<RoomDTO>(); foreach (var room in rooms) { RoomDTOs.Add(new RoomDTO() { Id = room.Id, Number = room.Number, Quantity = room.Quantity, Reserved = room.Reserved }); } return RoomDTOs.ToArray(); }
public RoomDTO GetRowById(int id) { string connectionString = ConfigurationManager.ConnectionStrings["ConnectToSQL"].ConnectionString; IRoomRepository repository = new RoomRepository(connectionString); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand(queryGetAllId, connection)) { command.Parameters.AddWithValue("id", id); using (SqlDataReader reader = command.ExecuteReader()) { RoomDTO room = new RoomDTO(); if (reader.Read()) { room = (new RoomDTO() { Id = (int)reader["id"], Name = (string)reader["Name"], Price = (int)reader["Price"] }); return room; } else { return null; } } } } }
public RoomDTO[] SelectAll() { string connectionString = ConfigurationManager.ConnectionStrings["ConnectToSQL"].ConnectionString; IRoomRepository repository = new RoomRepository(connectionString); var rooms = repository.SelectAll(); var roomDTOs = new List<RoomDTO>(); foreach (var room in rooms) { roomDTOs.Add(new RoomDTO() { npp = room.npp, Id = room.Id, Name = room.Name, Price = room.Price }); } return roomDTOs.ToArray(); }