/* Returns a Set using a SQLiteDataReader and a dictionary mapping the attributes to a index.
*/
private Set SetExtractor(SQLiteDataReader reader, Dictionary<string, int> attributeIndexDict)
{
return new Set(reader.GetInt32(attributeIndexDict["day"]), reader.GetInt32(attributeIndexDict["month"]),
reader.GetInt32(attributeIndexDict["year"]), reader.GetInt32(attributeIndexDict["setSeqNum"]),
reader.GetInt32(attributeIndexDict["activityId"]), reader.GetDouble(attributeIndexDict["weight"]),
reader.GetInt32(attributeIndexDict["secs"]), reader.GetInt32(attributeIndexDict["reps"]));
}
protected override Exemplar InitEntryByReader(System.Data.SQLite.SQLiteDataReader reader)
{
Exemplar exemplar = new Exemplar();
ulong id = System.Convert.ToUInt64(reader.GetInt32(reader.GetOrdinal("id")));
string loanPeriodAsString = reader.GetString(reader.GetOrdinal("loanPeriod"));
DateTime loanPeriod = new DateTime();
if (loanPeriodAsString != null || loanPeriodAsString != "")
{
loanPeriod = DateTime.Parse(loanPeriodAsString);
}
string stateString = reader.GetString(reader.GetOrdinal("state"));
BookStates state = (BookStates)Enum.Parse(typeof(BookStates), stateString, true);
string signatur = reader.GetString(reader.GetOrdinal("signatur"));
ulong customerId = System.Convert.ToUInt64(reader.GetInt32(reader.GetOrdinal("customerID")));
ulong bookId = System.Convert.ToUInt64(reader.GetInt32(reader.GetOrdinal("bookID")));
exemplar.ExemplarId = id;
exemplar.LoanPeriod = loanPeriod;
exemplar.State = state;
exemplar.Signatur = signatur;
exemplar.BookId = bookId;
return(exemplar);
}
internal DbChannel(SignalSource source, SQLiteDataReader r, IDictionary<string, int> field,
DataRoot dataRoot, IDictionary<string,bool> encryptionInfo)
{
this.SignalSource = source;
this.RecordIndex = r.GetInt32(field["channel_handle"]);
this.Bits = r.GetInt32(field["list_bits"]);
bool isTv = (Bits & BITS_Tv) != 0;
bool isRadio = (Bits & BITS_Radio) != 0;
bool isAnalog = (source & SignalSource.Analog) != 0;
if (isAnalog && !isTv)
{
this.IsDeleted = true;
return;
}
if (isTv) this.SignalSource |= SignalSource.Tv;
if (isRadio) this.SignalSource |= SignalSource.Radio;
this.Lock = (Bits & BITS_Locked) != 0;
this.OldProgramNr = r.GetInt32(field["channel_number"]);
this.Favorites = this.ParseFavorites(Bits);
if (isAnalog)
this.ReadAnalogData(r, field);
else
this.ReadDvbData(r, field, dataRoot, encryptionInfo);
}
public Report()
{
InitializeComponent();
// Connect to database file
sql_con = new SQLiteConnection("Data Source=" + applicationPath + "\\ExpenseTracker.db;Version=3;New=False;Compress=True;");
sql_cmd = new SQLiteCommand();
sql_con.Open();
sql_cmd.Connection = sql_con;
sql_cmd.CommandText = "SELECT * FROM Month";
sql_reader = sql_cmd.ExecuteReader();
while (sql_reader.Read())
{
dataGridView.Rows.Add(
sql_reader.GetInt32(0),
CustomDate.GetThaiMonth(sql_reader.GetInt32(1)),
sql_reader.GetDecimal(2).ToString("#,#0.00#"),
sql_reader.GetDecimal(3).ToString("#,#0.00#"),
sql_reader.GetDecimal(4).ToString("#,#0.00#")
);
}
sql_reader.Close();
dataGridView.ClearSelection();
}
/* Returns a Activity using a SQLiteDataReader and a dictionary mapping the attributes to a index.
*/
private Activity ActivityExtractor(SQLiteDataReader reader, Dictionary<string, int> attributeIndexDict)
{
return new Activity(reader.GetInt32(attributeIndexDict["activityId"]),
reader.GetInt32(attributeIndexDict["seqNum"]), reader.GetString(attributeIndexDict["workoutName"]),
reader.GetInt32(attributeIndexDict["numSets"]), reader.GetInt32(attributeIndexDict["workoutVersion"]),
reader.GetString(attributeIndexDict["exerciseName"]), reader.GetInt32(attributeIndexDict["exerciseVersion"]));
}
protected void ReadDvbData(SQLiteDataReader r, IDictionary<string, int> field, DataRoot dataRoot,
IDictionary<string, bool> encryptionInfo)
{
string longName, shortName;
this.GetChannelNames(r.GetString(field["channel_label"]), out longName, out shortName);
this.Name = longName;
this.ShortName = shortName;
this.RecordOrder = r.GetInt32(field["channel_order"]);
this.FreqInMhz = (decimal)r.GetInt32(field["frequency"]) / 1000;
int serviceType = r.GetInt32(field["dvb_service_type"]);
this.ServiceType = serviceType;
this.OriginalNetworkId = r.GetInt32(field["onid"]);
this.TransportStreamId = r.GetInt32(field["tsid"]);
this.ServiceId = r.GetInt32(field["sid"]);
int bits = r.GetInt32(field["list_bits"]);
this.Favorites = this.ParseFavorites(bits);
if ((this.SignalSource & SignalSource.Sat) != 0)
{
int satId = r.GetInt32(field["sat_id"]);
var sat = dataRoot.Satellites.TryGet(satId);
if (sat != null)
{
this.Satellite = sat.Name;
this.SatPosition = sat.OrbitalPosition;
int tpId = satId * 1000000 + (int)this.FreqInMhz;
var tp = dataRoot.Transponder.TryGet(tpId);
if (tp != null)
{
this.SymbolRate = tp.SymbolRate;
}
}
}
this.Encrypted = encryptionInfo.TryGet(this.Uid);
}
private int findNOCert()
{
try
{
using (System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection("data source=gestionalePalestra.db"))
{
using (System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(conn))
{
conn.Open();
string command = "SELECT count(*) FROM Certificato WHERE Presente='NO';";
cmd.CommandText = command;
using (System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
return(reader.GetInt32(0)); //ritorna la prima colonna, quella avente il count
}
}
conn.Close();
}
}
return(0);
}
catch
{
return(-1);
}
}
private int findNextToPay()
{
try
{
using (System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection("data source=gestionalePalestra.db"))
{
using (System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(conn))
{
conn.Open();
string command = "SELECT count(*) FROM Rata WHERE DATE(DataPagam) <= DATE('now','+'||14||' days') and DATE(DataPagam) >= DATE('now') and (PagamentoAvv='NO')";
cmd.CommandText = command;
using (System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
return(reader.GetInt32(0)); //ritorna la prima colonna, quella avente il count
}
}
conn.Close();
}
}
return(0);
}
catch
{
return(-1);
}
}
public string printToConsole(SQLiteDataReader readerDB, int index)
{
if (readerDB.IsDBNull(index))
{
//return "NULL";
return "";
}
else
{
String dataObject = readerDB.GetFieldType(index).ToString();
switch (dataObject)
{
case "System.Int32":
return readerDB.GetInt32(index).ToString();
case "System.DateTime":
DateTime date = readerDB.GetDateTime(index);
return Convert.ToString(date);
case "System.String":
return readerDB.GetString(index);
default:
return "Unknown";
}
}
}
public ICollection <IFinancialProduct> UpdateTheListView(ICollection <IFinancialProduct> listProducts)
{
try
{
connection.Open();
cmd = new System.Data.SQLite.SQLiteCommand(connection);
//cmd.Prepare();
//connection.CreateTable<Stock>();
//connection.CreateTable<Fund>();
cmd.CommandText = "SELECT * FROM Stock";
try
{
allRead = cmd.ExecuteReader();
while (allRead.Read())
{
listProducts.Add(new Stock(allRead.GetInt32(0), allRead.GetString(1), allRead.GetString(2), allRead.GetString(3)));
//listProducts.Add(new Stock((int)allRead["Id"], (string)allRead["categoria"], (string)allRead["name"], (string)allRead["code"])); //Isso não converte.
}
}
catch (Exception e)
{
MessageBox.Show("Erro ao montar a lista de ações: " + e.Message);
return(null);
}
cmd = new System.Data.SQLite.SQLiteCommand(connection);
//cmd.Prepare();
//connection.CreateTable<Stock>();
//connection.CreateTable<Fund>();
cmd.CommandText = "SELECT * FROM Fund";
try
{
allRead = cmd.ExecuteReader();
while (allRead.Read())
{
listProducts.Add(new Fund(allRead.GetInt32(0), allRead.GetString(1), allRead.GetString(2), allRead.GetString(3), allRead.GetString(4)));
//listProducts.Add(new Fund(
//(int)allRead["Id"],
//(string)allRead["categoria"],
//(string)allRead["name"],
//(string)allRead["code"])); //Isso não converte.
}
}
catch (Exception e)
{
MessageBox.Show("Erro ao montar a lista de Fundos: " + e.Message);
return(null);
}
}
catch (Exception e)
{
MessageBox.Show("Erro ao acessar Banco de Dados: " + e);
return(null);
}
finally
{
connection.Close();
}
return(listProducts);
}
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");
}
public SortieStatisticData(SQLiteDataReader rpReader) : base(rpReader)
{
Count = rpReader.GetInt32("count");
FuelConsumption = rpReader.GetInt32("fuel_consumption");
BulletConsumption = rpReader.GetInt32("bullet_consumption");
SteelConsumption = rpReader.GetInt32("steel_consumption");
BauxiteConsumption = rpReader.GetInt32("bauxite_consumption");
BucketConsumption = rpReader.GetInt32("bucket_consumption");
RankingPoint = rpReader.GetDouble("ranking_point");
SRankCount = rpReader.GetInt32("s_rank_count");
ARankCount = rpReader.GetInt32("a_rank_count");
BRankCount = rpReader.GetInt32("b_rank_count");
FailureRankCount = rpReader.GetInt32("failure_rank_count");
}
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");
}
private TranslationMemory ReadTranslationMemory(SQLiteDataReader reader)
{
TranslationMemory tm = new TranslationMemory();
tm.tmid = reader.GetInt32(0); // tmid used for update
tm.japanese = GetSegmentFromXml(reader.GetString(4)); // source_segment
tm.chinese = GetSegmentFromXml(reader.GetString(6)); // target_segment
tm.tags += reader.GetString(8) + Environment.NewLine; // user
tm.tags += reader.GetString(9) + Environment.NewLine; // date
tm.tmname = Path.GetFileName(this.sourcePath);
return tm;
}
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");
}
public SortieRecordBase(SQLiteDataReader rpReader)
{
var rMapID = rpReader.GetInt32("map");
Map = MapService.Instance.GetMasterInfo(rMapID);
var rEventMapDifficulty = rpReader.GetInt32Optional("difficulty");
if (rEventMapDifficulty.HasValue)
{
IsEventMap = true;
EventMapDifficulty = (EventMapDifficulty)rEventMapDifficulty.Value;
}
}
private void ParseFavorites(SQLiteDataReader r, IDictionary<string, int> field)
{
for (int i = 0; i < 4; i++)
{
int favIndex = r.GetInt32(field["profile" + (i + 1) + "index"]);
if (favIndex > 0)
{
this.Favorites |= (Favorites) (1 << i);
this.FavIndex[i] = favIndex;
}
}
}
protected void ReadDvbData(SQLiteDataReader r, IDictionary<string, int> field, DataRoot dataRoot, byte[] delivery)
{
int stype = r.GetInt32(field["stype"]);
this.SignalSource |= LookupData.Instance.IsRadioOrTv(stype);
this.ServiceType = stype;
int freq = r.GetInt32(field["freq"]);
if ((this.SignalSource & SignalSource.Sat) != 0)
{
// ReSharper disable PossibleLossOfFraction
this.FreqInMhz = freq/10;
// ReSharper restore PossibleLossOfFraction
int satId = r.GetInt32(field["physical_ch"]) >> 12;
var sat = dataRoot.Satellites.TryGet(satId);
if (sat != null)
{
this.Satellite = sat.Name;
this.SatPosition = sat.OrbitalPosition;
}
if (delivery.Length >= 7)
{
this.SymbolRate = (delivery[5] >> 4)*10000 + (delivery[5] & 0x0F)*1000 +
(delivery[6] >> 4)*100 + (delivery[6] & 0x0F)*10;
}
}
else
{
freq /= 1000;
this.FreqInMhz = freq;
this.ChannelOrTransponder = (this.SignalSource & SignalSource.Antenna) != 0 ?
LookupData.Instance.GetDvbtTransponder(freq).ToString() :
LookupData.Instance.GetDvbcTransponder(freq).ToString();
this.Satellite = (this.SignalSource & SignalSource.Antenna) != 0 ? "DVB-T" : "DVB-C";
}
this.OriginalNetworkId = r.GetInt32(field["onid"]);
this.TransportStreamId = r.GetInt32(field["tsid"]);
this.ServiceId = r.GetInt32(field["sid"]);
}
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;
}
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");
}
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"]));
this.AddDebug(r.GetInt32(field["lcn"]).ToString());
}
public void CreateChart(ZedGraphControl zgc)
{
GraphPane myPane = zgc.GraphPane;
PointPairList lstIncome = new PointPairList();
PointPairList lstExpense = new PointPairList();
// Set the title and axis labels
myPane.Title.FontSpec.Family = "Browallia New";
myPane.Title.FontSpec.Size = 24;
myPane.Title.Text = "สรุป";
myPane.XAxis.Title.FontSpec.Family = "Browallia New";
myPane.XAxis.Title.FontSpec.Size = 16;
myPane.XAxis.Title.Text = "เดือน";
myPane.XAxis.Type = AxisType.Text;
myPane.YAxis.Title.FontSpec.Family = "Browallia New";
myPane.YAxis.Title.FontSpec.Size = 24;
myPane.YAxis.Title.Text = "จำนวนเงิน";
// Load data for this month
sql_cmd.CommandText = "SELECT Month, TotalIncome, TotalExpense FROM Month WHERE Year = '" + CustomDate.GetThaiYear(DateTime.Today.Year) + "'";
sql_reader = sql_cmd.ExecuteReader();
while (sql_reader.Read())
{
monthsLabel.Add(CustomDate.GetThaiMonth(sql_reader.GetInt32(0)));
lstIncome.Add(0, sql_reader.GetDouble(1));
lstExpense.Add(0, sql_reader.GetDouble(2));
}
sql_reader.Close();
myPane.XAxis.Scale.FontSpec.Family = "Browallia New";
myPane.XAxis.Scale.FontSpec.Size = 16;
myPane.XAxis.Scale.TextLabels = monthsLabel.ToArray();
BarItem myCurve = myPane.AddBar("รายรับ", lstIncome, Color.Blue);
BarItem myCurve2 = myPane.AddBar("รายจ่าย", lstExpense, Color.Red);
myPane.Chart.Fill = new Fill(Color.White, Color.FromArgb(255, 255, 166), 45.0F);
myPane.YAxis.Scale.Max += myPane.YAxis.Scale.MajorStep;
//BarItem.CreateBarLabels(myPane, false, "#,#0.00#", "Tahoma", 10, Color.Black, true, false, false);
zgc.AxisChange();
}
internal DbChannel(SQLiteDataReader r, IDictionary<string, int> field, DataRoot dataRoot, Encoding encoding)
{
this.RecordIndex = r.GetInt32(field["rowid"]);
this.RecordOrder = r.GetInt32(field["major_channel"]);
this.OldProgramNr = r.GetInt32(field["major_channel"]);
int ntype = r.GetInt32(field["ntype"]);
if (ntype == 1)
{
this.SignalSource |= SignalSource.DvbS;
if (r.GetInt32(field["ya_svcid"]) >= 0)
this.SignalSource |= SignalSource.Freesat;
}
else if (ntype == 2)
this.SignalSource |= SignalSource.DvbT;
else if (ntype == 3)
this.SignalSource |= SignalSource.DvbC;
else if (ntype == 10)
this.SignalSource |= SignalSource.AnalogT | SignalSource.Tv;
else if (ntype == 14)
this.SignalSource |= SignalSource.AnalogC | SignalSource.Tv;
else if (ntype == 15)
this.SignalSource |= SignalSource.SatIP;
byte[] buffer = new byte[1000];
var len = r.GetBytes(field["delivery"], 0, buffer, 0, 1000);
this.AddDebug(buffer, 0, (int) len);
this.Skip = r.GetInt32(field["skip"]) != 0;
this.Encrypted = r.GetInt32(field["free_CA_mode"]) != 0;
this.Lock = r.GetInt32(field["child_lock"]) != 0;
this.ParseFavorites(r, field);
this.ReadNamesWithEncodingDetection(r, field, encoding);
if (ntype == 10 || ntype == 14)
this.ReadAnalogData(r, field);
else
this.ReadDvbData(r, field, dataRoot, buffer);
}
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");
}
/// <summary>
/// 读取权限列表
/// </summary>
/// <returns>权限列表的name与权限</returns>
public List <Tuple <string, int> > ReadAuthorityTable()
{
try
{
using (var conn = new System.Data.SQLite.SQLiteConnection())
{
var connstr = new SQLiteConnectionStringBuilder();
connstr.DataSource = datasource;
//connstr.Password = "******";//设置密码，SQLite ADO.NET实现了数据库密码保护
conn.ConnectionString = connstr.ToString();
conn.Open();
using (SQLiteCommand cmd = new SQLiteCommand())
{
var collect = new List <Tuple <string, int> >();
cmd.Connection = conn;
string sql = "SELECT * from control_authority";
cmd.CommandText = sql;
System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
collect.Add(new Tuple <string, int>(reader.GetString(0), reader.GetInt32(1)));
}
conn.Close();
return(collect);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private static HuntingPlace createHunt(SQLiteDataReader reader)
{
SQLiteCommand command;
if (!reader.Read()) {
return null;
}
HuntingPlace huntingPlace = new HuntingPlace();
huntingPlace.permanent = true;
huntingPlace.id = reader.GetInt32(0);
huntingPlace.name = reader["name"].ToString();
huntingPlace.level = reader.IsDBNull(2) ? DATABASE_NULL : reader.GetInt32(2);
huntingPlace.exp_quality = reader.IsDBNull(3) ? DATABASE_NULL : reader.GetInt32(3);
huntingPlace.loot_quality = reader.IsDBNull(4) ? DATABASE_NULL : reader.GetInt32(4);
string imageName = reader.GetString(5).ToLower();
Creature cr = getCreature(imageName);
if (cr != null) {
huntingPlace.image = cr.GetImage();
} else {
NPC npc = getNPC(imageName);
if (npc != null) {
huntingPlace.image = npc.GetImage();
} else {
throw new Exception("Unrecognized npc or creature image.");
}
}
huntingPlace.city = reader["city"].ToString();
// Hunting place coordinates
command = new SQLiteCommand(String.Format("SELECT x, y, z FROM HuntingPlaceCoordinates WHERE huntingplaceid={0}", huntingPlace.id), mainForm.conn);
reader = command.ExecuteReader();
while (reader.Read()) {
Coordinate c = new Coordinate();
c.x = reader.IsDBNull(0) ? DATABASE_NULL : reader.GetInt32(0);
c.y = reader.IsDBNull(1) ? DATABASE_NULL : reader.GetInt32(1);
c.z = reader.IsDBNull(2) ? DATABASE_NULL : reader.GetInt32(2);
huntingPlace.coordinates.Add(c);
}
// Hunting place directions
command = new SQLiteCommand(String.Format("SELECT beginx, beginy, beginz,endx, endy, endz, ordering, description, settings FROM HuntDirections WHERE huntingplaceid={0} ORDER BY ordering", huntingPlace.id), mainForm.conn);
reader = command.ExecuteReader();
while (reader.Read()) {
Directions d = new Directions();
d.huntingplaceid = huntingPlace.id;
d.begin = new Coordinate(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2));
d.end = new Coordinate(reader.GetInt32(3), reader.GetInt32(4), reader.GetInt32(5));
d.ordering = reader.GetInt32(6);
d.description = reader["description"].ToString();
d.settings = reader.GetString(8);
huntingPlace.directions.Add(d);
}
// Hunting place creatures
command = new SQLiteCommand(String.Format("SELECT creatureid FROM HuntingPlaceCreatures WHERE huntingplaceid={0}", huntingPlace.id), mainForm.conn);
reader = command.ExecuteReader();
while (reader.Read()) {
int creatureid = reader.GetInt32(0);
huntingPlace.creatures.Add(creatureid);
}
// Hunting place requirements
command = new SQLiteCommand(String.Format("SELECT questid, requirementtext FROM HuntRequirements WHERE huntingplaceid={0}", huntingPlace.id), mainForm.conn);
reader = command.ExecuteReader();
while (reader.Read()) {
Requirements r = new Requirements();
r.huntingplaceid = huntingPlace.id;
int questid = reader.IsDBNull(0) ? DATABASE_NULL : reader.GetInt32(0);
r.quest = questIdMap[questid];
r.notes = reader["requirementtext"].ToString();
huntingPlace.requirements.Add(r);
}
return huntingPlace;
}
/* Returns an Exercise using a SQLiteDataReader and a dictionary mapping the attributes to a index.
*/
private Date DateExtractor(SQLiteDataReader reader, Dictionary<string, int> attributeIndexDict)
{
return new Date(reader.GetInt32(attributeIndexDict["day"]),
reader.GetInt32(attributeIndexDict["month"]), reader.GetInt32(attributeIndexDict["year"]),
reader.GetString(attributeIndexDict["workoutName"]), reader.GetInt32(attributeIndexDict["workoutVersion"]),
reader.GetString(attributeIndexDict["comments"]));
}
/* Returns an Exercise using a SQLiteDataReader and a dictionary mapping the attributes to a index.
*/
private Exercise ExerciseExtractor(SQLiteDataReader reader, Dictionary<string, int> attributeIndexDict)
{
return new Exercise(reader.GetString(attributeIndexDict["exerciseName"]),
reader.GetString(attributeIndexDict["format"]), reader.GetInt32(attributeIndexDict["exerciseVersion"]),
reader.GetInt32(attributeIndexDict["deleted"]));
}
private static NPC createNPC(SQLiteDataReader reader)
{
SQLiteCommand command;
if (!reader.Read()) {
return null;
}
NPC npc = new NPC();
npc.permanent = true;
npc.id = reader.GetInt32(0);
npc.name = reader["name"].ToString();
npc.city = reader["city"].ToString();
if (!reader.IsDBNull(3) && !reader.IsDBNull(4) && !reader.IsDBNull(5)) {
npc.pos.x = reader.GetInt32(3);
npc.pos.y = reader.GetInt32(4);
npc.pos.z = reader.GetInt32(5);
}
npc.image = Image.FromStream(reader.GetStream(6));
npc.job = reader.IsDBNull(7) ? "" : reader.GetString(7);
if (npc.image.RawFormat.Guid == ImageFormat.Gif.Guid) {
int frames = npc.image.GetFrameCount(FrameDimension.Time);
if (frames == 1) {
Bitmap new_bitmap = new Bitmap(npc.image);
new_bitmap.MakeTransparent();
npc.image.Dispose();
npc.image = new_bitmap;
}
}
// special case for rashid: change location based on day of the week
if (npc != null && npc.name == "Rashid") {
command = new SQLiteCommand(String.Format("SELECT city, x, y, z FROM RashidPositions WHERE day='{0}'", DateTime.Now.DayOfWeek.ToString()), mainForm.conn);
reader = command.ExecuteReader();
if (reader.Read()) {
npc.city = reader["city"].ToString();
npc.pos.x = reader.GetInt32(1);
npc.pos.y = reader.GetInt32(2);
npc.pos.z = reader.GetInt32(3);
}
}
command = new SQLiteCommand(String.Format("SELECT itemid, value FROM SellItems WHERE vendorid={0}", npc.id), mainForm.conn);
reader = command.ExecuteReader();
while (reader.Read()) {
ItemSold sellItem = new ItemSold();
sellItem.itemid = reader.GetInt32(0);
sellItem.npcid = npc.id;
sellItem.price = reader.GetInt32(1);
npc.sellItems.Add(sellItem);
}
command = new SQLiteCommand(String.Format("SELECT itemid, value FROM BuyItems WHERE vendorid={0}", npc.id), mainForm.conn);
reader = command.ExecuteReader();
while (reader.Read()) {
ItemSold buyItem = new ItemSold();
buyItem.itemid = reader.GetInt32(0);
buyItem.npcid = npc.id;
buyItem.price = reader.GetInt32(1);
npc.buyItems.Add(buyItem);
}
command = new SQLiteCommand(String.Format("SELECT spellid,knight,druid,paladin,sorcerer FROM SpellNPCs WHERE npcid={0}", npc.id), mainForm.conn);
reader = command.ExecuteReader();
while (reader.Read()) {
SpellTaught t = new SpellTaught();
t.npcid = npc.id;
t.spellid = reader.GetInt32(0);
t.knight = reader.GetBoolean(1);
t.druid = reader.GetBoolean(2);
t.paladin = reader.GetBoolean(3);
t.sorcerer = reader.GetBoolean(4);
npc.spellsTaught.Add(t);
}
command = new SQLiteCommand(String.Format("SELECT DISTINCT questid FROM QuestNPCs WHERE npcid={0}", npc.id), mainForm.conn);
reader = command.ExecuteReader();
while (reader.Read()) {
Quest q = getQuest(reader.GetInt32(0));
npc.involvedQuests.Add(q);
}
command = new SQLiteCommand(String.Format("SELECT destination,cost,notes FROM NPCDestinations WHERE npcid={0}", npc.id), mainForm.conn);
reader = command.ExecuteReader();
while (reader.Read()) {
Transport t = new Transport();
t.destination = reader.GetString(0);
t.cost = reader.GetInt32(1);
t.notes = reader.GetString(2);
npc.transportOffered.Add(t);
}
return npc;
}
/* Returns a Workout using a SQLiteDataReader and a dictionary mapping the attributes to a index.
*/
private Workout WorkoutExtractor(SQLiteDataReader reader, Dictionary<string, int> attributeIndexDict)
{
return new Workout(reader.GetString(attributeIndexDict["workoutName"]),
reader.GetInt32(attributeIndexDict["workoutVersion"]));
}
private Int32 SafeInt32(SQLiteDataReader reader, int idx)
{
try
{
if (reader.IsDBNull(idx))
return 0;
else
return reader.GetInt32(idx);
}
catch (Exception)
{
return 0;
}
}
private static Mount createMount(SQLiteDataReader reader)
{
if (!reader.Read()) {
return null;
}
Mount mount = new Mount();
mount.permanent = true;
mount.id = reader.GetInt32(0);
mount.title = reader.GetString(1);
mount.name = reader.GetString(2);
int tameitem = reader.IsDBNull(3) ? DATABASE_NULL : reader.GetInt32(3);
if (tameitem > 0) mount.tameitemid = tameitem;
else mount.tameitemid = -1;
int tamecreature = reader.IsDBNull(4) ? DATABASE_NULL : reader.GetInt32(4);
if (tamecreature > 0) mount.tamecreatureid = tamecreature;
else mount.tamecreatureid = -1;
mount.speed = reader.GetInt32(5);
mount.tibiastore = reader.GetBoolean(6);
mount.image = Image.FromStream(reader.GetStream(7));
return mount;
}
private void ReadAnalogData(SQLiteDataReader r, IDictionary<string, int> field)
{
this.FreqInMhz = r.IsDBNull(field["freq"]) ? 0 : (decimal)r.GetInt32(field["freq"]) / 1000;
this.ChannelOrTransponder = Tools.GetAnalogChannelNumber((int)this.FreqInMhz);
}
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 void ReadAnalogData(SQLiteDataReader r, IDictionary<string, int> field)
{
this.Name = r.GetString(field["channel_label"]);
this.FreqInMhz = (decimal)r.GetInt32(field["frequency"]) / 1000000;
}
