Beispiel #1
0
 public static void Update(Groups groups, DbTransaction transaction)
 {
     groups.Update(transaction);
 }
Beispiel #2
0
 public static void Update(Groups groups)
 {
     groups.Update();
 }
Beispiel #3
0
        public static Groups[] MapFrom(DataSet ds)
        {
            List<Groups> objects;

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

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

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

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

            // Return collection.
            return objects.ToArray();
        }
Beispiel #4
0
 public static Groups[] SearchExact(Groups searchObject)
 {
     return SearchExact ( searchObject.No, searchObject.GroupName, searchObject.ParentGroupid, searchObject.ORDERBY_FIELD);
 }
Beispiel #5
0
        public static Groups Get(System.Int32 no)
        {
            DataSet ds;
            Database db;
            string sqlCommand;
            DbCommand dbCommand;
            Groups instance;

            instance = new Groups();

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

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

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