/// <summary>
/// converte o parametro para o tipo esperado
/// </summary>
/// <param name="copy">Se true, copia os valores deste objeto</param>
/// <returns></returns>
internal DbParameter ToParameterType(bool copy = true)
{
DbParameter result = null;
#region Detecta o tipo de parametro
switch (Configuration.DataGenericSettings.Settings.DatabaseType)
{
case DatabaseType.PostgreSQL:
result = new Npgsql.NpgsqlParameter();
break;
case DatabaseType.SQLite:
result = new System.Data.SQLite.SQLiteParameter();
break;
default:
throw new Exceptions.DatabaseTypeNotDefined();
}
#endregion
#region Copia o objeto
if (copy)
{
result.ParameterName = ParameterName;
result.DbType = DbType;
result.SourceColumn = SourceColumn;
result.Value = Value;
}
#endregion
return(result);
}
/// <summary>
/// Returns the article from its reference
/// </summary>
/// <param name="refArticle"></param>
/// <returns>the article</returns>
public Models.Article Get_Article(string refArticle)
{
Models.Article Article = new Models.Article();
System.Data.SQLite.SQLiteCommand cmd = SQL_Connection.CreateCommand();
cmd.CommandText = "SELECT RefArticle, Description, SousFamilles.Nom as SousFamille, m.Nom as Marque, PrixHT, Quantite FROM Articles natural join SousFamilles inner join Marques m on m.RefMarque = Articles.refMarque WHERE RefArticle = ?";
System.Data.SQLite.SQLiteParameter Id_Parameter = new System.Data.SQLite.SQLiteParameter();
Id_Parameter.Value = refArticle;
cmd.Parameters.Add(Id_Parameter);
System.Data.SQLite.SQLiteDataReader Articles_Reader = cmd.ExecuteReader();
int Article_Index = Articles_Reader.GetOrdinal("RefArticle");
int Description_Index = Articles_Reader.GetOrdinal("Description");
int Sub_Familly_Index = Articles_Reader.GetOrdinal("SousFamille");
int Brand_Index = Articles_Reader.GetOrdinal("Marque");
int Price_Index = Articles_Reader.GetOrdinal("PrixHT");
int Quantity_Index = Articles_Reader.GetOrdinal("Quantite");
if (Articles_Reader.Read())
{
Models.Article A = new Models.Article();
Article.Ref_Article = Articles_Reader.GetString(Article_Index);
Article.Description = Articles_Reader.GetString(Description_Index);
Article.Sub_Familly_Name = Articles_Reader.GetString(Sub_Familly_Index);
Article.Brand_Name = Articles_Reader.GetString(Brand_Index);
Article.Price_HT = Articles_Reader.GetFloat(Price_Index);
Article.Quantity = Articles_Reader.GetInt32(Quantity_Index);
}
return(Article);
}
// another microfuckup
public IDbDataParameter BlobParameter(int no, byte[] value, bool isNull)
{
if (VendorType.Lite3 == connect.typeOfVendor)
{
string p = ParameterShape(no);
System.Data.SQLite.SQLiteParameter parameter = new System.Data.SQLite.SQLiteParameter(p, DbType.Binary, value.Length);
if (isNull)
{
parameter.Value = DBNull.Value;
}
else
{
parameter.Value = value;
}
command.Parameters.Add(parameter);
return(parameter);
//return null;
}
else
{
string p = ParameterShape(no);
System.Data.SqlClient.SqlParameter parameter = new System.Data.SqlClient.SqlParameter(p, SqlDbType.Image);
if (isNull)
{
parameter.Value = DBNull.Value;
}
else
{
parameter.Value = value;
}
command.Parameters.Add(parameter);
return(parameter);
}
}
/// <summary>
/// 保存或更新数据
/// </summary>
/// <param name="data">中奖号码记录</param>
public bool SaveOrUpdate(Modules.LoanData data)
{
string sql_count = "select count(1) from Numbers where Cycle = @Cycle";
string sql_insert = "insert into Numbers values(@Cycle, @RunDate, @Number1, @Number2, @Number3, @Number4, @Number5, @Number6, @BlueNumber)";
System.Data.SQLite.SQLiteParameter param_count = new System.Data.SQLite.SQLiteParameter("@Cycle", data.Cycle);
System.Data.SQLite.SQLiteParameter[] param_insert = new System.Data.SQLite.SQLiteParameter[]
{
new System.Data.SQLite.SQLiteParameter("@Cycle", data.Cycle),
new System.Data.SQLite.SQLiteParameter("@RunDate", data.RunDate),
new System.Data.SQLite.SQLiteParameter("@Number1", data.Number1),
new System.Data.SQLite.SQLiteParameter("@Number2", data.Number2),
new System.Data.SQLite.SQLiteParameter("@Number3", data.Number3),
new System.Data.SQLite.SQLiteParameter("@Number4", data.Number4),
new System.Data.SQLite.SQLiteParameter("@Number5", data.Number5),
new System.Data.SQLite.SQLiteParameter("@Number6", data.Number6),
new System.Data.SQLite.SQLiteParameter("@BlueNumber", data.BlueNumber),
};
int count = DbProvider.ExecuteSalacr<int>(sql_count, param_count);
if (count == 0)
{
int iResult = DbProvider.ExecuteNonQuery(sql_insert, param_insert);
return iResult == 1 ? true : false;
}
else
{
return true;
}
}
public DataSource()
{
dataCore = new DataModel();
string sql = @"SELECT result.tid,text,topic,name,person,location,organization,event,event_date,original_pic
from result,home_timeline
where result.tid=home_timeline.tid and date(event_date)< '@endDate' and event != ''
order by date(event_date) desc,datetime(created_at) desc limit 80;";
System.Data.SQLite.SQLiteParameter[] pms = new System.Data.SQLite.SQLiteParameter[]
{
//new System.Data.SQLite.SQLiteParameter("startDate",DateTime.Today.AddDays(-30).ToString("yyyy-MM-dd")),//过去30天
new System.Data.SQLite.SQLiteParameter("endDate", DateTime.Today.AddDays(5).ToString("yyyy-MM-dd")), //最多未来5天
};
var reader = SQLiteHelper.ExecuteReader(sql);
while (reader.Read())
{
var tid = reader.GetString(0);
var text = reader.GetString(1);
var topic = reader.IsDBNull(2) ? "" : reader.GetString(2);
var name = reader.GetString(3);
var person = reader.GetString(4);
var location = reader.GetString(5);
var organization = reader.GetString(6);
var event_phrase = reader.GetString(7);
var time = reader.IsDBNull(8) ? "" : reader.GetString(8);
var original_pic = reader.IsDBNull(9) ? "" : reader.GetString(9);
dataCore.AddItem(new DataItem(tid, text, topic, name, person, location, organization, event_phrase, Convert.ToDateTime(time), original_pic));
}
}
public async void SaveCityToDB(List <City> cityList)
{
await Task.Run(() => {
ShowStatusText($"开始保存城市数据");
using (SQLiteUtil sqlite = new SQLiteUtil(dbPath))
{
var sql = "Delete From City";
sqlite.ExecuteNonQuery(sql);
foreach (var item in cityList)
{
sql = "Insert Into City (ProvinceID,CityID,CityName,CityPinYin) Values (@ProvinceID,@CityID,@CityName,@CityPinYin)";
System.Data.SQLite.SQLiteParameter[] parameters = new System.Data.SQLite.SQLiteParameter[]
{
new System.Data.SQLite.SQLiteParameter("@ProvinceID", item.ProvinceID),
new System.Data.SQLite.SQLiteParameter("@CityID", item.CityID),
new System.Data.SQLite.SQLiteParameter("@CityName", item.CityName),
new System.Data.SQLite.SQLiteParameter("@CityPinYin", item.CityPinYinName)
};
sqlite.ExecuteNonQuery(sql, parameters);
ShowStatusText($"保存{item.CityName}数据完成");
Task.Delay(5);
}
}
ShowStatusText($"保存城市数据完成");
});
}
/// <summary>
/// 根据微博id获取微博数据
/// </summary>
/// <param name="tid"></param>
public DataSource(string tid)
{
dataCore = new DataModel();
string sql = @"SELECT result.tid,text,topic,name,person,location,organization,event,event_date,original_pic
from result,home_timeline
where result.tid=home_timeline.tid and home_timeline.tid=@tid;";
System.Data.SQLite.SQLiteParameter[] pms = new System.Data.SQLite.SQLiteParameter[]
{
new System.Data.SQLite.SQLiteParameter("tid", tid),
};
var reader = SQLiteHelper.ExecuteReader(sql, pms);
while (reader.Read())
{
var tid2 = reader.GetString(0);
var text = reader.GetString(1);
var topics = reader.IsDBNull(2) ? "" : reader.GetString(2);
var name = reader.GetString(3);
var person = reader.GetString(4);
var location = reader.GetString(5);
var organization = reader.GetString(6);
var event_phrase = reader.GetString(7);
var time = reader.IsDBNull(8) ? "" : reader.GetString(8);
var original_pic = reader.IsDBNull(9) ? "" : reader.GetString(9);
dataCore.AddItem(new DataItem(tid2, text, topics, name, person, location, organization, event_phrase, Convert.ToDateTime(time), original_pic));
}
}
public static DbParameter NewPar(string Nome, object Valore, DbType tipo)
{
DbParameter o = null;
if (DataBaseAttuale == DataBase.Access)
{
o = new System.Data.OleDb.OleDbParameter(Nome, tipo);
}
else if (DataBaseAttuale == DataBase.SQLite)
{
if (tipo == DbType.Date || tipo == DbType.DateTime)
{
//"YYYY-MM-DD HH:MM:SS.SSS"
Valore = ((DateTime)Valore).ToString("yyyy-MM-dd HH:mm:ss.fff");
tipo = DbType.String;
}
#if __MonoCS__
o = new Mono.Data.Sqlite.SqliteParameter(Nome, tipo);
#else
o = new System.Data.SQLite.SQLiteParameter(Nome, tipo);
#endif
}
o.Value = Valore;
return(o);
}
public void DeleteCategory(int id)
{
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
// The category
command.CommandText = "DELETE FROM categories WHERE id=@id";
SqliteParameter parameter = new SqliteParameter("@id", DbType.Int32);
parameter.Value = id;
command.Parameters.Add(parameter);
command.ExecuteNonQuery();
// The questions for the category
command.CommandText = "DELETE FROM questions WHERE categoryid=@id";
command.ExecuteNonQuery();
}
}
}
catch (SqliteException e)
{
Logger.Warn("SqliteException occurred with DeleteCategory({0}): \n{1}", id, e);
}
}
public int MaxQuestionOrder(Category category)
{
int result = 0;
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
command.CommandText = @"SELECT MAX([order]) from questions WHERE categoryid=@categoryid";
SqliteParameter parameter = new SqliteParameter("@categoryid", DbType.Int32);
parameter.Value = category.Id;
command.Parameters.Add(parameter);
object val = command.ExecuteScalar();
if (val != DBNull.Value)
{
result = Convert.ToInt32(val);
}
}
}
}
catch (SqliteException ex)
{
Logger.Fatal("Unable to perform MaxQuestionOrder: \n{0}", ex);
}
return(result);
}
/// <summary>
/// Returns the id from the family name or create a new family if none found.
/// </summary>
/// <param name="Familly_Name"></param>
/// <returns>the family id</returns>
public int Get_Or_Create_Familly(string Familly_Name)
{
int Id = Get_Familly_ID(Familly_Name);
if (Id != -1)
{
return(Id);
}
Id = Get_New_Id("Familles");
System.Data.SQLite.SQLiteCommand cmd = SQL_Connection.CreateCommand();
cmd.CommandText = "INSERT INTO Familles (RefFamille, Nom) VALUES (?, ?)";
System.Data.SQLite.SQLiteParameter Id_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Name_Parameter = new System.Data.SQLite.SQLiteParameter();
Id_Parameter.Value = Id;
Name_Parameter.Value = Familly_Name;
cmd.Parameters.Add(Id_Parameter);
cmd.Parameters.Add(Name_Parameter);
int Nb = cmd.ExecuteNonQuery();
if (Nb != 1)
{
return(-1);
}
else
{
return(Id);
}
}
public async Task <List <SearchQueryFile> > LookupAsync(string search, CancellationToken token)
{
StringBuilder keywords = new StringBuilder();
var words = search.Split(' ').Where(t => !string.IsNullOrWhiteSpace(t));
for (int i = 0; i < words.Count(); i++)
{
if (words.Count() == 0)
{
keywords.Append(string.Format("*{0}*", words.ElementAt(i)));
}
else if (i == (words.Count() - 1))
{
keywords.Append(words.ElementAt(i));
}
else
{
keywords.Append(string.Format("{0} NEAR ", words.ElementAt(i)));
}
}
string sql = @"
select q.Id,
q.Name,
q.DateCreated,
q.DateModified
from SearchQueryFile s
join QueryFile q on s.Id = q.Id
where s.Name MATCH @keywords
";
var sparam = new System.Data.SQLite.SQLiteParameter("@keywords", keywords);
return(await Context.Database.SqlQuery <SearchQueryFile>(sql, sparam).ToListAsync(token));
}
private PostGetHelperFrm()
{
InitializeComponent();
cbx_Type.SelectedIndex = 0;
SQLiteHelper.SetConnectionString(System.Environment.CurrentDirectory + "/DBS/MyDicDb.db");
var Param = new System.Data.SQLite.SQLiteParameter[0];
var dt = SQLiteHelper.ExecuteQuery("select * from ListTable", Param);
for (int i = 0; i < dt.Columns.Count; i++)
{
if (dt.Columns[i].ColumnName == "DicKey")
{
dt.Columns[i].ColumnName = "Key";
}
else
{
dt.Columns[i].ColumnName = "Value";
}
}
foreach (DataRow dr in dt.Rows)
{
if (!dic.ContainsKey(dr["Key"].ToString()))
{
dic.Add(dr["Key"].ToString(), dr["Value"].ToString());
}
}
}
public bool ExistTable(string tb)
{
string sql = "select count(*) from sqlite_master where type='table' and name=@tb";
System.Data.SQLite.SQLiteParameter[] pars = new System.Data.SQLite.SQLiteParameter[]
{
new System.Data.SQLite.SQLiteParameter("@tb", DbType.String)
};
pars[0].Value = tb;
DB.IDB db = this;
var obj = db.ExecuteScalar(sql, pars);
if (obj == null)
{
return(false);
}
else
{
int cnt = 0;
int.TryParse(obj.ToString(), out cnt);
if (cnt == 0)
{
return(false);
}
else
{
return(true);
}
}
}
public int SaveCategory(Category category)
{
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
bool updating = (category.Id > 0);
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
SqliteParameter parameter;
string sql = @"INSERT INTO categories (name,active) VALUES (@name,@active);SELECT last_insert_rowid();";
if (updating)
{
sql = @"UPDATE categories SET name=@name,active=@active WHERE id=@id";
parameter = new SqliteParameter("@id", DbType.Int32);
parameter.Value = category.Id;
command.Parameters.Add(parameter);
}
parameter = new SqliteParameter("@name", DbType.String);
parameter.Value = category.Name;
command.Parameters.Add(parameter);
parameter = new SqliteParameter("@active", DbType.Boolean);
parameter.Value = category.Active;
command.Parameters.Add(parameter);
command.CommandText = sql;
int result;
if (updating)
{
command.ExecuteNonQuery();
result = category.Id;
// If result isn't the categoryid, then ignore it
}
else
{
Int64 newId = (Int64)command.ExecuteScalar();
result = Convert.ToInt32(newId);
category.Id = result;
}
return(result);
}
}
}
catch (SqliteException e)
{
Logger.Warn("SqliteException occurred with SaveCategory({0}): \n{1}", category.Id, e);
}
return(0);
}
public DbParameter CreateParameter(string parameterName, ParameterDirection direction)
{
DbParameter parameter = new System.Data.SQLite.SQLiteParameter();
parameter.ParameterName = parameterName;
parameter.Direction = direction;
return(parameter);
}
/// <summary>
/// Creates an article
/// </summary>
/// <param name="Article_ID"></param>
/// <param name="Sub_Familly_ID"></param>
/// <param name="Brand_ID"></param>
/// <param name="Description"></param>
/// <param name="Prix"></param>
/// <returns>the id</returns>
public bool Create_Article(string Article_ID, int Sub_Familly_ID, int Brand_ID, string Description, float Prix)
{
// Check values.
if (Sub_Familly_ID == -1 || Brand_ID == -1)
{
return(false);
}
int Quantite = Count_Articles_Id(Article_ID);
//If the article already exists just update the quantity
if (Quantite != -1)
{
System.Data.SQLite.SQLiteCommand cmd = SQL_Connection.CreateCommand();
cmd.CommandText = "UPDATE Articles SET (Quantite = ?) WHERE RefArticle = ?";
System.Data.SQLite.SQLiteParameter Id_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Quantity_Parameter = new System.Data.SQLite.SQLiteParameter();
Id_Parameter.Value = Article_ID;
Quantity_Parameter.Value = Quantite + 1;
int Rows = cmd.ExecuteNonQuery();
return(Rows == 1);
}
else
{
System.Data.SQLite.SQLiteCommand cmd = SQL_Connection.CreateCommand();
cmd.CommandText = "INSERT INTO Articles (RefArticle, Description, RefSousFamille, RefMarque, PrixHT, Quantite) VALUES (?, ?, ?, ?, ?, ?)";
System.Data.SQLite.SQLiteParameter Id_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Description_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Sub_Fammilly_Id_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Brand_Id_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Price_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Quantity_Parameter = new System.Data.SQLite.SQLiteParameter();
Id_Parameter.Value = Article_ID;
Description_Parameter.Value = Description;
Sub_Fammilly_Id_Parameter.Value = Sub_Familly_ID;
Brand_Id_Parameter.Value = Brand_ID;
Price_Parameter.Value = Prix;
Quantity_Parameter.Value = 1;
cmd.Parameters.Add(Id_Parameter);
cmd.Parameters.Add(Description_Parameter);
cmd.Parameters.Add(Sub_Fammilly_Id_Parameter);
cmd.Parameters.Add(Brand_Id_Parameter);
cmd.Parameters.Add(Price_Parameter);
cmd.Parameters.Add(Quantity_Parameter);
int Nb = cmd.ExecuteNonQuery();
return(Nb == 1);
}
}
public static LazySQL.Infrastructure.ExecuteNonModel userInsert(string user, string pwd, string power)
{
System.Text.StringBuilder StrbSQL = new System.Text.StringBuilder();
LazySQL.Infrastructure.SQLiteTemplate sqlLiteT = new LazySQL.Infrastructure.SQLiteTemplate();
try
{
System.Collections.Generic.List <System.Data.SQLite.SQLiteParameter> aList = new System.Collections.Generic.List <System.Data.SQLite.SQLiteParameter>();
StrbSQL.Append("insert into user (user,pwd,power) values (");
System.Text.StringBuilder par0 = new System.Text.StringBuilder();
par0.Append("@user");
par0.Append(" , ");
if (!string.IsNullOrWhiteSpace(user))
{
System.Data.SQLite.SQLiteParameter userPar = new System.Data.SQLite.SQLiteParameter("@user", user);
aList.Add(userPar);
}
else
{
System.Data.SQLite.SQLiteParameter userPar = new System.Data.SQLite.SQLiteParameter("@user", "''");
aList.Add(userPar);
}
par0.Append("@pwd");
par0.Append(" , ");
if (!string.IsNullOrWhiteSpace(pwd))
{
System.Data.SQLite.SQLiteParameter pwdPar = new System.Data.SQLite.SQLiteParameter("@pwd", pwd);
aList.Add(pwdPar);
}
else
{
System.Data.SQLite.SQLiteParameter pwdPar = new System.Data.SQLite.SQLiteParameter("@pwd", "''");
aList.Add(pwdPar);
}
par0.Append("@power");
if (!string.IsNullOrWhiteSpace(power))
{
System.Data.SQLite.SQLiteParameter powerPar = new System.Data.SQLite.SQLiteParameter("@power", power);
aList.Add(powerPar);
}
else
{
System.Data.SQLite.SQLiteParameter powerPar = new System.Data.SQLite.SQLiteParameter("@power", "''");
aList.Add(powerPar);
}
StrbSQL.Append(par0);
StrbSQL.Append(")");
return(sqlLiteT.ExecuteNonQuery("Data Source=db\\sqlliteTest.db;Initial Catalog=sqlliteTest;Integrated Security=Tru" +
"e;Max Pool Size=10", StrbSQL, aList));
}
catch (System.Exception ex)
{
throw ex;;
}
}
public async Task <List <FileImport> > GetReadyToCheckImports(int seconds)
{
string sql = @"
select *
from FileImport
where strftime('%s', datetime('now', 'localtime')) - strftime('%s', DateDeleted) >= @second
and DateChecked is null
";
var sparam = new System.Data.SQLite.SQLiteParameter("@second", seconds);
return(await Context.Database.SqlQuery <FileImport>(sql, sparam).ToListAsync());
}
public Question ReadQuestion(int id)
{
Question question = new Question();
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
command.CommandText = "SELECT q.*,c.Name as categoryName,c.inbuilt as inbuilt,c.active as active" +
"FROM questions q, categories c WHERE c.id = q.categoryid AND id=@id";
SqliteParameter parameter = new SqliteParameter("@id", DbType.Int32);
parameter.Value = id;
command.Parameters.Add(parameter);
using (SqliteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
question.Id = Convert.ToInt32(reader["id"]);
question.Title = (string)reader["title"];
question.Category = new Category();
question.Category.Id = Convert.ToInt32(reader["categoryid"]);
question.Category.InBuilt = Convert.ToBoolean(reader["inbuilt"]);
question.Category.Active = Convert.ToBoolean(reader["active"]);
question.Category.Name = (string)reader["categoryName"];
question.Answer = (string)reader["answer"];
question.AskCount = Convert.ToInt32(reader["askcount"]);
question.EasinessFactor = Convert.ToDouble(reader["easinessfactor"]);
question.Interval = Convert.ToInt32(reader["interval"]);
question.LastAsked = new DateTime(Convert.ToInt64(reader["lastasked"]));
question.NextAskOn = new DateTime(Convert.ToInt64(reader["nextaskon"]));
question.Order = Convert.ToInt32(reader["order"]);
question.PreviousInterval = Convert.ToInt32(reader["previousinterval"]);
question.ResponseQuality = Convert.ToInt32(reader["responsequality"]);
}
}
}
}
}
catch (SqliteException e)
{
Logger.Warn("SqliteException occurred with ReadQuestion({0}): \n{1}", id, e);
}
return(question);
}
/// <summary>
/// Deletes the article
/// </summary>
/// <param name="Article_ID"></param>
/// <returns>true if everything went fine</returns>
public bool Delete_Article(string Article_ID)
{
System.Data.SQLite.SQLiteCommand cmd = SQL_Connection.CreateCommand();
cmd.CommandText = "DELETE FROM Articles WHERE RefArticle = ?";
System.Data.SQLite.SQLiteParameter Id_Parameter = new System.Data.SQLite.SQLiteParameter();
Id_Parameter.Value = Article_ID;
cmd.Parameters.Add(Id_Parameter);
int Nb = cmd.ExecuteNonQuery();
return(Nb == 1);
}
public IList <Question> QuestionsForCategory(Category category)
{
IList <Question> list = new List <Question>();
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
command.CommandText = "SELECT * FROM questions WHERE categoryid = @categoryid";
SqliteParameter parameter = new SqliteParameter("@categoryid", DbType.Int32);
parameter.Value = category.Id;
command.Parameters.Add(parameter);
using (SqliteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Question question = new Question();
question.Id = Convert.ToInt32(reader["id"]);
question.Title = (string)reader["title"];
question.Category = category;
question.Answer = (string)reader["answer"];
question.AskCount = Convert.ToInt32(reader["askcount"]);
question.EasinessFactor = Convert.ToDouble(reader["easinessfactor"]);
question.Interval = Convert.ToInt32(reader["interval"]);
question.LastAsked = new DateTime(Convert.ToInt64(reader["lastasked"]));
question.NextAskOn = new DateTime(Convert.ToInt64(reader["nextaskon"]));
question.Order = Convert.ToInt32(reader["order"]);
question.PreviousInterval = Convert.ToInt32(reader["previousinterval"]);
question.ResponseQuality = Convert.ToInt32(reader["responsequality"]);
list.Add(question);
}
}
}
}
}
catch (SqliteException e)
{
Logger.Warn("SqliteException occurred with QuestionsForCategory({0}): \n{1}", category.Id, e);
}
return(list);
}
/// <summary>
/// Deletes the sub-family
/// </summary>
/// <param name="Sub_Familly_ID"></param>
/// <returns>true if everything went fine</returns>
public bool Delete_Sub_Familly(int Sub_Familly_ID)
{
System.Data.SQLite.SQLiteCommand cmd = SQL_Connection.CreateCommand();
cmd = SQL_Connection.CreateCommand();
cmd.CommandText = "DELETE FROM SousFamilles WHERE RefSousFamille = ?";
System.Data.SQLite.SQLiteParameter Id_Parameter = new System.Data.SQLite.SQLiteParameter();
Id_Parameter.Value = Sub_Familly_ID;
cmd.Parameters.Add(Id_Parameter);
int Nb = cmd.ExecuteNonQuery();
return(Nb == 1);
}
public DomainContextImpl(Domain domain, Context context, string insertStatement, int nbCols, DataTable sourceData)
{
_context = context;
_domain = domain;
_reader = sourceData.CreateDataReader();
_insertCommand = _context.CreateCommand();
_insertCommand.CommandText = insertStatement;
_insertParams = new System.Data.SQLite.SQLiteParameter[nbCols];
for (var u = 0; u < nbCols; ++u)
{
_insertParams[u] = new System.Data.SQLite.SQLiteParameter();
_insertCommand.Parameters.Add(_insertParams[u]);
}
}
public static ExecuteNonModel userUpdate(string user, string pwd, string power, string id)
{
System.Text.StringBuilder StrbSQL = new System.Text.StringBuilder();
LazySQL.Infrastructure.SQLiteTemplate sqlLiteT = new LazySQL.Infrastructure.SQLiteTemplate();
try
{
System.Collections.Generic.List <System.Data.SQLite.SQLiteParameter> aList = new System.Collections.Generic.List <System.Data.SQLite.SQLiteParameter>();
StrbSQL.Append("UPDATE user SET ");
System.Text.StringBuilder par0 = new System.Text.StringBuilder();
if (!string.IsNullOrWhiteSpace(user))
{
par0.Append("user = @userParSET");
System.Data.SQLite.SQLiteParameter userParSET = new System.Data.SQLite.SQLiteParameter("@userParSET", userParSET);
aList.Add(userParSET);
}
if (!string.IsNullOrWhiteSpace(pwd))
{
par0.Append(" , ");
par0.Append("pwd = @pwdParSET");
System.Data.SQLite.SQLiteParameter pwdParSET = new System.Data.SQLite.SQLiteParameter("@pwdParSET", pwdParSET);
aList.Add(pwdParSET);
}
if (!string.IsNullOrWhiteSpace(power))
{
par0.Append(" , ");
par0.Append("power = @powerParSET");
System.Data.SQLite.SQLiteParameter powerParSET = new System.Data.SQLite.SQLiteParameter("@powerParSET", powerParSET);
aList.Add(powerParSET);
}
StrbSQL.Append(par0);
StrbSQL.Append(" where ");
System.Text.StringBuilder par1 = new System.Text.StringBuilder();
if (!string.IsNullOrWhiteSpace(id))
{
par1.Append("id = @id");
System.Data.SQLite.SQLiteParameter idPar = new System.Data.SQLite.SQLiteParameter("@id", id);
aList.Add(idPar);
}
StrbSQL.Append(par1);
return(sqlLiteT.ExecuteNonQuery("Data Source=db\\sqlliteTest.db;Initial Catalog=sqlliteTest;Integrated Security=Tru" +
"e;Max Pool Size=10", StrbSQL, aList));
}
catch (System.Exception ex)
{
throw ex;;
}
}
/// <summary>
/// Returns true if the given family has any articles associated to it
/// </summary>
/// <param name="Id"></param>
/// <returns>true if articles are associated</returns>
public bool Family_Has_Articles_Associated(int Id)
{
System.Data.SQLite.SQLiteCommand cmd = SQL_Connection.CreateCommand();
cmd.CommandText = "SELECT COUNT(*) FROM Articles INNER JOIN SousFamilles ON (Articles.RefSousFamille = SousFamilles.RefSousFamille) WHERE RefFamille = ?";
System.Data.SQLite.SQLiteParameter Id_Parameter = new System.Data.SQLite.SQLiteParameter();
Id_Parameter.Value = Id;
cmd.Parameters.Add(Id_Parameter);
System.Data.SQLite.SQLiteDataReader Reader = cmd.ExecuteReader();
if (Reader.Read())
{
return(Reader.GetInt32(0) > 0);
}
return(false);
}
/// <summary>
/// Returns the id from the sub-family name and family id or create a new sub-family if none found.
/// </summary>
/// <param name="Familly_ID"></param>
/// <param name="Sub_Familly_Name"></param>
/// <returns>the sub-family id</returns>
public int Get_Or_Create_Sub_Familly(int Familly_ID, string Sub_Familly_Name)
{
// Check we have a valid familly ID.
if (Familly_ID == -1)
{
return(-1);
}
// Check if the ID is already in use.
int Id = Get_Sub_Familly_ID(Sub_Familly_Name);
if (Id != -1)
{
return(Id);
}
// Create the subfamilly.
Id = Get_New_Id("SousFamilles");
System.Data.SQLite.SQLiteCommand cmd = SQL_Connection.CreateCommand();
cmd.CommandText = "INSERT INTO SousFamilles (RefSousFamille, RefFamille, Nom) VALUES (?, ?, ?)";
System.Data.SQLite.SQLiteParameter Id_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Family_Id_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Name_Parameter = new System.Data.SQLite.SQLiteParameter();
Id_Parameter.Value = Id;
Family_Id_Parameter.Value = Familly_ID;
Name_Parameter.Value = Sub_Familly_Name;
cmd.Parameters.Add(Id_Parameter);
cmd.Parameters.Add(Family_Id_Parameter);
cmd.Parameters.Add(Name_Parameter);
int Nb = cmd.ExecuteNonQuery();
if (Nb != 1)
{
return(-1);
}
else
{
return(Id);
}
}
private async Task SaveResult(Result result)
{
await Task.Run(() => {
using (SQLiteUtil sqlite = new SQLiteUtil(dbPath))
{
var sql = "Insert Into Result (CityID,Html,RestaurentName,AverageSpend,Keyword) values (@CityID,@Html,@RestaurentName,@AverageSpend,@Keyword)";
System.Data.SQLite.SQLiteParameter[] parameters = new System.Data.SQLite.SQLiteParameter[]
{
new System.Data.SQLite.SQLiteParameter("@CityID", result.CityID),
new System.Data.SQLite.SQLiteParameter("@Html", result.Html),
new System.Data.SQLite.SQLiteParameter("@RestaurentName", result.RestaurentName),
new System.Data.SQLite.SQLiteParameter("@AverageSpend", result.AverageSpend),
new System.Data.SQLite.SQLiteParameter("@Keyword", result.Keyword)
};
sqlite.ExecuteNonQuery(sql, parameters);
}
});
}
/// <summary>
/// Updates the article
/// </summary>
/// <param name="Description"></param>
/// <param name="Reference"></param>
/// <param name="Marque"></param>
/// <param name="SousFamille"></param>
/// <param name="PrixHT"></param>
/// <param name="Quantity"></param>
/// <returns>true if everything went fine<returns>
public bool Update_Article(string Description, string Reference, int Marque, int SousFamille, float PrixHT, int Quantity)
{
if (Quantity == -1)
{
Quantity = Count_Articles_Id(Reference);
}
if (Quantity == -1)
{
return(false);
}
System.Data.SQLite.SQLiteCommand cmd = SQL_Connection.CreateCommand();
cmd = SQL_Connection.CreateCommand();
cmd.CommandText = "UPDATE Articles SET Description = ?, RefSousFamille = ?, RefMarque = ?, PrixHT = ?, Quantite = ? WHERE RefArticle = ?";
System.Data.SQLite.SQLiteParameter Description_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Sub_Fammilly_Id_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Brand_Id_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Price_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Quantity_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Id_Parameter = new System.Data.SQLite.SQLiteParameter();
Description_Parameter.Value = Description;
Sub_Fammilly_Id_Parameter.Value = SousFamille;
Brand_Id_Parameter.Value = Marque;
Price_Parameter.Value = PrixHT;
Quantity_Parameter.Value = Quantity;
Id_Parameter.Value = Reference;
cmd.Parameters.Add(Description_Parameter);
cmd.Parameters.Add(Sub_Fammilly_Id_Parameter);
cmd.Parameters.Add(Brand_Id_Parameter);
cmd.Parameters.Add(Price_Parameter);
cmd.Parameters.Add(Quantity_Parameter);
cmd.Parameters.Add(Id_Parameter);
int Nb = cmd.ExecuteNonQuery();
return(Nb == 1);
}
/// <summary>
/// Updates the brand
/// </summary>
/// <param name="Brand_ID"></param>
/// <param name="Brand_Name"></param>
/// <returns>true if everything went fine</returns>
public bool Update_Brand(int Brand_ID, string Brand_Name)
{
System.Data.SQLite.SQLiteCommand cmd = SQL_Connection.CreateCommand();
cmd = SQL_Connection.CreateCommand();
cmd.CommandText = "UPDATE Marques SET Nom = ? WHERE RefMarque = ?";
System.Data.SQLite.SQLiteParameter Name_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Id_Parameter = new System.Data.SQLite.SQLiteParameter();
Name_Parameter.Value = Brand_Name;
Id_Parameter.Value = Brand_ID;
cmd.Parameters.Add(Name_Parameter);
cmd.Parameters.Add(Id_Parameter);
int Nb = cmd.ExecuteNonQuery();
return(Nb == 1);
}
/// <summary>
/// Creates an article
/// </summary>
/// <param name="Article_ID"></param>
/// <param name="Sub_Familly_ID"></param>
/// <param name="Brand_ID"></param>
/// <param name="Description"></param>
/// <param name="Prix"></param>
/// <param name="Quantity"></param>
/// <returns>the id</returns>
public bool Create_Article(string Article_ID, int Sub_Familly_ID, int Brand_ID, string Description, float Prix, int Quantity)
{
// Check values.
if (Sub_Familly_ID == -1 || Brand_ID == -1)
{
return(false);
}
int Number = Count_Articles_Id(Article_ID);
if (Number != -1)
{
return(false);
}
System.Data.SQLite.SQLiteCommand cmd = SQL_Connection.CreateCommand();
cmd.CommandText = "INSERT INTO Articles (RefArticle, Description, RefSousFamille, RefMarque, PrixHT, Quantite) VALUES (?, ?, ?, ?, ?, ?)";
System.Data.SQLite.SQLiteParameter Id_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Description_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Sub_Fammilly_Id_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Brand_Id_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Price_Parameter = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter Quantity_Parameter = new System.Data.SQLite.SQLiteParameter();
Id_Parameter.Value = Article_ID;
Description_Parameter.Value = Description;
Sub_Fammilly_Id_Parameter.Value = Sub_Familly_ID;
Brand_Id_Parameter.Value = Brand_ID;
Price_Parameter.Value = Prix;
Quantity_Parameter.Value = Quantity;
cmd.Parameters.Add(Id_Parameter);
cmd.Parameters.Add(Description_Parameter);
cmd.Parameters.Add(Sub_Fammilly_Id_Parameter);
cmd.Parameters.Add(Brand_Id_Parameter);
cmd.Parameters.Add(Price_Parameter);
cmd.Parameters.Add(Quantity_Parameter);
int Nb = cmd.ExecuteNonQuery();
return(Nb == 1);
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (txtCompanyName.Text == string.Empty)
{
txtCompanyName.Focus();
return;
}
//Submit all changes
if (currentState == AddressBookState.Add)
{
using (var cmd = new System.Data.SQLite.SQLiteCommand(DataBase.Instance.sqlConnection))
{
cmd.CommandText = "insert into AddressBook(CompanyName,President,Contact,Tel,Fax,Cellphone,Address1,Address2,SerialNumber,State,PhoneFormatId) values(@CompanyName,@President,@Contact,@Tel,@Fax,@Cellphone,@Address1,@Address2,@SerialNumber,@State,@PhoneFormatId); Select last_insert_rowid()";
System.Data.SQLite.SQLiteParameter[] parameters = new System.Data.SQLite.SQLiteParameter[11];
parameters[0] = new System.Data.SQLite.SQLiteParameter("CompanyName", txtCompanyName.Text);
parameters[1] = new System.Data.SQLite.SQLiteParameter("President", txtPresident.Text);
parameters[2] = new System.Data.SQLite.SQLiteParameter("Contact", txtContact.Text);
parameters[3] = new System.Data.SQLite.SQLiteParameter("Tel", mtxtTel.Text);
parameters[4] = new System.Data.SQLite.SQLiteParameter("Fax", mtxtFax.Text);
parameters[5] = new System.Data.SQLite.SQLiteParameter("Cellphone", mtxtCellphone.Text);
parameters[6] = new System.Data.SQLite.SQLiteParameter("Address1", txtAddress1.Text);
parameters[7] = new System.Data.SQLite.SQLiteParameter("Address2", txtAddress2.Text);
parameters[8] = new System.Data.SQLite.SQLiteParameter("SerialNumber", mtxtSerialNumber.Text);
parameters[9] = new System.Data.SQLite.SQLiteParameter("State", cbbState.SelectedText);
parameters[10] = new System.Data.SQLite.SQLiteParameter("PhoneFormatId", cbbPhoneFormat.SelectedIndex);
cmd.Parameters.AddRange(parameters);
long insertedId = (long)cmd.ExecuteScalar();
CurrentCompany.Id = (int)insertedId;
}
}
else if (currentState == AddressBookState.Modify)
{
using (var cmd = new System.Data.SQLite.SQLiteCommand(DataBase.Instance.sqlConnection))
{
cmd.Parameters.Add(cmd.CreateParameter());
cmd.CommandText = "update AddressBook set CompanyName = @CompanyName,President = @President,Contact = @Contact,Tel = @Tel,Fax = @Fax,Cellphone = @Cellphone,Address1 = @Address1,Address2 = @Address2, SerialNumber = @SerialNumber, State = @State, PhoneFormatId = @PhoneFormatId where Id = @Id";
System.Data.SQLite.SQLiteParameter[] parameters = new System.Data.SQLite.SQLiteParameter[12];
parameters[0] = new System.Data.SQLite.SQLiteParameter("CompanyName", txtCompanyName.Text);
parameters[1] = new System.Data.SQLite.SQLiteParameter("President", txtPresident.Text);
parameters[2] = new System.Data.SQLite.SQLiteParameter("Contact", txtContact.Text);
parameters[3] = new System.Data.SQLite.SQLiteParameter("Tel", mtxtTel.Text);
parameters[4] = new System.Data.SQLite.SQLiteParameter("Fax", mtxtFax.Text);
parameters[5] = new System.Data.SQLite.SQLiteParameter("Cellphone", mtxtCellphone.Text);
parameters[6] = new System.Data.SQLite.SQLiteParameter("Address1", txtAddress1.Text);
parameters[7] = new System.Data.SQLite.SQLiteParameter("Address2", txtAddress2.Text);
parameters[8] = new System.Data.SQLite.SQLiteParameter("Id", CurrentCompany.Id);
parameters[9] = new System.Data.SQLite.SQLiteParameter("SerialNumber", mtxtSerialNumber.Text);
parameters[10] = new System.Data.SQLite.SQLiteParameter("State", cbbState.Text);
parameters[11] = new System.Data.SQLite.SQLiteParameter("PhoneFormatId", cbbPhoneFormat.SelectedIndex);
cmd.Parameters.AddRange(parameters);
cmd.ExecuteNonQuery();
}
}
currentState = AddressBookState.View;
companies.ResetItem(customControl1.SelectedIndex);
UpdateControls();
}
public void MoveQuestion(Question question, int newIndex)
{
int currentIndex = 0; // not the order, the list index.
// All questions, find the question's index
IList<Question> questions = ListQuestions().OrderBy(q => q.Order).ToList();
for (int i = 0; i < questions.Count; i++)
{
if (questions[i].Id == question.Id)
{
currentIndex = i;
break;
}
}
// Move all items after the new index up one
var after = questions.Where(q => q.Order >= newIndex).ToList();
for (int i = 0; i < after.Count; i++)
{
after[i].Order += 1;
}
questions[currentIndex].Order = newIndex;
// Re-order
var ordered = questions.OrderBy(q => q.Order).ToList();
for (int i = 0; i < ordered.Count; i++)
{
ordered[i].Order = i;
}
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
// TODO: put inside a transaction (not WinSQLite friendly)
command.CommandText = @"UPDATE questions SET [order]=@order WHERE id=@id";
foreach (Question questionItem in ordered)
{
SqliteParameter parameter = new SqliteParameter("@id", DbType.Int32);
parameter.Value = questionItem.Id;
command.Parameters.Add(parameter);
parameter = new SqliteParameter("@order", DbType.Int32);
parameter.Value = questionItem.Order;
command.Parameters.Add(parameter);
command.ExecuteNonQuery();
}
}
}
}
catch (SqliteException ex)
{
Logger.Fatal("Unable to MoveQuestion: \n{0}", ex);
throw;
}
}
public IList<Question> QuestionsForCategory(Category category)
{
IList<Question> list = new List<Question>();
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
command.CommandText = "SELECT * FROM questions WHERE categoryid = @categoryid";
SqliteParameter parameter = new SqliteParameter("@categoryid", DbType.Int32);
parameter.Value = category.Id;
command.Parameters.Add(parameter);
using (SqliteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Question question = new Question();
question.Id = Convert.ToInt32(reader["id"]);
question.Title = (string)reader["title"];
question.Category = category;
question.Answer = (string)reader["answer"];
question.AskCount = Convert.ToInt32(reader["askcount"]);
question.EasinessFactor = Convert.ToDouble(reader["easinessfactor"]);
question.Interval = Convert.ToInt32(reader["interval"]);
question.LastAsked = new DateTime(Convert.ToInt64(reader["lastasked"]));
question.NextAskOn = new DateTime(Convert.ToInt64(reader["nextaskon"]));
question.Order = Convert.ToInt32(reader["order"]);
question.PreviousInterval = Convert.ToInt32(reader["previousinterval"]);
question.ResponseQuality = Convert.ToInt32(reader["responsequality"]);
list.Add(question);
}
}
}
}
}
catch (SqliteException e)
{
Logger.Warn("SqliteException occurred with QuestionsForCategory({0}): \n{1}", category.Id,e);
}
return list;
}
public Category ReadCategory(int id)
{
Category category = new Category();
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
command.CommandText = "SELECT * FROM categories WHERE id=@id";
SqliteParameter parameter = new SqliteParameter("@id", DbType.Int32);
parameter.Value = id;
command.Parameters.Add(parameter);
using (SqliteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
category.Id = Convert.ToInt32(reader["categoryid"]);
category.InBuilt = Convert.ToBoolean(reader["inbuilt"]);
category.Name = (string)reader["categoryName"];
category.Active = Convert.ToBoolean(reader["active"]);
}
}
}
}
}
catch (SqliteException e)
{
Logger.Warn("SqliteException occurred with ReadCategory({0}): \n{1}", id, e);
}
return category;
}
public Question ReadQuestion(int id)
{
Question question = new Question();
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
command.CommandText = "SELECT q.*,c.Name as categoryName,c.inbuilt as inbuilt,c.active as active"+
"FROM questions q, categories c WHERE c.id = q.categoryid AND id=@id";
SqliteParameter parameter = new SqliteParameter("@id", DbType.Int32);
parameter.Value = id;
command.Parameters.Add(parameter);
using (SqliteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
question.Id = Convert.ToInt32(reader["id"]);
question.Title = (string)reader["title"];
question.Category = new Category();
question.Category.Id = Convert.ToInt32(reader["categoryid"]);
question.Category.InBuilt = Convert.ToBoolean(reader["inbuilt"]);
question.Category.Active = Convert.ToBoolean(reader["active"]);
question.Category.Name = (string)reader["categoryName"];
question.Answer = (string)reader["answer"];
question.AskCount = Convert.ToInt32(reader["askcount"]);
question.EasinessFactor = Convert.ToDouble(reader["easinessfactor"]);
question.Interval = Convert.ToInt32(reader["interval"]);
question.LastAsked = new DateTime(Convert.ToInt64(reader["lastasked"]));
question.NextAskOn = new DateTime(Convert.ToInt64(reader["nextaskon"]));
question.Order = Convert.ToInt32(reader["order"]);
question.PreviousInterval = Convert.ToInt32(reader["previousinterval"]);
question.ResponseQuality = Convert.ToInt32(reader["responsequality"]);
}
}
}
}
}
catch (SqliteException e)
{
Logger.Warn("SqliteException occurred with ReadQuestion({0}): \n{1}", id,e);
}
return question;
}
public int SaveCategory(Category category)
{
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
bool updating = (category.Id > 0);
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
SqliteParameter parameter;
string sql = @"INSERT INTO categories (name,active) VALUES (@name,@active);SELECT last_insert_rowid();";
if (updating)
{
sql = @"UPDATE categories SET name=@name,active=@active WHERE id=@id";
parameter = new SqliteParameter("@id", DbType.Int32);
parameter.Value = category.Id;
command.Parameters.Add(parameter);
}
parameter = new SqliteParameter("@name", DbType.String);
parameter.Value = category.Name;
command.Parameters.Add(parameter);
parameter = new SqliteParameter("@active", DbType.Boolean);
parameter.Value = category.Active;
command.Parameters.Add(parameter);
command.CommandText = sql;
int result;
if (updating)
{
command.ExecuteNonQuery();
result = category.Id;
// If result isn't the categoryid, then ignore it
}
else
{
Int64 newId = (Int64)command.ExecuteScalar();
result = Convert.ToInt32(newId);
category.Id = result;
}
return result;
}
}
}
catch (SqliteException e)
{
Logger.Warn("SqliteException occurred with SaveCategory({0}): \n{1}", category.Id, e);
}
return 0;
}
public int SaveQuestion(Question question)
{
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
bool updating = (question.Id > 0);
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
SqliteParameter parameter;
string sql = @"INSERT INTO questions (answer,askcount,categoryid,easinessfactor,interval,lastasked,nextaskon,[order],previousinterval,responsequality,title) ";
sql += "VALUES (@answer,@askcount,@categoryid,@easinessfactor,@interval,@lastasked,@nextaskon,@order,@previousinterval,@responsequality,@title);SELECT last_insert_rowid();";
if (updating)
{
sql = @"UPDATE questions SET answer=@answer,askcount=@askcount,categoryid=@categoryid,easinessfactor=@easinessfactor,interval=@interval,";
sql += "lastasked=@lastasked,nextaskon=@nextaskon,[order]=@order,previousinterval=@previousinterval,responsequality=@responsequality,title=@title ";
sql += "WHERE id=@id";
parameter = new SqliteParameter("@id", DbType.Int32);
parameter.Value = question.Id;
command.Parameters.Add(parameter);
}
parameter = new SqliteParameter("@title", DbType.String);
parameter.Value = question.Title;
command.Parameters.Add(parameter);
parameter = new SqliteParameter("@answer", DbType.String);
parameter.Value = question.Answer;
command.Parameters.Add(parameter);
parameter = new SqliteParameter("@askcount", DbType.Int32);
parameter.Value = question.AskCount;
command.Parameters.Add(parameter);
parameter = new SqliteParameter("@categoryid", DbType.Int32);
parameter.Value = question.Category.Id;
command.Parameters.Add(parameter);
parameter = new SqliteParameter("@easinessfactor", DbType.Double);
parameter.Value = question.EasinessFactor;
command.Parameters.Add(parameter);
parameter = new SqliteParameter("@interval", DbType.Int32);
parameter.Value = question.Interval;
command.Parameters.Add(parameter);
parameter = new SqliteParameter("@lastasked", DbType.Int64);
parameter.Value = question.LastAsked.Ticks;
command.Parameters.Add(parameter);
parameter = new SqliteParameter("@nextaskon", DbType.Int64);
parameter.Value = question.NextAskOn.Ticks;
command.Parameters.Add(parameter);
parameter = new SqliteParameter("@order", DbType.Int32);
if (updating)
{
parameter.Value = question.Order;
}
else
{
parameter.Value = MaxQuestionOrder(question.Category) +1;
}
command.Parameters.Add(parameter);
parameter = new SqliteParameter("@previousinterval", DbType.Int32);
parameter.Value = question.PreviousInterval;
command.Parameters.Add(parameter);
parameter = new SqliteParameter("@responsequality", DbType.Int32);
parameter.Value = question.ResponseQuality;
command.Parameters.Add(parameter);
command.CommandText = sql;
int result;
if (updating)
{
command.ExecuteNonQuery();
result = question.Id;
}
else
{
Int64 newId = (Int64)command.ExecuteScalar();
result = Convert.ToInt32(newId);
}
return result;
}
}
}
catch (SqliteException e)
{
Logger.Warn("SqliteException occurred with SaveQuestion({0}): \n{1}", question.Id, e);
}
return 0;
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.Data.SQLite.SQLiteParameter sqLiteParameter54 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter55 = new System.Data.SQLite.SQLiteParameter();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(LogBrowserForm));
System.Data.SQLite.SQLiteParameter sqLiteParameter56 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter57 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter58 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter59 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter60 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter61 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter62 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter63 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter64 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter65 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter66 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter67 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter68 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter69 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter70 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter71 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter72 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter73 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter74 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter75 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter76 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter1 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter2 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter77 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter78 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter79 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter80 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter81 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter82 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter83 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter84 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter85 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter86 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter87 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter88 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter89 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter90 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter91 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter92 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter93 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter94 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter95 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter96 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter97 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter98 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter99 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter100 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter101 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter102 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter103 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter104 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter105 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter106 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter107 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter108 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter109 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter110 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter111 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter112 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter113 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter114 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter115 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter116 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter117 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter118 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter119 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter120 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter121 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter122 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter123 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter124 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter125 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter3 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter4 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter5 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter6 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter7 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter8 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter9 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter10 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter11 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter12 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter13 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter14 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter15 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter16 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter17 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter18 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter19 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter20 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter21 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter22 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter23 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter126 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter127 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter128 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter129 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter130 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter131 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter132 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter133 = new System.Data.SQLite.SQLiteParameter();
System.Data.SQLite.SQLiteParameter sqLiteParameter134 = new System.Data.SQLite.SQLiteParameter();
this.logDataGridView = new System.Windows.Forms.DataGridView();
this.tabControl1 = new System.Windows.Forms.TabControl();
this.tabPage1 = new System.Windows.Forms.TabPage();
this.tabPage2 = new System.Windows.Forms.TabPage();
this.dataGridView2 = new System.Windows.Forms.DataGridView();
this.sqliteSelectCommand1 = new System.Data.SQLite.SQLiteCommand();
this.logDataAdapter = new System.Data.SQLite.SQLiteDataAdapter();
this.sqLiteConnection1 = new System.Data.SQLite.SQLiteConnection();
this.InsertCommand = new System.Data.SQLite.SQLiteCommand();
this.sqliteSelectCommand2 = new System.Data.SQLite.SQLiteCommand();
this.sqliteInsertCommand1 = new System.Data.SQLite.SQLiteCommand();
this.sqliteUpdateCommand1 = new System.Data.SQLite.SQLiteCommand();
this.sqliteDeleteCommand1 = new System.Data.SQLite.SQLiteCommand();
this.serverDataAdapter = new System.Data.SQLite.SQLiteDataAdapter();
this.serverDataSet = new SensorShare.Desktop.serverDataSet();
this.serversBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.dataGridViewTextBoxColumn21 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn22 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn23 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn24 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn25 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn26 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn27 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn28 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn29 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn30 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn31 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn32 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn33 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn34 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn35 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn36 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewImageColumn2 = new System.Windows.Forms.DataGridViewImageColumn();
this.dataGridViewTextBoxColumn37 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn38 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn39 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn40 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.logDataSet = new SensorShare.Desktop.logDataSet();
this.logBindingSource = new System.Windows.Forms.BindingSource(this.components);
this.timeDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.messageDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
((System.ComponentModel.ISupportInitialize)(this.logDataGridView)).BeginInit();
this.tabControl1.SuspendLayout();
this.tabPage1.SuspendLayout();
this.tabPage2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.serverDataSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.serversBindingSource)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.logDataSet)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.logBindingSource)).BeginInit();
this.SuspendLayout();
//
// logDataGridView
//
this.logDataGridView.AllowUserToAddRows = false;
this.logDataGridView.AllowUserToDeleteRows = false;
this.logDataGridView.AutoGenerateColumns = false;
this.logDataGridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.logDataGridView.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.timeDataGridViewTextBoxColumn,
this.messageDataGridViewTextBoxColumn});
this.logDataGridView.DataSource = this.logBindingSource;
this.logDataGridView.Dock = System.Windows.Forms.DockStyle.Fill;
this.logDataGridView.Location = new System.Drawing.Point(3, 3);
this.logDataGridView.Name = "logDataGridView";
this.logDataGridView.ReadOnly = true;
this.logDataGridView.Size = new System.Drawing.Size(596, 393);
this.logDataGridView.TabIndex = 0;
//
// tabControl1
//
this.tabControl1.Controls.Add(this.tabPage1);
this.tabControl1.Controls.Add(this.tabPage2);
this.tabControl1.Dock = System.Windows.Forms.DockStyle.Fill;
this.tabControl1.Location = new System.Drawing.Point(0, 0);
this.tabControl1.Name = "tabControl1";
this.tabControl1.SelectedIndex = 0;
this.tabControl1.Size = new System.Drawing.Size(610, 425);
this.tabControl1.TabIndex = 1;
//
// tabPage1
//
this.tabPage1.Controls.Add(this.logDataGridView);
this.tabPage1.Location = new System.Drawing.Point(4, 22);
this.tabPage1.Name = "tabPage1";
this.tabPage1.Padding = new System.Windows.Forms.Padding(3);
this.tabPage1.Size = new System.Drawing.Size(602, 399);
this.tabPage1.TabIndex = 0;
this.tabPage1.Text = "tabPage1";
this.tabPage1.UseVisualStyleBackColor = true;
//
// tabPage2
//
this.tabPage2.Controls.Add(this.dataGridView2);
this.tabPage2.Location = new System.Drawing.Point(4, 22);
this.tabPage2.Name = "tabPage2";
this.tabPage2.Padding = new System.Windows.Forms.Padding(3);
this.tabPage2.Size = new System.Drawing.Size(602, 399);
this.tabPage2.TabIndex = 1;
this.tabPage2.Text = "tabPage2";
this.tabPage2.UseVisualStyleBackColor = true;
//
// dataGridView2
//
this.dataGridView2.AllowUserToAddRows = false;
this.dataGridView2.AllowUserToDeleteRows = false;
this.dataGridView2.AllowUserToOrderColumns = true;
this.dataGridView2.AutoGenerateColumns = false;
this.dataGridView2.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView2.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.dataGridViewTextBoxColumn21,
this.dataGridViewTextBoxColumn22,
this.dataGridViewTextBoxColumn23,
this.dataGridViewTextBoxColumn24,
this.dataGridViewTextBoxColumn25,
this.dataGridViewTextBoxColumn26,
this.dataGridViewTextBoxColumn27,
this.dataGridViewTextBoxColumn28,
this.dataGridViewTextBoxColumn29,
this.dataGridViewTextBoxColumn30,
this.dataGridViewTextBoxColumn31,
this.dataGridViewTextBoxColumn32,
this.dataGridViewTextBoxColumn33,
this.dataGridViewTextBoxColumn34,
this.dataGridViewTextBoxColumn35,
this.dataGridViewTextBoxColumn36,
this.dataGridViewImageColumn2,
this.dataGridViewTextBoxColumn37,
this.dataGridViewTextBoxColumn38,
this.dataGridViewTextBoxColumn39,
this.dataGridViewTextBoxColumn40});
this.dataGridView2.DataSource = this.serversBindingSource;
this.dataGridView2.Dock = System.Windows.Forms.DockStyle.Fill;
this.dataGridView2.Location = new System.Drawing.Point(3, 3);
this.dataGridView2.Name = "dataGridView2";
this.dataGridView2.ReadOnly = true;
this.dataGridView2.Size = new System.Drawing.Size(596, 393);
this.dataGridView2.TabIndex = 0;
//
// sqliteSelectCommand1
//
this.sqliteSelectCommand1.CommandText = "SELECT [time], message\r\nFROM log";
this.sqliteSelectCommand1.Connection = this.sqLiteConnection1;
//
// logDataAdapter
//
this.logDataAdapter.InsertCommand = this.InsertCommand;
this.logDataAdapter.SelectCommand = this.sqliteSelectCommand1;
this.logDataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "log", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("time", "time"),
new System.Data.Common.DataColumnMapping("message", "message")})});
//
// sqLiteConnection1
//
this.sqLiteConnection1.ConnectionString = "data source=\"D:\\mcp\\Temp\\sqlite databases\\SensorShareServer.db\"";
this.sqLiteConnection1.DefaultTimeout = 30;
//
// InsertCommand
//
this.InsertCommand.CommandText = "INSERT INTO [log] ([time], [message]) VALUES (@time, @message)";
this.InsertCommand.Connection = this.sqLiteConnection1;
sqLiteParameter54.ParameterName = "@time";
sqLiteParameter54.SourceColumn = "time";
sqLiteParameter55.ParameterName = "@message";
sqLiteParameter55.SourceColumn = "message";
this.InsertCommand.Parameters.AddRange(new System.Data.SQLite.SQLiteParameter[] {
sqLiteParameter54,
sqLiteParameter55});
//
// sqliteSelectCommand2
//
this.sqliteSelectCommand2.CommandText = resources.GetString("sqliteSelectCommand2.CommandText");
this.sqliteSelectCommand2.Connection = this.sqLiteConnection1;
//
// sqliteInsertCommand1
//
this.sqliteInsertCommand1.CommandText = resources.GetString("sqliteInsertCommand1.CommandText");
this.sqliteInsertCommand1.Connection = this.sqLiteConnection1;
sqLiteParameter56.ParameterName = "@server_id";
sqLiteParameter56.SourceColumn = "server_id";
sqLiteParameter57.ParameterName = "@name";
sqLiteParameter57.SourceColumn = "name";
sqLiteParameter58.ParameterName = "@description";
sqLiteParameter58.SourceColumn = "description";
sqLiteParameter59.ParameterName = "@location";
sqLiteParameter59.SourceColumn = "location";
sqLiteParameter60.ParameterName = "@image";
sqLiteParameter60.SourceColumn = "image";
sqLiteParameter61.ParameterName = "@sensor_1_name";
sqLiteParameter61.SourceColumn = "sensor_1_name";
sqLiteParameter62.ParameterName = "@sensor_2_name";
sqLiteParameter62.SourceColumn = "sensor_2_name";
sqLiteParameter63.ParameterName = "@sensor_3_name";
sqLiteParameter63.SourceColumn = "sensor_3_name";
sqLiteParameter64.ParameterName = "@sensor_4_name";
sqLiteParameter64.SourceColumn = "sensor_4_name";
sqLiteParameter65.ParameterName = "@sensor_1_unit";
sqLiteParameter65.SourceColumn = "sensor_1_unit";
sqLiteParameter66.ParameterName = "@sensor_2_unit";
sqLiteParameter66.SourceColumn = "sensor_2_unit";
sqLiteParameter67.ParameterName = "@sensor_3_unit";
sqLiteParameter67.SourceColumn = "sensor_3_unit";
sqLiteParameter68.ParameterName = "@sensor_4_unit";
sqLiteParameter68.SourceColumn = "sensor_4_unit";
sqLiteParameter69.ParameterName = "@sensor_1_range";
sqLiteParameter69.SourceColumn = "sensor_1_range";
sqLiteParameter70.ParameterName = "@sensor_2_range";
sqLiteParameter70.SourceColumn = "sensor_2_range";
sqLiteParameter71.ParameterName = "@sensor_3_range";
sqLiteParameter71.SourceColumn = "sensor_3_range";
sqLiteParameter72.ParameterName = "@sensor_4_range";
sqLiteParameter72.SourceColumn = "sensor_4_range";
sqLiteParameter73.ParameterName = "@sensor_1_id";
sqLiteParameter73.SourceColumn = "sensor_1_id";
sqLiteParameter74.ParameterName = "@sensor_2_id";
sqLiteParameter74.SourceColumn = "sensor_2_id";
sqLiteParameter75.ParameterName = "@sensor_3_id";
sqLiteParameter75.SourceColumn = "sensor_3_id";
sqLiteParameter76.ParameterName = "@sensor_4_id";
sqLiteParameter76.SourceColumn = "sensor_4_id";
this.sqliteInsertCommand1.Parameters.AddRange(new System.Data.SQLite.SQLiteParameter[] {
sqLiteParameter56,
sqLiteParameter57,
sqLiteParameter58,
sqLiteParameter59,
sqLiteParameter60,
sqLiteParameter61,
sqLiteParameter62,
sqLiteParameter63,
sqLiteParameter64,
sqLiteParameter65,
sqLiteParameter66,
sqLiteParameter67,
sqLiteParameter68,
sqLiteParameter69,
sqLiteParameter70,
sqLiteParameter71,
sqLiteParameter72,
sqLiteParameter73,
sqLiteParameter74,
sqLiteParameter75,
sqLiteParameter76});
//
// sqliteUpdateCommand1
//
this.sqliteUpdateCommand1.CommandText = resources.GetString("sqliteUpdateCommand1.CommandText");
this.sqliteUpdateCommand1.Connection = this.sqLiteConnection1;
sqLiteParameter1.ParameterName = "@server_id";
sqLiteParameter1.SourceColumn = "server_id";
sqLiteParameter2.ParameterName = "@name";
sqLiteParameter2.SourceColumn = "name";
sqLiteParameter77.ParameterName = "@description";
sqLiteParameter77.SourceColumn = "description";
sqLiteParameter78.ParameterName = "@location";
sqLiteParameter78.SourceColumn = "location";
sqLiteParameter79.ParameterName = "@image";
sqLiteParameter79.SourceColumn = "image";
sqLiteParameter80.ParameterName = "@sensor_1_name";
sqLiteParameter80.SourceColumn = "sensor_1_name";
sqLiteParameter81.ParameterName = "@sensor_2_name";
sqLiteParameter81.SourceColumn = "sensor_2_name";
sqLiteParameter82.ParameterName = "@sensor_3_name";
sqLiteParameter82.SourceColumn = "sensor_3_name";
sqLiteParameter83.ParameterName = "@sensor_4_name";
sqLiteParameter83.SourceColumn = "sensor_4_name";
sqLiteParameter84.ParameterName = "@sensor_1_unit";
sqLiteParameter84.SourceColumn = "sensor_1_unit";
sqLiteParameter85.ParameterName = "@sensor_2_unit";
sqLiteParameter85.SourceColumn = "sensor_2_unit";
sqLiteParameter86.ParameterName = "@sensor_3_unit";
sqLiteParameter86.SourceColumn = "sensor_3_unit";
sqLiteParameter87.ParameterName = "@sensor_4_unit";
sqLiteParameter87.SourceColumn = "sensor_4_unit";
sqLiteParameter88.ParameterName = "@sensor_1_range";
sqLiteParameter88.SourceColumn = "sensor_1_range";
sqLiteParameter89.ParameterName = "@sensor_2_range";
sqLiteParameter89.SourceColumn = "sensor_2_range";
sqLiteParameter90.ParameterName = "@sensor_3_range";
sqLiteParameter90.SourceColumn = "sensor_3_range";
sqLiteParameter91.ParameterName = "@sensor_4_range";
sqLiteParameter91.SourceColumn = "sensor_4_range";
sqLiteParameter92.ParameterName = "@sensor_1_id";
sqLiteParameter92.SourceColumn = "sensor_1_id";
sqLiteParameter93.ParameterName = "@sensor_2_id";
sqLiteParameter93.SourceColumn = "sensor_2_id";
sqLiteParameter94.ParameterName = "@sensor_3_id";
sqLiteParameter94.SourceColumn = "sensor_3_id";
sqLiteParameter95.ParameterName = "@sensor_4_id";
sqLiteParameter95.SourceColumn = "sensor_4_id";
sqLiteParameter96.ParameterName = "@Original_server_id";
sqLiteParameter96.SourceColumn = "server_id";
sqLiteParameter96.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter97.ParameterName = "@Original_name";
sqLiteParameter97.SourceColumn = "name";
sqLiteParameter97.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter98.ParameterName = "@Original_description";
sqLiteParameter98.SourceColumn = "description";
sqLiteParameter98.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter99.ParameterName = "@Original_location";
sqLiteParameter99.SourceColumn = "location";
sqLiteParameter99.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter100.ParameterName = "@IsNull_image";
sqLiteParameter100.SourceColumn = "image";
sqLiteParameter100.SourceColumnNullMapping = true;
sqLiteParameter100.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter101.ParameterName = "@Original_image";
sqLiteParameter101.SourceColumn = "image";
sqLiteParameter101.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter102.ParameterName = "@IsNull_sensor_1_name";
sqLiteParameter102.SourceColumn = "sensor_1_name";
sqLiteParameter102.SourceColumnNullMapping = true;
sqLiteParameter102.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter103.ParameterName = "@Original_sensor_1_name";
sqLiteParameter103.SourceColumn = "sensor_1_name";
sqLiteParameter103.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter104.ParameterName = "@IsNull_sensor_2_name";
sqLiteParameter104.SourceColumn = "sensor_2_name";
sqLiteParameter104.SourceColumnNullMapping = true;
sqLiteParameter104.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter105.ParameterName = "@Original_sensor_2_name";
sqLiteParameter105.SourceColumn = "sensor_2_name";
sqLiteParameter105.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter106.ParameterName = "@IsNull_sensor_3_name";
sqLiteParameter106.SourceColumn = "sensor_3_name";
sqLiteParameter106.SourceColumnNullMapping = true;
sqLiteParameter106.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter107.ParameterName = "@Original_sensor_3_name";
sqLiteParameter107.SourceColumn = "sensor_3_name";
sqLiteParameter107.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter108.ParameterName = "@IsNull_sensor_4_name";
sqLiteParameter108.SourceColumn = "sensor_4_name";
sqLiteParameter108.SourceColumnNullMapping = true;
sqLiteParameter108.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter109.ParameterName = "@Original_sensor_4_name";
sqLiteParameter109.SourceColumn = "sensor_4_name";
sqLiteParameter109.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter110.ParameterName = "@IsNull_sensor_1_unit";
sqLiteParameter110.SourceColumn = "sensor_1_unit";
sqLiteParameter110.SourceColumnNullMapping = true;
sqLiteParameter110.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter111.ParameterName = "@Original_sensor_1_unit";
sqLiteParameter111.SourceColumn = "sensor_1_unit";
sqLiteParameter111.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter112.ParameterName = "@IsNull_sensor_2_unit";
sqLiteParameter112.SourceColumn = "sensor_2_unit";
sqLiteParameter112.SourceColumnNullMapping = true;
sqLiteParameter112.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter113.ParameterName = "@Original_sensor_2_unit";
sqLiteParameter113.SourceColumn = "sensor_2_unit";
sqLiteParameter113.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter114.ParameterName = "@IsNull_sensor_3_unit";
sqLiteParameter114.SourceColumn = "sensor_3_unit";
sqLiteParameter114.SourceColumnNullMapping = true;
sqLiteParameter114.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter115.ParameterName = "@Original_sensor_3_unit";
sqLiteParameter115.SourceColumn = "sensor_3_unit";
sqLiteParameter115.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter116.ParameterName = "@IsNull_sensor_4_unit";
sqLiteParameter116.SourceColumn = "sensor_4_unit";
sqLiteParameter116.SourceColumnNullMapping = true;
sqLiteParameter116.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter117.ParameterName = "@Original_sensor_4_unit";
sqLiteParameter117.SourceColumn = "sensor_4_unit";
sqLiteParameter117.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter118.ParameterName = "@Original_sensor_1_range";
sqLiteParameter118.SourceColumn = "sensor_1_range";
sqLiteParameter118.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter119.ParameterName = "@Original_sensor_2_range";
sqLiteParameter119.SourceColumn = "sensor_2_range";
sqLiteParameter119.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter120.ParameterName = "@Original_sensor_3_range";
sqLiteParameter120.SourceColumn = "sensor_3_range";
sqLiteParameter120.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter121.ParameterName = "@Original_sensor_4_range";
sqLiteParameter121.SourceColumn = "sensor_4_range";
sqLiteParameter121.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter122.ParameterName = "@Original_sensor_1_id";
sqLiteParameter122.SourceColumn = "sensor_1_id";
sqLiteParameter122.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter123.ParameterName = "@Original_sensor_2_id";
sqLiteParameter123.SourceColumn = "sensor_2_id";
sqLiteParameter123.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter124.ParameterName = "@Original_sensor_3_id";
sqLiteParameter124.SourceColumn = "sensor_3_id";
sqLiteParameter124.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter125.ParameterName = "@Original_sensor_4_id";
sqLiteParameter125.SourceColumn = "sensor_4_id";
sqLiteParameter125.SourceVersion = System.Data.DataRowVersion.Original;
this.sqliteUpdateCommand1.Parameters.AddRange(new System.Data.SQLite.SQLiteParameter[] {
sqLiteParameter1,
sqLiteParameter2,
sqLiteParameter77,
sqLiteParameter78,
sqLiteParameter79,
sqLiteParameter80,
sqLiteParameter81,
sqLiteParameter82,
sqLiteParameter83,
sqLiteParameter84,
sqLiteParameter85,
sqLiteParameter86,
sqLiteParameter87,
sqLiteParameter88,
sqLiteParameter89,
sqLiteParameter90,
sqLiteParameter91,
sqLiteParameter92,
sqLiteParameter93,
sqLiteParameter94,
sqLiteParameter95,
sqLiteParameter96,
sqLiteParameter97,
sqLiteParameter98,
sqLiteParameter99,
sqLiteParameter100,
sqLiteParameter101,
sqLiteParameter102,
sqLiteParameter103,
sqLiteParameter104,
sqLiteParameter105,
sqLiteParameter106,
sqLiteParameter107,
sqLiteParameter108,
sqLiteParameter109,
sqLiteParameter110,
sqLiteParameter111,
sqLiteParameter112,
sqLiteParameter113,
sqLiteParameter114,
sqLiteParameter115,
sqLiteParameter116,
sqLiteParameter117,
sqLiteParameter118,
sqLiteParameter119,
sqLiteParameter120,
sqLiteParameter121,
sqLiteParameter122,
sqLiteParameter123,
sqLiteParameter124,
sqLiteParameter125});
//
// sqliteDeleteCommand1
//
this.sqliteDeleteCommand1.CommandText = resources.GetString("sqliteDeleteCommand1.CommandText");
this.sqliteDeleteCommand1.Connection = this.sqLiteConnection1;
sqLiteParameter3.ParameterName = "@Original_server_id";
sqLiteParameter3.SourceColumn = "server_id";
sqLiteParameter3.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter4.ParameterName = "@Original_name";
sqLiteParameter4.SourceColumn = "name";
sqLiteParameter4.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter5.ParameterName = "@Original_description";
sqLiteParameter5.SourceColumn = "description";
sqLiteParameter5.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter6.ParameterName = "@Original_location";
sqLiteParameter6.SourceColumn = "location";
sqLiteParameter6.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter7.ParameterName = "@IsNull_image";
sqLiteParameter7.SourceColumn = "image";
sqLiteParameter7.SourceColumnNullMapping = true;
sqLiteParameter7.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter8.ParameterName = "@Original_image";
sqLiteParameter8.SourceColumn = "image";
sqLiteParameter8.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter9.ParameterName = "@IsNull_sensor_1_name";
sqLiteParameter9.SourceColumn = "sensor_1_name";
sqLiteParameter9.SourceColumnNullMapping = true;
sqLiteParameter9.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter10.ParameterName = "@Original_sensor_1_name";
sqLiteParameter10.SourceColumn = "sensor_1_name";
sqLiteParameter10.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter11.ParameterName = "@IsNull_sensor_2_name";
sqLiteParameter11.SourceColumn = "sensor_2_name";
sqLiteParameter11.SourceColumnNullMapping = true;
sqLiteParameter11.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter12.ParameterName = "@Original_sensor_2_name";
sqLiteParameter12.SourceColumn = "sensor_2_name";
sqLiteParameter12.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter13.ParameterName = "@IsNull_sensor_3_name";
sqLiteParameter13.SourceColumn = "sensor_3_name";
sqLiteParameter13.SourceColumnNullMapping = true;
sqLiteParameter13.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter14.ParameterName = "@Original_sensor_3_name";
sqLiteParameter14.SourceColumn = "sensor_3_name";
sqLiteParameter14.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter15.ParameterName = "@IsNull_sensor_4_name";
sqLiteParameter15.SourceColumn = "sensor_4_name";
sqLiteParameter15.SourceColumnNullMapping = true;
sqLiteParameter15.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter16.ParameterName = "@Original_sensor_4_name";
sqLiteParameter16.SourceColumn = "sensor_4_name";
sqLiteParameter16.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter17.ParameterName = "@IsNull_sensor_1_unit";
sqLiteParameter17.SourceColumn = "sensor_1_unit";
sqLiteParameter17.SourceColumnNullMapping = true;
sqLiteParameter17.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter18.ParameterName = "@Original_sensor_1_unit";
sqLiteParameter18.SourceColumn = "sensor_1_unit";
sqLiteParameter18.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter19.ParameterName = "@IsNull_sensor_2_unit";
sqLiteParameter19.SourceColumn = "sensor_2_unit";
sqLiteParameter19.SourceColumnNullMapping = true;
sqLiteParameter19.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter20.ParameterName = "@Original_sensor_2_unit";
sqLiteParameter20.SourceColumn = "sensor_2_unit";
sqLiteParameter20.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter21.ParameterName = "@IsNull_sensor_3_unit";
sqLiteParameter21.SourceColumn = "sensor_3_unit";
sqLiteParameter21.SourceColumnNullMapping = true;
sqLiteParameter21.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter22.ParameterName = "@Original_sensor_3_unit";
sqLiteParameter22.SourceColumn = "sensor_3_unit";
sqLiteParameter22.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter23.ParameterName = "@IsNull_sensor_4_unit";
sqLiteParameter23.SourceColumn = "sensor_4_unit";
sqLiteParameter23.SourceColumnNullMapping = true;
sqLiteParameter23.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter126.ParameterName = "@Original_sensor_4_unit";
sqLiteParameter126.SourceColumn = "sensor_4_unit";
sqLiteParameter126.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter127.ParameterName = "@Original_sensor_1_range";
sqLiteParameter127.SourceColumn = "sensor_1_range";
sqLiteParameter127.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter128.ParameterName = "@Original_sensor_2_range";
sqLiteParameter128.SourceColumn = "sensor_2_range";
sqLiteParameter128.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter129.ParameterName = "@Original_sensor_3_range";
sqLiteParameter129.SourceColumn = "sensor_3_range";
sqLiteParameter129.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter130.ParameterName = "@Original_sensor_4_range";
sqLiteParameter130.SourceColumn = "sensor_4_range";
sqLiteParameter130.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter131.ParameterName = "@Original_sensor_1_id";
sqLiteParameter131.SourceColumn = "sensor_1_id";
sqLiteParameter131.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter132.ParameterName = "@Original_sensor_2_id";
sqLiteParameter132.SourceColumn = "sensor_2_id";
sqLiteParameter132.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter133.ParameterName = "@Original_sensor_3_id";
sqLiteParameter133.SourceColumn = "sensor_3_id";
sqLiteParameter133.SourceVersion = System.Data.DataRowVersion.Original;
sqLiteParameter134.ParameterName = "@Original_sensor_4_id";
sqLiteParameter134.SourceColumn = "sensor_4_id";
sqLiteParameter134.SourceVersion = System.Data.DataRowVersion.Original;
this.sqliteDeleteCommand1.Parameters.AddRange(new System.Data.SQLite.SQLiteParameter[] {
sqLiteParameter3,
sqLiteParameter4,
sqLiteParameter5,
sqLiteParameter6,
sqLiteParameter7,
sqLiteParameter8,
sqLiteParameter9,
sqLiteParameter10,
sqLiteParameter11,
sqLiteParameter12,
sqLiteParameter13,
sqLiteParameter14,
sqLiteParameter15,
sqLiteParameter16,
sqLiteParameter17,
sqLiteParameter18,
sqLiteParameter19,
sqLiteParameter20,
sqLiteParameter21,
sqLiteParameter22,
sqLiteParameter23,
sqLiteParameter126,
sqLiteParameter127,
sqLiteParameter128,
sqLiteParameter129,
sqLiteParameter130,
sqLiteParameter131,
sqLiteParameter132,
sqLiteParameter133,
sqLiteParameter134});
//
// serverDataAdapter
//
this.serverDataAdapter.DeleteCommand = this.sqliteDeleteCommand1;
this.serverDataAdapter.InsertCommand = this.sqliteInsertCommand1;
this.serverDataAdapter.SelectCommand = this.sqliteSelectCommand2;
this.serverDataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "servers", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("server_id", "server_id"),
new System.Data.Common.DataColumnMapping("name", "name"),
new System.Data.Common.DataColumnMapping("description", "description"),
new System.Data.Common.DataColumnMapping("location", "location"),
new System.Data.Common.DataColumnMapping("image", "image"),
new System.Data.Common.DataColumnMapping("sensor_1_name", "sensor_1_name"),
new System.Data.Common.DataColumnMapping("sensor_2_name", "sensor_2_name"),
new System.Data.Common.DataColumnMapping("sensor_3_name", "sensor_3_name"),
new System.Data.Common.DataColumnMapping("sensor_4_name", "sensor_4_name"),
new System.Data.Common.DataColumnMapping("sensor_1_unit", "sensor_1_unit"),
new System.Data.Common.DataColumnMapping("sensor_2_unit", "sensor_2_unit"),
new System.Data.Common.DataColumnMapping("sensor_3_unit", "sensor_3_unit"),
new System.Data.Common.DataColumnMapping("sensor_4_unit", "sensor_4_unit"),
new System.Data.Common.DataColumnMapping("sensor_1_range", "sensor_1_range"),
new System.Data.Common.DataColumnMapping("sensor_2_range", "sensor_2_range"),
new System.Data.Common.DataColumnMapping("sensor_3_range", "sensor_3_range"),
new System.Data.Common.DataColumnMapping("sensor_4_range", "sensor_4_range"),
new System.Data.Common.DataColumnMapping("sensor_1_id", "sensor_1_id"),
new System.Data.Common.DataColumnMapping("sensor_2_id", "sensor_2_id"),
new System.Data.Common.DataColumnMapping("sensor_3_id", "sensor_3_id"),
new System.Data.Common.DataColumnMapping("sensor_4_id", "sensor_4_id")})});
this.serverDataAdapter.UpdateCommand = this.sqliteUpdateCommand1;
//
// serverDataSet
//
this.serverDataSet.DataSetName = "serverDataSet";
this.serverDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// serversBindingSource
//
this.serversBindingSource.DataMember = "servers";
this.serversBindingSource.DataSource = this.serverDataSet;
//
// dataGridViewTextBoxColumn21
//
this.dataGridViewTextBoxColumn21.DataPropertyName = "server_id";
this.dataGridViewTextBoxColumn21.HeaderText = "server_id";
this.dataGridViewTextBoxColumn21.Name = "dataGridViewTextBoxColumn21";
this.dataGridViewTextBoxColumn21.ReadOnly = true;
//
// dataGridViewTextBoxColumn22
//
this.dataGridViewTextBoxColumn22.DataPropertyName = "name";
this.dataGridViewTextBoxColumn22.HeaderText = "name";
this.dataGridViewTextBoxColumn22.Name = "dataGridViewTextBoxColumn22";
this.dataGridViewTextBoxColumn22.ReadOnly = true;
//
// dataGridViewTextBoxColumn23
//
this.dataGridViewTextBoxColumn23.DataPropertyName = "sensor_1_unit";
this.dataGridViewTextBoxColumn23.HeaderText = "sensor_1_unit";
this.dataGridViewTextBoxColumn23.Name = "dataGridViewTextBoxColumn23";
this.dataGridViewTextBoxColumn23.ReadOnly = true;
//
// dataGridViewTextBoxColumn24
//
this.dataGridViewTextBoxColumn24.DataPropertyName = "sensor_3_unit";
this.dataGridViewTextBoxColumn24.HeaderText = "sensor_3_unit";
this.dataGridViewTextBoxColumn24.Name = "dataGridViewTextBoxColumn24";
this.dataGridViewTextBoxColumn24.ReadOnly = true;
//
// dataGridViewTextBoxColumn25
//
this.dataGridViewTextBoxColumn25.DataPropertyName = "sensor_4_unit";
this.dataGridViewTextBoxColumn25.HeaderText = "sensor_4_unit";
this.dataGridViewTextBoxColumn25.Name = "dataGridViewTextBoxColumn25";
this.dataGridViewTextBoxColumn25.ReadOnly = true;
//
// dataGridViewTextBoxColumn26
//
this.dataGridViewTextBoxColumn26.DataPropertyName = "sensor_1_range";
this.dataGridViewTextBoxColumn26.HeaderText = "sensor_1_range";
this.dataGridViewTextBoxColumn26.Name = "dataGridViewTextBoxColumn26";
this.dataGridViewTextBoxColumn26.ReadOnly = true;
//
// dataGridViewTextBoxColumn27
//
this.dataGridViewTextBoxColumn27.DataPropertyName = "sensor_2_range";
this.dataGridViewTextBoxColumn27.HeaderText = "sensor_2_range";
this.dataGridViewTextBoxColumn27.Name = "dataGridViewTextBoxColumn27";
this.dataGridViewTextBoxColumn27.ReadOnly = true;
//
// dataGridViewTextBoxColumn28
//
this.dataGridViewTextBoxColumn28.DataPropertyName = "sensor_3_range";
this.dataGridViewTextBoxColumn28.HeaderText = "sensor_3_range";
this.dataGridViewTextBoxColumn28.Name = "dataGridViewTextBoxColumn28";
this.dataGridViewTextBoxColumn28.ReadOnly = true;
//
// dataGridViewTextBoxColumn29
//
this.dataGridViewTextBoxColumn29.DataPropertyName = "sensor_4_range";
this.dataGridViewTextBoxColumn29.HeaderText = "sensor_4_range";
this.dataGridViewTextBoxColumn29.Name = "dataGridViewTextBoxColumn29";
this.dataGridViewTextBoxColumn29.ReadOnly = true;
//
// dataGridViewTextBoxColumn30
//
this.dataGridViewTextBoxColumn30.DataPropertyName = "sensor_1_id";
this.dataGridViewTextBoxColumn30.HeaderText = "sensor_1_id";
this.dataGridViewTextBoxColumn30.Name = "dataGridViewTextBoxColumn30";
this.dataGridViewTextBoxColumn30.ReadOnly = true;
//
// dataGridViewTextBoxColumn31
//
this.dataGridViewTextBoxColumn31.DataPropertyName = "sensor_2_id";
this.dataGridViewTextBoxColumn31.HeaderText = "sensor_2_id";
this.dataGridViewTextBoxColumn31.Name = "dataGridViewTextBoxColumn31";
this.dataGridViewTextBoxColumn31.ReadOnly = true;
//
// dataGridViewTextBoxColumn32
//
this.dataGridViewTextBoxColumn32.DataPropertyName = "sensor_3_id";
this.dataGridViewTextBoxColumn32.HeaderText = "sensor_3_id";
this.dataGridViewTextBoxColumn32.Name = "dataGridViewTextBoxColumn32";
this.dataGridViewTextBoxColumn32.ReadOnly = true;
//
// dataGridViewTextBoxColumn33
//
this.dataGridViewTextBoxColumn33.DataPropertyName = "sensor_4_id";
this.dataGridViewTextBoxColumn33.HeaderText = "sensor_4_id";
this.dataGridViewTextBoxColumn33.Name = "dataGridViewTextBoxColumn33";
this.dataGridViewTextBoxColumn33.ReadOnly = true;
//
// dataGridViewTextBoxColumn34
//
this.dataGridViewTextBoxColumn34.DataPropertyName = "sensor_2_unit";
this.dataGridViewTextBoxColumn34.HeaderText = "sensor_2_unit";
this.dataGridViewTextBoxColumn34.Name = "dataGridViewTextBoxColumn34";
this.dataGridViewTextBoxColumn34.ReadOnly = true;
//
// dataGridViewTextBoxColumn35
//
this.dataGridViewTextBoxColumn35.DataPropertyName = "description";
this.dataGridViewTextBoxColumn35.HeaderText = "description";
this.dataGridViewTextBoxColumn35.Name = "dataGridViewTextBoxColumn35";
this.dataGridViewTextBoxColumn35.ReadOnly = true;
//
// dataGridViewTextBoxColumn36
//
this.dataGridViewTextBoxColumn36.DataPropertyName = "location";
this.dataGridViewTextBoxColumn36.HeaderText = "location";
this.dataGridViewTextBoxColumn36.Name = "dataGridViewTextBoxColumn36";
this.dataGridViewTextBoxColumn36.ReadOnly = true;
//
// dataGridViewImageColumn2
//
this.dataGridViewImageColumn2.DataPropertyName = "image";
this.dataGridViewImageColumn2.HeaderText = "image";
this.dataGridViewImageColumn2.Name = "dataGridViewImageColumn2";
this.dataGridViewImageColumn2.ReadOnly = true;
//
// dataGridViewTextBoxColumn37
//
this.dataGridViewTextBoxColumn37.DataPropertyName = "sensor_1_name";
this.dataGridViewTextBoxColumn37.HeaderText = "sensor_1_name";
this.dataGridViewTextBoxColumn37.Name = "dataGridViewTextBoxColumn37";
this.dataGridViewTextBoxColumn37.ReadOnly = true;
//
// dataGridViewTextBoxColumn38
//
this.dataGridViewTextBoxColumn38.DataPropertyName = "sensor_2_name";
this.dataGridViewTextBoxColumn38.HeaderText = "sensor_2_name";
this.dataGridViewTextBoxColumn38.Name = "dataGridViewTextBoxColumn38";
this.dataGridViewTextBoxColumn38.ReadOnly = true;
//
// dataGridViewTextBoxColumn39
//
this.dataGridViewTextBoxColumn39.DataPropertyName = "sensor_3_name";
this.dataGridViewTextBoxColumn39.HeaderText = "sensor_3_name";
this.dataGridViewTextBoxColumn39.Name = "dataGridViewTextBoxColumn39";
this.dataGridViewTextBoxColumn39.ReadOnly = true;
//
// dataGridViewTextBoxColumn40
//
this.dataGridViewTextBoxColumn40.DataPropertyName = "sensor_4_name";
this.dataGridViewTextBoxColumn40.HeaderText = "sensor_4_name";
this.dataGridViewTextBoxColumn40.Name = "dataGridViewTextBoxColumn40";
this.dataGridViewTextBoxColumn40.ReadOnly = true;
//
// logDataSet
//
this.logDataSet.DataSetName = "logDataSet";
this.logDataSet.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema;
//
// logBindingSource
//
this.logBindingSource.DataMember = "log";
this.logBindingSource.DataSource = this.logDataSet;
//
// timeDataGridViewTextBoxColumn
//
this.timeDataGridViewTextBoxColumn.DataPropertyName = "time";
this.timeDataGridViewTextBoxColumn.HeaderText = "time";
this.timeDataGridViewTextBoxColumn.Name = "timeDataGridViewTextBoxColumn";
this.timeDataGridViewTextBoxColumn.ReadOnly = true;
//
// messageDataGridViewTextBoxColumn
//
this.messageDataGridViewTextBoxColumn.DataPropertyName = "message";
this.messageDataGridViewTextBoxColumn.HeaderText = "message";
this.messageDataGridViewTextBoxColumn.Name = "messageDataGridViewTextBoxColumn";
this.messageDataGridViewTextBoxColumn.ReadOnly = true;
//
// LogBrowserForm
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.ClientSize = new System.Drawing.Size(610, 425);
this.Controls.Add(this.tabControl1);
this.Name = "LogBrowserForm";
this.Text = "Log Browser";
((System.ComponentModel.ISupportInitialize)(this.logDataGridView)).EndInit();
this.tabControl1.ResumeLayout(false);
this.tabPage1.ResumeLayout(false);
this.tabPage2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.serverDataSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.serversBindingSource)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.logDataSet)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.logBindingSource)).EndInit();
this.ResumeLayout(false);
}
private void btnCreate_Click(object sender, EventArgs e)
{
if (hapDataView1.SelectedItem == null)
return;
string output = GenerateSQLCommand(tblPanelService);
using (var cmd = new System.Data.SQLite.SQLiteCommand(DataBase.Instance.sqlConnection))
{
cmd.CommandText = "insert into DebitNotes(OwnerId,Category,Date,Services,Advances,Tax,Total) values(@OwnerId,@Category,DateTime('now','localtime'),@Services,@Advances,@Tax,@Total); Select last_insert_rowid()";
System.Data.SQLite.SQLiteParameter[] parameters = new System.Data.SQLite.SQLiteParameter[6];
parameters[0] = new System.Data.SQLite.SQLiteParameter("OwnerId", ((Company)hapDataView1.SelectedItem).Id);
parameters[1] = new System.Data.SQLite.SQLiteParameter("Category", cmb_Category.Text);
parameters[2] = new System.Data.SQLite.SQLiteParameter("Services", GenerateSQLCommand(tblPanelService));
parameters[3] = new System.Data.SQLite.SQLiteParameter("Advances", GenerateSQLCommand(tblPanelAdvance));
parameters[4] = new System.Data.SQLite.SQLiteParameter("Tax", tax);
parameters[5] = new System.Data.SQLite.SQLiteParameter("Total", total);
cmd.Parameters.AddRange(parameters);
long insertedId = (long)cmd.ExecuteScalar();
}
Form_Main.Instance.ReloadDebitNotes();
}
// another microfuckup
public IDbDataParameter BlobParameter(int no, byte[] value, bool isNull)
{
if (VendorType.Lite3 == connect.typeOfVendor)
{
string p = ParameterShape(no);
System.Data.SQLite.SQLiteParameter parameter = new System.Data.SQLite.SQLiteParameter(p, DbType.Binary, value.Length);
if (isNull)
parameter.Value = DBNull.Value;
else
parameter.Value = value;
command.Parameters.Add(parameter);
return parameter;
//return null;
}
else
{
string p = ParameterShape(no);
System.Data.SqlClient.SqlParameter parameter = new System.Data.SqlClient.SqlParameter(p, SqlDbType.Image);
if (isNull)
parameter.Value = DBNull.Value;
else
parameter.Value = value;
command.Parameters.Add(parameter);
return parameter;
}
}
public int MaxQuestionOrder(Category category)
{
int result = 0;
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
command.CommandText = @"SELECT MAX([order]) from questions WHERE categoryid=@categoryid";
SqliteParameter parameter = new SqliteParameter("@categoryid", DbType.Int32);
parameter.Value = category.Id;
command.Parameters.Add(parameter);
object val = command.ExecuteScalar();
if (val != DBNull.Value)
result = Convert.ToInt32(val);
}
}
}
catch (SqliteException ex)
{
Logger.Fatal("Unable to perform MaxQuestionOrder: \n{0}", ex);
}
return result;
}
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);
}
public void DeleteQuestion(int id)
{
try
{
using (SqliteConnection connection = new SqliteConnection(Settings.DatabaseConnection))
{
connection.Open();
using (SqliteCommand command = new SqliteCommand(connection))
{
command.CommandText = "DELETE FROM questions WHERE id=@id";
SqliteParameter parameter = new SqliteParameter("@id", DbType.Int32);
parameter.Value = id;
command.Parameters.Add(parameter);
command.ExecuteNonQuery();
}
}
}
catch (SqliteException e)
{
Logger.Warn("SqliteException occurred with DeleteQuestion({0}): \n{1}", id, e);
}
}
