public string PrepareCashDeskEvent(int InstallationNumber, int FaultType)
{
//DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString;
try
{
return(DataBaseServiceHandler.ExecuteScalar <string>(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_RSP_CASHDESKEVENT,
DataBaseServiceHandler.AddParameter <int>("@InstallationNo", DbType.Int32, InstallationNumber),
DataBaseServiceHandler.AddParameter <int>("@FaultType", DbType.Int32, FaultType)));
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
return(string.Empty);
}
public static string GetExchangeKey()
{
string ExchangeKey = string.Empty;
try
{
ExchangeKey = DataBaseServiceHandler.ExecuteScalar <string>(GetConnectionString(), CommandType.StoredProcedure,
"rsp_GetExchangePassKeys");
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
return(ExchangeKey);
}
public int GetCurrentBarPosCount()
{
int BarPositionCount = 0;
try
{
//DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString;
BarPositionCount = DataBaseServiceHandler.ExecuteScalar <int>(CommonDataAccess.ExchangeConnectionString, CommandType.Text, "SELECT COUNT(*) FROM Bar_Position WHERE End_Date IS NULL");
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(BarPositionCount);
}
public static string GetVersion()
{
string sResult = DataBaseServiceHandler.ExecuteScalar <string>(ExchangeConnectionString, CommandType.Text, "Select VersionName from VersionHistory");
return(sResult);
}