public String restore_password(Login login) { String password = null; try { using (SQLiteConnection c = new conexion_sqlite().getConection()) { c.Open(); String sql = "SELECT password FROM LOGIN WHERE username = '******'"; using (SQLiteCommand cmd = new SQLiteCommand(sql, c)) { using (SQLiteDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { password = new Algoritmo_Encriptacion.Encriptacion().DecryptText(rdr["password"].ToString()); } } } } return(password); } catch (Exception e) { return(password); } }
public int findById(Login login) { String passwordEncrypt = new Algoritmo_Encriptacion.Encriptacion().EncryptText(login.password); //String passwordDecencrypt = new Algoritmo_Encriptacion.Encriptacion().DecryptText(passwordEncrypt, login.password); try { using (SQLiteConnection c = new conexion_sqlite().getConection()) { c.Open(); String sql = "SELECT id FROM LOGIN WHERE username ='******' AND password = '******'"; using (SQLiteCommand cmd = new SQLiteCommand(sql, c)) { using (SQLiteDataReader rdr = cmd.ExecuteReader()) { if (rdr.Read()) { return(1); } else { return(0); } } } } } catch (Exception e) { Console.WriteLine(e.Message); return(0); } }
public List <Manager> findByIdLogin(Login login, int flag) { List <Manager> lista = null; try { using (SQLiteConnection c = new conexion_sqlite().getConection()) { c.Open(); lista = new List <Manager>(); String sql = "SELECT id, username, password, url FROM MANAGER WHERE id_login = "******"id"].ToString()); String username = flag == 0 ? rdr["password"].ToString() : new Encriptacion().DecryptText(rdr["username"].ToString()); String password = flag == 0 ? rdr["password"].ToString() : new Encriptacion().DecryptText(rdr["password"].ToString()); String url = rdr["url"].ToString(); Manager manager_ = new Manager(id, username, password, url); lista.Add(manager_); } } } } return(lista); }catch (Exception e) { return(lista); } }
public int deleteById(Manager manager) { try { using (SQLiteConnection c = new conexion_sqlite().getConection()) { c.Open(); String sql = "DELETE FROM MANAGER WHERE id =" + manager.id; using (SQLiteCommand cmd = new SQLiteCommand(sql, c)) { return(cmd.ExecuteNonQuery()); } } } catch (Exception e) { Console.WriteLine(e.Message); return(0); } }
public int agregar(Login login) { try { String password = new Algoritmo_Encriptacion.Encriptacion().EncryptText(login.password); using (SQLiteConnection c = new conexion_sqlite().getConection()) { c.Open(); String sql = "INSERT INTO LOGIN (username, password) values ('" + login.username + "','" + password + "')"; using (SQLiteCommand cmd = new SQLiteCommand(sql, c)) { return(cmd.ExecuteNonQuery()); } } } catch (Exception e) { MessageBox.Show(e.Message); return(0); } }
public int updateById(Manager manager_) { try { String username = new Algoritmo_Encriptacion.Encriptacion().EncryptText(manager_.username); String password = new Algoritmo_Encriptacion.Encriptacion().EncryptText(manager_.password); using (SQLiteConnection c = new conexion_sqlite().getConection()) { c.Open(); String sql = "UPDATE MANAGER set username ='******',password='******',url='" + manager_.url + "' WHERE id =" + manager_.id; using (SQLiteCommand cmd = new SQLiteCommand(sql, c)) { return(cmd.ExecuteNonQuery()); } } } catch (Exception e) { Console.WriteLine(e.Message); return(0); } }
public int agregar(Manager manager) { String password = new Algoritmo_Encriptacion.Encriptacion().EncryptText(manager.password); String username = new Algoritmo_Encriptacion.Encriptacion().EncryptText(manager.username); try { using (SQLiteConnection c = new conexion_sqlite().getConection()) { c.Open(); String sql = "INSERT INTO MANAGER (username, password, url, id_login) values ('" + username + "','" + password + "','" + manager.url + "'," + manager.login + ")"; using (SQLiteCommand cmd = new SQLiteCommand(sql, c)) { return(cmd.ExecuteNonQuery()); } } } catch (Exception e) { Console.WriteLine(e.Message); return(0); } }