//--------------------------------------------------------------------- #endregion #region --------------ConvertToParameters-------------- //--------------------------------------------------------------------- //ConvertToParameters //--------------------------------------------------------------------- /// <summary> /// convert specific properties to a collection of sql parameters as CustomDbParameterList /// </summary> /// <typeparam name="T"></typeparam> /// <param name="instance"></param> /// <param name="expressions"></param> /// <returns></returns> //--------------------------------------------------------------------- internal static CustomDbParameterList ConvertToParameters <T>(this T instance, params Expression <Func <T, object> >[] expressions) { CustomDbParameterList parameterlist = new CustomDbParameterList(); List <PropertyInfo> propList = ExpressionHelper.GetProperiesFromExpression(expressions); foreach (PropertyInfo prop in propList) { parameterlist.Add(prop, prop.GetValue(instance)); } return(parameterlist); }
//--------------------------------------------------------------------- //ConvertToParameters //--------------------------------------------------------------------- /// <summary> /// convert any object properties to a collection of sql parameters as CustomDbParameterList /// </summary> /// <typeparam name="T"></typeparam> /// <param name="instance"></param> /// <returns></returns> //--------------------------------------------------------------------- internal static CustomDbParameterList ConvertToParameters <T>(this T instance) { string name = null; object value; CustomDbParameterList plist = new CustomDbParameterList(); Type t = instance.GetType(); PropertyInfo[] properties = t.GetProperties(); foreach (PropertyInfo prop in properties) { name = prop.Name; value = prop.GetValue(instance); plist.Add(name, value); } return(plist); }
//--------------------------------------------------------------------- #endregion #region --------------ConvertToParametersExcept-------------- //--------------------------------------------------------------------- //ConvertToParametersExcept //--------------------------------------------------------------------- /// <summary> /// convert any object properties to a collection of sql parameters as CustomDbParameterList except some properties /// </summary> /// <typeparam name="T"></typeparam> /// <param name="instance"></param> /// <param name="expressions"></param> /// <returns></returns> //--------------------------------------------------------------------- internal static CustomDbParameterList ConvertToParametersExcept <T>(this T instance, params Expression <Func <T, object> >[] expressions) { CustomDbParameterList parameterlist = new CustomDbParameterList(); List <PropertyInfo> execludedpropList = ExpressionHelper.GetProperiesFromExpression(expressions); List <string> execludedpropListNames = execludedpropList.Select(e => e.Name).ToList(); Type t = instance.GetType(); PropertyInfo[] propList = t.GetProperties(); foreach (var prop in propList) { if (expressions == null || !execludedpropListNames.Contains(prop.Name)) { parameterlist.Add(prop, prop.GetValue(instance)); } } return(parameterlist); }
public static List <T> RetrieveEntityList <T>(string procedureName, CustomDbParameterList customParameters) { return(RetrieveEntityList <T>(procedureName, customParameters.Parameters)); }
public static Dictionary <string, object> RetrieveMultiRecordSet(string procedureName, CustomDbParameterList customParameters, params Type[] types) { return(RetrieveMultiRecordSet(procedureName, customParameters.Parameters, types)); }
public static T RetrieveEntitySingleOrDefault <T>(string procedureName, CustomDbParameterList customParameters) { return(RetrieveEntitySingleOrDefault <T>(procedureName, customParameters.Parameters)); }
public static object ExecuteScalarStoredProcedure(string procedureName, CustomDbParameterList customParameters) { return(ExecuteScalarStoredProcedure(procedureName, customParameters.Parameters)); }