public ActionResult CreateOffer(FarmerOrderDTO model, int farmId, int purchaseOfferId, string counterOffered)
{
var dao = new FarmerOrderDao();
dao.Insert(model, farmId, purchaseOfferId, counterOffered);
return(RedirectToAction("FarmerOfferIndex", "FarmerOffer"));
}
// GET: Farmer/FarmerOrder
public ActionResult FarmerOrderIndex(int purchaseOfferId)
{
FarmerOrderDTO traderOrder = new FarmerOrderDTO();
traderOrder.purchaseOfferDetail = PurchaseOfferDetail(purchaseOfferId);
return(View(traderOrder));
}
public ActionResult CreateOffer(FarmerOrderDTO model, int saleOfferId, string counterOffered)
{
var userId = Convert.ToInt32(Session["UserID"]);
var dao = new FarmerOrderDao();
dao.Insert(model, saleOfferId, userId, counterOffered);
return(RedirectToAction("", "TraderOffer"));
}
public ActionResult FarmerOrderIndex(int purchaseOfferId)
{
var farmerId = Convert.ToInt32(Session["FarmerId"]);
FarmerOrderDTO farmerOrder = new FarmerOrderDTO();
farmerOrder.purchaseOfferDetail = PurchaseOfferDetail(purchaseOfferId);
var productId = farmerOrder.purchaseOfferDetail.Id_Product;
var seedId = farmerOrder.purchaseOfferDetail.Id_Seed;
farmerOrder.farms = FarmList(farmerId, productId, seedId);
farmerOrder.productDetailId = ProducDetail(productId, seedId).Id_ProductDetail;
return(View(farmerOrder));
}
public void Insert(FarmerOrderDTO model, int farmId, int purchaseOfferId, string counterOffered)
{
var purchaseModel = db.PURCHASE_OFFER.Find(purchaseOfferId);
//Assign value to Purchase Offer
model.saleOffer.Id_Farm = farmId;
model.saleOffer.Id_MassUnit = purchaseModel.Id_MassUnit;
model.saleOffer.Price_Offer = purchaseModel.Price_Purchase;
model.saleOffer.Can_Bargain = purchaseModel.Can_Bargain;
model.saleOffer.Date_SaleOffer = DateTime.Now;
model.saleOffer.Remain_SaleQuantity = 0;
model.saleOffer.Is_Deleted = false;
db.SALE_OFFER.Add(model.saleOffer);
db.SaveChanges();
int poId = purchaseModel.Id_PurchasesOffer;
int soId = model.saleOffer.Id_SaleOffer;
int?Quantity = model.saleOffer.Quantity_SaleOffer;
int?WTKg = purchaseModel.MASS_UNIT.Weight_To_Kg;
int?price = purchaseModel.Price_Purchase;
int?TotalMoney = Quantity * WTKg * price;
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", model.saleOffer.Id_ProductDetail),
new SqlParameter("@Transaction_Mass", Quantity),
new SqlParameter("@Transaction_Unitmass", purchaseModel.MASS_UNIT.Name_MassUnit),
new SqlParameter("@Transaction_Price", purchaseModel.Price_Purchase),
new SqlParameter("@Transaction_TotalMoney", TotalMoney),
new SqlParameter("@Paying_Time", model.saleOffer.Paying_Time),
new SqlParameter("@Delivering_Time", model.saleOffer.Delivering_Time),
new SqlParameter("@Id_StatusTrans", 12)); //"Bên Bán Đặ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", model.saleOffer.Id_ProductDetail),
new SqlParameter("@Transaction_Mass", Quantity),
new SqlParameter("@Transaction_Unitmass", purchaseModel.MASS_UNIT.Name_MassUnit),
new SqlParameter("@Transaction_Price", purchaseModel.Price_Purchase),
new SqlParameter("@Transaction_TotalMoney", TotalMoney),
new SqlParameter("@Paying_Time", model.saleOffer.Paying_Time),
new SqlParameter("@Delivering_Time", model.saleOffer.Delivering_Time),
new SqlParameter("@Id_StatusTrans", 10)); //"Mới Thiết Lập"
}
db.SaveChanges();
}