public void SubAgregarCatalogo(CAT_Plantilla_Movil lObjMovil)
{
string dbPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "IccDb.db3");
var db = new SQLiteConnection(dbPath);
db.Insert(lObjMovil);
}
public int FncValidarUsuario(string lStrUsuario, string lStrContrasena)
{
string dbPath = Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "IccDb.db3");
var db = new SQLiteConnection(dbPath);
CAT_Plantilla_Movil lObjTabla = new CAT_Plantilla_Movil();
lObjTabla = db.Query <CAT_Plantilla_Movil>("SELECT * FROM CAT_Plantilla_Movil WHERE Tabla = 'LOGIN' AND Prefijo = ? AND Descripcion = ?",
lStrUsuario, lStrContrasena).FirstOrDefault();
if (lObjTabla == null)
{
lObjTabla = new CAT_Plantilla_Movil();
lObjTabla.Orden = -1;
}
return(Convert.ToInt32(lObjTabla.Orden));
}
