/// <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);
}
