public MyParameter AddWhereParameter(SQLiteParameter param) { MyParameter my_param = new MyParameter(param.ParameterName, param); _whereParameters.Add(my_param); return(my_param); }
public void GetSimilarStorageItems(string pInputString) { string[] inputWords = this.GetSuitableDescriptionWords(pInputString); this.Query.ResetWhereParameters(); //StorageItem storageItem = new StorageItem(); foreach (string toSearchWordLoop in inputWords) { if (this.Query.ParameterCount > 0) { this.Query.AddConjunction(MyConj.And); } this.Query.OpenParenthesis(); string toSearchWord = "%" + toSearchWordLoop + "%"; MyParameter descParameter1 = this.Query.AddWhereParameter(StorageItemDT.Parameters.Description); descParameter1.Operator = MyOperand.Like; descParameter1.Value = toSearchWord.ToLower(); //descParameter1.Conjuction = WhereParameter.Conj.Or; MyParameter descParameter2 = this.Query.AddWhereParameter(StorageItemDT.Parameters.Description); descParameter2.Operator = MyOperand.Like; descParameter2.Value = toSearchWord.ToUpper(); descParameter2.Conjuction = MyConj.Or; this.Query.CloseParenthesis(); } this.Query.Load(); //return storageItem.AsList(); }
public MyParameter AddWhereParameter(String columnName, MyOperand op, SQLiteParameter param, object value) { MyParameter my_param = new MyParameter(columnName, param) { Operator = op, Value = value }; _whereParameters.Add(my_param); return(my_param); }
//public MyParameter AddWhereParameter(string columnName, IDataParameter param) //{ // MyParameter my_param = new MyParameter(columnName, param); // _whereParameters.Add(my_param); // return my_param; //} public MyParameter AddWhereParameter(SQLiteParameter param, object value) { MyParameter my_param = new MyParameter(param.ParameterName, param) { Value = value }; _whereParameters.Add(my_param); return(my_param); }
public void AddWhereParameter(MyParameter wItem) { _whereParameters.Add(wItem); }