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