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);
}
