/// <summary>
/// To check whether Enable Redeem Receipt printer is enabled from the setting table.
/// </summary>
/// <param name=""></param>
/// <returns >true or false</returns>
public bool CheckEnableRedeemPrintCDODB()
{
string strproc = "CheckEnableRedeemPrintCDODB";
bool bEnableRedeemPrint = false;
try
{
SqlParameter[] sqlparams = CommonDataAccess.GetSettingParameterDB(DBConstants.CONST_SP_PARAM_ENABLEREDEEMPRINTCDO);
SqlHelper.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, System.Data.CommandType.StoredProcedure, DBConstants.CONST_SP_GETSETTING, sqlparams);
if (sqlparams[3].Value != null || sqlparams[3].Value.ToString() != string.Empty)
{
if (Convert.ToString(sqlparams[3].Value).ToUpper() == "TRUE")
{
bEnableRedeemPrint = true;
}
else
{
bEnableRedeemPrint = false;
}
}
else
{
bEnableRedeemPrint = false;
}
}
catch (Exception ex)
{
LogManager.WriteLog(strproc + ex.Message, LogManager.enumLogLevel.Error);
ExceptionManager.Publish(ex);
bEnableRedeemPrint = false;
}
return(bEnableRedeemPrint);
}
private void GetInstallationDetailsTable()
{
CommonDataAccess commonDataAccess = new CommonDataAccess();
try
{
objInstallationDetails = CommonDataAccess.GetInstallationDetailsForHourly();
}
catch (Exception ex)
{
LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Error);
}
}
public string FillEventType()
{
string strEventTypes = string.Empty;
try
{
strEventTypes = CommonDataAccess.GetSettingValue("EVENTTYPELIST");
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
strEventTypes = string.Empty;
}
return(strEventTypes);
}
public string FillSettingsToBeSkipped()
{
string strSettings = string.Empty;
try
{
strSettings = CommonDataAccess.GetSettingValue("SETTING_NAMES_HIDDEN");
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
strSettings = string.Empty;
}
return(strSettings);
}
/// <summary>
/// To Get EnableIssueReceipt from Setting table in Exchange DB
/// </summary>
/// <param name=""></param>
/// <returns type=boolean >bCreateTicketIssueReceipt</returns>
public bool CreateTicketIssueReceipt()
{
bool ShouldIssueReceipt = false;
try
{
SqlParameter[] sqlparams = CommonDataAccess.GetSettingParameterDB(DBConstants.CONST_SP_PARAM_ENABLEISSUERECEIPT);
SqlHelper.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, System.Data.CommandType.StoredProcedure, DBConstants.CONST_SP_GETSETTING, sqlparams);
if (sqlparams[3].Value != null && Convert.ToString(sqlparams[3].Value) != string.Empty && sqlparams[3].Value != DBNull.Value)
{
ShouldIssueReceipt = Convert.ToBoolean(sqlparams[3].Value);
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(ShouldIssueReceipt);
}
/// <summary>
/// To Open Connection with Ticketing DB and Exchange
/// </summary>
/// <param name=""></param>
/// <returns ></returns>
public bool OpenConnection()
{
string Connection = string.Empty;
bool IsConnectionOpen = false;
try
{
Connection = CommonDataAccess.ExchangeConnectionString;
if (CommonDataAccess.GetTicketingConnectionString(Connection) != string.Empty)
{
IsConnectionOpen = true;
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(IsConnectionOpen);
}
public string VoucherSite()
{
string VoucherSite = string.Empty;
try
{
SqlParameter[] sqlparams = CommonDataAccess.GetSettingParameterDB(DBConstants.CONST_SP_PARAM_VOUCHERSITENAME);
SqlHelper.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, System.Data.CommandType.StoredProcedure, DBConstants.CONST_SP_GETSETTING, sqlparams);
if (sqlparams[3].Value != null || sqlparams[3].Value.ToString() != string.Empty)
{
VoucherSite = Convert.ToString(sqlparams[3].Value);
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(VoucherSite);
}
/// <summary>
/// Retrieve the setting value
/// </summary>
/// <param name="strConnect"></param>
/// <returns>dictionary</returns>
public Dictionary <string, string> GetCMPCredentials(string strConnect)
{
Dictionary <string, string> objDicCMPDetails = new Dictionary <string, string>();
try
{
//Get the CMP Kiosk URL
SqlParameter[] sqlparams = CommonDataAccess.GetSettingParameterDB(DBConstants.CONSTANT_RSP_GETCMPKIOSKURL);
string strCMPURL = commonDataAccess.ExecuteQuery(strConnect, sqlparams);
if (!String.IsNullOrEmpty(strCMPURL))
{
objDicCMPDetails.Add("CMPURL", strCMPURL);
}
//Get the CMP Application USERNAME
SqlParameter[] sqlparams1 = CommonDataAccess.GetSettingParameterDB(DBConstants.CONSTANT_RSP_GETCMPAPPUSER);
string strCMPUSER = commonDataAccess.ExecuteQuery(strConnect, sqlparams1);
if (!String.IsNullOrEmpty(strCMPUSER))
{
objDicCMPDetails.Add("CMPUSER", strCMPUSER);
}
//Get the CMP Application Password
SqlParameter[] sqlparams2 = CommonDataAccess.GetSettingParameterDB(DBConstants.CONSTANT_RSP_GETCMPAPPPWD);
string strCMPPWD = commonDataAccess.ExecuteQuery(strConnect, sqlparams2);
if (!String.IsNullOrEmpty(strCMPPWD))
{
objDicCMPDetails.Add("CMPPWD", strCMPPWD);
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(objDicCMPDetails);
}
public string Region()
{
string Region = string.Empty;
try
{
SqlParameter[] sqlparams = CommonDataAccess.GetSettingParameterDB(DBConstants.CONST_SP_PARAM_REGION);
SqlHelper.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_GETSETTING, sqlparams);
if (sqlparams[3].Value != null || sqlparams[3].Value.ToString() != string.Empty)
{
Region = Convert.ToString(sqlparams[3].Value);
}
else
{
Region = string.Empty;
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(Region);
}
public DataTable GetAnalysisDetails(int SpotCheckDataType, DateTime StartDate, DateTime EndDate, AnalysisView viewType, int zoneId)
{
DataTable dtAnalysis = new DataTable();
double TotalCashIn = 0;
double TotalCashOut = 0;
double Totalhandle = 0;
int InstallationNo = 0;
double TotalDrop = 0;
double TotalBills = 0;
double TotalTicketsIn = 0;
double TotalCoinsIn = 0;
double TotalCoinsOut = 0;
double TicketsOut = 0;
double TotalHandpay = 0;
double TotalJackpot = 0;
double TotalPayout = 0;
double ProgressiveHandpay = 0;
double CashableEFTIn = 0;
double CashableEFTOut = 0;
double NonCashableEFTIn = 0;
double NonCashableEFTOut = 0;
double WATIn = 0;
double WATOut = 0;
double TotalNonCashableTicketsIn = 0;
double TotalNonCashableTicketsOut = 0;
double TotalMDA = 0;
double TotalAvgBet = 0;
double TotalWon = 0;
double TotalCashRefills = 0;
DateTime InstallationEndDate;
double TotalNetWin = 0;
double NumberofDays = 0;
double GAMES_BET = 0;
string reportType = string.Empty;
IDictionary<int, GetGroupByZone> zoneRows = new SortedDictionary<int, GetGroupByZone>();
dtAnalysis.Columns.Add("Installation_No");
dtAnalysis.Columns.Add("Bar_Pos_Name");
dtAnalysis.Columns.Add("Zone_No");
dtAnalysis.Columns.Add("Zone_Name");
dtAnalysis.Columns.Add("Stock_No");
dtAnalysis.Columns.Add("Name");
dtAnalysis.Columns.Add("LastMeterDate", typeof(DateTime));
dtAnalysis.Columns.Add("LastMeterUpdate");
dtAnalysis.Columns.Add("NoofMachine");
dtAnalysis.Columns.Add("GMUtoMachine");
dtAnalysis.Columns.Add("GMUtoServer");
dtAnalysis.Columns.Add("Bills_In", typeof(decimal));
dtAnalysis.Columns.Add("Coin_In", typeof(decimal));
dtAnalysis.Columns.Add("Coin_Out", typeof(decimal));
dtAnalysis.Columns.Add("Drop", typeof(decimal));
dtAnalysis.Columns.Add("Tickets_In", typeof(decimal));
dtAnalysis.Columns.Add("Tickets_Out", typeof(decimal));
dtAnalysis.Columns.Add("Non_Cashable_Tickets_In", typeof(decimal));
dtAnalysis.Columns.Add("Non_Cashable_Tickets_Out", typeof(decimal));
dtAnalysis.Columns.Add("Handpay", typeof(decimal));
dtAnalysis.Columns.Add("Jackpot", typeof(decimal));
dtAnalysis.Columns.Add("Prog_Handpay", typeof(decimal));
if (Settings.IsAFTEnabledForSite)
{
dtAnalysis.Columns.Add("CashableEFTIn", typeof(decimal));
dtAnalysis.Columns.Add("CashableEFTOut", typeof(decimal));
dtAnalysis.Columns.Add("NonCashableEFTIn", typeof(decimal));
dtAnalysis.Columns.Add("NonCashableEFTOut", typeof(decimal));
dtAnalysis.Columns.Add("WATIn", typeof(decimal));
dtAnalysis.Columns.Add("WATOut", typeof(decimal));
}
dtAnalysis.Columns.Add("Cash_In", typeof(decimal));
dtAnalysis.Columns.Add("Cash_Out", typeof(decimal));
dtAnalysis.Columns.Add("Handle", typeof(decimal));
dtAnalysis.Columns.Add("Payout", typeof(decimal));
dtAnalysis.Columns.Add("MDA", typeof(decimal));
dtAnalysis.Columns.Add("AvgBet", typeof(decimal));
dtAnalysis.Columns.Add("NetWin", typeof(decimal));
dtAnalysis.Columns.Add("Won", typeof(decimal));
dtAnalysis.Columns.Add("Cash_Refills", typeof(decimal));
dtAnalysis.Columns.Add("SortColumn", typeof(int));//used to maintain Row "Total" in top
dtAnalysis.Columns.Add("NumberofDays", typeof(decimal));
dtAnalysis.Columns.Add("GAMES_BET", typeof(decimal));
dtAnalysis.Columns.Add("IsTotalRow", typeof(bool)).DefaultValue = false;
try
{
switch (SpotCheckDataType.ToString())
{
case "1":
reportType = "DAY";
break;
case "2":
reportType = "DROP";
break;
case "3":
reportType = "WEEK";
break;
case "4":
reportType = "MONTH";
break;
}
DataTable dtDetails = new CommonDataAccess().GetInstallationDetailsForReports(reportType);
bool isGrouping = false;
if (zoneId != -1)
{
dtDetails = (from i in dtDetails.Rows.OfType<DataRow>()
where i["Zone_No"].ToString() == zoneId.ToString()
select i).CopyToDataTable();
isGrouping = (viewType == AnalysisView.Zone);
}
if (zoneId == -1 && viewType == AnalysisView.Zone)
{
isGrouping = true;
}
int ZoneCount = 0;
foreach (DataRow InstallationDetail in dtDetails.Rows)
{
if (InstallationDetail["Installation_No"] != DBNull.Value)
{
InstallationNo = Convert.ToInt32(InstallationDetail["Installation_No"]);
DateTime dt_date = DateTime.Now;
InstallationEndDate = ((InstallationDetail["End_Date"]) != DBNull.Value) ? Convert.ToDateTime(InstallationDetail["End_Date"]) : DateTime.Now.AddDays(1);
int StartOfDay = 0;
switch (SpotCheckDataType)
{
case 1:
StartOfDay = 1;
break;
case 2:
//spotCheckData.Type = 2;
StartOfDay = 2;
break;
case 3:
StartDate = analysisDataAccessHandler.GetMonthOrWeekStartDate().Rows[0]["WeekStart"].ToString().ReadDate();
dt_date = StartDate;
//if (InstallationEndDate.Date <= StartDate.Date) continue;
break;
case 4:
StartDate = analysisDataAccessHandler.GetMonthOrWeekStartDate().Rows[0]["MonthStart"].ToString().ReadDate();
dt_date = StartDate;
//if (InstallationEndDate.Date <= StartDate.Date) continue;
break;
}
LogManager.WriteLog("GetAnalysisDetails:Getting Meters for DB for Installation:" + InstallationNo, LogManager.enumLogLevel.Info);
DataTable dt_CurrMeters = analysisDataAccessHandler.GetAnalysisDetails(InstallationNo, StartOfDay, 0, dt_date);
DataRow dr_CurrM = null;
if (dt_CurrMeters.Rows.Count > 0)
{
dr_CurrM = dt_CurrMeters.Rows[0];
}
else
{
LogManager.WriteLog("GetAnalysisDetails:InstallationNo Not Found", LogManager.enumLogLevel.Error);
}
DataRow dr = null;
int zoneIdActual = 0;
Int32.TryParse(InstallationDetail["Zone_No"].ToString(), out zoneIdActual);
bool addToCollection = false;
switch (viewType)
{
case AnalysisView.Zone:
if (zoneRows.ContainsKey(zoneIdActual))
{
GetGroupByZone gp_zone = zoneRows[zoneIdActual];
dr = gp_zone.dr_row;
gp_zone.count += 1;
}
else
{
addToCollection = true;
}
break;
default:
break;
}
if (dr == null)
{
dr = dtAnalysis.NewRow();
dtAnalysis.Rows.Add(dr);
if (addToCollection)
{
zoneRows.Add(zoneIdActual, new GetGroupByZone { dr_row = dr, count = 1 });
}
}
if (!isGrouping)
{
dr["Installation_No"] = InstallationDetail["Installation_no"].ToString();
dr["Bar_Pos_Name"] = InstallationDetail["Bar_Pos_Name"].ToString();
dr["Stock_No"] = InstallationDetail["Stock_No"].ToString();
dr["Name"] = InstallationDetail["Name"].ToString();
dr["LastMeterUpdate"] = InstallationDetail["LastMeterUpdate"].Equals(DBNull.Value) ? "" : Convert.ToDateTime(InstallationDetail["LastMeterUpdate"]).ToString("dd-MMM-yyyy HH:mm:ss");
dr["LastMeterDate"] = InstallationDetail["LastMeterUpdate"].Equals(DBNull.Value) ? DateTime.MinValue : InstallationDetail["LastMeterUpdate"];
//dr["Payout"] = Convert.ToDouble(dr_CurrM["Payout"]).ToString("F");
if (Convert.ToInt16(InstallationDetail["Datapak_PollingStatus"]) == 0)
dr["GMUtoServer"] = "ERROR";
else
dr["GMUtoServer"] = "OK";
if (Convert.ToInt16(InstallationDetail["GMU_Machine_Status"]) == 0)
dr["GMUtoMachine"] = "ERROR";
else
{
if (Convert.ToInt16(InstallationDetail["Datapak_PollingStatus"]) == 0)
dr["GMUtoMachine"] = "UNKNOWN";
else
dr["GMUtoMachine"] = "OK";
}
}
else
{
dr["Installation_No"] = string.Empty;
dr["Bar_Pos_Name"] = string.Empty;
dr["Stock_No"] = string.Empty;
dr["Name"] = string.Empty;
dr["LastMeterUpdate"] = string.Empty;
//dr["Payout"] = string.Empty;
}
dr["SortColumn"] = 0;
if (viewType == AnalysisView.Zone)
{
dr["NoofMachine"] = zoneRows[zoneIdActual].count;
}
else
{
dr["NoofMachine"] = Convert.ToInt32(InstallationDetail["NoofMachine"] != DBNull.Value ? InstallationDetail["NoofMachine"] : 0);
}
dr["Zone_No"] = InstallationDetail["Zone_No"].ToString();
dr["Zone_Name"] = InstallationDetail["Zone_Name"].ToString();
dr_CurrM["NumberofDays"] = Convert.ToDouble(dr_CurrM["NumberofDays"]).ToString();
dr_CurrM["GAMES_BET"] = Convert.ToDouble(dr_CurrM["GAMES_BET"]).ToString();
dr_CurrM["Payout"] = Convert.ToDouble(dr_CurrM["Payout"]).ToString("F");
TotalBills += this.AddIntValue(dr, dr_CurrM, "Bills_In");
TotalTicketsIn += this.AddDoubleValue(dr, dr_CurrM, "Tickets_In");
TotalCoinsIn += this.AddDoubleValue(dr, dr_CurrM, "Coin_In");
TotalNonCashableTicketsIn += this.AddDoubleValue(dr, dr_CurrM, "Non_Cashable_Tickets_In");
TotalNonCashableTicketsOut += this.AddDoubleValue(dr, dr_CurrM, "Non_Cashable_Tickets_Out");
TotalPayout += this.AddDoubleValue(dr, dr_CurrM, "Payout");
TotalDrop += this.AddDoubleValue(dr, dr_CurrM, "Drop");
TotalCashIn += this.AddDoubleValue(dr, dr_CurrM, "Cash_In");
TotalCashOut += this.AddDoubleValue(dr, dr_CurrM, "Cash_Out");
TotalNetWin += this.AddDoubleValue(dr, dr_CurrM, "NetWin");
NumberofDays += this.AddDoubleValue(dr, dr_CurrM, "NumberofDays");
GAMES_BET += this.AddDoubleValue(dr, dr_CurrM, "GAMES_BET");
Totalhandle += this.AddDoubleValue(dr, dr_CurrM, "Handle");
TotalMDA += this.AddDoubleValue(dr, dr_CurrM, "MDA");
TotalCoinsOut += this.AddDoubleValue(dr, dr_CurrM, "Coin_Out");
TicketsOut += this.AddDoubleValue(dr, dr_CurrM, "Tickets_Out");
TotalHandpay += this.AddDoubleValue(dr, dr_CurrM, "Handpay");
TotalJackpot += this.AddDoubleValue(dr, dr_CurrM, "Jackpot");
ProgressiveHandpay += this.AddDoubleValue(dr, dr_CurrM, "Prog_Handpay");
TotalAvgBet += this.AddDoubleValue(dr, dr_CurrM, "AvgBet");
TotalWon += this.AddDoubleValue(dr, dr_CurrM, "WON"); ;
TotalCashRefills += this.AddDoubleValue(dr, dr_CurrM, "Cash_Refills");
if (Settings.IsAFTEnabledForSite)
{
CashableEFTIn += this.AddDoubleValue(dr, dr_CurrM, "CashableEFTIn");
CashableEFTOut += this.AddDoubleValue(dr, dr_CurrM, "CashableEFTOut");
NonCashableEFTIn += this.AddDoubleValue(dr, dr_CurrM, "NonCashableEFTIn");
NonCashableEFTOut += this.AddDoubleValue(dr, dr_CurrM, "NonCashableEFTOut");
WATIn += this.AddDoubleValue(dr, dr_CurrM, "WATIn");
WATOut += this.AddDoubleValue(dr, dr_CurrM, "WATOut");
}
}
}
if (dtAnalysis.Rows.Count > 0)
{
DataRow SumOfRows = dtAnalysis.NewRow();
SumOfRows["Installation_No"] = string.Empty;
SumOfRows["Bar_Pos_Name"] = "Total";
SumOfRows["Stock_No"] = string.Empty;
SumOfRows["Name"] = string.Empty;
SumOfRows["LastMeterUpdate"] = string.Empty;
SumOfRows["Cash_In"] = TotalCashIn;
SumOfRows["Cash_Out"] = TotalCashOut;
SumOfRows["NetWin"] = (TotalCashIn - TotalCashOut);
SumOfRows["Handle"] = Totalhandle;
SumOfRows["Drop"] = TotalDrop;
SumOfRows["NoofMachine"] = dtDetails.Rows.Count;
SumOfRows["WON"] = TotalWon;
SumOfRows["Cash_Refills"] = TotalCashRefills;
SumOfRows["IsTotalRow"] = true;
if (Totalhandle != 0)
SumOfRows["Payout"] = Math.Round(((Totalhandle - TotalNetWin) / Totalhandle) * 100, 2);
else
SumOfRows["Payout"] = 0;
/// dtDetails.Rows.Count,2,MidpointRounding.AwayFromZero);
//if (TotalGamesBet == 0)
// TotalAvgBet = Totalhandle;
//else
// TotalAvgBet = Totalhandle / TotalGamesBet;
//if (Numberofdays > 0)
// MDA = (decimal)(TotalCashIn - TotalCashOut) /( dtAnalysis.Rows.Count * Numberofdays) ;
//else
// MDA = (decimal)(TotalCashIn - TotalCashOut) / dtAnalysis.Rows.Count;
if (GAMES_BET == 0)
SumOfRows["AvgBet"] = Math.Round(Totalhandle, 2);
else
SumOfRows["AvgBet"] = Math.Round(Convert.ToDecimal(Totalhandle / GAMES_BET), 2);// TotalAvgBet;
if (NumberofDays == 0)
SumOfRows["MDA"] = Math.Round(TotalNetWin, 2);
else
SumOfRows["MDA"] = Math.Round(Convert.ToDecimal(TotalNetWin / NumberofDays), 2);// TotalMDA;//Modified Total AvgDailyWin calculation CR#92149 Fix
SumOfRows["Bills_In"] = TotalBills;
SumOfRows["Tickets_In"] = TotalTicketsIn;
SumOfRows["Tickets_Out"] = TicketsOut;
SumOfRows["Coin_In"] = TotalCoinsIn;
SumOfRows["Coin_Out"] = TotalCoinsOut;
SumOfRows["Non_Cashable_Tickets_In"] = TotalNonCashableTicketsIn;
SumOfRows["Non_Cashable_Tickets_out"] = TotalNonCashableTicketsOut;
SumOfRows["Handpay"] = TotalHandpay;
SumOfRows["Jackpot"] = TotalJackpot;
SumOfRows["Prog_Handpay"] = ProgressiveHandpay;
if (Settings.IsAFTEnabledForSite)
{
SumOfRows["CashableEFTIn"] = CashableEFTIn;
SumOfRows["CashableEFTOut"] = CashableEFTOut;
SumOfRows["NonCashableEFTIn"] = NonCashableEFTIn;
SumOfRows["NonCashableEFTOut"] = NonCashableEFTOut;
SumOfRows["WATIn"] = WATIn;
SumOfRows["WATOut"] = WATOut;
}
SumOfRows["SortColumn"] = 100;//used to avoid Column "Total" Sorting
dtAnalysis.Rows.InsertAt(SumOfRows, 0);
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return dtAnalysis;
}
private void LoadAccWinLossComboBoxes()
{
try
{
DataTable dt_zones = new CommonDataAccess().GetAllZones();
DataRow dataRow = dt_zones.NewRow();
dataRow["Zone_No"] = 0;
dataRow["Zone_Name"] = "ALL";
dt_zones.Rows.InsertAt(dataRow, 0);
LogManager.WriteLog("Setting Asset number combo box Item Source property", LogManager.enumLogLevel.Info);
cmbZone_AWLR.ItemsSource = ((System.ComponentModel.IListSource)dt_zones).GetList();
cmbZone_AWLR.DataContext = dt_zones.DefaultView;
cmbZone_AWLR.DisplayMemberPath = "Zone_Name";
cmbZone_AWLR.SelectedValuePath = "Zone_No";
cmbZone_AWLR.SelectedIndex = 0;
DataTable dt_machine_category = new CommonDataAccess().GetMachineCategory();
DataRow dataRow1 = dt_machine_category.NewRow();
dataRow1["Machine_Type_ID"] = 0;
dataRow1["Machine_Type_Code"] = "ALL";
dt_machine_category.Rows.InsertAt(dataRow1, 0);
LogManager.WriteLog("Setting Asset number combo box Item Source property", LogManager.enumLogLevel.Info);
cmbCategory_AWLR.ItemsSource = ((System.ComponentModel.IListSource)dt_machine_category).GetList();
cmbCategory_AWLR.DataContext = dt_machine_category.DefaultView;
cmbCategory_AWLR.DisplayMemberPath = "Machine_Type_Code";
cmbCategory_AWLR.SelectedValuePath = "Machine_Type_ID";
cmbCategory_AWLR.SelectedIndex = 0;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
public void GetAnalysisDetails(ref BMC.Transport.CashDeskOperatorEntity.SpotCheck objSpotCheck)
{
SqlParameter[] objParams = null;
try
{
if (System.Globalization.CultureInfo.CurrentCulture.Name == "it-IT" ||
System.Globalization.CultureInfo.CurrentUICulture.Name == "it-IT" ||
(Settings.RegulatoryEnabled && Settings.RegulatoryType == "AAMS"))
{
if (Settings.IsAFTEnabledForSite)
{
objParams = new SqlParameter[54];
}
else
{
objParams = new SqlParameter[48];
}
objParams[0] = new SqlParameter("@Installation_No", objSpotCheck.InstallationNo);
objParams[1] = CommonDataAccess.AddOutputparameter("@Cash_In ", objSpotCheck.CashIn);
objParams[2] = CommonDataAccess.AddOutputparameter("@Cash_Out", objSpotCheck.CashOut);
objParams[3] = CommonDataAccess.AddOutputparameter("@Token_In", objSpotCheck.TokenIn);
objParams[4] = CommonDataAccess.AddOutputparameter("@Token_Out", objSpotCheck.TokenOut);
objParams[5] = CommonDataAccess.AddOutputparameter("@Token_Refill", objSpotCheck.TokenRefill);
objParams[6] = CommonDataAccess.AddOutputparameter("@Cash_Refill", objSpotCheck.CashRefill);
objParams[7] = CommonDataAccess.AddOutputparameter("@COINS_IN", objSpotCheck.CoinsIn);
objParams[8] = CommonDataAccess.AddOutputparameter("@COINS_OUT", objSpotCheck.CoinsOut);
objParams[9] = CommonDataAccess.AddOutputparameter("@COINS_DROP", objSpotCheck.CoinsDrop);
objParams[10] = CommonDataAccess.AddOutputparameter("@CANCELLED_CREDITS", objSpotCheck.CancelledCredits);
objParams[11] = CommonDataAccess.AddOutputparameter("@VTP", objSpotCheck.VTP);
objParams[12] = CommonDataAccess.AddOutputparameter("@Datetime", objSpotCheck.DateTimeStamp);
objParams[13] = CommonDataAccess.AddOutputparameter("@Jackpot", objSpotCheck.Jackpot);
objParams[14] = CommonDataAccess.AddOutputparameter("@Handpay", objSpotCheck.HandPay);
objParams[15] = CommonDataAccess.AddOutputparameter("@BILL_1", objSpotCheck.Bill1);
objParams[16] = CommonDataAccess.AddOutputparameter("@BILL_2", objSpotCheck.Bill2);
objParams[17] = CommonDataAccess.AddOutputparameter("@BILL_5", objSpotCheck.Bill5);
objParams[18] = CommonDataAccess.AddOutputparameter("@BILL_10", objSpotCheck.Bill10);
objParams[19] = CommonDataAccess.AddOutputparameter("@BILL_20", objSpotCheck.Bill20);
objParams[20] = CommonDataAccess.AddOutputparameter("@BILL_50", objSpotCheck.Bill50);
objParams[21] = CommonDataAccess.AddOutputparameter("@BILL_100", objSpotCheck.Bill100);
objParams[22] = CommonDataAccess.AddOutputparameter("@BILL_250", objSpotCheck.Bill250);
objParams[23] = CommonDataAccess.AddOutputparameter("@BILL_10000", objSpotCheck.Bill10000);
objParams[24] = CommonDataAccess.AddOutputparameter("@BILL_20000", objSpotCheck.Bill20000);
objParams[25] = CommonDataAccess.AddOutputparameter("@BILL_50000", objSpotCheck.Bill50000);
objParams[26] = CommonDataAccess.AddOutputparameter("@BILL_100000", objSpotCheck.Bill100000);
objParams[27] = CommonDataAccess.AddOutputparameter("@Ticktes_Inserted", objSpotCheck.TicketsInserted);
objParams[28] = CommonDataAccess.AddOutputparameter("@TRUE_COIN_IN", objSpotCheck.TrueCoinIn);
objParams[29] = CommonDataAccess.AddOutputparameter("@TRUE_COIN_OUT", objSpotCheck.TrueCoinOut);
objParams[30] = CommonDataAccess.AddOutputparameter("@CASH_IN_1P", objSpotCheck.CashIn1p);
objParams[31] = CommonDataAccess.AddOutputparameter("@CASH_IN_2P", objSpotCheck.CashIn2p);
objParams[32] = CommonDataAccess.AddOutputparameter("@CASH_IN_100P", objSpotCheck.CashIn100p);
objParams[33] = CommonDataAccess.AddOutputparameter("@CASH_IN_200P", objSpotCheck.CashIn200p);
objParams[34] = CommonDataAccess.AddOutputparameter("@CASH_IN_500P", objSpotCheck.CashIn500p);
objParams[35] = CommonDataAccess.AddOutputparameter("@CASH_IN_1000P", objSpotCheck.CashIn1000p);
objParams[36] = CommonDataAccess.AddOutputparameter("@CASH_IN_2000P", objSpotCheck.CashIn2000p);
objParams[37] = CommonDataAccess.AddOutputparameter("@Tickets_Printed", objSpotCheck.TicketsPrinted);
objParams[38] = new SqlParameter("@bStartOfDay", objSpotCheck.StartOfDay);
objParams[39] = new SqlParameter("@bSelectDay", objSpotCheck.SelectDay);
objParams[40] = new SqlParameter("@Date", objSpotCheck.Date);
objParams[41] = CommonDataAccess.AddOutputparameter("@NoOfDays", 0);
objParams[42] = CommonDataAccess.AddOutputparameter("@ProgHandpay", objSpotCheck.ProgHandpay);
objParams[43] = CommonDataAccess.AddOutputparameter("@Games_Bet", 0);
if (Settings.IsAFTEnabledForSite)
{
objParams[44] = CommonDataAccess.AddOutputparameter("@CashableAFTIn", objSpotCheck.CashableEFTIn);
objParams[45] = CommonDataAccess.AddOutputparameter("@CashableAFTOut", objSpotCheck.CashableEFTOut);
objParams[46] = CommonDataAccess.AddOutputparameter("@NonCashableAFTIn", objSpotCheck.NonCashableEFTIn);
objParams[47] = CommonDataAccess.AddOutputparameter("@NonCashableAFTOut", objSpotCheck.NonCashableEFTOut);
objParams[48] = CommonDataAccess.AddOutputparameter("@WATIn", objSpotCheck.WATIn);
objParams[49] = CommonDataAccess.AddOutputparameter("@WATOut", objSpotCheck.WATOut);
objParams[50] = CommonDataAccess.AddOutputparameter("@BILL_200", objSpotCheck.Bill200);
objParams[51] = CommonDataAccess.AddOutputparameter("@BILL_500", objSpotCheck.Bill500);
objParams[52] = CommonDataAccess.AddOutputparameter("@NonCashable_Tickets_Inserted", objSpotCheck.NonCashableTicketsInserted);
objParams[53] = CommonDataAccess.AddOutputparameter("@NonCashable_Tickets_Printed", objSpotCheck.NonCashableTicketsPrinted);
}
else
{
objParams[44] = CommonDataAccess.AddOutputparameter("@BILL_200", objSpotCheck.Bill200);
objParams[45] = CommonDataAccess.AddOutputparameter("@BILL_500", objSpotCheck.Bill500);
objParams[46] = CommonDataAccess.AddOutputparameter("@NonCashable_Tickets_Inserted", objSpotCheck.NonCashableTicketsInserted);
objParams[47] = CommonDataAccess.AddOutputparameter("@NonCashable_Tickets_Printed", objSpotCheck.NonCashableTicketsPrinted);
}
SqlConnection objcon = new SqlConnection(CommonDataAccess.ExchangeConnectionString);
objcon.Open();
SqlCommand objcomd = new SqlCommand("usp_GetSpotCheckDataSAS", objcon);
objcomd.CommandType = CommandType.StoredProcedure;
objcomd.CommandTimeout = SqlHelper.LoadCommandTimeout();
objcomd.Parameters.AddRange(objParams);
objcomd.ExecuteReader();
objcon.Close();
objSpotCheck.CashIn = (objParams[1].Value).ToString().GetDecimal();
objSpotCheck.CashOut = (objParams[2].Value).ToString().GetDecimal();
objSpotCheck.TokenIn = (objParams[3].Value).ToString().GetDecimal();
objSpotCheck.TokenOut = (objParams[4].Value).ToString().GetDecimal();
objSpotCheck.TokenRefill = (objParams[5].Value).ToString().GetDecimal();
objSpotCheck.CashRefill = (objParams[6].Value).ToString().GetDecimal();
objSpotCheck.CoinsIn = (objParams[7].Value).ToString().GetDecimal();
objSpotCheck.CoinsOut = (objParams[8].Value).ToString().GetDecimal();
objSpotCheck.CoinsDrop = (double)(objParams[9].Value).ToString().GetDecimal();
objSpotCheck.CancelledCredits = (objParams[10].Value).ToString().GetDecimal();
objSpotCheck.VTP = (objParams[11].Value).ToString().GetDecimal();
objSpotCheck.DateTimeStamp = objParams[12].Value.ToString().ReadDate();
objSpotCheck.Jackpot = (objParams[13].Value).ToString().GetDecimal();
objSpotCheck.HandPay = (objParams[14].Value).ToString().GetDecimal();
objSpotCheck.TicketsInserted = (objParams[27].Value).ToString().GetDecimal();
objSpotCheck.TrueCoinIn = (objParams[28].Value).ToString().GetDecimal();
objSpotCheck.TrueCoinOut = (objParams[29].Value).ToString().GetDecimal();
objSpotCheck.TicketsPrinted = (objParams[36].Value).ToString().GetDecimal();
objSpotCheck.Bill1 = (objParams[15].Value).ToString().GetDecimal();
objSpotCheck.Bill2 = (objParams[16].Value).ToString().GetDecimal();
objSpotCheck.Bill5 = (objParams[17].Value).ToString().GetDecimal();
objSpotCheck.Bill10 = (objParams[18].Value).ToString().GetDecimal();
objSpotCheck.Bill20 = (objParams[19].Value).ToString().GetDecimal();
objSpotCheck.Bill50 = (objParams[20].Value).ToString().GetDecimal();
objSpotCheck.Bill100 = (objParams[21].Value).ToString().GetDecimal();
objSpotCheck.Bill250 = (objParams[22].Value).ToString().GetDecimal();
objSpotCheck.Bill10000 = (objParams[23].Value).ToString().GetDecimal();
objSpotCheck.Bill20000 = (objParams[24].Value).ToString().GetDecimal();
objSpotCheck.Bill50000 = (objParams[25].Value).ToString().GetDecimal();
objSpotCheck.Bill100000 = (objParams[26].Value).ToString().GetDecimal();
objSpotCheck.CashIn2p = (objParams[30].Value).ToString().GetDecimal();
objSpotCheck.CashIn100p = (objParams[31].Value).ToString().GetDecimal();
objSpotCheck.CashIn200p = (objParams[32].Value).ToString().GetDecimal();
objSpotCheck.CashIn500p = (objParams[33].Value).ToString().GetDecimal();
objSpotCheck.CashIn1000p = (objParams[34].Value).ToString().GetDecimal();
objSpotCheck.CashIn2000p = (objParams[35].Value).ToString().GetDecimal();
objSpotCheck.NumberOfDays = (objParams[40].Value == DBNull.Value) ? 0 : Convert.ToInt32(objParams[40].Value);
objSpotCheck.ProgHandpay = (objParams[41].Value).ToString().GetDecimal();
objSpotCheck.GamesBet = Convert.ToInt32(objParams[42].Value);
if (Settings.IsAFTEnabledForSite)
{
objSpotCheck.CashableEFTIn = (objParams[43].Value).ToString().GetDecimal();
objSpotCheck.CashableEFTOut = (objParams[44].Value).ToString().GetDecimal();
objSpotCheck.NonCashableEFTIn = (objParams[45].Value).ToString().GetDecimal();
objSpotCheck.NonCashableEFTOut = (objParams[46].Value).ToString().GetDecimal();
objSpotCheck.WATIn = (objParams[47].Value).ToString().GetDecimal();
objSpotCheck.WATOut = (objParams[48].Value).ToString().GetDecimal();
objSpotCheck.Bill200 = (objParams[49].Value).ToString().GetDecimal();
objSpotCheck.Bill500 = (objParams[50].Value).ToString().GetDecimal();
objSpotCheck.NonCashableTicketsInserted = (objParams[51].Value).ToString().GetDecimal();
objSpotCheck.NonCashableTicketsPrinted = (objParams[52].Value).ToString().GetDecimal();
}
else
{
objSpotCheck.Bill200 = (objParams[43].Value).ToString().GetDecimal();
objSpotCheck.Bill500 = (objParams[44].Value).ToString().GetDecimal();
objSpotCheck.NonCashableTicketsInserted = (objParams[45].Value).ToString().GetDecimal();
objSpotCheck.NonCashableTicketsPrinted = (objParams[46].Value).ToString().GetDecimal();
}
}
else
{
if (Settings.IsAFTEnabledForSite)
{
objParams = new SqlParameter[54];
}
else
{
objParams = new SqlParameter[48];
}
objParams[0] = new SqlParameter("@Installation_No", objSpotCheck.InstallationNo);
objParams[1] = CommonDataAccess.AddOutputparameter("@Cash_In ", objSpotCheck.CashIn);
objParams[2] = CommonDataAccess.AddOutputparameter("@Cash_Out", objSpotCheck.CashOut);
objParams[3] = CommonDataAccess.AddOutputparameter("@Token_In", objSpotCheck.TokenIn);
objParams[4] = CommonDataAccess.AddOutputparameter("@Token_Out", objSpotCheck.TokenOut);
objParams[5] = CommonDataAccess.AddOutputparameter("@Token_Refill", objSpotCheck.TokenRefill);
objParams[6] = CommonDataAccess.AddOutputparameter("@Cash_Refill", objSpotCheck.CashRefill);
objParams[7] = CommonDataAccess.AddOutputparameter("@COINS_IN", objSpotCheck.CoinsIn);
objParams[8] = CommonDataAccess.AddOutputparameter("@COINS_OUT", objSpotCheck.CoinsOut);
objParams[9] = CommonDataAccess.AddOutputparameter("@COINS_DROP", objSpotCheck.CoinsDrop);
objParams[10] = CommonDataAccess.AddOutputparameter("@CANCELLED_CREDITS", objSpotCheck.CancelledCredits);
objParams[11] = CommonDataAccess.AddOutputparameter("@VTP", objSpotCheck.VTP);
objParams[12] = CommonDataAccess.AddOutputparameter("@Datetime", objSpotCheck.DateTimeStamp);
objParams[13] = CommonDataAccess.AddOutputparameter("@Jackpot", objSpotCheck.Jackpot);
objParams[14] = CommonDataAccess.AddOutputparameter("@Handpay", objSpotCheck.HandPay);
objParams[15] = CommonDataAccess.AddOutputparameter("@BILL_1", objSpotCheck.Bill1);
objParams[16] = CommonDataAccess.AddOutputparameter("@BILL_2", objSpotCheck.Bill2);
objParams[17] = CommonDataAccess.AddOutputparameter("@BILL_5", objSpotCheck.Bill5);
objParams[18] = CommonDataAccess.AddOutputparameter("@BILL_10", objSpotCheck.Bill10);
objParams[19] = CommonDataAccess.AddOutputparameter("@BILL_20", objSpotCheck.Bill20);
objParams[20] = CommonDataAccess.AddOutputparameter("@BILL_50", objSpotCheck.Bill50);
objParams[21] = CommonDataAccess.AddOutputparameter("@BILL_100", objSpotCheck.Bill100);
objParams[22] = CommonDataAccess.AddOutputparameter("@BILL_250", objSpotCheck.Bill250);
objParams[23] = CommonDataAccess.AddOutputparameter("@BILL_10000", objSpotCheck.Bill10000);
objParams[24] = CommonDataAccess.AddOutputparameter("@BILL_20000", objSpotCheck.Bill20000);
objParams[25] = CommonDataAccess.AddOutputparameter("@BILL_50000", objSpotCheck.Bill50000);
objParams[26] = CommonDataAccess.AddOutputparameter("@BILL_100000", objSpotCheck.Bill100000);
objParams[27] = CommonDataAccess.AddOutputparameter("@Ticktes_Inserted", objSpotCheck.TicketsInserted);
objParams[28] = CommonDataAccess.AddOutputparameter("@TRUE_COIN_IN", objSpotCheck.TrueCoinIn);
objParams[29] = CommonDataAccess.AddOutputparameter("@TRUE_COIN_OUT", objSpotCheck.TrueCoinOut);
objParams[30] = CommonDataAccess.AddOutputparameter("@CASH_IN_1P", objSpotCheck.CashIn1p);
objParams[31] = CommonDataAccess.AddOutputparameter("@CASH_IN_2P", objSpotCheck.CashIn2p);
objParams[32] = CommonDataAccess.AddOutputparameter("@CASH_IN_100P", objSpotCheck.CashIn100p);
objParams[33] = CommonDataAccess.AddOutputparameter("@CASH_IN_200P", objSpotCheck.CashIn200p);
objParams[34] = CommonDataAccess.AddOutputparameter("@CASH_IN_500P", objSpotCheck.CashIn500p);
objParams[35] = CommonDataAccess.AddOutputparameter("@CASH_IN_1000P", objSpotCheck.CashIn1000p);
objParams[36] = CommonDataAccess.AddOutputparameter("@CASH_IN_2000P", objSpotCheck.CashIn2000p);
objParams[37] = CommonDataAccess.AddOutputparameter("@Tickets_Printed", objSpotCheck.TicketsPrinted);
objParams[38] = new SqlParameter("@bStartOfDay", objSpotCheck.StartOfDay);
objParams[39] = new SqlParameter("@bSelectDay", objSpotCheck.SelectDay);
objParams[40] = new SqlParameter("@Date", objSpotCheck.Date);
objParams[41] = CommonDataAccess.AddOutputparameter("@NoOfDays", 0);
objParams[42] = CommonDataAccess.AddOutputparameter("@ProgHandpay", 0);
objParams[43] = CommonDataAccess.AddOutputparameter("@Games_Bet", 0);
if (Settings.IsAFTEnabledForSite)
{
objParams[44] = CommonDataAccess.AddOutputparameter("@CashableAFTIn", objSpotCheck.CashableEFTIn);
objParams[45] = CommonDataAccess.AddOutputparameter("@CashableAFTOut", objSpotCheck.CashableEFTOut);
objParams[46] = CommonDataAccess.AddOutputparameter("@NonCashableAFTIn", objSpotCheck.NonCashableEFTIn);
objParams[47] = CommonDataAccess.AddOutputparameter("@NonCashableAFTOut", objSpotCheck.NonCashableEFTOut);
objParams[48] = CommonDataAccess.AddOutputparameter("@WATIn", objSpotCheck.WATIn);
objParams[49] = CommonDataAccess.AddOutputparameter("@WATOut", objSpotCheck.WATOut);
objParams[50] = CommonDataAccess.AddOutputparameter("@BILL_200", objSpotCheck.Bill200);
objParams[51] = CommonDataAccess.AddOutputparameter("@BILL_500", objSpotCheck.Bill500);
objParams[52] = CommonDataAccess.AddOutputparameter("@NonCashable_Tickets_Inserted", objSpotCheck.NonCashableTicketsInserted);
objParams[53] = CommonDataAccess.AddOutputparameter("@NonCashable_Tickets_Printed", objSpotCheck.NonCashableTicketsPrinted);
}
else
{
objParams[44] = CommonDataAccess.AddOutputparameter("@BILL_200", objSpotCheck.Bill200);
objParams[45] = CommonDataAccess.AddOutputparameter("@BILL_500", objSpotCheck.Bill500);
objParams[46] = CommonDataAccess.AddOutputparameter("@NonCashable_Tickets_Inserted", objSpotCheck.NonCashableTicketsInserted);
objParams[47] = CommonDataAccess.AddOutputparameter("@NonCashable_Tickets_Printed", objSpotCheck.NonCashableTicketsPrinted);
}
SqlConnection objcon = new SqlConnection(CommonDataAccess.ExchangeConnectionString);
objcon.Open();
SqlCommand objcomd = new SqlCommand("usp_GetSpotCheckDataSAS", objcon);
objcomd.CommandType = CommandType.StoredProcedure;
objcomd.CommandTimeout = SqlHelper.LoadCommandTimeout();
objcomd.Parameters.AddRange(objParams);
objcomd.ExecuteReader();
objcon.Close();
objSpotCheck.CashIn = (objParams[1].Value).ToString().GetDecimal();
objSpotCheck.CashOut = (objParams[2].Value).ToString().GetDecimal();
objSpotCheck.TokenIn = (objParams[3].Value).ToString().GetDecimal();
objSpotCheck.TokenOut = (objParams[4].Value).ToString().GetDecimal();
objSpotCheck.TokenRefill = (objParams[5].Value).ToString().GetDecimal();
objSpotCheck.CashRefill = (objParams[6].Value).ToString().GetDecimal();
objSpotCheck.CoinsIn = (objParams[7].Value).ToString().GetDecimal();
objSpotCheck.CoinsOut = (objParams[8].Value).ToString().GetDecimal();
objSpotCheck.CoinsDrop = (double)(objParams[9].Value).ToString().GetDecimal();
objSpotCheck.CancelledCredits = (objParams[10].Value).ToString().GetDecimal();
objSpotCheck.VTP = (objParams[11].Value).ToString().GetDecimal();
objSpotCheck.DateTimeStamp = objParams[12].Value.ToString().ReadDate();
objSpotCheck.Jackpot = (objParams[13].Value).ToString().GetDecimal();
objSpotCheck.HandPay = (objParams[14].Value).ToString().GetDecimal();
objSpotCheck.TicketsInserted = (objParams[27].Value).ToString().GetDecimal();
objSpotCheck.TrueCoinIn = (objParams[28].Value).ToString().GetDecimal();
objSpotCheck.TrueCoinOut = (objParams[29].Value).ToString().GetDecimal();
objSpotCheck.TicketsPrinted = (objParams[36].Value).ToString().GetDecimal();
objSpotCheck.Bill1 = (objParams[15].Value).ToString().GetDecimal();
objSpotCheck.Bill2 = (objParams[16].Value).ToString().GetDecimal();
objSpotCheck.Bill5 = (objParams[17].Value).ToString().GetDecimal();
objSpotCheck.Bill10 = (objParams[18].Value).ToString().GetDecimal();
objSpotCheck.Bill20 = (objParams[19].Value).ToString().GetDecimal();
objSpotCheck.Bill50 = (objParams[20].Value).ToString().GetDecimal();
objSpotCheck.Bill100 = (objParams[21].Value).ToString().GetDecimal();
objSpotCheck.Bill250 = (objParams[22].Value).ToString().GetDecimal();
objSpotCheck.Bill10000 = (objParams[23].Value).ToString().GetDecimal();
objSpotCheck.Bill20000 = (objParams[24].Value).ToString().GetDecimal();
objSpotCheck.Bill50000 = (objParams[25].Value).ToString().GetDecimal();
objSpotCheck.Bill100000 = (objParams[26].Value).ToString().GetDecimal();
objSpotCheck.CashIn2p = (objParams[30].Value).ToString().GetDecimal();
objSpotCheck.CashIn100p = (objParams[31].Value).ToString().GetDecimal();
objSpotCheck.CashIn200p = (objParams[32].Value).ToString().GetDecimal();
objSpotCheck.CashIn500p = (objParams[33].Value).ToString().GetDecimal();
objSpotCheck.CashIn1000p = (objParams[34].Value).ToString().GetDecimal();
objSpotCheck.CashIn2000p = (objParams[35].Value).ToString().GetDecimal();
objSpotCheck.NumberOfDays = (objParams[40].Value == DBNull.Value) ? 0 : Convert.ToInt32(objParams[40].Value);
objSpotCheck.ProgHandpay = (objParams[41].Value).ToString().GetDecimal();
objSpotCheck.GamesBet = Convert.ToInt32(objParams[42].Value);
if (Settings.IsAFTEnabledForSite)
{
objSpotCheck.CashableEFTIn = (objParams[43].Value).ToString().GetDecimal();
objSpotCheck.CashableEFTOut = (objParams[44].Value).ToString().GetDecimal();
objSpotCheck.NonCashableEFTIn = (objParams[45].Value).ToString().GetDecimal();
objSpotCheck.NonCashableEFTOut = (objParams[46].Value).ToString().GetDecimal();
objSpotCheck.WATIn = (objParams[47].Value).ToString().GetDecimal();
objSpotCheck.WATOut = (objParams[48].Value).ToString().GetDecimal();
objSpotCheck.Bill200 = (objParams[49].Value).ToString().GetDecimal();
objSpotCheck.Bill500 = (objParams[50].Value).ToString().GetDecimal();
objSpotCheck.NonCashableTicketsInserted = (objParams[51].Value).ToString().GetDecimal();
objSpotCheck.NonCashableTicketsPrinted = (objParams[52].Value).ToString().GetDecimal();
}
else
{
objSpotCheck.Bill200 = (objParams[43].Value).ToString().GetDecimal();
objSpotCheck.Bill500 = (objParams[44].Value).ToString().GetDecimal();
objSpotCheck.NonCashableTicketsInserted = (objParams[45].Value).ToString().GetDecimal();
objSpotCheck.NonCashableTicketsPrinted = (objParams[46].Value).ToString().GetDecimal();
}
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
/// <summary>
/// Create database back up in Zip format and kept in path
/// </summary>
/// <returns>int 0 -not success, 1- success, 2 - already backkup available</returns>
public int CreateSqlDatabaseBackUp(FactoryReset oFactoryResetEntity)
{
SqlConnection SqlConn = null;
ServerConnection svrConnServerConnection = null;
Server SqlSever = null;
Backup bak = null;
BackupDeviceItem bkpitem = null;
DateTime dt = DateTime.Now;
int iResult = 0;
String[] format = { "ddMMMyyyyHHmm" };
string bkpFileName = "";
string Backuppath = "";
string date = "";
string zipFileName = "";
try
{
date = dt.ToString(format[0], DateTimeFormatInfo.InvariantInfo);
Backuppath = oFactoryResetEntity.strBackupPath;
bkpFileName = Backuppath + "\\" + "[" + date + "]" + "_BAK_" + "[" +
CommonDataAccess.GetSettingValue("TICKET_LOCATION_CODE") + "]" +
"[" + BMC.Transport.Settings.SiteName + "]" + "_" +
oFactoryResetEntity.BackUpDataBase + ".BAK";
oFactoryResetEntity.strBackupFileName = bkpFileName;
if (Directory.Exists(Backuppath))
{
if (File.Exists(bkpFileName) == false)
{
try
{
SqlConn = new SqlConnection(CommonDataAccess.ExchangeConnectionString);
svrConnServerConnection = new ServerConnection(SqlConn);
SqlSever = new Server(svrConnServerConnection);
if (SqlSever != null)
{
bak = new Microsoft.SqlServer.Management.Smo.Backup();
bak.Action = BackupActionType.Database;
bkpitem = new BackupDeviceItem(bkpFileName, DeviceType.File);
bak.Devices.Add(bkpitem);
bak.Database = oFactoryResetEntity.BackUpDataBase;
bak.SqlBackup(SqlSever);
}
}
catch (SqlException sqlex)
{
ExceptionManager.Publish(sqlex);
iResult = 0;
}
catch (TimeoutException tex)
{
ExceptionManager.Publish(tex);
iResult = 0;
}
zipFileName = Backuppath + "\\" + "bkp" + oFactoryResetEntity.BackUpDataBase + date + ".ZIP";
zipFileName = Backuppath + "\\" + "[" + date + "]" + "_BAK_" + "[" +
CommonDataAccess.GetSettingValue("TICKET_LOCATION_CODE") + "]" +
"[" + BMC.Transport.Settings.SiteName + "]" + "_" +
oFactoryResetEntity.BackUpDataBase + ".ZIP";
oFactoryResetEntity.strZipFileName = zipFileName;
iResult = 1;
}
else
{
iResult = 2;
}
}
else
{
Directory.CreateDirectory(Backuppath);
try
{
SqlConn = new SqlConnection(CommonDataAccess.ExchangeConnectionString);
svrConnServerConnection = new ServerConnection(SqlConn);
SqlSever = new Server(svrConnServerConnection);
if (SqlSever != null)
{
bak = new Microsoft.SqlServer.Management.Smo.Backup();
bak.Action = BackupActionType.Database;
bkpitem = new BackupDeviceItem(bkpFileName, DeviceType.File);
bak.Devices.Add(bkpitem);
bak.Database = oFactoryResetEntity.BackUpDataBase;
bak.SqlBackup(SqlSever);
}
}
catch (SqlException sqlex)
{
ExceptionManager.Publish(sqlex);
iResult = 0;
}
catch (TimeoutException tex)
{
ExceptionManager.Publish(tex);
iResult = 0;
}
zipFileName = Backuppath + "bkp" + oFactoryResetEntity.BackUpDataBase + date + ".zip";
oFactoryResetEntity.strZipFileName = zipFileName;
iResult = 1;
}
}
catch (FileNotFoundException fex)
{
ExceptionManager.Publish(fex);
iResult = 0;
}
catch (FileLoadException flx)
{
ExceptionManager.Publish(flx);
iResult = 0;
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
iResult = 0;
}
return(iResult);
}
public string GetSetting(string strSettingName, string defaultValue)
{
return(CommonDataAccess.GetSettingValue(strSettingName, defaultValue));
}
private void GetInstallationDetailsTable()
{
CommonDataAccess commonDataAccess = new CommonDataAccess();
try
{
objInstallationDetails = CommonDataAccess.GetInstallationDetailsForHourly();
}
catch (Exception ex)
{
LogManager.WriteLog(ex.Message, LogManager.enumLogLevel.Error);
}
}
