public ReedeemTicketDetailsComms RedeemTicketCompleteComms(ReedeemTicketDetailsComms TicketDetailComms)
{
//Add additional parameter to update clientsitecode from client
try
{
SqlParameter[] oSQLParams = new SqlParameter[5];
SqlParameter objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "Barcode";
objSQLParam.Value = TicketDetailComms.Barcode;
objSQLParam.Direction = ParameterDirection.Input;
oSQLParams[0] = objSQLParam;
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "DeviceID";
objSQLParam.Value = TicketDetailComms.DeviceId;
objSQLParam.Direction = ParameterDirection.Input;
oSQLParams[1] = objSQLParam;
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "retResult";
objSQLParam.Direction = ParameterDirection.Output;
objSQLParam.SqlDbType = SqlDbType.Int;
oSQLParams[2] = objSQLParam;
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "iVoucherID";
objSQLParam.Direction = ParameterDirection.Output;
objSQLParam.SqlDbType = SqlDbType.Int;
oSQLParams[3] = objSQLParam;
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "iClientSiteCode";
objSQLParam.Value = TicketDetailComms.ClientSiteCode;
objSQLParam.Direction = ParameterDirection.Input;
objSQLParam.SqlDbType = SqlDbType.VarChar;
oSQLParams[4] = objSQLParam;
SqlHelper.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, "esp_RedeemTicketComplete", oSQLParams);
LogManager.WriteLog("<CrossTicketing> esp_RedeemTicketComplete after SP CALL", LogManager.enumLogLevel.Info);
int nResult, nVoucherid;
bool bResult = int.TryParse(Convert.ToString(oSQLParams[2].Value),out nResult);
bResult= int.TryParse(Convert.ToString(oSQLParams[3].Value), out nVoucherid);
TicketDetailComms.retResult = nResult;
TicketDetailComms.iVoucherid = nVoucherid;
LogManager.WriteLog("<CrossTicketing> esp_RedeemTicketComplete returns: " + TicketDetailComms.retResult.ToString() + " | nVoucherid" + nVoucherid.ToString(), LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return TicketDetailComms;
}
public ReedeemTicketDetailsComms RedeemTicketCancelComms(ReedeemTicketDetailsComms TicketDetailComms)
{
try
{
SqlParameter[] oSQLParams = new SqlParameter[5];
SqlParameter objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "Barcode";
objSQLParam.Value = TicketDetailComms.Barcode;
objSQLParam.Direction = ParameterDirection.Input;
oSQLParams[0] = objSQLParam;
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "DeviceID";
objSQLParam.Value = TicketDetailComms.DeviceId;
objSQLParam.Direction = ParameterDirection.Input;
oSQLParams[1] = objSQLParam;
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "iError_Code";
objSQLParam.Value = TicketDetailComms.iErrorCode;
objSQLParam.Direction = ParameterDirection.Input;
objSQLParam.SqlDbType = SqlDbType.Int;
oSQLParams[2] = objSQLParam;
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "retResult";
objSQLParam.Direction = ParameterDirection.Output;
objSQLParam.SqlDbType = SqlDbType.Int;
oSQLParams[3] = objSQLParam;
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "iClientSiteCode";
objSQLParam.Value = TicketDetailComms.ClientSiteCode;
objSQLParam.Direction = ParameterDirection.Input;
objSQLParam.SqlDbType = SqlDbType.VarChar;
oSQLParams[4] = objSQLParam;
SqlHelper.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, "esp_RedeemTicketCancel", oSQLParams);
TicketDetailComms.retResult = int.Parse(oSQLParams[3].Value.ToString());
LogManager.WriteLog("<CrossTicketing> esp_RedeemTicketCancel returns: " + TicketDetailComms.retResult.ToString(), LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return TicketDetailComms;
}
public ReedeemTicketDetailsComms RedeemTicketStartComms(ReedeemTicketDetailsComms TicketDetailComms)
{
try
{
SqlParameter[] oSQLParams = new SqlParameter[7];
SqlParameter objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "Barcode";
objSQLParam.Value = TicketDetailComms.Barcode;
objSQLParam.Direction = ParameterDirection.Input;
oSQLParams[0] = objSQLParam;
LogManager.WriteLog("<CrossTicketing> Esp_redeemticketstart Barcode: " + TicketDetailComms.Barcode, LogManager.enumLogLevel.Info);
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "DeviceID";
objSQLParam.Value = TicketDetailComms.DeviceId;
objSQLParam.Direction = ParameterDirection.Input;
oSQLParams[1] = objSQLParam;
LogManager.WriteLog("<CrossTicketing> Esp_redeemticketstart DeviceID: " + TicketDetailComms.DeviceId, LogManager.enumLogLevel.Info);
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "ClSiteCode";
objSQLParam.Value = TicketDetailComms.ClientSiteCode;
objSQLParam.Direction = ParameterDirection.Input;
oSQLParams[2] = objSQLParam;
LogManager.WriteLog("<CrossTicketing> Esp_redeemticketstart ClSiteCode: " + TicketDetailComms.ClientSiteCode, LogManager.enumLogLevel.Info);
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "retAmount";
objSQLParam.Value = TicketDetailComms.retAmount;
objSQLParam.Direction = ParameterDirection.Output;
objSQLParam.SqlDbType = SqlDbType.Int;
oSQLParams[3] = objSQLParam;
LogManager.WriteLog("<CrossTicketing> Esp_redeemticketstart retAmount: " + TicketDetailComms.retAmount, LogManager.enumLogLevel.Info);
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "retResult";
objSQLParam.Direction = ParameterDirection.Output;
objSQLParam.SqlDbType = SqlDbType.Int;
oSQLParams[4] = objSQLParam;
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "retBarcode";
objSQLParam.Value = string.Empty;
objSQLParam.Direction = ParameterDirection.Output;
objSQLParam.SqlDbType = SqlDbType.VarChar;
oSQLParams[5] = objSQLParam;
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "retTicketType";
objSQLParam.Direction = ParameterDirection.Output;
objSQLParam.SqlDbType = SqlDbType.Int;
oSQLParams[6] = objSQLParam;
SqlHelper.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, "Esp_redeemticketstart", oSQLParams);
bool bResult;
int nretAmount, nretResult, nretTicketType;
bResult = int.TryParse(Convert.ToString(oSQLParams[3].Value), out nretAmount);
LogManager.WriteLog("<CrossTicketing> Esp_redeemticketstart returns nretAmount: " + nretAmount.ToString(), LogManager.enumLogLevel.Info);
bResult = int.TryParse(Convert.ToString(oSQLParams[4].Value), out nretResult);
LogManager.WriteLog("<CrossTicketing> Esp_redeemticketstart returns nretResult: " + nretResult.ToString(), LogManager.enumLogLevel.Info);
TicketDetailComms.retAmount= nretAmount;
TicketDetailComms.retResult = nretResult;
//TicketDetailComms.retBarcode = Convert.ToString(oSQLParams[5].Value);
//LogManager.WriteLog("<CrossTicketing> Esp_redeemticketstart returns retBarcode: " + TicketDetailComms.retBarcode, LogManager.enumLogLevel.Info);
//TicketDetailComms.retTicketType = int.Parse(oSQLParams[6].Value.ToString());
bResult = int.TryParse(Convert.ToString(oSQLParams[6].Value), out nretTicketType);
TicketDetailComms.retTicketType = bResult ? nretTicketType : 0;
LogManager.WriteLog("<CrossTicketing> Esp_redeemticketstart returns retTicketType: " + TicketDetailComms.retTicketType, LogManager.enumLogLevel.Info);
LogManager.WriteLog("<CrossTicketing> Esp_redeemticketstart returns: " + TicketDetailComms.retResult.ToString(), LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return TicketDetailComms;
}
public bool ImportVoucherDetailsComms(ReedeemTicketDetailsComms TicketDetail)
{
bool bSuccess = false;
try
{
SqlParameter[] oSQLParams = new SqlParameter[4];
SqlParameter objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "doc";
objSQLParam.Value = TicketDetail.VoucherXMLData;
objSQLParam.Direction = ParameterDirection.Input;
oSQLParams[0] = objSQLParam;
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "DeviceName";
objSQLParam.Value = TicketDetail.DeviceId;
objSQLParam.Direction = ParameterDirection.Input;
oSQLParams[1] = objSQLParam;
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "RedeemUserName";
objSQLParam.Value = "";
objSQLParam.Direction = ParameterDirection.Input;
oSQLParams[2] = objSQLParam;
objSQLParam = new SqlParameter();
objSQLParam.ParameterName = "IsSuccess";
objSQLParam.Direction = ParameterDirection.Output;
objSQLParam.SqlDbType = SqlDbType.Int;
oSQLParams[3] = objSQLParam;
SqlHelper.ExecuteNonQuery(CommonDataAccess.TicketingConnectionString, CommandType.StoredProcedure, "RSP_IMPORTVOUCHERDETAILS", oSQLParams);
if (int.Parse(oSQLParams[3].Value.ToString()) == 0)
{
bSuccess = true;
LogManager.WriteLog("<CrossTicketing> ImportVoucherDetails Call Success", LogManager.enumLogLevel.Info);
}
else
{
bSuccess = false;
LogManager.WriteLog("<CrossTicketing> ImportVoucherDetails Call " + " failed due to " + oSQLParams[1].Value.ToString(), LogManager.enumLogLevel.Info);
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
bSuccess = false;
}
return bSuccess;
}
public bool ImportVoucherDetailsComms(ReedeemTicketDetailsComms objReedeemTicketDetailsComms)
{
return redeemTicketDB.ImportVoucherDetailsComms(objReedeemTicketDetailsComms);
}
public ReedeemTicketDetailsComms RedeemTicketCancelComms(ReedeemTicketDetailsComms TicketDetailComms)
{
return redeemTicketDB.RedeemTicketCancelComms(TicketDetailComms);
}
public ReedeemTicketDetailsComms RedeemTicketStartComms(ReedeemTicketDetailsComms TicketDetailComms)
{
return redeemTicket.RedeemTicketStartComms(TicketDetailComms);
}