public IList <CoreBase> GetList() { System.Data.IDataReader idr = null; CoreBase clone; ParameterManager Params; try { Params = new ParameterManager(this._DMLCore); IDatabaseHelper helper = new DatabaseFactory().CreateDBHelper(base.DBType, StoredProcedureName); //idr = helper.ExecuteReader(Params.Parameters); using (idr = helper.ExecuteReader(Params.Parameters)) { while (idr.Read()) { Type coreType = _DMLCore.GetType(); //this line is written as alternative of the avobe lines[that are comented] clone = GetParamFromReader(coreType, idr); if (_DMLCoreList == null) { _DMLCoreList = new List <CoreBase>(); } _DMLCoreList.Add(clone); clone = null; //coreType.GetProperty("").SetValue(_DMLCore, "", null); } } } catch (Exception) { throw; } finally { if (idr != null) { idr.Close(); idr.Dispose(); } } return(_DMLCoreList); }
public CoreBase GetObjectByID() { System.Data.IDataReader idr = null; ParameterManager Params; try { Params = new ParameterManager(this._DMLCore); IDatabaseHelper helper = new DatabaseFactory().CreateDBHelper(base.DBType, StoredProcedureName); //idr = helper.ExecuteReader(Params.Parameters); using (idr = helper.ExecuteReader(Params.Parameters)) { if (idr.Read()) { Type coreType = _DMLCore.GetType(); PropertyInfo[] properties = coreType.GetProperties(); foreach (PropertyInfo info in properties) { //info.Name exists in dataReader if (DataRecordExtensions.HasColumn(idr, info.Name) && !DataRecordExtensions.IsNull(idr, info.Name)) { coreType.GetProperty(info.Name).SetValue(_DMLCore, idr[info.Name], null); } } //coreType.GetProperty("").SetValue(_DMLCore, "", null); } } } catch (Exception) { throw; } finally { //if (idr != null) //{ // idr.Close(); // idr.Dispose(); //} } return(_DMLCore); }
private void executeDAB() { ParameterManager Params; try { if (this._DMLCore.HasEntity()) { Params = new ParameterManager(this._DMLCore); } else { Params = new ParameterManager(this._DMLCore.ParamSetList_P); } IDatabaseHelper helper = new DatabaseFactory().CreateDBHelper(base.DBType, StoredProcedureName); helper.Run(Params.Parameters); } catch (Exception) { throw; } }