Esempio n. 1
0
File: Help.cs Progetto: Arshir/PCC
 public static void Update(Help help, DbTransaction transaction)
 {
     help.Update(transaction);
 }
Esempio n. 2
0
File: Help.cs Progetto: Arshir/PCC
 public static void Update(Help help)
 {
     help.Update();
 }
Esempio n. 3
0
File: Help.cs Progetto: Arshir/PCC
        public static Help[] MapFrom(DataSet ds)
        {
            List<Help> objects;

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

            // 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].[help] in DataSet.");

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

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

            // Return collection.
            return objects.ToArray();
        }
Esempio n. 4
0
File: Help.cs Progetto: Arshir/PCC
 public static Help[] SearchExact(Help searchObject)
 {
     return SearchExact ( searchObject.Id, searchObject.Keyword, searchObject.Message, searchObject.ORDERBY_FIELD);
 }
Esempio n. 5
0
File: Help.cs Progetto: Arshir/PCC
        public static Help Get(System.Int32 id)
        {
            DataSet ds;
            Database db;
            string sqlCommand;
            DbCommand dbCommand;
            Help instance;

            instance = new Help();

            db = MyDatabase.DB;
            sqlCommand = "[dbo].Help_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 Help ID:" + id.ToString()+ " from Database.");
            // Return results.
            ds.Tables[0].TableName = TABLE_NAME;

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