public IActionResult RemoveBillEntry(string weekBasketId, string productStockId)
{
TempWeekBasket tempWeekBasket = _context.TempsWeekBaskets.Include(x => x.AdherentStolon).ThenInclude(x => x.Adherent).Include(x => x.BillEntries).ThenInclude(x => x.ProductStock).ThenInclude(x => x.Product).First(x => x.Id.ToString() == weekBasketId);
tempWeekBasket.RetrieveProducts(_context);
BillEntry billEntry = tempWeekBasket.BillEntries.First(x => x.ProductId.ToString() == productStockId);
tempWeekBasket.BillEntries.Remove(billEntry);
_context.Remove(billEntry);
_context.SaveChanges();
return(JsonTmpWeekBasket());
}
public IActionResult ResetBasket(string basketId)
{
TempWeekBasket tempWeekBasket = _context.TempsWeekBaskets.Include(x => x.AdherentStolon).Include(x => x.AdherentStolon.Adherent).First(x => x.Id.ToString() == basketId);
ValidatedWeekBasket validatedWeekBasket = _context.ValidatedWeekBaskets.Include(x => x.AdherentStolon).Include(x => x.BillEntries).FirstOrDefault(x => x.AdherentStolon.AdherentId == tempWeekBasket.AdherentStolon.AdherentId);
if (validatedWeekBasket == null)
{
tempWeekBasket.BillEntries = new List <BillEntry>();
}
else
{
tempWeekBasket.BillEntries = new List <BillEntry>();
foreach (BillEntry billEntry in validatedWeekBasket.BillEntries.ToList())
{
tempWeekBasket.BillEntries.Add(billEntry.Clone());
}
}
tempWeekBasket.Validated = true;
_context.SaveChanges();
tempWeekBasket.RetrieveProducts(_context);
return(Json(tempWeekBasket));
}
public IActionResult ValidateBasket(string basketId)
{
var adherentStolon = GetActiveAdherentStolon();
Stolon stolon = GetCurrentStolon();
if (stolon.GetMode() == Stolon.Modes.DeliveryAndStockUpdate)
{
return(Redirect("Index"));
}
//TempWeekBasket tempWeekBasket = _context.TempsWeekBaskets.Include(x => x.BillEntries).Include(x => x.AdherentStolon).AsNoTracking().FirstOrDefault(x => x.Id.ToString() == basketId);
//tempWeekBasket.RetrieveProducts(_context);
ValidatedWeekBasket validatedWeekBasket = _context.ValidatedWeekBaskets.Include(x => x.AdherentStolon).ThenInclude(x => x.Adherent).Include(x => x.BillEntries).FirstOrDefault(x => x.AdherentStolonId == adherentStolon.Id);
if (validatedWeekBasket == null)
{
//First validation of the week
validatedWeekBasket = new ValidatedWeekBasket
{
BillEntries = new List <BillEntry>(),
AdherentStolon = adherentStolon
};
_context.Add(validatedWeekBasket);
_context.SaveChanges();
}
else
{
validatedWeekBasket.RetrieveProducts(_context);
}
TempWeekBasket tempWeekBasket = _context.TempsWeekBaskets.Include(x => x.BillEntries).Include(x => x.AdherentStolon).FirstOrDefault(x => x.Id.ToString() == basketId);
tempWeekBasket.RetrieveProducts(_context);
//TODO LOCK to prevent multi insert at this moment ?
if (tempWeekBasket.BillEntries.Any())
{
List <BillEntry> rejectedEntries = new List <BillEntry>();
//Sauvegarde des produits déja validés
List <BillEntry> previousBillEntries = validatedWeekBasket.BillEntries;
//On met le panier validé dans le même état que le temporaire
validatedWeekBasket.BillEntries = new List <BillEntry>();
foreach (BillEntry billEntry in tempWeekBasket.BillEntries.ToList())
{
validatedWeekBasket.BillEntries.Add(billEntry.Clone());
}
//Gestion de la suppression et du changement de quantité sur des billEntry existantes
foreach (BillEntry prevEntry in previousBillEntries)
{
BillEntry newEntry = validatedWeekBasket.BillEntries.FirstOrDefault(x => x.ProductStockId == prevEntry.ProductStockId);
ProductStockStolon productStock = _context.ProductsStocks.Include(x => x.Product).Include(x => x.AdherentStolon).Single(x => x.Id == prevEntry.ProductStockId);
if (newEntry == null)
{
//produit supprimé du panier
UpdateProductStock(productStock, prevEntry.Quantity);
}
else
{
int qtyDiff = newEntry.Quantity - prevEntry.Quantity;
decimal stepStock = productStock.RemainingStock;
if (productStock.Product.Type != Product.SellType.Piece)
{
//Actual remaining stock in terms of quantity step Kg/L for weight type products
stepStock = (productStock.RemainingStock / productStock.Product.QuantityStep) * 1000.0M;
}
if (stepStock < qtyDiff && productStock.Product.StockManagement != Product.StockType.Unlimited)
{
//Stock insuffisant, on supprime la nouvelle ligne et on garde l'ancienne
validatedWeekBasket.BillEntries.Remove(newEntry);
validatedWeekBasket.BillEntries.Add(prevEntry);
rejectedEntries.Add(newEntry);
}
else
{
UpdateProductStock(productStock, -qtyDiff);
//On supprime la bill entry précédente ( ancienne bill entry)
_context.BillEntrys.Remove(prevEntry);
}
}
}
//Gestion de l'ajout de produits
foreach (BillEntry newEntry in validatedWeekBasket.BillEntries.ToList())
{
BillEntry prevEntry = previousBillEntries.FirstOrDefault(x => x.ProductStockId == newEntry.ProductStockId);
if (prevEntry == null)
{
//Nouveau produit
ProductStockStolon productStock = _context.ProductsStocks.Include(x => x.Product).Include(x => x.AdherentStolon).Single(x => x.Id == newEntry.ProductStockId);
decimal stepStock = productStock.RemainingStock;
if (productStock.Product.Type != Product.SellType.Piece)
{
stepStock = (productStock.RemainingStock / productStock.Product.QuantityStep) * 1000.0M;
}
if (newEntry.Quantity <= stepStock || productStock.Product.StockManagement == Product.StockType.Unlimited)
{
//product.RemainingStock -= newEntry.Quantity;
UpdateProductStock(productStock, -newEntry.Quantity);
}
else
{
validatedWeekBasket.BillEntries.Remove(newEntry);
rejectedEntries.Add(newEntry);
}
}
}
_context.SaveChanges();
//On supprime toute les BillEntry du tempWeekBasket
_context.BillEntrys.RemoveRange(_context.BillEntrys.Where(x => x.TempWeekBasketId == tempWeekBasket.Id).ToList());
_context.SaveChanges();
//On met le panier temporaire dans le même état que le validé
foreach (BillEntry entry in validatedWeekBasket.BillEntries)
{
tempWeekBasket.BillEntries.Add(entry.Clone());
}
tempWeekBasket.Validated = true;
_context.SaveChanges();
//END LOCK TODO
//Recuperation du detail produit pour utilisation dans la Vue
validatedWeekBasket.RetrieveProducts(_context);
//Send email to user
string subject;
if (rejectedEntries.Count == 0)
{
subject = "Validation de votre panier de la semaine";
}
else
{
subject = "Validation partielle de votre panier de la semaine";
}
ValidationSummaryViewModel validationSummaryViewModel = new ValidationSummaryViewModel(adherentStolon, validatedWeekBasket, rejectedEntries)
{
Total = GetBasketPrice(validatedWeekBasket)
};
Services.AuthMessageSender.SendEmail(adherentStolon.Stolon.Label, validatedWeekBasket.AdherentStolon.Adherent.Email, validatedWeekBasket.AdherentStolon.Adherent.Name, subject, base.RenderPartialViewToString("Templates/ValidatedBasketTemplate", validationSummaryViewModel));
//Return view
return(View("ValidatedBasket", validationSummaryViewModel));
}
else
{
//On annule tout le contenu du panier
foreach (BillEntry entry in validatedWeekBasket.BillEntries)
{
ProductStockStolon productStock = _context.ProductsStocks.Include(x => x.Product).Include(x => x.AdherentStolon).Single(x => x.Id == entry.ProductStockId);
UpdateProductStock(productStock, entry.Quantity);
//entry.Product.RemainingStock += entry.Quantity;
}
_context.Remove(tempWeekBasket);
_context.Remove(validatedWeekBasket);
_context.SaveChanges();
//Il ne commande rien du tout
//On lui signale
Services.AuthMessageSender.SendEmail(stolon.Label, validatedWeekBasket.AdherentStolon.Adherent.Email, validatedWeekBasket.AdherentStolon.Adherent.Name, "Panier de la semaine annulé", base.RenderPartialViewToString("Templates/ValidatedBasketTemplate", null));
}
return(View("ValidatedBasket"));
}
