public Response Drop(DropRequest Request)
{
Response oResponse = new Response();
LogManager.WriteLog("VaultService: Drop -- Entered", LogManager.enumLogLevel.Info);
try
{
StringWriter outStream = new StringWriter();
XmlSerializer s = new XmlSerializer(typeof(DropRequest));
s.Serialize(outStream, Request);
LogManager.WriteLog("VaultService: Drop Xml" + outStream.ToString(), LogManager.enumLogLevel.Info);
outStream.Close();
if (Request.EventID == 0)
{
oResponse.ErrCode = 1;
oResponse.ErrDesc = "Invalid EventID ";
}
//else if (Request.DeviceID == 0)
//{
// oResponse.ErrCode = 1;
// oResponse.ErrDesc = "Invalid DeviceID";
//}
else if (Request.DeviceName.IsNullOrEmpty())
{
oResponse.ErrCode = 2;
oResponse.ErrDesc = "Invalid Device Name";
}
else if (Request.TotalTransactionAmount < 0)
{
oResponse.ErrCode = 4;
oResponse.ErrDesc = "Invalid Amount(Must be greater than 0)";
}
else if (Request.CassetteDetails == null || Request.CassetteDetails.Count == 0)
{
oResponse.ErrCode = 5;
oResponse.ErrDesc = "cassette details not found";
}
foreach (Cassette cte in Request.CassetteDetails)
{
if (cte.CassetteName.IsNullOrEmpty())
{
oResponse.ErrCode = 6;
oResponse.ErrDesc = "Cassette name invalid.";
break;
}
if (cte.Denom == 0)
{
oResponse.ErrCode = 5;
oResponse.ErrDesc = "Cassette denom invalid.";
break;
}
//if (cte.Amount == 0)
//{
// oResponse.ErrCode = 5;
// oResponse.ErrDesc = "cassette amount invalid.";
// break;
//}
}
if (oResponse.ErrCode != 0)
{
LogManager.WriteLog("Drop Response: " + oResponse.ToString(), LogManager.enumLogLevel.Debug);
return oResponse;
}
SqlParameter[] sqlParameters = new SqlParameter[4];
sqlParameters[0] = new SqlParameter("@EventId", Request.EventID);
sqlParameters[1] = new SqlParameter("@EventDescription", "DROPWEBREQUEST");
sqlParameters[2] = new SqlParameter("@XML", outStream.ToString());
sqlParameters[3] = new SqlParameter("@Device", Request.DeviceSerialNumber);
int retval = int.Parse(SqlHelper.ExecuteScalar(GetConnectionString(), CommandType.StoredProcedure, "usp_Vault_UpdateGenericMessage", sqlParameters).ToString());
if (retval > 0)
{
LogManager.WriteLog("Drop Updated Successfully Device:" + Request.DeviceName + " Amount: " + Request.TotalTransactionAmount, LogManager.enumLogLevel.Info);
}
else
{
if (retval == -701)
{
oResponse.ErrCode = 701;
oResponse.ErrDesc = "Vault not enrolled/invalid serial number";
}
else if (retval == -702)
{
oResponse.ErrCode = 702;
oResponse.ErrDesc = "Feature not enabled";
}
else
{
oResponse.ErrCode = -100;
oResponse.ErrDesc = "Unable to process request";
}
LogManager.WriteLog("Drop Updated Failed Asset:" + Request.DeviceName + " Amount: " + Request.TotalTransactionAmount, LogManager.enumLogLevel.Info);
}
}
catch (Exception ex)
{
LogManager.WriteLog("Error in updating Drop Info", LogManager.enumLogLevel.Error);
ExceptionManager.Publish(ex);
oResponse.ErrCode = -100;
oResponse.ErrDesc = "Error Occured";
}
LogManager.WriteLog("Drop Response: " + oResponse.ToString(), LogManager.enumLogLevel.Debug);
return oResponse;
}
public Response ProcessMessages(string XMLRequest)
{
Response oResponse = new Response();
LogManager.WriteLog("VaultService: ProcessEvents -- Entered", LogManager.enumLogLevel.Info);
try
{
LogManager.WriteLog("VaultService: ProcessEvents Xml" + XMLRequest, LogManager.enumLogLevel.Info);
using (SqlConnection oConn = new SqlConnection(GetConnectionString()))
{
try
{
oConn.Open();
//if (request.DeviceID.IsNullOrEmpty())
//{
// oResponse.ErrCode = 1;
// oResponse.ErrDesc = "Invalid DeviceID";
//}
//if (request.SiteID.ToString().Length < 4)
//{
// oResponse.ErrCode = 2;
// oResponse.ErrDesc = "Invalid SiteID(Must be a integer with 4 digits)";
//}
//if (request.EventID < 1)
//{
// oResponse.ErrCode = 3;
// oResponse.ErrDesc = "Invalid EventID";
//}
//if (request.EventDescription.IsNullOrEmpty())
//{
// oResponse.ErrCode = 4;
// oResponse.ErrDesc = "Invalid EventDescription";
//}
if (oResponse.ErrCode != 0)
{
LogManager.WriteLog("ProcessMessages Response: " + oResponse.ToString(), LogManager.enumLogLevel.Debug);
return oResponse;
}
var sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter("@doc", XMLRequest);
int retval = SqlHelper.ExecuteNonQuery(oConn, CommandType.StoredProcedure, "rsp_Vault_UpdateMessagesFromXML", sqlParameters);
if (retval == 1)
{
LogManager.WriteLog("Messages Updated Successfully ", LogManager.enumLogLevel.Info);
}
else
{
LogManager.WriteLog("Messages Update Failed", LogManager.enumLogLevel.Info);
oResponse.ErrCode = -100;
oResponse.ErrDesc = "Unable to update vault messages";
}
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
oResponse.ErrCode = -100;
oResponse.ErrDesc = "Unable to update vault messages";
}
}
}
catch (Exception ex)
{
LogManager.WriteLog("Error in reading Vault Messages Info", LogManager.enumLogLevel.Error);
ExceptionManager.Publish(ex);
oResponse.ErrCode = -100;
oResponse.ErrDesc = "Error Occured";
}
return oResponse;
}
public Response ProcessVouchers(VoucherModel request)
{
Response oResponse = new Response();
LogManager.WriteLog("VaultService: ProcessVouchers -- Entered", LogManager.enumLogLevel.Info);
try
{
StringWriter outStream = new StringWriter();
XmlSerializer s = new XmlSerializer(typeof(VoucherModel));
s.Serialize(outStream, request);
LogManager.WriteLog("VaultService: Vouchers Xml" + outStream.ToString(), LogManager.enumLogLevel.Info);
outStream.Close();
if (request.BarCode.IsNullOrEmpty())
{
oResponse.ErrCode = 1;
oResponse.ErrDesc = "Invalid BarCode";
}
if (request.Amount < 1)
{
oResponse.ErrCode = 2;
oResponse.ErrDesc = "Invalid Amount(Must be greater than 0)";
}
if (request.SiteID.ToString().Length < 4)
{
oResponse.ErrCode = 3;
oResponse.ErrDesc = "Invalid SiteID(Must be a integer with 4 digits)";
}
//case -4:
// oResponse.ErrCode = 4;
// oResponse.ErrDesc = "Invalid RedeemedDateTime";
// break;
if (request.RedeemedAsset.IsNullOrEmpty())
{
oResponse.ErrCode = 5;
oResponse.ErrDesc = "Invalid Redeemed Asset";
}
if (request.PrintedAsset.IsNullOrEmpty())
{
oResponse.ErrCode = 6;
oResponse.ErrDesc = "Invalid Printed Asset";
}
//case -7:
// oResponse.ErrCode = 7;
// oResponse.ErrDesc = "Invalid PrintedDateTime";
// break;
//case -8:
// oResponse.ErrCode = 8;
// oResponse.ErrDesc = "Invalid ExpiryDate";
// break;
if (request.Type.GetType() != typeof(VoucherTypeModel))
{
oResponse.ErrCode = 9;
oResponse.ErrDesc = "Invalid Type";
}
//case -10:
// oResponse.ErrCode = 10;
// oResponse.ErrDesc = "Duplicate Entry";
// break;
if (oResponse.ErrCode != 0)
{
LogManager.WriteLog("ProcessVouchers Response: " + oResponse.ToString(), LogManager.enumLogLevel.Debug);
return oResponse;
}
//var sqlParameters = new SqlParameter[9];
//sqlParameters[0] = new SqlParameter("@BarCode", request.BarCode);
//sqlParameters[1] = new SqlParameter("@Amount", request.Amount);
//sqlParameters[2] = new SqlParameter("@SiteID", request.SiteID);
//sqlParameters[3] = new SqlParameter("@PaidDateTime", request.RedeemedDateTime);
//sqlParameters[4] = new SqlParameter("@RedeemedAsset", request.RedeemedAsset);
//sqlParameters[5] = new SqlParameter("@PrintedAsset", request.PrintedAsset);
//sqlParameters[6] = new SqlParameter("@PrintedDateTime", request.PrintedDateTime);
//sqlParameters[7] = new SqlParameter("@ExpiryDate", request.ExpiryDate);
//sqlParameters[8] = new SqlParameter("@Ticket_Type", request.Type);
var sqlParameters = new SqlParameter[4];
sqlParameters[0] = new SqlParameter("@EventId", (int)request.Type);
sqlParameters[1] = new SqlParameter("@EventDescription", request.Type.ToString().ToUpper());
sqlParameters[2] = new SqlParameter("@XML", outStream.ToString());
sqlParameters[3] = new SqlParameter("@Device", request.RedeemedAsset);
int retval = int.Parse(SqlHelper.ExecuteScalar(GetConnectionString(), CommandType.StoredProcedure, "usp_Vault_UpdateGenericMessage", sqlParameters).ToString());
//if (SqlHelper.ExecuteNonQuery(GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateVoucherInfo", sqlParameters) < 0)
if (retval == 1)
{
LogManager.WriteLog("Voucher Updated Successfully BarCode:" + request.BarCode + " Amount: " + request.Amount, LogManager.enumLogLevel.Info);
}
else
{
LogManager.WriteLog("Unable to update Voucher:" + request.BarCode + " Amount: " + request.Amount, LogManager.enumLogLevel.Error);
if (retval == -701)
{
oResponse.ErrCode = 701;
oResponse.ErrDesc = "Vault not enrolled/invalid serial number";
}
else if (retval == -702)
{
oResponse.ErrCode = 702;
oResponse.ErrDesc = "Feature not enabled";
}
else
{
oResponse.ErrCode = -100;
oResponse.ErrDesc = "Unable to process request";
}
}
LogManager.WriteLog("ProcessVouchers Response: " + oResponse.ToString(), LogManager.enumLogLevel.Debug);
}
catch (Exception ex)
{
LogManager.WriteLog("Error in reading Voucher Info", LogManager.enumLogLevel.Error);
ExceptionManager.Publish(ex);
oResponse.ErrCode = -100;
oResponse.ErrDesc = "Error Occured";
}
return oResponse; ;
}
public Response ProcessEvents(EventModel request)
{
Response oResponse = new Response();
LogManager.WriteLog("VaultService: ProcessEvents -- Entered", LogManager.enumLogLevel.Info);
try
{
StringWriter outStream = new StringWriter();
XmlSerializer s = new XmlSerializer(typeof(EventModel));
s.Serialize(outStream, request);
string xml = outStream.ToString();
LogManager.WriteLog("VaultService: ProcessEvents Xml" + xml.ToString(), LogManager.enumLogLevel.Info);
outStream.Close();
using (SqlConnection oConn = new SqlConnection(GetConnectionString()))
{
try
{
oConn.Open();
if (request.DeviceID.IsNullOrEmpty())
{
oResponse.ErrCode = 1;
oResponse.ErrDesc = "Invalid DeviceID";
}
if (request.SiteID.ToString().Length < 4)
{
oResponse.ErrCode = 2;
oResponse.ErrDesc = "Invalid SiteID(Must be a integer with 4 digits)";
}
if (request.EventID < 1)
{
oResponse.ErrCode = 3;
oResponse.ErrDesc = "Invalid EventID";
}
if (request.EventDescription.IsNullOrEmpty())
{
oResponse.ErrCode = 4;
oResponse.ErrDesc = "Invalid EventDescription";
}
foreach (CassetteDetails cd in request.CassetteDetail)
{
if (cd.CassetteNumber.IsNullOrEmpty())
{
oResponse.ErrCode = 6;
oResponse.ErrDesc = "Invalid CassetteNumber";
break;
}
if (cd.CassetteLevel < 0)
{
oResponse.ErrCode = 7;
oResponse.ErrDesc = "Invalid CassetteLevel";
break;
}
if (cd.CassetteDenom < 1)
{
oResponse.ErrCode = 8;
oResponse.ErrDesc = "Invalid CassetteDenom";
break;
}
if (decimal.Parse( cd.CassetteLevel.ToString()) %decimal.Parse( cd.CassetteDenom.ToString()) > 0 )
{
oResponse.ErrCode = 8;
oResponse.ErrDesc = "Amount did not match CassetteDenom";
break;
}
if (cd.CassetteDescription.IsNullOrEmpty())
{
oResponse.ErrCode = 9;
oResponse.ErrDesc = "Invalid CassetteDescription";
break;
}
}
if (oResponse.ErrCode != 0)
{
LogManager.WriteLog("ProcessEvents Response: " + oResponse.ToString(), LogManager.enumLogLevel.Debug);
return oResponse;
}
//var sqlParameters = new SqlParameter[7];
//sqlParameters[0] = new SqlParameter("@DeviceID", request.DeviceID);
//sqlParameters[1] = new SqlParameter("@SiteID", request.SiteID);
//sqlParameters[2] = new SqlParameter("@EventID", request.EventID);
//sqlParameters[3] = new SqlParameter("@EventDescription", request.EventDescription);
//sqlParameters[4] = new SqlParameter("@EventDateTime", request.EventDateTime);
//sqlParameters[5] = new SqlParameter("@VaultEventID", SqlDbType.Int);
//sqlParameters[5].Direction = ParameterDirection.Output;
//sqlParameters[6] = new SqlParameter("@xml", xml);
//DataSet dtVaultEvent = SqlHelper.ExecuteDataset(oConn, CommandType.StoredProcedure, "usp_UpdateEventsInfo", sqlParameters);
var sqlParameters = new SqlParameter[4];
sqlParameters[0] = new SqlParameter("@EventId", request.EventID);
sqlParameters[1] = new SqlParameter("@EventDescription", request.EventDescription);
sqlParameters[2] = new SqlParameter("@XML", outStream.ToString());
sqlParameters[3] = new SqlParameter("@Device", request.DeviceID);
int retval = int.Parse(SqlHelper.ExecuteScalar(GetConnectionString(), CommandType.StoredProcedure, "usp_Vault_UpdateGenericMessage", sqlParameters).ToString());
if (retval == 1)
{
LogManager.WriteLog("Event Updated Successfully eventID:" + request.EventID, LogManager.enumLogLevel.Info);
}
else
{
LogManager.WriteLog("Event Update failed for eventID:" + request.EventID, LogManager.enumLogLevel.Info);
if (retval == -701)
{
oResponse.ErrCode = 701;
oResponse.ErrDesc = "Vault not enrolled/invalid serial number";
}
else if (retval == -702)
{
oResponse.ErrCode = 702;
oResponse.ErrDesc = "Feature not enabled";
}
else
{
oResponse.ErrCode = -100;
oResponse.ErrDesc = "Unable to process request";
}
}
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
}
}
catch (Exception ex)
{
LogManager.WriteLog("Error in reading Event Info", LogManager.enumLogLevel.Error);
ExceptionManager.Publish(ex);
oResponse.ErrCode = -100;
oResponse.ErrDesc = "Error Occured";
}
LogManager.WriteLog("ProcessEvents Response: " + oResponse.ToString(), LogManager.enumLogLevel.Debug);
return oResponse;
}
public Response ProcessHandpays(HandpayModel request)
{
Response oResponse = new Response();
LogManager.WriteLog("VaultService: ProcessHandpays -- Entered", LogManager.enumLogLevel.Info);
try
{
StringWriter outStream = new StringWriter();
XmlSerializer s = new XmlSerializer(typeof(HandpayModel));
s.Serialize(outStream, request);
LogManager.WriteLog("VaultService: Handpays Xml" + outStream.ToString(), LogManager.enumLogLevel.Info);
outStream.Close();
if (request.Asset.IsNullOrEmpty())
{
oResponse.ErrCode = 1;
oResponse.ErrDesc = "Invalid Asset";
}
if (request.RedeemedAsset.IsNullOrEmpty())
{
oResponse.ErrCode = 2;
oResponse.ErrDesc = "Invalid Redeemed Asset";
}
if (request.SiteID.ToString().Length < 4)
{
oResponse.ErrCode = 3;
oResponse.ErrDesc = "Invalid SiteID(Must be a integer with 4 digits)";
}
if (request.Amount < 1)
{
oResponse.ErrCode = 4;
oResponse.ErrDesc = "Invalid Amount(Must be greater than 0)";
}
if (request.Type.GetType() != typeof(HandpayTypeModel))
{
oResponse.ErrCode = 7;
oResponse.ErrDesc = "Invalid Type";
}
//case -5:
// oResponse.ErrCode = 5;
// oResponse.ErrDesc = "Invalid RedeemDateTime";
// break;
//case -6:
// oResponse.ErrCode = 6;
// oResponse.ErrDesc = "Invalid GeneratedDateTime";
// break;
if (oResponse.ErrCode != 0)
{
LogManager.WriteLog("ProcessHandpays Response: " + oResponse.ToString(), LogManager.enumLogLevel.Debug);
return oResponse;
}
var sqlParameters = new SqlParameter[4];
sqlParameters[0] = new SqlParameter("@EventId", (int)request.Type);
sqlParameters[1] = new SqlParameter("@EventDescription", request.Type.ToString().ToUpper());
sqlParameters[2] = new SqlParameter("@XML", outStream.ToString());
sqlParameters[3] = new SqlParameter("@Device", request.RedeemedAsset);
int retval = int.Parse( SqlHelper.ExecuteScalar(GetConnectionString(), CommandType.StoredProcedure, "usp_Vault_UpdateGenericMessage", sqlParameters).ToString());
//var sqlParameters = new SqlParameter[7];
//sqlParameters[0] = new SqlParameter("@Asset", request.Asset);
//sqlParameters[1] = new SqlParameter("@RedeemedAsset", request.RedeemedAsset);
//sqlParameters[2] = new SqlParameter("@SiteID", request.SiteID);
//sqlParameters[3] = new SqlParameter("@Amount", request.Amount);
//sqlParameters[4] = new SqlParameter("@RedeemDateTime", request.RedeemDateTime);
//sqlParameters[5] = new SqlParameter("@GeneratedDateTime", request.GeneratedDateTime);
//sqlParameters[6] = new SqlParameter("@Type", request.Type);
//int iStatus = int.Parse(SqlHelper.ExecuteScalar(GetConnectionString(), CommandType.StoredProcedure, "usp_UpdateHandpayInfo", sqlParameters).ToString());
//if (iStatus == -1)
//{
// oResponse.ErrCode = 1;
// oResponse.ErrDesc = "Invalid Asset";
//}
//if (iStatus == 0)
//{
// LogManager.WriteLog("Handpay Updated Successfully Asset:" + request.Asset + " Amount: " + request.Amount, LogManager.enumLogLevel.Info);
//}
if (retval == 1)
{
LogManager.WriteLog("Handpay Updated Successfully Asset:" + request.Asset + " Amount: " + request.Amount, LogManager.enumLogLevel.Info);
}
else
{
LogManager.WriteLog("Handpay Updated Failed Asset:" + request.Asset + " Amount: " + request.Amount, LogManager.enumLogLevel.Info);
if (retval == -701)
{
oResponse.ErrCode = 701;
oResponse.ErrDesc = "Vault not enrolled/invalid serial number";
}
else if (retval == -702)
{
oResponse.ErrCode = 702;
oResponse.ErrDesc = "Feature not enabled";
}
else
{
oResponse.ErrCode = -100;
oResponse.ErrDesc = "Unable to process request";
}
}
}
catch (Exception ex)
{
LogManager.WriteLog("Error in reading Handpay Info", LogManager.enumLogLevel.Error);
ExceptionManager.Publish(ex);
oResponse.ErrCode = -100;
oResponse.ErrDesc = "Error Occured";
}
LogManager.WriteLog("ProcessHandpays Response: " + oResponse.ToString(), LogManager.enumLogLevel.Debug);
return oResponse;
}
