Пример #1
0
        public bool actualizarVehiculo_SQLite(Vehicle vehicle)
        {
            UDataBase db        = new UDataBase(mContext);
            var       respuesta = db.UpdateVehicle(vehicle);

            return(respuesta);
        }
Пример #2
0
        public List <Vehicle> obtenerTablaVehiculos_SQLite()
        {
            UDataBase      db    = new UDataBase(mContext);
            List <Vehicle> lista = db.SelectTableVehicle();

            return(lista);
        }
Пример #3
0
        public bool agregarVehiculo_SQLite(Vehicle vehicle)
        {
            UDataBase db        = new UDataBase(mContext);
            var       respuesta = db.InsertIntoTableVehicle(vehicle);

            return(respuesta);
        }
Пример #4
0
        public List <User> obtenerTablaUsuarios_SQLite()
        {
            UDataBase   db    = new UDataBase(mContext);
            List <User> lista = db.SelectTableUser();

            return(lista);
        }
Пример #5
0
 public void CrearBasedeDatos_SQLite()
 {
     try
     {
         UDataBase db = new UDataBase(mContext);
         db.CreateDataBase();
     }
     catch (Exception ex)
     {
         Log.Info("CrearBasedeDatos_SQLite", ex.Message);
     }
 }
Пример #6
0
 public bool borrarTablaPreUsos_SQLite()
 {
     try
     {
         UDataBase db = new UDataBase(mContext);
         db.DeleteTableCheckListSumary();
         Log.Info(TAG, "borrarTablaPreUsos_SQLite");
         return(true);
     }
     catch (Exception ex)
     {
         Log.Info("borrarTablaPreUsos_SQLite", ex.Message);
         return(false);
     }
 }
Пример #7
0
 public bool insertarTablaPreUsos_SQLite(List <CheckListSummary> lista)
 {
     try
     {
         UDataBase db = new UDataBase(mContext);
         db.InsertIntoTableListCheckListSumary(lista);
         Log.Info("insertarTablaPreUsos_SQLite", lista.ToString());
         return(true);
     }
     catch (Exception ex)
     {
         Log.Info("insertarTablaPreUsos_SQLite", ex.Message);
         return(false);
     }
 }
Пример #8
0
 public bool borrarPreUso_SQLite(CheckListSummary checkList)
 {
     try
     {
         UDataBase db = new UDataBase(mContext);
         db.DeleteCheckListSumary(checkList);
         Log.Info("borrarPreUso_SQLite", checkList.ToString());
         return(true);
     }
     catch (Exception ex)
     {
         Log.Error("borrarPreUso_SQLite", ex.Message);
         return(false);
     }
 }
Пример #9
0
 public bool actualizarPreUso_SQLite(CheckListSummary preUso)
 {
     try
     {
         UDataBase db = new UDataBase(mContext);
         db.UpdateCheckListSumary(preUso);
         Log.Info("actualizarPreUsos_SQLite", JsonConvert.SerializeObject(preUso));
         return(true);
     }
     catch (Exception ex)
     {
         Log.Error("actualizarPreUsos_SQLite", ex.Message);
         return(false);
     }
 }
Пример #10
0
 public List <CheckListSummary> obtenerTablaPreUsos_SQLite()
 {
     try
     {
         UDataBase db = new UDataBase(mContext);
         List <CheckListSummary> lista = db.SelectTableCheckListSumary();
         Log.Info("obtenerTablaPreUsos_SQLite", lista.ToString());
         return(lista);
     }
     catch (Exception ex)
     {
         Log.Info("obtenerTablaPreUsos_SQLite", ex.Message);
         return(null);
     }
 }
Пример #11
0
 public bool borrarTablaVehiculos_SQLite()
 {
     try
     {
         UDataBase db = new UDataBase(mContext);
         db.DeleteTableVehicles();
         Log.Info(TAG, "borrarTablaVehiculos_SQLite");
         return(true);
     }
     catch (Exception ex)
     {
         Log.Error("borrarTablaVehiculos_SQLite", ex.Message);
         return(false);
     }
 }
