public Guid Create(Model.Transaction transEntity)
{
var context = new CMS_DataContext();
var trans = new DataAccess.Transaction()
{
Id = transEntity.Id,
Reference = transEntity.Reference,
Notes = transEntity.Notes,
CreditAccountId = transEntity.CreditAccount.Id,
DebitAccountId = transEntity.DebitAccount.Id,
Amount = transEntity.Amount,
Date = DateTime.Parse(transEntity.Date)
};
try
{
context.Transactions.InsertOnSubmit(trans);
context.SubmitChanges();
}
catch (Exception ex)
{ throw ex; }
return(transEntity.Id);
}
public static bool GenerateReportBug(long idBug)
{
DBO.BugReport bugreport = new DBO.BugReport();
DataAccess.Bug bug = new DataAccess.Bug();
DataAccess.T_Bug b = bug.GetBug(idBug);
List<DataAccess.T_Bug> li = bug.GetListBug();
DataAccess.Comment com = new DataAccess.Comment();
DataAccess.Transaction trans = new DataAccess.Transaction();
List<DataAccess.T_Transaction> lt = trans.GetListTransaction();
bugreport.Title = b.title;
bugreport.Comment = com.getListCommentbyIdbug(idBug);
foreach (DataAccess.T_Transaction item in lt)
{
if (item.T_Bug.id == idBug)
{
bugreport.Statut = item.statut;
bugreport.Responsable = item.T_User.name + ' ' + item.T_User.firstname;
break;
}
}
return (DataAccess.GenerateDocx.GenerateReportBug(bugreport) != null);
}
public bool UpdateStaffPotentialAssessmentByAppraisalHeaderId(long staffPotentialAssessmentId, long appraisalHeaderId, int potentialAssessmentPeriodId, short score, DataAccess.Transaction transaction)
{
try
{
//Make parameter(s)
ArrayList param = new ArrayList();
param.Add(MakeParam(PARAM_STAFF_POTENTIAL_ASSESSMENT_ID_NAME, PARAM_STAFF_POTENTIAL_ASSESSMENT_ID_TYPE, PARAM_STAFF_POTENTIAL_ASSESSMENT_ID_SIZE, staffPotentialAssessmentId));
param.Add(MakeParam(PARAM_APPRAISAL_HEADER_ID_NAME, PARAM_APPRAISAL_HEADER_ID_TYPE, PARAM_APPRAISAL_HEADER_ID_SIZE, appraisalHeaderId));
param.Add(MakeParam(PARAM_POTENTIAL_ASSESSMENT_PERIOD_ID_NAME, PARAM_POTENTIAL_ASSESSMENT_PERIOD_ID_TYPE, PARAM_POTENTIAL_ASSESSMENT_PERIOD_ID_SIZE, potentialAssessmentPeriodId));
param.Add(MakeParam(PARAM_SCORE_NAME, PARAM_SCORE_TYPE, PARAM_SCORE_SIZE, score));
//Execute Stored Procedure
if (ExecuteProc(STP_STAFF_POTENTIAL_ASSESSMENT_UPDATESTAFF_POTENTIAL_ASSESSMENTBYSTAFF_POTENTIAL_ASSESSMENT_ID, param, transaction) == 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public bool UpdateTransaction(DataAccess.T_Transaction transaction)
{
DataAccess.Transaction trans = new DataAccess.Transaction();
return trans.UpdateTransaction(transaction);
}
public DataAccess.T_Transaction GetTransaction(long id)
{
DataAccess.Transaction trans = new DataAccess.Transaction();
return trans.GetTransaction(id);
}
public List<DataAccess.T_Transaction> GetListTransaction()
{
DataAccess.Transaction trans = new DataAccess.Transaction();
return trans.GetListTransaction();
}
public bool DeleteTransaction(long id)
{
DataAccess.Transaction trans = new DataAccess.Transaction();
return trans.DeleteTransaction(id);
}
public bool CreateTransaction(DataAccess.T_Transaction transaction, long idBug, long idUser)
{
DataAccess.Transaction trans = new DataAccess.Transaction();
return trans.CreateTransaction(transaction, idBug, idUser);
}
public IHttpActionResult GetTransfer(string id, string merchantid, double amount, string reference, string currency)
{
// double amount = 12;
//string reference = "testrransfer";
DataAccess.User user;
DataAccess.Merchant merchant;
// Retrieve User and Merchant account id's from database
using (DataAccess.CodeDuoTestEntities entities = new DataAccess.CodeDuoTestEntities())
{
int idint = int.Parse(id);
int merchid = int.Parse(merchantid);
user = entities.Users.FirstOrDefault(e => e.Id == idint);
merchant = entities.Merchants.FirstOrDefault(m => m.Id == merchid);
}
string fromaccountid = user.AccountId; //"e863600a86656f979d646e83";
string toaccountid = merchant.AccountId; //"e863600a86656f979d646e83";
var transfer = new Models.Transfer();
switch (currency)
{
case "EUR":
transfer = DataAccess.bocApi.Transfer(fromaccountid, toaccountid, amount, reference);
break;
case "BTC":
transfer = DataAccess.bitCoinAPI.MakeCryptoTransfer(fromaccountid, toaccountid, amount, reference);
break;
default:
break;
}
// var accountBalance = DataAccess.bocApi.GetAccountBalance(id, "5710bba5d42604e4072d1e92");
if (transfer == null)
{
return(NotFound());
}
//Store Transaction details in SQL database
// insert
using (DataAccess.CodeDuoTestEntities entities = new DataAccess.CodeDuoTestEntities())
{
DataAccess.Transaction newTransaction = new DataAccess.Transaction();
newTransaction.Amount = (decimal)amount;
newTransaction.CreatedDate = DateTime.Now;
newTransaction.Currency = currency;
newTransaction.FromAccountId = user.IBAN;
newTransaction.MerchantId = merchant.Id;
newTransaction.MerchantReference = reference;
newTransaction.Status = transfer.status;
newTransaction.ToAccountId = merchant.IBAN;
newTransaction.UserId = user.Id;
if (currency == "BTC")
{
newTransaction.FromAccountId = "";
newTransaction.ToAccountId = "";
}
var customers = entities.Transactions.Add(newTransaction);
entities.SaveChanges();
}
if (transfer.status == "COMPLETED")
{
transfer.status = "SUCCESS";
}
else
{
transfer.status = "FAILED";
}
return(Ok(transfer));
}
