/// <summary> /// Get Ticketing Connection String /// </summary> /// <param name="ExchangeConnection"></param> /// <returns>Ticketing Connection String</returns> /// Method Revision History /// /// Author Date Description /// --------------------------------------------------- /// Anuradha 10-Dec-2008 Intial Version /// public static string TicketingConnectionString(string ExchangeConnection) { string strTicketingConnectionString = string.Empty; int SettingID = 0; try { Dictionary <int, string> dtSetting = new Dictionary <int, string>(); dtSetting = DBBuilder.GetSetting(ExchangeConnection, DBBuilder.AddParameter <int>("@Setting_ID", System.Data.DbType.Int32, SettingID, 32), DBBuilder.AddParameter <string>("@Setting_Name", System.Data.DbType.String, DBConstants.TICKETINGCONNECTIONSETTING, 500), DBBuilder.AddParameter <string>("@Setting_Default", System.Data.DbType.String, string.Empty, 500), DBBuilder.AddOutputParameter <string>("@Setting_Value", System.Data.DbType.String, string.Empty, 500)); foreach (KeyValuePair <int, string> objValue in dtSetting) { strTicketingConnectionString = objValue.Value.ToString(); } } catch (Exception ex) { LogManager.WriteLog("TicketingConnectionString" + ex.Message.ToString() + ex.Source.ToString(), LogManager.enumLogLevel.Error); ExceptionManager.Publish(ex); } return(strTicketingConnectionString); }
public static string GetSettingValue(string ExchangeConnection, string strSettingName) { string sResult = string.Empty; int SettingID = 0; try { if (strSettingName != null && strSettingName != string.Empty) { Dictionary <int, string> dtSetting = new Dictionary <int, string>(); dtSetting = DBBuilder.GetSetting(ExchangeConnection, DBBuilder.AddParameter <int>("@Setting_ID", System.Data.DbType.Int32, SettingID, 32), DBBuilder.AddParameter <string>("@Setting_Name", System.Data.DbType.String, strSettingName, 500), DBBuilder.AddParameter <string>("@Setting_Default", System.Data.DbType.String, string.Empty, 500), DBBuilder.AddOutputParameter <string>("@Setting_Value", System.Data.DbType.String, string.Empty, 500)); foreach (KeyValuePair <int, string> objValue in dtSetting) { sResult = objValue.Value.ToString(); } } } catch (Exception ex) { ExceptionManager.Publish(ex); } return(sResult); }