Пример #12
0
 public bool insertarTablaVehiculos_SQLite(List <Vehicle> lista)
 {
     try
     {
         UDataBase db = new UDataBase(mContext);
         db.InsertIntoTableListVehicles(lista);
         Log.Info("insertarTablaVehiculos_SQLite", lista.ToString());
         return(true);
     }
     catch (Exception ex)
     {
         Log.Error("insertarTablaVehiculos_SQLite", ex.Message);
         return(false);
     }
 }
Пример #13
0
 public bool borrarUsuario_SQLite(User usuario)
 {
     try
     {
         UDataBase db = new UDataBase(mContext);
         db.DeleteUser(usuario);
         Log.Info("borrarUsuario_SQLite", usuario.ToString());
         return(true);
     }
     catch (Exception ex)
     {
         Log.Error("borrarUsuario_SQLite", ex.Message);
         return(false);
     }
 }
Пример #14
0
 public bool actualizarUsuarios_SQLite(User usuario)
 {
     try
     {
         UDataBase db = new UDataBase(mContext);
         db.UpdateUser(usuario);
         Log.Info("actualizarUsuarios_SQLite", JsonConvert.SerializeObject(usuario));
         return(true);
     }
     catch (Exception ex)
     {
         Log.Error("actualizarUsuarios_SQLite", ex.Message);
         return(false);
     }
 }
Пример #15
0
 public bool actualizarPreUsos_SQLite(CheckListSummary preUso)
 {
     try
     {
         UDataBase db = new UDataBase(mContext);
         db.UpdateCheckListSumary(preUso);
         Log.Info("actualizarPreUsos_SQLite", preUso.ToString());
         return(true);
     }
     catch (Exception ex)
     {
         Log.Info("actualizarPreUsos_SQLite", ex.Message);
         return(false);
     }
 }
Пример #16
0
 public bool actualizarVehiculo_SQLite(Vehicle vehiculo)
 {
     try
     {
         UDataBase db = new UDataBase(mContext);
         db.UpdateVehicle(vehiculo);
         Log.Info("actualizarVehiculo_SQLite", JsonConvert.SerializeObject(vehiculo));
         return(true);
     }
     catch (Exception ex)
     {
         Log.Error("actualizarVehiculo_SQLite", ex.Message);
         return(false);
     }
 }
Пример #17
0
 public List <User> obtenerTablaUsuarios_SQLite()
 {
     try
     {
         UDataBase   db    = new UDataBase(mContext);
         List <User> lista = db.SelectTableUser();
         Log.Info("obtenerTablaUsuarios_SQLite", lista.ToString());
         return(lista);
     }
     catch (Exception ex)
     {
         Log.Info("obtenerTablaUsuarios_SQLite", ex.Message);
         return(null);
     }
 }
Пример #18
0
 public bool borrarVehiculo_SQLite(Vehicle vehiculo)
 {
     try
     {
         UDataBase db = new UDataBase(mContext);
         db.DeleteVehicle(vehiculo);
         Log.Info("borrarVehiculo_SQLite", vehiculo.ToString());
         return(true);
     }
     catch (Exception ex)
     {
         Log.Error("borrarVehiculo_SQLite", ex.Message);
         return(false);
     }
 }
Пример #19
0
 public List <Vehicle> obtenerTablaVehiculos_SQLite()
 {
     try
     {
         UDataBase      db    = new UDataBase(mContext);
         List <Vehicle> lista = db.SelectTableVehicle();
         Log.Info("obtenerTablaVehiculos_SQLite", lista.ToString());
         return(lista);
     }
     catch (Exception ex)
     {
         Log.Error("obtenerTablaVehiculos_SQLite", ex.Message);
         return(null);
     }
 }
Пример #20
0
 public bool actualizarVehiculo_SQLite(Vehicle vehiculo)
 {
     try
     {
         UDataBase db = new UDataBase(mContext);
         db.UpdateVehicle(vehiculo);
         Log.Info("actualizarVehiculo_SQLite", vehiculo.ToString());
         return(true);
     }
     catch (Exception ex)
     {
         Log.Info("actualizarVehiculo_SQLite", ex.Message);
         return(false);
     }
 }