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