private static void SendReportToActor(MailAddress mailAddress, int requestOrderNumber)
{
// Retrieve order
var controller = new OrderDetailController();
var repository = new OrderDetailRepository();
var orderDetail = repository.GetOrderDetail(requestOrderNumber);
var mail = new MailMessage(ConfigurationManager.AppSettings["smtpFrom"], mailAddress.Address)
{
Subject = $"Report for order {orderDetail.OrderNumber}",
Body = $"Dear {mailAddress.DisplayName}, \n Your report for order {orderDetail.OrderNumber} is finished. \n\n{orderDetail}"
};
var client = new SmtpClient
{
Port = 25,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Host = ConfigurationManager.AppSettings["smtpHost"],
Credentials = new NetworkCredential(ConfigurationManager.AppSettings["smtpUsername"], ConfigurationManager.AppSettings["smtpPassword"]),
EnableSsl = true
};
client.Send(mail);
}
public HttpResponseMessage GetOrderDetailByID(HttpRequestMessage request, int ID)
{
OrderDetailRepository orderDetailRepo = new OrderDetailRepository();
tbOrderDetail result = orderDetailRepo.GetDataSet().Where(a => a.IsDeleted != true && a.ID == ID).FirstOrDefault();
return(request.CreateResponse <tbOrderDetail>(HttpStatusCode.OK, result));
}
private void button1_Click(object sender, EventArgs e)
{
int Qid = Convert.ToInt32(lblOrderID.Text);
var myOrder = db.Orders.FirstOrDefault(x => x.OrderID == Qid);
myOrder.PaymentStatusID = 1;
myOrder.FoodStatusID = 1;
db.SaveChanges();
//////////////////////////////////////////////////////////////////////
OrderDetail od = new OrderDetail();
int productid = Convert.ToInt32(lblpid.Text);
var myProduct = db.Products.FirstOrDefault(x => x.ProductID == productid);
od.OrderID = Qid;
od.ProductID = Convert.ToInt32(lblpid.Text);
decimal price = Convert.ToDecimal(myProduct.ProductPrice * numericUpDown1.Value);
od.Price = price;
OrderDetailRepository odr = new OrderDetailRepository();
odr.Add(od);
Bill bill = new Bill();
bill.CustomerID = myOrder.CustomerID;
bill.OrderID = myOrder.OrderID;
bill.BillAmount = price;
bill.CreatorID = myOrder.CreatorID;
BillRepository br = new BillRepository();
br.Add(bill);
}
public ShoppingController()
{
_oRep = new OrderRepository();
_odRep = new OrderDetailRepository();
_pRep = new ProductRepository();
_cRep = new CategoryRepository();
}
public static OrderDetailRepository GetOrderDetailRepository(IUnitOfWork unitOfWork)
{
var repository = new OrderDetailRepository();
repository.UnitOfWork = unitOfWork;
return(repository);
}
public static bool ModifyOrderDetail(OrderDetailEntity entity)
{
long result = 0;
if (entity != null)
{
OrderDetailRepository mr = new OrderDetailRepository();
OrderDetailInfo OrderDetailInfo = TranslateOrderDetailInfo(entity);
if (entity.ID > 0)
{
OrderDetailInfo.ID = entity.ID;
OrderDetailInfo.ChangeDate = DateTime.Now;
result = mr.ModifyOrderDetail(OrderDetailInfo);
}
else
{
OrderDetailInfo.ChangeDate = DateTime.Now;
OrderDetailInfo.CreateDate = DateTime.Now;
result = mr.CreateNew(OrderDetailInfo);
}
List <OrderDetailInfo> miList = mr.GetAllOrderDetail();//刷新缓存
Cache.Add("OrderDetailALL", miList);
}
return(result > 0);
}
public static OrderDetailRepository GetOrderDetailRepository()
{
var repository = new OrderDetailRepository();
repository.UnitOfWork = GetUnitOfWork();
return(repository);
}
public OrderDetailServiceImpl(OrderDetailRepository orderDetailRepository, OrderDetailMaker orderDetailMaker, OrderRepository orderRepo, MenuRepository menuRepository)
{
_orderDetailMaker = orderDetailMaker;
_orderDetailRepo = orderDetailRepository;
_orderRepo = orderRepo;
_menuRepository = menuRepository;
}
public MemberController()
{
prep = new ProductRepository();
crep = new CategoryRepository();
orep = new OrderRepository();
odrep = new OrderDetailRepository();
}
public AccountController()
{
appRep = new AppUserRepository();
oRep = new OrderRepository();
odRep = new OrderDetailRepository();
uRep = new UserProfileRepository();
}
public OrderController()
{
oRep = new OrderRepository();
aRep = new AppUserRepository();
sRep = new ShipperRepository();
odRep = new OrderDetailRepository();
}
public OrderDetail Get(int orderId, int retailerChainId)
{
log.Info(string.Format(LogMessages.RequestMethod, RequestContext.Principal.Identity.Name, $"orderdetail\\get?orderId={orderId}&retailerChainId={retailerChainId}"));
OrderDetailRepository repository = new OrderDetailRepository();
return(repository.GetOrderDetail(orderId, retailerChainId));
}
public async Task <Page <OrderDetail> > QueryOrderDetailByCustomerNoByPage(int pageNumber, int pageSize, string customerNo)
{
var page = new Pageable(pageNumber, pageSize);
var result = await OrderDetailRepository.GetOrderDetailByCustomerNoByPageAsync(page, customerNo);
return(result);
}
public LUCsForOrder GetLUCsForOrder(int orderId)
{
log.Info(string.Format(LogMessages.RequestMethod, RequestContext.Principal.Identity.Name, $"orderdetail\\LoadUnitConditionsForOrder?orderId={orderId}"));
OrderDetailRepository repository = new OrderDetailRepository();
return(repository.GetSSCCLUCsForOrder(orderId));
}
public OrderService()
{
_orderRepository = new OrderRepository();
_orderDetailRepository = new OrderDetailRepository();
_customerRepository = new CustomerRepository();
_employeeRepository = new EmployeeRepository();
}
public UnitOfWork(NorthwindContext context)
{
_context = context;
Orders = new OrderRepository(_context);
Customers = new CustomerRepository(_context);
OrderDetails = new OrderDetailRepository(_context);
}
public bool InsertOrderDetail(int orderId, int userId)
{
var shoppingCartDetails = new ShoppingCartService().GetShoppingCartDetail(userId);
var orderDetails = new List <OrderDetail>();
foreach (var item in shoppingCartDetails)
{
orderDetails.Add(new OrderDetail()
{
Price = item.Price,
Quantity = item.Quantity,
OrderId = orderId,
ProductId = item.ProductId,
Title = item.Title,
Author = item.Author,
Image = item.Image,
Detail = item.Detail,
Isbn = item.Isbn,
CategoryName = item.CategoryName
});
}
var orderDetailRepository = new OrderDetailRepository();
return(orderDetailRepository.InsertOrderDetail(orderDetails, orderId));
}
public List <OrderDetailModel> GetByOrderId(int orderId)
{
var orderDetailRepository = new OrderDetailRepository().GetByOrderId(orderId);
var model = new List <OrderDetailModel>();
foreach (var item in orderDetailRepository)
{
var orderDetailModel = new OrderDetailModel();
orderDetailModel.Title = item.Title;
orderDetailModel.Author = item.Author;
orderDetailModel.CategoryName = item.CategoryName;
orderDetailModel.Detail = item.Detail;
orderDetailModel.Image = item.Image;
orderDetailModel.Isbn = item.Isbn;
orderDetailModel.OrderId = item.OrderId;
orderDetailModel.Price = item.Price;
orderDetailModel.ProductId = item.ProductId;
orderDetailModel.Quantity = item.Quantity;
orderDetailModel.OrderDate = item.Order.TimeStamp;
orderDetailModel.FirstName = item.Order.User.FirstName;
orderDetailModel.LastName = item.Order.User.LastName;
orderDetailModel.Address = item.Order.User.Address;
orderDetailModel.UserId = item.Order.UserId;
model.Add(orderDetailModel);
}
return(model);
}
public OrderDetailService(
OrderDetailRepository orderDetailRepository,
TicketService ticketService)
{
_orderDetailRepository = orderDetailRepository;
_ticketService = ticketService;
}
public async Task <IActionResult> AddOrder([FromBody] AddOrderDto dto)
{
if (dto?.ProductList == null)
{
return(BadRequest("参数不能为空"));
}
Uow.BeginTransaction();
try
{
var orderHeader = new OrderHeader
{
CreateTime = DateTime.UtcNow,
CustomerNo = dto.CustomerNo,
State = 1,
OrderNo = Guid.NewGuid().ToString("N")
};
await OrderHeaderRepository.InsertAsync(orderHeader);
var orderDetailList = new List <OrderDetail>();
//总消费金额
var totalAmount = 0m;
dto.ProductList.ForEach(it =>
{
var orderDetail = new OrderDetail
{
OrderHeaderId = orderHeader.Id,
ProductNo = it.ProductNo,
ProductName = it.ProductName,
Quantity = it.Quantity,
Price = it.Price
};
orderDetailList.Add(orderDetail);
totalAmount += it.Quantity * it.Price;
});
await OrderDetailRepository.BatchInsertAsync(orderDetailList);
//更新用户消费金额
var success = await CustomerRepository.UpdateCustomerAmount(dto.CustomerNo, totalAmount);
if (!success)
{
Uow.RollBack();
return(BadRequest());
}
}
catch (Exception e)
{
Uow.RollBack();
}
Uow.Commit();
return(Ok());
}
private void Save(bool submit)
{
try
{
if (!CheckData())
{
return;
}
_projectDataContext = new ProjectDataContext();
_orderRepository = new OrderRepository(_projectDataContext);
_orderDetailRepository = new OrderDetailRepository(_projectDataContext);
_productRepository = new ProductRepository(_projectDataContext);
//Table Order
Order order = new Order();
order.OrderDate = dtpOrderDate.Value;
order.CarNumberOrder = txtCarNumberOrder.Text.Trim();
order.UseCarStatus = (chkCompany.Checked ? GlobalConstants.UseCarStatusValue.Company : GlobalConstants.UseCarStatusValue.Agency);
order.Total = float.Parse(txtTongTienChuaBaoGomVAT.Text);
order.VAT = (float)txtVAT.Value;
order.VATMoney = float.Parse(txtTienVAT.Text);
order.ProcessingCarStatus = GlobalConstants.ProcessingCarStatusValue.None;
order.ProcessingStatus = (submit ? GlobalConstants.ProcessingStatusValue.WaitApprove : GlobalConstants.ProcessingStatusValue.None);
_orderRepository.Save(order);
txtOrderNo.Text = _orderRepository.id;
for (int i = 0; i < viewDuLieu.RowCount; i++)
{
//Table OrderDetail
OrderDetail orderDetail = new OrderDetail();
orderDetail.OrderId = txtOrderNo.Text;
orderDetail.ItemId = viewDuLieu.GetRowCellValue(i, "ProductId").ToString();
orderDetail.Quantity = float.Parse(viewDuLieu.GetRowCellValue(i, "Quantity").ToString());
orderDetail.Price = float.Parse(viewDuLieu.GetRowCellValue(i, "Price").ToString());
orderDetail.Discount = 0;
orderDetail.DiscountMoney = 0;
_orderDetailRepository.Save(orderDetail);
//Table Product
_productRepository.CaculateRemainVirtual(viewDuLieu.GetRowCellValue(i, "ProductId").ToString(), float.Parse(viewDuLieu.GetRowCellValue(i, "Quantity").ToString()));
}
UnitOfWork productOfWork = new UnitOfWork(_projectDataContext);
int result = productOfWork.Complete();
if (result > 0)
{
XtraMessageBox.Show(LanguageTranslate.ChangeLanguageText("Lưu thành công"), LanguageTranslate.ChangeLanguageText("Thông báo"));
Clear();
}
else
{
XtraMessageBox.Show(LanguageTranslate.ChangeLanguageText("Lưu thất bại"), LanguageTranslate.ChangeLanguageText("Thông báo"), MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
catch (Exception ex)
{
XtraMessageBox.Show(LanguageTranslate.ChangeLanguageText("Lưu thất bại"), LanguageTranslate.ChangeLanguageText("Thông báo"), MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
public OrderInfoViewModel(ReportViewModel reportViewModel)
{
_reportViewModel = reportViewModel;
_orderDetailRepositary = new OrderDetailRepository(_connectionString);
OrderList = _orderDetailRepositary.GetOrderDetail(_reportViewModel.SelectedBill.Order);
OrderNumber = _reportViewModel.SelectedBill.Id;
Total = _reportViewModel.SelectedBill.Total;
}
public HttpResponseMessage GetOrderDetailByVoucherCode(HttpRequestMessage request, string voucherCode)
{
Context ctx = new Context();
OrderDetailRepository orderDetailRepo = new OrderDetailRepository(ctx);
List <tbOrderDetail> result = orderDetailRepo.GetDataSet().Where(a => a.IsDeleted != true && a.VoucherCode == voucherCode).ToList();
return(request.CreateResponse <List <tbOrderDetail> >(HttpStatusCode.OK, result));
}
public UnitOfWork(ApplicationDbContext context)
{
_context = context;
UsersR = new UserRepository(_context);
ReaderR = new ReaderRepository(_context);
OrderR = new OrderRepository(_context);
OrderDetailR = new OrderDetailRepository(_context);
}
public ShoppingController()
{
oRep = new OrderRepository();
pRep = new ProductRepository();
cRep = new CategoryRepository();
odRep = new OrderDetailRepository();
paRep = new PARepository();
}
public ShoppingCartController()
{
this.httpClient = new HttpClient();
this.cartRepository = new CartRepository(new ExcursionContext());
this.orderRepository = new OrderRepository(new ExcursionContext());
this.orderDetailRepository = new OrderDetailRepository(new ExcursionContext());
//this.sortieParSemaineRepository = new SortieParSemaineRepository(new ExcursionContext());
}
public ShoppingController()
{
pRep = new ProductRepository();
cRep = new CategoryRepository();
oRep = new OrderRepository();
odRep = new OrderDetailRepository();
sRep = new ShipperRepository();
}
public MemberController()
{
cRep = new CategoryRepository();
pcRep = new ProductCategoryRepository();
pRep = new ProductRepository();
oRep = new OrderRepository();
odRep = new OrderDetailRepository();
}
public ShoppingCart()
{
this.httpClient = new HttpClient();
this.cartRepository = new CartRepository(new ExcursionContext());
this.excursionnRepository = new ExcursionnRepository(new ExcursionContext());
this.orderRepository = new OrderRepository(new ExcursionContext());
this.orderDetailRepository = new OrderDetailRepository(new ExcursionContext());
}
public override void OnActionExecuting(HttpActionContext context)
{
OrderDetailRepository orderDetail = new OrderDetailRepository(new MyRoomDbContext());
bool hasOrders = orderDetail.HasOrderDetail((int)context.ActionArguments["key"]);
if (hasOrders)
throw new HttpResponseException(context.Request.CreateErrorResponse(HttpStatusCode.NotAcceptable, "The Product has Orders Details"));
}
public OrderDetailService(
OrderDetailRepository orderDetailRepository,
TicketService ticketService,
TicketRuleRepository ticketRuleRepository)
{
_orderDetailRepository = orderDetailRepository;
_ticketService = ticketService;
_ticketRuleRepository = ticketRuleRepository;
}
