private static string GetQuery(ConstDbCommands.DbCommandList queryName) { switch (queryName) { case ConstDbCommands.DbCommandList.GET_USER_BY_EMAIL: return(ConstDbCommands.GET_QUERY_CONTENT); default: break; } return(""); }
public static bool RunDbQuery <T>(ref List <T> entityObj, ConstDbCommands.DbCommandList queryName, string[] parameterNames, object[] parameterValues) { string queryText = ""; if (RunQueryForQueryContent(queryName.ToString(), ref queryText)) { queryText = CheckParametersInQuery(queryText, parameterNames); PrepareAndExecuteQuery(ref entityObj, queryText, parameterNames, parameterValues); return(true); } else { return(false); } }