private async Task ViewCurrentOrder()
{
Console.Clear();
Task <HttpResponseMessage> getCurrentOrderResponse = _httpClient.GetAsync($"https://localhost:44332/api/Order/{_currentOrderId}");
if (getCurrentOrderResponse.Result.IsSuccessStatusCode)
{
OrderListItem order = _httpClient.GetAsync($"https://localhost:44332/api/Order/{_currentOrderId}").Result.Content.ReadAsAsync <OrderListItem>().Result;
string orderproducts = " ";
foreach (var orderProduct in order.OrderProducts)
{
orderproducts = orderproducts + orderProduct.ProductCount + " X " + orderProduct.ProductName + " (OrderItem ID: " + orderProduct.PrimaryId + ")\n";
}
Console.WriteLine($"\n" +
$"Order Id: {order.OrderId}\n" +
$"Created Date: {order.CreatedOrderDate}\n" +
$"Products: {orderproducts} Total Cost: {order.Cost.ToString("C")}\n\n");
}
else
{
string stringResponse = await getCurrentOrderResponse.Result.Content.ReadAsStringAsync();
Console.WriteLine($"Something is wrong... Please try again. {getCurrentOrderResponse.Result.StatusCode}");
}
}
public IEnumerable <OrderListItem> GetOrders() //For customer that is logged in
{
using (var ctx = new ApplicationDbContext())
{
var query =
ctx
.Orders
.Where(e => e.CustomerId == _userId).ToList();
List <OrderListItem> newList = new List <OrderListItem>();
foreach (var q in query)
{
var oLI = new OrderListItem
{
OrderId = q.OrderId,
CustomerId = q.CustomerId,
CustomerFirstName = q.Customer.FirstName,
OrderProducts = HelperConvertOrderProductsToOPListItem(q.OrderProducts),
Cost = q.OrderFinalized ? q.FinalTotalCost : q.TotalCost,
CreatedOrderDate = q.CreatedOrderDate,
OrderFinalized = q.OrderFinalized
};
newList.Add(oLI);
}
return(newList);
}
}
public OrderListItem CreateOrderListItem(Order order, IPersistenceContext context)
{
var data = new OrderListItem();
UpdateListItem(data, order, context);
UpdateListItem(data, order.Visit, context);
return(data);
}
public OrderListItem CreateOrderListItem(Procedure rp, IPersistenceContext context)
{
var data = new OrderListItem();
UpdateListItem(data, rp.Order, context);
UpdateListItem(data, rp.Order.Visit, context);
UpdateListItem(data, rp, context);
return(data);
}
private void Button_Add(object sender, EventArgs e)
{
Button button = (Button)sender;
OrderListItem serchedOrder = (OrderListItem)button.BindingContext;
OrderListItem selectedOrder = ordersPageViewModel.OrderListItems.FirstOrDefault(x => x.Order == serchedOrder.Order);
if (null != selectedOrder)
{
selectedOrder.Order.Count++;
}
}
private static void UpdateListItem(OrderListItem data, Procedure rp, IPersistenceContext context)
{
var rptAssembler = new ProcedureTypeAssembler();
data.ProcedureRef = rp.GetRef();
data.ProcedureType = rptAssembler.CreateSummary(rp.Type);
data.ProcedureScheduledStartTime = rp.ScheduledStartTime;
data.ProcedureSchedulingCode = EnumUtils.GetEnumValueInfo(rp.SchedulingCode);
data.ProcedureCheckInTime = rp.ProcedureCheckIn.CheckInTime;
data.ProcedureCheckOutTime = rp.ProcedureCheckIn.CheckOutTime;
data.ProcedureStatus = EnumUtils.GetEnumValueInfo(rp.Status, context);
data.ProcedurePerformingFacility = new FacilityAssembler().CreateFacilitySummary(rp.PerformingFacility);
data.ProcedurePortable = rp.Portable;
data.ProcedureLaterality = EnumUtils.GetEnumValueInfo(rp.Laterality, context);
}
public OrderListItem Map(GetOrdersQueryResultItem listItem)
{
var result = new OrderListItem
{
Id = listItem.Id,
TotalAmount = listItem.TotalAmount,
Exchange = listItem.Exchange,
PairSymbols = listItem.PairSymbols,
Price = listItem.Price,
Status = listItem.Status,
Type = listItem.Type,
Volume = listItem.Volume
};
return(result);
}
public static void SaveAllOrder(ICollection <ListAggregator> list)
{
var tempAggrList = new List <OrderListAggrItem>();
int i = 1, j = 1, k = 1;
list.ToList().ForEach(aggr =>
{
var itemAggr = new OrderListAggrItem {
Id = aggr.ListAggregatorId, Order = i++
};
aggr.Lists.ToList().ForEach(lista =>
{
var itemList = new OrderListItem {
Id = lista.ListId, Order = j++
};
lista.ListItems.ToList().ForEach(item =>
{
var itemItem = new OrderItem {
Id = item.ListItemId, Order = k++
};
itemList.List.Add(itemItem);
});
itemAggr.List.Add(itemList);
});
tempAggrList.Add(itemAggr);
});
if (Application.Current.Properties.ContainsKey("UserName"))
{
var UserName = Application.Current.Properties["UserName"].ToString();
string serializedObject = JsonConvert.SerializeObject(tempAggrList);
Application.Current.Properties[$"{UserName}ListOrder"] = serializedObject;
}
}
/// <summary>
/// Populate the ObjectListViews with wine data.
/// </summary>
private void InitializeOrderLists()
{
List <OrderListItem> pendingList = OrderListItem.ConstructFromLists(AppDatabase.WineTable.GetAllWine(), AppDatabase.InventoryTable.GetInventory());
List <OrderListItem> toOrderList = new List <OrderListItem>();
for (int i = pendingList.Count - 1; i >= 0; i--)
{
if (pendingList[i].Quantity <= 0)
{
toOrderList.Add(pendingList[i]);
pendingList.Remove(pendingList[i]);
}
}
pendingOrdersListView.SetObjects(pendingList);
ordersListView.SetObjects(toOrderList);
}
public static void AddOrder(AddOrderPage addOrderPage, TableOrder order)
{
TableOrder addedOrder = order;
OrderListItem auxOrder = ordersPageViewModel.OrderListItems.FirstOrDefault(x => x.Order.Order == order.Order);
if (null == auxOrder)
{
OrderListItem orderListItem = new OrderListItem {
Order = addedOrder, CommitStatus = false
};
ordersPageViewModel.OrderListItems.Add(orderListItem);
}
else
{
auxOrder.Order.Count += addedOrder.Count;
}
}
private void B_MouseDown(object sender, MouseButtonEventArgs e)
{
this.timer.Start();
this.timer.Tag = (sender as Button).Tag;
OrderListItem selecteditem = this.vm.Order.TermekList.FirstOrDefault(x => x.Termek.Equals((sender as Button).Tag as Termek));
if (selecteditem != null)
{
this.vm.SelectedProduct = selecteditem;
}
else
{
this.vm.SelectedProduct = new OrderListItem()
{
Termek = (sender as Button).Tag as Termek
};
}
}
private static void UpdateListItem(OrderListItem data, Order order, IPersistenceContext context)
{
var practitionerAssembler = new ExternalPractitionerAssembler();
var dsAssembler = new DiagnosticServiceAssembler();
var facilityAssembler = new FacilityAssembler();
data.OrderRef = order.GetRef();
data.PlacerNumber = order.PlacerNumber;
data.AccessionNumber = order.AccessionNumber;
data.DiagnosticService = dsAssembler.CreateSummary(order.DiagnosticService);
data.EnteredTime = order.EnteredTime;
data.SchedulingRequestTime = order.SchedulingRequestTime;
data.OrderingPractitioner = practitionerAssembler.CreateExternalPractitionerSummary(order.OrderingPractitioner, context);
data.OrderingFacility = facilityAssembler.CreateFacilitySummary(order.OrderingFacility);
data.ReasonForStudy = order.ReasonForStudy;
data.OrderPriority = EnumUtils.GetEnumValueInfo(order.Priority, context);
data.CancelReason = order.CancelInfo != null && order.CancelInfo.Reason != null?EnumUtils.GetEnumValueInfo(order.CancelInfo.Reason) : null;
data.OrderStatus = EnumUtils.GetEnumValueInfo(order.Status, context);
data.OrderScheduledStartTime = order.ScheduledStartTime;
}
public OrderListResult getOrderList(string openid, string shop)
{
OrderListResult orderListResult = new OrderListResult();
string sql = "select l.merchantOrderId,l.tradeTime from t_order_list l "
+ " where l.sendapi = 'XXC' and l.customerCode = '" + openid + "' and l.`status` != '未支付' and l.purchaserId = '" + shop + "' ";
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "t_goods_list").Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string slt = "";
string pro = "";
string sql1 = "select g.barCode,max(g.skuBillName) goodsname,max(l.slt) slt " +
"from t_order_goods g,t_goods_list l " +
"where l.barcode = g.barCode and g.merchantOrderId = '" + dt.Rows[i]["merchantOrderId"].ToString() + "' " +
"group by g.barCode";
DataTable dt1 = DatabaseOperationWeb.ExecuteSelectDS(sql1, "t_goods_list").Tables[0];
if (dt1.Rows.Count > 0)
{
slt = dt1.Rows[0]["slt"].ToString();
for (int j = 0; j < dt1.Rows.Count; j++)
{
pro += dt1.Rows[0]["goodsname"].ToString() + ",";
}
}
OrderListItem orderListItem = new OrderListItem();
orderListItem.billId = dt.Rows[i]["merchantOrderId"].ToString();
orderListItem.imgUrl = slt;
orderListItem.createTime = dt.Rows[i]["tradeTime"].ToString();
orderListItem.product = pro.Substring(0, pro.Length - 1);
orderListResult.orderList.Add(orderListItem);
}
return(orderListResult);
}
else
{
return(null);
}
}
public List <OrderListItem> GetOrdersByDate(DateTime?date)
{
string sqlQuery = @"SELECT
o.ID as OrderId,
s.Name as ServiceName,
o.PurchaseDate,
o.ServiceAmount,
m.FullName as MasterFullName,
m.Id as MasterId
FROM [dbo].[Order] as o
LEFT JOIN [dbo].[Master] as m ON o.[MasterId] = m.[Id]
INNER JOIN [dbo].[Service] as s ON o.[ServiceId] = s.[Id]";
if (date != null)
{
var startDateStr = date.Value.ToString("MM/dd/yyyy") + " 00:00:00";
var endDateStr = date.Value.ToString("MM/dd/yyyy") + " 23:59:59";
sqlQuery += string.Format(" where PurchaseDate between '{0}' AND '{1}'", startDateStr, endDateStr);
}
return(base.SelectList <OrderListItem>(sqlQuery, (dataReader) =>
{
var row = new OrderListItem();
row.Id = Convert.ToInt32(dataReader["OrderId"]);
row.ServiceName = dataReader["ServiceName"].ToString();
row.MasterFullName = dataReader["MasterFullName"] is DBNull
? null
: dataReader["MasterFullName"].ToString();
row.MasterId = dataReader["MasterId"] is DBNull
? (int?)null
: Convert.ToInt32(dataReader["MasterId"]);
row.PurchaseDate = Convert.ToDateTime(dataReader["PurchaseDate"]);
row.ServiceAmount = Convert.ToDecimal(dataReader["ServiceAmount"]);
return row;
}));
}
/// <summary>
/// Formats the procedure name, portable and laterality similar to "Name (Portable/Laterality)".
/// Name is formatted according to the default person name format as specified in <see cref="FormatSettings"/>
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public static string Format(OrderListItem item)
{
return(Format(item.ProcedureType.Name, item.ProcedurePortable, item.ProcedureLaterality, FormatSettings.Default.ProcedurePortableLateralityDefaultFormat));
}
public OrderListItem getOrder(string openid, string orderId)
{
OrderListItem orderListItem = new OrderListItem();
string sql = "select merchantOrderId,tradeTime,status,tradeAmount,waybillno,waybilltype,payTime,consigneeName," +
"consigneeMobile,addrProvince,addrCity,addrDistrict,addrDetail " +
"from t_order_list " +
"where merchantOrderId = '" + orderId + "' and customerCode = '" + openid + "' ";
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "t_goods_list").Tables[0];
if (dt.Rows.Count > 0)
{
string slt = "";
string pro = "";
string sql1 = "select barCode,skuBillName,slt,quantity,skuUnitPrice " +
"from t_order_goods " +
"where merchantOrderId = '" + orderId + "' " +
"group by barCode";
DataTable dt1 = DatabaseOperationWeb.ExecuteSelectDS(sql1, "t_goods_list").Tables[0];
if (dt1.Rows.Count > 0)
{
List <OrderGoodsListItem> orderGoodsList = new List <OrderGoodsListItem>();
for (int j = 0; j < dt1.Rows.Count; j++)
{
OrderGoodsListItem orderGoodsListItem = new OrderGoodsListItem();
orderGoodsListItem.barCode = dt1.Rows[j]["barCode"].ToString();
orderGoodsListItem.slt = dt1.Rows[j]["slt"].ToString();
orderGoodsListItem.skuUnitPrice = dt1.Rows[j]["skuUnitPrice"].ToString();
orderGoodsListItem.quantity = dt1.Rows[j]["quantity"].ToString();
orderGoodsListItem.skuBillName = dt1.Rows[j]["skuBillName"].ToString();
orderGoodsList.Add(orderGoodsListItem);
}
orderListItem.orderGoodsList = orderGoodsList;
}
orderListItem.billId = dt.Rows[0]["merchantOrderId"].ToString();
orderListItem.imgUrl = slt;
orderListItem.createTime = dt.Rows[0]["tradeTime"].ToString();
orderListItem.payTime = Convert.ToDateTime(dt.Rows[0]["payTime"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
orderListItem.waybilltype = dt.Rows[0]["waybilltype"].ToString();
orderListItem.waybillno = dt.Rows[0]["waybillno"].ToString();
//orderListItem.product = pro.Substring(0, pro.Length - 1);
orderListItem.total = dt.Rows[0]["tradeAmount"].ToString();
orderListItem.consigneeName = dt.Rows[0]["consigneeName"].ToString();
orderListItem.consigneeMobile = dt.Rows[0]["consigneeMobile"].ToString();
orderListItem.addr = dt.Rows[0]["addrProvince"].ToString() + dt.Rows[0]["addrCity"].ToString() + dt.Rows[0]["addrDistrict"].ToString() + dt.Rows[0]["addrDetail"].ToString();
string status = dt.Rows[0]["status"].ToString();
if (status == "1" || status == "2")
{
status = "等待发货";
}
else if (status == "4" || status == "6")
{
status = "已完成";
}
else if (status == "3")
{
status = "已发货";
}
orderListItem.status = status;
return(orderListItem);
}
else
{
return(null);
}
}
public OrderListResult getOrderList(string openid, string shop)
{
string st = "";
if (shop != "")
{
st = " and l.purchaserCode = '" + shop + "' ";
}
OrderListResult orderListResult = new OrderListResult();
string sql = "select l.merchantOrderId,l.tradeTime,l.status,l.tradeAmount,l.payTime from t_order_list l "
+ " where l.sendapi = 'XXC' and l.customerCode = '" + openid + "' and l.`status` != 0 " + st + " order by id desc ";
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "t_goods_list").Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string slt = "";
string pro = "";
string sql1 = "select barCode,max(skuBillName) goodsname,max(slt) slt " +
"from t_order_goods " +
"where merchantOrderId = '" + dt.Rows[i]["merchantOrderId"].ToString() + "' " +
"group by barCode";
DataTable dt1 = DatabaseOperationWeb.ExecuteSelectDS(sql1, "t_goods_list").Tables[0];
if (dt1.Rows.Count > 0)
{
slt = dt1.Rows[0]["slt"].ToString();
for (int j = 0; j < dt1.Rows.Count; j++)
{
pro += dt1.Rows[j]["goodsname"].ToString() + ",";
}
}
OrderListItem orderListItem = new OrderListItem();
orderListItem.billId = dt.Rows[i]["merchantOrderId"].ToString();
orderListItem.imgUrl = slt;
orderListItem.createTime = dt.Rows[i]["tradeTime"].ToString();
orderListItem.payTime = dt.Rows[i]["payTime"].ToString();
orderListItem.product = pro.Substring(0, pro.Length - 1);
orderListItem.total = dt.Rows[i]["tradeAmount"].ToString();
string status = dt.Rows[i]["status"].ToString();
if (status == "1" || status == "2")
{
status = "等待发货";
}
else if (status == "4" || status == "5")
{
status = "已完成";
}
else if (status == "3")
{
status = "已发货";
}
orderListItem.status = status;
orderListResult.orderList.Add(orderListItem);
}
return(orderListResult);
}
else
{
return(new OrderListResult());
}
}
