public static ResultArgs FetchData <T>(OracleParameter[] param, string sSQL, EnumCommand.DataSource dataSourceType, string sAcademicYear = "") where T : new() { ResultArgs resultArgs = new ResultArgs(); DataValue dv = new DataValue(); dv.Clear(); try { if (string.IsNullOrEmpty(sSQL)) { resultArgs.Success = false; resultArgs.Message = Common.Message.QueryIsEmpty; return(resultArgs); } if (sAcademicYear != string.Empty) { sSQL = sSQL.Replace(Common.Delimiter.QUS + "", sAcademicYear); } //if (param != null) //{ // DataValue Construction // foreach (var prop in obj.GetType().GetProperties()) // { // objValue = prop.GetValue(obj, null); // objValue = (objValue == null) ? string.Empty : objValue.ToString(); // dv.Add(prop.Name, objValue.ToString(), EnumCommand.DataType.String); // } //} if (dataSourceType == EnumCommand.DataSource.list) { using (OracleHelper objHelper = new OracleHelper()) { resultArgs = objHelper.FecthDataAsList <T>(sSQL, param, EnumCommand.SQLType.StoredProcedure); } } else { using (OracleHelper objHelper = new OracleHelper()) { resultArgs = objHelper.FetchData(sSQL, dataSourceType, param, EnumCommand.SQLType.StoredProcedure); } } } catch (System.Exception ex) { using (ErrorLog objlog = new ErrorLog()) { objlog.WriteError("OracleHelper", "FetchData", sSQL, ex.Message); } resultArgs.Success = false; } return(resultArgs); }