Exemplo n.º 1
0
        public bool save(Rezervare entity)
        {
            SQLiteConnection connection = dbUtils.getConnection();

            try
            {
                connection.Open();
                SQLiteCommand command = new SQLiteCommand(insertString, connection);
                command.Parameters.Add(new SQLiteParameter("numeC", entity.numeClient));
                command.Parameters.Add(new SQLiteParameter("numeT", entity.getStringTuristi()));
                command.Parameters.Add(new SQLiteParameter("nrT", entity.telefon));
                command.Parameters.Add(new SQLiteParameter("nrL", entity.nrLocuri));
                command.Parameters.Add(new SQLiteParameter("eid", entity.eId));


                command.ExecuteNonQuery();

                command.Dispose();
                connection.Close();
            }
            catch (Exception e)
            {
                log.Error(e);
                return(false);
            }


            return(true);
        }
Exemplo n.º 2
0
        public static RezervareDTO getDTO(Rezervare rezervare)
        {
            int    id          = rezervare.id;
            string numeClient  = rezervare.numeClient;
            string numeTuristi = rezervare.getStringTuristi();
            string telefon     = rezervare.telefon;
            int    nrLocuri    = rezervare.nrLocuri;
            int    eId         = rezervare.eId;

            return(new RezervareDTO(id, numeClient, numeTuristi, telefon, nrLocuri, eId));
        }