// 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();
}