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