protected void OnBtnNewDbClicked(object sender, EventArgs e) { //********************************************************************** //***Path do banco de dados***// String path = System.IO.Directory.GetCurrentDirectory() + "/"; String dbName = "sigomDb.db"; String dbPathFile = path + dbName; DbLite dbl = new DbLite(); dbl.showMessage(dbPathFile); //***Criando o banco de dados***// //dbl.dbCreate(dbPathFile); //***criando a tabela de login***// //string createTable = @"CREATE TABLE Login (ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,Nome VARCHAR(100) NOT NULL,Senha VARCHAR (10) NOT NULL )"; //dbl.dbSetCommand(dbPathFile, createTable); //***Inserir o administrador do login***// //String Nome = "admin"; //String Senha = "123456"; //String insertCommand = "INSERT INTO Login (Nome, Senha)"+ // "VALUES('"+Nome+"','"+Senha+"')"; //dbl.dbSetCommand(dbPathFile, insertCommand); }
protected void OnBtnLoginClicked(object sender, EventArgs e) { String path = System.IO.Directory.GetCurrentDirectory() + "/"; String dbName = "sigomDb.db"; String dbPathFile = path + dbName; DbLite dbl = new DbLite(); dbl.showMessage(dbPathFile); String tableName = "Login"; etrUser.Text = etrUser.Text.Trim(); etrPsw.Text = etrPsw.Text.Trim(); if ((etrUser.Text != "") && (etrPsw.Text != "")) { String getData = dbl.dbGetCommand(dbPathFile, tableName, "Nome", "Nome", etrUser.Text); if (etrUser.Text == getData) { getData = dbl.dbGetCommand(dbPathFile, tableName, "Senha", "Senha", etrPsw.Text); if (etrPsw.Text == getData) { sigom.WorkshopWindow ww = new sigom.WorkshopWindow(); ww.Show(); this.Destroy(); } else { dbl.showMessage("Usuário e/ou Senha incorreto!"); } } else { dbl.showMessage("Usuário e/ou Senha incorreto!"); } } else { dbl.showMessage("Usuário e/ou Senha é obrigatório!"); } }