/// <summary> /// Executes DB SELECT statement (mostly based on where clause) and returns only one row as object of supplied class. /// </summary> /// <returns> /// Object of generic class result. /// </returns> public static T GetSpecific(T obj, string strProcName) { T result; try { List <T> list = new List <T>(); SqlParameter[] parameter = Util.GetParameter(obj); object obj2 = sdh.ExecuteDataSet(Util.CS(), strProcName, CommandType.StoredProcedure, parameter); list = ListProvider <T> .FindAll((DataSet)obj2); result = ((list.Count > 0) ? list[0] : new T()); } catch (Exception ex) { throw ex; } return(result); }
/// <summary> /// Executes DB SELECT statement (Capabilities to return all or paginated format based on stored procedure design) /// and returns query result in generic list format of supplied class. /// </summary> // /// <returns> /// List of generic class result. /// </returns> public static List <T> GetAllOrByRange(T obj, string strProcName) { List <T> result; try { List <T> list = new List <T>(); SqlParameter[] parameter = Util.GetParameter(obj); object obj2 = sdh.ExecuteDataSet(Util.CS(), strProcName, CommandType.StoredProcedure, parameter); list = ListProvider <T> .FindAll((DataSet)obj2); result = list; } catch (Exception ex) { throw ex; //return new List<T>(); } return(result); }