//method implemented for readability //similar to user.Query() //query db for rows matching object using a stored proc public static T[] QueryWithStoredProc(string storedProc, params object[] storedProcParameters) { List <T> all = new List <T>(); DataTable dt = DbEntityDbHandler.ExecuteStoredProc(storedProc, storedProcParameters); foreach (DataRow dr in dt.Rows) { T obj = new T(); CopyDataRowValuesToObjectProperties(dr, obj); all.Add(obj); } return(all.ToArray()); }
//query for results from DB //auto populate the stored proc parameters based on the obj properties public virtual T[] QueryWithStoredProcAutoParams(string storedProc) { List <T> all = new List <T>(); object[] storedProcParameters = GetStoredProcParameters(storedProc); DataTable dt = DbEntityDbHandler.ExecuteStoredProc(storedProc, storedProcParameters); foreach (DataRow dr in dt.Rows) { T obj = new T(); CopyDataRowValuesToObjectProperties(dr, obj); all.Add(obj); } this.StatusCode = DbGlobals.SUCCESS_STATUS_CODE; this.StatusDesc = DbGlobals.SUCCESS_STATUS_TEXT; return(all.ToArray()); }