/// <summary>
/// FindAll method.
/// </summary>
/// <returns></returns>
public List <Order> All()
{
var orderDac = new OrderDAC();
var result = orderDac.Select();
return(result);
}
public List <OrderDTO> RefundStatement(Guid accountId, int pageIndex, int pageSize)
{
var orderDac = new OrderDAC();
var orderList = orderDac.GetMerchantRefundOrder(accountId, pageIndex, pageSize);
var coinList = new CryptocurrencyDAC().GetAll();
var result = new List <OrderDTO>();
foreach (var order in orderList)
{
var coin = coinList.FirstOrDefault(e => e.Id == order.CryptoId);
var orderDTO = new OrderDTO
{
Id = order.Id,
OrderNo = order.OrderNo,
OrderStatus = order.Status,
Timestamp = order.Timestamp.ToUnixTime(),
CryptoCode = coin?.Code,
CryptoAmount = order.CryptoAmount.ToString(coin?.DecimalPlace ?? 0),
FiatCurrency = order.FiatCurrency,
FiatAmount = order.FiatAmount.ToString("F", CultureInfo.InvariantCulture),
UserAccount = order.UserAccountId.HasValue ? GetUserMastMaskedCellphone(order.UserAccountId.Value) : string.Empty,
ActualCryptoAmount = order.ActualCryptoAmount.ToString(coin?.DecimalPlace ?? 0)
};
result.Add(orderDTO);
}
return(result);
}
public void BorrarOrder(int id)
{
var orderDAC = new OrderDAC();
orderDAC.DeleteById(id);
//db.Delete(id);
}
public Order FindByOrder(int order)
{
var orderDac = new OrderDAC();
var result = orderDac.SelectByOrder(order);
return(result);
}
public void BackOfficeRefundOrder(string orderno)
{
var order = new OrderDAC().GetByOrderNo(orderno);
var coin = new CryptocurrencyDAC().GetById(order.CryptoId);
var regId = RedisHelper.StringGet($"FiiiPay:Notice:UserId:{order.UserAccountId}");
var lang = RedisHelper.StringGet(REDIS_LANGUAGE_DBINDEX, $"FiiiPay:Language:{order.UserAccountId}") ?? "en";
var titleKey = "BackOfficeRefundOrderTitle";
var subTitleKey = "BackOfficeRefundOrderSubTitle";
if (!(_resourcePropertyNames.Contains(titleKey) && _resourcePropertyNames.Contains(subTitleKey)))
{
throw new Exception("没有找到资源");
}
//var content = string.Format(Resources.ResourceHelper.GetString(titleKey, new System.Globalization.CultureInfo(lang)), coin.Code);
//var subTitle = string.Format(Resources.ResourceHelper.GetString(subTitleKey, new System.Globalization.CultureInfo(lang)), coin.Code);
var content = ResourceHelper.FiiiPay.GetFormatResource(titleKey, lang, coin.Code);
var subTitle = ResourceHelper.FiiiPay.GetFormatResource(subTitleKey, lang, coin.Code);
string noticeId = "";
//写MongoDB [退款]
MessagesComponent.AddMessage(order.UserAccountId.Value, UserType.User, order.Id.ToString(), FiiiPayPushType.TYPE_REFUND_ORDER, titleKey, subTitleKey, coin.Code, content, subTitle, out noticeId);
RegPush(FiiiPayPushType.TYPE_REFUND_ORDER, new List <string> {
regId
}, order.Id, content, subTitle, noticeId);
LogHelper.Info($"--------{lang}------{content}----------{subTitle}");
}
public List <OrderDTO> ReceiptStatement(Guid accountId, DateTime startTime, DateTime endTime, int pageIndex, int pageSize)
{
var orderDac = new OrderDAC();
_logger.Info("----------------" + accountId + startTime + pageIndex + pageSize);
var orderList = orderDac.GetMerchantOrderByDate(accountId, startTime, endTime, pageIndex, pageSize);
_logger.Info("----------------" + JsonConvert.SerializeObject(orderList));
var coinList = new CryptocurrencyDAC().GetAll();
var result = new List <OrderDTO>();
foreach (var order in orderList)
{
var coin = coinList.FirstOrDefault(e => e.Id == order.CryptoId);
var orderDTO = new OrderDTO
{
Id = order.Id,
OrderNo = order.OrderNo,
OrderStatus = order.Status,
Timestamp = order.PaymentTime.Value.ToUtcTimeTicks(),
CryptoCode = coin?.Code,
CryptoAmount = order.CryptoAmount.ToString(coin?.DecimalPlace ?? 0),
FiatCurrency = order.FiatCurrency,
FiatAmount = order.FiatAmount.ToString("F", CultureInfo.InvariantCulture),
UserAccount = order.UserAccountId.HasValue ? GetUserMastMaskedCellphone(order.UserAccountId.Value) : string.Empty,
ActualCryptoAmount = order.ActualCryptoAmount.ToString(coin?.DecimalPlace ?? 0)
};
result.Add(orderDTO);
}
return(result);
}
public void PushConsume(string id)
{
var orderId = Guid.Parse(id);
var order = new OrderDAC().GetOrderByOrderId(orderId);
var coin = new CryptocurrencyDAC().GetById(order.CryptoId);
var regId = RedisHelper.StringGet($"FiiiPay:Notice:UserId:{order.UserAccountId}");
var lang = RedisHelper.StringGet(REDIS_LANGUAGE_DBINDEX, $"FiiiPay:Language:{order.UserAccountId}") ?? "en";
var titleKey = "ConsumeTitle";
var subTitleKey = "ConsumeSubTitle";
if (!(_resourcePropertyNames.Contains(titleKey) && _resourcePropertyNames.Contains(subTitleKey)))
{
throw new Exception("没有找到资源");
}
var content = ResourceHelper.FiiiPay.GetFormatResource(titleKey, lang, coin.Code);
var subTitle = ResourceHelper.FiiiPay.GetFormatResource(subTitleKey, lang, coin.Code);
string noticeId = "";
//写MongoDB [消费（支付成功）]
MessagesComponent.AddMessage(order.UserAccountId.Value, UserType.User, order.Id.ToString(), FiiiPayPushType.TYPE_CONSUME, titleKey, subTitleKey, coin.Code, content, subTitle, out noticeId);
RegPush(FiiiPayPushType.TYPE_CONSUME, new List <string> {
regId
}, order.Id, content, subTitle, noticeId);
LogHelper.Info($"--------{lang}------{content}----------{subTitle}");
}
/// <summary>
/// 统计今天、所有交易的订单量和金额
/// </summary>
/// <param name="merchantId"></param>
/// <param name="status"></param>
/// <returns></returns>
public OrderStat GetOrderStat(Guid merchantId, int status = 2)
{
OrderDAC dac = new OrderDAC();
OrderStat orderStat = dac.GetOrderStat(merchantId, status);
return(orderStat);
}
/// <summary>
/// Find method.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Order Find(int id)
{
var orderDac = new OrderDAC();
var result = orderDac.SelectById(id);
return(result);
}
public List <Order> GetOrdersByCustomerID(string customerID)
{
var repo = new OrderDAC();
var tempList = repo.GetAllOrdersByCustomer(customerID);
return(tempList);
}
// GET: Order
public ActionResult Index()
{
OrderDAC dac = new OrderDAC();
DataTable dt = dac.GetOrderSalesByMonth();
string data1 = default; //제품1 y축 데이터
List <string> prodNM = new List <string>(); // 제품명
string labels = "1월,2월,3월,4월,5월,6월,7월,8월,9월,10월,11월,12월";
DataView dv = new DataView(dt);
List <int> qtys = new List <int>();
for (int i = 0; i < dv.ToTable().Columns.Count - 1; i++)
{
qtys.Add(Convert.ToInt32(dv.ToTable().Rows[0][i]));
}
data1 = "[" + string.Join(",", qtys.ToArray()) + "]";
qtys.Clear();
ViewBag.Labels = labels;
ViewBag.Label1 = dv.ToTable().Rows[0][12];
ViewBag.data1 = data1;
OrderDAC dac1 = new OrderDAC();
var list = dac1.GetTotalPrieByCom();
ViewBag.C1 = list[0].TotalPrice;
ViewBag.C2 = list[1].TotalPrice;
ViewBag.C3 = list[2].TotalPrice;
ViewBag.C4 = list[3].TotalPrice;
ViewBag.C5 = list[4].TotalPrice;
ViewBag.C6 = list[5].TotalPrice;
ViewBag.C7 = list[6].TotalPrice;
ViewBag.C8 = list[7].TotalPrice;
ViewBag.C9 = list[8].TotalPrice;
ViewBag.B1 = list[0].COMNAME;
ViewBag.B2 = list[1].COMNAME;
ViewBag.B3 = list[2].COMNAME;
ViewBag.B4 = list[3].COMNAME;
ViewBag.B5 = list[4].COMNAME;
ViewBag.B6 = list[5].COMNAME;
ViewBag.B7 = list[6].COMNAME;
ViewBag.B8 = list[7].COMNAME;
ViewBag.B9 = list[8].COMNAME;
Order orders = new Order()
{
Orders = list
};
OrderDAC dac2 = new OrderDAC();
ViewBag.OrderList = dac2.GetOrderList();
return(View(orders));
}
public Order GetOrder(int id)
{
//return db.GetById(id);
var orderDAC = new OrderDAC();
var result = orderDAC.SelectById(id);
return(result);
}
public Order AgregarOrder(Order order)
{
//return db.Create(order);
Order result = default(Order);
var orderDAC = new OrderDAC();
result = orderDAC.Create(order);
return(result);
}
public OrderDetailDTO GetById(Guid merchantAccountId, Guid orderId)
{
var order = new OrderDAC().GetById(orderId);
var merchantAccount = new MerchantAccountDAC().GetById(merchantAccountId);
var pos = new POSDAC().GetById(merchantAccount.POSId.Value);
if (order == null)
{
throw new CommonException(10000, Resources.订单不存在);
}
if (order.MerchantAccountId != merchantAccountId)
{
throw new CommonException(10000, Resources.只能查看自己的订单);
}
var coin = new CryptocurrencyDAC().GetById(order.CryptoId);
var er = order.ExchangeRate;
var cer = GetExchangeRate(merchantAccount.CountryId, order.FiatCurrency, coin);
var iRate = ((cer - er) / er) * 100;
var result = new OrderDetailDTO
{
Id = order.Id,
OrderNo = order.OrderNo,
OrderStatus = order.Status,
Timestamp = order.Timestamp.ToUnixTime(),
CryptoStatus = coin.Status,
CryptoEnable = coin.Enable,
CryptoCode = coin.Code,
CryptoAmount = order.CryptoAmount.ToString(coin.DecimalPlace),
FiatCurrency = order.FiatCurrency,
FiatAmount = order.FiatAmount.ToString(2),
Markup = order.Markup,
ActualFiatAmount = order.ActualFiatAmount.ToString(2),
TransactionFee = order.TransactionFee.ToString(coin.DecimalPlace),
ActualCryptoAmount = order.ActualCryptoAmount.ToString(coin.DecimalPlace),
UserAccount = order.UserAccountId.HasValue ? GetUserMastMaskedCellphone(order.UserAccountId.Value) : string.Empty,
SN = pos.Sn,
ExchangeRate = er.ToString(4),
CurrentExchangeRate = cer.ToString(4),
IncreaseRate = iRate > 0 ? $"+{iRate.ToString(2)}" : iRate.ToString(2)
};
if (result.OrderStatus == OrderStatus.Refunded)
{
var refund = new RefundDAC().GetByOrderId(result.Id);
if (refund?.Timestamp != null)
{
result.RefundTimestamp = refund.Timestamp.ToUnixTime();
}
}
return(result);
}
public OrderStatusDTO GetStatusByOrderNo(Guid merchantAccountId, string orderNo)
{
var order = new OrderDAC().GetByOrderNo(orderNo);
return(new OrderStatusDTO()
{
OrderStatus = order?.Status ?? OrderStatus.Pending,
Id = order == null ? String.Empty : order.Id.ToString()
});
}
/// <summary>
/// 获取区间的日期订单统计[年]
/// </summary>
/// <param name="merchantId"></param>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <returns></returns>
public List <OrderMonthStat> GetOrderStatInMonth(Guid merchantId, DateTime startDate, DateTime endDate)
{
startDate = new DateTime(startDate.Year, startDate.Month, startDate.Day, 0, 0, 0);
endDate = new DateTime(endDate.Year, endDate.Month, endDate.Day, 23, 59, 59);
OrderDAC dac = new OrderDAC();
List <OrderMonthStat> list = dac.GetTradingStatInMonth(merchantId, startDate, endDate);
return(list);
}
public List <Order> ListarTodasLasOrdenes()
{
// return db.Get();
List <Order> result = default(List <Order>);
var orderDAC = new OrderDAC();
result = orderDAC.Select();
return(result);
}
public Order Add(Order Order)
{
var OrderDac = new OrderDAC();
Order.CreatedBy = CreatedBy;
Order.CreatedOn = CreatedOn;
Order.ChangedBy = ChangedBy;
Order.ChangedOn = ChangedOn;
return(OrderDac.Create(Order));
}
public PrintOrderInfoDTO PrintOrder(Guid merchantAccountId, string orderNo)
{
var order = new OrderDAC().GetByOrderNo(orderNo);
var merchantAccount = new MerchantAccountDAC().GetById(merchantAccountId);
var pos = new POSDAC().GetById(merchantAccount.POSId.Value);
if (order == null)
{
throw new CommonException(10000, Resources.订单不存在);
}
if (order.MerchantAccountId != merchantAccountId)
{
throw new CommonException(10000, Resources.只能查看自己的订单);
}
var coin = new CryptocurrencyDAC().GetById(order.CryptoId);
var result = new PrintOrderInfoDTO
{
Id = order.Id,
OrderNo = order.OrderNo,
OrderStatus = order.Status,
Timestamp = order.Timestamp.ToUnixTime(),
CryptoCode = coin.Code,
CryptoAmount = order.CryptoAmount.ToString(coin.DecimalPlace),
FiatCurrency = order.FiatCurrency,
FiatAmount = order.FiatAmount.ToString(2),
Markup = order.Markup,
ActualFiatAmount = order.ActualFiatAmount.ToString(2),
ExchangeRate = $"1 {coin.Code} = {order.ExchangeRate.ToString(4)} {order.FiatCurrency}",
TransactionFee = order.TransactionFee.ToString(coin.DecimalPlace),
ActualCryptoAmount = order.ActualCryptoAmount.ToString(coin.DecimalPlace),
UserAccount = order.UserAccountId.HasValue ? GetUserMastMaskedCellphone(order.UserAccountId.Value) : string.Empty,
SN = pos.Sn,
AvatarId = merchantAccount.Photo,
MerchantName = merchantAccount.MerchantName,
CryptoImage = coin.IconURL
};
if (result.OrderStatus == OrderStatus.Refunded)
{
var refund = new RefundDAC().GetByOrderId(result.Id);
if (refund?.Timestamp != null)
{
result.RefundTimestamp = refund.Timestamp.ToUnixTime();
}
}
return(result);
}
public TradingReportDTO YearlyTrading(Guid merchantAccountId)
{
//if (!new ProfileComponent().ValidateLv1(merchantAccountId))
// throw new CommonException(ReasonCode.NOT_VERIFY_LV1, Resources.需要Lv1认证才能使用相关功能);
var date = DateTime.UtcNow.Date;
var endDate = new DateTime(date.Year, date.Month, date.Day - 1);
var startDate = new DateTime(date.Year, date.Month, 1).AddMonths(-11);
var account = new MerchantAccountDAC().GetById(merchantAccountId);
var country = new CountryComponent().GetById(account.CountryId);
OrderDAC dac = new OrderDAC();
List <OrderMonthStat> list = dac.GetTradingStatInMonth(merchantAccountId, startDate, endDate);
var volume = list.Sum(e => e.OrderCount);
var sum = list.Sum(e => e.OrderAmount);
var avg = volume == 0 ? 0 : sum / volume;
var result = new TradingReportDTO
{
FormDate = startDate.ToUnixTime(),
ToDate = endDate.ToUnixTime(),
Volume = volume,
SumAmount = sum.ToString("F"),
AvgAmount = avg.ToString("F"),
FiatCurrency = country.FiatCurrency ?? "USD",
Stats = new List <Stat>()
};
var cusorDate = startDate;
while (cusorDate <= endDate)
{
var item = list.FirstOrDefault(e => DateTime.Parse($"{e.OrderYear}/{e.OrderMonth}") == cusorDate);
var stat = new Stat
{
Date = cusorDate.ToUnixTime(),
Count = item?.OrderCount ?? 0,
Amount = item?.OrderAmount ?? 0M
};
result.Stats.Add(stat);
cusorDate = cusorDate.AddMonths(1);
}
return(result);
}
public void PushOrderPayed(Guid orderId)
{
var order = new OrderDAC().GetOrderByOrderId(orderId);
var coin = new CryptocurrencyDAC().GetById(order.CryptoId);
var agent = new JPushAgent();
var regId = RedisHelper.StringGet($"{FiiiPOS_APP_Notice_MerchantId}:{order.MerchantAccountId}");
var lang = RedisHelper.StringGet(REDIS_LANGUAGE_DBINDEX, $"{FiiiPOS_APP_Language_MerchantId}:{order.MerchantAccountId}") ?? "en";
var titleKey = "ReceiptTitle";
var subTitleKey = "ReceiptSubTitle";
var content = ResourceHelper.FiiiPos.GetFormatResource(titleKey, lang, coin.Code);
var subTitle = ResourceHelper.FiiiPos.GetResource(subTitleKey, lang);
string noticeId = "";
//写MongoDB [收款成功]
MessagesComponent.AddMessage(order.MerchantAccountId, UserType.Merchant, order.Id.ToString(), FiiiPayPushType.TYPE_RECEIPT, titleKey, subTitleKey, coin.Code, content, subTitle, out noticeId);
var result = agent.Push(new PushPayload
{
Audience = new { registration_id = new List <string> {
regId
} },
Platform = "all",
Notification = new Notification
{
Alert = content,
Android = new Android
{
Alert = subTitle,
Title = content,
Extras = PushHelper.GetNewExtras(FiiiPayPushType.TYPE_RECEIPT, orderId, content, subTitle, noticeId)
}
},
Message = new Message
{
Content = content,
Extras = PushHelper.GetNewExtras(FiiiPayPushType.TYPE_RECEIPT, orderId, content, subTitle, noticeId)
},
Options = new Options {
IsApnsProduction = IsPushProduction
}
});
LogHelper.Info($"--------{lang}------{content}----------{subTitle}");
}
/// <summary>
/// 获取订单列表
/// </summary>
/// <param name="merchantId"></param>
/// <param name="orderSN"></param>
/// <param name="status"></param>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="pageIndx"></param>
/// <param name="pageSize"></param>
/// <param name="count"></param>
/// <returns></returns>
public List <OrderByPage> GetOrderRecordList(Guid merchantId, string orderSN, int status, string startDate, string endDate, int pageIndx, int pageSize, out int count)
{
count = 0;
List <OrderByPage> list = new OrderDAC().GetOrderRecordListByPage(merchantId, orderSN, status, startDate, endDate, pageIndx, pageSize);
foreach (var item in list)
{
var coin = new CryptocurrencyDAC().GetById(item.CryptoId);
var er = item.ExchangeRate;
var cer = GetExchangeRate(item.FiatCurrency, coin);
var iRate = ((cer - er) / er) * 100;
item.CurrentExchangeRate = $"1 {coin.Code} = {cer.ToString(2)} {item.FiatCurrency}";
item.IncreaseRate = iRate > 0 ? $"+{iRate.ToString(2)}" : iRate.ToString(2);
}
if (list != null && list.Count > 0)
{
count = list[0].TotalCount;
}
return(list);
}
public void PushRefundOrder(string orderno)
{
var order = new OrderDAC().GetByOrderNo(orderno);
var coin = new CryptocurrencyDAC().GetById(order.CryptoId);
var regId = RedisHelper.StringGet($"{FiiiPOS_APP_Notice_MerchantId}:{order.MerchantAccountId}");
var lang = RedisHelper.StringGet(REDIS_LANGUAGE_DBINDEX, $"{FiiiPOS_APP_Language_MerchantId}:{order.MerchantAccountId}") ?? "en";
var titleKey = "BackOfficeRefundOrderTitle";
var subTitleKey = "BackOfficeRefundOrderSubTitle";
var content = ResourceHelper.FiiiPos.GetFormatResource(titleKey, lang, coin.Code);
var subTitle = ResourceHelper.FiiiPos.GetFormatResource(subTitleKey, lang, coin.Code);
string noticeId = "";
//写MongoDB [提币成功]
MessagesComponent.AddMessage(order.MerchantAccountId, UserType.Merchant, order.Id.ToString(), FiiiPayPushType.TYPE_REFUND_ORDER, titleKey, subTitleKey, coin.Code, content, subTitle, out noticeId);
RegPush(FiiiPayPushType.TYPE_REFUND_ORDER, new List <string> {
regId
}, order.Id, content, subTitle, noticeId);
LogHelper.Info($"--------{lang}------{content}----------{subTitle}");
}
/// <summary>
/// Add method.
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public Order Add(Order order)
{
var orderDac = new OrderDAC();
var neworder = new Order();
neworder = orderDac.Create(order);
var cartbusi = new CartItemBusiness();
var lista = cartbusi.FindByCartId(neworder.OrderNumber);
var odb = new OrderDetailBusiness();
foreach (CartItem item in lista)
{
var od = new OrderDetail();
od.OrderId = neworder.Id;
od.ProductId = item.ProductId;
od.Price = item.Price;
od.Quantity = item.Quantity;
odb.Add(od);
}
return(neworder);
}
public decimal GetOrderAmount(int orderID)
{
OrderDAC dac = new OrderDAC();
return(dac.GetOrderAmount(orderID));
}
public bool DeleteOrderInfo(int orderID)
{
OrderDAC dac = new OrderDAC();
return(dac.DeleteOrderInfo(orderID));
}
public bool UpdateShipInfo(OrderVO order)
{
OrderDAC dac = new OrderDAC();
return(dac.UpdateShipInfo(order));
}
public List <OrderDetailVO> GetOrderDetailList(int orderID)
{
OrderDAC dac = new OrderDAC();
return(dac.GetOrderDetailList(orderID));
}
public List <OrderVO> GetOrderSearchList(string custID, int empID, string dtFrom, string dtTo)
{
OrderDAC dac = new OrderDAC();
return(dac.GetOrderSearchList(custID, empID, dtFrom, dtTo));
}
public bool RegisterOrder(OrderVO order, List <OrderDetailVO> ordDetail)
{
OrderDAC dac = new OrderDAC();
return(dac.RegisterOrder(order, ordDetail));
}
