// GET: TraderOrder public ActionResult TraderOrderIndex(int saleOfferId) { TraderOrderDTO traderOrder = new TraderOrderDTO(); traderOrder.saleOfferDetail = SaleOfferDetail(saleOfferId); return(View(traderOrder)); }
public ActionResult CreateOffer(TraderOrderDTO model, int saleOfferId, string counterOffered) { var userId = Convert.ToInt32(Session["UserID"]); var dao = new OrderDao(); dao.Insert(model, saleOfferId, userId, counterOffered); return(RedirectToAction("", "TraderOffer")); }
public void Insert(TraderOrderDTO model, int idsaleOfferId, int traderId, string counterOffered) { var saleModel = db.SALE_OFFER.Find(idsaleOfferId); //Assign value to Purchase Offer model.purchaseOffer.Id_Product = saleModel.PRODUCT_DETAIL.Id_Product; model.purchaseOffer.Id_Seed = saleModel.PRODUCT_DETAIL.Id_Seed; model.purchaseOffer.Id_MassUnit = saleModel.Id_MassUnit; model.purchaseOffer.Price_Purchase = saleModel.Price_Offer; model.purchaseOffer.Can_Bargain = saleModel.Can_Bargain; model.purchaseOffer.Date_PurchaseOffer = DateTime.Now; model.purchaseOffer.Remain_PurchaseQuantity = 0; model.purchaseOffer.Is_Deleted = false; model.purchaseOffer.Id_Trader = traderId; db.PURCHASE_OFFER.Add(model.purchaseOffer); db.SaveChanges(); int poId = model.purchaseOffer.Id_PurchasesOffer; int soId = saleModel.Id_SaleOffer; double?Quantity = model.purchaseOffer.Quantity_PurchaseOffer; double?TotalMoney = Quantity * saleModel.MASS_UNIT.Weight_To_Kg * saleModel.Price_Offer; db.Database.ExecuteSqlCommand("EXEC CreatePurchaseDetail @Id_PurchasesOffer, @Quantity_PurchaseOfferDetail", new SqlParameter("@Id_PurchasesOffer", poId), new SqlParameter("@Quantity_PurchaseOfferDetail", Quantity)); db.Database.ExecuteSqlCommand("EXEC CreateSaleDetail @Id_SaleOffer, @Quantity_SaleOfferDetail", new SqlParameter("@Id_SaleOffer", soId), new SqlParameter("@Quantity_SaleOfferDetail", Quantity)); var soDetailId = db.SALE_OFFER_DETAIL.Max(x => x.Id_SaleOfferDetail); var poDetailId = db.PURCHASE_OFFER_DETAIL.Max(x => x.Id_PurchaseOfferDetail); if (counterOffered == "true") { db.Database.ExecuteSqlCommand("EXEC CreateTransactionOrder @Id_SaleOfferDetail,@Id_PurchaseOfferDetail,@Id_ProductDetail,@Transaction_Mass,@Transaction_Unitmass,@Transaction_Price,@Transaction_TotalMoney,@Paying_Time,@Delivering_Time,@Id_StatusTrans", new SqlParameter("@Id_SaleOfferDetail", soDetailId), new SqlParameter("@Id_PurchaseOfferDetail", poDetailId), new SqlParameter("@Id_ProductDetail", saleModel.Id_ProductDetail), new SqlParameter("@Transaction_Mass", Quantity), new SqlParameter("@Transaction_Unitmass", saleModel.MASS_UNIT.Name_MassUnit), new SqlParameter("@Transaction_Price", saleModel.Price_Offer), new SqlParameter("@Transaction_TotalMoney", TotalMoney), new SqlParameter("@Paying_Time", model.purchaseOffer.Paying_Time), new SqlParameter("@Delivering_Time", model.purchaseOffer.Delivering_Time), new SqlParameter("@Id_StatusTrans", 11)); //"Bên Mua Đặt Lại" } else { db.Database.ExecuteSqlCommand("EXEC CreateTransactionOrder @Id_SaleOfferDetail,@Id_PurchaseOfferDetail,@Id_ProductDetail,@Transaction_Mass,@Transaction_Unitmass,@Transaction_Price,@Transaction_TotalMoney,@Paying_Time,@Delivering_Time,@Id_StatusTrans", new SqlParameter("@Id_SaleOfferDetail", soDetailId), new SqlParameter("@Id_PurchaseOfferDetail", poDetailId), new SqlParameter("@Id_ProductDetail", saleModel.Id_ProductDetail), new SqlParameter("@Transaction_Mass", Quantity), new SqlParameter("@Transaction_Unitmass", saleModel.MASS_UNIT.Name_MassUnit), new SqlParameter("@Transaction_Price", saleModel.Price_Offer), new SqlParameter("@Transaction_TotalMoney", TotalMoney), new SqlParameter("@Paying_Time", model.purchaseOffer.Paying_Time), new SqlParameter("@Delivering_Time", model.purchaseOffer.Delivering_Time), new SqlParameter("@Id_StatusTrans", 10)); //"Mới Thiết Lập" } db.SaveChanges(); }