/// Get a table from database.
public static System.Data.DataTable SelectDataTable(string sql, params System.Data.SQLite.SQLiteParameter[] arrayOfParameters)
{
if (!System.IO.File.Exists(DatabaseFilePath))
{
return(null);
}
using (System.Data.SQLite.SQLiteConnection cn = new System.Data.SQLite.SQLiteConnection(GetConnectionString()))
{
System.Data.DataTable dtReturn = new System.Data.DataTable();
using (System.Data.SQLite.SQLiteDataAdapter da = new System.Data.SQLite.SQLiteDataAdapter(sql, cn))
{
if ((arrayOfParameters?.Length ?? 0) > 0)
{
da.SelectCommand.Parameters.AddRange(arrayOfParameters);
}
cn.Open();
da.Fill(dtReturn);
}
/// Cannot use SQLiteDataReader in some cases.
//using (System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(sql, cn))
//{
// if ((arrayOfParameters?.Length ?? 0) > 0)
// { com.Parameters.AddRange(arrayOfParameters); }
// com.Connection.Open();
// using (System.Data.SQLite.SQLiteDataReader rdr = com.ExecuteReader())
// {
// dtReturn.Load(rdr);
// }
//}
return(dtReturn);
}
}
/// <summary>
/// Recupera registro de associacao pelo id do servidor
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <ServidorPublicacao> GetServidor(int id)
{
List <ServidorPublicacao> retorno = null;
using (var comm = new System.Data.SQLite.SQLiteCommand(sqliteConnection))
{
comm.CommandText = "SELECT t1.*," +
"t2.vhr_nome as vhr_nomeservidor " +
"FROM tba_servidor_publicacao t1 " +
"INNER JOIN tbl_servidor t2 ON t1.int_idfservidor = t2.int_idaservidor " +
"WHERE t1.int_idfservidor = " + id;
var adapter = new System.Data.SQLite.SQLiteDataAdapter(comm);
var dataTable = new System.Data.DataTable();
adapter.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
retorno = new List <ServidorPublicacao>();
foreach (DataRow linha in dataTable.Rows)
{
retorno.Add(new ServidorPublicacao(linha));
}
}
}
return(retorno);
}
public static DbDataAdapter GetDbDataAdapter(DbConnection conn)
{
DbDataAdapter da = null;
if (conn is System.Data.SqlClient.SqlConnection)
{
da = new System.Data.SqlClient.SqlDataAdapter();
}
if (conn is System.Data.OleDb.OleDbConnection)
{
da = new System.Data.OleDb.OleDbDataAdapter();
}
if (conn is Devart.Data.Oracle.OracleConnection)
{
da = new Devart.Data.Oracle.OracleDataAdapter();
}
if (conn is System.Data.SQLite.SQLiteConnection)
{
da = new System.Data.SQLite.SQLiteDataAdapter();
}
if (conn is MySql.Data.MySqlClient.MySqlConnection)
{
da = new MySql.Data.MySqlClient.MySqlDataAdapter();
}
return da;
}
/// <summary>
/// 执行查询返回DataTable
/// </summary>
/// <param name="sql">Sql语句</param>
/// <returns>成功返回DataTable,失败则返回 null</returns>
static public System.Data.DataTable ExecuteQueryToDataTable(string sql, System.Data.Common.DbConnection Conn)
{
if (Conn is System.Data.SQLite.SQLiteConnection)
{
var cmd = Conn.CreateCommand() as System.Data.SQLite.SQLiteCommand;
cmd.CommandText = sql;
cmd.CommandTimeout = 180;
var da = new System.Data.SQLite.SQLiteDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
if (Conn is OracleConnection)
{
var cmd = Conn.CreateCommand() as OracleCommand;
cmd.CommandText = sql;
cmd.CommandTimeout = 180;
var da = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
return(dt);
}
else
{
System.Data.DataTable dt = new System.Data.DataTable();
System.Data.IDataReader reader = ExecuteQuery(sql, Conn);
dt.Load(reader);
return(dt);
}
}//ExecuteQueryToDataTable(string sql)
public static List <String> DevKeys()
{
//list of keys to return
List <String> lst = new List <string>();
//create a dataset
System.Data.DataSet ds = new System.Data.DataSet();
//get a command object
using (System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(SqlLite.Connection))
{
//set the sql
cmd.CommandText = "SELECT value FROM " + SqlLite.DB_DEV_KEYS;
//create adapters
using (System.Data.SQLite.SQLiteDataAdapter adapter = new System.Data.SQLite.SQLiteDataAdapter(cmd))
{
//query
adapter.Fill(ds);
//get the keys
for (int i = 0; i < ds.Tables.Count; i++)
{
for (int j = 0; j < ds.Tables[i].Rows.Count; j++)
{
lst.Add(ds.Tables[i].Rows[j]["value"].ToString());
}
}
}
}
//return the list
return(lst);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataSet ds = new DataSet();
var connectionString = String.Format("Data Source={0};Version=3;", "./App_Data/Madera.db");
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection("data source=|DataDirectory|Madera.db"))
{
con.Open();
using (var cmd = con.CreateCommand())
{
gammeMaison.Items.Clear();
string query = "SELECT nom, id_gamme FROM gamme;";
cmd.CommandText = query;
System.Data.SQLite.SQLiteDataAdapter da = new System.Data.SQLite.SQLiteDataAdapter(cmd);
da.Fill(ds);
int i = 0;
while (i < ds.Tables[0].Rows.Count)
{
string nomGamme = ds.Tables[0].Rows[i].ItemArray[0].ToString();
string id_gamme = ds.Tables[0].Rows[i].ItemArray[1].ToString();
gammeMaison.Items.Add(new ListItem(nomGamme, id_gamme));
i++;
}
getModelesModules(new Object(), new EventArgs());
setEtage(new Object(), new EventArgs());
setPlan(new Object(), new EventArgs());
con.Close();
}
}
}
}
public void getModelesModules(object o, System.EventArgs arg)
{
DataSet ds = new DataSet();
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection("data source=|DataDirectory|Madera.db"))
{
con.Open();
using (var cmd = con.CreateCommand())
{
modeleMaison.Items.Clear();
string query = "SELECT id_modele_gamme, nom, nb_etage, forme " +
"FROM modele_gamme " +
"WHERE id_gamme = @idGamme;";
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@idGamme", gammeMaison.SelectedValue);
System.Data.SQLite.SQLiteDataAdapter da = new System.Data.SQLite.SQLiteDataAdapter(cmd);
da.Fill(ds);
int i = 0;
while (i < ds.Tables[0].Rows.Count)
{
string id_modele = ds.Tables[0].Rows[i].ItemArray[0].ToString();
string nomModele = ds.Tables[0].Rows[i].ItemArray[1].ToString();
string nbEtagesModele = ds.Tables[0].Rows[i].ItemArray[2].ToString();
string formeModele = ds.Tables[0].Rows[i].ItemArray[3].ToString();
modeleMaison.Items.Add(new ListItem(nomModele + " - " + nbEtagesModele + " étage(s) - " + formeModele, id_modele));
i++;
}
con.Close();
}
}
setEtage(new Object(), new EventArgs());
}
public static DataTable EseguiSQLDataTable(string sql, DbParameter[] param, DataColumn[] colonne = null)
{
var t = new DataTable();
if (colonne != null)
{
t.Columns.AddRange(colonne);
}
using (var cm = CreaCommandNoConnection(sql, param))
{
if (DataBaseAttuale == DataBase.Access)
{
using (var a = new System.Data.OleDb.OleDbDataAdapter((System.Data.OleDb.OleDbCommand)cm))
a.Fill(t);
}
else if (DataBaseAttuale == DataBase.SQLite)
#if __MonoCS__
{ using (var a = new Mono.Data.Sqlite.SqliteDataAdapter((Mono.Data.Sqlite.SqliteCommand)cm))
a.Fill(t); }
#else
{ using (var a = new System.Data.SQLite.SQLiteDataAdapter((System.Data.SQLite.SQLiteCommand)cm))
a.Fill(t); }
#endif
}
return(t);
}
public string[] ColumnNames()
{
bool wasopen = _isOpen;
if (!_isOpen)
{
Open();
}
List <string> names = new List <string>();
using (System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand("PRAGMA table_info([" + _tableName + "])", _connection))
{
System.Data.SQLite.SQLiteDataAdapter adap = new System.Data.SQLite.SQLiteDataAdapter(cmd);
System.Data.DataTable tab = new System.Data.DataTable();
adap.Fill(tab);
string typestring = "";
foreach (System.Data.DataRow r in tab.Rows)
{
typestring = (string)r[2];
if (!typestring.Contains("BLOB"))
{
names.Add((string)r[1]);
}
}
}
if (!wasopen)
{
Close();
}
return(names.ToArray());
}
private void LoadData()
{
taskDataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT * FROM events WHERE ID=" + id, connection);
alertsDataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT * FROM events_alerts WHERE event_id=" + id, connection);
dataSet = new System.Data.DataSet();
var taskCommandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(taskDataAdapter);
var alertsCommandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(alertsDataAdapter);
taskDataAdapter.Fill(dataSet, "event");
alertsDataAdapter.Fill(dataSet, "alerts");
var parentColumn = dataSet.Tables["event"].Columns["ID"];
{
var childColumn = dataSet.Tables["alerts"].Columns["event_id"];
var relation = new System.Data.DataRelation("event_alerts", parentColumn, childColumn);
dataSet.Relations.Add(relation);
}
//var table = dataSet.Tables["event"];
row = dataSet.Tables["event"].Rows[0];
dataSet.Tables["event"].RowChanged += table_RowChanged;
dataSet.Tables["alerts"].RowChanged += table_RowChanged;
dataSet.Tables["alerts"].RowDeleted += table_RowDeleted;
dataSet.Tables["alerts"].TableNewRow += table_TableNewRow;
FillDeadline(row);
FillTags(id);
TaskGrid.DataContext = dataSet.Tables["event"].DefaultView;
AlertsDataGrid.ItemsSource = dataSet.Tables["alerts"].DefaultView;
}
public string ReadDataRoles()
{
string data = "";
try
{
DataTable dtObj = new DataTable();
var conStingBuilder = new System.Data.SQLite.SQLiteConnectionStringBuilder();
conStingBuilder.DataSource = "C:/Users/INDIAN/Documents/DB/HighSchool";
var conObj = new System.Data.SQLite.SQLiteConnection(conStingBuilder.ConnectionString);
//System.Data.SQLite.SQLiteConnection conObj = new System.Data.SQLite.SQLiteConnection();
System.Data.SQLite.SQLiteCommand cmdObj = new System.Data.SQLite.SQLiteCommand("select * from roles;", conObj);
//SqliteDataAdapter daObj;
System.Data.SQLite.SQLiteDataAdapter dAdapter = new System.Data.SQLite.SQLiteDataAdapter(cmdObj);
dAdapter.Fill(dtObj);
foreach (DataRow i in dtObj.Rows)
{
data = data + i["RoleId"] + " " + i["RoleName"] + "\n";
}
}
catch (Exception ex)
{
data = "";
}
finally
{
//conTest.Close();
}
return(data);
}
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
var connectionString = String.Format("Data Source={0};Version=3;", "./App_Data/Madera.db");
using (System.Data.SQLite.SQLiteConnection con = new System.Data.SQLite.SQLiteConnection("data source=|DataDirectory|Madera.db"))
{
con.Open();
using (var cmd = con.CreateCommand())
{
string query = "select id_client, nom, prenom, mail from client;";
cmd.CommandText = query;
System.Data.SQLite.SQLiteDataAdapter da = new System.Data.SQLite.SQLiteDataAdapter(cmd);
da.Fill(ds);
int i = 0;
while (i < ds.Tables[0].Rows.Count)
{
string nom = ds.Tables[0].Rows[i].ItemArray[1].ToString();
string prenom = ds.Tables[0].Rows[i].ItemArray[2].ToString();
string mail = ds.Tables[0].Rows[i].ItemArray[3].ToString();
string id_client = ds.Tables[0].Rows[i].ItemArray[0].ToString();
client.Items.Add(new ListItem(nom + " " + prenom + " : " + mail, id_client));
i++;
}
con.Close();
}
}
}
private DataSet getDataSet(ref StringBuilder sbSql, string strConnection, out int intEffected)
{
intEffected = -1;
try {
connToDB = new System.Data.SQLite.SQLiteConnection(strConnection);
connToDB.Open();
}
catch (Exception ex) {
string msg = "Open Connection Exception / Check Connection String.";
throw new Exception(msg, ex);
}
DataSet dataSet = new DataSet();
try {
System.Data.SQLite.SQLiteDataAdapter dbAdapter = new System.Data.SQLite.SQLiteDataAdapter();
dbAdapter.SelectCommand = new System.Data.SQLite.SQLiteCommand(sbSql.ToString(), connToDB);
dbAdapter.FillLoadOption = LoadOption.PreserveChanges;
intEffected = dbAdapter.Fill(dataSet);
}
catch (Exception ex) {
throw (ex);
}
return(dataSet);
}
private void AllReport_Load(object sender, EventArgs e)
{
CrystalReport2 objRpt = new CrystalReport2();
string appPath = Path.GetDirectoryName(Application.ExecutablePath);
String ConnStr = @"Data Source=" + appPath + @"\dbcar.s3db ;Version=3;";
System.Data.SQLite.SQLiteConnection myConnection = new System.Data.SQLite.SQLiteConnection(ConnStr);
String Query1 = "SELECT * FROM Donaciones";
System.Data.SQLite.SQLiteDataAdapter adapter = new System.Data.SQLite.SQLiteDataAdapter(Query1, ConnStr);
DataSet Ds = new DataSet();
// here my_dt is the name of the DataTable which we
// created in the designer view.
adapter.Fill(Ds, "my_dt");
// Setting data source of our report object
objRpt.SetDataSource(Ds);
// Binding the crystalReportViewer with our report object.
this.crystalReportViewer1.ReportSource = objRpt;
objRpt.Refresh();
}
private void buttonImportData_Click(object sender, EventArgs e)
{
if (!datasource.Equals(""))
{
//建立SQLite连接
System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection();
System.Data.SQLite.SQLiteConnectionStringBuilder connstr = new System.Data.SQLite.SQLiteConnectionStringBuilder();
connstr.DataSource = datasource;
//connstr.Password = "******";
conn.ConnectionString = connstr.ToString();
conn.Open();
//执行查询语句
string sql = "select id,puid from camdevices";
System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();
cmd.CommandText = sql;
System.Data.SQLite.SQLiteDataAdapter dataAdapter = new System.Data.SQLite.SQLiteDataAdapter(sql, conn);
//填充架构及数据
dataAdapter.FillSchema(dataSet1, SchemaType.Source, "camdevices");
dataAdapter.Fill(dataSet1, "camdevices");
//清空dataGridView数据源
if (dataGridViewDb.DataSource != null && dataGridViewDb.DataSource != "")
{
dataGridViewDb.DataSource = "";
dataGridViewDb.Refresh();
}
//填充dataGridView
dataGridViewDb.DataSource = dataSet1.Tables[0];
//刷新映射表
if (puidmap.ToString() != null && puidmap.ToString() != "")
{
puidmap.Clear();
}
for (int i = 0; i < dataSet1.Tables[0].Rows.Count; i++)
{
puidmap.Add(dataSet1.Tables[0].Rows[i][0], dataSet1.Tables[0].Rows[i][1]);
}
conn.Close();
}
else
{
MessageBox.Show("请选择数据库文件");
return;
}
if (!excelsource.Equals(""))
{
if (dataGridViewExcel.DataSource != null && dataGridViewExcel.DataSource != "")
{
dataGridViewExcel.DataSource = "";
dataGridViewExcel.Refresh();
}
DataTable dt = ExcelInput(excelsource);
dataGridViewExcel.DataSource = dt;
}
else
{
MessageBox.Show("请选择模板文件");
return;
}
}
public static void DisposeSQLiteTableAdapterCommands(
System.Data.SQLite.SQLiteDataAdapter adapter)
{
foreach (object currentCommand_loopVariable in {
adapter.UpdateCommand,
adapter.InsertCommand,
adapter.DeleteCommand,
adapter.SelectCommand
})
public static void DisposeSQLiteTableAdapter(
System.Data.SQLite.SQLiteDataAdapter adapter)
{
if (adapter != null)
{
DisposeSQLiteTableAdapterCommands(adapter);
adapter.Dispose();
}
}
private void buttonSelectDbFolder_Click(object sender, EventArgs e)
{
string folder = "";
FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog();
if (folderBrowserDialog.ShowDialog() == DialogResult.OK)
{
folder = folderBrowserDialog.SelectedPath;
}
if (Directory.Exists(folder))
{
//文件夹及子文件夹下的所有文件的全路径
string[] files = Directory.GetFiles(folder, "*.db", SearchOption.AllDirectories);
for (int i = 0; i < files.Length; i++)
{
files[i] = Path.GetFileNameWithoutExtension(files[i]);//只取后缀
}
for (int i = 0; i < files.Count(); i++)
{
//建立SQLite连接
System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection();
System.Data.SQLite.SQLiteConnectionStringBuilder connstr = new System.Data.SQLite.SQLiteConnectionStringBuilder();
connstr.DataSource = files[i];
//connstr.Password = "******";
conn.ConnectionString = connstr.ToString();
conn.Open();
//执行查询语句
string sql = "select id,puid from camdevices";
System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();
cmd.CommandText = sql;
System.Data.SQLite.SQLiteDataAdapter dataAdapter = new System.Data.SQLite.SQLiteDataAdapter(sql, conn);
//填充架构及数据
dataAdapter.FillSchema(dataSet1, SchemaType.Source, "camdevices");
dataAdapter.Fill(dataSet1, "camdevices");
//清空dataGridView数据源
if (dataGridViewDb.DataSource != null && dataGridViewDb.DataSource != "")
{
dataGridViewDb.DataSource = "";
dataGridViewDb.Refresh();
}
//填充dataGridView
dataGridViewDb.DataSource = dataSet1.Tables[0];
//刷新映射表
if (puidmap.ToString() != null && puidmap.ToString() != "")
{
puidmap.Clear();
}
for (int j = 0; j < dataSet1.Tables[0].Rows.Count; j++)
{
puidmap.Add(dataSet1.Tables[0].Rows[i][0], dataSet1.Tables[0].Rows[i][1]);
}
conn.Close();
}
}
}
// void ImageFileReconciliation()
// {
// // This next line creates a list of strings that don't have images. Can be commented out!
// List<string> missingImages = new List<string>();
// // Creates the collection of functional groups.
// foreach (ChemInfo.FunctionalGroup temp in fGroups)
// {
// string filename = imagePath + "FunctionalGroups\\" + temp.Name.ToLower() + ".jpg";
// if (System.IO.File.Exists(filename)) temp.Image = System.Drawing.Image.FromFile(filename);
// //this line adds the missing image to the list of missing images. Can be commented out.
// else missingImages.Add(temp.Name);
// }
// // Writes the missing images to a file.
// // Write the string array to a new file named "WriteLines.txt".
// using (System.IO.StreamWriter outputFile = new System.IO.StreamWriter(documentPath + @"\MissingImages.txt"))
// {
// foreach (string line in missingImages)
// outputFile.WriteLine(line);
// }
// string[] imageFiles = System.IO.Directory.GetFiles(imagePath + "FunctionalGroups\\");
// string[] groupNames = fGroups.FunctionalGroups;
// List<string> extraImages = new List<string>();
// foreach (string name in imageFiles)
// {
// string temp = name.Replace(imagePath + "FunctionalGroups\\", string.Empty);
// temp = temp.Replace(".jpg", string.Empty);
// bool add = true;
// foreach (string gName in groupNames)
// {
// if (temp.ToUpper() == gName.ToUpper()) add = false;
// }
// if (add) extraImages.Add(temp);
// }
// // Write the string array to a new file named "WriteLines.txt".
// using (System.IO.StreamWriter outputFile = new System.IO.StreamWriter(imagePath + "FunctionalGroups\\" + @"\ExtraImages.txt"))
// {
// foreach (string line in extraImages)
// outputFile.WriteLine(line);
// }
// }
//}
// Code from https://stackoverflow.com/questions/20419630/saving-datatable-to-sqlite-database-by-adapter-update
public System.Data.DataTable GetDataTable(string tablename)
{
System.Data.DataTable DT = new System.Data.DataTable();
m_dbConnection.Open();
db_Command = m_dbConnection.CreateCommand();
db_Command.CommandText = string.Format("SELECT * FROM {0}", tablename);
db_Adapter = new System.Data.SQLite.SQLiteDataAdapter(db_Command);
db_Adapter.Fill(DT);
m_dbConnection.Close();
DT.TableName = tablename;
return(DT);
}
// Connection
#region Base de Datos
//Muestra los Datos en el DataGridView
//private Task MostrarDatosAsync() => Task.Run(() => {
// DataTable dataTable = new DataTable();
// string sql = "select * from TUsuario";
// System.Data.SQLite.SQLiteDataAdapter sQ =
// new System.Data.SQLite.SQLiteDataAdapter(sql, Clases.Conexion.Connection);
// sQ.Fill(dataTable);
// DGVUsuario.DataSource = dataTable;
// Clases.Conexion.Connection.Close();
// return true;
//});
private void MostrarDatosAsync()
{
DataTable dataTable = new DataTable();
string sql = "select * from TUsuario";
System.Data.SQLite.SQLiteDataAdapter sQ =
new System.Data.SQLite.SQLiteDataAdapter(sql, Clases.Conexion.Connection);
sQ.Fill(dataTable);
DGVUsuario.DataSource = dataTable;
Clases.Conexion.Connection.Close();
}
private void DataGrid_Initialized(object sender, System.EventArgs e)
{
connection = new System.Data.SQLite.SQLiteConnection("Data source=" + System.Environment.CurrentDirectory.ToString() + "\\ToDoAny.sqlite;Version=3;");
dataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT * FROM priorities", connection);
dataSet = new System.Data.DataSet();
dataAdapter.TableMappings.Add("priorities", "priorities");
var commandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(dataAdapter);
dataAdapter.Fill(dataSet, "priorities");
SourceDataTable = dataSet.Tables["priorities"];
}
public System.Collections.ArrayList GetContentModule()
{
using (this.getConnection)
{
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.IDbCommand cmd = this.conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "SELECT * FROM FW_Module WHERE M_Level = " + Framework.Entity.Module.CHILD + " AND M_Position = " + Framework.Entity.Module.CONTENT;
System.Data.IDbDataAdapter adapter = new System.Data.SQLite.SQLiteDataAdapter((System.Data.SQLite.SQLiteCommand)cmd);
adapter.Fill(ds);
return Framework.Class.PackageEntity.Package(new Framework.Entity.Module(), ds.Tables[0]);
}
}
public System.Collections.ArrayList GetTemplateByChapter(int cid)
{
using (this.getConnection)
{
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.IDbCommand cmd = this.conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "SELECT * FROM CB_Template WHERE C_Id = " + cid;
System.Data.IDbDataAdapter adapter = new System.Data.SQLite.SQLiteDataAdapter((System.Data.SQLite.SQLiteCommand)cmd);
adapter.Fill(ds);
return Framework.Class.PackageEntity.Package(new Framework.Entity.Template(), ds.Tables[0]);
}
}
public System.Collections.ArrayList GetContentModule()
{
using (this.getConnection)
{
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.IDbCommand cmd = this.conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "SELECT * FROM FW_Module WHERE M_Level = " + Framework.Entity.Module.CHILD + " AND M_Position = " + Framework.Entity.Module.CONTENT;
System.Data.IDbDataAdapter adapter = new System.Data.SQLite.SQLiteDataAdapter((System.Data.SQLite.SQLiteCommand)cmd);
adapter.Fill(ds);
return(Framework.Class.PackageEntity.Package(new Framework.Entity.Module(), ds.Tables[0]));
}
}
public System.Collections.ArrayList GetAllModel()
{
using (this.getConnection)
{
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.IDbCommand cmd = this.conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "SELECT * FROM CB_Model";
System.Data.IDbDataAdapter adapter = new System.Data.SQLite.SQLiteDataAdapter((System.Data.SQLite.SQLiteCommand)cmd);
adapter.Fill(ds);
return(Framework.Class.PackageEntity.Package(new Framework.Entity.Model(), ds.Tables[0]));
}
}
public System.Collections.ArrayList GetContentTemplateByTitle(string title)
{
using (this.getConnection)
{
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.IDbCommand cmd = this.conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "SELECT * FROM CB_Template WHERE C_Id IN ( SELECT C_Id FROM CB_Chapter WHERE C_Title = '" + title + "')";
System.Data.IDbDataAdapter adapter = new System.Data.SQLite.SQLiteDataAdapter((System.Data.SQLite.SQLiteCommand)cmd);
adapter.Fill(ds);
return(Framework.Class.PackageEntity.Package(new Framework.Entity.Template(), ds.Tables[0]));
}
}
public System.Collections.ArrayList GetChapterByPid(int pid, int type)
{
using (this.getConnection)
{
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.IDbCommand cmd = this.conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "SELECT * FROM CB_Chapter WHERE C_Pid = " + pid + " AND (C_Type=" + type + " OR C_Type='9')";
System.Data.IDbDataAdapter adapter = new System.Data.SQLite.SQLiteDataAdapter((System.Data.SQLite.SQLiteCommand)cmd);
adapter.Fill(ds);
return(Framework.Class.PackageEntity.Package(new Framework.Entity.Chapter(), ds.Tables[0]));
}
}
public System.Collections.ArrayList GetChapterByPid(int pid,int type)
{
using (this.getConnection)
{
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.IDbCommand cmd = this.conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "SELECT * FROM CB_Chapter WHERE C_Pid = " + pid + " AND (C_Type=" + type + " OR C_Type='9')";
System.Data.IDbDataAdapter adapter = new System.Data.SQLite.SQLiteDataAdapter((System.Data.SQLite.SQLiteCommand)cmd);
adapter.Fill(ds);
return Framework.Class.PackageEntity.Package(new Framework.Entity.Chapter(), ds.Tables[0]);
}
}
public void Load()
{
dataAdapter.Dispose();
dataSet.Dispose();
dataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT * FROM events", connection);
dataSet = new System.Data.DataSet();
var commandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(dataAdapter);
dataAdapter.Fill(dataSet, "events");
dataAdapter.AcceptChangesDuringUpdate = true;
MainDataGrid.ItemsSource = dataSet.Tables["events"].DefaultView;
}
private void loadDB()
{
string connectionString = $@"Data Source={DBFileName}";
System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection(connectionString);
System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand("select * from test limit 1");
cmd.Connection = conn;
conn.Open();
cmd.ExecuteScalar();
System.Data.SQLite.SQLiteDataAdapter da = new System.Data.SQLite.SQLiteDataAdapter(cmd);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
var table = ds.Tables[0];
minColWidth = new int[table.Columns.Count];
for (var colIndex = 0; colIndex < minColWidth.Length; colIndex++)
{
minColWidth[colIndex] = minWidth;
}
foreach (DataRow row in table.Rows)
{
for (var colIndex = 0; colIndex < minColWidth.Length; colIndex++)
{
minColWidth[colIndex] = Math.Max(minColWidth[colIndex], TextRenderer.MeasureText(row[colIndex].ToString(), gridControl1.Font).Width);
}
}
ReflectionDictionary dict = new ReflectionDictionary();
XpoDefault.Dictionary = dict;
XPClassInfo classInfo = new XPDataObjectClassInfo(dict, "Test", new Attribute[] { new OptimisticLockingAttribute(false), new DeferredDeletionAttribute(false) });
List <string> colNames = new List <string>();
foreach (DataColumn col in table.Columns)
{
colNames.Add(col.ColumnName);
classInfo.CreateMember(col.ColumnName, col.DataType);
}
classInfo.GetMember("id").AddAttribute(new KeyAttribute());
XPInstantFeedbackSource instantDS = new XPInstantFeedbackSource(classInfo);
instantDS.ResolveSession += instantDS_ResolveSession;
instantDS.DismissSession += instantDS_DismissSession;
gridView.Columns.Clear();
gridControl1.DataSource = instantDS;
gridControl1.Refresh();
btnBestFirColumns.PerformClick();
}
private void LoadData()
{
taskDataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT * FROM tasks WHERE ID=" + id, connection);
alertsDataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT * FROM tasks_alerts WHERE task_id=" + id, connection);
subTasksDataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT ID, child_of, name FROM tasks WHERE child_of=" + id, connection);
dataSet = new System.Data.DataSet();
var taskCommandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(taskDataAdapter);
var alertsCommandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(alertsDataAdapter);
var subTasksCommandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(subTasksDataAdapter);
taskDataAdapter.Fill(dataSet, "task");
taskDataAdapter.AcceptChangesDuringUpdate = true;
alertsDataAdapter.Fill(dataSet, "alerts");
alertsDataAdapter.AcceptChangesDuringUpdate = true;
subTasksDataAdapter.Fill(dataSet, "sub_tasks");
subTasksDataAdapter.AcceptChangesDuringUpdate = true;
var parentColumn = dataSet.Tables["task"].Columns["ID"];
{
var childColumn = dataSet.Tables["alerts"].Columns["task_id"];
var relation = new System.Data.DataRelation("task_alerts", parentColumn, childColumn);
dataSet.Relations.Add(relation);
}
{
var childColumn = dataSet.Tables["sub_tasks"].Columns["child_of"];
var relation = new System.Data.DataRelation("task_sub_tasks", parentColumn, childColumn);
dataSet.Relations.Add(relation);
}
row = dataSet.Tables["task"].Rows[0];
dataSet.Tables["task"].RowChanged += table_RowChanged;
dataSet.Tables["alerts"].RowChanged += table_RowChanged;
dataSet.Tables["alerts"].RowDeleted += table_RowDeleted;
dataSet.Tables["alerts"].TableNewRow += table_TableNewRow;
dataSet.Tables["sub_tasks"].RowChanged += table_RowChanged;
dataSet.Tables["sub_tasks"].RowDeleted += table_RowDeleted;
dataSet.Tables["sub_tasks"].TableNewRow += table_TableNewRow;
FillDeadline(row);
FillTags(id);
TaskGrid.DataContext = dataSet.Tables["task"].DefaultView;
AlertsDataGrid.ItemsSource = dataSet.Tables["alerts"].DefaultView;
SubTasksDataGrid.ItemsSource = dataSet.Tables["sub_tasks"].DefaultView;
FillPrioritiesComboBox();
}
/// <summary>
/// Disposes a TableAdapter generated by SQLite Designer
/// </summary>
/// <param name="disposing"></param>
/// <param name="adapter"></param>
/// <param name="commandCollection"></param>
/// <remarks>You must dispose all the command,
/// otherwise the file remains locked and cannot be accessed
/// (for example, for reading or deletion)</remarks>
public static void DisposeTableAdapter(
bool disposing,
System.Data.SQLite.SQLiteDataAdapter adapter,
IEnumerable <System.Data.SQLite.SQLiteCommand> commandCollection)
{
if (disposing)
{
DisposeSQLiteTableAdapter(adapter);
foreach (object currentCommand_loopVariable in commandCollection)
{
currentCommand = currentCommand_loopVariable;
currentCommand.Dispose();
}
}
}
public string ReadDataPerson()
{
var connectionStringBuilder = new SqliteConnectionStringBuilder();
connectionStringBuilder.DataSource = "C:/Users/INDIAN/Documents/DB/HighSchool";
var conTest = new SqliteConnection(connectionStringBuilder.ConnectionString);
string data = "";
try
{
DataTable dtObj = new DataTable();
var conStingBuilder = new System.Data.SQLite.SQLiteConnectionStringBuilder();
conStingBuilder.DataSource = "C:/Users/INDIAN/Documents/DB/HighSchool";
var conObj = new System.Data.SQLite.SQLiteConnection(conStingBuilder.ConnectionString);
//System.Data.SQLite.SQLiteConnection conObj = new System.Data.SQLite.SQLiteConnection();
System.Data.SQLite.SQLiteCommand cmdObj = new System.Data.SQLite.SQLiteCommand("select * from person;", conObj);
//SqliteDataAdapter daObj;
System.Data.SQLite.SQLiteDataAdapter dAdapter = new System.Data.SQLite.SQLiteDataAdapter(cmdObj);
dAdapter.Fill(dtObj);
foreach (DataRow i in dtObj.Rows)
{
data = data + i["PersonID"] + " " + i["FirstName"] + " " + i["LastName"] + " " + i["UserPassword"] + " " + i["RoleId"] + " " + i["Gender"] + " " + i["DateOfBirth"] + " " + i["Address"] + "\n";
}
//conTest.Open();
//data = "";
//var selectCmd = conTest.CreateCommand();
//selectCmd.CommandText = "select * from person;";
//SqliteDataReader rObj = null;
//rObj = selectCmd.ExecuteReader(CommandBehavior.CloseConnection);
//while (rObj.Read())
//{
// data = "\n" + data + rObj["PersonID"] + " " + rObj["FirstName"] + " " + rObj["LastName"] + " " + rObj["UserPassword"] + " " + rObj["RoleId"] + " " + rObj["Gender"] + " " + rObj["DateOfBirth"] + " " + rObj["Address"];
//}
}
catch (Exception ex)
{
data = "";
}
finally
{
//conTest.Close();
}
return(data);
}
public void SaveDataTable(System.Data.DataTable DT)
{
try
{
m_dbConnection.Open();
db_Command = m_dbConnection.CreateCommand();
db_Command.CommandText = string.Format("SELECT * FROM {0}", DT.TableName);
db_Adapter = new System.Data.SQLite.SQLiteDataAdapter(db_Command);
System.Data.SQLite.SQLiteCommandBuilder builder = new System.Data.SQLite.SQLiteCommandBuilder(db_Adapter);
db_Adapter.Update(DT);
m_dbConnection.Close();
}
catch (Exception Ex)
{
System.Windows.Forms.MessageBox.Show(Ex.Message);
}
}
/// <summary>
/// Recupera registro de tipo ato pelo nome
/// </summary>
/// <param name="nome"></param>
/// <returns></returns>
public TipoAto Get(String nome)
{
TipoAto retorno = null;
using (var comm = new System.Data.SQLite.SQLiteCommand(sqliteConnection))
{
comm.CommandText = "SELECT * FROM tbl_tipoato WHERE vhr_nome = '" + nome + "'";
var adapter = new System.Data.SQLite.SQLiteDataAdapter(comm);
var dataTable = new System.Data.DataTable();
adapter.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
retorno = new TipoAto(dataTable.Rows[0]);
}
}
return(retorno);
}
public DataTable TestQuery(string Query)
{
using (System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection(this.ConnStr)) {
conn.Open();
using (System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand()) {
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = Query;
DataTable dt = new DataTable();
using (System.Data.SQLite.SQLiteDataAdapter da = new System.Data.SQLite.SQLiteDataAdapter(cmd)) {
da.Fill(dt);
}
conn.Close();
return(dt);
}
}
}
public void Load()
{
dataAdapter.Dispose();
dataSet.Dispose();
dataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT *, CASE WHEN child_of IS NULL THEN ID ELSE CHILD_OF END AS SORT1, CASE WHEN child_of IS NULL THEN 1 ELSE 2 END AS SORT2 FROM tasks ORDER BY SORT1 ASC, SORT2 ASC", connection);
dataSet = new System.Data.DataSet();
var commandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(dataAdapter);
dataAdapter.Fill(dataSet, "task");
dataAdapter.AcceptChangesDuringUpdate = true;
MainDataGrid.ItemsSource = dataSet.Tables["task"].DefaultView;
foreach (System.Data.DataRowView x in MainDataGrid.Items)
{
if (x.Row[1].ToString().Length > 0)
x.Row[2] = ">"+x.Row[2];
}
}
System.Data.DataTable DB.IDB.ExecuteToTable(string sql, System.Data.IDbDataParameter[] pars)
{
System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();
cmd.Connection = conn;
cmd.Transaction = tran;
cmd.CommandTimeout = 8000;
System.Data.SQLite.SQLiteDataAdapter da = new System.Data.SQLite.SQLiteDataAdapter();
da.SelectCommand = cmd;
cmd.CommandText = sql;
if (pars != null)
{
cmd.Parameters.AddRange(pars);
}
//
System.Data.DataTable dt = new System.Data.DataTable();
da.Fill(dt);
return(dt);
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
//Get top priority
System.Data.SQLite.SQLiteDataAdapter DA = new System.Data.SQLite.SQLiteDataAdapter("SELECT * FROM priorities WHERE active=1 LIMIT 1", connection);
System.Data.DataSet DS = new System.Data.DataSet();
var commandBuilder = new System.Data.SQLite.SQLiteCommandBuilder(DA);
DA.Fill(DS, "priorities");
long priorityID = 1;
try
{
priorityID = (long)DS.Tables["priorities"].Rows[0]["ID"];
}
catch { priorityID = 1; }
//Add row and save
dataSet.Tables["task"].Rows.Add(System.DBNull.Value, System.DBNull.Value, NewTaskName.Text, System.DBNull.Value, priorityID, System.DBNull.Value);
NewTaskName.Text = "";
Save();
Load();
}
public MainForm()
{
//
// The InitializeComponent() call is required for Windows Forms designer support.
//
InitializeComponent();
RssCache = new List<RssCacheItem>();
try {
this.AppDataPath = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData);
if (!System.IO.Directory.Exists(this.AppDataPath + "\\BmReader")){
System.IO.Directory.CreateDirectory(this.AppDataPath + "\\BmReader");
}
this.AppDataPath += "\\BmReader";
if (!System.IO.File.Exists(this.AppDataPath + "\\data.db")){
//System.Data.SQLite.SQLiteConnection.CreateFile(this.AppDataPath + "\\data.db");
}
conn =
new System.Data.SQLite.SQLiteConnection(String.Format("Data Source={0};Version=3;", this.AppDataPath + "\\data.db"));
conn.Open();
if(conn.GetSchema("Tables",new string[]{null, null, "URLRSS", null}).Rows.Count == 0){
System.Data.SQLite.SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = "CREATE TABLE URLRSS (id integer primary key, Url CHAR(1000), active Boolean true)";
cmd.ExecuteNonQuery();
}
System.Data.SQLite.SQLiteDataAdapter da = new System.Data.SQLite.SQLiteDataAdapter("select * from urlrss", conn);
System.Data.SQLite.SQLiteCommandBuilder cb = new System.Data.SQLite.SQLiteCommandBuilder(da);
LoadFeeds();
} catch (Exception err){
MessageBox.Show(err.Message);
Application.Exit();
}
}
void BtnImportClick(object sender, EventArgs e)
{
XDocument xOpml = null;
try {
using (OpenFileDialog dlgOpen = new OpenFileDialog()){
if(dlgOpen.ShowDialog(this).Equals(DialogResult.OK))
{
StreamReader sr = new StreamReader(dlgOpen.FileName);
xOpml = XDocument.Parse(sr.ReadToEnd());
}
}
} catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (xOpml != null){
var outlines = xOpml.Element("opml").Element("body").Descendants("outline");
var feeds = outlines.Where(ot => ot.Attribute("xmlUrl") != null).ToList();
int x = feeds.Count();
ClearFeeds();
System.Data.SQLite.SQLiteDataAdapter da = new System.Data.SQLite.SQLiteDataAdapter("select * from urlrss", conn);
System.Data.SQLite.SQLiteCommandBuilder cb = new System.Data.SQLite.SQLiteCommandBuilder(da);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
foreach(var feed in feeds)
{
System.Data.DataRow dr = ds.Tables[0].NewRow();
dr["Url"] = feed.Attribute("xmlUrl").Value;
ds.Tables[0].Rows.Add(dr);
}
da.Update(ds);
}
}
void LoadFeeds()
{
System.Data.SQLite.SQLiteDataAdapter da = new System.Data.SQLite.SQLiteDataAdapter("select * from urlrss", conn);
System.Data.SQLite.SQLiteCommandBuilder cb = new System.Data.SQLite.SQLiteCommandBuilder(da);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
System.Data.DataRowCollection dr = ds.Tables[0].Rows;
tvFeeds.Nodes.Clear();
foreach (System.Data.DataRow d in dr){
tvFeeds.Nodes.Add(d["id"].ToString(),d["Url"].ToString());
}
}
private void InitAdapter() {
this._adapter = new System.Data.SQLite.SQLiteDataAdapter();
System.Data.Common.DataTableMapping tableMapping = new System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "Data";
tableMapping.ColumnMappings.Add("oui", "oui");
tableMapping.ColumnMappings.Add("totalpacketsweak", "totalpacketsweak");
tableMapping.ColumnMappings.Add("totalpacketstotal", "totalpacketstotal");
tableMapping.ColumnMappings.Add("totalpacketsllc", "totalpacketsllc");
tableMapping.ColumnMappings.Add("totalpacketsdupeiv", "totalpacketsdupeiv");
tableMapping.ColumnMappings.Add("totalpacketsdata", "totalpacketsdata");
tableMapping.ColumnMappings.Add("totalpacketscrypt", "totalpacketscrypt");
tableMapping.ColumnMappings.Add("Network", "Network");
tableMapping.ColumnMappings.Add("NetType", "NetType");
tableMapping.ColumnMappings.Add("ESSID", "ESSID");
tableMapping.ColumnMappings.Add("BSSID", "BSSID");
tableMapping.ColumnMappings.Add("Info", "Info");
tableMapping.ColumnMappings.Add("Channel", "Channel");
tableMapping.ColumnMappings.Add("Cloaked", "Cloaked");
tableMapping.ColumnMappings.Add("Encryption", "Encryption");
tableMapping.ColumnMappings.Add("Decrypted", "Decrypted");
tableMapping.ColumnMappings.Add("MaxRate", "MaxRate");
tableMapping.ColumnMappings.Add("MaxSeenRate", "MaxSeenRate");
tableMapping.ColumnMappings.Add("Beacon", "Beacon");
tableMapping.ColumnMappings.Add("LLC", "LLC");
tableMapping.ColumnMappings.Add("Data", "Data");
tableMapping.ColumnMappings.Add("Crypt", "Crypt");
tableMapping.ColumnMappings.Add("Weak", "Weak");
tableMapping.ColumnMappings.Add("Total", "Total");
tableMapping.ColumnMappings.Add("Carrier", "Carrier");
tableMapping.ColumnMappings.Add("Encoding", "Encoding");
tableMapping.ColumnMappings.Add("FirstTime", "FirstTime");
tableMapping.ColumnMappings.Add("LastTime", "LastTime");
tableMapping.ColumnMappings.Add("BestQuality", "BestQuality");
tableMapping.ColumnMappings.Add("BestSignal", "BestSignal");
tableMapping.ColumnMappings.Add("BestNoise", "BestNoise");
tableMapping.ColumnMappings.Add("GPSMinLat", "GPSMinLat");
tableMapping.ColumnMappings.Add("GPSMinLon", "GPSMinLon");
tableMapping.ColumnMappings.Add("GPSMinAlt", "GPSMinAlt");
tableMapping.ColumnMappings.Add("GPSMinSpd", "GPSMinSpd");
tableMapping.ColumnMappings.Add("GPSMaxLat", "GPSMaxLat");
tableMapping.ColumnMappings.Add("GPSMaxLon", "GPSMaxLon");
tableMapping.ColumnMappings.Add("GPSMaxAlt", "GPSMaxAlt");
tableMapping.ColumnMappings.Add("GPSMaxSpd", "GPSMaxSpd");
tableMapping.ColumnMappings.Add("GPSBestLat", "GPSBestLat");
tableMapping.ColumnMappings.Add("GPSBestLon", "GPSBestLon");
tableMapping.ColumnMappings.Add("GPSBestAlt", "GPSBestAlt");
tableMapping.ColumnMappings.Add("Datasize", "Datasize");
tableMapping.ColumnMappings.Add("IPType", "IPType");
tableMapping.ColumnMappings.Add("IP", "IP");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new System.Data.SQLite.SQLiteCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM [Data] WHERE (((@IsNull_oui = 1 AND [oui] IS NULL) OR ([oui] = @Origi" +
"nal_oui)) AND ((@IsNull_totalpacketsweak = 1 AND [totalpacketsweak] IS NULL) OR " +
"([totalpacketsweak] = @Original_totalpacketsweak)) AND ((@IsNull_totalpacketstot" +
"al = 1 AND [totalpacketstotal] IS NULL) OR ([totalpacketstotal] = @Original_tota" +
"lpacketstotal)) AND ((@IsNull_totalpacketsllc = 1 AND [totalpacketsllc] IS NULL)" +
" OR ([totalpacketsllc] = @Original_totalpacketsllc)) AND ((@IsNull_totalpacketsd" +
"upeiv = 1 AND [totalpacketsdupeiv] IS NULL) OR ([totalpacketsdupeiv] = @Original" +
"_totalpacketsdupeiv)) AND ((@IsNull_totalpacketsdata = 1 AND [totalpacketsdata] " +
"IS NULL) OR ([totalpacketsdata] = @Original_totalpacketsdata)) AND ((@IsNull_tot" +
"alpacketscrypt = 1 AND [totalpacketscrypt] IS NULL) OR ([totalpacketscrypt] = @O" +
"riginal_totalpacketscrypt)) AND ((@IsNull_Network = 1 AND [Network] IS NULL) OR " +
"([Network] = @Original_Network)) AND ((@IsNull_NetType = 1 AND [NetType] IS NULL" +
") OR ([NetType] = @Original_NetType)) AND ((@IsNull_ESSID = 1 AND [ESSID] IS NUL" +
"L) OR ([ESSID] = @Original_ESSID)) AND ([BSSID] = @Original_BSSID) AND ((@IsNull" +
"_Info = 1 AND [Info] IS NULL) OR ([Info] = @Original_Info)) AND ((@IsNull_Channe" +
"l = 1 AND [Channel] IS NULL) OR ([Channel] = @Original_Channel)) AND ((@IsNull_C" +
"loaked = 1 AND [Cloaked] IS NULL) OR ([Cloaked] = @Original_Cloaked)) AND ((@IsN" +
"ull_Encryption = 1 AND [Encryption] IS NULL) OR ([Encryption] = @Original_Encryp" +
"tion)) AND ((@IsNull_Decrypted = 1 AND [Decrypted] IS NULL) OR ([Decrypted] = @O" +
"riginal_Decrypted)) AND ((@IsNull_MaxRate = 1 AND [MaxRate] IS NULL) OR ([MaxRat" +
"e] = @Original_MaxRate)) AND ((@IsNull_MaxSeenRate = 1 AND [MaxSeenRate] IS NULL" +
") OR ([MaxSeenRate] = @Original_MaxSeenRate)) AND ((@IsNull_Beacon = 1 AND [Beac" +
"on] IS NULL) OR ([Beacon] = @Original_Beacon)) AND ((@IsNull_LLC = 1 AND [LLC] I" +
"S NULL) OR ([LLC] = @Original_LLC)) AND ((@IsNull_Data = 1 AND [Data] IS NULL) O" +
"R ([Data] = @Original_Data)) AND ((@IsNull_Crypt = 1 AND [Crypt] IS NULL) OR ([C" +
"rypt] = @Original_Crypt)) AND ((@IsNull_Weak = 1 AND [Weak] IS NULL) OR ([Weak] " +
"= @Original_Weak)) AND ((@IsNull_Total = 1 AND [Total] IS NULL) OR ([Total] = @O" +
"riginal_Total)) AND ((@IsNull_Carrier = 1 AND [Carrier] IS NULL) OR ([Carrier] =" +
" @Original_Carrier)) AND ((@IsNull_Encoding = 1 AND [Encoding] IS NULL) OR ([Enc" +
"oding] = @Original_Encoding)) AND ((@IsNull_FirstTime = 1 AND [FirstTime] IS NUL" +
"L) OR ([FirstTime] = @Original_FirstTime)) AND ((@IsNull_LastTime = 1 AND [LastT" +
"ime] IS NULL) OR ([LastTime] = @Original_LastTime)) AND ((@IsNull_BestQuality = " +
"1 AND [BestQuality] IS NULL) OR ([BestQuality] = @Original_BestQuality)) AND ((@" +
"IsNull_BestSignal = 1 AND [BestSignal] IS NULL) OR ([BestSignal] = @Original_Bes" +
"tSignal)) AND ((@IsNull_BestNoise = 1 AND [BestNoise] IS NULL) OR ([BestNoise] =" +
" @Original_BestNoise)) AND ((@IsNull_GPSMinLat = 1 AND [GPSMinLat] IS NULL) OR (" +
"[GPSMinLat] = @Original_GPSMinLat)) AND ((@IsNull_GPSMinLon = 1 AND [GPSMinLon] " +
"IS NULL) OR ([GPSMinLon] = @Original_GPSMinLon)) AND ((@IsNull_GPSMinAlt = 1 AND" +
" [GPSMinAlt] IS NULL) OR ([GPSMinAlt] = @Original_GPSMinAlt)) AND ((@IsNull_GPSM" +
"inSpd = 1 AND [GPSMinSpd] IS NULL) OR ([GPSMinSpd] = @Original_GPSMinSpd)) AND (" +
"(@IsNull_GPSMaxLat = 1 AND [GPSMaxLat] IS NULL) OR ([GPSMaxLat] = @Original_GPSM" +
"axLat)) AND ((@IsNull_GPSMaxLon = 1 AND [GPSMaxLon] IS NULL) OR ([GPSMaxLon] = @" +
"Original_GPSMaxLon)) AND ((@IsNull_GPSMaxAlt = 1 AND [GPSMaxAlt] IS NULL) OR ([G" +
"PSMaxAlt] = @Original_GPSMaxAlt)) AND ((@IsNull_GPSMaxSpd = 1 AND [GPSMaxSpd] IS" +
" NULL) OR ([GPSMaxSpd] = @Original_GPSMaxSpd)) AND ((@IsNull_GPSBestLat = 1 AND " +
"[GPSBestLat] IS NULL) OR ([GPSBestLat] = @Original_GPSBestLat)) AND ((@IsNull_GP" +
"SBestLon = 1 AND [GPSBestLon] IS NULL) OR ([GPSBestLon] = @Original_GPSBestLon))" +
" AND ((@IsNull_GPSBestAlt = 1 AND [GPSBestAlt] IS NULL) OR ([GPSBestAlt] = @Orig" +
"inal_GPSBestAlt)) AND ((@IsNull_Datasize = 1 AND [Datasize] IS NULL) OR ([Datasi" +
"ze] = @Original_Datasize)) AND ((@IsNull_IPType = 1 AND [IPType] IS NULL) OR ([I" +
"PType] = @Original_IPType)) AND ((@IsNull_IP = 1 AND [IP] IS NULL) OR ([IP] = @O" +
"riginal_IP)))";
this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
System.Data.SQLite.SQLiteParameter param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_oui";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "oui";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_oui";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "oui";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_totalpacketsweak";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "totalpacketsweak";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_totalpacketsweak";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsweak";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_totalpacketstotal";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "totalpacketstotal";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_totalpacketstotal";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketstotal";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_totalpacketsllc";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "totalpacketsllc";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_totalpacketsllc";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsllc";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_totalpacketsdupeiv";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "totalpacketsdupeiv";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_totalpacketsdupeiv";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsdupeiv";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_totalpacketsdata";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "totalpacketsdata";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_totalpacketsdata";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsdata";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_totalpacketscrypt";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "totalpacketscrypt";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_totalpacketscrypt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketscrypt";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Network";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Network";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Network";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Network";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_NetType";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "NetType";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_NetType";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "NetType";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_ESSID";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "ESSID";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_ESSID";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "ESSID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_BSSID";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "BSSID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Info";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Info";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Info";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Info";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Channel";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Channel";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Channel";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Channel";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Cloaked";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Cloaked";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Cloaked";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Cloaked";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Encryption";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Encryption";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Encryption";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Encryption";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Decrypted";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Decrypted";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Decrypted";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Decrypted";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_MaxRate";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "MaxRate";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_MaxRate";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "MaxRate";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_MaxSeenRate";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "MaxSeenRate";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_MaxSeenRate";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "MaxSeenRate";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Beacon";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Beacon";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Beacon";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Beacon";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_LLC";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "LLC";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_LLC";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "LLC";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Data";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Data";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Data";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Data";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Crypt";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Crypt";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Crypt";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Crypt";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Weak";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Weak";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Weak";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Weak";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Total";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Total";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Total";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Total";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Carrier";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Carrier";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Carrier";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Carrier";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Encoding";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Encoding";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Encoding";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Encoding";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_FirstTime";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "FirstTime";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_FirstTime";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "FirstTime";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_LastTime";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "LastTime";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_LastTime";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "LastTime";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_BestQuality";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "BestQuality";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_BestQuality";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "BestQuality";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_BestSignal";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "BestSignal";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_BestSignal";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "BestSignal";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_BestNoise";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "BestNoise";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_BestNoise";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "BestNoise";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMinLat";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMinLat";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMinLat";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinLat";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMinLon";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMinLon";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMinLon";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinLon";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMinAlt";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMinAlt";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMinAlt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinAlt";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMinSpd";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMinSpd";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMinSpd";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinSpd";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMaxLat";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMaxLat";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMaxLat";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxLat";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMaxLon";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMaxLon";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMaxLon";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxLon";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMaxAlt";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMaxAlt";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMaxAlt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxAlt";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMaxSpd";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMaxSpd";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMaxSpd";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxSpd";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSBestLat";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSBestLat";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSBestLat";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSBestLat";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSBestLon";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSBestLon";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSBestLon";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSBestLon";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSBestAlt";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSBestAlt";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSBestAlt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSBestAlt";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Datasize";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Datasize";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Datasize";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Datasize";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_IPType";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "IPType";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_IPType";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "IPType";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_IP";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "IP";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.DeleteCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_IP";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "IP";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.DeleteCommand.Parameters.Add(param);
this._adapter.InsertCommand = new System.Data.SQLite.SQLiteCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = @"INSERT INTO [Data] ([oui], [totalpacketsweak], [totalpacketstotal], [totalpacketsllc], [totalpacketsdupeiv], [totalpacketsdata], [totalpacketscrypt], [Network], [NetType], [ESSID], [BSSID], [Info], [Channel], [Cloaked], [Encryption], [Decrypted], [MaxRate], [MaxSeenRate], [Beacon], [LLC], [Data], [Crypt], [Weak], [Total], [Carrier], [Encoding], [FirstTime], [LastTime], [BestQuality], [BestSignal], [BestNoise], [GPSMinLat], [GPSMinLon], [GPSMinAlt], [GPSMinSpd], [GPSMaxLat], [GPSMaxLon], [GPSMaxAlt], [GPSMaxSpd], [GPSBestLat], [GPSBestLon], [GPSBestAlt], [Datasize], [IPType], [IP]) VALUES (@oui, @totalpacketsweak, @totalpacketstotal, @totalpacketsllc, @totalpacketsdupeiv, @totalpacketsdata, @totalpacketscrypt, @Network, @NetType, @ESSID, @BSSID, @Info, @Channel, @Cloaked, @Encryption, @Decrypted, @MaxRate, @MaxSeenRate, @Beacon, @LLC, @Data, @Crypt, @Weak, @Total, @Carrier, @Encoding, @FirstTime, @LastTime, @BestQuality, @BestSignal, @BestNoise, @GPSMinLat, @GPSMinLon, @GPSMinAlt, @GPSMinSpd, @GPSMaxLat, @GPSMaxLon, @GPSMaxAlt, @GPSMaxSpd, @GPSBestLat, @GPSBestLon, @GPSBestAlt, @Datasize, @IPType, @IP)";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@oui";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "oui";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@totalpacketsweak";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsweak";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@totalpacketstotal";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketstotal";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@totalpacketsllc";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsllc";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@totalpacketsdupeiv";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsdupeiv";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@totalpacketsdata";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsdata";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@totalpacketscrypt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketscrypt";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Network";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Network";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@NetType";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "NetType";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@ESSID";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "ESSID";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@BSSID";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "BSSID";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Info";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Info";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Channel";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Channel";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Cloaked";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Cloaked";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Encryption";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Encryption";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Decrypted";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Decrypted";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@MaxRate";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "MaxRate";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@MaxSeenRate";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "MaxSeenRate";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Beacon";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Beacon";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@LLC";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "LLC";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Data";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Data";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Crypt";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Crypt";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Weak";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Weak";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Total";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Total";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Carrier";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Carrier";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Encoding";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Encoding";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@FirstTime";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "FirstTime";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@LastTime";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "LastTime";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@BestQuality";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "BestQuality";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@BestSignal";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "BestSignal";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@BestNoise";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "BestNoise";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMinLat";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinLat";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMinLon";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinLon";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMinAlt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinAlt";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMinSpd";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinSpd";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMaxLat";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxLat";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMaxLon";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxLon";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMaxAlt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxAlt";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMaxSpd";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxSpd";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSBestLat";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSBestLat";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSBestLon";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSBestLon";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSBestAlt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSBestAlt";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Datasize";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Datasize";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IPType";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "IPType";
this._adapter.InsertCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IP";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "IP";
this._adapter.InsertCommand.Parameters.Add(param);
this._adapter.UpdateCommand = new System.Data.SQLite.SQLiteCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = "UPDATE [Data] SET [oui] = @oui, [totalpacketsweak] = @totalpacketsweak, [totalpac" +
"ketstotal] = @totalpacketstotal, [totalpacketsllc] = @totalpacketsllc, [totalpac" +
"ketsdupeiv] = @totalpacketsdupeiv, [totalpacketsdata] = @totalpacketsdata, [tota" +
"lpacketscrypt] = @totalpacketscrypt, [Network] = @Network, [NetType] = @NetType," +
" [ESSID] = @ESSID, [BSSID] = @BSSID, [Info] = @Info, [Channel] = @Channel, [Cloa" +
"ked] = @Cloaked, [Encryption] = @Encryption, [Decrypted] = @Decrypted, [MaxRate]" +
" = @MaxRate, [MaxSeenRate] = @MaxSeenRate, [Beacon] = @Beacon, [LLC] = @LLC, [Da" +
"ta] = @Data, [Crypt] = @Crypt, [Weak] = @Weak, [Total] = @Total, [Carrier] = @Ca" +
"rrier, [Encoding] = @Encoding, [FirstTime] = @FirstTime, [LastTime] = @LastTime," +
" [BestQuality] = @BestQuality, [BestSignal] = @BestSignal, [BestNoise] = @BestNo" +
"ise, [GPSMinLat] = @GPSMinLat, [GPSMinLon] = @GPSMinLon, [GPSMinAlt] = @GPSMinAl" +
"t, [GPSMinSpd] = @GPSMinSpd, [GPSMaxLat] = @GPSMaxLat, [GPSMaxLon] = @GPSMaxLon," +
" [GPSMaxAlt] = @GPSMaxAlt, [GPSMaxSpd] = @GPSMaxSpd, [GPSBestLat] = @GPSBestLat," +
" [GPSBestLon] = @GPSBestLon, [GPSBestAlt] = @GPSBestAlt, [Datasize] = @Datasize," +
" [IPType] = @IPType, [IP] = @IP WHERE (((@IsNull_oui = 1 AND [oui] IS NULL) OR (" +
"[oui] = @Original_oui)) AND ((@IsNull_totalpacketsweak = 1 AND [totalpacketsweak" +
"] IS NULL) OR ([totalpacketsweak] = @Original_totalpacketsweak)) AND ((@IsNull_t" +
"otalpacketstotal = 1 AND [totalpacketstotal] IS NULL) OR ([totalpacketstotal] = " +
"@Original_totalpacketstotal)) AND ((@IsNull_totalpacketsllc = 1 AND [totalpacket" +
"sllc] IS NULL) OR ([totalpacketsllc] = @Original_totalpacketsllc)) AND ((@IsNull" +
"_totalpacketsdupeiv = 1 AND [totalpacketsdupeiv] IS NULL) OR ([totalpacketsdupei" +
"v] = @Original_totalpacketsdupeiv)) AND ((@IsNull_totalpacketsdata = 1 AND [tota" +
"lpacketsdata] IS NULL) OR ([totalpacketsdata] = @Original_totalpacketsdata)) AND" +
" ((@IsNull_totalpacketscrypt = 1 AND [totalpacketscrypt] IS NULL) OR ([totalpack" +
"etscrypt] = @Original_totalpacketscrypt)) AND ((@IsNull_Network = 1 AND [Network" +
"] IS NULL) OR ([Network] = @Original_Network)) AND ((@IsNull_NetType = 1 AND [Ne" +
"tType] IS NULL) OR ([NetType] = @Original_NetType)) AND ((@IsNull_ESSID = 1 AND " +
"[ESSID] IS NULL) OR ([ESSID] = @Original_ESSID)) AND ([BSSID] = @Original_BSSID)" +
" AND ((@IsNull_Info = 1 AND [Info] IS NULL) OR ([Info] = @Original_Info)) AND ((" +
"@IsNull_Channel = 1 AND [Channel] IS NULL) OR ([Channel] = @Original_Channel)) A" +
"ND ((@IsNull_Cloaked = 1 AND [Cloaked] IS NULL) OR ([Cloaked] = @Original_Cloake" +
"d)) AND ((@IsNull_Encryption = 1 AND [Encryption] IS NULL) OR ([Encryption] = @O" +
"riginal_Encryption)) AND ((@IsNull_Decrypted = 1 AND [Decrypted] IS NULL) OR ([D" +
"ecrypted] = @Original_Decrypted)) AND ((@IsNull_MaxRate = 1 AND [MaxRate] IS NUL" +
"L) OR ([MaxRate] = @Original_MaxRate)) AND ((@IsNull_MaxSeenRate = 1 AND [MaxSee" +
"nRate] IS NULL) OR ([MaxSeenRate] = @Original_MaxSeenRate)) AND ((@IsNull_Beacon" +
" = 1 AND [Beacon] IS NULL) OR ([Beacon] = @Original_Beacon)) AND ((@IsNull_LLC =" +
" 1 AND [LLC] IS NULL) OR ([LLC] = @Original_LLC)) AND ((@IsNull_Data = 1 AND [Da" +
"ta] IS NULL) OR ([Data] = @Original_Data)) AND ((@IsNull_Crypt = 1 AND [Crypt] I" +
"S NULL) OR ([Crypt] = @Original_Crypt)) AND ((@IsNull_Weak = 1 AND [Weak] IS NUL" +
"L) OR ([Weak] = @Original_Weak)) AND ((@IsNull_Total = 1 AND [Total] IS NULL) OR" +
" ([Total] = @Original_Total)) AND ((@IsNull_Carrier = 1 AND [Carrier] IS NULL) O" +
"R ([Carrier] = @Original_Carrier)) AND ((@IsNull_Encoding = 1 AND [Encoding] IS " +
"NULL) OR ([Encoding] = @Original_Encoding)) AND ((@IsNull_FirstTime = 1 AND [Fir" +
"stTime] IS NULL) OR ([FirstTime] = @Original_FirstTime)) AND ((@IsNull_LastTime " +
"= 1 AND [LastTime] IS NULL) OR ([LastTime] = @Original_LastTime)) AND ((@IsNull_" +
"BestQuality = 1 AND [BestQuality] IS NULL) OR ([BestQuality] = @Original_BestQua" +
"lity)) AND ((@IsNull_BestSignal = 1 AND [BestSignal] IS NULL) OR ([BestSignal] =" +
" @Original_BestSignal)) AND ((@IsNull_BestNoise = 1 AND [BestNoise] IS NULL) OR " +
"([BestNoise] = @Original_BestNoise)) AND ((@IsNull_GPSMinLat = 1 AND [GPSMinLat]" +
" IS NULL) OR ([GPSMinLat] = @Original_GPSMinLat)) AND ((@IsNull_GPSMinLon = 1 AN" +
"D [GPSMinLon] IS NULL) OR ([GPSMinLon] = @Original_GPSMinLon)) AND ((@IsNull_GPS" +
"MinAlt = 1 AND [GPSMinAlt] IS NULL) OR ([GPSMinAlt] = @Original_GPSMinAlt)) AND " +
"((@IsNull_GPSMinSpd = 1 AND [GPSMinSpd] IS NULL) OR ([GPSMinSpd] = @Original_GPS" +
"MinSpd)) AND ((@IsNull_GPSMaxLat = 1 AND [GPSMaxLat] IS NULL) OR ([GPSMaxLat] = " +
"@Original_GPSMaxLat)) AND ((@IsNull_GPSMaxLon = 1 AND [GPSMaxLon] IS NULL) OR ([" +
"GPSMaxLon] = @Original_GPSMaxLon)) AND ((@IsNull_GPSMaxAlt = 1 AND [GPSMaxAlt] I" +
"S NULL) OR ([GPSMaxAlt] = @Original_GPSMaxAlt)) AND ((@IsNull_GPSMaxSpd = 1 AND " +
"[GPSMaxSpd] IS NULL) OR ([GPSMaxSpd] = @Original_GPSMaxSpd)) AND ((@IsNull_GPSBe" +
"stLat = 1 AND [GPSBestLat] IS NULL) OR ([GPSBestLat] = @Original_GPSBestLat)) AN" +
"D ((@IsNull_GPSBestLon = 1 AND [GPSBestLon] IS NULL) OR ([GPSBestLon] = @Origina" +
"l_GPSBestLon)) AND ((@IsNull_GPSBestAlt = 1 AND [GPSBestAlt] IS NULL) OR ([GPSBe" +
"stAlt] = @Original_GPSBestAlt)) AND ((@IsNull_Datasize = 1 AND [Datasize] IS NUL" +
"L) OR ([Datasize] = @Original_Datasize)) AND ((@IsNull_IPType = 1 AND [IPType] I" +
"S NULL) OR ([IPType] = @Original_IPType)) AND ((@IsNull_IP = 1 AND [IP] IS NULL)" +
" OR ([IP] = @Original_IP)))";
this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@oui";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "oui";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@totalpacketsweak";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsweak";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@totalpacketstotal";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketstotal";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@totalpacketsllc";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsllc";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@totalpacketsdupeiv";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsdupeiv";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@totalpacketsdata";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsdata";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@totalpacketscrypt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketscrypt";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Network";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Network";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@NetType";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "NetType";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@ESSID";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "ESSID";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@BSSID";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "BSSID";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Info";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Info";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Channel";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Channel";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Cloaked";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Cloaked";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Encryption";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Encryption";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Decrypted";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Decrypted";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@MaxRate";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "MaxRate";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@MaxSeenRate";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "MaxSeenRate";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Beacon";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Beacon";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@LLC";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "LLC";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Data";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Data";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Crypt";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Crypt";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Weak";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Weak";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Total";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Total";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Carrier";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Carrier";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Encoding";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Encoding";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@FirstTime";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "FirstTime";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@LastTime";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "LastTime";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@BestQuality";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "BestQuality";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@BestSignal";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "BestSignal";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@BestNoise";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "BestNoise";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMinLat";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinLat";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMinLon";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinLon";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMinAlt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinAlt";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMinSpd";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinSpd";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMaxLat";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxLat";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMaxLon";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxLon";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMaxAlt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxAlt";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSMaxSpd";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxSpd";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSBestLat";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSBestLat";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSBestLon";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSBestLon";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@GPSBestAlt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSBestAlt";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Datasize";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Datasize";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IPType";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "IPType";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IP";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "IP";
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_oui";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "oui";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_oui";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "oui";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_totalpacketsweak";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "totalpacketsweak";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_totalpacketsweak";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsweak";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_totalpacketstotal";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "totalpacketstotal";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_totalpacketstotal";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketstotal";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_totalpacketsllc";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "totalpacketsllc";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_totalpacketsllc";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsllc";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_totalpacketsdupeiv";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "totalpacketsdupeiv";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_totalpacketsdupeiv";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsdupeiv";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_totalpacketsdata";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "totalpacketsdata";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_totalpacketsdata";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketsdata";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_totalpacketscrypt";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "totalpacketscrypt";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_totalpacketscrypt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "totalpacketscrypt";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Network";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Network";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Network";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Network";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_NetType";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "NetType";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_NetType";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "NetType";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_ESSID";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "ESSID";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_ESSID";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "ESSID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_BSSID";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "BSSID";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Info";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Info";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Info";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Info";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Channel";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Channel";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Channel";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Channel";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Cloaked";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Cloaked";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Cloaked";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Cloaked";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Encryption";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Encryption";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Encryption";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Encryption";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Decrypted";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Decrypted";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Decrypted";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Decrypted";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_MaxRate";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "MaxRate";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_MaxRate";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "MaxRate";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_MaxSeenRate";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "MaxSeenRate";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_MaxSeenRate";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "MaxSeenRate";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Beacon";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Beacon";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Beacon";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Beacon";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_LLC";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "LLC";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_LLC";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "LLC";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Data";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Data";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Data";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Data";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Crypt";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Crypt";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Crypt";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Crypt";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Weak";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Weak";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Weak";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Weak";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Total";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Total";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Total";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Total";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Carrier";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Carrier";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Carrier";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "Carrier";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Encoding";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Encoding";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Encoding";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Encoding";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_FirstTime";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "FirstTime";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_FirstTime";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "FirstTime";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_LastTime";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "LastTime";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_LastTime";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "LastTime";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_BestQuality";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "BestQuality";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_BestQuality";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "BestQuality";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_BestSignal";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "BestSignal";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_BestSignal";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "BestSignal";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_BestNoise";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "BestNoise";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_BestNoise";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "BestNoise";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMinLat";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMinLat";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMinLat";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinLat";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMinLon";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMinLon";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMinLon";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinLon";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMinAlt";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMinAlt";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMinAlt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinAlt";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMinSpd";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMinSpd";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMinSpd";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMinSpd";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMaxLat";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMaxLat";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMaxLat";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxLat";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMaxLon";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMaxLon";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMaxLon";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxLon";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMaxAlt";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMaxAlt";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMaxAlt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxAlt";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSMaxSpd";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSMaxSpd";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSMaxSpd";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSMaxSpd";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSBestLat";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSBestLat";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSBestLat";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSBestLat";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSBestLon";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSBestLon";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSBestLon";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSBestLon";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_GPSBestAlt";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "GPSBestAlt";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_GPSBestAlt";
param.DbType = System.Data.DbType.Decimal;
param.DbType = System.Data.DbType.Decimal;
param.SourceColumn = "GPSBestAlt";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_Datasize";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "Datasize";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_Datasize";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "Datasize";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_IPType";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "IPType";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_IPType";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "IPType";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@IsNull_IP";
param.DbType = System.Data.DbType.Int32;
param.DbType = System.Data.DbType.Int32;
param.SourceColumn = "IP";
param.SourceVersion = System.Data.DataRowVersion.Original;
param.SourceColumnNullMapping = true;
this._adapter.UpdateCommand.Parameters.Add(param);
param = new System.Data.SQLite.SQLiteParameter();
param.ParameterName = "@Original_IP";
param.DbType = System.Data.DbType.String;
param.SourceColumn = "IP";
param.SourceVersion = System.Data.DataRowVersion.Original;
this._adapter.UpdateCommand.Parameters.Add(param);
}
void BtnAddUrlClick(object sender, EventArgs e)
{
AddRssForm addForm = new AddRssForm();
if (addForm.ShowDialog(this) == DialogResult.OK){
System.Data.SQLite.SQLiteDataAdapter da = new System.Data.SQLite.SQLiteDataAdapter("select * from urlrss", conn);
System.Data.SQLite.SQLiteCommandBuilder cb = new System.Data.SQLite.SQLiteCommandBuilder(da);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
System.Data.DataRow dr = ds.Tables[0].NewRow();
dr["Url"] = addForm.NewUrl;
bool found = false;
foreach (System.Data.DataRow tmpDr in ds.Tables[0].Rows){
if (tmpDr["Url"].Equals(dr["Url"])){
found = true;
break;
}
}
if (!found){
ds.Tables[0].Rows.Add(dr);
da.Update(ds);
LoadFeeds();
} else {
MessageBox.Show("This Feed already exists");
}
}
}
private void FillPrioritiesComboBox()
{
string query = "SELECT ID, name FROM priorities WHERE active=1";
if (!row.IsNull("priority_id"))
query += " OR ID=" + row["priority_id"];
var dataAdapter = new System.Data.SQLite.SQLiteDataAdapter(query, connection);
var dataSet = new System.Data.DataSet();
dataAdapter.Fill(dataSet, "priorities");
var previousValue = PriorityComboBox.SelectedValue;
PriorityComboBox.ItemsSource = dataSet.Tables["priorities"].DefaultView;
PriorityComboBox.SelectedValue = previousValue;
}
private void FillEventsComboBox()
{
var dataAdapter = new System.Data.SQLite.SQLiteDataAdapter("SELECT deadlines.ID, events.name, deadlines.deadline FROM events LEFT JOIN deadlines ON events.deadline_id=deadlines.ID WHERE deadlines.deadline>=date('now') ORDER BY events.name", connection);
var dataSet = new System.Data.DataSet();
dataAdapter.Fill(dataSet, "events");
var previousValue = EventsComboBox.SelectedValue;
EventsComboBox.ItemsSource = dataSet.Tables["events"].DefaultView;
EventsComboBox.SelectedValue = previousValue;
}
public DynamicUpdateSqlite(string ConnString)
{
odc = new System.Data.SQLite.SQLiteConnection(ConnString);
oda = new System.Data.SQLite.SQLiteDataAdapter();
oda.ContinueUpdateOnError = true;
}
public Framework.Entity.Template GetTemplateByTitle(string title)
{
using (this.getConnection)
{
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.IDbCommand cmd = this.conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "SELECT * FROM CB_Template WHERE T_Title = '" + title + "'";
System.Data.IDbDataAdapter adapter = new System.Data.SQLite.SQLiteDataAdapter((System.Data.SQLite.SQLiteCommand)cmd);
adapter.Fill(ds);
System.Collections.ArrayList alist = Framework.Class.PackageEntity.Package(new Framework.Entity.Template(), ds.Tables[0]);
return (Framework.Entity.Template)alist[0];
}
}
public object FindById(object entity, int id)
{
using (this.getConnection)
{
System.Data.DataSet ds = new System.Data.DataSet();
this.getConnection.Open();
System.Data.IDbCommand cmd = this.getConnection.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
switch (Framework.Class.PackageEntity.Dispatcher(entity))
{
case 1:
cmd.CommandText = "SELECT * FROM FW_Module WHERE M_Id = " + id;
break;
case 2:
cmd.CommandText = "SELECT * FROM FW_Role WHERE R_Id = " + id;
break;
case 3:
cmd.CommandText = "SELECT * FROM FW_User WHERE U_Id = " + id;
break;
case 4:
cmd.CommandText = "SELECT * FROM CB_Chapter WHERE C_Id = " + id;
break;
case 5:
cmd.CommandText = "SELECT * FROM CB_Template WHERE T_Id = " + id;
break;
case 6:
cmd.CommandText = "SELECT * FROM CB_Model WHERE D_Id = " + id;
break;
}
System.Data.IDbDataAdapter adapter = new System.Data.SQLite.SQLiteDataAdapter((System.Data.SQLite.SQLiteCommand)cmd);
adapter.Fill(ds);
System.Collections.ArrayList alist = Framework.Class.PackageEntity.Package(entity, ds.Tables[0]);
this.getConnection.Close();
return alist[0];
}
}
private void Rptpordonador_Load(object sender, EventArgs e)
{
CrystalReport2 objRpt = new CrystalReport2();
string appPath = Path.GetDirectoryName(Application.ExecutablePath);
String ConnStr = @"Data Source=" + appPath + @"\dbcar.s3db ;Version=3;";
System.Data.SQLite.SQLiteConnection myConnection = new System.Data.SQLite.SQLiteConnection(ConnStr);
String Query1 = "SELECT * FROM Donaciones Where Nombre = '"+nombre1+"' AND Edad = '"+edad1+"'";
System.Data.SQLite.SQLiteDataAdapter adapter = new System.Data.SQLite.SQLiteDataAdapter(Query1, ConnStr);
DataSet Ds = new DataSet();
// here my_dt is the name of the DataTable which we
// created in the designer view.
adapter.Fill(Ds, "my_dt");
// Setting data source of our report object
objRpt.SetDataSource(Ds);
// Binding the crystalReportViewer with our report object.
this.crystalReportViewer1.ReportSource = objRpt;
objRpt.Refresh();
}
