/// <summary> /// Gets the formatted sysdate. /// </summary> /// <param name="format">The format.</param> /// <returns></returns> static public string GetFormattedSysdate(string format) { try { var sysdateSet = new ActiveRecordSet { Query = "Select TO_CHAR(sysdate,'" + format + "') as CurrentDate FROM dual" }; if (sysdateSet.Execute() && sysdateSet.MoveNext()) { return(sysdateSet["CurrentDate"].ToString()); } } catch (Exception ex) { LogError(ex.Message, "GetFormattedSysdate"); } return(string.Empty); }
/// <summary> /// Gets the sysdate as string. /// </summary> /// <param name="instance">The instance.</param> /// <returns></returns> static public string GetSysdateAsString(string instance) { try { var sysdateSet = new ActiveRecordSet(instance) { Query = "Select SYSDATE from dual" }; if (sysdateSet.Execute() && sysdateSet.MoveNext()) { return(sysdateSet["SYSDATE"].ToString()); } } catch (Exception ex) { LogError(ex.Message, "GetSysdateAsString"); } return(string.Empty); }
public static string GetCallClaimIdFromCallId(string callId, string instance) { try { var records = new ActiveRecordSet { Instance = instance, Query = string.Format("select call_claim_id from call_claim where call_id = {0}", callId) }; if (records.Execute() && records.MoveNext()) { return(records[0].ToString()); } } catch (Exception ex) { GeneralUtility.LogError(ex.Message, "GetCallClaimIdFromCallId"); } return(string.Empty); }