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

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

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

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

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

            // Return collection.
            return objects.ToArray();
        }
Esempio n. 4
0
 public static ModemSettings[] SearchExact(ModemSettings searchObject)
 {
     return SearchExact ( searchObject.Id, searchObject.Comport, searchObject.Rate, searchObject.Timeout, searchObject.Status, searchObject.ORDERBY_FIELD);
 }
Esempio n. 5
0
        public static ModemSettings Get(System.Int32 id)
        {
            DataSet ds;
            Database db;
            string sqlCommand;
            DbCommand dbCommand;
            ModemSettings instance;

            instance = new ModemSettings();

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

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