/// <summary> /// Made for debug purposes, to see what the webservices return ... /// </summary> /// <param name="sValueWeReturn"></param> /// <returns></returns> public string MAIN_STRING_RETURN(bool bSuperDeveloperTesting, string sValueWeReturn) { if (bSuperDeveloperTesting) { return(sValueWeReturn); } try { string sDetailedFunction = "Not found ..."; string sCallStack = Environment.StackTrace; if (sCallStack != null && sCallStack.Length > 0) { string[] callStackTable = sCallStack.Split("\r\n".ToCharArray()); if (callStackTable != null && callStackTable.Length > 6) { string sCall = callStackTable[6]; // This is the method we call +1 level higher up in the call stack ... int start = sCall.IndexOf("."); int end = sCall.IndexOf(")"); if (start > 0 && end > 0 && end > start) { sDetailedFunction = sCall.Substring(start + 1, end - start); } } } string sSqlReadyText = sValueWeReturn; sSqlReadyText = sSqlReadyText.Replace("'", """); xSQL_InsertBuilder sb = new xSQL_InsertBuilder((webservice_database)this, "webservice_log"); DateTime now = DateTime.Now; if (sDetailedFunction.Length > 99) { sDetailedFunction = sDetailedFunction.Substring(0, 98); } sb.add("name", sDetailedFunction); sb.add("timestamp", now.Year.ToString() + "." + zero_2(now.Month.ToString()) + "." + zero_2(now.Day.ToString()) + " " + zero_2(now.Hour.ToString()) + ":" + zero_2(now.Minute.ToString()) + ":" + zero_2(now.Second.ToString()) + " " + zero_3(now.Millisecond.ToString())); sb.add("parameters", "RETURNED: " + sSqlReadyText); bool bOK = sb.ExecuteSql(); } catch (Exception e) { return(sValueWeReturn); } return(sValueWeReturn); }
public bool save_page_view() { bool bOK = false; try { xSQL_InsertBuilder ib = new xSQL_InsertBuilder(this, "bank_phone_page_view"); ib.add("timestamp", DateTime.Now); bool bOk = ib.ExecuteSql(); } catch (Exception) { } finally { } return(bOK); }
public bool save_phone(string sPhone) { bool bOK = false; try { xSQL_InsertBuilder ib = new xSQL_InsertBuilder(this, "bank_phone"); ib.add("phone", sPhone); bool bOk = ib.ExecuteSql(); } catch (Exception) { } finally { } return(bOK); }
public bool save_phone(string sPhone) { bool bOK = false; try { xSQL_InsertBuilder ib = new xSQL_InsertBuilder(this, "bank_phone"); ib.add("phone", sPhone); bool bOk = ib.ExecuteSql(); } catch (Exception) { } finally { } return bOK; }
/// <summary> /// Made for debug purposes, to see what the webservices return ... /// </summary> /// <param name="sValueWeReturn"></param> /// <returns></returns> public string MAIN_STRING_RETURN(bool bSuperDeveloperTesting, string sValueWeReturn) { if (bSuperDeveloperTesting) return sValueWeReturn; try { string sDetailedFunction = "Not found ..."; string sCallStack = Environment.StackTrace; if (sCallStack != null && sCallStack.Length > 0) { string[] callStackTable = sCallStack.Split("\r\n".ToCharArray()); if (callStackTable != null && callStackTable.Length > 6) { string sCall = callStackTable[6]; // This is the method we call +1 level higher up in the call stack ... int start = sCall.IndexOf("."); int end = sCall.IndexOf(")"); if (start > 0 && end > 0 && end > start) { sDetailedFunction = sCall.Substring(start + 1, end - start); } } } string sSqlReadyText = sValueWeReturn; sSqlReadyText = sSqlReadyText.Replace("'", """); xSQL_InsertBuilder sb = new xSQL_InsertBuilder((webservice_database)this, "webservice_log"); DateTime now = DateTime.Now; if (sDetailedFunction.Length > 99) sDetailedFunction = sDetailedFunction.Substring(0, 98); sb.add("name", sDetailedFunction); sb.add("timestamp", now.Year.ToString() + "." + zero_2(now.Month.ToString()) + "." + zero_2(now.Day.ToString()) + " " + zero_2(now.Hour.ToString()) + ":" + zero_2(now.Minute.ToString()) + ":" + zero_2(now.Second.ToString()) + " " + zero_3(now.Millisecond.ToString())); sb.add("parameters", "RETURNED: " + sSqlReadyText); bool bOK = sb.ExecuteSql(); } catch (Exception e) { return sValueWeReturn; } return sValueWeReturn; }
public bool log_call(string sActualParameters) { try { if (!isBlank(sActualParameters)) { sActualParameters = sActualParameters.Replace("'", "_"); // sActualParameters = sActualParameters.Replace("\"", "_"); if (sActualParameters.Length > 5000) sActualParameters = sActualParameters.Substring(0, 4999); } else sActualParameters = ""; bool bOK = false; string sDetailedFunction = "Not found ..."; string sCallStack = Environment.StackTrace; if (sCallStack != null && sCallStack.Length > 0) { string[] callStackTable = sCallStack.Split("\r\n".ToCharArray()); if (callStackTable != null && callStackTable.Length > 6) { string sCall = callStackTable[6]; int start = sCall.IndexOf("."); int end = sCall.IndexOf(")"); if (start > 0 && end > 0 && end > start) { sDetailedFunction = sCall.Substring(start + 1, end - start); } } } if (isBlank(sActualParameters)) { sActualParameters = ""; } sActualParameters = sActualParameters.Replace("'", "_"); sActualParameters = sActualParameters.Replace("\"", "_"); // xSQL_InsertBuilder sb = new xSQL_InsertBuilder(iCommonPointer, "webservice_log"); xSQL_InsertBuilder sb = new xSQL_InsertBuilder((webservice_database)this, "webservice_log"); DateTime now = DateTime.Now; if (sDetailedFunction.Length > 99) sDetailedFunction = sDetailedFunction.Substring(0, 98); sb.add("name", sDetailedFunction); // sb.add("timestamp", DateTime.Now.ToLongDateString() + " - " + DateTime.Now.ToLongTimeString()); sb.add("timestamp", now.Year.ToString() + "." + zero_2(now.Month.ToString()) + "." + zero_2(now.Day.ToString()) + " " + zero_2(now.Hour.ToString()) + ":" + zero_2(now.Minute.ToString()) + ":" + zero_2(now.Second.ToString()) + " " + zero_3(now.Millisecond.ToString())); sb.add("parameters", sActualParameters); bOK = sb.ExecuteSql(); } catch (Exception) { return false; } return true; }
public bool log_user_action(string sConsumerGuid, string sSubAction, string sActualParameters) { try { if (sSubAction == null) sSubAction = ""; if (sSubAction.Length > 50) sSubAction = sSubAction.Substring(0, 49); string sCouponId = ""; if (!isBlank(sActualParameters)) { sActualParameters = sActualParameters.Replace("'", "_"); sActualParameters = sActualParameters.Replace("\"", "_"); string[] tab = sActualParameters.Split(";".ToCharArray()); if (tab != null && tab.Length > 0) { for (int i = 0; i < tab.Length; ++i) { string[] tab2 = tab[i].Split("=".ToCharArray()); if (tab2 != null && tab2.Length == 2) { if (tab2[0] == "coupon_id") { sCouponId = tab2[1]; } } } } } bool bOK = false; string sDetailedFunction = "Not found ..."; string sFunctionCall = "void"; string sCallStack = Environment.StackTrace; if (sCallStack != null && sCallStack.Length > 0) { string[] callStackTable = sCallStack.Split("\r\n".ToCharArray()); if (callStackTable != null && callStackTable.Length > 6) { string sCall = callStackTable[6]; int start = sCall.IndexOf("."); int end = sCall.IndexOf(")"); if (start > 0 && end > 0 && end > start) { sDetailedFunction = sCall.Substring(start + 1, end - start); int iStartPar = sDetailedFunction.IndexOf("("); if (iStartPar > 0) { sFunctionCall = sDetailedFunction.Substring(0, iStartPar); } } } } if (isBlank(sActualParameters)) { sActualParameters = ""; } else if (sActualParameters.Length > 199) { sActualParameters = sActualParameters.Substring(0, 199); } sActualParameters = sActualParameters.Replace("'", "_"); sActualParameters = sActualParameters.Replace("\"", "_"); xSQL_InsertBuilder sb = new xSQL_InsertBuilder((webservice_database)this, "user_action"); if (sConsumerGuid.Length > 50) sConsumerGuid = sConsumerGuid.Substring(0, 49); if (sActualParameters.Length > 99) sActualParameters = sActualParameters.Substring(0, 98); if (sFunctionCall.Length > 50) sFunctionCall = sFunctionCall.Substring(0, 49); sb.add("consumer_guid", sConsumerGuid); if (sCouponId != "") sb.add("coupon_id", sCouponId); sb.add("action", sFunctionCall); sb.add("sub_action", sSubAction); sb.add("parameters", sActualParameters); sb.add("timestamp", DateTime.Now.Subtract(new TimeSpan(1, 0, 0))); // 19 nov fix we get 1 hour wrong on Azure !!! bOK = sb.ExecuteSql(); } catch (Exception e) { log_call("PROBLEM"); return false; } return true; }
public bool log_call(string sActualParameters) { try { if (!isBlank(sActualParameters)) { sActualParameters = sActualParameters.Replace("'", "_"); // sActualParameters = sActualParameters.Replace("\"", "_"); if (sActualParameters.Length > 5000) { sActualParameters = sActualParameters.Substring(0, 4999); } } else { sActualParameters = ""; } bool bOK = false; string sDetailedFunction = "Not found ..."; string sCallStack = Environment.StackTrace; if (sCallStack != null && sCallStack.Length > 0) { string[] callStackTable = sCallStack.Split("\r\n".ToCharArray()); if (callStackTable != null && callStackTable.Length > 6) { string sCall = callStackTable[6]; int start = sCall.IndexOf("."); int end = sCall.IndexOf(")"); if (start > 0 && end > 0 && end > start) { sDetailedFunction = sCall.Substring(start + 1, end - start); } } } if (isBlank(sActualParameters)) { sActualParameters = ""; } sActualParameters = sActualParameters.Replace("'", "_"); sActualParameters = sActualParameters.Replace("\"", "_"); // xSQL_InsertBuilder sb = new xSQL_InsertBuilder(iCommonPointer, "webservice_log"); xSQL_InsertBuilder sb = new xSQL_InsertBuilder((webservice_database)this, "webservice_log"); DateTime now = DateTime.Now; if (sDetailedFunction.Length > 99) { sDetailedFunction = sDetailedFunction.Substring(0, 98); } sb.add("name", sDetailedFunction); // sb.add("timestamp", DateTime.Now.ToLongDateString() + " - " + DateTime.Now.ToLongTimeString()); sb.add("timestamp", now.Year.ToString() + "." + zero_2(now.Month.ToString()) + "." + zero_2(now.Day.ToString()) + " " + zero_2(now.Hour.ToString()) + ":" + zero_2(now.Minute.ToString()) + ":" + zero_2(now.Second.ToString()) + " " + zero_3(now.Millisecond.ToString())); sb.add("parameters", sActualParameters); bOK = sb.ExecuteSql(); } catch (Exception) { return(false); } return(true); }
public bool log_user_action(string sConsumerGuid, string sSubAction, string sActualParameters) { try { if (sSubAction == null) { sSubAction = ""; } if (sSubAction.Length > 50) { sSubAction = sSubAction.Substring(0, 49); } string sCouponId = ""; if (!isBlank(sActualParameters)) { sActualParameters = sActualParameters.Replace("'", "_"); sActualParameters = sActualParameters.Replace("\"", "_"); string[] tab = sActualParameters.Split(";".ToCharArray()); if (tab != null && tab.Length > 0) { for (int i = 0; i < tab.Length; ++i) { string[] tab2 = tab[i].Split("=".ToCharArray()); if (tab2 != null && tab2.Length == 2) { if (tab2[0] == "coupon_id") { sCouponId = tab2[1]; } } } } } bool bOK = false; string sDetailedFunction = "Not found ..."; string sFunctionCall = "void"; string sCallStack = Environment.StackTrace; if (sCallStack != null && sCallStack.Length > 0) { string[] callStackTable = sCallStack.Split("\r\n".ToCharArray()); if (callStackTable != null && callStackTable.Length > 6) { string sCall = callStackTable[6]; int start = sCall.IndexOf("."); int end = sCall.IndexOf(")"); if (start > 0 && end > 0 && end > start) { sDetailedFunction = sCall.Substring(start + 1, end - start); int iStartPar = sDetailedFunction.IndexOf("("); if (iStartPar > 0) { sFunctionCall = sDetailedFunction.Substring(0, iStartPar); } } } } if (isBlank(sActualParameters)) { sActualParameters = ""; } else if (sActualParameters.Length > 199) { sActualParameters = sActualParameters.Substring(0, 199); } sActualParameters = sActualParameters.Replace("'", "_"); sActualParameters = sActualParameters.Replace("\"", "_"); xSQL_InsertBuilder sb = new xSQL_InsertBuilder((webservice_database)this, "user_action"); if (sConsumerGuid.Length > 50) { sConsumerGuid = sConsumerGuid.Substring(0, 49); } if (sActualParameters.Length > 99) { sActualParameters = sActualParameters.Substring(0, 98); } if (sFunctionCall.Length > 50) { sFunctionCall = sFunctionCall.Substring(0, 49); } sb.add("consumer_guid", sConsumerGuid); if (sCouponId != "") { sb.add("coupon_id", sCouponId); } sb.add("action", sFunctionCall); sb.add("sub_action", sSubAction); sb.add("parameters", sActualParameters); sb.add("timestamp", DateTime.Now.Subtract(new TimeSpan(1, 0, 0))); // 19 nov fix we get 1 hour wrong on Azure !!! bOK = sb.ExecuteSql(); } catch (Exception e) { log_call("PROBLEM"); return(false); } return(true); }
public bool save_page_view() { bool bOK = false; try { xSQL_InsertBuilder ib = new xSQL_InsertBuilder(this, "bank_phone_page_view"); ib.add("timestamp", DateTime.Now); bool bOk = ib.ExecuteSql(); } catch (Exception) { } finally { } return bOK; }