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);
}
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 Qso LoadFromDataReader(SQLiteDataReader dr)
{
Qso q = new Qso();
q.Band = (Band)Enum.Parse(typeof(Band), dr.GetString(dr.GetOrdinal("band")));
q.Callsign = dr.GetString(dr.GetOrdinal("callsign"));
q.Mode = (Mode)Enum.Parse(typeof(Mode), dr.GetString(dr.GetOrdinal("mode")));
q.Operator = dr.GetString(dr.GetOrdinal("operator"));
q.QsoTime = dr.GetDateTime(dr.GetOrdinal("qsotime"));
return q;
}
private void button2_Click(object sender, EventArgs e)
{
// TODO: Exporta txt
dlgExportar.Filter = "Textos (*.txt)|*.txt";
// Cria conteudo do texto
string texto = "DA - Skype Grab Message/Contact List - V1.0 - Betha - Desenvolvimento Aberto\r\n\r\n" +
"Computador: " + Convert.ToString(Environment.MachineName) + "\r\n" +
"Usuário: " + Environment.UserName + "\r\n" +
"Sistema: " + Convert.ToString(Environment.OSVersion) + "\r\n" +
"Versão: " + Convert.ToString(Environment.Version) + "\r\n\r\n";
// Lista de contatos
texto += "****************************\r\n";
texto += "** Lista de Contatos: **\r\n";
texto += "****************************\r\n\r\n";
// Retorna contatos
try
{
contatos = new SQLiteCommand(sql2, conn);
rcontatos = contatos.ExecuteReader();
// Exibe retorno
if (rcontatos.HasRows)
{
while (rcontatos.Read())
{
string nskype = String.Empty;
string cnome = String.Empty;
if (!rcontatos.IsDBNull(rcontatos.GetOrdinal("Skype"))) nskype = rcontatos.GetString(rcontatos.GetOrdinal("Skype"));
if (!rcontatos.IsDBNull(rcontatos.GetOrdinal("Nome"))) cnome = rcontatos.GetString(rcontatos.GetOrdinal("Nome"));
texto += Convert.ToString(rcontatos.GetInt32(0)) + "\r\n";
texto += "Nome Skype: " + nskype + "\r\n";
texto += "Nome Completo: " + cnome + "\r\n\r\n";
}
}
// Lista de menssagens
texto += "********************\r\n";
texto += "** Menssagens: **\r\n";
texto += "********************\r\n\r\n";
}
catch
{
MessageBox.Show("Primeiro você precisa verificar os dados da conta.", "Atenção!!!",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
// Retorna Menssagens
try
{
menssagem = new SQLiteCommand(sql1, conn);
rmenssagem = menssagem.ExecuteReader();
// Exibe retorno
if (rmenssagem.HasRows)
{
while (rmenssagem.Read())
{
string mde = String.Empty;
string mpara = String.Empty;
string mmsg = String.Empty;
if (!rmenssagem.IsDBNull(rmenssagem.GetOrdinal("De"))) mde = rmenssagem.GetString(rmenssagem.GetOrdinal("De"));
if (!rmenssagem.IsDBNull(rmenssagem.GetOrdinal("Para"))) mpara = rmenssagem.GetString(rmenssagem.GetOrdinal("Para"));
if (!rmenssagem.IsDBNull(rmenssagem.GetOrdinal("Menssagem"))) mmsg = rmenssagem.GetString(rmenssagem.GetOrdinal("Menssagem"));
texto += Convert.ToString(rmenssagem.GetInt32(0)) + " \r\n";
texto += mde + " : " + mpara + " \r\n\r\n";
texto += Convert.ToString(rmenssagem.GetString(4)) + " >>>>> " + mmsg + " \r\n";
texto += "----------------------------------------------------------------------------\r\n\r\n";
}
}
// Exibe dialogo para salvar arquivo
if (dlgExportar.ShowDialog() == DialogResult.OK)
{
// Grava um arquivo baseado na area de texto
using (StreamWriter gravar = new StreamWriter(dlgExportar.OpenFile()))
{
gravar.Write(texto);
}
}
}
catch
{
//
}
}
//Argument to this function should be changed
//into the SQLResults object returned from
//runQuery above (and used in fQR above)
/// <summary>
/// A public method allowing the Track Model and external modules to format
/// database queries into coherent RouteInfo objects
/// </summary>
/// <param name="rr">A SQLiteDataReader object provided by the runQuery method in the DBManager</param>
/// <returns>A valid RouteInfo object, or null in the case of a database error.</returns>
public RouteInfo formatRouteQueryResults(SQLiteDataReader rr)
{
if (rr == null)
return null;
//Temp list used to store blocks, since we dont know
//ahead of time how many to expect
var blockList = new List<Block>();
int nBlocks = 0;
//We need to get our list of blocks, and the number of blocks
int bIDFinal = -1, locXFinal = -1, locYFinal = -1;
double sEFinal = -1.0, gradeFinal = -0.0, bSizeFinal = -1.0;
int dest1Final = -1, dest2Final = -1, prevFinal = -1;
int trackCirIDFinal = -1;
int speedLimitFinal =-1;
while (rr.Read())
{
//Get all fields for a given block
bIDFinal = rr.GetInt32(rr.GetOrdinal("blockID"));
string line = rr.GetString(rr.GetOrdinal("line"));
string infra = rr.GetString(rr.GetOrdinal("infra"));
string dir = rr.GetString(rr.GetOrdinal("dir"));
string state = rr.GetString(rr.GetOrdinal("state"));
sEFinal = rr.GetDouble(rr.GetOrdinal("starting_elev"));
gradeFinal = rr.GetDouble(rr.GetOrdinal("grade"));
bSizeFinal = rr.GetDouble(rr.GetOrdinal("bSize"));
trackCirIDFinal = rr.GetInt32(rr.GetOrdinal("trackCirID"));
speedLimitFinal = rr.GetInt32(rr.GetOrdinal("speedLimit"));
locXFinal = rr.GetInt32(rr.GetOrdinal("locX"));
locYFinal = rr.GetInt32(rr.GetOrdinal("locY"));
prevFinal = rr.GetInt32(rr.GetOrdinal("prev"));
dest1Final = rr.GetInt32(rr.GetOrdinal("dest1"));
dest2Final = rr.GetInt32(rr.GetOrdinal("dest2"));
//////////////////////////////////////////////////////////////////////
//Parse fields that must be provided as a different type
string[] infraFinal = infra.Split(';');
var dirFinal = (DirEnum) Enum.Parse(typeof (DirEnum), dir, true);
var stateFinal = (StateEnum) Enum.Parse(typeof (StateEnum), state, true);
var locFinal = new int[2];
locFinal[0] = locXFinal;
locFinal[1] = locYFinal;
blockList.Add(new Block(bIDFinal, stateFinal, prevFinal, sEFinal, gradeFinal, locFinal, bSizeFinal,
dirFinal, infraFinal, dest1Final, dest2Final, trackCirIDFinal, line,speedLimitFinal));
nBlocks++;
}
//If we didnt find any blocks, give up.
if (nBlocks == 0)
{
//if (_dbCon.State != ConnectionState.Closed)
// _dbCon.Close();
return null;
}
Block[] blocks = blockList.ToArray();
string rName = blocks[0].Line;
int rID;
if (rName.Equals("Red", StringComparison.OrdinalIgnoreCase))
rID = 0;
else
rID = 1;
//All routes start and end at the yard
int sID = 0;
int eID = 0;
var tempRoute = new RouteInfo(rID, rName, nBlocks, blocks, sID, eID);
//if (_dbCon.State != ConnectionState.Closed)
// _dbCon.Close();
return tempRoute;
}
//Argument to this function shouldbe changed
//into the SQLResults object returned from
//runQuery() above
/// <summary>
/// A public method allowing the track model and other modules to format
/// database query results into coherent Block objects
/// </summary>
/// <param name="bR">The SQLiteDataReader containing the results of the query</param>
/// <returns>A valid Block object, or null in the case of an error</returns>
public Block formatBlockQueryResults(SQLiteDataReader bR)
{
Block tempBlock = null;
int i = 0;
if (!bR.IsClosed)
{
while (bR.Read())
{
//Get all fields for a given block
string line = null, infra = null, dir = null;
string state = null;
int bIDFinal = -1, locXFinal = -1, locYFinal = -1;
double sEFinal = -1.0, gradeFinal = -1.0, bSizeFinal = -1.0;
int prevFinal = -1, dest1Final = -1, dest2Final = -1;
int trackCirIDFinal = -1;
int speedLimitFinal = -1;
try
{
bIDFinal = bR.GetInt32(bR.GetOrdinal("blockID"));
line = bR.GetString(bR.GetOrdinal("line"));
infra = bR.GetString(bR.GetOrdinal("infra"));
dir = bR.GetString(bR.GetOrdinal("dir"));
state = bR.GetString(bR.GetOrdinal("state"));
if (bIDFinal != 0)
{
sEFinal = bR.GetDouble(bR.GetOrdinal("starting_elev"));
gradeFinal = bR.GetDouble(bR.GetOrdinal("grade"));
locXFinal = bR.GetInt32(bR.GetOrdinal("locX"));
locYFinal = bR.GetInt32(bR.GetOrdinal("locY"));
bSizeFinal = bR.GetDouble(bR.GetOrdinal("bSize"));
prevFinal = bR.GetInt32(bR.GetOrdinal("prev"));
dest1Final = bR.GetInt32(bR.GetOrdinal("dest1"));
dest2Final = bR.GetInt32(bR.GetOrdinal("dest2"));
trackCirIDFinal = bR.GetInt32(bR.GetOrdinal("trackCirID"));
speedLimitFinal = bR.GetInt32(bR.GetOrdinal("speedLimit"));
}
}
catch (Exception e)
{
//Console.WriteLine("Exception was raised");
}
//////////////////////////////////////////////////////////////////////
//Parse fields that must be provided as a different type
string[] infraFinal = infra.Split(';');
var dirFinal = (DirEnum) Enum.Parse(typeof (DirEnum), dir, true);
var stateFinal = (StateEnum) Enum.Parse(typeof (StateEnum), state, true);
var locFinal = new int[2];
locFinal[0] = locXFinal;
locFinal[1] = locYFinal;
tempBlock = new Block(bIDFinal, stateFinal, prevFinal, sEFinal, gradeFinal, locFinal, bSizeFinal,
dirFinal, infraFinal, dest1Final, dest2Final, trackCirIDFinal, line,speedLimitFinal);
i++; //Inc counter
}
}
else
{
//Console.WriteLine("Reader was closed, this was a mistake.");
}
if (i != 1)
return null;
else
return tempBlock;
}
private static void ReadQueryResult(QueryResolution resolution, SQLiteDataReader reader, List<KeyValuePair<DateTime, decimal>> values)
{
switch (resolution)
{
case QueryResolution.All:
var date = reader.GetDateTime(0);
var value = reader.GetDecimal(1);
values.Add(new KeyValuePair<DateTime, decimal>(date, value));
break;
default:
var rawDate = Convert.ToString(reader["GroupedDate"]);
// Partial time resolutions will cause the raw date to have a minute value
// of :0 instead of :00, which will cause parsing errors, so try and fix that
if (rawDate.EndsWith(":0"))
rawDate += "0";
var resolutionDate = DateTime.Parse(rawDate);
var resolutionValue = reader.GetDecimal(reader.GetOrdinal("Value"));
values.Add(new KeyValuePair<DateTime, decimal>(resolutionDate, resolutionValue));
break;
}
}
