public bool actualizarVehiculo_SQLite(Vehicle vehicle)
{
UDataBase db = new UDataBase(mContext);
var respuesta = db.UpdateVehicle(vehicle);
return(respuesta);
}
public List <Vehicle> obtenerTablaVehiculos_SQLite()
{
UDataBase db = new UDataBase(mContext);
List <Vehicle> lista = db.SelectTableVehicle();
return(lista);
}
public bool agregarVehiculo_SQLite(Vehicle vehicle)
{
UDataBase db = new UDataBase(mContext);
var respuesta = db.InsertIntoTableVehicle(vehicle);
return(respuesta);
}
public List <User> obtenerTablaUsuarios_SQLite()
{
UDataBase db = new UDataBase(mContext);
List <User> lista = db.SelectTableUser();
return(lista);
}
public void CrearBasedeDatos_SQLite()
{
try
{
UDataBase db = new UDataBase(mContext);
db.CreateDataBase();
}
catch (Exception ex)
{
Log.Info("CrearBasedeDatos_SQLite", ex.Message);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}
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);
}
}