public int GetClientId(string email) { string connectionString = ConfigurationManager.ConnectionStrings["HotelServiceDB"].ConnectionString; IClientRepository repository = new ClientRepository(connectionString); int clientId = repository.ClientId(email); return clientId; }
public List<ClientDTO> GetClients() { string connectionString = ConfigurationManager.ConnectionStrings["HotelServiceDB"].ConnectionString; IClientRepository repository = new ClientRepository(connectionString); var clients = repository.GetClients(); var clientsDTO = new List<ClientDTO>(); foreach (var client in clients) { clientsDTO.Add(new ClientDTO() { Id = client.Id, FirstName = client.FirstName, LastName = client.LastName, Email = client.Email, Phone = client.Phone }); } return clientsDTO; }
public void InsertClient(ClientDTO clientDTO) { var client = new Client { FirstName = clientDTO.FirstName, LastName = clientDTO.LastName, Email = clientDTO.Email, Phone = clientDTO.Phone }; string connectionString = ConfigurationManager.ConnectionStrings["HotelServiceDB"].ConnectionString; IClientRepository repository = new ClientRepository(connectionString); repository.Insert(client); }