public void AddTrans(TransactionsViewModel transviewmodel)
{
try
{
tbl_Transactions tbltrans = new tbl_Transactions();
tbltrans.HighLevelTxnID = transviewmodel.HighLevelTxnID;
tbltrans.HighLevelTxnDesc = transviewmodel.HighLevelTxnDesc;
tbltrans.LifeCycleID = transviewmodel.LifeCycleID;
if (transviewmodel.ReqReference != null)
{
tbltrans.ReqReference = transviewmodel.ReqReference;
}
tbltrans.daId = transviewmodel.daId;
tbltrans.EntityState = DA.DomainModel.EntityState.Added;
TransactionsManager transmanager = new TransactionsManager();
transmanager.AddTransaction(tbltrans);
}
catch (Exception)
{
throw;
}
}
public void UpdateTransaction(tbl_Transactions tblTransactions)
{
try
{
IGenericDataRepository <tbl_Transactions> repository = new GenericDataRepository <tbl_Transactions>();
repository.Update(tblTransactions);
}
catch (Exception)
{
throw;
}
}
public tbl_Transactions FindTransaction(int?TransactionSeq)
{
try
{
IGenericDataRepository <tbl_Transactions> repository = new GenericDataRepository <tbl_Transactions>();
tbl_Transactions tblTransactions = repository.GetSingle(b => b.TransactionSeq == TransactionSeq);
return(tblTransactions);
}
catch (Exception)
{
throw;
}
}
public ResponseMessage LogBetRequest(Transactions transactions)
{
var recID = 0;
var ResponseMsg = new ResponseMessage();
log.Info("Request with ID" + transactions.TicketNo + "got here");
try
{
transactions.ReferenceNo = GenerateReferenceNo(transactions);
//check request already logged
var doccheck = CheckIfRequestAlreadySubmit(transactions);
if (!string.IsNullOrEmpty(doccheck))
{
ResponseMsg.ResponseCode = "03";
ResponseMsg.ResponseDetails = "Request already logged with reference number" + doccheck;
ResponseMsg.ResponseID = recID.ToString();
}
else
{
// do insertion
var transaction = new tbl_Transactions
{
ReferenceNo = transactions.ReferenceNo,
CompanyName = transactions.CompanyName,
Amount = transactions.Amount,
CompanyID = transactions.CompanyID,
GameName = transactions.GameName,
GameType = transactions.GameType,
TotalAmt = transactions.TotalAmt,
AmountRemmitted = transactions.AmountRemmitted,
TicketNo = transactions.TicketNo,
TransactionDate = transactions.TransactionDate,
Audit = "Request logged",
DateLogged = DateTime.Now
};
db.tbl_Transactions.Add(transaction);
recID = db.SaveChanges();
ResponseMsg.ResponseCode = "00";
ResponseMsg.ResponseDetails = "Request logged successfully.";
ResponseMsg.ResponseID = transaction.ReferenceNo;
}
}
catch (Exception ex)
{
ResponseMsg.ResponseCode = "X01";
ResponseMsg.ResponseDetails = "Error Occurred. Please try again later.";
ResponseMsg.ResponseID = recID.ToString();
log.Error(ex);
}
return(ResponseMsg);
}
public tbl_Transactions FindReqRefAndHLT(string temp, int?daid)
{
try
{
IGenericDataRepository <tbl_Transactions> repository = new GenericDataRepository <tbl_Transactions>();
tbl_Transactions tblTransactions = repository.GetSingle(a => a.HighLevelTxnID == temp && a.daId == daid);
return(tblTransactions);
}
catch (Exception)
{
throw;
}
}
public tbl_Transactions FindHLTransaction(string highLevelTransactionId, int lifeCycleId, string highLevelTransactionDesc, string reqRef, int daid)
//, int lifeCycleId, string highLevelTransactionDesc, string reqRef
{
try
{
IGenericDataRepository <tbl_Transactions> repository = new GenericDataRepository <tbl_Transactions>();
tbl_Transactions tblTransactions = repository.GetSingle(b => b.HighLevelTxnID.ToUpper() == highLevelTransactionId.ToUpper() && b.LifeCycleID == lifeCycleId &&
b.HighLevelTxnDesc.ToUpper() == highLevelTransactionDesc.ToUpper() && b.ReqReference.ToUpper() == reqRef.ToUpper());
//tbl_Transactions tblTransactions = repository.GetSingle(b => b.HighLevelTxnID.ToUpper() == highLevelTransactionId.ToUpper() && b.daId == daid);
return(tblTransactions);
}
catch (Exception)
{
throw;
}
}
public bool DeleteTrans(TransactionsViewModel transviewmodel)
{
try
{
tbl_Transactions tbltrans = new tbl_Transactions();
tbltrans.TransactionSeq = transviewmodel.TransactionSeq;
tbltrans.EntityState = DA.DomainModel.EntityState.Deleted;
TransactionsManager transmanager = new TransactionsManager();
transmanager.DeleteTransaction(tbltrans);
return(true);
}
catch (Exception)
{
throw;
}
}
public void UpdateTrans(TransactionsViewModel transviewmodel)
{
try
{
tbl_Transactions tbltrans = new tbl_Transactions();
tbltrans.TransactionSeq = transviewmodel.TransactionSeq;
tbltrans.HighLevelTxnID = transviewmodel.HighLevelTxnID;
tbltrans.HighLevelTxnDesc = transviewmodel.HighLevelTxnDesc;
tbltrans.LifeCycleID = transviewmodel.LifeCycleID;
tbltrans.ReqReference = transviewmodel.ReqReference;
tbltrans.daId = transviewmodel.daId; //1
tbltrans.EntityState = DA.DomainModel.EntityState.Modified;
TransactionsManager transmanager = new TransactionsManager();
transmanager.UpdateTransaction(tbltrans);
}
catch (Exception)
{
throw;
}
}
