/// <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); } }