public DataTable GetWTDMTD()
{
DataTable dtWTDMTD = new DataTable();
try
{
dtWTDMTD = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, "rsp_GetWTDMTD", dtWTDMTD);
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
return(dtWTDMTD);
}
public DataTable GetPayPeriodList()
{
try
{
string GetPayPeriodList = "rsp_GetPayPeriods";
DataTable dtPPList = new DataTable();
dtPPList = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, GetPayPeriodList, dtPPList);
return(dtPPList);
}
catch (Exception ex)
{
LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Error);
return(null);
}
}
public DataTable GetFailureReasons()
{
DataTable FailureReason = new DataTable();
try
{
//DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString;
FailureReason = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_GET_FAILURE_REASONS, FailureReason);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(FailureReason);
}
public DataTable GetPlayerDetails(Int32 InstallationNo)
{
DataTable PlayerDetail = new DataTable();
try
{
PlayerDetail = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, "rsp_PlayerClub_GetPlayerDetails", PlayerDetail,
DataBaseServiceHandler.AddParameter <Int32>("@Installation_No", DbType.Int32, InstallationNo));
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
return(PlayerDetail);
}
public DataSet GetMachineDetailsTreasury(string TreasuryNumber)
{
DataSet MachineDetailTreasury = new DataSet();
try
{
//DataBaseServiceHandler.ConnectionString = ExchangeConnectionString;
MachineDetailTreasury = DataBaseServiceHandler.Fill(ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONSTANT_RSP_GETMCDETAILSVIATREASURY, MachineDetailTreasury,
DataBaseServiceHandler.AddParameter <string>("Treasury_ID", DbType.String, TreasuryNumber));
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(MachineDetailTreasury);
}
public DataTable GetHandpaystoClear(int InstallationNo)
{
DataTable Handpay = new DataTable();
try
{
//DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString;
Handpay = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.Text, "Select IsNull(Datapak_No, 0) As Datapak_No From installation Where Installation_no = " + InstallationNo.ToString(), Handpay);
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
return(Handpay);
}
public DataTable GetTicketingExceptionTable(string TicketNumber)
{
DataTable ticketingException = new DataTable();
try
{
//DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString;
ticketingException = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_GET_TICKETING_EXCEPTIONS_PROC, ticketingException,
DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_TE_TICKET_NUMBER, DbType.Int32, TicketNumber),
DataBaseServiceHandler.AddParameter <int>(DBConstants.CONST_PARAM_TE_ID, DbType.Int32, 0));
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(ticketingException);
}
public DataTable GetBarPositionsEnrolledOnGamingDay(DateTime Date, int StartHour)
{
DataTable dtHourlyData = new DataTable();
SqlParameter[] Param = new SqlParameter[2];
try
{
Param[0] = DataBaseServiceHandler.AddParameter <DateTime>("@date", DbType.DateTime, Date);
Param[1] = DataBaseServiceHandler.AddParameter <int>("@starthour", DbType.Int32, StartHour);
dtHourlyData = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, rsp_GetBarPositionsEnrolledOnGamingDay, dtHourlyData, Param);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(dtHourlyData);
}
public DataTable GetMeterList(string display, int record_No, int hour_No)
{
DataSet dtMeters = null;
try
{
//DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString;
dtMeters = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, "RecordType", dtMeters, DataBaseServiceHandler.AddParameter <string>("", DbType.String, display),
DataBaseServiceHandler.AddParameter <int>("id", DbType.Int32, record_No),
DataBaseServiceHandler.AddParameter <int>("HourNo", DbType.Int32, hour_No));
return(dtMeters.Tables[0]);
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
return(null);
}
}
public void GetAssetDetails(int iInstallationNo, ref string SiteCode, ref string AssetNumber, ref string PosNumber)
{
DataSet AssetDetails = new DataSet();
try
{
//DataBaseServiceHandler.ConnectionString = ExchangeConnectionString;
AssetDetails = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONSTANT_RSP_GETASSETPOSDETAILS, AssetDetails,
DataBaseServiceHandler.AddParameter <int>("Installation_No", DbType.Int32, iInstallationNo));
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
PosNumber = AssetDetails.Tables[0].Rows[0]["Bar_Pos_Name"].ToString();
SiteCode = AssetDetails.Tables[0].Rows[0]["Code"].ToString();
AssetNumber = AssetDetails.Tables[0].Rows[0]["Stock_No"].ToString();
}
public static DataTable GetInstallationDetailsForHourly()
{
DataTable dtInstallationDetails = new DataTable();
try
{
dtInstallationDetails = DataBaseServiceHandler.Fill(ExchangeConnectionString, CommandType.StoredProcedure, "rsp_GetAllInstallationDetailsForHourly", dtInstallationDetails);
if (dtInstallationDetails.Rows.Count <= 0)
{
dtInstallationDetails = new DataTable();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(dtInstallationDetails);
}
public DataTable GetSiteName()
{
SqlCommand objComm = new SqlCommand();
objComm.CommandText = "select Name from site";
DataTable dtSite = new DataTable();
try
{
//objComm.Connection = new SqlConnection(DataBaseServiceHandler.ConnectionString);
//DataBaseServiceHandler.Fill(objComm, out dtSite);
dtSite = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.Text, "select Name from site", dtSite);
}
catch (Exception ex)
{
LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Error);
}
return(dtSite);
}
public DataTable GetTicketsClaimedByCDForPeriod(int SelectDay, DateTime IsDate, int MachineNo)
{
DataTable dt = new DataTable();
try
{
//DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString;
dt = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, "rsp_GetTicketsClaimedByCDForPeriod", dt,
DataBaseServiceHandler.AddParameter <int>("@MachineNo", DbType.Int32, MachineNo),
DataBaseServiceHandler.AddParameter <int>("@bStartOfDay", DbType.Int32, SelectDay),
DataBaseServiceHandler.AddParameter <DateTime>("@Date", DbType.DateTime, IsDate));
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
return(dt);
}
public DataTable GetBarPositionDetails(string SortBy, int InstallNo)
{
DataTable BarPositionDetail = new DataTable();
try
{
//DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString;
BarPositionDetail = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, "rsp_GetBarPositionDetailsForCashDeskoperator", BarPositionDetail,
DataBaseServiceHandler.AddParameter <string>("SortBy", DbType.String, SortBy),
DataBaseServiceHandler.AddParameter <int>("InstallNo", DbType.Int32, InstallNo));
//BarPositionDetail = SqlHelper.ExecuteDataset(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, "rsp_GetBarPositionDetailsForCashDeskoperator").Tables[0];
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
return(BarPositionDetail);
}
public DataTable GetTicketException(int InstallationNo)
{
DataTable TicketException = new DataTable();
string sqlQuery;
sqlQuery = " SELECT TE_ID FROM Installation tI INNER JOIN Ticket_Exception tTE ON tTE.TE_Installation_No = tI.Installation_No ";
sqlQuery = sqlQuery + "WHERE te_status_create_actual='HANDPAY' AND coalesce(te_status_final_actual,'') <> 'HANDPAY' AND tI.Installation_No = " + InstallationNo.ToString();
try
{
//DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString;
TicketException = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.Text, sqlQuery, TicketException);
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
return(TicketException);
}
public DataTable GetEPIDetails(int InstallationNo)
{
string sqlQuery;
DataTable EPIDetail = new DataTable();
//sqlQuery = "SELECT EPIDetails = ISNULL(LTRIM(RTRIM(EPIDetails)), 0), CardinTime ,IsEPIAvailable = CASE WHEN ISNULL(LTRIM(RTRIM(EPIDetails)), 0) IN ('0', '') THEN '0' ELSE '1' END FROM Floor_status WHERE INSTALLATION_NO = " + InstallationNo.ToString();
try
{
//DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString;
//EPIDetail = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.Text, sqlQuery, EPIDetail);
EPIDetail = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, "rsp_PlayerClub_GetEPIDetails", EPIDetail,
DataBaseServiceHandler.AddParameter <int>("@Installation_ID", DbType.Int32, InstallationNo));
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
return(EPIDetail);
}
public DataTable GetAnalysisDetails(int InstallationNo, int StartOfDay, int SelectDay, DateTime Date)
{
SqlParameter[] objParams = null;
DataTable dtAnalysisDetail = new DataTable();
try
{
objParams = new SqlParameter[4];
objParams[0] = new SqlParameter("@Installation_No", InstallationNo);
objParams[1] = new SqlParameter("@bStartOfDay", StartOfDay);
objParams[2] = new SqlParameter("@bSelectDay", SelectDay);
objParams[3] = new SqlParameter("@Date", Date);
dtAnalysisDetail = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, "rsp_GetAnalysisDetails", dtAnalysisDetail, objParams);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(dtAnalysisDetail);
}
public static DataTable GetInstallationDetails()
{
DataTable dtInstallationDetails = new DataTable();
//DataBaseServiceHandler.ConnectionString = ExchangeConnectionString;
try
{
dtInstallationDetails = DataBaseServiceHandler.Fill(ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_GET_INSTALLTION_DETAILS_PROC, dtInstallationDetails);
if (dtInstallationDetails.Rows.Count <= 0)
{
dtInstallationDetails = new DataTable();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(dtInstallationDetails);
}
public DataTable GetInstallationDetailsForReports(string reportType)
{
DataTable dtInstallationDetails = new DataTable();
//DataBaseServiceHandler.ConnectionString = ExchangeConnectionString;
try
{
dtInstallationDetails = DataBaseServiceHandler.Fill(ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_GET_INSTALLTION_DETAILS_REPORTS_PROC, dtInstallationDetails,
DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_REPORT_TYPE, DbType.String, reportType));
if (dtInstallationDetails.Rows.Count <= 0)
{
dtInstallationDetails = new DataTable();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(dtInstallationDetails);
}
public DataTable GetHourlyStatisticsForOccupancy(Transport.CashDeskOperatorEntity.HourlyDetails objHourlyDetails)
{
DataTable dtHourlyData = new DataTable();
SqlParameter[] Param = new SqlParameter[7];
try
{
Param[0] = DataBaseServiceHandler.AddParameter <string>("@DataType", DbType.String, objHourlyDetails.Datatype);
Param[1] = DataBaseServiceHandler.AddParameter <int>("@rows", DbType.Int32, objHourlyDetails.Rows);
Param[2] = DataBaseServiceHandler.AddParameter <int>("@starthour", DbType.Int32, objHourlyDetails.StartHour);
Param[3] = objHourlyDetails.Category == 0 ? DataBaseServiceHandler.AddParameter <object>("@category", DbType.Int32, DBNull.Value) : DataBaseServiceHandler.AddParameter <int>("@category", DbType.Int32, objHourlyDetails.Category);
Param[4] = objHourlyDetails.Zone == 0 ? DataBaseServiceHandler.AddParameter <object>("@zone", DbType.Int32, DBNull.Value) : DataBaseServiceHandler.AddParameter <int>("@zone", DbType.Int32, objHourlyDetails.Zone);
Param[5] = objHourlyDetails.Position == 0 ? DataBaseServiceHandler.AddParameter <object>("@position", DbType.Int32, DBNull.Value) : DataBaseServiceHandler.AddParameter <int>("@position", DbType.Int32, objHourlyDetails.Position);
Param[6] = objHourlyDetails.Date == DateTime.MinValue ? DataBaseServiceHandler.AddParameter <object>("@date", DbType.DateTime, DBNull.Value) : DataBaseServiceHandler.AddParameter <DateTime>("@date", DbType.DateTime, objHourlyDetails.Date);
dtHourlyData = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, Get24HourStatisticsByOccupancy, dtHourlyData, Param);
}
catch (Exception ex)
{
LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Error);
}
return(dtHourlyData);
}
/// <summary>
/// Gets the VTP hourly Data
/// </summary>
/// <param name="objHourlyDetails">Hourly Details entity</param>
/// <returns></returns>
public DataSet GetHourlyStatistics(string Datatype, int Rows, int StartHour, int Category, int Zone, int Position, DateTime Date)
{
DataSet dtHourlyData = new DataSet();
SqlParameter[] Param = new SqlParameter[7];
try
{
Param[0] = DataBaseServiceHandler.AddParameter <string>("@DataType", DbType.String, Datatype);
Param[1] = DataBaseServiceHandler.AddParameter <int>("@rows", DbType.Int32, Rows);
Param[2] = DataBaseServiceHandler.AddParameter <int>("@starthour", DbType.Int32, StartHour);
Param[3] = Category == 0 ? DataBaseServiceHandler.AddParameter <object>("@category", DbType.Int32, DBNull.Value) : DataBaseServiceHandler.AddParameter <int>("@category", DbType.Int32, Category);
Param[4] = Zone == 0 ? DataBaseServiceHandler.AddParameter <object>("@zone", DbType.Int32, DBNull.Value) : DataBaseServiceHandler.AddParameter <int>("@zone", DbType.Int32, Zone);
Param[5] = Position == 0 ? DataBaseServiceHandler.AddParameter <object>("@position", DbType.Int32, DBNull.Value) : DataBaseServiceHandler.AddParameter <int>("@position", DbType.Int32, Position);
Param[6] = Date == DateTime.MinValue ? DataBaseServiceHandler.AddParameter <object>("@date", DbType.DateTime, DBNull.Value) : DataBaseServiceHandler.AddParameter <DateTime>("@date", DbType.DateTime, Date);
dtHourlyData = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, Get24HourStatisticsPROC, dtHourlyData, Param);
}
catch (Exception ex)
{
LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Error);
}
return(dtHourlyData);
}
public string GetCurrentBarPositionNames()
{
DataTable CurrentServiceCalls = new DataTable();
string BarPositionNames = string.Empty;
try
{
//DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString;
CurrentServiceCalls = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_RSP_GETCURRENTBARPOSITIONNAMES, CurrentServiceCalls,
DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_SITE_CODE, DbType.String, GetCurrentSiteCode()),
DataBaseServiceHandler.AddParameter <int>("@RETURN_VALUE", DbType.Int32, 0, ParameterDirection.InputOutput));
foreach (DataRow dr in CurrentServiceCalls.Rows)
{
BarPositionNames += Common.TypeHandler.GetRowValue <string>(dr, "Bar_Pos_Name");
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(BarPositionNames);
}
public DataTable GetUserRoles(string UserName, string Password)
{
DataTable userRoles = new DataTable();
try
{
userRoles = DataBaseServiceHandler.Fill(ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_GET_USER_ROLE_PROC, userRoles,
DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_USER_NAME, DbType.String, UserName),
DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_USER_PASSWORD, DbType.String, Password));
}
catch (Exception ex)
{
if (ex.Message == "Connectionstring Not Found.")
{
throw ex;
}
else
{
ExceptionManager.Publish(ex);
}
}
return(userRoles);
}
public DataTable GetInstallationDetails(int DatapakSerialNo, int InstallationNumber, bool ShouldIncludeVirtual, bool ShouldSortbyZone)
{
DataTable dtInstallationDetails = new DataTable();
//DataBaseServiceHandler.ConnectionString = ExchangeConnectionString;
try
{
dtInstallationDetails = DataBaseServiceHandler.Fill(ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_GET_INSTALLTION_DETAILS_PROC, dtInstallationDetails,
DataBaseServiceHandler.AddParameter <int>(DBConstants.CONST_PARAM_DATAPAK_SERIAL, DbType.Int32, DatapakSerialNo),
DataBaseServiceHandler.AddParameter <int>(DBConstants.CONST_PARAM_INSTALLATION_NUMBER, DbType.Int32, InstallationNumber),
DataBaseServiceHandler.AddParameter <bool>(DBConstants.CONST_PARAM_INCLUDE_VIRTUAL, DbType.Boolean, ShouldIncludeVirtual),
DataBaseServiceHandler.AddParameter <bool>(DBConstants.CONST_PARAM_SORT_BY_ZONE, DbType.Boolean, ShouldSortbyZone));
if (dtInstallationDetails.Rows.Count <= 0)
{
dtInstallationDetails = new DataTable();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(dtInstallationDetails);
}
public DataTable FillHSTypes()
{
DataTable dtHSTypes = new DataTable();
SqlParameter[] Param = new SqlParameter[1];
try
{
if (ExtensionMethods.CurrentSiteCulture.ToUpper().Contains("IT"))
{
Param[0] = DataBaseServiceHandler.AddParameter <string>("@Language", DbType.String, "it-IT");
}
else
{
Param[0] = DataBaseServiceHandler.AddParameter <string>("@Language", DbType.String, "en-US");
}
dtHSTypes = DataBaseServiceHandler.Fill(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, GetHourlyStatisticsTypes, dtHSTypes, Param);
}
catch (Exception ex)
{
LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Error);
}
return(dtHSTypes);
}