private TransactionHistoryDTO convertToTH(double sum, string from, string status, string currency, string cardnumber)
{
var th = new TransactionHistoryDTO();
th.Currency = currency;
th.TransactionCost = sum;
th.TransactionType = from;
th.TransactionTarget = cardnumber;
th.TransactionStatus = status;
return(th);
}
private TransactionHistoryDTO convertToTH(ExchangeDTO dto, string status)
{
var th = new TransactionHistoryDTO();
th.Currency = dto.Currency;
th.TransactionCost = dto.Amount;
th.TransactionType = dto.From;
th.TransactionTarget = dto.To;
th.TransactionStatus = status;
return(th);
}
public static TransactionHistoryDTO ToDTO(TransactionHistory entity)
{
var dto = new TransactionHistoryDTO();
dto.Currency = entity.Currency;
dto.Name = entity.Name;
dto.TransactionCost = entity.TransactionCost;
dto.TransactionStatus = entity.TransactionStatus;
dto.TransactionTarget = entity.TransactionTarget;
dto.TransactionType = entity.TransactionType;
return(dto);
}
public static TransactionHistory ToEntity(TransactionHistoryDTO dto)
{
var entity = new TransactionHistory();
entity.Currency = dto.Currency;
entity.Name = dto.Name;
entity.TransactionCost = dto.TransactionCost;
entity.TransactionStatus = dto.TransactionStatus;
entity.TransactionTarget = dto.TransactionTarget;
entity.TransactionType = dto.TransactionType;
entity.AccountId = dto.AccountId;
return(entity);
}
public async Task <ActionResult <TransactionHistory> > createTransactionHistory(TransactionHistoryDTO dto)
{
TransactionHistory transactionHistory = new TransactionHistory(); //truyền xuống dto có 4 field: postid, giver, receiver, transactiondate
transactionHistory.PostId = dto.PostId;
transactionHistory.Giver = dto.Giver;
transactionHistory.Receiver = dto.Receiver;
transactionHistory.TransactionDate = DateTime.Now;
TblUsersHavingPosts usersHavingPosts = _context.TblUsersHavingPosts.FromSqlRaw("select * from TblUsersHavingPosts where " +
"Username = {0} and PostId = {1}", dto.Receiver, dto.PostId).First(); //tìm bài post của freelancer đã hoàn thành
usersHavingPosts.Status = "finished"; //set status = finished
_context.Entry(usersHavingPosts).State = EntityState.Modified;
TblPosts post = _context.TblPosts.FromSqlRaw("select * from TblPosts where " +
"Id = {0}", dto.PostId).First(); //tìm bài post trong TblPosts
post.IsPublic = false; //ko public bài post nữa
_context.Entry(post).State = EntityState.Modified;
Int64 postAmount = _context.TblPosts.Find(dto.PostId).Amount; //lấy ra amount của bài post
transactionHistory.Amount = postAmount; //lưu vào transaction history
_context.TransactionHistory.Add(transactionHistory); //add transaction dto vào table TransactionHistory
TblUsers company = _context.TblUsers.Find(dto.Giver); //tìm ra company
company.Amount -= postAmount; //lấy amount hiện tại của company - amount của bài post đã finished
_context.Entry(company).State = EntityState.Modified;
TblUsers freelancer = _context.TblUsers.Find(dto.Receiver); //tìm ra freelancer
freelancer.Amount += postAmount; //lấy amount hiện tại của freelancer + amount của bài post đã finished
_context.Entry(freelancer).State = EntityState.Modified;
await _context.SaveChangesAsync();
return(transactionHistory);
}
public void Save(TransactionHistoryDTO dto)
{
historyRepository.Save(TransactionHistoryConverter.ToEntity(dto));
}
