public JsonResult PurchaseOfferListBySaleOfferID(int saleOfferId) { var saleList = new SaleOfferDetailDao().TransactionListByPurchaseOfferID(saleOfferId); List <TraderTransactionDTO> purchaseOfferDTOs = new List <TraderTransactionDTO>(); foreach (var p in saleList) { var TransactionOfferDTO = new TraderTransactionDTO(); TransactionOfferDTO.transId = p.Id_TransactionOrder; TransactionOfferDTO.endTransDay = ((DateTime)p.Transaction_Date).ToShortDateString(); TransactionOfferDTO.productName = p.SALE_OFFER_DETAIL.SALE_OFFER.PRODUCT_DETAIL.PRODUCT.Name_Product; TransactionOfferDTO.seedName = p.SALE_OFFER_DETAIL.SALE_OFFER.PRODUCT_DETAIL.SEED.Name_Seed; TransactionOfferDTO.traderName = p.PURCHASE_OFFER_DETAIL.PURCHASE_OFFER.TRADER.Name_Trader; TransactionOfferDTO.quantity = p.Transaction_Mass; TransactionOfferDTO.unitName = p.Transaction_Unitmass; TransactionOfferDTO.price = p.Transaction_Price; TransactionOfferDTO.totalMoney = p.Transaction_Mass * p.SALE_OFFER_DETAIL.SALE_OFFER.MASS_UNIT.Weight_To_Kg * p.Transaction_Price; TransactionOfferDTO.StatusName = p.STATUS_TRANS.Name_StatusTrans; purchaseOfferDTOs.Add(TransactionOfferDTO); } return(Json(purchaseOfferDTOs, JsonRequestBehavior.AllowGet)); }
public JsonResult GetListImportantTransaction() { var transactionList = dao.GetListTransaction(); List <TraderTransactionDTO> transactionDTOs = new List <TraderTransactionDTO>(); foreach (var p in transactionList) { var traderTransactionDTO = new TraderTransactionDTO(); traderTransactionDTO.transId = p.Id_TransactionOrder; traderTransactionDTO.endTransDay = ((DateTime)p.Transaction_Date).ToShortDateString(); traderTransactionDTO.productName = p.PRODUCT_DETAIL.PRODUCT.Name_Product; traderTransactionDTO.seedName = p.PRODUCT_DETAIL.SEED.Name_Seed; traderTransactionDTO.farmName = p.SALE_OFFER_DETAIL.SALE_OFFER.FARM.Name_Farm; traderTransactionDTO.farmerName = p.SALE_OFFER_DETAIL.SALE_OFFER.FARM.FARMER.Name_Farmer; traderTransactionDTO.price = p.Transaction_Price; traderTransactionDTO.quantity = p.Transaction_Mass; traderTransactionDTO.unitName = p.Transaction_Unitmass; traderTransactionDTO.totalMoney = p.Transaction_TotalMoney; traderTransactionDTO.StatusName = p.STATUS_TRANS.Name_StatusTrans; transactionDTOs.Add(traderTransactionDTO); } return(Json(new { data = transactionDTOs }, JsonRequestBehavior.AllowGet)); }