public void save(Flight entity) { var con = DBUtils.getConnection(props); using (var comm = con.CreateCommand()) { comm.CommandText = "insert into flights (departureDate, departureTime, airport, destination, places) values ( @departureDate, @departureTime, @airport, @destination, @places)"; var paramDepartureDate = comm.CreateParameter(); paramDepartureDate.ParameterName = "@departureDate"; paramDepartureDate.Value = entity.DepartureDate; comm.Parameters.Add(paramDepartureDate); var paramDepartureTime = comm.CreateParameter(); paramDepartureTime.ParameterName = "@departureTime"; paramDepartureTime.Value = entity.DepartureTime; comm.Parameters.Add(paramDepartureTime); var paramAirport = comm.CreateParameter(); paramAirport.ParameterName = "@airport"; paramAirport.Value = entity.Airport; comm.Parameters.Add(paramAirport); var paramDestination = comm.CreateParameter(); paramDestination.ParameterName = "@destination"; paramDestination.Value = entity.Destination; comm.Parameters.Add(paramDestination); var paramPlaces = comm.CreateParameter(); paramPlaces.ParameterName = "@places"; paramPlaces.Value = entity.Places; comm.Parameters.Add(paramPlaces); var result = comm.ExecuteNonQuery(); if (result == 0) { throw new RepositoryException("No flight added !"); } } }
public void save(SortingTask entity) { var con = DBUtils.getConnection(); using (var comm = con.CreateCommand()) { comm.CommandText = "insert into SortingTasks values (@idT, @desc, @elems, @orderC, @algo)"; var paramId = comm.CreateParameter(); paramId.ParameterName = "@idT"; paramId.Value = entity.Id; comm.Parameters.Add(paramId); var paramDesc = comm.CreateParameter(); paramDesc.ParameterName = "@desc"; paramDesc.Value = entity.Description; comm.Parameters.Add(paramDesc); var paramElems = comm.CreateParameter(); paramElems.ParameterName = "@elems"; paramElems.Value = entity.Elems; comm.Parameters.Add(paramElems); IDbDataParameter paramOrder = comm.CreateParameter(); paramOrder.ParameterName = "@orderC"; paramOrder.Value = entity.Order.ToString(); comm.Parameters.Add(paramOrder); IDbDataParameter paramAlgo = comm.CreateParameter(); paramAlgo.ParameterName = "@algo"; paramAlgo.Value = entity.Algorithm.ToString(); comm.Parameters.Add(paramAlgo); var result = comm.ExecuteNonQuery(); if (result == 0) { throw new RepositoryException("No task added !"); } } }
public void save(Booking entity) { var con = DBUtils.getConnection(props); using (var comm = con.CreateCommand()) { comm.CommandText = "insert into bookings (flightId, clientName, clientAddress, tourists, nrSeats) values ( @flightId, @clientName, @clientAddress, @tourists, @nrSeats)"; var paramFlightId = comm.CreateParameter(); paramFlightId.ParameterName = "@flightId"; paramFlightId.Value = entity.FlightId; comm.Parameters.Add(paramFlightId); var paramClientName = comm.CreateParameter(); paramClientName.ParameterName = "@clientName"; paramClientName.Value = entity.ClientName; comm.Parameters.Add(paramClientName); var paramClientAddress = comm.CreateParameter(); paramClientAddress.ParameterName = "@clientAddress"; paramClientAddress.Value = entity.ClientAddress; comm.Parameters.Add(paramClientAddress); var paramTourists = comm.CreateParameter(); paramTourists.ParameterName = "@tourists"; paramTourists.Value = entity.Tourists; comm.Parameters.Add(paramTourists); var paramNrSeats = comm.CreateParameter(); paramNrSeats.ParameterName = "@nrSeats"; paramNrSeats.Value = entity.NrSeats; comm.Parameters.Add(paramNrSeats); var result = comm.ExecuteNonQuery(); if (result == 0) { throw new RepositoryException("No booking added !"); } } }
public IEnumerable <Flight> findAllFlightsWithDestinationAndDate(String fDestination, String fDate) { IDbConnection con = DBUtils.getConnection(props); IList <Flight> flightList = new List <Flight>(); using (var comm = con.CreateCommand()) { comm.CommandText = "select id, departureDate, departureTime, airport, destination, places from flights where destination=@destination and departureDate=@departureDate"; IDbDataParameter paramDestinaton = comm.CreateParameter(); paramDestinaton.ParameterName = "@destination"; paramDestinaton.Value = fDestination; comm.Parameters.Add(paramDestinaton); IDbDataParameter paramDate = comm.CreateParameter(); paramDate.ParameterName = "@departureDate"; paramDate.Value = fDate; comm.Parameters.Add(paramDate); using (var dataR = comm.ExecuteReader()) { while (dataR.Read()) { int idF = dataR.GetInt32(0); String departureDate = dataR.GetString(1); String departureTime = dataR.GetString(2); String airport = dataR.GetString(3); String destination = dataR.GetString(4); int places = dataR.GetInt32(5); Flight flight = new Flight(idF, departureDate, departureTime, airport, destination, places); Console.Write("(findAllFlightsWithDestinationAndDate) zbor gasit cu id-ul:" + idF + "\n"); flightList.Add(flight); } } } return(flightList); }
public Employee login(string username, string password) { log.InfoFormat("Entering findOne with value {0}", username); IDbConnection con = DBUtils.getConnection(props); using (var comm = con.CreateCommand()) { comm.CommandText = "select id,username, password from employees where username=@username and password=@password"; var paramUsername = comm.CreateParameter(); paramUsername.ParameterName = "@username"; paramUsername.Value = username; comm.Parameters.Add(paramUsername); var paramPassword = comm.CreateParameter(); paramPassword.ParameterName = "@password"; paramPassword.Value = password; comm.Parameters.Add(paramPassword); using (var dataR = comm.ExecuteReader()) { if (dataR.Read()) { int idE = dataR.GetInt32(0); String usernameFound = dataR.GetString(1); String passwordFound = dataR.GetString(2); Employee employee = new Employee(idE, usernameFound, passwordFound); log.InfoFormat("Exiting findOne with value {0}", employee); Console.Write("login successful for " + usernameFound + "\n"); return(employee); } } } log.InfoFormat("Exiting findOne with value {0}", null); return(null); }
public IEnumerable <Participant> findAll() { IDbConnection con = DBUtils.getConnection(); IList <Participant> tasksR = new List <Participant>(); using (var comm = con.CreateCommand()) { comm.CommandText = "select idParticipant,nume, varsta from Participant"; using (var dataR = comm.ExecuteReader()) { while (dataR.Read()) { int idParticipant = dataR.GetInt32(0); String nume = dataR.GetString(1); int varsta = dataR.GetInt32(2); Participant participant = new Participant(idParticipant, nume, varsta); tasksR.Add(participant); } } } return(tasksR); }
public IEnumerable <Organizator> findAll() { IDbConnection con = DBUtils.getConnection(); IList <Organizator> tasksR = new List <Organizator>(); using (var comm = con.CreateCommand()) { comm.CommandText = "select idOrganizator,username, password from Organizator"; using (var dataR = comm.ExecuteReader()) { while (dataR.Read()) { int idOrganizator = dataR.GetInt32(0); String username = dataR.GetString(1); String password = dataR.GetString(2); Organizator Organizator = new Organizator(idOrganizator, username, password); tasksR.Add(Organizator); } } } return(tasksR); }