public static bool Init() { try { m_cards = new Dictionary <int, CardData>(); string currentPath = System.Reflection.Assembly.GetExecutingAssembly().Location; currentPath = Path.GetDirectoryName(currentPath) ?? ""; string absolutePath = Path.Combine(currentPath, "Content/cards.cdb"); if (!File.Exists(absolutePath)) { return(false); } using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + absolutePath)) { connection.Open(); const string select = "SELECT datas.id, alias, type, level, race, attribute, atk, def, name, desc " + "FROM datas INNER JOIN texts ON datas.id = texts.id"; SQLiteCommand command = new SQLiteCommand(select, connection); using (SQLiteDataReader reader = command.ExecuteReader()) InitCards(reader); command.Dispose(); } return(true); } catch (Exception) { return(false); } }
public static void Init() { try { _cards = new Dictionary<int, CardData>(); string currentPath = Assembly.GetExecutingAssembly().Location; currentPath = Path.GetDirectoryName(currentPath) ?? ""; string absolutePath = Path.Combine(currentPath, "cards.cdb"); if (!File.Exists(absolutePath)) { throw new Exception("Could not find the cards database."); } using (SqliteConnection connection = new SqliteConnection("Data Source=" + absolutePath)) { connection.Open(); const string select = "SELECT datas.id, alias, type, level, race, attribute, atk, def, name, desc " + "FROM datas INNER JOIN texts ON datas.id = texts.id"; using (SqliteCommand command = new SqliteCommand(select, connection)) using (SqliteDataReader reader = command.ExecuteReader()) InitCards(reader); } } catch (Exception ex) { throw new Exception("Could not initialize the cards database. Check the inner exception for more details.", ex); } }
/** * Try and move an item from an oldowner to a new owner * @param oldOwner the owner trying to move the item from * @param newOwner the owner tyring to move the item too. * @param item the name of the item to be moved. */ public String MoveItem(String oldOwner, String newOwner, String item) { var command = new sqliteCommand("select * from " + itemTableName + " where owner =:owner AND name =:item ", Database); command.Parameters.Add("owner", DbType.String).Value = oldOwner; command.Parameters.Add("item", DbType.String).Value = item; try { var reader = command.ExecuteReader(); if (reader.HasRows) { reader.Read(); if (ChangeItemOwner(reader["uniqueID"].ToString(), newOwner)) { return("You "); } } } catch (Exception ex) { Console.Write("Item Not recognised: " + ex); } return("Failed To "); }
/** * Get all items with where the owner field is equal to that of the players name * @param owner the entity to whom the items belong. */ public String GetOwnedItems(String owner) { String rString = U.NL(""); var command = new sqliteCommand("select * from " + itemTableName + " where owner =:name ", Database); command.Parameters.Add("name", DbType.String).Value = owner; try { var reader = command.ExecuteReader(); while (reader.Read()) { //make the description String id = reader["itemID"].ToString(); rString += U.NL("Name: " + gameObjectList.GetItem(id).itemName); rString += U.NL("Description: " + gameObjectList.GetItem(id).description); U.NL(""); } } catch (Exception ex) { Console.Write("Failed to get inventory" + ex); rString += "Could not find items"; } return(rString); }
public void InsertData(string scene, string posx,string posy) { _query = "INSERT INTO continar VALUES('PEPE','"+scene+"','"+posx+"','"+ posy +"')";//continar? _command = _conexion.CreateCommand (); _command.CommandText = _query; _command.ExecuteReader (); }
public void InsertMonsters() { string[] nombres = SaveMonster.GetMonsterList(); Monstruo temp; if (PlayerPrefs.GetString ("botonPresionado") == "new") { DeleteMonsters(); } for(int i = 0;i < nombres.Length;++i){ temp = SaveMonster.LoadMonster(nombres[i]); _query="SELECT * FROM tablaMonstruos WHERE owner='PEPE' and name='"+temp.nombre+"'"; _command = _conexion.CreateCommand (); _command.CommandText = _query; _reader = _command.ExecuteReader (); int cont=0; if(_reader != null){ while(_reader.Read()){ cont++; } if(cont!=0){ _query= "UPDATE tablaMonstruos set specie='"+temp.especie+"',exp='"+temp.exp.ToString()+"',modStats='"+temp.modStats.ToString()+"',estado='"+temp.estado.ToString()+"' WHERE owner='PEPE' and name='"+temp.nombre+"'"; }else{ _query = "INSERT INTO tablaMonstruos VALUES('"+temp.nombre+"','"+temp.especie+"','"+temp.exp.ToString()+"','"+temp.modStats.ToString()+"','"+temp.estado.ToString()+"','PEPE')"; } } _command = _conexion.CreateCommand(); _command.CommandText = _query; _command.ExecuteReader(); } }
public void DeleteMonsters() { _query = "DELETE FROM tablaMonstruos WHERE owner='PEPE'"; _command = _conexion.CreateCommand (); _command.CommandText = _query; _command.ExecuteReader (); }
public void CrearTablaMonstruos(string tabla) { _query = "CREATE TABLE "+tabla+" (name CHAR(20), specie CHAR(20), exp CHAR(40), modstats CHAR(100), estado CHAR(100), owner CHAR(20));"; _command = _conexion.CreateCommand(); _command.CommandText = _query; _command.ExecuteReader(); }
public void CrearTabla(string tabla) { _query = "CREATE TABLE "+tabla+"(name CHAR(20) NOT NULL, scene CHAR(20), posicionX CHAR (20), posicionY CHAR(20));"; _command = _conexion.CreateCommand(); _command.CommandText = _query; _command.ExecuteReader(); }
/** * Adds a new player to the player table * @param tempPlayer the player so far that we will add. * @param password the salted-hashes password the player used to login * @param salt the salt used to hash the password and used for encryption */ public bool AddPlayer(Player tempPlayer, String password, String salt) { var command = new sqliteCommand("select * from " + playerTableName + " where name =:id", Database); command.Parameters.Add("id", DbType.String).Value = tempPlayer.PlayerName; var reader = command.ExecuteReader(); if (reader.HasRows == false && !U.HasBadChars(tempPlayer.PlayerName) && !U.HasBadChars(password)) { try { command = new sqliteCommand("INSERT INTO " + playerTableName + " (name, password, salt, rIndex) " + "VALUES ($n, $p, $s, $i) ", Database); command.Parameters.Add("$n", DbType.String).Value = tempPlayer.PlayerName; command.Parameters.Add("$p", DbType.String).Value = password; command.Parameters.Add("$s", DbType.String).Value = salt; command.Parameters.Add("$i", DbType.Int32).Value = tempPlayer.RoomIndex; command.ExecuteNonQuery(); ActivePlayers.Add(tempPlayer.PlayerName); return(true); } catch (Exception ex) { Console.WriteLine("Failed Adding to DB: " + ex); return(false); } } else { return(false); } }
public GUIhosts(GUImain gui, SqliteConnection connection, SqliteCommand command) { InitializeComponent(); InitializeList(); this.gui = gui; _connection = connection; _command = command; using (_command = new SqliteCommand("SELECT host, port, password FROM hosts ORDER BY id DESC", _connection)) { using (SqliteDataReader reader = _command.ExecuteReader()) { while (reader.Read()) { String host = gui.GetSafeString(reader, 0); String port = gui.GetSafeString(reader, 1); String password = gui.GetSafeString(reader, 2); String[] items = { host, port, password }; ListViewItem item = new ListViewItem(items); list.Items.Add(item); } } } }
public static bool Init() { try { m_cards = new Dictionary<int, CardData>(); string currentPath = System.Reflection.Assembly.GetExecutingAssembly().Location; currentPath = Path.GetDirectoryName(currentPath) ?? ""; string absolutePath = Path.Combine(currentPath, "Content/cards.cdb"); if (!File.Exists(absolutePath)) return false; using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + absolutePath)) { connection.Open(); const string select = "SELECT datas.id, alias, type, level, race, attribute, atk, def, name, desc " + "FROM datas INNER JOIN texts ON datas.id = texts.id"; SQLiteCommand command = new SQLiteCommand(select, connection); using (SQLiteDataReader reader = command.ExecuteReader()) InitCards(reader); command.Dispose(); } return true; } catch (Exception) { return false; } }
public static List<string[]> ExecuteStringCommand(SqliteCommand command, int columncount) { try { var values = new List<string[]>(); SqliteDataReader reader = command.ExecuteReader(); while (reader.Read()) { var row = new List<string>(); for (int i = 0; i < reader.FieldCount; i++) { row.Add(reader[i].ToString()); } values.Add(row.ToArray()); } reader.Close(); return values; } catch (Exception ex) { MessageBox.Show(ex.Message); return new List<string[]>(); } }
public void UpdateOrders() { MainClass.StatusMessage("Получаем таблицу заказов..."); string sql = "SELECT orders.id, orders.customer, orders.contract, orders.address, orders.phone1, orders.phone2, orders.arrval, orders.deadline_s, orders.deadline_e FROM orders "; SqliteCommand cmd = new SqliteCommand(sql, (SqliteConnection) QSMain.ConnectionDB); using(SqliteDataReader rdr = cmd.ExecuteReader()) { OrdersListStore.Clear(); while (rdr.Read()) { OrdersListStore.AppendValues(rdr.GetInt32(rdr.GetOrdinal("id")), rdr["customer"].ToString(), rdr["contract"].ToString(), rdr["phone1"].ToString() + rdr["phone2"].ToString(), rdr["address"].ToString(), String.Format("{0:d}", rdr["arrval"]), DateWorks.GetDateRangeText(DBWorks.GetDateTime(rdr, "deadline_s", new DateTime()), DBWorks.GetDateTime(rdr, "deadline_e", new DateTime())) ); } } MainClass.StatusMessage("Ok"); }
public void CommitTransaction() { var lst = new List<string>(); using (var cmd = new SqliteCommand(String.Format("SELECT DISTINCT [TableName] FROM {0}", TranStatusTable), ActiveConnection)) { using (SqliteDataReader r = cmd.ExecuteReader()) { while (r.Read()) { lst.Add(r.GetString(0)); } } } SqliteTransaction tran = ActiveConnection.BeginTransaction(); try { foreach (String tableName in lst) { using (var cmd = new SqliteCommand(String.Format("DELETE FROM __{0}", tableName), tran.Connection, tran)) cmd.ExecuteNonQuery(); } using (var cmd = new SqliteCommand(String.Format("DELETE FROM {0}", TranStatusTable), tran.Connection, tran)) cmd.ExecuteNonQuery(); tran.Commit(); } catch { tran.Rollback(); throw; } }
public static void Init(string databaseFullPath) { try { if (!File.Exists(databaseFullPath)) { throw new Exception("Could not find the cards database."); } _cards = new Dictionary<int, NamedCard>(); using (SqliteConnection connection = new SqliteConnection("Data Source=" + databaseFullPath)) { connection.Open(); using (IDbCommand command = new SqliteCommand( "SELECT datas.id, ot, alias, setcode, type, level, race, attribute, atk, def, texts.name, texts.desc" + " FROM datas INNER JOIN texts ON datas.id = texts.id", connection)) { using (IDataReader reader = command.ExecuteReader()) { while (reader.Read()) { LoadCard(reader); } } } } } catch (Exception ex) { throw new Exception("Could not initialize the cards database. Check the inner exception for more details.", ex); } }
/// <summary> /// Returns all categories. /// </summary> public IEnumerable<Category> GetAllCategories() { var categories = new List<Category>(); using (var connection = new SqliteConnection("Data Source=" + dbPath)) using (var query = new SqliteCommand("SELECT * FROM Categories", connection)) { connection.Open(); var reader = query.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { var category = new Category(); category.Id = int.Parse(reader["id"].ToString()); category.Name = reader ["name"].ToString(); categories.Add(category); } reader.Close(); } return categories; }
public void Fill(int id) { ItemId = id; NewItem = false; MainClass.StatusMessage(String.Format ("Запрос выставки №{0}...", id)); string sql = "SELECT exhibition.* FROM exhibition WHERE exhibition.id = @id"; try { SqliteCommand cmd = new SqliteCommand(sql, (SqliteConnection) QSMain.ConnectionDB); cmd.Parameters.AddWithValue("@id", id); using(SqliteDataReader rdr = cmd.ExecuteReader()) { rdr.Read(); labelID.Text = rdr["id"].ToString(); entryName.Text = rdr["name"].ToString(); entryPhone1.Text = DBWorks.GetString(rdr, "phone", ""); entryPhone2.Text = DBWorks.GetString(rdr, "phone2", ""); textAddress.Buffer.Text = DBWorks.GetString(rdr, "address", ""); } MainClass.StatusMessage("Ok"); this.Title = entryName.Text; } catch (Exception ex) { QSMain.ErrorMessageWithLog(this, "Ошибка получения информации о номенклатуре!", logger, ex); } TestCanSave(); }
public static List<Dictionary<string, string>> QueryImpl(string handler, string statement, string[] param) { List<Dictionary<string,string>> result = new List<Dictionary<string,string>>(); var db = dbs[handler]; var dbcmd = new SqliteCommand(ConvertStatment(statement), db); // Hard and ugly hack to use '?' for (var i = 1; i <= param.Length; i++) { dbcmd.Parameters.AddWithValue("@a" + i, param[i-1]); } IDataReader reader = dbcmd.ExecuteReader(); while(reader.Read()) { Dictionary<string,string> row = new Dictionary<string,string>(); for (var i = 0; i < reader.FieldCount; i++) { string val = reader.GetValue(i).ToString(); row.Add(reader.GetName(i),val); } result.Add(row); } reader.Dispose(); dbcmd.Dispose(); return result; }
/** * Used if loading from an exsisitng dungeon. It will cycle through the dungeon table * getting all the rooms and adding them to the new dungeons room list * Having the dungeon as dynamic memory, allows for quicker sanity checks incase * players try and break things. The databse is always written to if the player * actuallty does anything. */ public Dungeon GetDungeon() { Dungeon d = new Dungeon(); try { var command = new sqliteCommand("select * from " + dungeonTableName, Database); var reader = command.ExecuteReader(); while (reader.Read()) { Room r = new Room(); r.name = reader["name"].ToString(); r.desc = reader["description"].ToString(); r.RoomIndex = Int32.Parse(reader["rIndex"].ToString()); r.north = Int32.Parse(reader["north"].ToString()); r.east = Int32.Parse(reader["east"].ToString()); r.south = Int32.Parse(reader["south"].ToString()); r.west = Int32.Parse(reader["west"].ToString()); d.GetRoomList().Add(r); } reader.Close(); Console.WriteLine(""); } catch (Exception ex) { Console.WriteLine("Failed to display DB" + ex); } return(d); }
private void liqviscdata() { con.Open(); string stm = "SELECT * FROM windowsdata WHERE comp='"+comppicker.SelectedItem+"' ORDER BY comp "; using (SqliteCommand cmd = new SqliteCommand(stm, con)) { using (SqliteDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { tcenti = double.Parse(temp.Text); tk = tcenti + 273.15; viscb =double.Parse( rdr["viscb"].ToString()); viscc = double.Parse(rdr["viscc"].ToString()); if (viscc != 0) { double visc1 = viscb * ((1 / tk) - (1 / viscc)); double viscocity = Math.Pow(10, visc1); Liqvisc.Text = viscocity.ToString(); } else { Liqvisc.Text = "0"; } } } } con.Close(); }
static List<Dictionary<string, object>> ExecuteQuery(string query, List<SqliteParameter> pars) { List<Dictionary<string, object>> res = new List<Dictionary<string, object>>(); using (var Conn = GetConnection()) { Conn.Open(); using (SqliteCommand command = new SqliteCommand(query, Conn)) { foreach (var par in pars) command.Parameters.Add(par); using (var reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { res.Add(new Dictionary<string, object>()); for (int i = 0; i < reader.FieldCount; i++) { res[res.Count - 1][reader.GetName(i)] = reader[i]; } } } } } } return res; }
private void vapdata() { tcenti = int.Parse(temp.Text); tk = 273.15 + tcenti; con.Open(); string stm = "SELECT * FROM VAPDATA2 WHERE Name ='"+comppicker.SelectedItem+"'"; using (SqliteCommand cmd = new SqliteCommand(stm, con)) { using (SqliteDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { ct1 = double.Parse(rdr["C1"].ToString()); ct2 = double.Parse(rdr["C2"].ToString()); ct3 = double.Parse(rdr["C3"].ToString()); ct4 = double.Parse(rdr["C4"].ToString()); ct5 = double.Parse(rdr["C5"].ToString()); } } } con.Close(); vpresure = (Math.Exp(ct1 + (ct2 / tk) + ct3 * Math.Log(tk) + ct4 * Math.Pow(tk, ct5)) / 100000); vp.Text = vpresure.ToString(); }
static public SqliteDataReader ExecuteQuery(string sqlQuery) { dbCommand = OpenDB("monsters.db").CreateCommand(); dbCommand.CommandText = sqlQuery; reader = dbCommand.ExecuteReader(); return reader; }
public override void update(ActionTimer timer) { List <Account> _list = new List <Account>(); using (SQLiteCommand command = new SQLiteCommand(Sqlite.getSqlite().connection)) { command.CommandText = "SELECT id, name FROM `account`"; using (SQLiteDataReader sdrITM = command.ExecuteReader()) { if (sdrITM.HasRows) { while (sdrITM.Read()) { int accID = Convert.ToInt32(sdrITM["id"]); string name = Convert.ToString(sdrITM["name"]); _list.Add(new Account() { accountID = accID, name = name }); } } } } list = _list.ToArray(); isFinished = true; timer.removeAction(this); }
/// <summary> /// Returns all subscribed feeds. /// </summary> public IEnumerable<Feed> GetAllFeeds() { var feeds = new List<Feed>(); using (var connection = new SqliteConnection("Data Source=" + dbPath)) using (var query = new SqliteCommand("SELECT * FROM Feeds", connection)) { connection.Open(); var reader = query.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { var feed = new Feed(); feed.Id = int.Parse(reader["id"].ToString()); feed.Name = reader ["name"].ToString(); feed.Url = reader ["url"].ToString(); feed.LastUpdated = DateTime.Parse (reader ["LastUpdated"].ToString ()); feed.CategoryId = int.Parse(reader["categoryId"].ToString()); feeds.Add(feed); } reader.Close(); } return feeds; }
public void RoomInfo(Socket UserSocket, SQLiteConnection connection, Dictionary <Socket, Character> clientDictonary) { ASCIIEncoding encoder = new ASCIIEncoding(); string returnMessage = ""; Character character = clientDictonary[UserSocket]; command = new sqliteCommand("select * from " + "table_characters" + " where name = " + "'" + character.name + "'", connection); var characterSearch = command.ExecuteReader(); while (characterSearch.Read()) { command = new sqliteCommand("select * from " + "table_dungeon" + " where name = " + "'" + characterSearch["room"] + "'", connection); } characterSearch.Close(); var dungeonSearch = command.ExecuteReader(); while (dungeonSearch.Read()) { returnMessage += "-------------------------------"; returnMessage += "\nName: " + dungeonSearch["name"]; returnMessage += "\nDescription: " + dungeonSearch["description"]; returnMessage += "\nNorth: " + dungeonSearch["North"]; returnMessage += "\nSouth: " + dungeonSearch["South"]; returnMessage += "\nEast: " + dungeonSearch["East"]; returnMessage += "\nWest: " + dungeonSearch["West"]; returnMessage += "\nUp: " + dungeonSearch["Up"]; returnMessage += "\nDown: " + dungeonSearch["Down"]; returnMessage += "\n-------------------------------"; } connection.Close(); byte[] sendbuffer = encoder.GetBytes(returnMessage); int bytesSent = UserSocket.Send(sendbuffer); //try //{ // Console.WriteLine(""); // command = new sqliteCommand("select * from " + "table_dungeon" + " order by name asc", connection); // var reader = command.ExecuteReader(); // while (reader.Read()) // { // Console.WriteLine("Name: " + reader["name"]); // } // reader.Close(); // Console.WriteLine(""); //} //catch (Exception ex) //{ // Console.WriteLine("Failed to display DB" + ex); //} }
public static void Main(string[] args) { var db = "../../stalkr.db"; if (args.Length > 0) { db = args[0]; } // COUCHSURFING var profiles = new Dictionary<int, string>(); using (var conn = new SqliteConnection("Data Source=" + db + ";Version=3;")) { conn.Open(); var sql = "SELECT * FROM person_profile WHERE profile_type = 'couchsurfing'"; using (var cmd = new SqliteCommand(sql, conn)) { var reader = cmd.ExecuteReader(); while (reader.Read()) { int id = Convert.ToInt32(reader["person_id"]); string profile = reader["profile"] as string; profiles[id] = profile; } } foreach (var profile in profiles) { Console.WriteLine("{0}: {1}", profile.Key, profile.Value); var name = ""; var age = 0; var gender = ""; try { var url = profile.Value; //"https://www.couchsurfing.com/people/casey"; var html = new HtmlDocument(); html.LoadHtml(new WebClient().DownloadString(url)); var root = html.DocumentNode; name = root.SelectSingleNode("/html/body/main/div[2]/div/section/header/h1/a").InnerHtml; var ageAndGender = root.SelectSingleNode("/html/body/main/div[2]/section[3]/div/div/div[1]/ul/li[3]").InnerText .Split(new char[]{ ',' }, 2); age = int.Parse(ageAndGender[0].Trim()); gender = ageAndGender[1].Trim(); } catch (Exception) { } Console.WriteLine(name); Console.WriteLine(age); Console.WriteLine(gender); sql = string.Format("INSERT INTO fact_couchsurfing(person_id, timestamp, name, age, gender) VALUES ({0}, {1}, '{2}', {3}, '{4}')", profile.Key, "DATETIME('now')", name, age, gender); using (var cmd = new SqliteCommand(sql, conn)) { cmd.ExecuteNonQuery(); } Thread.Sleep(1000); } } }
protected IDataReader ExecuteReader(SqliteCommand cmd) { SqliteConnection dbcon = new SqliteConnection(m_connectionString); dbcon.Open(); cmd.Connection = dbcon; return cmd.ExecuteReader(); }
public SqliteDataReader ExecuteQuery(string q) { databaseCommand = databaseConnection.CreateCommand(); databaseCommand.CommandText = q; reader = databaseCommand.ExecuteReader(); return reader; }
private int _GetDataBaseSongID(string artist, string title, int defNumPlayed, SQLiteCommand command) { command.CommandText = "SELECT id FROM Songs WHERE [Title] = @title AND [Artist] = @artist"; command.Parameters.Add("@title", DbType.String, 0).Value = title; command.Parameters.Add("@artist", DbType.String, 0).Value = artist; SQLiteDataReader reader = command.ExecuteReader(); if (reader != null && reader.HasRows) { reader.Read(); int id = reader.GetInt32(0); reader.Dispose(); return(id); } if (reader != null) { reader.Close(); } command.CommandText = "INSERT INTO Songs (Title, Artist, NumPlayed, DateAdded) " + "VALUES (@title, @artist, @numplayed, @dateadded)"; command.Parameters.Add("@title", DbType.String, 0).Value = title; command.Parameters.Add("@artist", DbType.String, 0).Value = artist; command.Parameters.Add("@numplayed", DbType.Int32, 0).Value = defNumPlayed; command.Parameters.Add("@dateadded", DbType.Int64, 0).Value = DateTime.Now.Ticks; command.ExecuteNonQuery(); command.CommandText = "SELECT id FROM Songs WHERE [Title] = @title AND [Artist] = @artist"; command.Parameters.Add("@title", DbType.String, 0).Value = title; command.Parameters.Add("@artist", DbType.String, 0).Value = artist; reader = command.ExecuteReader(); if (reader != null) { reader.Read(); int id = reader.GetInt32(0); reader.Dispose(); return(id); } return(-1); }
//depending on what the client sent (1 or 2) add a username to databse or retreive a name from the database static bool username(string Key, Socket client) { int bytesSent; ASCIIEncoding encoder = new ASCIIEncoding(); sqliteCommand command; var input = Key.Split(' '); switch (input[0]) { case "1": for (int i = 1; i < input.Length; i++) { name += input[i]; } try { var sql = "insert into " + "table_usernames" + " (name) values "; sql += "('" + name + "'"; sql += ")"; command = new sqliteCommand(sql, conn); command.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine("Failed to add: " + name + " : to DB " + ex); } return(true); case "2": for (int i = 1; i < input.Length; i++) { name += input[i]; } try { command = new sqliteCommand("select * from table_usernames where name == '" + name + "'", conn); var reader = command.ExecuteReader(); if (reader.HasRows == true) { byte[] sendBuffer = encoder.GetBytes("signed in"); bytesSent = client.Send(sendBuffer); } } catch (Exception ex) { Console.WriteLine("Failed to find: " + name + " : to DB " + ex); } return(true); } return(false); }
public bool GetCreditsRessource(string fileName, ref CTextureRef tex) { if (_Connection == null) { return(false); } bool result = false; using (var command = new SQLiteCommand(_Connection)) { command.CommandText = "SELECT id, width, height FROM Images WHERE [Path] = @path"; command.Parameters.Add("@path", DbType.String, 0).Value = fileName; SQLiteDataReader reader = command.ExecuteReader(); if (reader != null && reader.HasRows) { reader.Read(); int id = reader.GetInt32(0); int w = reader.GetInt32(1); int h = reader.GetInt32(2); reader.Close(); command.CommandText = "SELECT Data FROM ImageData WHERE ImageID = @id"; command.Parameters.Add("@id", DbType.Int32).Value = id; reader = command.ExecuteReader(); if (reader.HasRows) { result = true; reader.Read(); byte[] data = _GetBytes(reader); tex = CDraw.AddTexture(w, h, data); } } if (reader != null) { reader.Dispose(); } } return(result); }
private bool _ConvertV2toV3(SQLiteConnection connection) { var command = new SQLiteCommand(connection) { CommandText = "ALTER TABLE Songs ADD DateAdded BIGINT" }; command.ExecuteNonQuery(); command.CommandText = "UPDATE Songs SET [DateAdded] = @DateAdded"; command.Parameters.Add("@DateAdded", DbType.Int64, 0).Value = DateTime.Now.Ticks; command.ExecuteNonQuery(); command.CommandText = "UPDATE Version SET [Value] = @version"; command.Parameters.Add("@version", DbType.Int32, 0).Value = 3; command.ExecuteNonQuery(); //Read NumPlayed from Scores and save to Songs command.CommandText = "SELECT SongID, Date FROM Scores ORDER BY Date ASC"; SQLiteDataReader reader; try { reader = command.ExecuteReader(); } catch (Exception) { return(false); } long lastDateAdded = -1; int lastID = -1; DateTime dt = new DateTime(1, 1, 1, 0, 0, 5); long sec = dt.Ticks; List <int> ids = new List <int>(); while (reader.Read()) { int id = reader.GetInt32(0); long dateAdded = reader.GetInt64(1); if (id != lastID || dateAdded > lastDateAdded + sec) { ids.Add(id); lastID = id; lastDateAdded = dateAdded; } } reader.Dispose(); foreach (int id in ids) { _IncreaseSongCounter(id, command); } command.Dispose(); return(true); }
public bool InTransaction() { using (var cmd = new SqliteCommand(String.Format("SELECT DISTINCT [TableName] FROM {0}", TranStatusTable), ActiveConnection)) { using (SqliteDataReader r = cmd.ExecuteReader()) { return r.HasRows; } } }
private void vapdata() { tk = double.Parse(temp.Text)+273.15 ; con.Open(); string str = "SELECT * FROM VAPDATA2 WHERE Name='"+comppicker.SelectedItem+"' ORDER BY Name"; using (SqliteCommand cmd2 = new SqliteCommand(str, con)) { using (SqliteDataReader rdr1 = cmd2.ExecuteReader()) { while (rdr1.Read()) { ct1 = double.Parse(rdr1["C1"].ToString()); ct2 = double.Parse(rdr1["C2"].ToString()); ct3 = double.Parse(rdr1["C3"].ToString()); ct4 = double.Parse(rdr1["C4"].ToString()); ct5 = double.Parse(rdr1["C5"].ToString()); molwt = double.Parse(rdr1["molwt"].ToString()); if (molwt != 0 ) { double vapP_derivative,latentheatdat; omega = double.Parse(rdr1["omega"].ToString()); tc = double.Parse(rdr1["Tc"].ToString()); pc = double.Parse(rdr1["Pc"].ToString()) * 1000; vpresure = (Math.Exp(ct1 + (ct2 / tk) + ct3 * Math.Log(tk) + ct4 * Math.Pow(tk, ct5))); if (tk > tc) { MessageBox.Show("Latent heat for supercritical phase is not defined"); } else { // lh.Text = vpresure.ToString(); double r = 8.314; double gasvol,liqvol; vapP_derivative = (Math.Exp(ct1 + (ct2 / tk) + ct3 * Math.Log(tk) + ct4 * Math.Pow(tk, ct5))) * (-ct2 / Math.Pow(tk, 2) + ct3 / tk + ct4 * ct5 * Math.Pow(tk, (ct5 - 1))); gasvol = eosrkvv(tc, pc, r, vpresure); liqvol = eosrklv(tc, pc, tk, r, vpresure); latentheatdat = ((tk * (gasvol - liqvol) * vapP_derivative)) / molwt; lh.Text = latentheatdat.ToString(); } } else { lh.Text = "No data avialable"; } } } } con.Close(); }
void Awake() { Debug.Log("ASd"); SqliteConnection connection = new SqliteConnection(string.Format("Data Source={0}", "Test.db")); connection.Open(); Debug.Log("Connected DB"); //Debug.Log(connection.ConnectionString); SqliteCommand sqlCmd = new SqliteCommand(connection); sqlCmd.CommandText = "SELECT * FROM Position"; SqliteDataReader reader = sqlCmd.ExecuteReader(); string[] readArray = new string[reader.RecordsAffected]; //Debug.Log(reader.RecordsAffected); //Debug.Log(reader.FieldCount); //Debug.Log(reader.HasRows); //Debug.Log(reader.VisibleFieldCount); posList = new List<Vector3>(); while (reader.Read()) { //Debug.Log("(" + reader.GetFloat(0) + ", " + reader.GetFloat(1) + ", " + reader.GetFloat(2) + ")"); posList.Add(new Vector3(reader.GetFloat(0), reader.GetFloat(1), reader.GetFloat(2))); } reader.Close(); connection.Close(); // reading database code //connection.ConnectionString = "URI=file:" + "EventDB.db"; //connection.Open(); //SqliteCommand sqlCmd2 = new SqliteCommand(connection); //sqlCmd2.CommandText = "SELECT * FROM Event"; //SqliteDataReader reader2 = sqlCmd2.ExecuteReader(); //string eventName = ""; //while (reader2.Read()) //{ // eventName = reader2.GetString(0); // Contents content = new Contents(reader2.GetString(1), reader2.GetString(2)); // //Debug.Log("Event Name : " + eventName); // //Debug.Log("Character Name : " + content.charName); // //Debug.Log("Description : " + content.description); // contentsList.Add(content); //} //eventMap.Add(eventName, contentsList); //reader2.Close(); //connection.Close(); text = this.GetComponent<GUIText>(); }
public bool queryExists(String query, String field) { sqliteCommand command = new sqliteCommand("select * from " + m_TableName + " where " + field + " = @query", m_Connection); command.Parameters.Add("@query", System.Data.DbType.String).Value = query; command.Parameters.Add("@field", System.Data.DbType.String).Value = field; sqliteDataReader reader = command.ExecuteReader(); return(reader.HasRows); }
private bool _GetDataBaseSongInfos(int songID, out string artist, out string title, out int numPlayed, out DateTime dateAdded, string filePath) { artist = String.Empty; title = String.Empty; numPlayed = 0; dateAdded = DateTime.Today; using (var connection = new SQLiteConnection()) { connection.ConnectionString = "Data Source=" + filePath; try { connection.Open(); } catch (Exception) { return(false); } using (var command = new SQLiteCommand(connection)) { command.CommandText = "SELECT Artist, Title, NumPlayed, DateAdded FROM Songs WHERE [id] = @id"; command.Parameters.Add("@id", DbType.String, 0).Value = songID; SQLiteDataReader reader; try { reader = command.ExecuteReader(); } catch (Exception) { return(false); } if (reader != null && reader.HasRows) { reader.Read(); artist = reader.GetString(0); title = reader.GetString(1); numPlayed = reader.GetInt32(2); dateAdded = new DateTime(reader.GetInt64(3)); reader.Dispose(); return(true); } if (reader != null) { reader.Dispose(); } } } return(false); }
public static bool SaveToDB(string dataSource, string completeQuery) { using (SqliteConnection con = new SqliteConnection()) { con.ConnectionString = dataSource; try { con.Open(); } catch (Exception ex) { MakeLogErrorStatic(typeof(DBReader), ex); if (con.State.ToString() == "Open") { con.Close(); con.Dispose(); } return(false); } // security check and close connection if necessary if (!DBSecurity.IsSecureSQLCommand(completeQuery)) { MakeLogWarningStatic(typeof(DBReader), "SaveToDB: Prevented forwarding of insecure sql-command: " + completeQuery); return(false); } using (SQLiteCommand cmd = new SQLiteCommand(completeQuery, con)) { cmd.CommandText = completeQuery; SQLiteDataReader rdr = null; try { cmd.ExecuteReader(); } catch (Exception ex) { throw new Exception("Could not execute SQLiteDataReader in SaveToDB: " + ex); } finally { if (rdr != null) { rdr.Close(); } } } } return(true); }
//sets players in room and where they can move to public void SetClientInRoom(Socket client, String room) { if (socketToRoomLookup.ContainsKey(client) == false) { var command = new sqliteCommand("select * from table_rooms where name == '" + room + "'", conn); var reader = command.ExecuteReader(); reader.Read(); Room currentRoom = new Room(reader["name"] as String, reader["desc"] as String); socketToRoomLookup[client] = currentRoom; } }
/// <summary> /// Allows programmer to run a query against the Database. /// </summary> /// <param name="sql">The SQL to run</param> /// <returns>A DataTable containing the result set.</returns> public DataTable GetDataTable(string sql) { DataTable dt = new DataTable(); SqliteConnection cnn = new SqliteConnection(dbConnection); cnn.Open(); SqliteCommand cmd = new SqliteCommand(cnn) { CommandText = sql }; SqliteDataReader reader = cmd.ExecuteReader(); dt.Load(reader); reader.Close(); cnn.Close(); return dt; }
public Mono.Data.Sqlite.SqliteDataReader ExecuteReader(bool bKillConnectionOnError = false) { if (_SqlConnection.State != System.Data.ConnectionState.Open || _SqlCommand.Connection == null) { throw new Exception("Connection not initialised"); } try { return(_SqlCommand.ExecuteReader()); } catch (Exception ex) { LogFault(String.Format("Query execution failed {0}.", _SqlCommand.CommandText), ex, true); if (bKillConnectionOnError) { Dispose(); } return(null); } }
public Dictionary<string, FileObject> GetFilelist() { using (SqliteCommand sqc = new SqliteCommand(connection)) { sqc.CommandText = "SELECT path, hash, size, changedate FROM Files"; using (SqliteDataReader sqr = sqc.ExecuteReader()) { Dictionary<string, FileObject> filelist = new Dictionary<string, FileObject>(); while (sqr.Read()) { filelist.Add(sqr.GetString(0), new FileObject(sqr.GetString(0), sqr.GetString(1), sqr.GetInt64(2), sqr.GetInt64(3))); } return filelist; } } }
List<MatchingTable> GetMatchingList(SqliteCommand command, string sql) { command.CommandText = sql; List<MatchingTable> matchingList = new List<MatchingTable>(); using (SqliteDataReader reader = command.ExecuteReader()) { while (reader.Read()) { matchingList.Add(CreateMatchingTable(reader)); } } return matchingList; }
public override void update(ActionTimer timer) { using (SQLiteCommand command = new SQLiteCommand(Sqlite.getSqlite().connection)) { command.CommandText = "SELECT name FROM `account` WHERE `id`=@id"; command.Parameters.AddWithValue("@id", this.accID); using (SQLiteDataReader sdrITM = command.ExecuteReader()) { if (sdrITM.HasRows) { sdrITM.Read(); this.name = Convert.ToString(sdrITM["name"]); accExists = true; } } } if (accExists) { using (SQLiteCommand command = new SQLiteCommand(Accounts.Logs.SQLiteLogger.connection)) { command.CommandText = "SELECT * FROM `logStats` WHERE `accountID`=@id"; command.Parameters.AddWithValue("@id", this.accID); using (SQLiteDataReader sdrITM = command.ExecuteReader()) { if (sdrITM.HasRows) { List <AccountLogChar> alcList = new List <AccountLogChar>(); while (sdrITM.Read()) { AccountLogChar alc = new AccountLogChar(); alc.type = Convert.ToInt32(sdrITM["type"]); alc.value = Convert.ToInt32(sdrITM["value"]); alc.time = Convert.ToInt64(sdrITM["time"]); alcList.Add(alc); } charStatList = alcList.ToArray(); } } } } isFinished = true; timer.removeAction(this); }
public static Hashtable[] Query(string qry) { Stopwatch sw = new Stopwatch(); sw.Start(); SqliteDataReader reader = null; cmd = conn.CreateCommand(); cmd.CommandText = qry; try { reader = cmd.ExecuteReader(); } catch (Exception ex) { MainClass.AddLog("Query error: '" + ex.Message + "'", true); MainClass.AddLog("Query was: '" + qry + "'", true); return null; } List<Hashtable> ret = new List<Hashtable>(); while (reader.Read()) { Hashtable row = new Hashtable(); for (int i = 0; i < reader.FieldCount; i++) { if (reader[i].GetType() == typeof(Int64)) { if ((long)reader[i] > int.MaxValue) row[reader.GetName(i)] = (long)reader[i]; else row[reader.GetName(i)] = (int)(long)reader[i]; } else row[reader.GetName(i)] = reader[i]; } ret.Add(row); } sw.Stop(); if (sw.ElapsedMilliseconds >= 1000) MainClass.AddLog("SQL Query took very long: " + sw.ElapsedMilliseconds + "ms", true); return ret.ToArray(); }
public void MakeCvsThenSend() { /*Make CVS file*/ //Filepath for the data.csv file string fileName = Application.persistentDataPath + "/" + "data.csv"; //timestamp, page, date, feeling, urge, intensity, thoughts using (StreamWriter writer = new StreamWriter(fileName, false, Encoding.UTF8)) { //Write the each columns title, for each field in pateint_info writer.Write("Timestamp | Page | Date | Feeling | Urge | Intensity | Thoughts"); writer.Write(Environment.NewLine); //Write data from the the db conn = new sqliteConnection("URI=file:" + Application.persistentDataPath + "/" + dbName + ";Version=3;FailIfMissing=True;mode=cvs"); conn.Open(); var Sqlcommand = new sqliteCommand("select * from patient_info", conn); var reader = Sqlcommand.ExecuteReader(); while (reader.Read()) { writer.Write(reader["timestamp"] + "|" + reader["page"] + "|" + reader["date"] + "|" + reader["feeling"] + "|" + reader["urge"] + "|" + reader["intensity"] + "|" + reader["thoughts"]); writer.Write(Environment.NewLine); } conn.Close(); } /*SendMail*/ MailMessage mail = new MailMessage(); mail.From = new MailAddress("*****@*****.**"); mail.To.Add(email.text); mail.Subject = "Patients Data from App"; mail.Body = "The File attached is the patients data (every entry is seperated by '|' when importing into excel or google sheets that custom seporator should be used) "; //Add the data.csv file to the email mail.Attachments.Add(new Attachment(fileName)); SmtpClient smtpServer = new SmtpClient(); smtpServer.Host = "smtp.gmail.com"; smtpServer.Port = 587; //Has to be 587 so it works on Networks with port protections. smtpServer.DeliveryMethod = SmtpDeliveryMethod.Network; smtpServer.Credentials = new System.Net.NetworkCredential("*****@*****.**", "HeartRateAppFxu2018") as ICredentialsByHost; smtpServer.EnableSsl = true; ServicePointManager.ServerCertificateValidationCallback = delegate(object s, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { return(true); }; smtpServer.Send(mail); }
public virtual bool Init() { lock (_Mutex) { if (_Connection != null) { return(false); } _Connection = new SQLiteConnection("Data Source=" + _FilePath); try { _Connection.Open(); } catch (Exception) { _Connection.Dispose(); _Connection = null; return(false); } using (var command = new SQLiteCommand(_Connection)) { command.CommandText = "SELECT Value FROM Version"; SQLiteDataReader reader = null; try { reader = command.ExecuteReader(); } catch (Exception) {} if (reader == null || !reader.Read() || reader.FieldCount == 0) { _Version = -1; } else { _Version = reader.GetInt32(0); } if (reader != null) { reader.Dispose(); } } } return(true); }
public static bool existsName(String name) { using (SQLiteCommand command = new SQLiteCommand(Sqlite.getSqlite().connection)) { command.CommandText = "SELECT name FROM `account` WHERE `name`=@name"; command.Parameters.AddWithValue("@name", name); using (SQLiteDataReader sdrITM = command.ExecuteReader()) { if (!sdrITM.HasRows) { return(false); } return(true); } } }
/* * Returns the string found at the field column for 'id' id */ public String getStringFieldFromId(int id, String field) { sqliteCommand command = new sqliteCommand("select " + field + " from " + m_TableName + " where id = @id", m_Connection); command.Parameters.Add("@id", System.Data.DbType.UInt32).Value = id; command.Parameters.Add("@field", System.Data.DbType.String).Value = field; sqliteDataReader reader = command.ExecuteReader(); while (reader.Read()) { return(reader[field].ToString()); } return(null); }
public static void ModifyPlayerWinCount(uint ID, int value) { for (int i = 0; i < players.Count; i++) { if (players [i].ID == ID) { //Confirm log in credentials through database string databasePath = ""; Platform platform = RunningPlatform(); if (platform == Platform.Windows) { databasePath = "Data Source=" + System.Environment.CurrentDirectory + "\\database.db; FailIfMissing=True"; } else if (platform == Platform.Mac) { databasePath = "Data Source=" + System.Environment.CurrentDirectory + "/data/database.db; FailIfMissing=True"; } SQLiteConnection db_connection = new SQLiteConnection(databasePath); db_connection.Open(); string query = "select * from Users where ID = @id"; SQLiteCommand command = new SQLiteCommand(query, db_connection); command.Parameters.AddWithValue("@id", players[i].ID); SQLiteDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { uint currentWinCount = Convert.ToUInt32(reader ["WINCOUNT"]); players [i] = SetPlayerWinCount(players [i], currentWinCount + 1); string sql = "update Users set WINCOUNT = @wincount where ID = @id"; command = new SQLiteCommand(sql, db_connection); command.Parameters.AddWithValue("@wincount", currentWinCount + 1); command.Parameters.AddWithValue("@id", players[i].ID); command.ExecuteNonQuery(); } } db_connection.Close(); break; } } }
/** * Given a user name this will return the salt for that username * if no user by that name exists it will return blank * @param username the user to check for. */ public String GetSalt(String username) { var command = new sqliteCommand("select * from " + playerTableName + " where name =:id", Database); command.Parameters.Add("id", DbType.String).Value = username; var reader = command.ExecuteReader(); if (reader.Read()) { return(reader["salt"].ToString()); } else { return(""); } }
//Gets the room of the player so that it can be cross referenced public String GetRoom(Socket client) { var name = socket2player[client]; var command = new sqliteCommand("select * from table_players where name == '" + name + "'", conn); var reader = command.ExecuteReader(); reader.Read(); { return(reader["room"] as string); } throw new Exception(); }
/* * Returns the string found at the field column for 'name' name */ public String getStringFieldFromName(String name, String field) { sqliteCommand command = new sqliteCommand("select " + field + " from " + m_TableName + " where name = @name", m_Connection); command.Parameters.Add("@name", System.Data.DbType.String).Value = name; command.Parameters.Add("@field", System.Data.DbType.String).Value = field; sqliteDataReader reader = command.ExecuteReader(); while (reader.Read()) { String Debug = reader[field].ToString(); return(reader[field].ToString()); } return(null); }
void Start() //When the Emergency Contacts Scene is opened Should display Contacts if they have been saved in the Database { conn = new sqliteConnection("URI=file:" + Application.persistentDataPath + "/" + dbName + ";Version=3;FailIfMissing=True"); conn.Open(); try { //Read from contact1 table and put that into text fields on the Emergency Contacts Screen var Sqlcommand = new sqliteCommand("select * from contact1", conn); var reader = Sqlcommand.ExecuteReader(); reader.Read(); if (reader.HasRows == true) { name1.text = reader["name"] as String; relationship1.text = reader["relationship"] as String; mobile1.text = reader["mobile"] as String; home1.text = reader["home"] as String; } else { Debug.Log("There are no rows in contact1"); } //Read from contact2 table and put that into text fields on the Emergency Contacts Screen Sqlcommand = new sqliteCommand("select * from contact2", conn); reader = Sqlcommand.ExecuteReader(); reader.Read(); if (reader.HasRows == true) { name2.text = reader["name"] as String; relationship2.text = reader["relationship"] as String; mobile2.text = reader["mobile"] as String; home2.text = reader["home"] as String; } else { Debug.Log("There are no rows in contact2"); } } catch (Exception ex) { Debug.Log("Failed to read from Database " + ex); } conn.Close(); }
/* * Returns true if the query exists in the field in this table for entry name in column Name */ public bool queryOtherFieldFromName(String name, String query, String field) { sqliteCommand command = new sqliteCommand("select " + field + " from " + m_TableName + " where name = @name", m_Connection); command.Parameters.Add("@name", System.Data.DbType.String).Value = name; command.Parameters.Add("@field", System.Data.DbType.String).Value = field; sqliteDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (reader[field].ToString() == query) { return(true); } } return(false); }
//prints description of room players are in public String RoomDescription(Socket client) { var command = new sqliteCommand("select * from table_rooms where name == '" + socketToRoomLookup[client].name + "'", conn); var reader = command.ExecuteReader(); String desc = ""; while (reader.Read()) { desc += reader["desc"] + "\nExits: \n"; String[] Temp = { "north", "west", "south", "east" }; for (var i = 0; i < Temp.Length; i++) { String result = reader[Temp[i]] as String; if (result != "") { desc += Temp[i] + " "; } } } var players = 0; //for each player in room players + 1 foreach (var kvp in socketToRoomLookup) { if ((kvp.Key != client) && (kvp.Value != socketToRoomLookup[client]) ) { players++; } } //if players more than 1 print if (players > 0) { desc += "\n"; desc += "There are " + players + " other dungeoneers in this room"; } desc += "\n"; return(desc); }
/// <summary> /// Method that makes a select on the database /// </summary> /// <param name="command_sql">Command to be executed</param> /// <returns>Returns a DataReader that provides the returns of consult</returns> public static SqliteDataReader Select(string command_sql) { try { if (!is_open) { OpenConnection(); } SqliteCommand command = new Mono.Data.Sqlite.SqliteCommand(command_sql, m_dbConnection); SqliteDataReader reader = command.ExecuteReader(); return(reader); } catch (Exception e) { Agenda_de_Saude.Util.CL_Files.WriteOnTheLog("Problem on the sentence. Sentence: " + command_sql + " Error: " + e.Message); return(null); } }
public static void Init(string absolutePath = "cards.cdb") { m_cards = new Dictionary <int, Card>(); using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + absolutePath)){ connection.Open(); using (SQLiteCommand command = new SQLiteCommand("SELECT datas.id, ot, alias, " + "setcode, type, level, race, attribute, atk, def ," + " name , desc FROM datas,texts WHERE datas.id=texts.id", connection)){ using (SQLiteDataReader reader = command.ExecuteReader()){ while (reader.Read()) { int id = reader.GetInt32(0); int ot = reader.GetInt32(1); int levelinfo = reader.GetInt32(5); int level = levelinfo & 0xff; int lscale = (levelinfo >> 24) & 0xff; int rscale = (levelinfo >> 16) & 0xff; Card.CardData data = new Card.CardData { Code = id, Alias = reader.GetInt32(2), Setcode = reader.GetInt64(3), Type = reader.GetInt32(4), Level = level, LScale = lscale, RScale = rscale, Race = reader.GetInt32(6), Attribute = reader.GetInt32(7), Attack = reader.GetInt32(8), Defense = reader.GetInt32(9) }; string name = reader.GetString(10); string desc = reader.GetString(11); m_cards.Add(id, new Card(data, ot, name, desc)); } reader.Close(); } } connection.Close(); } }