private Expense BuildStructure(SQLiteDataReader reader) { long expenseId = reader.GetInt64(0); long accountId = reader.GetInt64(1); long amount = reader.GetInt64(2); long categoryId = reader.GetInt64(3); DateTime date = DateTime.Parse(reader.GetString(4)); string description = reader.GetString(5); return new Expense(expenseId, accountId, amount, categoryId, date, description); }
internal static void MapDataReaderToContentDto(SQLiteDataReader dataReader, out ContentDto contentDto) { contentDto = new ContentDto(); contentDto.ContentId = dataReader.GetInt64((int) ContentDao.ContentsField.ContentId); contentDto.UrlId = dataReader.GetInt64((int) ContentDao.ContentsField.UrlId); contentDto.ContentType = (ContentTypesEnum) dataReader.GetInt64((int) ContentDao.ContentsField.ContentType); contentDto.Element = dataReader.GetString((int) ContentDao.ContentsField.Element); contentDto.Element = HttpUtility.UrlDecode(contentDto.Element); contentDto.Line = dataReader.GetInt64((int) ContentDao.ContentsField.Line); contentDto.LinePosition = dataReader.GetInt64((int) ContentDao.ContentsField.LinePosition); }
private Person BuildUserStructure(SQLiteDataReader reader) { string name = reader.GetString(0); string fullName = reader.GetString(1); long personId = reader.GetInt64(2); return new Person(name, fullName, personId); }
public ResourceRecord(SQLiteDataReader rpReader) { ID = rpReader.GetInt64("time"); Fuel = rpReader.GetInt32("fuel"); Bullet = rpReader.GetInt32("bullet"); Steel = rpReader.GetInt32("steel"); Bauxite = rpReader.GetInt32("bauxite"); InstantConstruction = rpReader.GetInt32("instant_construction"); Bucket = rpReader.GetInt32("bucket"); DevelopmentMaterial = rpReader.GetInt32("development_material"); ImprovementMaterial = rpReader.GetInt32("improvement_material"); }
protected void ReadDvbData(SQLiteDataReader r, IDictionary<string, int> field, DataRoot dataRoot, Dictionary<long, string> providers) { this.ShortName = DbSerializer.ReadUtf16(r, 16); this.RecordOrder = r.GetInt32(field["major"]); int serviceType = r.GetInt32(field["srvType"]); this.ServiceType = serviceType; this.SignalSource |= LookupData.Instance.IsRadioOrTv(serviceType); this.OriginalNetworkId = r.GetInt32(field["onid"]); this.TransportStreamId = r.GetInt32(field["tsid"]); this.ServiceId = r.GetInt32(field["progNum"]); this.VideoPid = r.GetInt32(field["vidPid"]); if (!r.IsDBNull(field["provId"])) this.Provider = providers.TryGet(r.GetInt64(field["provId"])); }
internal DevelopmentRecord(SQLiteDataReader rpReader) { ID = rpReader.GetInt64("time"); var rEquipmentID = rpReader.GetInt32Optional("equipment"); if (rEquipmentID.HasValue) Equipment = KanColleGame.Current.MasterInfo.Equipment[rEquipmentID.Value]; FuelConsumption = rpReader.GetInt32("fuel"); BulletConsumption = rpReader.GetInt32("bullet"); SteelConsumption = rpReader.GetInt32("steel"); BauxiteConsumption = rpReader.GetInt32("bauxite"); SecretaryShip = KanColleGame.Current.MasterInfo.Ships[rpReader.GetInt32("flagship")]; HeadquarterLevel = rpReader.GetInt32("hq_level"); }
internal FateRecord(SQLiteDataReader rpReader) { ID = rpReader.GetInt64("time"); var rMasterInfo = KanColleGame.Current.MasterInfo; var rMasterID = rpReader.GetInt32("master_id"); IsEquipment = rpReader.GetBoolean("is_equipment"); if (!IsEquipment) Ship = rMasterInfo.Ships[rMasterID]; else Equipment = rMasterInfo.Equipment[rMasterID]; Level = rpReader.GetInt32("level"); Proficiency = rpReader.GetInt32("proficiency"); Fate = (Fate)rpReader.GetInt32("fate"); }
internal ConstructionRecord(SQLiteDataReader rpReader) { ID = rpReader.GetInt64("time"); Ship = KanColleGame.Current.MasterInfo.Ships[rpReader.GetInt32("ship")]; FuelConsumption = rpReader.GetInt32("fuel"); BulletConsumption = rpReader.GetInt32("bullet"); SteelConsumption = rpReader.GetInt32("steel"); BauxiteConsumption = rpReader.GetInt32("bauxite"); DevelopmentMaterialConsumption = rpReader.GetInt32("dev_material"); SecretaryShip = KanColleGame.Current.MasterInfo.Ships[rpReader.GetInt32("flagship")]; HeadquarterLevel = rpReader.GetInt32("hq_level"); EmptyDockCount = rpReader.GetInt32Optional("empty_dock"); }
internal SortieConsumptionRecord(SQLiteDataReader rpReader) : base(rpReader) { ID = rpReader.GetInt64("id"); var rMapMaxHP = rpReader.GetInt32Optional("map_max_hp"); if (rMapMaxHP.HasValue) { var rMapHP = rpReader.GetInt32Optional("map_hp"); if (rMapHP.HasValue) MapHP = new ClampedValue(rMapMaxHP.Value, rMapHP.Value); } Fuel = rpReader.GetInt32("fuel"); Bullet = rpReader.GetInt32("bullet"); Steel = rpReader.GetInt32("steel"); Bauxite = rpReader.GetInt32("bauxite"); Bucket = rpReader.GetInt32("bucket"); RankingPoint = rpReader.GetDoubleOptional("ranking_point"); }
internal DbChannel(SQLiteDataReader r, IDictionary<string, int> field, DataRoot dataRoot, Dictionary<long, string> providers, Satellite sat, Transponder tp) { var chType = r.GetInt32(field["chType"]); this.SignalSource = DbSerializer.ChTypeToSignalSource(chType); this.RecordIndex = r.GetInt64(field["SRV.srvId"]); this.OldProgramNr = r.GetInt32(field["major"]); this.FreqInMhz = (decimal)r.GetInt32(field["freq"]) / 1000; this.ChannelOrTransponder = (this.SignalSource & SignalSource.DvbT) == SignalSource.DvbT ? LookupData.Instance.GetDvbtTransponder(this.FreqInMhz).ToString() : (this.SignalSource & SignalSource.DvbC) == SignalSource.DvbC ? LookupData.Instance.GetDvbcTransponder(this.FreqInMhz).ToString() : (this.SignalSource & SignalSource.Sat) == SignalSource.DvbS ? LookupData.Instance.GetAstraTransponder((int)this.FreqInMhz).ToString() : ""; this.Name = DbSerializer.ReadUtf16(r, 6); this.Hidden = r.GetBoolean(field["hidden"]); this.Encrypted = r.GetBoolean(field["scrambled"]); this.Lock = r.GetBoolean(field["lockMode"]); this.Skip = !r.GetBoolean(field["numSel"]); if (sat != null) { this.Satellite = sat.Name; this.SatPosition = sat.OrbitalPosition; } if (tp != null) { this.Transponder = tp; this.SymbolRate = tp.SymbolRate; } if ((this.SignalSource & SignalSource.Digital) != 0) this.ReadDvbData(r, field, dataRoot, providers); else this.ReadAnalogData(r, field); base.IsDeleted = this.OldProgramNr == -1; }
public static void ReadValue(SQLiteDataReader reader, int index, TypeStorage type, ICdlValueWriter writer) { switch (type) { case TypeStorage.Boolean: writer.SetBoolean(reader.GetInt32(index) != 0); break; case TypeStorage.Byte: writer.SetByte((byte) reader.GetInt32(index)); break; case TypeStorage.Int16: writer.SetInt16((short) reader.GetInt32(index)); break; case TypeStorage.Int32: writer.SetInt32((int) reader.GetInt32(index)); break; case TypeStorage.Int64: writer.SetInt64((long) reader.GetInt64(index)); break; case TypeStorage.SByte: writer.SetSByte((sbyte) reader.GetInt32(index)); break; case TypeStorage.UInt16: writer.SetUInt16((ushort) reader.GetInt32(index)); break; case TypeStorage.UInt32: writer.SetUInt32((uint) reader.GetInt32(index)); break; case TypeStorage.UInt64: writer.SetUInt64((ulong) reader.GetInt64(index)); break; case TypeStorage.DateTime: writer.SetDateTime(DateTime.Parse(reader.GetString(index), CultureInfo.InvariantCulture)); //writer.SetDateTime(DateTime.ParseExact(reader.GetString(index), "s", CultureInfo.InvariantCulture)); break; case TypeStorage.DateTimeEx: writer.SetDateTimeEx(DateTimeEx.ParseNormalized(reader.GetString(index))); break; case TypeStorage.DateEx: writer.SetDateEx(DateEx.ParseNormalized(reader.GetString(index))); break; case TypeStorage.TimeEx: writer.SetTimeEx(TimeEx.ParseNormalized(reader.GetString(index))); break; case TypeStorage.Decimal: { var dtype = reader.GetFieldType(index); decimal value; if (dtype == typeof (string)) { value = Decimal.Parse(reader.GetString(index), CultureInfo.InvariantCulture); } else { value = (decimal) reader.GetDouble(index); } writer.SetDecimal(value); } break; case TypeStorage.Float: writer.SetFloat((float) reader.GetDouble(index)); break; case TypeStorage.Double: writer.SetDouble((double) reader.GetDouble(index)); break; case TypeStorage.String: writer.SetString(reader.GetString(index)); break; case TypeStorage.Guid: writer.SetGuid(new Guid(reader.GetString(index))); break; case TypeStorage.ByteArray: writer.SetByteArray((byte[]) reader.GetValue(index)); break; case TypeStorage.Null: writer.SetNull(); break; default: throw new Exception("DBSH-00167 Unsupported field type:" + type.ToString()); } }
static Card ReadCard(SQLiteDataReader reader,bool reNewLine) { Card c = new Card(0); c.id = reader.GetInt64(reader.GetOrdinal("id")); c.ot = reader.GetInt32(reader.GetOrdinal("ot")); c.alias = reader.GetInt64(reader.GetOrdinal("alias")); c.setcode = reader.GetInt64(reader.GetOrdinal("setcode")); c.type = reader.GetInt64(reader.GetOrdinal("type")); c.atk = reader.GetInt32(reader.GetOrdinal("atk")); c.def = reader.GetInt32(reader.GetOrdinal("def")); c.level = reader.GetInt64(reader.GetOrdinal("level")); c.race = reader.GetInt64(reader.GetOrdinal("race")); c.attribute = reader.GetInt32(reader.GetOrdinal("attribute")); c.category = reader.GetInt64(reader.GetOrdinal("category")); c.name = reader.GetString(reader.GetOrdinal("name")); c.desc = reader.GetString(reader.GetOrdinal("desc")); if(reNewLine) c.desc=Retext(c.desc); string temp = null; for ( int i = 0; i < 0x10; i++ ) { temp = reader.GetString(reader.GetOrdinal("str"+(i+1).ToString())); c.Str[i]= ( temp == null ) ? "":temp; } return c; }
private static void MapDataReaderToUrlDto(SQLiteDataReader dataReader, out UrlDto urlDto) { urlDto = new UrlDto(); urlDto.UrlId = dataReader.GetInt64((int)UrlsField.UrlId); urlDto.Url = dataReader.GetString((int)UrlsField.Url); urlDto.Url = HttpUtility.UrlDecode(urlDto.Url); urlDto.Status = (HttpStatusCode) dataReader.GetInt32((int)UrlsField.Status); urlDto.IsWebPage = dataReader.GetInt32((int)UrlsField.IsWebPage) > 0; }
private long ReadOneInt64(SQLiteDataReader reader) { return reader.GetInt64(0); }
private CrashReport MakeCrashReport(SQLiteDataReader reader) { Guid g = reader.GetGuid(0); //Guid.Parse(reader.GetString(0))); long l = reader.GetInt64(1); string s1 = reader.GetString(2); string s2 = reader.GetString(3); string s3 = reader.GetString(4); string s4 = reader.GetString(5); Version v = Version.Parse(reader.GetString(6)); string s6 = reader.GetValue(7) as string; //Not GetString as GetString throws an invalidCast string s7 = reader.GetValue(8) as string; //(or another exception, cannot rmbr) string userstory = reader.GetValue(9) as string; //If the value is null, and this and following fields string trace = reader.GetValue(10) as string; //can be null as they aren't set before zip is downloaded return new CrashReport(innerApi, g, l, s1, s2, s3, s4, v, s6, s7, trace, userstory); }
private Tuple<long, Tag> ReadInt64AndTag(SQLiteDataReader reader) { return new Tuple<long, Tag>(reader.GetInt64(0), new Tag(reader.GetString(1), reader.GetString(2))); }
private RelationMember ReadRelationMember(SQLiteDataReader reader) { var relation_member = new RelationMember(); relation_member.MemberType = SchemaTools.ConvertMemberType(reader.GetInt16(0)); relation_member.MemberId = reader.GetInt64(1); relation_member.MemberRole = reader.GetString(2); return relation_member; }
private Tuple<long, long> ReadTwoInt64s(SQLiteDataReader reader) { return new Tuple<long, long>(reader.GetInt64(0), reader.GetInt64(1)); }
private Tuple<long, RelationMember> ReadRelationIdAndMember(SQLiteDataReader reader) { var relation_member = new RelationMember(); relation_member.MemberType = SchemaTools.ConvertMemberType(reader.GetInt16(1)); relation_member.MemberId = reader.GetInt64(2); relation_member.MemberRole = reader.GetString(3); return new Tuple<long, RelationMember>(reader.GetInt64(0), relation_member); }
private Relation ReadRelation(SQLiteDataReader reader) { var relation = new Relation(); relation.Id = reader.GetInt64(0); // evaluate name if (!reader.IsDBNull(1)) { var name = reader.GetString(1); EvaluateName(name, relation); } return relation; }
private Tuple<long, int> ReadOneInt64OneInt32(SQLiteDataReader reader) { return new Tuple<long, int>(reader.GetInt64(0), reader.GetInt32(1)); }
private static Item createItem(SQLiteDataReader reader) { SQLiteCommand command; if (!reader.Read()) { return null; } Item item = new Item(); item.permanent = true; item.id = reader.GetInt32(0); item.displayname = reader.GetString(1); item.actual_value = reader.IsDBNull(2) ? DATABASE_NULL : reader.GetInt64(2); item.vendor_value = reader.IsDBNull(3) ? DATABASE_NULL : reader.GetInt64(3); item.stackable = reader.GetBoolean(4); item.capacity = reader.IsDBNull(5) ? DATABASE_NULL : reader.GetFloat(5); item.category = reader.IsDBNull(6) ? "Unknown" : reader.GetString(6); item.discard = reader.GetBoolean(7); item.convert_to_gold = reader.GetBoolean(8); item.look_text = reader.IsDBNull(9) ? String.Format("You see a {0}.", item.displayname) : reader.GetString(9); item.title = reader.GetString(10); item.currency = reader.IsDBNull(11) ? DATABASE_NULL : reader.GetInt32(11); item.image = Image.FromStream(reader.GetStream(12)); if (item.image.RawFormat.Guid == ImageFormat.Gif.Guid) { int frames = item.image.GetFrameCount(FrameDimension.Time); if (frames == 1) { Bitmap new_bitmap = new Bitmap(item.image); new_bitmap.MakeTransparent(); item.image.Dispose(); item.image = new_bitmap; } } command = new SQLiteCommand(String.Format("SELECT vendorid, value FROM SellItems WHERE itemid={0}", item.id), mainForm.conn); reader = command.ExecuteReader(); while (reader.Read()) { ItemSold sellItem = new ItemSold(); sellItem.itemid = item.id; sellItem.npcid = reader.GetInt32(0); sellItem.price = reader.GetInt32(1); item.sellItems.Add(sellItem); } command = new SQLiteCommand(String.Format("SELECT vendorid, value FROM BuyItems WHERE itemid={0}", item.id), mainForm.conn); reader = command.ExecuteReader(); while (reader.Read()) { ItemSold buyItem = new ItemSold(); buyItem.itemid = item.id; buyItem.npcid = reader.GetInt32(0); buyItem.price = reader.GetInt32(1); item.buyItems.Add(buyItem); } command = new SQLiteCommand(String.Format("SELECT creatureid, percentage, min, max FROM CreatureDrops WHERE itemid={0}", item.id), mainForm.conn); reader = command.ExecuteReader(); while (reader.Read()) { ItemDrop itemDrop = new ItemDrop(); itemDrop.itemid = item.id; itemDrop.creatureid = reader.GetInt32(0); itemDrop.percentage = reader.IsDBNull(1) ? DATABASE_NULL : reader.GetFloat(1); if (itemDrop.percentage > 100) { itemDrop.min = 1; itemDrop.max = (int)(itemDrop.percentage / 100.0 * 2.0); itemDrop.percentage = 100; } else { itemDrop.min = Math.Max(reader.GetInt32(2), 1); itemDrop.max = Math.Max(reader.GetInt32(3), itemDrop.min); } item.itemdrops.Add(itemDrop); } command = new SQLiteCommand(String.Format("SELECT questid FROM QuestRewards WHERE itemid={0}", item.id), mainForm.conn); reader = command.ExecuteReader(); while (reader.Read()) { item.rewardedBy.Add(getQuest(reader.GetInt32(0))); } command = new SQLiteCommand(String.Format("SELECT property, value FROM ItemProperties WHERE itemid={0}", item.id), mainForm.conn); reader = command.ExecuteReader(); while (reader.Read()) { string property = reader.GetString(0); switch(property) { case "Voc": item.vocation = reader.GetString(1); break; case "Level": item.level = reader.GetInt32(1); break; case "Def": item.defensestr = reader["value"].ToString(); if (!int.TryParse(item.defensestr, out item.defense)) { item.defense = int.Parse(item.defensestr.Split(' ')[0]); } break; case "Attrib": item.attrib = reader.GetString(1); break; case "Atk": item.attack = reader.GetInt32(1); break; case "Atk+": item.atkmod = reader.GetInt32(1); break; case "Hit+": string str = reader["value"].ToString(); int.TryParse(str, out item.hitmod); break; case "Arm": item.armor = reader.GetInt32(1); break; case "Range": item.range = reader.GetInt32(1); break; case "Type": item.type = reader.GetString(1); break; } } return item; }
private AccountBalance BuildBalanceStructure(SQLiteDataReader reader) { long balance = reader.GetInt64(0); DateTime lastUpdated = DateTime.Parse(reader.GetString(1)); return new AccountBalance(balance, lastUpdated); }
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))); }
private Account BuildStructure(SQLiteDataReader reader) { long accountId = reader.GetInt64(0); string currency = reader.GetString(1); long ownerPersonId = reader.GetInt64(2); string name = reader.GetString(3); AccountType type = AccountTypeHelper.AccountTypeFromString(reader.GetString(4)); return new Account(accountId, currency, ownerPersonId, name, type); }
private DataTable convertToDataTable(SQLiteDataReader reader) { DataTable table = new DataTable(); DataTable dtb = new DataTable(); table = reader.GetSchemaTable(); for (int x = 0; x < table.Rows.Count; x++) { string colNome = table.Rows[x]["ColumnName"].ToString(); dtb.Columns.Add(colNome, typeof(string)); } dtb.AcceptChanges(); while (reader.Read()) { DataRow dr = dtb.NewRow(); for (int i = 0; i < table.Rows.Count; i++) { string colNome = table.Rows[i]["ColumnName"].ToString(); string colType = table.Rows[i]["DataTypeName"].ToString(); string valor = string.Empty; if (colType.ToUpper().Equals("NUMBER") || colType.ToUpper().Equals("INT") || colType.ToUpper().Equals("INTERGER")) { try { long Lvalor = reader.GetInt64(i); if (Lvalor != null) valor = Lvalor.ToString(); } catch (InvalidCastException inv) { valor = string.Empty; } } else if (colType.ToUpper().Equals("VARCHAR2") || colType.ToUpper().Equals("VARCHAR") || colType.ToUpper().Equals("TEXT")) valor = reader.GetString(i).ToString(); dr[colNome] = valor; } dtb.Rows.Add(dr); } dtb.AcceptChanges(); return dtb; }
private UnspentOutput ReadUnspentOutput(SQLiteDataReader reader) { int col = 0; int sourceBlockHeight = reader.GetInt32(col++); byte[] transactionHash = ReadBytes(reader, col++); int outputNumber = reader.GetInt32(col++); ulong sum = (ulong) reader.GetInt64(col++); byte[] publicScript = ReadBytes(reader, col++); return new UnspentOutput(sourceBlockHeight, transactionHash, outputNumber, sum, publicScript); }
private Way ReadWay(SQLiteDataReader reader) { var way = new Way(); way.Id = reader.GetInt64(0); // evaluate name if (!reader.IsDBNull(1)) { var name = reader.GetString(1); EvaluateName(name, way); } return way; }
private Node ReadNode(SQLiteDataReader reader) { var node = new Node(); node.Id = reader.GetInt64(0); node.Latitude = SQLiteSchemaTools.DBToGeo(reader.GetInt32(1)); node.Longitude = SQLiteSchemaTools.DBToGeo(reader.GetInt32(2)); // evaluate name if (!reader.IsDBNull(3)) { var name = reader.GetString(3); EvaluateName(name, node); } return node; }