Esempio n. 1
0
 public static void Update(KeywordParams keywordParams, DbTransaction transaction)
 {
     keywordParams.Update(transaction);
 }
Esempio n. 2
0
 public static void Update(KeywordParams keywordParams)
 {
     keywordParams.Update();
 }
Esempio n. 3
0
        public static KeywordParams[] MapFrom(DataSet ds)
        {
            List<KeywordParams> objects;

            // Initialise Collection.
            objects = new List<KeywordParams>();

            // Validation.
            if (ds == null)
                throw new ApplicationException("Cannot map to dataset null.");
            else if (ds.Tables[TABLE_NAME].Rows.Count == 0)
                return objects.ToArray();

            if (ds.Tables[TABLE_NAME] == null)
                throw new ApplicationException("Cannot find table [dbo].[keyword_params] in DataSet.");

            if (ds.Tables[TABLE_NAME].Rows.Count < 1)
                throw new ApplicationException("Table [dbo].[keyword_params] is empty.");

            // Map DataSet to Instance.
            foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
            {
                KeywordParams instance = new KeywordParams();
                instance.MapFrom(dr);
                objects.Add(instance);
            }

            // Return collection.
            return objects.ToArray();
        }
Esempio n. 4
0
 public static KeywordParams[] SearchExact(KeywordParams searchObject)
 {
     return SearchExact ( searchObject.Keyword, searchObject.Name, searchObject.Datatype, searchObject.MappedField, searchObject.Position, searchObject.ErrorMessage, searchObject.ValidateType, searchObject.ValidationData, searchObject.ValidateType2, searchObject.ValidationData2, searchObject.Id, searchObject.KeywordId, searchObject.ORDERBY_FIELD);
 }
Esempio n. 5
0
        public static KeywordParams Get(System.Int32 id)
        {
            DataSet ds;
            Database db;
            string sqlCommand;
            DbCommand dbCommand;
            KeywordParams instance;

            instance = new KeywordParams();

            db = MyDatabase.DB;
            sqlCommand = "[dbo].KeywordParams_SELECT";
            dbCommand = db.GetStoredProcCommand(sqlCommand, id);

            // Get results.
            ds = db.ExecuteDataSet(dbCommand);
            // Verification.
            if (ds == null || ds.Tables[0].Rows.Count == 0) throw new ApplicationException("Could not get KeywordParams ID:" + id.ToString()+ " from Database.");
            // Return results.
            ds.Tables[0].TableName = TABLE_NAME;

            instance.MapFrom( ds.Tables[0].Rows[0] );
            return instance;
        }