// Create public int Create(FARM farmModel) { farmModel.Is_Deleted = false; db.FARMs.Add(farmModel); db.SaveChanges(); return(farmModel.Id_Farm); }
// Create public int Create(PRODUCT_KIND productKindModel) { productKindModel.Is_Deleted = false; db.PRODUCT_KIND.Add(productKindModel); db.SaveChanges(); return(productKindModel.Id_ProductKind); }
public void Create(PRODUCT model) { model.Is_Deleted = false; db.PRODUCTs.Add(model); db.SaveChanges(); }
// Create public int Create(SEED seedModel) { seedModel.Is_Deleted = false; db.SEEDs.Add(seedModel); db.SaveChanges(); return(seedModel.Id_Seed); }
// Create public int Create(SALE_OFFER saleOfferModel) { saleOfferModel.Is_Deleted = false; db.SALE_OFFER.Add(saleOfferModel); db.SaveChanges(); return(saleOfferModel.Id_SaleOffer); }
// Create public int Create(PRODUCT productModel) { productModel.Is_Deleted = false; db.PRODUCTs.Add(productModel); db.SaveChanges(); return(productModel.Id_Product); }
// Create public int Create(USER_AUTHENTICATION userAuthenModel) { userAuthenModel.Created_Date = DateTime.Now; userAuthenModel.Status_User = 1; db.USER_AUTHENTICATION.Add(userAuthenModel); db.SaveChanges(); return(userAuthenModel.Id_User); }
public int InsertUser(Register entity) { entity.UserAu.Created_Date = DateTime.Now; entity.UserAu.Status_User = false;//Chưa Hoạt Động entity.UserAu.Is_Deleted = false; db.USER_AUTHENTICATION.Add(entity.UserAu); db.SaveChanges(); return(db.USER_AUTHENTICATION.Max(x => x.Id_User)); }
public void GetAcceptResult(int transactionId) { var model = db.TRANSACTION_ORDER.Find(transactionId); // Recalculate PO remain. model.Transaction_Date = DateTime.Now; model.SALE_OFFER_DETAIL.SALE_OFFER.Remain_SaleQuantity -= model.Transaction_Mass; model.Id_StatusTrans = 13;//Status 13: "Đã Đồng ý". db.SaveChanges(); }
public int InsertTrader(Register entity) { entity.UserAu.Status_User = 0; entity.UserAu.Created_Date = DateTime.Now; entity.UserAu.Id_UserKind = 2; db.USER_AUTHENTICATION.Add(entity.UserAu); db.TRADERs.Add(entity.trader); db.SaveChanges(); return(entity.UserAu.Id_User); }
public bool Create(PRODUCT model) { try { model.Is_Deleted = false; db.PRODUCTs.Add(model); db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool Create(SEED seed) { try { seed.Is_Deleted = false; db.SEEDs.Add(seed); db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
// Create public int Create(PRODUCT_DETAIL productDetailModel) { try { productDetailModel.Is_Deleted = false; db.PRODUCT_DETAIL.Add(productDetailModel); db.SaveChanges(); } catch (Exception) { return(0); } return(productDetailModel.Id_ProductDetail); }
public void ExecuteHandler(string Command, int transactionId) { var model = db.TRANSACTION_ORDER.Find(transactionId); switch (Command) { case "Readied": model.Transaction_Date = DateTime.Now; model.Id_StatusTrans = 6; //Sẵn Sàng Giao Hàng db.SaveChanges(); break; case "Extend": model.Transaction_Date = DateTime.Now; model.Paying_Time += 3; model.Id_StatusTrans = 7;//Gia Hạn Giao Hàng model.SALE_OFFER_DETAIL.Fine = Convert.ToInt32(model.Transaction_Price * 0.1); model.Transaction_TotalMoney -= model.SALE_OFFER_DETAIL.Fine; db.SaveChanges(); break; case "NotReceived": model.Transaction_Date = DateTime.Now; if (model.Id_StatusTrans == 3) { model.Id_StatusTrans = 15; //model.Transaction_Date = DateTime.Now; model.PURCHASE_OFFER_DETAIL.PURCHASE_OFFER.TRADER.USER_AUTHENTICATION.Penalty -= 1; } else { model.Id_StatusTrans = 4; //Chưa Nhận Được Tiền } db.SaveChanges(); break; case "Cancel": model.Transaction_Date = DateTime.Now; if (model.Id_StatusTrans != 5) //Gia Hạn Giao Tiền { model.SALE_OFFER_DETAIL.SALE_OFFER.FARM.FARMER.USER_AUTHENTICATION.Penalty -= 1; } model.Id_StatusTrans = 16; //Bên Bán Hủy db.SaveChanges(); break; } }
public bool Update(TRADER trader) { var targetUpdate = db.TRADERs.Find(trader.Id_Trader); try { targetUpdate.Id_Trader = trader.Id_Trader; targetUpdate.Id_User = trader.Id_User; targetUpdate.Name_Trader = trader.Name_Trader; targetUpdate.Birthday_Trader = trader.Birthday_Trader; targetUpdate.Gender_Trader = trader.Gender_Trader; targetUpdate.Address_Trader = trader.Address_Trader; targetUpdate.Telephone_Trader = trader.Telephone_Trader; targetUpdate.Email_Trader = trader.Email_Trader; db.SaveChanges(); return(true); } catch (Exception e) { return(false); throw new Exception(e.Message); } }
public Boolean ConfirmReady(TRANSACTION_ORDER entity) { try { var TransOrder = db.TRANSACTION_ORDER.Find(entity.Id_TransactionOrder); TransOrder.Transaction_Date = DateTime.Today; TransOrder.Id_StatusTrans = 5;//"Sẵn Sàng Giao Hàng" db.SaveChanges(); return(true); } catch { return(false); } }
public void Insert(PurchaseOfferDTO model, int traderID) { PURCHASE_OFFER purchModel = new PURCHASE_OFFER(); purchModel.Date_PurchaseOffer = DateTime.Now; purchModel.Can_Bargain = model.canBargain; purchModel.Id_Trader = traderID; purchModel.Id_Product = model.productID; purchModel.Id_Seed = model.seedId; purchModel.Quantity_PurchaseOffer = model.quantity; purchModel.Id_MassUnit = model.unitId; purchModel.Price_Purchase = model.price; purchModel.Paying_Time = model.payingTime; purchModel.Delivering_Time = model.deliveringTime; purchModel.Is_Deleted = false; db.PURCHASE_OFFER.Add(purchModel); db.SaveChanges(); }
public int Insert(TRADER_REGISTER entity) { entity.UserAu.Status_User = 1; db.USER_AUTHENTICATION.Add(entity.UserAu); db.TRADERs.Add(entity.Trader); db.SaveChanges(); return(entity.UserAu.Id_User); }
public int Insert(SaleOfferDTO model) { SALE_OFFER saleModel = new SALE_OFFER(); saleModel.Date_SaleOffer = DateTime.Now; saleModel.Can_Bargain = model.canBargain; saleModel.Id_Farm = model.farmId; saleModel.Id_ProductDetail = model.productDetailId; saleModel.Quantity_SaleOffer = model.quantity; saleModel.Id_MassUnit = model.idUnit; saleModel.Price_Offer = model.price; saleModel.Paying_Time = model.payingTime; saleModel.Delivering_Time = model.deliveringTime; //db.SALE_OFFER.Add(saleOffer); db.SaveChanges(); return(1); }
public void ChangeScheduledTransactions() { IEnumerable <TRANSACTION_ORDER> transModel = db.TRANSACTION_ORDER.Where(x => x.Id_StatusTrans != 9 &&//Đã Nhận Được Hàng x.Id_StatusTrans != 10 &&//Mới Thiết Lập x.Id_StatusTrans != 11 &&//Bên Mua Đặt Lại x.Id_StatusTrans != 12 &&//Bên Bán Đặt Lại x.Id_StatusTrans != 14 &&//Đã Từ Chối x.Id_StatusTrans != 15 &&//Bên Mua Hủy x.Id_StatusTrans != 16 //Bên Bán Hủy ); DateTime expectedPayDate; foreach (var item in transModel) { expectedPayDate = item.Transaction_Date.Value.AddDays(Convert.ToInt32(item.Paying_Time)); if (expectedPayDate.Date < DateTime.Now.Date) { byte?newStatusID = ChangeStatus(item.Id_StatusTrans); item.Transaction_Date = DateTime.Now; item.Id_StatusTrans = newStatusID; if (item.Id_StatusTrans == 15) { item.PURCHASE_OFFER_DETAIL.PURCHASE_OFFER.TRADER.USER_AUTHENTICATION.Penalty -= 1; } if (item.Id_StatusTrans == 16) { item.SALE_OFFER_DETAIL.SALE_OFFER.FARM.FARMER.USER_AUTHENTICATION.Penalty -= 1; } db.SaveChanges(); } } db.SaveChanges(); }
public bool Delete(int id) { try { var user = db.USER_AUTHENTICATION.Find(id); db.USER_AUTHENTICATION.Remove(user); db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public Boolean Update(int userID, string newPassWord) { try { var user = db.USER_AUTHENTICATION.Find(userID); //user.Name_User = user.Name_User; //user.Id_User = user.Id_User; user.Password_User = newPassWord; db.SaveChanges(); return(true); } catch { return(false); } }
public void ExecuteHandler(string Command, int transactionId) { var model = db.TRANSACTION_ORDER.Find(transactionId); switch (Command) { case "Transfered": model.Transaction_Date = DateTime.Now; model.Id_StatusTrans = 1; //Đã Chuyển Tiền db.SaveChanges(); break; case "Extend": model.Transaction_Date = DateTime.Now; model.Paying_Time += 3; model.Id_StatusTrans = 4; //Gia Hạn Giao Tiền db.SaveChanges(); break; case "Delivered": model.Transaction_Date = DateTime.Now; model.Id_StatusTrans = 8; //Đã Nhận Được Hàng db.SaveChanges(); break; case "NotDelivered": model.Transaction_Date = DateTime.Now; model.Id_StatusTrans = 7; //Chưa Nhận Được Hàng db.SaveChanges(); break; case "Cancel": model.Transaction_Date = DateTime.Now; if (model.Id_StatusTrans != 6) { model.PURCHASE_OFFER_DETAIL.PURCHASE_OFFER.TRADER.USER_AUTHENTICATION.Penalty -= 1; } model.Id_StatusTrans = 14; //Chưa Nhận Được Hàng db.SaveChanges(); break; } }
public void ExecuteHandler(string Command, int transactionId) { var model = db.TRANSACTION_ORDER.Find(transactionId); switch (Command) { case "Transfered": model.Transaction_Date = DateTime.Now; model.Id_StatusTrans = 1; //Đã Chuyển Tiền db.SaveChanges(); break; case "Extend": model.Transaction_Date = DateTime.Now; model.Paying_Time += 3; model.Id_StatusTrans = 5; //Gia Hạn Giao Tiền db.SaveChanges(); break; //case "Delivered": // model.Transaction_Date = DateTime.Now; // model.Id_StatusTrans = 9;//Đã Nhận Được Hàng // db.SaveChanges(); // break; case "NotDelivered": model.Transaction_Date = DateTime.Now; model.Id_StatusTrans = 15; //hủy //model.SALE_OFFER_DETAIL.SALE_OFFER.FARM db.SaveChanges(); break; case "Cancel": model.Transaction_Date = DateTime.Now; if (model.Id_StatusTrans != 7) //Gia Hạn Giao Hàng { model.PURCHASE_OFFER_DETAIL.PURCHASE_OFFER.TRADER.USER_AUTHENTICATION.Penalty -= 1; } model.Id_StatusTrans = 15; //Bên Mua Hủy db.SaveChanges(); break; } }
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(); }
public int Insert(USER_AUTHENTICATION entity) { db.USER_AUTHENTICATION.Add(entity); db.SaveChanges(); return(entity.Id_User); }
public void Insert(TraderOrderDTO model, int idsaleOfferId, int userId, string counterOffered) { var saleModel = db.SALE_OFFER.Find(idsaleOfferId); var trader = db.TRADERs.Where(x => x.Id_User == userId); //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; foreach (var item in trader) { model.purchaseOffer.Id_Trader = item.Id_Trader; } db.PURCHASE_OFFER.Add(model.purchaseOffer); db.SaveChanges(); int poId = model.purchaseOffer.Id_PurchasesOffer; int soId = saleModel.Id_SaleOffer; int?Quantity = model.purchaseOffer.Quantity_PurchaseOffer; int?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", 10)); //"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", 9)); //"Mới Thiết Lập" } db.SaveChanges(); }