public Task <string> UpdateOrder(OrderViewModel.OrderSingleResult orderUpdate) { return(Task.Run(() => { //從資料庫抓資料單筆 var singleOrder = _dbRepository.GetAll <Order>().FirstOrDefault(x => x.OrderId == orderUpdate.OrderId); if (singleOrder == null) { return "無匹配訂單"; } else { singleOrder.OrderName = orderUpdate.OrderName; singleOrder.OrderPhone = orderUpdate.OrderPhone; singleOrder.OrderConEmail = orderUpdate.OrderConEmail; singleOrder.Condition = orderUpdate.Condition; singleOrder.OrderAddress = orderUpdate.OrderAddress; } using (var transaction = _context.Database.BeginTransaction()) { try { _dbRepository.Update(singleOrder); transaction.Commit(); return "更新成功"; } catch (Exception ex) { transaction.Rollback(); return ex.Message; } } })); }
//Delete單筆 public Task <string> DeleteOrder(OrderViewModel.OrderSingleResult order) { return(Task.Run(() => { var singleOrder = _dbRepository.GetAll <Order>().FirstOrDefault(x => x.OrderId == order.OrderId); if (singleOrder == null) { return "查無此匹配訂單"; } using (var transaction = _context.Database.BeginTransaction()) { try { _dbRepository.Delete(singleOrder); transaction.Commit(); return "刪除成功"; } catch (Exception ex) { transaction.Rollback(); return ex.Message; } } })); }
public bool Edit(OrderViewModel.OrderSingleResult orderVM) { foreach (var orderDetailVM in orderVM.OrderDetailList) { OrderDetail orderDetail = _dbRepository.GetAll <OrderDetail>().FirstOrDefault(orderDetail => orderDetail.OrderDetailId == orderDetailVM.OrderDetailId); orderDetail.Quantity = orderDetailVM.Quantity; orderDetail.SpecialPrice = orderDetailVM.SpecialPrice; _dbRepository.Update(orderDetail); } Order order = _dbRepository.GetAll <Order>().FirstOrDefault(order => order.OrderId == orderVM.OrderId); order.ShipName = orderVM.ShipName; order.ShipCity = orderVM.ShipCity; order.ShipRegion = orderVM.ShipRegion; order.ShipAddress = orderVM.ShipAddress; order.ShipPostalCode = orderVM.ShipPostalCode; order.InvoiceType = orderVM.InvoiceType; order.InvoiceInfo = orderVM.InvoiceInfo; order.UpdateTime = DateTime.UtcNow.AddHours(8); order.PaymentType = orderVM.PaymentType; order.PaymentState = orderVM.PaymentState; _dbRepository.Update(order); return(true); }
public BaseModel.BaseResult <OrderViewModel.OrderSingleResult> Edit(OrderViewModel.OrderSingleResult orderVM) { BaseModel.BaseResult <OrderViewModel.OrderSingleResult> result = new BaseModel.BaseResult <OrderViewModel.OrderSingleResult>(); result.Body = orderVM; try { result.IsSuccess = _orderService.Edit(orderVM); return(result); } catch (Exception ex) { result.Msg = ex.Message; result.IsSuccess = false; return(result); } }
public async Task <ActionResult <BaseModel.BaseResult <OrderViewModel.OrderSingleResult> > > DeleteOrder([FromBody] OrderViewModel.OrderSingleResult orderSingle) { _logger.LogWarning(2001, DateTime.Now.ToLongTimeString() + "Products控制器Delete方法被呼叫, by" + UriHelper.GetDisplayUrl(Request)); //確認前後端參數是否一致 var result = new BaseModel.BaseResult <OrderViewModel.OrderSingleResult>(); //刪除單一筆資料 var deleteOrder = await _orderService.DeleteOrder(orderSingle); result.Msg = deleteOrder; //刪除成功 或 錯誤訊息 if (result.Msg == "無匹配訂單") { result.IsSuccess = false; return(result); } else if (result.Msg == "刪除成功") { result.IsSuccess = true; return(result); } else { result.IsSuccess = false; return(result); } }
public async Task <ActionResult <BaseModel.BaseResult <OrderViewModel.OrderSingleResult> > > UpdateOrder([FromBody] OrderViewModel.OrderSingleResult orderSingle) { _logger.LogWarning(2001, DateTime.Now.ToLongTimeString() + "Products控制器PUT方法被呼叫-傳入的資料為:" + System.Text.Json.JsonSerializer.Serialize(orderSingle)); var result = new BaseModel.BaseResult <OrderViewModel.OrderSingleResult>(); var updateOrder = await _orderService.UpdateOrder(orderSingle); result.Msg = updateOrder; if (result.Msg == "查無此筆訂單") { result.IsSuccess = false; return(result); } else if (result.Msg == "更新成功") { result.IsSuccess = true; return(result); } else { result.IsSuccess = false; return(result); } }