public bool InsertGloryOpenSessDetails(GloryCashDetails gcd, ref int Seqid)
{
bool retVal = true;
try
{
SqlParameter[] ObjParams = new SqlParameter[13];
ObjParams[0] = new SqlParameter(DBConstants.CONST_PARAM_TRANSACTION_TYPE, gcd.TransactionType);
ObjParams[1] = new SqlParameter(DBConstants.CONST_PARAM_TRANSACTIONSTARTTIME, gcd.TransactionStarttime);
ObjParams[2] = new SqlParameter(DBConstants.CONST_PARAM_TRANSACTIONENDTIME, gcd.TransactionEndtime);
ObjParams[3] = new SqlParameter(DBConstants.CONST_PARAM_TRANSACTIONAMOUNT, gcd.TransactionAmount);
ObjParams[4] = new SqlParameter(DBConstants.CONST_PARAM_TICKETNO, gcd.TicketNo);
ObjParams[5] = new SqlParameter(DBConstants.CONST_PARAM_VALIDATIONNO, gcd.ValidationNo);
ObjParams[6] = new SqlParameter(DBConstants.CONST_PARAM_ASSETNO, gcd.AssetNo);
ObjParams[7] = new SqlParameter(DBConstants.CONST_PARAM_USERID, gcd.UserID);
ObjParams[8] = new SqlParameter(DBConstants.CONST_PARAM_SESSIONID, gcd.SessionID);
ObjParams[9] = new SqlParameter(DBConstants.CONST_PARAM_DEVICE, gcd.Device);
ObjParams[10] = new SqlParameter(DBConstants.CONST_PARAM_STATUS, gcd.Status);
ObjParams[11] = new SqlParameter(DBConstants.CONST_PARAM_ERRORCODE, gcd.ErrorCode);
ObjParams[12] = new SqlParameter
{
ParameterName = DBConstants.CONST_PARAM_SEQID,
Value = 0,
Direction = ParameterDirection.Output
};
Seqid = Convert.ToInt32(SqlHelper.ExecuteScalar(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONSTANT_SP_USP_INSERT_GLORYCDDETAILS, ObjParams));
if (Seqid < 0)
{
retVal = false;
}
else
{
Seqid = Convert.ToInt32(ObjParams[12].Value);
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
retVal = false;
}
return retVal;
}
public bool UpdateGloryDetails(GloryCashDetails gcd)
{
bool retVal = true;
try
{
SqlParameter[] ObjParams = new SqlParameter[3];
ObjParams[0] = new SqlParameter(DBConstants.CONST_PARAM_SEQID, gcd.Sequenceid);
ObjParams[1] = new SqlParameter(DBConstants.CONST_PARAM_STATUS, gcd.Status);
ObjParams[2] = new SqlParameter(DBConstants.CONST_PARAM_ERRORCODE, gcd.ErrorCode);
int Val = SqlHelper.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONSTANT_SP_USP_UPDATE_GLORYCDDETAILS, ObjParams);
if (Val < 0)
{
retVal = false;
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
retVal = false;
}
return retVal;
}
private bool AuditCloseSessionGloryDetails(bool IsSuccess, string ErrorCode)
{
bool retVal = true;
try
{
if (_cOut != null)
{
GloryCashDetails gCash = new GloryCashDetails();
gCash.AssetNo = _cOut.AssetNo;
gCash.Device = UserInformation.Device;
gCash.ErrorCode = ErrorCode.Equals("") ? null : ErrorCode;
gCash.SessionID = UserInformation.SessionID;
gCash.Status = IsSuccess ? '1' : '0';
gCash.TicketNo = _cOut.ValidationNo;
gCash.TransactionAmount = _cOut.Amount;
gCash.TransactionStarttime = DateTime.Now;
gCash.TransactionEndtime = null;
gCash.TransactionType = _cType.ToString();
gCash.UserID = UserInformation.ID;
gCash.Sequenceid = UserInformation.SeqID;
GloryCashDispDataAccess GDB = new GloryCashDispDataAccess();
if (GDB.UpdateGloryDetails(gCash))
{
LogManager.WriteLog(DispenserType + "Close Session Glory Details Inserted Succeesful", LogManager.enumLogLevel.Info);
}
else
{
retVal = false;
LogManager.WriteLog(DispenserType + "Close Session Glory Details Failed to Insert", LogManager.enumLogLevel.Info);
}
// InsertGloryOpenSessDetails
}
}
catch (Exception ex)
{
retVal = false;
ExceptionManager.Publish(ex);
}
return retVal;
}