public RouteViewModel GetRouteById(string routeId)
{
var route = (from p in _routeRepository.GetAllQueryable()
join l1 in _locationRepository.GetAllQueryable() on p.Location1C equals l1.LocationC into pl1
from l1 in pl1.DefaultIfEmpty()
join l2 in _locationRepository.GetAllQueryable() on p.Location2C equals l2.LocationC into pl12
from l2 in pl12.DefaultIfEmpty()
join t in _containerTypeRepository.GetAllQueryable() on p.ContainerTypeC equals t.ContainerTypeC into pl12c
from t in pl12c.DefaultIfEmpty()
where p.RouteId == routeId
select new RouteViewModel()
{
RouteId = p.RouteId,
Location1C = p.Location1C,
Location1N = l1.LocationN,
Location2C = p.Location2C,
Location2N = l2.LocationN,
ContainerTypeC = p.ContainerTypeC,
ContainerTypeN = t.ContainerTypeN,
ContainerSizeI = p.ContainerSizeI,
IsEmpty = p.IsEmpty,
IsHeavy = p.IsHeavy,
IsSingle = p.IsSingle,
RouteN = p.RouteN,
TotalExpense = p.TotalExpense
}).FirstOrDefault();
if (route != null)
{
route = GetRouteExpenses(route);
return(route);
}
return(null);
}
public string MakePayoutToCustomer(int TicketId, string username)
{
string staffId = _userRepository.Get(x => x.UserName == username).Id;
//lấy all routeTicke ứng vs cái Ticket
///// CÁCH 1
var route =
(from ROUTE in _routeRepository.GetAllQueryable()
join RT in _routeTicketRepository.GetAllQueryable()
on ROUTE.Id equals RT.RouteId
where ROUTE.Deleted == false &&
RT.Deleted == false &&
ROUTE.Status == RouteStatus.Bought &&
RT.TicketId == TicketId
select ROUTE)
.FirstOrDefault();
if (route == null)
{
return("Not found Route");
}
var ticket = _ticketRepository.Get(x => x.Id == TicketId && x.Deleted == false);
if (ticket.Status == TicketStatus.Completed)
{
throw new InvalidOperationException();
}
_unitOfWork.StartTransaction();
ticket.Status = TicketStatus.Completed;
_ticketRepository.Update(ticket);
_unitOfWork.CommitChanges();
//make payout
var paymentDetail = _paymentRepository.Get(x => x.RouteId == route.Id && x.Deleted == false);
StripeConfiguration.SetApiKey(SETTING.Value.SecretStripe);
var amount = ticket.SellingPrice * (100 - ticket.CommissionPercent) / 100;
//số tiền chuyển đi
var options = new TransferCreateOptions
{
Amount = Convert.ToInt64(amount * 100),
Currency = "usd",
Destination = ticket.Seller.StripeConnectAccountId,
SourceTransaction = paymentDetail.StripeChargeId,
Description = "Transfer for Ticket Code: " + ticket.TicketCode
};
var service = new TransferService();
Transfer Transfer = service.Create(options);
Core.Models.Payout payoutCreateIntoDatabase = new Core.Models.Payout();
payoutCreateIntoDatabase.StripePayoutId = Transfer.Id;
payoutCreateIntoDatabase.TicketId = TicketId;
payoutCreateIntoDatabase.PaymentId = paymentDetail.Id;
payoutCreateIntoDatabase.Amount = amount;
payoutCreateIntoDatabase.FeeAmount = ticket.SellingPrice * (ticket.CommissionPercent / 100);
payoutCreateIntoDatabase.Description = "You receive money for ticket " + ticket.TicketCode + ". Thank you for using our service.";
payoutCreateIntoDatabase.Status = PayoutStatus.Success;
_payoutRepository.Add(payoutCreateIntoDatabase);
//make payout
//save log
//_unitOfWork.StartTransaction();
ResolveOptionLog log = new ResolveOptionLog()
{
Option = ResolveOption.PAYOUT,
RouteId = route.Id,
TicketId = TicketId,
StaffId = staffId,
Amount = amount
};
_resolveOptionLogRepository.Add(log);
_unitOfWork.CommitChanges();
if (route.ResolveOptionLogs.Count() == route.RouteTickets.Where(x => x.Deleted == false).Count())
{
route.Status = RouteStatus.Completed;
_routeRepository.Update(route);
}
_unitOfWork.CommitTransaction();
//save log
//push noti to buyer
var message = "Ticket " + ticket.TicketCode + " has been payout. $" +
(amount).ToString("N2") + " has been tranfered to your Stripe account.";
var sellerDevices = ticket.Seller.CustomerDevices.Where(x => x.IsLogout == false);
List <string> sellerDeviceIds = new List <string>();
foreach (var sellerDev in sellerDevices)
{
sellerDeviceIds.Add(sellerDev.DeviceId);
}
//push noti
_oneSignalService.PushNotificationCustomer(message, sellerDeviceIds);
//Save Notification
_notificationService.SaveNotification(
customerId: ticket.SellerId,
type: NotificationType.TicketIsPayouted,
message: $"Ticket {ticket.TicketCode} has been payout. ${(amount).ToString("N2")} has been transfered to your Stripe account.",
data: new { ticketId = ticket.Id, });
//send Email
_sendGridService.SendEmailReceiptForSeller(TicketId, amount);
return("");
}
