internal void cargarTablaMozos(EditarMozo editarMozo, int id)
{
try
{
conectar();
string sql = "select * from Mozo where id = " + id;
command = new SQLiteCommand(sql, connection);
SQLiteDataReader lector = command.ExecuteReader();
while (lector.Read())
{
editarMozo.textBoxNombre.Text = lector.GetString(0);
editarMozo.checkBoxMañana.Checked = lector.GetBoolean(2);
editarMozo.checkBoxTarde.Checked = lector.GetBoolean(3);
editarMozo.checkBoxNoche.Checked = lector.GetBoolean(4);
}
command.Connection.Close();;
}
catch (Exception e)
{
throw new Exception("Error: " + e);
}
finally
{
desconectar();
}
}
public IEnumerable <MediaType> GetMediaTypes()
{
SQLiteConnection connection = GetConnectionForTable("azusa.mediaTypes");
SQLiteCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT * FROM azusa.mediaTypes";
SQLiteDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
MediaType mt = new MediaType();
mt.Id = dataReader.GetInt32(0);
mt.ShortName = dataReader.GetString(1);
mt.LongName = dataReader.GetString(2);
mt.GraphData = dataReader.GetBoolean(3);
mt.DateAdded = dataReader.GetDateTime(4);
mt.Icon = dataReader.GetByteArray(5);
mt.IgnoreForStatistics = dataReader.GetBoolean(6);
if (!dataReader.IsDBNull(8))
{
mt.HasFilesystem = dataReader.GetBoolean(8);
}
yield return(mt);
}
dataReader.Dispose();
cmd.Dispose();
}
/// <summary>
/// Retrieve log file definition.
/// </summary>
/// <param name="fileKey"></param>
/// <returns></returns>
public static Models.LogFileDefinition GetDefinition(string fileKey)
{
var returnModel = new Models.LogFileDefinition();
var connectionString = "URI=file:" + Path.Combine("database/logetl.db");
using (var connection = new SQLiteConnection(connectionString))
{
connection.Open();
var statement = $"SELECT * FROM definitions WHERE logfilekey = '{fileKey}'";
using (var command = new SQLiteCommand(statement, connection))
{
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
returnModel.LogFileKey = reader.GetString(0);
returnModel.SplunkOutput = reader.GetBoolean(1);
returnModel.DatabaseOutput = reader.GetBoolean(2);
}
}
}
}
return(returnModel);
}
public Nullable <Eredmény> Eredmény(string _verseny, string _név)
{
lock (Program.datalock)
{
Nullable <Eredmény> Data = null;
connection.Open( );
SQLiteCommand command = connection.CreateCommand();
command.CommandText = "SELECT INNEVE, INSOSZ, ITAZON, INCSSZ, IN10TA, IN08TA, IN05TA, INMETA, INOSZP, INERSZ, INMEGJ, INKOMO, KOAZON FROM Eredmények_" + _verseny + " WHERE INNEVE = '" + _név + "';";
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read( ))
{
Data = new Eredmény(reader.GetString(0),
reader.GetInt64(1),
reader.GetString(2),
reader.GetInt32(3),
reader.GetInt32(4),
reader.GetInt32(5),
reader.GetInt32(6),
reader.GetInt32(7),
reader.GetInt32(8),
reader.GetInt32(9),
reader.GetBoolean(10),
reader.GetBoolean(11),
reader.GetString(12));
}
command.Dispose( );
connection.Close( );
return(Data);
}
}
public override bool GetAllRecords(out List <ViewData> list)
{
list = new List <ViewData>();
lock (syncObject)
{
if (!Open("GetAllRecords"))
{
Logger.Log("GetAllRecords: Open() failed");
return(false);
}
SQLiteCommand sqlCommand = new SQLiteCommand("SELECT * FROM Positions", connection);
string results = string.Empty;
try
{
SQLiteDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
ViewData record = new ViewData
{
id = reader.GetInt64((int)ColumnIndices.ID),
symbol = reader.GetString((int)ColumnIndices.Symbol),
buyDate = reader.GetDateTime((int)ColumnIndices.BuyDate),
buyPrice = reader.GetDecimal((int)ColumnIndices.BuyPrice),
sharesBought = reader.GetDouble((int)ColumnIndices.SharesBought),
numShares = reader.GetDouble((int)ColumnIndices.NumShares),
highestClose = reader.GetDecimal((int)ColumnIndices.HighestClose),
lastClose = reader.GetDecimal((int)ColumnIndices.LastClose),
fixedStop = reader.GetDecimal((int)ColumnIndices.FixedStopPrice),
stopPercent = reader.GetInt32((int)ColumnIndices.StopPercent),
useTrailing = reader.GetBoolean((int)ColumnIndices.UseTrailing),
useDividends = reader.GetBoolean((int)ColumnIndices.UseDividends),
dividends = reader.GetDecimal((int)ColumnIndices.Dividends),
useOptions = reader.GetBoolean((int)ColumnIndices.UseOptions),
options = reader.GetDecimal((int)ColumnIndices.OptionsSold),
lastUpdate = reader.GetDateTime((int)ColumnIndices.LastUpdate)
};
list.Add(record);
}
reader.Close();
}
catch (SQLiteException e)
{
MessageBox.Show("GetAllRecords - " + e.Message);
return(false);
}
catch (Exception ex)
{
MessageBox.Show("GetAllRecords - " + ex.Message);
return(false);
}
finally
{
connection.Close();
}
} // lock
list.Sort(CompareBySymbol);
return(true);
}
public Item GetItem(Int32 id)
{
SQLiteCommand cmd = new SQLiteCommand(Program.m_dbConnection);
cmd.CommandText = "SELECT A.ID AS ID, " +
"A.TIPOITEM AS TIPO, " +
"A.TITULO AS TITULO, " +
"A.AUTOR AS AUTOR, " +
"A.ALBUM AS ALBUM, " +
"A.DURACION AS DURACION, " +
"A.GENERO AS GENERO, " +
"A.IDIOMA AS IDIOMA, " +
"A.LOCALIZACION AS LOCALIZACION, " +
"A.TIENELETRA AS TIENELETRA, " +
"A.PERDIDO AS PERDIDO " +
"FROM " + this.tableName + " A WHERE ID ='" + id.ToString() + "'";
SQLiteDataReader row = cmd.ExecuteReader();
row.Read();
Item item = new Item();
item.Id = row.GetInt32(0); // Convert.ToInt32(row.Item["id"]);
item.tipo = row.GetString(1); // Convert.ToString(row["tipo"]);
item.Titulo = row.GetString(2); // Convert.ToString(row["Titulo"]);
item.Autor = row.GetString(3); // Convert.ToString(row["Autor"]);
item.Album = row.GetString(4); // Convert.ToString(row["Album"]);
item.Duracion = row.GetString(5); // Convert.ToString(row["Duracion"]);
item.genero = row.GetString(6); // Convert.ToString(row["genero"]);
item.idioma = row.GetString(7); // Convert.ToString(row["idioma"]);
item.Localizacion = row.GetString(8); // Convert.ToString(row["Localizacion"]);
item.tieneletra = row.GetBoolean(9);
item.perdido = row.GetBoolean(10);
return(item);
}
public List <Eredmény> Eredmények(string _azonosító)
{
lock (Program.datalock)
{
List <Eredmény> data = new List <Eredmény>( );
connection.Open( );
SQLiteCommand command = connection.CreateCommand( );
command.CommandText = "SELECT INNEVE, INSOSZ, ITAZON, INCSSZ, IN10TA, IN08TA, IN05TA, INMETA, INOSZP, INERSZ, INMEGJ, INKOMO, KOAZON FROM Eredmények_" + _azonosító + ";";
SQLiteDataReader reader = command.ExecuteReader( );
while (reader.Read( ))
{
data.Add(new Eredmény(reader.GetString(0),
reader.GetInt64(1),
reader.GetString(2),
reader.GetInt32(3),
reader.GetInt32(4),
reader.GetInt32(5),
reader.GetInt32(6),
reader.GetInt32(7),
reader.GetInt32(8),
reader.GetInt32(9),
reader.GetBoolean(10),
reader.GetBoolean(11),
reader.GetString(12)));
}
command.Dispose( );
connection.Close( );
return(data);
}
}
public void updateLists()
{
bills.Clear();
SQLiteConnection dbConnection = new SQLiteConnection("Data Source=database.sqlite;Version=3;");
dbConnection.Open();
SQLiteCommand cmd = dbConnection.CreateCommand();
cmd.CommandText = "SELECT * FROM bills WHERE (PAID_BY='" + User.Email + "' OR PAID_TO='" + User.Email + "') AND SETTLED=0;";
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
long id = reader.GetInt64(0);
string paid_by = reader.GetString(1);
string paid_to = reader.GetString(2);
string desc = reader.GetString(3);
float amount = reader.GetFloat(4);
bool accepted = reader.GetBoolean(5);
bool settled = reader.GetBoolean(6);
bills.Add(new Bill(id, paid_by, paid_to, desc, amount, accepted, settled));
}
reader.Close();
dbConnection.Close();
}
/// <summary>
/// Retrieves all components (in the inventory) in the database
/// </summary>
/// <returns>List of all components in the database</returns>
private List <Component> getAllComponents()
{
List <Component> components = new List <Component>();
//using (var tx = conn.BeginTransaction())
//{
using (SQLiteDataReader reader = getAllComponentsCommand.ExecuteReader())
{
//tx.Commit();
if (reader.HasRows)
{
while (reader.Read())
{
reader.Read();
// TODO: Link up the notes and crashHistory stuff
components.Add(new Component(reader.GetInt32(0), reader.GetString(1),
reader.GetString(2), reader.GetString(3), reader.GetString(4),
reader.GetDouble(5), reader.GetString(6), reader.GetString(7),
reader.GetBoolean(8), reader.GetBoolean(9), reader.GetString(10)));
}
}
}
//}
return(components);
}
public List <KGLanguage> Get(string wherecase = "", string ordercase = "")
{
List <KGLanguage> results = new List <KGLanguage>();
SQLiteConnection conn = DbConnection.Conn;
SQLiteCommand cmd = new SQLiteCommand("select * from kg_language", conn);
try
{
conn.Open();
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
KGLanguage item = new KGLanguage();
item.Name = reader.IsDBNull(0) ? "" : reader.GetString(0);
item.Description = reader.IsDBNull(1) ? "" : reader.GetString(1);
item.IsCompileLanguage = reader.IsDBNull(2) ? false : reader.GetBoolean(2);
item.IsExplainLanguage = reader.IsDBNull(3) ? false : reader.GetBoolean(3);
item.IsProcessLanguage = reader.IsDBNull(4) ? false : reader.GetBoolean(4);
item.IsObjectiveLanguage = reader.IsDBNull(5) ? false : reader.GetBoolean(5);
item.IsScriptLanguage = reader.IsDBNull(6) ? false : reader.GetBoolean(6);
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return(results);
}
/// <summary>
/// Gets all components for a specific system
/// </summary>
/// <param name="systemName">The specified system to retieve components for</param>
/// <returns>List of all components for the systemName</returns>
private List <Component> GetAllComponentsForSystem(string systemName)
{
List <Component> components = new List <Component>();
///using (var tx = conn.BeginTransaction())
///{
getAllComponentsForSystemCommand.Parameters["@System"].Value = systemName;
using (SQLiteDataReader reader = getAllComponentsForSystemCommand.ExecuteReader())
{
///tx.Commit();
if (reader.HasRows)
{
while (reader.Read())
{
// TODO: Link up the notes and crashHistory stuff
Component temp = new Component(reader.GetInt32(0), reader.GetString(1),
reader.GetString(2), reader.GetString(3), reader.GetString(4),
reader.GetDouble(5), reader.GetString(6), reader.GetString(7),
reader.GetBoolean(8), reader.GetBoolean(9), reader.GetString(10));
components.Add(temp);
Console.WriteLine(temp.name);
}
}
}
///}
return(components);
}
/// <summary>
/// Get Competition by Competition name.
/// </summary>
/// <param name="competitionName"></param>
/// <returns></returns>
public static CompetitionModel GetCompetitionByName(string competitionName)
{
CompetitionModel rValue = null;
_conn = new SQLiteConnection(CONNECTION_STRING);
_conn.Open();
using (SQLiteCommand command = _conn.CreateCommand())
{
command.CommandText = "SELECT CompetitionID, CompetitionName, CompetitionImage, FixedTeams, RandomiseTeams, LogicallyDeleted" +
" FROM Competitions" +
" WHERE CompetitionName = @competitionName";
command.Parameters.AddWithValue("@competitionName", competitionName);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
rValue = new CompetitionModel();
rValue.CompetitionID = reader.GetInt64(0);
rValue.CompetitionName = reader.GetString(1);
rValue.CompetitionImage = reader.GetString(2);
rValue.TeamsAreFixed = reader.GetBoolean(3);
rValue.TeamsAreRandomised = reader.GetBoolean(4);
rValue.LogicallyDeleted = reader.GetBoolean(5);
}
}
_conn.Dispose();
return(rValue);
}
public void OfflineLoadData()
{
con = new SQLiteConnection("Data Source=hospitalDb.db);Version=3");
string cstring = "select * from OPDTable where Id=@id";
cmd = new SQLiteCommand(cstring, con);
con.Open();
cmd.Parameters.AddWithValue("@id", SelectedId);
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
IsTbCheckBox.Checked = reader.GetBoolean(1);
DiagnosticInvestigationTextBox.Text = reader.GetString(2);
ProvisionalDiagnosisTextBox.Text = reader.GetString(3);
ICDCodeTextBox.Text = reader.GetString(4);
TreatmentTextBox.Text = reader.GetString(5);
SurgicalProcedureTextBox.Text = reader.GetString(6);
IsFirstTimeCheckBox.Checked = reader.GetBoolean(9);
IsGenderViolenceCheckBox.Checked = reader.GetBoolean(7);
FreeServiceCodeComboBox.SelectedItem = reader.GetString(8);
PanTextBox.Text = reader.GetString(13);
ClaimCodemetroTextBox.Text = reader.GetString(12);
NshimetroTextBox.Text = reader.GetString(11);
ReferredToTextBox.Text = reader.GetString(10);
}
con.Close();
}
public List <Korosztály> Korosztályok(string _verseny)
{
lock (Program.datalock)
{
List <Korosztály> data = new List <Korosztály>();
connection.Open( );
SQLiteCommand command = connection.CreateCommand();
command.CommandText = "SELECT VEAZON, KOAZON, KOMEGN, KOEKMI, KOEKMA, KONOK, KOFERF, KOINSN, KOINSF, KOEGYB FROM Korosztályok WHERE VEAZON = '" + _verseny + "' ORDER BY KOEKMI;";
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read( ))
{
data.Add(new Korosztály(reader.GetString(0),
reader.GetString(1),
reader.GetString(2),
reader.GetInt32(3),
reader.GetInt32(4),
reader.GetBoolean(5),
reader.GetBoolean(6),
reader.GetInt32(7),
reader.GetInt32(8),
reader.GetBoolean(9)));
}
command.Dispose( );
connection.Close( );
return(data);
}
}
public void Load(BCRUser user)
{
using (SQLiteDataReader reader = Database.Instance.ExecuteReader(@"SELECT open_current_comic_at_launch, open_next_comic, page_fit_mode,
zoom_on_tap, toggle_paging_bar, use_page_turn_drag, page_turn_drag_threshold, use_page_change_area, page_change_area_width, use_comicrack_progress
FROM user_settings WHERE user_id = " + user.UserId + " LIMIT 1;"))
{
if (reader.Read())
{
try
{
open_current_comic_at_launch = reader.GetBoolean(0);
open_next_comic = reader.GetBoolean(1);
page_fit_mode = reader.GetInt32(2);
zoom_on_tap = reader.GetInt32(3);
toggle_paging_bar = reader.GetInt32(4);
use_page_turn_drag = reader.GetBoolean(5);
page_turn_drag_threshold = reader.GetInt32(6);
use_page_change_area = reader.GetBoolean(7);
page_change_area_width = reader.GetInt32(8);
use_comicrack_progress = reader.GetBoolean(9);
full_name = user.FullName;
}
catch (Exception ex)
{
Trace.WriteLine(ex);
}
}
}
}
public static void Read(this Beatmap beatmap, SQLiteDataReader reader)
{
int i = 1;
beatmap.TitleRoman = reader.GetString(i); i++;
beatmap.ArtistRoman = reader.GetString(i); i++;
beatmap.TitleUnicode = reader.GetString(i); i++;
beatmap.ArtistUnicode = reader.GetString(i); i++;
beatmap.Creator = reader.GetString(i); i++;
beatmap.DiffName = reader.GetString(i); i++;
beatmap.Mp3Name = reader.GetString(i); i++;
beatmap.Md5 = reader.GetString(i); i++;
beatmap.OsuFileName = reader.GetString(i); i++;
beatmap.MaxBpm = reader.GetDouble(i); i++;
beatmap.MinBpm = reader.GetDouble(i); i++;
beatmap.Tags = reader.GetString(i); i++;
beatmap.State = reader.GetByte(i); i++;
beatmap.Circles = (short)reader.GetInt32(i); i++;
beatmap.Sliders = (short)reader.GetInt32(i); i++;
beatmap.Spinners = (short)reader.GetInt32(i); i++;
beatmap.EditDate = reader.GetDateTime(i).ToUniversalTime(); i++;
beatmap.ApproachRate = (float)reader.GetDouble(i); i++;
beatmap.CircleSize = (float)reader.GetDouble(i); i++;
beatmap.HpDrainRate = (float)reader.GetDouble(i); i++;
beatmap.OverallDifficulty = (float)reader.GetDouble(i); i++;
beatmap.SliderVelocity = reader.GetDouble(i); i++;
beatmap.DrainingTime = reader.GetInt32(i); i++;
beatmap.TotalTime = reader.GetInt32(i); i++;
beatmap.PreviewTime = reader.GetInt32(i); i++;
beatmap.MapId = reader.GetInt32(i); i++;
beatmap.MapSetId = reader.GetInt32(i); i++;
beatmap.ThreadId = reader.GetInt32(i); i++;
/*beatmap.MapRating =*/ reader.GetInt32(i); i++;
beatmap.Offset = (short)reader.GetInt32(i); i++;
var stackLeniency = reader.SafeGetDouble(i); i++;
beatmap.StackLeniency = double.IsNaN(stackLeniency) ? 0 : (float)stackLeniency;//TODO: (CollectionManager) StackLeniency has to be nullable
beatmap.PlayMode = (PlayMode)reader.GetByte(i); i++;
beatmap.Source = reader.GetString(i); i++;
beatmap.AudioOffset = (short)reader.GetInt32(i); i++;
beatmap.LetterBox = reader.GetString(i); i++;
beatmap.Played = reader.GetBoolean(i); i++;
beatmap.LastPlayed = reader.GetDateTime(i).ToUniversalTime(); i++;
beatmap.IsOsz2 = reader.GetBoolean(i); i++;
beatmap.Dir = reader.GetString(i); i++;
beatmap.LastSync = reader.GetDateTime(i).ToUniversalTime(); i++;
beatmap.DisableHitsounds = reader.GetBoolean(i); i++;
beatmap.DisableSkin = reader.GetBoolean(i); i++;
beatmap.DisableSb = reader.GetBoolean(i); i++;
beatmap.BgDim = reader.GetInt16(i); i++;
beatmap.Somestuff = reader.GetInt16(i); i++;
beatmap.DeSerializeStars((byte[])reader.GetValue(i)); i++;
i++; // beatmapChecksum
beatmap.MainBpm = reader.GetDouble(i);
}
public void selectAll()
{
if (allUnitFeatuers == null || allUnitFeatuers.Count == 0)
{
ruleManager.selectAll();
string query = "SELECT * FROM " + UNIT_TABLE_NAME + "";
SQLiteDataReader mReader = sqlManager.executeReader(query);
List <UnitFeatures> unitList = new List <UnitFeatures>();
int Counter = 0;
if (mReader.Read())
{
do
{
Counter++;
int id = mReader.GetInt32(0);
string name = mReader.GetString(1);
int powerSpawn = mReader.GetInt32(2);
int powerMove = mReader.GetInt32(3);
int powerAttack = mReader.GetInt32(4);
float powerRegen = mReader.GetFloat(5);
int airDamage = mReader.GetInt32(6);
int groundDamage = mReader.GetInt32(7);
float armorPricsingDamagePoint = mReader.GetFloat(8);
float splashDamagePoint = mReader.GetFloat(9);
int health = mReader.GetInt32(10);
bool isArmored = mReader.GetBoolean(11);
bool isGrounded = mReader.GetBoolean(12);
int width = (int)mReader.GetFloat(15);
int height = (int)mReader.GetFloat(16);
int vision = mReader.GetInt32(17);
int requiredLevel = mReader.GetInt32(18);
int coinCost = mReader.GetInt32(19);
int lastModified = mReader.GetInt32(21);
int moveSpeed = mReader.GetInt32(22);
string description = mReader.GetString(23);
bool isVehicle = mReader.GetBoolean(24);
int shotPerTurn = mReader.GetInt32(25);
bool isInDeck;
bool isLocked;
int currentLevel;
isInDeck = false; //mReader.GetBoolean(14);
isLocked = false; //mReader.GetBoolean(13);
currentLevel = 1; //mReader.GetInt32(20);
UnitFeatures unit = new UnitFeatures(id, name, powerSpawn, powerMove, powerAttack, powerRegen,
airDamage, groundDamage, armorPricsingDamagePoint, splashDamagePoint, health, isArmored,
isGrounded, isLocked, isInDeck, width, height, vision, requiredLevel, coinCost, currentLevel,
lastModified, moveSpeed, description, isVehicle, shotPerTurn);//,numberOfStateImages,numberOfDirections);
List <UpgradeRule> upgradeRule = ruleManager.selectUnitUpgradeRule(id);
unit.rules = upgradeRule;
unitList.Add(unit);
} while (mReader.Read());
}
allUnitFeatuers = unitList;
}
}
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)
});
}
public TrainRemoteControl.Model.Display GetFirstRecord()
{
SQLiteDataReader dr = null;
TrainRemoteControl.Model.Display display = new TrainRemoteControl.Model.Display();
try
{
SQLiteDBHelper sdb = new SQLiteDBHelper(Program.g_dbPath);
dr = sdb.ExecuteReader(GetFirstRecordSqlStr, null);
string temp = null;
while (dr.Read())
{
display.Number = dr.GetInt32(2);
display.oil_mass = float.Parse(dr.GetString(3));
display.fire_alarm = dr.GetBoolean(4);
display.up_oil_place = dr.GetBoolean(5);
display.up_water_place = dr.GetBoolean(6);
display.battery_voltage = dr.GetBoolean(7);
display.alarm = dr.GetBoolean(8);
display.alarm_voice = dr.GetBoolean(9);
temp = dr.GetString(10).Trim();
display.oil_press = !string.IsNullOrEmpty(temp)? float.Parse(temp):0;
temp = dr.GetString(11).Trim();
display.water_temp = !string.IsNullOrEmpty(temp) ? float.Parse(temp) : 0;
temp = dr.GetString(12).Trim();
display.frequency = !string.IsNullOrEmpty(temp) ? float.Parse(temp) : 0;
temp = dr.GetString(13).Trim();
display.motor_speed = !string.IsNullOrEmpty(temp) ? float.Parse(temp) : 0;
temp = dr.GetString(14).Trim();
display.voltage = !string.IsNullOrEmpty(temp) ? float.Parse(temp) : 0;
temp = dr.GetString(15).Trim();
display.current = !string.IsNullOrEmpty(temp) ? float.Parse(temp) : 0;
temp = dr.GetString(16).Trim();
display.motor_power = !string.IsNullOrEmpty(temp) ? float.Parse(temp) : 0;
temp = dr.GetString(17).Trim();
display.power_factor = !string.IsNullOrEmpty(temp) ? float.Parse(temp) : 0;
display.oil_leak = dr.GetBoolean(18);
display.OKAlarm = dr.GetBoolean(19);
display.NOAlarm = dr.GetBoolean(20);
display.NCAlarm = dr.GetBoolean(21);
display.time = dr.GetDateTime(22);
}
return(display);
}
finally
{
if (dr != null)
{
dr.Close();
}
}
}
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);
}
// Get Plug by PlugID
public static PlugDevice GetPlugDeviceByPlugID(Int64 plugid, string dbPath)
{
try
{
using (SQLiteConnection conn = new SQLiteConnection("Data Source=" + dbPath + ";"))
{
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from PlugList where PlugID=@PlugID;";
cmd.Parameters.Add(new SQLiteParameter("PlugID", plugid));
SQLiteDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
PlugDevice plugdev = new PlugDevice();
plugdev.PlugID = dr.GetInt64(0);
plugdev.PlugName = dr.GetString(1);
plugdev.PlugMac = dr.GetString(2);
plugdev.UserCode = (UInt16)dr.GetInt32(3);
plugdev.Voltage = dr.GetFloat(4);
plugdev.Power = dr.GetFloat(5);
plugdev.DayBudget = dr.GetFloat(6);
plugdev.NightBudget = dr.GetFloat(7);
plugdev.MorningBudget = dr.GetFloat(8);
plugdev.AfternoonBudget = dr.GetFloat(9);
plugdev.EveningBudget = dr.GetFloat(10);
plugdev.NightSaving = dr.GetBoolean(11);
plugdev.MorningSaving = dr.GetBoolean(12);
plugdev.AfternoonSaving = dr.GetBoolean(13);
plugdev.EveningSaving = dr.GetBoolean(14);
plugdev.Description = dr.GetString(15);
plugdev.CreateDateTime = dr.GetDateTime(16);
return(plugdev);
}
else
{
return(null);
}
}
}
catch (ArgumentException ae)
{
MessageBox.Show(ae.Message + " \n\n" + ae.Source + "\n\n" + ae.StackTrace);
return(null);
}
catch (Exception ex)
{
//Do any logging operation here if necessary
throw new Exception(ex.Message);
}
}
public static List <Giveaway> GetGiveaways()
{
try
{
using (SQLiteConnection _conn = new SQLiteConnection(connectionString))
{
using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Giveaways", _conn))
{
cmd.Connection.Open();
SQLiteDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
List <Giveaway> giveaways = new List <Giveaway>();
while (dr.Read())
{
Giveaway giveaway = new Giveaway();
giveaway.Id = dr.GetInt32(0);
giveaway.Name = dr.GetString(1);
giveaway.Reward = dr.GetInt32(2);
giveaway.RewardString = dr.GetString(3);
giveaway.Type = dr.GetInt32(4);
giveaway.Hashtag = dr.GetString(5);
giveaway.Repeat = dr.GetInt32(6);
giveaway.Delay = dr.GetInt32(7);
giveaway.StartMessage = dr.GetString(8);
giveaway.WinnerMessage = dr.GetString(9);
giveaway.WinnerWhisper = dr.GetString(10);
giveaway.CodeWhisper = dr.GetString(11);
giveaway.AnnounceStart = dr.GetBoolean(12);
giveaway.AutoPickCode = dr.GetBoolean(13);
giveaways.Add(giveaway);
}
dr.Close();
_conn.Close();
return(giveaways);
}
else
{
dr.Close();
_conn.Close();
return(new List <Giveaway>());
}
}
}
}
catch (Exception e)
{
MessageBox.Show("Error retrieving giveaways: \n\n" + e.Message);
return(null);
}
}
/// <summary>
/// Get all Competitions from the database.
/// </summary>
/// <param name="excludeDeleted"></param>
/// <returns></returns>
public static List <CompetitionModel> GetAllCompetitions(bool excludeDeleted = false)
{
List <CompetitionModel> rValue = new List <CompetitionModel>();
_conn = new SQLiteConnection(CONNECTION_STRING);
_conn.Open();
try
{
using (SQLiteCommand command = _conn.CreateCommand())
{
string baseSQL = "SELECT CompetitionID, CompetitionName, CompetitionImage, FixedTeams, RandomiseTeams, LogicallyDeleted" +
" FROM Competitions";
if (excludeDeleted)
{
baseSQL += " WHERE LogicallyDeleted = @logicallyDeleted";
command.CommandText = baseSQL;
command.Parameters.AddWithValue("@logicallyDeleted", true);
}
else
{
command.CommandText = baseSQL;
}
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
CompetitionModel c = new CompetitionModel();
c.CompetitionID = reader.GetInt64(0);
c.CompetitionName = reader.GetString(1);
c.CompetitionImage = reader.GetString(2);
c.TeamsAreFixed = reader.GetBoolean(3);
c.TeamsAreRandomised = reader.GetBoolean(4);
c.LogicallyDeleted = reader.GetBoolean(5);
rValue.Add(c);
}
}
_conn.Dispose();
}
catch (SQLiteException e)
{
_conn.Dispose();
}
return(rValue);
}
/// <summary>
/// checks, if the chosen race has an extra choice attached to it
/// </summary>
/// <param name="subraceChoice">the race to be checked</param>
public bool subraceHasProficiencyChoice(string subraceChoice)
{
bool hasChoice = false;
using (SQLiteConnection connection = new SQLiteConnection(ConnectionString))
using (SQLiteCommand command = new SQLiteCommand(connection))
{
connection.Open();
command.CommandText = "SELECT extraToolProficiencies FROM races " +
"WHERE subrace=@SubraceChoice";
command.Parameters.AddWithValue("@SubraceChoice", subraceChoice);
using (SQLiteDataReader dbReader = command.ExecuteReader())
{
while (dbReader.Read())
{
if (!dbReader.IsDBNull(0))
{
hasChoice = dbReader.GetBoolean(0);
}
}
}
}
return(hasChoice);
}
public void LoadTableInfo()
{
SQLiteConnection Conn = new SQLiteConnection(connectstring);
SQLiteCommand Com = Conn.CreateCommand();
Com.CommandText = "PRAGMA table_info(" + tableName + ")";
Conn.Open();
SQLiteDataReader rs = Com.ExecuteReader();
while (rs.Read())
{
SQLiteTableColumn tablecolumn = new SQLiteTableColumn();
tablecolumn.m_parent = this;
tablecolumn.ColumnName = rs.GetString(rs.GetOrdinal("name"));
tablecolumn.ColumnType = rs.GetString(rs.GetOrdinal("type"));
//tablecolumn.DefaultValue = rs.GetString(rs.GetOrdinal("dflt_value"));
tablecolumn.pk = rs.GetBoolean(rs.GetOrdinal("pk"));
if (tablecolumn.pk == true)
{
HasPrimaryKey = true;
}
listSQLiteTableColumn.Add(tablecolumn);
}
rs.Close();
Conn.Close();
rs.Dispose();
Com.Dispose();
Conn.Dispose();
}
/// <summary>
/// Retrieve all market orders created by <code>seller</code>
/// </summary>
public static List <MarketEntry> EntriesBySeller(Mobile seller)
{
List <MarketEntry> list = new List <MarketEntry>();
SQLiteDataReader reader = ExecuteQuery("SELECT entryid,active,category,cost,description,itemserial FROM entries WHERE sellerserial = " + (int)seller.Serial);
while (reader.Read())
{
IEntity saleObject = World.FindEntity(reader.GetInt32(reader.GetOrdinal("itemserial")));
MarketEntry entry = new MarketEntry(seller);
entry.Active = reader.GetBoolean(reader.GetOrdinal("active"));
entry.Category = (Category)reader.GetInt32(reader.GetOrdinal("category"));
entry.Description = reader.GetString(reader.GetOrdinal("description"));
entry.TableId = reader.GetInt32(reader.GetOrdinal("entryid"));
if (saleObject != null)
{
entry.SetSellItem(saleObject);
}
entry.ChangeCost(reader.GetInt32(reader.GetOrdinal("cost")), 0, 0);
list.Add(entry);
}
reader.Close();
return(list);
}
public static List <Task> GetAllTasks()
{
DAL.ConnectDb();
List <Task> data = new List <Task> ();
string query = "SELECT * FROM " + TableName;
SQLiteCommand command = new SQLiteCommand(query, DAL.Conn);
SQLiteDataReader reader = command.ExecuteReader();
while (reader.HasRows)
{
while (reader.Read())
{
Task t = new Task();
t.Id = reader.GetInt32(0);
t.Owner = UserDAL.GetUserById(reader.GetInt32(1));
t.Title = reader.GetString(2);
t.Description = reader.GetString(3);
t.Status = (TaskStatus)reader.GetInt32(4);
t.StartDate = DateTime.Parse(reader.GetString(5));
t.EndDate = DateTime.Parse(reader.GetString(6));
t.IsPrivate = reader.GetBoolean(7);
t.Partners = PartnerDAL.GetAllPartners(t);
data.Add(t);
}
reader.NextResult();
}
return(data);
}
private byte[] GetHTTPCacheContent(Uri uri, ref bool requestSuccess)
{
using (SQLiteCommand command = new SQLiteCommand("select success, data from httpcache where uri=@uri", this.FetchDbConn()))
{
command.Parameters.Add(new SQLiteParameter("@uri", uri.ToString()));
using (SQLiteDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
requestSuccess = reader.GetBoolean(reader.GetOrdinal("success"));
// Get the length of the content by passing nothing to getbytes
int contentLength = Convert.ToInt32(reader.GetBytes(reader.GetOrdinal("data"), 0, null, 0, 0));
byte[] content = new byte[contentLength];
reader.GetBytes(reader.GetOrdinal("data"), 0, content, 0, contentLength);
return(content);
}
else
{
return(null);
}
}
}
}
/// <summary>
/// gets a list of the additional cantrips the given subclass may choose from
/// </summary>
/// <param name="subclass">chosen subclass</param>
public List <Spell> getExtraSubclassCantripOptions(string subclass)
{
List <Spell> cantripList = new List <Spell>();
using (SQLiteConnection connection = new SQLiteConnection(ConnectionString))
using (SQLiteCommand command = new SQLiteCommand(connection))
{
connection.Open();
command.CommandText = "SELECT spells.name, spells.ritual, spells.level, spells.school, spells.castTime, spells.range, " +
"spells.duration, spells.components, spells.materials, spells.description FROM spells " +
"INNER JOIN books ON spells.book = books.bookid " +
"WHERE spells.level = 0 " +
"AND spells.classes LIKE \"%\" || " +
"(SELECT classes.name FROM extraSubclassCantrips " +
"INNER JOIN subclasses ON subclasses.subclassId = extraSubclassCantrips.subclassId " +
"INNER JOIN classes ON classes.classid = extraSubclassCantrips.classId " +
"WHERE subclasses.name = @Subclass) || \"%\" " +
"AND books.title IN(@UsedBooks)";
command.Parameters.AddWithValue("@Subclass", subclass);
SQLiteCommandExtensions.AddParametersWithValues(command, "@UsedBooks", UsedBooks);
using (SQLiteDataReader dbReader = command.ExecuteReader())
{
while (dbReader.Read())
{
if (!dbReader.IsDBNull(0))
{
cantripList.Add(new Spell(dbReader.GetString(0), dbReader.GetBoolean(1), dbReader.GetInt32(2), dbReader.GetString(3), dbReader.GetString(4), dbReader.GetString(5), dbReader.GetString(6), dbReader.GetString(7), dbReader.GetString(8), dbReader.GetString(9), false));
}
}
}
}
return(cantripList);
}
public IEnumerable <HangmanGameRecord> GetAll()
{
List <HangmanGameRecord> records = new List <HangmanGameRecord>();
using (SQLiteConnection connection = new SQLiteConnection(_ConnectionString))
{
try
{
connection.Open();
string q = "SELECT * FROM HangmanGameHistory";
using (SQLiteCommand cmd = new SQLiteCommand(q, connection))
{
using (SQLiteDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var word = reader.GetString(0);
bool won = reader.GetBoolean(1);
records.Add(new HangmanGameRecord(word, won));
}
}
}
}
catch (Exception)
{
throw;
}
}
return(records);
}
