//<summary>
//Gets the list of machines for all installations
//</summary>
//<returns>success or failure</returns>
//public DataTable FillMachines()
//{
// DataTable dtMachines = new DataTable();
// try
// {
// dtMachines = handpayDataAccess.GetInstallationList();
// }
// catch (Exception ex)
// {
// ExceptionManager.Publish(ex);
// }
// return dtMachines;
//}
//<summary>
//Save the expired or void treasury entries
//</summary>
//<returns>success or failure</returns>
public bool SaveVoidorExpiredTreasury(VoidOrExpiredTreasury ExpiredTreasury)
{
bool bStatus = false;
int iSaveStatus = handpayDataAccess.UpdateVoidorExpiredTreasury(ExpiredTreasury);
if (iSaveStatus == -1 || iSaveStatus > 0)
{
bStatus = false;
}
return(bStatus);
}
/// <summary>
/// Update Ticket Exception Table
/// </summary>
/// <param name="objExpiredTreasury">VoidOrExpiredTreasury</param>
/// <returns >int</returns>
public int UpdateVoidorExpiredTreasury(VoidOrExpiredTreasury objExpiredTreasury)
{
try
{
SqlParameter[] ObjParams = new SqlParameter[4];
ObjParams[0] = new SqlParameter(DBConstants.CONST_PARAM_TRANSACTION_TYPE, objExpiredTreasury.TransactionType);
ObjParams[1] = new SqlParameter(DBConstants.CONST_PARAM_TICKETNUMBERorID, objExpiredTreasury.TicketNumber);
ObjParams[2] = new SqlParameter(DBConstants.CONST_PARAM_TREASURYREASON, objExpiredTreasury.TreasuryReason);
ObjParams[3] = new SqlParameter("@OutVal", 0);
ObjParams[3].Direction = ParameterDirection.Output;
return(SqlHelper.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, DBConstants.CONST_SP_UPDATE_VOID_EXPIRED_TREASURY_PROC, ObjParams));
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
return(-1);
}
}
public int UpdateVoidorExpiredTreasury(VoidOrExpiredTreasury ExpiredTreasury)
{
try
{
//DataBaseServiceHandler.ConnectionString = CommonDataAccess.ExchangeConnectionString;
System.Data.SqlClient.SqlParameter outputParameter = DataBaseServiceHandler.AddParameter <int>("@OutVal", DbType.Int32, 0, ParameterDirection.InputOutput);
DataBaseServiceHandler.ExecuteNonQuery(CommonDataAccess.ExchangeConnectionString, CommandType.StoredProcedure, DBConstants.CONST_SP_UPDATE_VOID_EXPIRED_TREASURY_PROC,
DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_TRANSACTION_TYPE, DbType.String, ExpiredTreasury.TransactionType),
DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_TICKETNUMBERorID, DbType.String, ExpiredTreasury.TicketNumber),
DataBaseServiceHandler.AddParameter <string>(DBConstants.CONST_PARAM_TREASURYREASON, DbType.String, ExpiredTreasury.TreasuryReason),
outputParameter);
return(int.Parse(outputParameter.Value.ToString()));
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
return(-1);
}
public int UpdateVoidorExpiredTreasury(VoidOrExpiredTreasury ExpiredTreasuryEntity)
{
return(shortPay.UpdateVoidorExpiredTreasury(ExpiredTreasuryEntity));
}
public bool SaveVoidExpiredTreasury(VoidOrExpiredTreasury ExpiredTreasury)
{
return(handPay.SaveVoidorExpiredTreasury(ExpiredTreasury));
}
public int UpdateVoidorExpiredTreasury(VoidOrExpiredTreasury VoidTreasuryEntity)
{
return(shortPayDataAccess.UpdateVoidorExpiredTreasury(VoidTreasuryEntity));
}