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);
}
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 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);
}
private void AddFromRecordSet(SQLiteDataReader rs)
{
try
{
if (!rs.IsDBNull(0))
{
_class_id = (ExtendedProperty_Type)rs.GetByte(0);
}
if (!rs.IsDBNull(1))
{
_class_desc = rs.GetString(1);
}
if (!rs.IsDBNull(2))
{
_major_id = rs.GetInt32(2);
}
if (!rs.IsDBNull(3))
{
_minor_id = rs.GetInt32(3);
}
if (!rs.IsDBNull(4))
{
_name = rs.GetString(4);
}
if (!rs.IsDBNull(5))
{
_value = rs.GetValue(5);
}
}
catch (Exception)
{
throw;
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
using (SQLiteConnection con = new SQLiteConnection(Adress))
using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Users WHERE userName=@uName", con))
{
con.Open();
cmd.Parameters.AddWithValue("@uName", TEMP.active_User);
using (SQLiteDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
UserNameTxt.Content = reader.GetString(0);
RealNameTbox.Text = reader.GetString(2);
TelNoTbox.Text = reader.GetInt64(3).ToString();
AccTypeTbox.Content = (reader.GetByte(4) == 1) ? "Admin" : "User";
reader.Close();
}
else
{
MessageBox.Show("Sorunla karşılaşıldı", "OPPPS", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
con.Close();
cmd.Dispose();
}
}
public static List <EquipmentData> GetListByTime2(string equipmentID, DateTime dt1, DateTime dt2)
{
//dt2 = dt2.AddDays(1);
string sql = string.Format("select a.EquipmentID,a.Chroma,a.Temperature,a.Humidity,a.AddTime,b.UnitType from tb_EquipmentData a left join tb_Equipment b on a.EquipmentID=b.ID where EquipmentID in ({0}) and AddTime >='{1}' and AddTime <='{2}'", equipmentID, dt1.ToString("yyyy-MM-dd HH:mm:ss"), dt2.ToString("yyyy-MM-dd HH:mm:ss"));
List <EquipmentData> list = new List <EquipmentData>();
Stopwatch watch = new Stopwatch();
watch.Start();
using (SQLiteDataReader reader = SqliteHelper.ExecuteReader(sql))
{
Trace.WriteLine("ExecuteReader: " + watch.Elapsed);
watch.Restart();
while (reader.Read())
{
EquipmentData eq = new EquipmentData();
eq.EquipmentID = reader.GetInt32(0);
eq.Chroma = reader.GetFloat(1);
eq.Chroma = eq.Chroma < 10000 ? eq.Chroma : 0;
eq.AddTimeStr = reader[4].ToString();
eq.UnitType = reader.GetByte(5);
list.Add(eq);
}
Trace.WriteLine("read: " + watch.Elapsed);
}
watch.Stop();
return(list);
}
public static IEnumerable <Item> GetChildItems(int uniqueItemId)
{
parentUniqueIdParam.Value = uniqueItemId;
SQLiteDataReader reader = ((SQLiteCommand)selectChildItemsCommand.Clone()).ExecuteReader();
try
{
while (reader.Read())
{
int uniqueId = reader.GetInt32(0);
ushort itemId = (ushort)reader.GetInt32(1);
byte extra = reader.GetByte(2);
Item item = Item.Create(itemId);
item.Extra = extra;
if (item is Container)
{
foreach (var i in GetChildItems(uniqueId))
{
((Container)item).AddItem(i);
}
}
yield return(item);
}
}
finally
{
reader.Close();
}
}
public static IEnumerable <KeyValuePair <SlotType, Item> > GetPlayerInventory(uint playerId)
{
playerIdParam.Value = playerId;
SQLiteDataReader reader = selectInventoryCommand.ExecuteReader();
try
{
while (reader.Read())
{
SlotType slot = (SlotType)reader.GetInt32(0);
int uniqueId = reader.GetInt32(1);
ushort itemId = (ushort)reader.GetInt32(2);
byte extra = reader.GetByte(3);
Item item = Item.Create(itemId);
item.Extra = extra;
if (item is Container)
{
foreach (var i in GetChildItems(uniqueId))
{
((Container)item).AddItem(i);
}
}
yield return(new KeyValuePair <SlotType, Item>(slot, item));
}
}
finally
{
reader.Close();
}
}
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 void UpdateUserList()
{
Users.Clear();
using (SQLiteConnection connection = new SQLiteConnection("DataSource = " + _fullPathToDatabase + ";"))
{
connection.Open();
string commandText =
"SELECT * FROM USERS ORDER BY NumberOfWins DESC;";
SQLiteCommand command = new SQLiteCommand(commandText, connection);
using (SQLiteDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
string username = reader["Username"].ToString() ?? "";
Users.Add(reader.GetInt64(0),
new User(username, reader.GetInt32(2), reader.GetByte(3)));
}
}
}
connection.Close();
}
}
public IEnumerable <Country> GetAllCountries()
{
SQLiteConnection connection = GetConnectionForTable("azusa.countries");
SQLiteCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT * FROM azusa.countries";
SQLiteDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
Country country = new Country();
country.ID = dataReader.GetInt32(0);
country.DisplayName = dataReader.GetString(1);
country.BroadcastTelevisionSystem = dataReader.GetString(2);
country.CurrencyName = dataReader.GetString(3);
country.CurrencyConversion = dataReader.GetDouble(4);
country.LanguageId = dataReader.GetInt32(5);
if (!dataReader.IsDBNull(6))
{
country.PowerVoltage = dataReader.GetInt16(6);
}
if (!dataReader.IsDBNull(7))
{
country.PowerFrequency = dataReader.GetByte(7);
}
if (!dataReader.IsDBNull(8))
{
country.DvdRegion = dataReader.GetByte(8);
}
if (!dataReader.IsDBNull(9))
{
country.BlurayRegion = dataReader.GetString(9)[0];
}
if (!dataReader.IsDBNull(10))
{
country.DateAdded = dataReader.GetDateTime(10);
}
yield return(country);
}
dataReader.Dispose();
cmd.Dispose();
}
private void AddFromRecordSet(SQLiteDataReader rs)
{
try
{
if (!rs.IsDBNull(0))
{
_object_id = rs.GetInt32(0);
}
if (!rs.IsDBNull(1))
{
_index_id = rs.GetInt32(1);
}
if (!rs.IsDBNull(2))
{
_index_column_id = rs.GetInt32(2);
}
if (!rs.IsDBNull(3))
{
_column_id = rs.GetInt32(3);
}
if (!rs.IsDBNull(4))
{
_key_ordinal = rs.GetByte(4);
}
if (!rs.IsDBNull(5))
{
_partition_ordinal = rs.GetByte(5);
}
if (!rs.IsDBNull(6))
{
_is_descending_key = rs.GetBoolean(6);
}
if (!rs.IsDBNull(7))
{
_is_included_column = rs.GetBoolean(7);
}
}
catch (Exception)
{
throw;
}
}
public void Load(T item)
{
_selectCommand.Parameters["@id"].Value = item.id;
using (SQLiteDataReader reader = _selectCommand.Command.ExecuteReader())
{
if (reader.Read())
{
for (int i = 0; i < _allProperties.Count; i++)
{
PropertyInfo p = _allProperties[i];
if (p.PropertyType == typeof(string))
{
p.SetValue(item, reader.GetString(i));
}
else if (p.PropertyType == typeof(bool))
{
p.SetValue(item, reader.GetBoolean(i));
}
else if (p.PropertyType == typeof(Int64))
{
p.SetValue(item, reader.GetInt64(i));
}
else if (p.PropertyType == typeof(Int32))
{
p.SetValue(item, reader.GetInt32(i));
}
else if (p.PropertyType == typeof(Int16))
{
p.SetValue(item, reader.GetInt16(i));
}
else if (p.PropertyType == typeof(byte))
{
p.SetValue(item, reader.GetByte(i));
}
else if (p.PropertyType == typeof(Nullable <Int64>))
{
object val = reader.GetValue(i);
if (val is DBNull)
{
p.SetValue(item, null);
}
else if (val is long)
{
p.SetValue(item, (long)val);
}
}
else
{
throw new Exception("Unhandled property type.");
}
}
}
}
}
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)
});
}
private CountEntry ParseCountEntry(SQLiteDataReader rd)
{
CountEntry entry = new CountEntry();
entry.Itmref = rd.GetString(0);
entry.LabelNumber = rd.GetInt32(1);
entry.Time = rd.GetDateTime(2);
entry.Value = (double)rd.GetDecimal(3);
entry.Unit = rd.GetString(4);
entry.IsDeleted = rd.GetByte(5) != 0;
entry.Sync = (CountEntry.SyncStatus)rd.GetInt32(6);
entry.Hash = rd.GetString(7);
entry.SyncCode = rd.GetInt32(8);
entry.Location = rd.IsDBNull(9) ? string.Empty : rd.GetString(9);
return(entry);
}
public Byte GetByte(ulong which)
{
string str = m_record.TranslateQueryValue(which);
int i;
for (i = 0; i < m_reader.FieldCount; ++i)
{
if (m_reader.GetName(i).Equals(str))
{
break;
}
}
if (i < m_reader.FieldCount)
{
return(m_reader.GetByte(0));
}
throw new IndexOutOfRangeException();
}
private void recordsInList(SQLiteDataReader r)
{
pdRecord pdr = new pdRecord();
lstProductRecord.Clear();
pdListCount = 0;
pdListTCount = 0;
while (r.Read())
{
//Maak list van geselecteerde rijen
pdListTCount++;
pdr.Prod_Id = r.GetInt32(r.GetOrdinal("Prod_Id"));
pdr.Prod_StatusId = r.GetInt32(r.GetOrdinal("Prod_StatusId"));
pdr.Prod_DispStatus = r.GetString(r.GetOrdinal("Prod_DispStatus"));
if (r.GetInt32(r.GetOrdinal("Prod_StatusId")) != 170009)
{
pdListCount++;
}
pdr.Prod_Naamkort = r.GetString(r.GetOrdinal("Prod_Naamkort"));
pdr.Prod_Naamlang = r.GetString(r.GetOrdinal("Prod_Naamlang"));
pdr.Prod_Kleur = r.GetString(r.GetOrdinal("Prod_Kleur"));
pdr.Prod_Code = r.GetString(r.GetOrdinal("Prod_Code"));
pdr.Prod_Soort = r.GetString(r.GetOrdinal("Prod_Soort"));
pdr.Prod_ActiefJN = r.GetInt16(r.GetOrdinal("Prod_ActiefJN"));
pdr.Prod_Dispactief = r.GetString(r.GetOrdinal("Prod_Dispactief"));
pdr.Prod_Waarde = r.GetDecimal(r.GetOrdinal("Prod_Waarde"));
pdr.Prod_Aantaleenhedenperproduct = r.GetByte(r.GetOrdinal("Prod_Aantaleenhedenperproduct"));
pdr.Prod_Verzamelnaam = r.GetString(r.GetOrdinal("Prod_Verzamelnaam"));
pdr.Prod_Waardepereenheid = r.GetDecimal(r.GetOrdinal("Prod_Waardepereenheid"));
pdr.Prod_Mutatiedatum = r.GetDateTime(r.GetOrdinal("Prod_Mutatiedatum"));
pdr.Prod_Opmerking = "";
try
{
pdr.Prod_Opmerking = r.GetString(r.GetOrdinal("Prod_Opmerking"));
}
catch (Exception)
{
}
lstProductRecord.Add(pdr);
}
}
private void recordsInList(SQLiteDataReader r)
{
blRecord blr = new blRecord();
lstBestelregelRecord.Clear();
blListCount = 0;
blListTCount = 0;
while (r.Read())
{
//Maak list van geselecteerde rijen
blListTCount++;
blr.Bstlr_Id = r.GetInt32(r.GetOrdinal("Bstlr_Id"));
blr.Bstlr_BstlId = r.GetInt32(r.GetOrdinal("Bstlr_BstlId"));
blr.Bstlr_StatusId = r.GetInt32(r.GetOrdinal("Bstlr_StatusId"));
if (r.GetInt32(r.GetOrdinal("Bstlr_StatusId")) != 135009)
{
blListCount++;
}
blr.Bstlr_DispStatus = r.GetString(r.GetOrdinal("Bstlr_DispStatus"));
blr.Bstlr_ProdId = r.GetInt32(r.GetOrdinal("Bstlr_ProdId"));
blr.Bstlr_DispProduct = r.GetString(r.GetOrdinal("Bstlr_DispProduct"));
blr.Bstlr_Aantal = r.GetByte(r.GetOrdinal("Bstlr_Aantal"));
blr.Bstlr_Beginnr = r.GetInt64(r.GetOrdinal("Bstlr_Beginnr"));
blr.Bstlr_Eindnr = r.GetInt64(r.GetOrdinal("Bstlr_Eindnr"));
blr.Bstlr_Voorraad = r.GetInt64(r.GetOrdinal("Bstlr_Voorraad"));
blr.Bstlr_Extranr1 = r.GetInt64(r.GetOrdinal("Bstlr_Extranr1"));
blr.Bstlr_Extranr2 = r.GetInt64(r.GetOrdinal("Bstlr_Extranr2"));
blr.Bstlr_Extranr3 = r.GetInt64(r.GetOrdinal("Bstlr_Extranr3"));
blr.Bstlr_Mutatiedatum = r.GetDateTime(r.GetOrdinal("Bstlr_Mutatiedatum"));
try
{
blr.Bstlr_Opmerking = r.GetString(r.GetOrdinal("Bstlr_Opmerking"));
}
catch (Exception)
{
}
lstBestelregelRecord.Add(blr);
}
}
private void recordsInList(SQLiteDataReader r)
{
ilRecord ilr = new ilRecord();
lstInstellingenRecord.Clear();
while (r.Read())
{
//Maak list van geselecteerde rijen
ilListTCount++;
ilr.Instl_Id = r.GetInt32(r.GetOrdinal("Instl_Id"));
ilr.Instl_Systeemsetting = r.GetInt32(r.GetOrdinal("Instl_Systeemsetting"));
ilr.Instl_StatusId = r.GetInt32(r.GetOrdinal("Instl_StatusId"));
ilr.Instl_DispStatus = r.GetString(r.GetOrdinal("Instl_DispStatus"));
if (r.GetInt32(r.GetOrdinal("Instl_StatusId")) != 185009)
{
ilListCount++;
}
ilr.Instl_Naam = r.GetString(r.GetOrdinal("Instl_Naam"));
ilr.Instl_Gegtype = r.GetByte(r.GetOrdinal("Instl_Gegtype"));
ilr.Instl_Actief = r.GetInt32(r.GetOrdinal("Instl_Actief"));
ilr.Instl_String = r.GetString(r.GetOrdinal("Instl_String"));
ilr.Instl_JN = r.GetInt32(r.GetOrdinal("Instl_JN"));
ilr.Instl_Integer = r.GetInt64(r.GetOrdinal("Instl_Integer"));
ilr.Instl_Real = r.GetDecimal(r.GetOrdinal("Instl_Real"));
ilr.Instl_Memo = r.GetString(r.GetOrdinal("Instl_Memo"));
ilr.Instl_Datum = r.GetDateTime(r.GetOrdinal("Instl_Datum"));
ilr.Instl_Tijd = r.GetDateTime(r.GetOrdinal("Instl_Tijd"));
ilr.Instl_Mutatiedatum = r.GetDateTime(r.GetOrdinal("Instl_Mutatiedatum"));
try
{
ilr.Instl_Opmerking = r.GetString(r.GetOrdinal("Instl_Opmerking"));
}
catch (Exception)
{
}
lstInstellingenRecord.Add(ilr);
}
}
static public string GetData(SQLiteDataReader reader, string column)
{
switch (Type.GetTypeCode(reader.GetFieldType(reader.GetOrdinal(column))))
{
case TypeCode.Boolean:
return(reader.GetBoolean(reader.GetOrdinal(column)).ToString());
case TypeCode.Byte:
return(reader.GetByte(reader.GetOrdinal(column)).ToString());
case TypeCode.Char:
return(reader.GetChar(reader.GetOrdinal(column)).ToString());
case TypeCode.DateTime:
return(reader.GetDateTime(reader.GetOrdinal(column)).ToString("yyyy/mm/dd HH:mm:ss"));
case TypeCode.Decimal:
return(reader.GetDecimal(reader.GetOrdinal(column)).ToString());
case TypeCode.Double:
return(reader.GetDouble(reader.GetOrdinal(column)).ToString());
case TypeCode.Int16:
return(reader.GetInt16(reader.GetOrdinal(column)).ToString());
case TypeCode.Int32:
return(reader.GetInt32(reader.GetOrdinal(column)).ToString());
case TypeCode.Int64:
return(reader.GetInt64(reader.GetOrdinal(column)).ToString());
case TypeCode.String:
return(reader.GetString(reader.GetOrdinal(column)));
default:
return("");
}
}
public IEnumerable <Packet> ReadPackets(string file)
{
using (var connection = new SQLiteConnection("Data Source=" + file))
{
var packets = new List <Packet>();
connection.Open();
SQLiteCommand command = connection.CreateCommand();
command.CommandText = "SELECT COUNT(*) FROM packets;";
command.Prepare();
var rows = (long)command.ExecuteScalar();
command.CommandText = "SELECT direction, opcode, data FROM packets ORDER BY id;";
command.Prepare();
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
//worker.ReportProgress((int)((float)m_packets.Count / (float)rows * 100.0f));
try
{
var direction = (Direction)reader.GetByte(0);
var opcode = (OpCodes)reader.GetInt16(1);
var data = (byte[])reader.GetValue(2);
packets.Add(new Packet(direction, opcode, data, 0, 0));
}
catch
{
}
}
return(packets);
}
}
public List <TableInfo> SelectAllFromTableInfo()
{
List <TableInfo> _list = new List <TableInfo>();
try
{
OpenConnection();
using (SQLiteConnection sqlConn = new SQLiteConnection(connectionDB))
using (SQLiteCommand cmd = new SQLiteCommand(sqlConn))
{
cmd.CommandText = "SELECT * FROM info";
{
using (SQLiteDataReader reader = cmd.ExecuteReader())
while (reader.Read())
{
TableInfo item = new TableInfo();
item.ID = reader.GetInt64(0);
item.Fio = reader.GetString(1);
item.TabelNumb = reader.GetString(2);
item.Shift = reader.GetString(3);
item.NormDoc = reader.GetString(4);
item.Specification = reader.GetString(5);
item.Drawing = reader.GetString(6);
item.SteelType = reader.GetString(7);
item.SopNumb = reader.GetString(8);
item.Lot = reader.GetString(9);
item.LotNumb = reader.GetString(10);
item.HeatNumb = reader.GetString(11);
item.BundleNumb = reader.GetString(12);
item.SerialNumb = reader.GetString(13);
item.AddNumb1 = reader.GetString(14);
item.AddNumb2 = reader.GetString(15);
item.AddNumb3 = reader.GetString(16);
item.AddNumb4 = reader.GetString(17);
item.AddNumb5 = reader.GetString(18);
item.ObjectLength = reader.GetDouble(19);
item.ObjectWidth = reader.GetDouble(20);
item.ObjectHeight = reader.GetDouble(21);
item.ObjectSpeed = reader.GetDouble(22);
item.ObjectOuterDiameter = reader.GetDouble(23);
item.ObjectInnerDiameter = reader.GetDouble(24);
item.ObjectWallThickness = reader.GetDouble(25);
item.ObjectA = reader.GetDouble(26);
item.ObjectB = reader.GetDouble(27);
item.ObjectC = reader.GetDouble(28);
item.ObjectD = reader.GetDouble(29);
item.ObjectE = reader.GetDouble(30);
item.ObjectF = reader.GetDouble(31);
item.ObjectG = reader.GetDouble(32);
item.ObjectH = reader.GetDouble(33);
item.ObjectI = reader.GetDouble(34);
item.ObjectJ = reader.GetDouble(35);
item.ObjectK = reader.GetDouble(36);
item.ObjectL = reader.GetDouble(37);
item.ObjectM = reader.GetDouble(38);
item.ObjectN = reader.GetDouble(39);
item.ObjectO = reader.GetDouble(40);
item.ObjectP = reader.GetDouble(41);
item.ObjectQ = reader.GetDouble(42);
item.ObjectR = reader.GetDouble(43);
item.ObjectS = reader.GetDouble(44);
item.ObjectT = reader.GetDouble(45);
item.ObjectU = reader.GetDouble(46);
item.ObjectV = reader.GetDouble(47);
item.ObjectW = reader.GetDouble(48);
item.ObjectX = reader.GetDouble(49);
item.ObjectY = reader.GetDouble(50);
item.ObjectZ = reader.GetDouble(51);
item.UsFilesPath = reader.GetString(52);
item.ControlResult = reader.GetByte(53);
item.DateTimeStump = reader.GetDateTime(54);
_list.Add(item);
}
;
}
}
return(_list);
}
catch (Exception)
{
throw;
}
finally
{
CloseConnection();
}
}
/// <summary>
///
/// </summary>
/// <param name="column"></param>
/// <param name="valueIfNull"></param>
/// <returns></returns>
public byte GetTinyInt(int column, byte valueIfNull)
{
return(IsDBNull(column) ? valueIfNull : currentReader.GetByte(column));
}
private static bool ParseFile(FileInfo f)
{
DateTime filestarttime = DateTime.Now;
Console.Write("Parsing {0}...", f.Name);
SQLiteConnection connection = new SQLiteConnection("Data Source=" + f.FullName);
SQLiteCommand command = new SQLiteCommand(connection);
connection.Open();
command.CommandText = "SELECT id, sess_id, timestamp, direction, opcode, data FROM packets ORDER BY id;";
command.Prepare();
SQLiteDataReader reader = command.ExecuteReader();
MemoryStream ms = new MemoryStream();
while (reader.Read())
{
uint id = (uint)reader.GetInt32(0);
uint sess_id = (uint)reader.GetInt32(1);
string timestamp = reader.GetString(2);
byte direction = reader.GetByte(3);
ushort opcode = (ushort)reader.GetInt32(4);
if (opcode > 1054)
{
Console.WriteLine(opcode);
throw new Exception("Test");
}
byte[] data_ = (byte[])reader.GetValue(5);
uint size = sizeof(uint) + sizeof(uint) + (uint)timestamp.Length + 1 + sizeof(byte) + sizeof(ushort) + (uint)data_.Length;
byte[] id_arr = BitConverter.GetBytes(id);
byte[] sessid_arr = BitConverter.GetBytes(sess_id);
byte[] time_arr = Encoding.ASCII.GetBytes(timestamp);
byte[] op = BitConverter.GetBytes(opcode);
byte[] sz = BitConverter.GetBytes(size);
ms.Write(sz, 0, sz.Length);
ms.Write(id_arr, 0, id_arr.Length);
ms.Write(sessid_arr, 0, sessid_arr.Length);
ms.Write(time_arr, 0, time_arr.Length);
ms.WriteByte(0);
ms.WriteByte(direction);
ms.Write(op, 0, op.Length);
ms.Write(data_, 0, data_.Length);
}
reader.Close();
connection.Close();
GenericReader gr = new GenericReader(ms, Encoding.ASCII);
gr.BaseStream.Position = 0;
string error_log = f.FullName + ".errors.txt";
StreamWriter swe = new StreamWriter(error_log);
string database_log = f.FullName + ".data.txt";
StreamWriter data = new StreamWriter(database_log);
string hex_log = f.FullName + ".hex.log";
StreamWriter hex = new StreamWriter(hex_log);
string ofn = f.FullName + ".data_out.txt";
StreamWriter sw = new StreamWriter(ofn);
sw.AutoFlush = true;
swe.AutoFlush = true;
data.AutoFlush = true;
hex.AutoFlush = true;
while (gr.PeekChar() >= 0)
{
//try
//{
if (ParseHeader(gr, sw, swe, data, hex))
{
packet++;
}
//}
//catch (Exception exc)
//{
// MessageBox.Show(exc.ToString());
// swe.WriteLine("error in pos " + gr.BaseStream.Position.ToString("X16"));
//}
}
// clear objects list...
m_objects.Clear();
sw.Close();
swe.Close();
data.Close();
hex.Close();
gr.Close();
TimeSpan fileworktime = DateTime.Now - filestarttime;
Console.WriteLine(" Parsed in {0}", fileworktime);
return(true);
}
void Button_Click(object sender, EventArgs e)
{
//string login = this.Login1.UserName;
//string haslo = this.Login1.Password;
string login = this.TextBox1.Text;
string haslo = this.TextBox2.Text;
//byte[] hash;
//using (MD5 md5 = MD5.Create())
//{
// hash = md5.ComputeHash(Encoding.UTF8.GetBytes(haslo));
//}
//string haslo2 = hash.ToString();
//string sql1 = string.Format("SELECT COUNT(*) from Uzytkownicy where login = {0} and haslo = {1};", login, hash);
string sql1 = string.Format("SELECT 1 from Uzytkownicy where login = '******' and haslo = '{1}';", login, haslo);
string sql2 = string.Format("SELECT czy_glosowal, czy_admin from Uzytkownicy where login = '******' and haslo = '{1}';", login, haslo);
//string sql3 = "CREATE TABLE Ankiety (id INTEGER PRIMARY KEY AUTOINCREMENT, opcja_pierwsza VARCHAR(20), glosy_pierwsza INTEGER, opcja_druga VARCHAR(20), glosy_druga INTEGER, opcja_trzecia VARCHAR(20), glosy_trzecia INTEGER, aktualna_liczba_glosow INTEGER, koncowa_liczba_glosow INTEGER, data VARCHAR(10), aktywna TINYINT(1), nazwa VARCHAR(45));";
string sql3 = string.Format("SELECT 1 from Ankiety where aktywna = 1");
SQLiteConnection m_dbConnection = new SQLiteConnection("Data Source=J:\\SEMESTR VII\\PIS\\AKTUALNE\\WebApplication1\\baza.sqlite;Version=3;");
m_dbConnection.Open();
SQLiteCommand selectCheckCommand = new SQLiteCommand(sql1, m_dbConnection);
SQLiteCommand selectUserCommand = new SQLiteCommand(sql2, m_dbConnection);
SQLiteCommand selectAnkietaCommand = new SQLiteCommand(sql3, m_dbConnection);
int count = Convert.ToInt32(selectCheckCommand.ExecuteScalar());
SQLiteDataReader sqlReader = selectUserCommand.ExecuteReader();
Int32 czy_admin = 0;
Int32 czy_glosowal = 0;
while (sqlReader.Read())
{
czy_glosowal = sqlReader.GetByte(0);
czy_admin = sqlReader.GetByte(1);
}
sqlReader.Close();
int ankieta = 0;
ankieta = Convert.ToInt32(selectAnkietaCommand.ExecuteScalar());
if (count == 1 && czy_admin == 1)
{
SQLiteCommand sessionCommand = new SQLiteCommand(string.Format("INSERT OR REPLACE INTO Sesja (login, admin) values ('{0}', '{1}')", login, czy_admin), m_dbConnection);
sessionCommand.ExecuteNonQuery();
m_dbConnection.Close();
if (ankieta == 1)
{
Response.Redirect("SurveyResults.aspx");
}
else
{
Response.Redirect("AdminAccount.aspx");
}
}
else if (count == 1 && czy_admin == 0)
{
SQLiteCommand sessionCommand = new SQLiteCommand(string.Format("INSERT OR REPLACE INTO Sesja (login, admin) values ('{0}', '{1}')", login, czy_admin), m_dbConnection);
sessionCommand.ExecuteNonQuery();
m_dbConnection.Close();
if (czy_glosowal == 0)
{
Response.Redirect("Survey.aspx");
}
else if (czy_glosowal == 1)
{
Response.Redirect("UserAccount.aspx");
}
}
}
private void AddFromRecordSet(SQLiteDataReader rs)
{
try
{
if (!rs.IsDBNull(0))
{
_collation_name = rs.GetString(0);
}
if (!rs.IsDBNull(1))
{
_column_id = rs.GetInt32(1);
}
if (!rs.IsDBNull(2))
{
_default_object_id = rs.GetInt32(2);
}
if (!rs.IsDBNull(3))
{
_is_ansi_padded = rs.GetBoolean(3);
}
if (!rs.IsDBNull(4))
{
_is_computed = rs.GetBoolean(4);
}
if (!rs.IsDBNull(5))
{
_is_dts_replicated = rs.GetBoolean(5);
}
if (!rs.IsDBNull(6))
{
_is_filestream = rs.GetBoolean(6);
}
if (!rs.IsDBNull(7))
{
_is_identity = rs.GetBoolean(7);
}
if (!rs.IsDBNull(8))
{
_is_merge_published = rs.GetBoolean(8);
}
if (!rs.IsDBNull(9))
{
_is_non_sql_subscribed = rs.GetBoolean(9);
}
if (!rs.IsDBNull(10))
{
_is_nullable = rs.GetBoolean(10);
}
if (!rs.IsDBNull(11))
{
_is_replicated = rs.GetBoolean(11);
}
if (!rs.IsDBNull(12))
{
_is_rowguidcol = rs.GetBoolean(12);
}
if (!rs.IsDBNull(13))
{
_is_xml_document = rs.GetBoolean(13);
}
if (!rs.IsDBNull(14))
{
_max_length = rs.GetInt16(14);
}
if (!rs.IsDBNull(15))
{
_name = rs.GetString(15);
}
if (!rs.IsDBNull(16))
{
_object_id = rs.GetInt32(16);
}
if (!rs.IsDBNull(17))
{
_precision = rs.GetByte(17);
}
if (!rs.IsDBNull(18))
{
_rule_object_id = rs.GetInt32(18);
}
if (!rs.IsDBNull(19))
{
_scale = rs.GetByte(19);
}
if (!rs.IsDBNull(20))
{
_system_type_id = rs.GetByte(20);
}
if (!rs.IsDBNull(21))
{
_user_type_id = rs.GetInt32(21);
}
if (!rs.IsDBNull(22))
{
_xml_collection_id = rs.GetInt32(22);
}
}
catch (Exception)
{
throw;
}
}
private void AddFromRecordSet(SQLiteDataReader rs)
{
try
{
if (!rs.IsDBNull(0))
{
_name = rs.GetString(0);
}
if (!rs.IsDBNull(1))
{
_object_id = rs.GetInt32(1);
}
if (!rs.IsDBNull(2))
{
_principal_id = rs.GetInt32(2);
}
if (!rs.IsDBNull(3))
{
_schema_id = rs.GetInt32(3);
}
if (!rs.IsDBNull(4))
{
_parent_object_id = rs.GetInt32(4);
}
if (!rs.IsDBNull(5))
{
_type = (Object_Type)Enum.Parse(typeof(Object_Type), rs.GetString(5));
}
if (!rs.IsDBNull(6))
{
_type_desc = rs.GetString(6);
}
if (!rs.IsDBNull(7))
{
_create_date = rs.GetDateTime(7);
}
if (!rs.IsDBNull(8))
{
_modify_date = rs.GetDateTime(8);
}
if (!rs.IsDBNull(9))
{
_is_ms_shipped = rs.GetBoolean(9);
}
if (!rs.IsDBNull(10))
{
_is_published = rs.GetBoolean(10);
}
if (!rs.IsDBNull(11))
{
_is_schema_published = rs.GetBoolean(11);
}
if (!rs.IsDBNull(12))
{
_referenced_object_id = rs.GetInt32(12);
}
if (!rs.IsDBNull(13))
{
_key_index_id = rs.GetInt32(13);
}
if (!rs.IsDBNull(14))
{
_is_disabled = rs.GetBoolean(14);
}
if (!rs.IsDBNull(15))
{
_is_not_for_replication = rs.GetBoolean(15);
}
if (!rs.IsDBNull(16))
{
_is_not_trusted = rs.GetBoolean(16);
}
if (!rs.IsDBNull(17))
{
_delete_referential_action = rs.GetByte(17);
}
if (!rs.IsDBNull(18))
{
_delete_referential_action_desc = rs.GetString(18);
}
if (!rs.IsDBNull(19))
{
_update_referential_action = rs.GetByte(19);
}
if (!rs.IsDBNull(20))
{
_update_referential_action_desc = rs.GetString(20);
}
if (!rs.IsDBNull(21))
{
_is_system_named = rs.GetBoolean(21);
}
}
catch (Exception)
{
throw;
}
}
private void AddFromRecordSet(SQLiteDataReader rs)
{
try
{
if (!rs.IsDBNull(0))
{
_object_id = rs.GetInt32(0);
}
if (!rs.IsDBNull(1))
{
_name = rs.GetString(1);
}
if (!rs.IsDBNull(2))
{
_index_id = rs.GetInt32(2);
}
if (!rs.IsDBNull(3))
{
byte tmptype = rs.GetByte(3);
_type = (Index_type)tmptype;
//switch (tmptype)
//{
// case 0:
// _type = Index_type.Heap;
// break;
// case 1:
// _type = Index_type.Clustered;
// break;
// case 2:
// _type = Index_type.Nonclustered;
// break;
// case 3:
// _type = Index_type.XML;
// break;
// default:
// break;
//}
}
if (!rs.IsDBNull(4))
{
_type_desc = rs.GetString(4);
}
if (!rs.IsDBNull(5))
{
_is_unique = rs.GetBoolean(5);
}
if (!rs.IsDBNull(6))
{
_data_space_id = rs.GetInt32(6);
}
if (!rs.IsDBNull(7))
{
_ignore_dup_key = rs.GetBoolean(7);
}
if (!rs.IsDBNull(8))
{
_is_primary_key = rs.GetBoolean(8);
}
if (!rs.IsDBNull(9))
{
_is_unique_constraint = rs.GetBoolean(9);
}
if (!rs.IsDBNull(10))
{
_fill_factor = rs.GetByte(10);
}
if (!rs.IsDBNull(11))
{
_is_padded = rs.GetBoolean(11);
}
if (!rs.IsDBNull(12))
{
_is_disabled = rs.GetBoolean(12);
}
if (!rs.IsDBNull(13))
{
_is_hypothetical = rs.GetBoolean(13);
}
if (!rs.IsDBNull(14))
{
_allow_row_locks = rs.GetBoolean(14);
}
if (!rs.IsDBNull(15))
{
_allow_page_locks = rs.GetBoolean(15);
}
}
catch (Exception)
{
throw;
}
}
public void loadStationsFromDB(Dictionary <string, Station> stationDic)
{
// string sql = @"SELECT name,positionX,positionY,btnX,btnY,next
// FROM station
// WHERE (ownerMap = @ownerMap)";
string sql = @"SELECT name,positionX,positionY,btnX,btnY,next,cardID,stationID
FROM station
WHERE (ownerMap = @ownerMap)";
SQLiteParameter[] parameters = new SQLiteParameter[]
{
new SQLiteParameter("@ownerMap", mapName),
};
SQLiteDBHelper db = getDataBase();
try
{
using (SQLiteDataReader reader = db.ExecuteReader(sql, parameters))
{
while (reader.Read())
{
//Console.WriteLine("indexNo:{0},shape:{1}", /*reader.GetInt64(0)*/1, reader.GetString(1));
Station s = new Station(reader.GetString(0), reader.GetInt32(1),
reader.GetInt32(2), reader.GetInt32(3), reader.GetInt32(4), reader.GetByte(6), reader.GetInt32(7));//select语句的顺序
stationDic.Add(reader.GetString(0), s);
if (!reader.IsDBNull(5))
{
s.Next = reader.GetString(5);
}
}
}
}
catch (Exception x)
{
Console.WriteLine(x.Message);
}
}
public static bool GetTinyIntBoolean(this SQLiteDataReader rdr, int ordinal)
{
return(rdr.GetByte(ordinal) != 0);
}
