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; } }