internal void cargarTablaMozos(EditarMozo editarMozo, int id) { try { conectar(); string sql = "select * from Mozo where id = " + id; command = new SQLiteCommand(sql, connection); SQLiteDataReader lector = command.ExecuteReader(); while (lector.Read()) { editarMozo.textBoxNombre.Text = lector.GetString(0); editarMozo.checkBoxMañana.Checked = lector.GetBoolean(2); editarMozo.checkBoxTarde.Checked = lector.GetBoolean(3); editarMozo.checkBoxNoche.Checked = lector.GetBoolean(4); } command.Connection.Close();; } catch (Exception e) { throw new Exception("Error: " + e); } finally { desconectar(); } }
public IEnumerable <MediaType> GetMediaTypes() { SQLiteConnection connection = GetConnectionForTable("azusa.mediaTypes"); SQLiteCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM azusa.mediaTypes"; SQLiteDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { MediaType mt = new MediaType(); mt.Id = dataReader.GetInt32(0); mt.ShortName = dataReader.GetString(1); mt.LongName = dataReader.GetString(2); mt.GraphData = dataReader.GetBoolean(3); mt.DateAdded = dataReader.GetDateTime(4); mt.Icon = dataReader.GetByteArray(5); mt.IgnoreForStatistics = dataReader.GetBoolean(6); if (!dataReader.IsDBNull(8)) { mt.HasFilesystem = dataReader.GetBoolean(8); } yield return(mt); } dataReader.Dispose(); cmd.Dispose(); }
/// <summary> /// Retrieve log file definition. /// </summary> /// <param name="fileKey"></param> /// <returns></returns> public static Models.LogFileDefinition GetDefinition(string fileKey) { var returnModel = new Models.LogFileDefinition(); var connectionString = "URI=file:" + Path.Combine("database/logetl.db"); using (var connection = new SQLiteConnection(connectionString)) { connection.Open(); var statement = $"SELECT * FROM definitions WHERE logfilekey = '{fileKey}'"; using (var command = new SQLiteCommand(statement, connection)) { using (SQLiteDataReader reader = command.ExecuteReader()) { while (reader.Read()) { returnModel.LogFileKey = reader.GetString(0); returnModel.SplunkOutput = reader.GetBoolean(1); returnModel.DatabaseOutput = reader.GetBoolean(2); } } } } return(returnModel); }
public Nullable <Eredmény> Eredmény(string _verseny, string _név) { lock (Program.datalock) { Nullable <Eredmény> Data = null; connection.Open( ); SQLiteCommand command = connection.CreateCommand(); command.CommandText = "SELECT INNEVE, INSOSZ, ITAZON, INCSSZ, IN10TA, IN08TA, IN05TA, INMETA, INOSZP, INERSZ, INMEGJ, INKOMO, KOAZON FROM Eredmények_" + _verseny + " WHERE INNEVE = '" + _név + "';"; SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read( )) { Data = new Eredmény(reader.GetString(0), reader.GetInt64(1), reader.GetString(2), reader.GetInt32(3), reader.GetInt32(4), reader.GetInt32(5), reader.GetInt32(6), reader.GetInt32(7), reader.GetInt32(8), reader.GetInt32(9), reader.GetBoolean(10), reader.GetBoolean(11), reader.GetString(12)); } command.Dispose( ); connection.Close( ); return(Data); } }
public override bool GetAllRecords(out List <ViewData> list) { list = new List <ViewData>(); lock (syncObject) { if (!Open("GetAllRecords")) { Logger.Log("GetAllRecords: Open() failed"); return(false); } SQLiteCommand sqlCommand = new SQLiteCommand("SELECT * FROM Positions", connection); string results = string.Empty; try { SQLiteDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { ViewData record = new ViewData { id = reader.GetInt64((int)ColumnIndices.ID), symbol = reader.GetString((int)ColumnIndices.Symbol), buyDate = reader.GetDateTime((int)ColumnIndices.BuyDate), buyPrice = reader.GetDecimal((int)ColumnIndices.BuyPrice), sharesBought = reader.GetDouble((int)ColumnIndices.SharesBought), numShares = reader.GetDouble((int)ColumnIndices.NumShares), highestClose = reader.GetDecimal((int)ColumnIndices.HighestClose), lastClose = reader.GetDecimal((int)ColumnIndices.LastClose), fixedStop = reader.GetDecimal((int)ColumnIndices.FixedStopPrice), stopPercent = reader.GetInt32((int)ColumnIndices.StopPercent), useTrailing = reader.GetBoolean((int)ColumnIndices.UseTrailing), useDividends = reader.GetBoolean((int)ColumnIndices.UseDividends), dividends = reader.GetDecimal((int)ColumnIndices.Dividends), useOptions = reader.GetBoolean((int)ColumnIndices.UseOptions), options = reader.GetDecimal((int)ColumnIndices.OptionsSold), lastUpdate = reader.GetDateTime((int)ColumnIndices.LastUpdate) }; list.Add(record); } reader.Close(); } catch (SQLiteException e) { MessageBox.Show("GetAllRecords - " + e.Message); return(false); } catch (Exception ex) { MessageBox.Show("GetAllRecords - " + ex.Message); return(false); } finally { connection.Close(); } } // lock list.Sort(CompareBySymbol); return(true); }
public Item GetItem(Int32 id) { SQLiteCommand cmd = new SQLiteCommand(Program.m_dbConnection); cmd.CommandText = "SELECT A.ID AS ID, " + "A.TIPOITEM AS TIPO, " + "A.TITULO AS TITULO, " + "A.AUTOR AS AUTOR, " + "A.ALBUM AS ALBUM, " + "A.DURACION AS DURACION, " + "A.GENERO AS GENERO, " + "A.IDIOMA AS IDIOMA, " + "A.LOCALIZACION AS LOCALIZACION, " + "A.TIENELETRA AS TIENELETRA, " + "A.PERDIDO AS PERDIDO " + "FROM " + this.tableName + " A WHERE ID ='" + id.ToString() + "'"; SQLiteDataReader row = cmd.ExecuteReader(); row.Read(); Item item = new Item(); item.Id = row.GetInt32(0); // Convert.ToInt32(row.Item["id"]); item.tipo = row.GetString(1); // Convert.ToString(row["tipo"]); item.Titulo = row.GetString(2); // Convert.ToString(row["Titulo"]); item.Autor = row.GetString(3); // Convert.ToString(row["Autor"]); item.Album = row.GetString(4); // Convert.ToString(row["Album"]); item.Duracion = row.GetString(5); // Convert.ToString(row["Duracion"]); item.genero = row.GetString(6); // Convert.ToString(row["genero"]); item.idioma = row.GetString(7); // Convert.ToString(row["idioma"]); item.Localizacion = row.GetString(8); // Convert.ToString(row["Localizacion"]); item.tieneletra = row.GetBoolean(9); item.perdido = row.GetBoolean(10); return(item); }
public List <Eredmény> Eredmények(string _azonosító) { lock (Program.datalock) { List <Eredmény> data = new List <Eredmény>( ); connection.Open( ); SQLiteCommand command = connection.CreateCommand( ); command.CommandText = "SELECT INNEVE, INSOSZ, ITAZON, INCSSZ, IN10TA, IN08TA, IN05TA, INMETA, INOSZP, INERSZ, INMEGJ, INKOMO, KOAZON FROM Eredmények_" + _azonosító + ";"; SQLiteDataReader reader = command.ExecuteReader( ); while (reader.Read( )) { data.Add(new Eredmény(reader.GetString(0), reader.GetInt64(1), reader.GetString(2), reader.GetInt32(3), reader.GetInt32(4), reader.GetInt32(5), reader.GetInt32(6), reader.GetInt32(7), reader.GetInt32(8), reader.GetInt32(9), reader.GetBoolean(10), reader.GetBoolean(11), reader.GetString(12))); } command.Dispose( ); connection.Close( ); return(data); } }
public void updateLists() { bills.Clear(); SQLiteConnection dbConnection = new SQLiteConnection("Data Source=database.sqlite;Version=3;"); dbConnection.Open(); SQLiteCommand cmd = dbConnection.CreateCommand(); cmd.CommandText = "SELECT * FROM bills WHERE (PAID_BY='" + User.Email + "' OR PAID_TO='" + User.Email + "') AND SETTLED=0;"; SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { long id = reader.GetInt64(0); string paid_by = reader.GetString(1); string paid_to = reader.GetString(2); string desc = reader.GetString(3); float amount = reader.GetFloat(4); bool accepted = reader.GetBoolean(5); bool settled = reader.GetBoolean(6); bills.Add(new Bill(id, paid_by, paid_to, desc, amount, accepted, settled)); } reader.Close(); dbConnection.Close(); }
/// <summary> /// Retrieves all components (in the inventory) in the database /// </summary> /// <returns>List of all components in the database</returns> private List <Component> getAllComponents() { List <Component> components = new List <Component>(); //using (var tx = conn.BeginTransaction()) //{ using (SQLiteDataReader reader = getAllComponentsCommand.ExecuteReader()) { //tx.Commit(); if (reader.HasRows) { while (reader.Read()) { reader.Read(); // TODO: Link up the notes and crashHistory stuff components.Add(new Component(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetDouble(5), reader.GetString(6), reader.GetString(7), reader.GetBoolean(8), reader.GetBoolean(9), reader.GetString(10))); } } } //} return(components); }
public List <KGLanguage> Get(string wherecase = "", string ordercase = "") { List <KGLanguage> results = new List <KGLanguage>(); SQLiteConnection conn = DbConnection.Conn; SQLiteCommand cmd = new SQLiteCommand("select * from kg_language", conn); try { conn.Open(); SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { KGLanguage item = new KGLanguage(); item.Name = reader.IsDBNull(0) ? "" : reader.GetString(0); item.Description = reader.IsDBNull(1) ? "" : reader.GetString(1); item.IsCompileLanguage = reader.IsDBNull(2) ? false : reader.GetBoolean(2); item.IsExplainLanguage = reader.IsDBNull(3) ? false : reader.GetBoolean(3); item.IsProcessLanguage = reader.IsDBNull(4) ? false : reader.GetBoolean(4); item.IsObjectiveLanguage = reader.IsDBNull(5) ? false : reader.GetBoolean(5); item.IsScriptLanguage = reader.IsDBNull(6) ? false : reader.GetBoolean(6); } } catch (Exception ex) { } finally { conn.Close(); } return(results); }
/// <summary> /// Gets all components for a specific system /// </summary> /// <param name="systemName">The specified system to retieve components for</param> /// <returns>List of all components for the systemName</returns> private List <Component> GetAllComponentsForSystem(string systemName) { List <Component> components = new List <Component>(); ///using (var tx = conn.BeginTransaction()) ///{ getAllComponentsForSystemCommand.Parameters["@System"].Value = systemName; using (SQLiteDataReader reader = getAllComponentsForSystemCommand.ExecuteReader()) { ///tx.Commit(); if (reader.HasRows) { while (reader.Read()) { // TODO: Link up the notes and crashHistory stuff Component temp = new Component(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetDouble(5), reader.GetString(6), reader.GetString(7), reader.GetBoolean(8), reader.GetBoolean(9), reader.GetString(10)); components.Add(temp); Console.WriteLine(temp.name); } } } ///} return(components); }
/// <summary> /// Get Competition by Competition name. /// </summary> /// <param name="competitionName"></param> /// <returns></returns> public static CompetitionModel GetCompetitionByName(string competitionName) { CompetitionModel rValue = null; _conn = new SQLiteConnection(CONNECTION_STRING); _conn.Open(); using (SQLiteCommand command = _conn.CreateCommand()) { command.CommandText = "SELECT CompetitionID, CompetitionName, CompetitionImage, FixedTeams, RandomiseTeams, LogicallyDeleted" + " FROM Competitions" + " WHERE CompetitionName = @competitionName"; command.Parameters.AddWithValue("@competitionName", competitionName); SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read()) { rValue = new CompetitionModel(); rValue.CompetitionID = reader.GetInt64(0); rValue.CompetitionName = reader.GetString(1); rValue.CompetitionImage = reader.GetString(2); rValue.TeamsAreFixed = reader.GetBoolean(3); rValue.TeamsAreRandomised = reader.GetBoolean(4); rValue.LogicallyDeleted = reader.GetBoolean(5); } } _conn.Dispose(); return(rValue); }
public void OfflineLoadData() { con = new SQLiteConnection("Data Source=hospitalDb.db);Version=3"); string cstring = "select * from OPDTable where Id=@id"; cmd = new SQLiteCommand(cstring, con); con.Open(); cmd.Parameters.AddWithValue("@id", SelectedId); SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { IsTbCheckBox.Checked = reader.GetBoolean(1); DiagnosticInvestigationTextBox.Text = reader.GetString(2); ProvisionalDiagnosisTextBox.Text = reader.GetString(3); ICDCodeTextBox.Text = reader.GetString(4); TreatmentTextBox.Text = reader.GetString(5); SurgicalProcedureTextBox.Text = reader.GetString(6); IsFirstTimeCheckBox.Checked = reader.GetBoolean(9); IsGenderViolenceCheckBox.Checked = reader.GetBoolean(7); FreeServiceCodeComboBox.SelectedItem = reader.GetString(8); PanTextBox.Text = reader.GetString(13); ClaimCodemetroTextBox.Text = reader.GetString(12); NshimetroTextBox.Text = reader.GetString(11); ReferredToTextBox.Text = reader.GetString(10); } con.Close(); }
public List <Korosztály> Korosztályok(string _verseny) { lock (Program.datalock) { List <Korosztály> data = new List <Korosztály>(); connection.Open( ); SQLiteCommand command = connection.CreateCommand(); command.CommandText = "SELECT VEAZON, KOAZON, KOMEGN, KOEKMI, KOEKMA, KONOK, KOFERF, KOINSN, KOINSF, KOEGYB FROM Korosztályok WHERE VEAZON = '" + _verseny + "' ORDER BY KOEKMI;"; SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read( )) { data.Add(new Korosztály(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetInt32(3), reader.GetInt32(4), reader.GetBoolean(5), reader.GetBoolean(6), reader.GetInt32(7), reader.GetInt32(8), reader.GetBoolean(9))); } command.Dispose( ); connection.Close( ); return(data); } }
public void Load(BCRUser user) { using (SQLiteDataReader reader = Database.Instance.ExecuteReader(@"SELECT open_current_comic_at_launch, open_next_comic, page_fit_mode, zoom_on_tap, toggle_paging_bar, use_page_turn_drag, page_turn_drag_threshold, use_page_change_area, page_change_area_width, use_comicrack_progress FROM user_settings WHERE user_id = " + user.UserId + " LIMIT 1;")) { if (reader.Read()) { try { open_current_comic_at_launch = reader.GetBoolean(0); open_next_comic = reader.GetBoolean(1); page_fit_mode = reader.GetInt32(2); zoom_on_tap = reader.GetInt32(3); toggle_paging_bar = reader.GetInt32(4); use_page_turn_drag = reader.GetBoolean(5); page_turn_drag_threshold = reader.GetInt32(6); use_page_change_area = reader.GetBoolean(7); page_change_area_width = reader.GetInt32(8); use_comicrack_progress = reader.GetBoolean(9); full_name = user.FullName; } catch (Exception ex) { Trace.WriteLine(ex); } } } }
public static void Read(this Beatmap beatmap, SQLiteDataReader reader) { int i = 1; beatmap.TitleRoman = reader.GetString(i); i++; beatmap.ArtistRoman = reader.GetString(i); i++; beatmap.TitleUnicode = reader.GetString(i); i++; beatmap.ArtistUnicode = reader.GetString(i); i++; beatmap.Creator = reader.GetString(i); i++; beatmap.DiffName = reader.GetString(i); i++; beatmap.Mp3Name = reader.GetString(i); i++; beatmap.Md5 = reader.GetString(i); i++; beatmap.OsuFileName = reader.GetString(i); i++; beatmap.MaxBpm = reader.GetDouble(i); i++; beatmap.MinBpm = reader.GetDouble(i); i++; beatmap.Tags = reader.GetString(i); i++; beatmap.State = reader.GetByte(i); i++; beatmap.Circles = (short)reader.GetInt32(i); i++; beatmap.Sliders = (short)reader.GetInt32(i); i++; beatmap.Spinners = (short)reader.GetInt32(i); i++; beatmap.EditDate = reader.GetDateTime(i).ToUniversalTime(); i++; beatmap.ApproachRate = (float)reader.GetDouble(i); i++; beatmap.CircleSize = (float)reader.GetDouble(i); i++; beatmap.HpDrainRate = (float)reader.GetDouble(i); i++; beatmap.OverallDifficulty = (float)reader.GetDouble(i); i++; beatmap.SliderVelocity = reader.GetDouble(i); i++; beatmap.DrainingTime = reader.GetInt32(i); i++; beatmap.TotalTime = reader.GetInt32(i); i++; beatmap.PreviewTime = reader.GetInt32(i); i++; beatmap.MapId = reader.GetInt32(i); i++; beatmap.MapSetId = reader.GetInt32(i); i++; beatmap.ThreadId = reader.GetInt32(i); i++; /*beatmap.MapRating =*/ reader.GetInt32(i); i++; beatmap.Offset = (short)reader.GetInt32(i); i++; var stackLeniency = reader.SafeGetDouble(i); i++; beatmap.StackLeniency = double.IsNaN(stackLeniency) ? 0 : (float)stackLeniency;//TODO: (CollectionManager) StackLeniency has to be nullable beatmap.PlayMode = (PlayMode)reader.GetByte(i); i++; beatmap.Source = reader.GetString(i); i++; beatmap.AudioOffset = (short)reader.GetInt32(i); i++; beatmap.LetterBox = reader.GetString(i); i++; beatmap.Played = reader.GetBoolean(i); i++; beatmap.LastPlayed = reader.GetDateTime(i).ToUniversalTime(); i++; beatmap.IsOsz2 = reader.GetBoolean(i); i++; beatmap.Dir = reader.GetString(i); i++; beatmap.LastSync = reader.GetDateTime(i).ToUniversalTime(); i++; beatmap.DisableHitsounds = reader.GetBoolean(i); i++; beatmap.DisableSkin = reader.GetBoolean(i); i++; beatmap.DisableSb = reader.GetBoolean(i); i++; beatmap.BgDim = reader.GetInt16(i); i++; beatmap.Somestuff = reader.GetInt16(i); i++; beatmap.DeSerializeStars((byte[])reader.GetValue(i)); i++; i++; // beatmapChecksum beatmap.MainBpm = reader.GetDouble(i); }
public void selectAll() { if (allUnitFeatuers == null || allUnitFeatuers.Count == 0) { ruleManager.selectAll(); string query = "SELECT * FROM " + UNIT_TABLE_NAME + ""; SQLiteDataReader mReader = sqlManager.executeReader(query); List <UnitFeatures> unitList = new List <UnitFeatures>(); int Counter = 0; if (mReader.Read()) { do { Counter++; int id = mReader.GetInt32(0); string name = mReader.GetString(1); int powerSpawn = mReader.GetInt32(2); int powerMove = mReader.GetInt32(3); int powerAttack = mReader.GetInt32(4); float powerRegen = mReader.GetFloat(5); int airDamage = mReader.GetInt32(6); int groundDamage = mReader.GetInt32(7); float armorPricsingDamagePoint = mReader.GetFloat(8); float splashDamagePoint = mReader.GetFloat(9); int health = mReader.GetInt32(10); bool isArmored = mReader.GetBoolean(11); bool isGrounded = mReader.GetBoolean(12); int width = (int)mReader.GetFloat(15); int height = (int)mReader.GetFloat(16); int vision = mReader.GetInt32(17); int requiredLevel = mReader.GetInt32(18); int coinCost = mReader.GetInt32(19); int lastModified = mReader.GetInt32(21); int moveSpeed = mReader.GetInt32(22); string description = mReader.GetString(23); bool isVehicle = mReader.GetBoolean(24); int shotPerTurn = mReader.GetInt32(25); bool isInDeck; bool isLocked; int currentLevel; isInDeck = false; //mReader.GetBoolean(14); isLocked = false; //mReader.GetBoolean(13); currentLevel = 1; //mReader.GetInt32(20); UnitFeatures unit = new UnitFeatures(id, name, powerSpawn, powerMove, powerAttack, powerRegen, airDamage, groundDamage, armorPricsingDamagePoint, splashDamagePoint, health, isArmored, isGrounded, isLocked, isInDeck, width, height, vision, requiredLevel, coinCost, currentLevel, lastModified, moveSpeed, description, isVehicle, shotPerTurn);//,numberOfStateImages,numberOfDirections); List <UpgradeRule> upgradeRule = ruleManager.selectUnitUpgradeRule(id); unit.rules = upgradeRule; unitList.Add(unit); } while (mReader.Read()); } allUnitFeatuers = unitList; } }
OutgoingFlow GetOutgoingMessage(SQLiteDataReader reader) { return(new OutgoingFlow() { PacketId = (ushort)reader.GetInt32(0), Retain = reader.GetBoolean(1), Topic = reader.GetString(2), Qos = GetQosLevel(reader.GetByte(3)), Payload = this.GetBlob(reader, 4), Received = reader.GetBoolean(5) }); }
public TrainRemoteControl.Model.Display GetFirstRecord() { SQLiteDataReader dr = null; TrainRemoteControl.Model.Display display = new TrainRemoteControl.Model.Display(); try { SQLiteDBHelper sdb = new SQLiteDBHelper(Program.g_dbPath); dr = sdb.ExecuteReader(GetFirstRecordSqlStr, null); string temp = null; while (dr.Read()) { display.Number = dr.GetInt32(2); display.oil_mass = float.Parse(dr.GetString(3)); display.fire_alarm = dr.GetBoolean(4); display.up_oil_place = dr.GetBoolean(5); display.up_water_place = dr.GetBoolean(6); display.battery_voltage = dr.GetBoolean(7); display.alarm = dr.GetBoolean(8); display.alarm_voice = dr.GetBoolean(9); temp = dr.GetString(10).Trim(); display.oil_press = !string.IsNullOrEmpty(temp)? float.Parse(temp):0; temp = dr.GetString(11).Trim(); display.water_temp = !string.IsNullOrEmpty(temp) ? float.Parse(temp) : 0; temp = dr.GetString(12).Trim(); display.frequency = !string.IsNullOrEmpty(temp) ? float.Parse(temp) : 0; temp = dr.GetString(13).Trim(); display.motor_speed = !string.IsNullOrEmpty(temp) ? float.Parse(temp) : 0; temp = dr.GetString(14).Trim(); display.voltage = !string.IsNullOrEmpty(temp) ? float.Parse(temp) : 0; temp = dr.GetString(15).Trim(); display.current = !string.IsNullOrEmpty(temp) ? float.Parse(temp) : 0; temp = dr.GetString(16).Trim(); display.motor_power = !string.IsNullOrEmpty(temp) ? float.Parse(temp) : 0; temp = dr.GetString(17).Trim(); display.power_factor = !string.IsNullOrEmpty(temp) ? float.Parse(temp) : 0; display.oil_leak = dr.GetBoolean(18); display.OKAlarm = dr.GetBoolean(19); display.NOAlarm = dr.GetBoolean(20); display.NCAlarm = dr.GetBoolean(21); display.time = dr.GetDateTime(22); } return(display); } finally { if (dr != null) { dr.Close(); } } }
public static void Read(this Beatmap beatmap, SQLiteDataReader reader) { int i = 1; beatmap.TitleRoman = reader.GetString(i); i++; beatmap.ArtistRoman = reader.GetString(i); i++; beatmap.TitleUnicode = reader.GetString(i); i++; beatmap.ArtistUnicode = reader.GetString(i); i++; beatmap.Creator = reader.GetString(i); i++; beatmap.DiffName = reader.GetString(i); i++; beatmap.Mp3Name = reader.GetString(i); i++; beatmap.Md5 = reader.GetString(i); i++; beatmap.OsuFileName = reader.GetString(i); i++; beatmap.MaxBpm = reader.GetDouble(i); i++; beatmap.MinBpm = reader.GetDouble(i); i++; beatmap.Tags = reader.GetString(i); i++; beatmap.State = reader.GetByte(i); i++; beatmap.Circles = (short)reader.GetInt32(i); i++; beatmap.Sliders = (short)reader.GetInt32(i); i++; beatmap.Spinners = (short)reader.GetInt32(i); i++; beatmap.EditDate = reader.GetDateTime(i); i++; beatmap.ApproachRate = (float)reader.GetDouble(i); i++; beatmap.CircleSize = (float)reader.GetDouble(i); i++; beatmap.HpDrainRate = (float)reader.GetDouble(i); i++; beatmap.OverallDifficulty = (float)reader.GetDouble(i); i++; beatmap.SliderVelocity = reader.GetDouble(i); i++; beatmap.DrainingTime = reader.GetInt32(i); i++; beatmap.TotalTime = reader.GetInt32(i); i++; beatmap.PreviewTime = reader.GetInt32(i); i++; beatmap.MapId = reader.GetInt32(i); i++; beatmap.MapSetId = reader.GetInt32(i); i++; beatmap.ThreadId = reader.GetInt32(i); i++; beatmap.MapRating = reader.GetInt32(i); i++; beatmap.Offset = (short)reader.GetInt32(i); i++; beatmap.StackLeniency = (float)reader.GetDouble(i); i++; beatmap.Mode = reader.GetByte(i); i++; beatmap.Source = reader.GetString(i); i++; beatmap.AudioOffset = (short)reader.GetInt32(i); i++; beatmap.LetterBox = reader.GetString(i); i++; beatmap.Played = reader.GetBoolean(i); i++; beatmap.LastPlayed = reader.GetDateTime(i); i++; beatmap.IsOsz2 = reader.GetBoolean(i); i++; beatmap.Dir = reader.GetString(i); i++; beatmap.LastSync = reader.GetDateTime(i); i++; beatmap.DisableHitsounds = reader.GetBoolean(i); i++; beatmap.DisableSkin = reader.GetBoolean(i); i++; beatmap.DisableSb = reader.GetBoolean(i); i++; beatmap.BgDim = reader.GetInt16(i); i++; beatmap.Somestuff = reader.GetInt16(i); i++; beatmap.VideoDir = reader.GetString(i); }
// Get Plug by PlugID public static PlugDevice GetPlugDeviceByPlugID(Int64 plugid, string dbPath) { try { using (SQLiteConnection conn = new SQLiteConnection("Data Source=" + dbPath + ";")) { conn.Open(); SQLiteCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from PlugList where PlugID=@PlugID;"; cmd.Parameters.Add(new SQLiteParameter("PlugID", plugid)); SQLiteDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { PlugDevice plugdev = new PlugDevice(); plugdev.PlugID = dr.GetInt64(0); plugdev.PlugName = dr.GetString(1); plugdev.PlugMac = dr.GetString(2); plugdev.UserCode = (UInt16)dr.GetInt32(3); plugdev.Voltage = dr.GetFloat(4); plugdev.Power = dr.GetFloat(5); plugdev.DayBudget = dr.GetFloat(6); plugdev.NightBudget = dr.GetFloat(7); plugdev.MorningBudget = dr.GetFloat(8); plugdev.AfternoonBudget = dr.GetFloat(9); plugdev.EveningBudget = dr.GetFloat(10); plugdev.NightSaving = dr.GetBoolean(11); plugdev.MorningSaving = dr.GetBoolean(12); plugdev.AfternoonSaving = dr.GetBoolean(13); plugdev.EveningSaving = dr.GetBoolean(14); plugdev.Description = dr.GetString(15); plugdev.CreateDateTime = dr.GetDateTime(16); return(plugdev); } else { return(null); } } } catch (ArgumentException ae) { MessageBox.Show(ae.Message + " \n\n" + ae.Source + "\n\n" + ae.StackTrace); return(null); } catch (Exception ex) { //Do any logging operation here if necessary throw new Exception(ex.Message); } }
public static List <Giveaway> GetGiveaways() { try { using (SQLiteConnection _conn = new SQLiteConnection(connectionString)) { using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Giveaways", _conn)) { cmd.Connection.Open(); SQLiteDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { List <Giveaway> giveaways = new List <Giveaway>(); while (dr.Read()) { Giveaway giveaway = new Giveaway(); giveaway.Id = dr.GetInt32(0); giveaway.Name = dr.GetString(1); giveaway.Reward = dr.GetInt32(2); giveaway.RewardString = dr.GetString(3); giveaway.Type = dr.GetInt32(4); giveaway.Hashtag = dr.GetString(5); giveaway.Repeat = dr.GetInt32(6); giveaway.Delay = dr.GetInt32(7); giveaway.StartMessage = dr.GetString(8); giveaway.WinnerMessage = dr.GetString(9); giveaway.WinnerWhisper = dr.GetString(10); giveaway.CodeWhisper = dr.GetString(11); giveaway.AnnounceStart = dr.GetBoolean(12); giveaway.AutoPickCode = dr.GetBoolean(13); giveaways.Add(giveaway); } dr.Close(); _conn.Close(); return(giveaways); } else { dr.Close(); _conn.Close(); return(new List <Giveaway>()); } } } } catch (Exception e) { MessageBox.Show("Error retrieving giveaways: \n\n" + e.Message); return(null); } }
/// <summary> /// Get all Competitions from the database. /// </summary> /// <param name="excludeDeleted"></param> /// <returns></returns> public static List <CompetitionModel> GetAllCompetitions(bool excludeDeleted = false) { List <CompetitionModel> rValue = new List <CompetitionModel>(); _conn = new SQLiteConnection(CONNECTION_STRING); _conn.Open(); try { using (SQLiteCommand command = _conn.CreateCommand()) { string baseSQL = "SELECT CompetitionID, CompetitionName, CompetitionImage, FixedTeams, RandomiseTeams, LogicallyDeleted" + " FROM Competitions"; if (excludeDeleted) { baseSQL += " WHERE LogicallyDeleted = @logicallyDeleted"; command.CommandText = baseSQL; command.Parameters.AddWithValue("@logicallyDeleted", true); } else { command.CommandText = baseSQL; } SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read()) { CompetitionModel c = new CompetitionModel(); c.CompetitionID = reader.GetInt64(0); c.CompetitionName = reader.GetString(1); c.CompetitionImage = reader.GetString(2); c.TeamsAreFixed = reader.GetBoolean(3); c.TeamsAreRandomised = reader.GetBoolean(4); c.LogicallyDeleted = reader.GetBoolean(5); rValue.Add(c); } } _conn.Dispose(); } catch (SQLiteException e) { _conn.Dispose(); } return(rValue); }
/// <summary> /// checks, if the chosen race has an extra choice attached to it /// </summary> /// <param name="subraceChoice">the race to be checked</param> public bool subraceHasProficiencyChoice(string subraceChoice) { bool hasChoice = false; using (SQLiteConnection connection = new SQLiteConnection(ConnectionString)) using (SQLiteCommand command = new SQLiteCommand(connection)) { connection.Open(); command.CommandText = "SELECT extraToolProficiencies FROM races " + "WHERE subrace=@SubraceChoice"; command.Parameters.AddWithValue("@SubraceChoice", subraceChoice); using (SQLiteDataReader dbReader = command.ExecuteReader()) { while (dbReader.Read()) { if (!dbReader.IsDBNull(0)) { hasChoice = dbReader.GetBoolean(0); } } } } return(hasChoice); }
public void LoadTableInfo() { SQLiteConnection Conn = new SQLiteConnection(connectstring); SQLiteCommand Com = Conn.CreateCommand(); Com.CommandText = "PRAGMA table_info(" + tableName + ")"; Conn.Open(); SQLiteDataReader rs = Com.ExecuteReader(); while (rs.Read()) { SQLiteTableColumn tablecolumn = new SQLiteTableColumn(); tablecolumn.m_parent = this; tablecolumn.ColumnName = rs.GetString(rs.GetOrdinal("name")); tablecolumn.ColumnType = rs.GetString(rs.GetOrdinal("type")); //tablecolumn.DefaultValue = rs.GetString(rs.GetOrdinal("dflt_value")); tablecolumn.pk = rs.GetBoolean(rs.GetOrdinal("pk")); if (tablecolumn.pk == true) { HasPrimaryKey = true; } listSQLiteTableColumn.Add(tablecolumn); } rs.Close(); Conn.Close(); rs.Dispose(); Com.Dispose(); Conn.Dispose(); }
/// <summary> /// Retrieve all market orders created by <code>seller</code> /// </summary> public static List <MarketEntry> EntriesBySeller(Mobile seller) { List <MarketEntry> list = new List <MarketEntry>(); SQLiteDataReader reader = ExecuteQuery("SELECT entryid,active,category,cost,description,itemserial FROM entries WHERE sellerserial = " + (int)seller.Serial); while (reader.Read()) { IEntity saleObject = World.FindEntity(reader.GetInt32(reader.GetOrdinal("itemserial"))); MarketEntry entry = new MarketEntry(seller); entry.Active = reader.GetBoolean(reader.GetOrdinal("active")); entry.Category = (Category)reader.GetInt32(reader.GetOrdinal("category")); entry.Description = reader.GetString(reader.GetOrdinal("description")); entry.TableId = reader.GetInt32(reader.GetOrdinal("entryid")); if (saleObject != null) { entry.SetSellItem(saleObject); } entry.ChangeCost(reader.GetInt32(reader.GetOrdinal("cost")), 0, 0); list.Add(entry); } reader.Close(); return(list); }
public static List <Task> GetAllTasks() { DAL.ConnectDb(); List <Task> data = new List <Task> (); string query = "SELECT * FROM " + TableName; SQLiteCommand command = new SQLiteCommand(query, DAL.Conn); SQLiteDataReader reader = command.ExecuteReader(); while (reader.HasRows) { while (reader.Read()) { Task t = new Task(); t.Id = reader.GetInt32(0); t.Owner = UserDAL.GetUserById(reader.GetInt32(1)); t.Title = reader.GetString(2); t.Description = reader.GetString(3); t.Status = (TaskStatus)reader.GetInt32(4); t.StartDate = DateTime.Parse(reader.GetString(5)); t.EndDate = DateTime.Parse(reader.GetString(6)); t.IsPrivate = reader.GetBoolean(7); t.Partners = PartnerDAL.GetAllPartners(t); data.Add(t); } reader.NextResult(); } return(data); }
private byte[] GetHTTPCacheContent(Uri uri, ref bool requestSuccess) { using (SQLiteCommand command = new SQLiteCommand("select success, data from httpcache where uri=@uri", this.FetchDbConn())) { command.Parameters.Add(new SQLiteParameter("@uri", uri.ToString())); using (SQLiteDataReader reader = command.ExecuteReader()) { if (reader.Read()) { requestSuccess = reader.GetBoolean(reader.GetOrdinal("success")); // Get the length of the content by passing nothing to getbytes int contentLength = Convert.ToInt32(reader.GetBytes(reader.GetOrdinal("data"), 0, null, 0, 0)); byte[] content = new byte[contentLength]; reader.GetBytes(reader.GetOrdinal("data"), 0, content, 0, contentLength); return(content); } else { return(null); } } } }
/// <summary> /// gets a list of the additional cantrips the given subclass may choose from /// </summary> /// <param name="subclass">chosen subclass</param> public List <Spell> getExtraSubclassCantripOptions(string subclass) { List <Spell> cantripList = new List <Spell>(); using (SQLiteConnection connection = new SQLiteConnection(ConnectionString)) using (SQLiteCommand command = new SQLiteCommand(connection)) { connection.Open(); command.CommandText = "SELECT spells.name, spells.ritual, spells.level, spells.school, spells.castTime, spells.range, " + "spells.duration, spells.components, spells.materials, spells.description FROM spells " + "INNER JOIN books ON spells.book = books.bookid " + "WHERE spells.level = 0 " + "AND spells.classes LIKE \"%\" || " + "(SELECT classes.name FROM extraSubclassCantrips " + "INNER JOIN subclasses ON subclasses.subclassId = extraSubclassCantrips.subclassId " + "INNER JOIN classes ON classes.classid = extraSubclassCantrips.classId " + "WHERE subclasses.name = @Subclass) || \"%\" " + "AND books.title IN(@UsedBooks)"; command.Parameters.AddWithValue("@Subclass", subclass); SQLiteCommandExtensions.AddParametersWithValues(command, "@UsedBooks", UsedBooks); using (SQLiteDataReader dbReader = command.ExecuteReader()) { while (dbReader.Read()) { if (!dbReader.IsDBNull(0)) { cantripList.Add(new Spell(dbReader.GetString(0), dbReader.GetBoolean(1), dbReader.GetInt32(2), dbReader.GetString(3), dbReader.GetString(4), dbReader.GetString(5), dbReader.GetString(6), dbReader.GetString(7), dbReader.GetString(8), dbReader.GetString(9), false)); } } } } return(cantripList); }
public IEnumerable <HangmanGameRecord> GetAll() { List <HangmanGameRecord> records = new List <HangmanGameRecord>(); using (SQLiteConnection connection = new SQLiteConnection(_ConnectionString)) { try { connection.Open(); string q = "SELECT * FROM HangmanGameHistory"; using (SQLiteCommand cmd = new SQLiteCommand(q, connection)) { using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var word = reader.GetString(0); bool won = reader.GetBoolean(1); records.Add(new HangmanGameRecord(word, won)); } } } } catch (Exception) { throw; } } return(records); }