public Pessoa Read(string id) { Pessoa p = null; SQLiteConnection conexao = Database.GetInstance().GetConnection(); string qry = string.Format("SELECT id, cpf, nome, sexo, rua, bairro, numero, cep, cidade, uf FROM pessoa WHERE id ='{0}'", id); if (conexao.State != System.Data.ConnectionState.Open) { conexao.Open(); } SQLiteCommand comm = new SQLiteCommand(qry, conexao); SQLiteDataReader dr = comm.ExecuteReader(); if (dr.Read()) { p = new Pessoa("", "", "", "", "", "", "", "", "", ""); p.Id = dr.GetInt16(0); p.Cpf = dr.GetString(1); p.Nome = dr.GetString(2); p.Sexo = dr.GetString(3); p.Rua = dr.GetString(4); p.Bairro = dr.GetString(5); p.Numero = dr.GetInt16(6); p.Cep = dr.GetString(7); p.Cidade = dr.GetString(8); p.Uf = dr.GetString(9); } dr.Close(); conexao.Close(); return(p); }
public List <Pessoa> ListAll() { List <Veiculo> lista_veiculo = new List <Veiculo>(); Veiculo v = null; SQLiteConnection conexao = Database.GetInstance().GetConnection(); string qry = string.Format("SELECT id,marca,modelo,combustive,placa,kmRodado,ano FROM Veiculo;"); if (conexao.State != System.Data.ConnectionState.Open) { conexao.Open(); } SQLiteCommand comm = new SQLiteCommand(qry, conexao); SQLiteDataReader dr = comm.ExecuteReader(); while (dr.Read()) { int id = dr.GetInt16(0); string marca = dr.GetString(1); string modelo = dr.GetString(2); string combustivel = dr.GetString(3); string placa = dr.GetString(4); string kmRodado = dr.GetInt16(5); string ano = dr.GetInt16(6); v = new Veiculo(marca, modelo, combustivel, placa, kmRodado, ano); lista_veiculo.Add(v); } dr.Close(); conexao.Close(); return(lista_veiculo); }
private void TopPlayers_Load(object sender, EventArgs e) { playerList = new List <Player>(); using (SQLiteConnection conn = new SQLiteConnection(connectionstring)) //(automatically closes the connection) { conn.Open(); string selectQuery = "SELECT Name, Time, Attemps FROM Users ORDER BY Time ASC;"; SQLiteCommand cmd = new SQLiteCommand(selectQuery, conn); SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { if (playerList.Any(x => x.Name == reader.GetString(0))) // if user exist in the list then we just add its attempt { playerList.Find(x => x.Name == reader.GetString(0)).Attempts.Add(new Attempt(reader.GetInt16(1), reader.GetInt16(2))); } else // if user doesn't exist we add him to the list with its attempt { playerList.Add(new Player(reader.GetString(0), new List <Attempt> { new Attempt(reader.GetInt16(1), reader.GetInt16(2)) })); } } // We add only the names of the player list listBox1.DataSource = playerList.Select(x => x.Name).ToList(); } }
public static List <journalP> getAllJournals(String champ, String texte) { List <journalP> liste = new List <journalP>(); try { SQLConnexion cnx = new SQLConnexion(); //cnx.OpenConnection(); String requette = "SELECT id, idp, tache from journalp WHERE " + champ + " like '%" + texte + "%' "; cnx.com.CommandText = requette; SQLiteDataReader reader = cnx.com.ExecuteReader(); while (reader.Read()) { liste.Add(new journalP() { id = reader.GetInt16(0), idP = reader.GetInt16(1), tache = reader.GetString(2) }); } return(liste); } catch (Exception e) { MessageBox.Show("" + e.Message + "" + e.Source, "Erreur"); return(null); } }
public Veiculo Read(string id) { Veiculo v = null; SQLiteConnection conexao = Database.GetInstance().GetConnection(); string qry = string.Format("SELECT id, marca, modelo, combustivel, placa, kmRodado, ano FROM veiculoCliente WHERE id ='{0}'", id); if (conexao.State != System.Data.ConnectionState.Open) { conexao.Open(); } SQLiteCommand comm = new SQLiteCommand(qry, conexao); SQLiteDataReader dr = comm.ExecuteReader(); if (dr.Read()) { v = new Veiculo("", "", "", "", "", "", ""); v.Id = dr.GetInt16(0); v.Marca = dr.GetString(1); v.Modelo = dr.GetString(2); v.Combustivel = dr.GetString(3); v.Placa = dr.GetString(4); v.KmRodado = dr.GetInt16(5); v.Ano = dr.GetInt16(6); } dr.Close(); conexao.Close(); return(v); }
public Categorie getCategorie(int id) { openBase(); string sql = "SELECT cat_id, cat_nom, cat_agemin, cat_agemax, cat_sexe, cat_poidsmin, cat_poidsmax, cat_creation FROM categorie WHERE cat_id = " + id; logger.Info("getCategorie: requête = " + sql); Categorie categ = new Categorie(); using (SQLiteCommand cmd = new SQLiteCommand(sql, _dbConnection)) { using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Categorie.Sexe sexe = reader.GetString(4) == "F" ? Categorie.Sexe.FEMALE : Categorie.Sexe.MALE; categ = new Categorie((int)reader.GetInt16(0), reader.GetString(1), (int)reader.GetInt16(2), (int)reader.GetInt16(3), sexe, (int)reader.GetInt16(5), (int)reader.GetInt16(6)); } } } closeBase(); return(categ); }
private void recordsInList(SQLiteDataReader r) { liRecord lir = new liRecord(); lstLicentieRecord.Clear(); while (r.Read()) { //Maak list van geselecteerde rijen lir.Id = r.GetInt32(r.GetOrdinal("Lic_Id")); lir.Actief = r.GetInt16(r.GetOrdinal("Lic_Actief")); lir.Programma = r.GetString(r.GetOrdinal("Lic_Programma")); lir.Nr = r.GetInt32(r.GetOrdinal("Lic_Nr")); lir.Code = r.GetString(r.GetOrdinal("Lic_Code")); lir.Type = r.GetByte(r.GetOrdinal("Lic_Type")); lir.Usermode = r.GetInt16(r.GetOrdinal("Lic_Usermode")); lir.Naamlh = r.GetString(r.GetOrdinal("Lic_Naamlh")); lir.Displaynaamlh = r.GetString(r.GetOrdinal("Lic_Displaynaamlh")); lir.Contactpersoonlh = r.GetString(r.GetOrdinal("Lic_Contactpersoonlh")); lir.Adreslh = r.GetString(r.GetOrdinal("Lic_Adreslh")); lir.Postcodelh = r.GetString(r.GetOrdinal("Lic_Postcodelh")); lir.Woonplaatslh = r.GetString(r.GetOrdinal("Lic_Woonplaatslh")); lir.Telefoonnummerlh = r.GetString(r.GetOrdinal("Lic_Telefoonnummerlh")); lir.Emailadreslh = r.GetString(r.GetOrdinal("Lic_Emailadreslh")); lir.OudeControleCode = r.GetString(r.GetOrdinal("Lic_OudeControleCode")); lir.NieuweControleCode = r.GetString(r.GetOrdinal("Lic_NieuweControlecode")); lir.ControleCodeType = r.GetInt32(r.GetOrdinal("Lic_ControleCodetype")); lir.Mutatiedatum = r.GetDateTime(r.GetOrdinal("Lic_Mutatiedatum")); lir.Opmerking = r.GetString(r.GetOrdinal("Lic_Opmerking")); lstLicentieRecord.Add(lir); } }
public static List <journalArticle> getAllJournalArticleBySymbole(String texte) { List <journalArticle> liste = new List <journalArticle>(); try { SQLConnexion cnx = new SQLConnexion(); //cnx.OpenConnection(); // journalarticle id ,idadmin,symbole,anne,moi,jour,action,stock String requette = "SELECT id, idadmin, symbole, anne, moi, jour, action, stock from journalarticle WHERE symbole = '" + texte + "' "; cnx.com.CommandText = requette; SQLiteDataReader reader = cnx.com.ExecuteReader(); while (reader.Read()) { liste.Add(new journalArticle() { id = reader.GetInt16(0), idAdmin = reader.GetInt16(1), symbole = Int16.Parse(reader.GetString(2)), anne = reader.GetString(3), moi = reader.GetString(4), jour = reader.GetString(5), action = reader.GetString(6), remarque = reader.GetString(7) }); } return(liste); } catch (Exception e) { MessageBox.Show("" + e.Message + "" + e.Source, "Erreur"); return(null); } }
/// <summary> /// This will return the list of planets on that session. /// </summary> /// <param name="sessionid"></param> /// <returns>Array List of int(planet id's)</returns> public List <int> SessionPlanet(int sessionid) { List <int> result = new List <int>(); if (Check()) { //Console.WriteLine("Planet"); //Console.WriteLine("si"+ sessionid); string Query = String.Format("SELECT Planet_id FROM sessiontoplanet WHERE Session_id = {0}", sessionid); using (SQLiteCommand command = new SQLiteCommand(Query, dbc)) { try { //Console.WriteLine("try1"); using (SQLiteDataReader rdq = command.ExecuteReader()) { //Console.WriteLine("rdq"); while (rdq.Read()) { result.Add(rdq.GetInt16(0)); //Console.WriteLine("HELLLL"); Console.WriteLine(rdq.GetInt16(0)); } } } catch (Exception ex) { Console.WriteLine("Error " + ex); } } } //Console.WriteLine("Planet Session Done"); return(result); }
private static void ReadPlayerInfo(SQLiteDataReader reader, Player player) { player.Id = (uint)reader.GetInt32(0); player.Name = reader.GetString(1); player.Gender = (Gender)reader.GetByte(2); player.Vocation = (Vocation)reader.GetByte(3); player.Level = (ushort)reader.GetInt16(4); player.MagicLevel = reader.GetByte(5); player.Experience = (uint)reader.GetInt32(6); player.MaxHealth = (ushort)reader.GetInt16(7); player.MaxMana = (ushort)reader.GetInt16(8); player.Capacity = (uint)reader.GetInt32(9); player.Outfit.LookType = (ushort)reader.GetInt16(10); player.Outfit.Head = reader.GetByte(11); player.Outfit.Body = reader.GetByte(12); player.Outfit.Legs = reader.GetByte(13); player.Outfit.Feet = reader.GetByte(14); player.Outfit.Addons = reader.GetByte(15); if (reader.GetInt64(20) > 0) { int x = reader.GetInt32(16); int y = reader.GetInt32(17); int z = reader.GetInt32(18); player.SavedLocation = new Location(x, y, z); player.Direction = (Direction)reader.GetByte(19); player.LastLogin = new DateTime(reader.GetInt64(20)); } player.Speed = (ushort)(220 + (2 * (player.Level - 1))); }
public Membre getMembre(int id) { openBase(); string sql = "SELECT mem_id, mem_nom, mem_prenom, mem_sexe, mem_age, mem_poids, mem_club FROM membre WHERE mem_id = " + id; logger.Info("getMembre: requête = " + sql); Membre membre = new Membre(); using (SQLiteCommand cmd = new SQLiteCommand(sql, _dbConnection)) { using (SQLiteDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { Categorie.Sexe sexe = reader.GetString(3) == "F" ? Categorie.Sexe.FEMALE : Categorie.Sexe.MALE; membre = new Membre((int)reader.GetInt16(0), reader.GetString(1), reader.GetString(2), sexe, (int)reader.GetInt16(4), (int)reader.GetInt16(5), (int)reader.GetInt16(6)); } } } closeBase(); return(membre); }
public List <Cadets> LoadCadets(SQLiteConnection _conn, int cadetID) { List <Cadets> cadets = new List <Cadets>(); int loopi = 0; String sqlQ = "SELECT * FROM Cadets"; //SQLiteDataReader sqlReader = ExecuteDBRead(sqlQ); _conn.Open(); SQLiteCommand scmd = new SQLiteCommand(sqlQ, _conn); SQLiteDataReader sqlReader = scmd.ExecuteReader(); while (sqlReader.Read()) { cadets.Add(new Cadets() { ID = sqlReader.GetInt16(0), Name = sqlReader.GetString(1), Address = sqlReader.GetString(2), Email = sqlReader.GetString(3), Cuit = sqlReader.GetString(4), Tel = sqlReader.GetString(5) }); cadetPayList.Items.Add(sqlReader.GetString(1)); if (cadetID == sqlReader.GetInt16(0)) { cadetPayList.SelectedIndex = loopi; } loopi++; } _conn.Close(); return(cadets); }
public Annotation buildObject(SQLiteDataReader res) { Annotation note = new Annotation(); note.Id = res.GetInt16(res.GetOrdinal("id")); note.Title = (string)res["title"]; //Há situações em que o texto não é selecionado if (res.GetOrdinal("text") > -1) { byte[] text = GetBytes("text", res); text = Encoding.Convert(Encoding.GetEncoding("iso-8859-1"), Encoding.UTF8, text); note.Text = Encoding.UTF8.GetString(text, 0, text.Length); } if (res.GetOrdinal("size") > -1) { note.Size = res.GetInt32(res.GetOrdinal("size")); } note.CreatedAt = converToDateTime((string)res["createdAt"]); //createdAt note.UpdatedAt = converToDateTime((string)res["updatedAt"]); //updatedAt note.CategoryId = res.GetInt16(res.GetOrdinal("categoryId")); //categoryId note.Position = res.GetInt32(res.GetOrdinal("position")); //position note.Password = (res["password"] != DBNull.Value ? (string)res["password"] : null); return(note); }
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 static List <IItem> LoadFromDB_Items() { SQLiteCommand sqlite_cmd; sqlite_cmd = sqlite_conn.CreateCommand(); sqlite_cmd.CommandText = "SELECT * FROM Products"; List <IItem> items = new List <IItem>(); SQLiteDataReader reader = sqlite_cmd.ExecuteReader(); while (reader.Read()) { if (reader.GetInt16(4) == 0) { //it's a food item. int id = reader.GetInt32(0); string prodName = reader.GetString(1); string desc = ""; if (reader[2].GetType() != typeof(DBNull)) { desc = reader.GetString(2); } else { desc = null; } //Console.WriteLine(reader[3].GetType().ToString()); string price = reader.GetDecimal(3).ToString(); items.Add(new FoodItem(id, prodName, desc, float.Parse(price))); } else if (reader.GetInt16(4) == 1) { // it's a drink item int id = reader.GetInt32(0); string prodName = reader.GetString(1); string desc = ""; if (reader[2].GetType() != typeof(DBNull)) { desc = reader.GetString(1); } else { desc = null; } //Console.WriteLine(reader[3].GetType().ToString()); string price = reader.GetDecimal(3).ToString(); items.Add(new DrinkItem(id, prodName, desc, float.Parse(price))); } else { // we should never be here - it means the database has a product type that isn't 1 or 0. throw new InvalidDataException(); } } return(items); }
private List <Veiculo> Read(string qry) { Veiculo v = null; SQLiteConnection conexao = Database.GetInstance().GetConnection(); if (conexao.State != System.Data.ConnectionState.Open) { conexao.Open(); } SQLiteCommand comm = new SQLiteCommand(qry, conexao); SQLiteDataReader dr = comm.ExecuteReader(); List <Veiculo> veiculo = new List <Veiculo>(); while (dr.Read()) { v = new Veiculo(); v.Id = dr.GetInt16(0); v.Marca = dr.GetString(1); v.Modelo = dr.GetString(2); v.Combustivel = dr.GetString(3); v.Placa = dr.GetString(4); v.KmRodado = dr.GetInt16(5); v.Ano = dr.GetInt16(6); veiculo.Add(v); } foreach (Veiculo vc in veiculo) { qry = string.Format("SELECT p.* FROM pessoa p INNER JOIN veiculo v ON p.id = v.idCliente WHERE v.id = {0}", vc.Id); comm = new SQLiteCommand(qry, conexao); dr = comm.ExecuteReader(); while (dr.Read()) { var p = new Pessoa(); p.Id = int.Parse(dr["id"].ToString()); p.Cpf = dr["cpf"].ToString(); p.Nome = dr["nome"].ToString(); p.Sexo = dr["sexo"].ToString(); p.Rua = dr["rua"].ToString(); p.Bairro = dr["bairro"].ToString(); p.Numero = int.Parse(dr["numero"].ToString()); p.Cep = dr["cep"].ToString(); p.Cidade = dr["cidade"].ToString(); p.Uf = dr["uf"].ToString(); vc.Pessoa.Add(p); } } dr.Close(); conexao.Close(); return(veiculo); }
private void timer1_Tick(object sender, EventArgs e) { timer1.Enabled = false; DataGridViewCellStyle gray = new DataGridViewCellStyle(); gray.ForeColor = Color.LightGray; SQLiteConnection cnn = GGKUtilLib.getDBConnection(); dgvEditKit.Rows.Clear(); SQLiteCommand query = new SQLiteCommand(@"SELECT kit_no,name,sex,disabled,coalesce(x,0),coalesce(y,0),last_modified FROM kit_master WHERE reference=0 order by last_modified DESC", cnn); SQLiteDataReader reader = query.ExecuteReader(); string sex = "U"; string xy = null; while (reader.Read()) { int new_idx = dgvEditKit.Rows.Add(); DataGridViewRow row = dgvEditKit.Rows[new_idx]; row.Cells[0].Value = reader.GetString(0); row.Cells[1].Value = reader.GetString(1); sex = reader.GetString(2); if (sex == "U") { row.Cells[2].Value = "Unknown"; } else if (sex == "M") { row.Cells[2].Value = "Male"; } else if (sex == "F") { row.Cells[2].Value = "Female"; } if (reader.GetInt16(3) == 1) { row.Cells[3].Value = true; } else { row.Cells[3].Value = false; } xy = reader.GetInt16(4).ToString() + ":" + reader.GetInt16(5).ToString(); if (xy == "0:0") { xy = "Unknown"; } row.Cells[4].Value = xy; } query.Dispose(); cnn.Dispose(); }
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); }
public Category buildObject(SQLiteDataReader res) { Category categ = new Category(); categ.Id = res.GetInt16(res.GetOrdinal("id")); categ.Description = (string)res["description"]; categ.Color = (string)res["color"]; categ.Editable = (res["editable"] == DBNull.Value ? 0 : res.GetInt16(res.GetOrdinal("editable"))); categ.Font = (res["font"] == DBNull.Value ? null : (string)res["font"]); categ.MustHide = (res["mustHide"] == DBNull.Value ? 0 : res.GetInt16(res.GetOrdinal("mustHide"))); categ.Selected = res.GetInt16(res.GetOrdinal("selected")); return(categ); }
public DelphiCategory buildObject(SQLiteDataReader res) { DelphiCategory categ = new DelphiCategory(); categ.CodCateg = res.GetInt16(res.GetOrdinal("codCateg")); categ.DesCateg = (string)res["desCateg"]; categ.CorCateg = (string)res["corCateg"]; categ.EdtCateg = (res["edtCateg"] == DBNull.Value ? 0 : res.GetInt16(res.GetOrdinal("edtCateg"))); categ.FntCateg = (res["fntCateg"] == DBNull.Value ? null : (string)res["fntCateg"]); categ.HidCateg = (res["hidCateg"] == DBNull.Value ? 0 : res.GetInt16(res.GetOrdinal("hidCateg"))); categ.SelCateg = res.GetInt16(res.GetOrdinal("selCateg")); return(categ); }
void FillCombos(SQLiteConnection _conn) { String sqlQ = "SELECT * FROM Clients"; //SQLiteDataReader sqlReader = ExecuteDBRead(sqlQ); _conn.Open(); SQLiteCommand scmd = new SQLiteCommand(sqlQ, _conn); SQLiteDataReader sqlReader = scmd.ExecuteReader(); while (sqlReader.Read()) { clientList.Add(new Clients() { ID = sqlReader.GetInt16(0), Name = sqlReader.GetString(1), Contact = sqlReader.GetString(2), Address = sqlReader.GetString(3), Email = sqlReader.GetString(4), Cuit = sqlReader.GetString(5), Tel = sqlReader.GetString(6) }); clientNames.Add(sqlReader.GetString(1)); tripFiltClient.Items.Add(sqlReader.GetString(1)); } dbConnection.Close(); sqlQ = "SELECT * FROM Cadets"; //SQLiteDataReader sqlReader = ExecuteDBRead(sqlQ); dbConnection.Open(); scmd = new SQLiteCommand(sqlQ, _conn); sqlReader = scmd.ExecuteReader(); while (sqlReader.Read()) { cadetList.Add(new Cadets() { ID = sqlReader.GetInt16(0), Name = sqlReader.GetString(1), Address = sqlReader.GetString(2), Email = sqlReader.GetString(3), Cuit = sqlReader.GetString(4), Tel = sqlReader.GetString(5) }); cadetNames.Add(sqlReader.GetString(1)); tripFiltCadet.Items.Add(sqlReader.GetString(1)); } dbConnection.Close(); }
private void CreateLendPanel(GridRowHeaderDoubleClickEventArgs e, SQLiteConnection conn) { GridPanel panel = ArchiveGrid.PrimaryGrid; GridRow row = (GridRow)panel.Rows[e.GridRow.RowIndex]; SQLiteCommand cmd = new SQLiteCommand(); cmd.Connection = conn; try { int archId = int.Parse(row.Cells[1].Value.ToString()); string strsql = string.Format("select * from LendArchive where ArchId ={0} order by LendDate desc", archId); cmd.CommandText = strsql; SQLiteDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { GridPanel subPanel = new GridPanel(); SetLendPanelColumn(subPanel); while (reader.Read()) { GridRow gr = new GridRow(); gr.Cells.Add(new GridCell(reader.GetInt16(0))); gr.Cells.Add(new GridCell(reader.GetString(1))); if (!reader.IsDBNull(2)) { gr.Cells.Add(new GridCell(Convert.ToDateTime(reader.GetString(2)))); } gr.Cells.Add(new GridCell(reader.GetInt16(3))); gr.Cells.Add(new GridCell(reader.IsDBNull(4) ? "" : reader.GetString(4))); gr.Cells.Add(new GridCell(reader.IsDBNull(5) ? "" : reader.GetString(5))); gr.Cells.Add(new GridCell(reader.IsDBNull(9) ? "" : reader.GetString(9))); gr.Cells.Add(new GridCell(reader.IsDBNull(7) ? "" : reader.GetString(7))); if (!reader.IsDBNull(8)) { gr.Cells.Add(new GridCell(Convert.ToDateTime(reader.GetString(8)))); } gr.Cells.Add(new GridCell(reader.IsDBNull(6) ? "" : reader.GetString(6))); gr.Cells.Add(new GridCell(reader.IsDBNull(10) ? "" : reader.GetString(10))); gr.Cells.Add(new GridCell(reader.IsDBNull(11) ? "" : reader.GetString(11))); subPanel.Rows.Add(gr); } e.GridRow.Rows.Add(subPanel); e.GridRow.Expanded = true; } } catch (System.Data.SQLite.SQLiteException E) { throw new Exception(E.Message); } }
internal static bool IsHeld(SQLiteConnection dbConnection, string imagePath) { dbConnection.Open(); bool isHeld = false; string isHeldSql = "SELECT COUNT(*) FROM held_images WHERE name = @name"; SQLiteCommand cmd = new SQLiteCommand(isHeldSql, dbConnection); cmd.Parameters.Add(new SQLiteParameter("@name", imagePath)); SQLiteDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { isHeld = reader.GetInt16(0) > 0; } } reader.Close(); dbConnection.Close(); return(isHeld); }
/// <summary> /// Executes the Input query and return the result set as list. /// </summary> /// <param name="query"> Query to be Executed. </param> /// <param name="Idflag"> Integer flag indicating the return Type to be Integer/String </param> /// <returns> Array List based on Integer flag passed. </returns> public string[] ExecReader(string query, int Idflag) { ArrayList alElements = new ArrayList(); using (acCmd = new SQLiteCommand(acConnection)) { acCmd.CommandText = query; SQLiteDataReader dr = acCmd.ExecuteReader(); // loop through all the rows if (dr.HasRows) { while (dr.Read()) { if (Idflag == 1) { alElements.Add(dr.GetInt16(0) + ""); } else { alElements.Add(dr.GetString(0)); } } } } // convert arraylist to a string array string[] elements = (string[])alElements.ToArray(typeof(string)); return(elements); }
internal List <CompetitionImage> SelectScoredImages(string sql) { List <CompetitionImage> scoredImages = new List <CompetitionImage>(); string databaseFilePath = ImagePaths.GetDatabaseFile(this.GetName()); SQLiteConnection dbConnection = new SQLiteConnection("DataSource=" + databaseFilePath + ";Version=3;"); dbConnection.Open(); SQLiteCommand cmd = new SQLiteCommand(sql, dbConnection); SQLiteDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { var timestamp = reader.GetString(0); var imageName = reader.GetString(1); var score = reader.GetInt16(2); foreach (CompetitionImage eachImage in this.images) { if (eachImage.GetFilePath() == imageName) { eachImage.SetScore(score, timestamp); scoredImages.Add(eachImage); break; } } } } return(scoredImages); }
public short GetIdNew(DataBlock db) { short GetInt = 0; try { using (SQLiteConnection sqlConnection = new SQLiteConnection(LocalBaseDAO.ConnectionString)) { SQLiteCommand sqlCommand = new SQLiteCommand(); sqlCommand.Connection = sqlConnection; sqlCommand.CommandType = CommandType.Text; sqlCommand.CommandText = string.Format("SELECT MAX(TagId) FROM {0} WHERE {1} = {2} AND {3} = {4} AND {5} = {6}", "[Tag]", "ChannelId", db.ChannelId, "DeviceId", db.DeviceId, "DataBlockId", db.DataBlockId); sqlConnection.Open(); SQLiteDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { try { GetInt = sqlDataReader.GetInt16(0); } catch (Exception) { GetInt = 0; } } return((short)(GetInt + 1)); } } catch (Exception ex2) { throw ex2; } }
public static List <Personel> getAllPersonels(String champ, String texte) { List <Personel> liste = new List <Personel>(); try { SQLConnexion cnx = new SQLConnexion(); //cnx.OpenConnection(); String requette = "SELECT id, nom, role, login, mdp from personel WHERE " + champ + " like '%" + texte + "%' "; cnx.com.CommandText = requette; SQLiteDataReader reader = cnx.com.ExecuteReader(); while (reader.Read()) { liste.Add(new Personel() { id = reader.GetInt16(0), nom = reader.GetString(1), role = reader.GetString(2), login = reader.GetString(3), pass = reader.GetString(4) }); } return(liste); } catch (Exception e) { MessageBox.Show("" + e.Message + "" + e.Source, "Erreur"); return(null); } }
public List <Clients> LoadClients(SQLiteConnection _conn) { List <Clients> clients = new List <Clients>(); string sqlQ = "SELECT * FROM Clients ORDER BY name ASC"; //SQLiteDataReader sqlReader = ExecuteDBRead(sqlQ); _conn.Open(); SQLiteCommand scmd = new SQLiteCommand(sqlQ, _conn); SQLiteDataReader sqlReader = scmd.ExecuteReader(); while (sqlReader.Read()) { String lala = sqlReader.GetString(1); clients.Add(new Clients() { ID = sqlReader.GetInt16(0), Name = sqlReader.GetString(1), Contact = sqlReader.GetString(2), Address = sqlReader.GetString(3), Email = sqlReader.GetString(4), Cuit = sqlReader.GetString(5), Tel = sqlReader.GetString(6) }); } _conn.Close(); return(clients); }
/// <summary> /// Récupérer un objet en fonction de son id /// </summary> /// <returns>The by.</returns> /// <param name="id">Identifier.</param> public static Model.Media FindBy(long id) { string sql = "SELECT * FROM link WHERE id = @id"; Model.Media m = null; try { SQLiteConnection c = Dao.Open(); SQLiteCommand query = new SQLiteCommand(sql, c); query.Parameters.AddWithValue("@id", id); SQLiteDataReader reader = query.ExecuteReader(); while (reader.Read()) { m = new Model.Media(); m.id = reader.GetInt64(0); m.url = reader.GetString(1); m.sender = reader.GetString(2); m.genre = reader.GetString(3); m.author = reader.GetString(4); m.title = reader.GetString(5); m.isViewed = reader.GetInt16(6); } reader.Close(); query.Dispose(); c.Close(); Console.WriteLine("FindBy"); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new Exception(ex.Message); } return(m); }
/// <summary> /// Récupérer tous les objets /// </summary> /// <returns>The all.</returns> public static List <Model.Media> FindAll() { List <Model.Media> medias = new List <Model.Media>(); string sql = "SELECT * FROM link"; try { SQLiteConnection c = Dao.Open(); SQLiteCommand query = new SQLiteCommand(sql, c); SQLiteDataReader reader = query.ExecuteReader(); while (reader.Read()) { Model.Media m = new Model.Media(); m.id = reader.GetInt32(0); m.url = reader.GetString(1); m.sender = reader.GetString(2); m.genre = reader.GetString(3); m.author = reader.GetString(4); m.title = reader.GetString(5); m.isViewed = reader.GetInt16(6); medias.Add(m); } reader.Close(); query.Dispose(); c.Close(); Console.WriteLine("FindAll"); } catch (Exception ex) { Console.WriteLine(ex.Message); throw new Exception(ex.Message); } return(medias); }