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