public ActionResult CreateAchat(Achat achat, FormCollection collection)
{
if (ModelState.IsValid)
{
try
{
var four = fourni.FindFourByID(achat.Id_fournisseur);
//achat.Date_d_achat = System.DateTime.Now;
achat.idDelegation = four.idDelegation;
db.Achat.Add(achat);
db.SaveChanges();
return(RedirectToAction("GetAchat"));
}
catch (Exception ex)
{
LogThread.WriteLine(ex.Message);
return(RedirectToAction("Index", "Error"));
}
}
else
{
ViewData["region"] = new SelectList(BissInventaireEntities.Instance.Region.ToList(), "idRegion", "libelle");
ViewData["pays"] = new SelectList(BissInventaireEntities.Instance.Pays.ToList(), "idPays", "libelle");
ViewData["delegations"] = new SelectList(BissInventaireEntities.Instance.Delegation.ToList(), "idDelegation", "libelle");
ViewData["gouvers"] = new SelectList(BissInventaireEntities.Instance.Gouvernorat.ToList(), "idGouvernorat", "libelle");
ViewData["fournisseurs"] = new SelectList(BissInventaireEntities.Instance.Fournisseur.ToList(), "Id_fournisseur", "Nom");
ViewData["contratgar"] = new SelectList(BissInventaireEntities.Instance.Contrat.ToList(), "Id_contrat_garanti", "Num");
ViewData["achats"] = new SelectList(BissInventaireEntities.Instance.Achat.ToList(), "Id_achat", "Num_facture");
return(View());
}
}
public static fsg_gpao.Acteurs.Achat GetAchat(int id)
{
Achat V = new Achat();
try
{
Connexion con = new Connexion();
con.OpenConnection();
string req = " SELECT id, idProduit, nbex, prix, remise FROM achat WHERE id =" + id;
MySqlCommand cmd = new MySqlCommand(req, con.connexion);
MySqlDataReader dt = cmd.ExecuteReader();
while (dt.Read())
{
V.ID = dt.GetInt16(0);
V.IDPRODUIT = dt.GetInt16(1);
V.NBEX = dt.GetInt16(2);
V.PRIX = dt.GetInt16(3);
V.REMISE = dt.GetInt16(4);
}
con.CloseConnection();
return(V);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(null);
}
}
public async Task <ActionResult> Create([Bind(Include = "ID,Des,Categ,DtAcha,Creation,LieuLiv,Imp,Qte,Type")] Achat achat)
{
ApplicationUser current = db.Users.Where(u => u.UserName == User.Identity.Name).First();
achat.DepartmentID = current.DepartmentID;
if (ModelState.IsValid)
{
db.Achats.Add(achat);
await db.SaveChangesAsync();
AchatInNotification notif = new AchatInNotification();
notif.AchatID = achat.ID;
notif.NotificationID = 1;
notif.State = false;
notif.DtNotif = DateTime.Now;
db.AchatInNotification.Add(notif);
return(RedirectToAction("Index"));
}
ViewBag.Categ = new SelectList(db.Categories, "Lbl", "Lbl", achat.Categ);
ViewBag.depd = current.Department.Budget;
ViewBag.depdt = current.Department.Depense;
return(View(achat));
}
public async Task <IActionResult> Edit(long id, [Bind("AchatId,ClientID,DateAchat")] Achat achat)
{
if (id != achat.AchatId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(achat);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AchatExists(achat.AchatId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ClientID"] = new SelectList(_context.Client, "ClientId", "ClientName", achat.ClientID);
return(View(achat));
}
public async void UpdateStockageOliveBeforeDeleteAchat(Achat achat)
{
AllHuileUpdateTwo = 0; AllPrixUnitaireUpdateTwo = 0; sommeAllAchatUpdateTwo = 0;
achatsUpdateTwo.Clear();
achatsUpdateTwo = await _context.Achats.AsNoTracking().Where(c => c.Trituration.VarieteId == achat.Trituration.VarieteId).ToListAsync();
produitHuilleTwo = null;
produitHuilleTwo = await _context.ProduitHuilles.SingleOrDefaultAsync(c => c.VarieteId == achat.Trituration.VarieteId);
if (achatsUpdateTwo != null || achatsUpdateTwo.Count != 0)
{
foreach (var achato in achatsUpdateTwo)
{
AllHuileUpdateTwo = AllHuileUpdateTwo + achato.QteAchete;
sommeAllAchatUpdateTwo = sommeAllAchatUpdateTwo + achato.MontantAchat;
}
if (sommeAllAchatUpdateTwo == 0)
{
produitHuilleTwo.Qte_En_Stock = 0;
produitHuilleTwo.Prix_unitaire = 0;
_context.Entry(produitHuilleTwo).State = EntityState.Modified;
_context.SaveChanges();
}
AllPrixUnitaireUpdateTwo = sommeAllAchatUpdateTwo / AllHuileUpdateTwo;
produitHuilleTwo.Qte_En_Stock = produitHuilleTwo.Qte_En_Stock - achat.QteAchete;
produitHuilleTwo.Prix_unitaire = AllPrixUnitaireUpdateTwo;
_context.Entry(produitHuilleTwo).State = EntityState.Modified;
_context.SaveChanges();
}
}
public async Task InsertAchatAsync(Achat achat)
{
_context.Achats.Add(achat);
_context.SaveChanges();
triturationUpdate = null;
triturationUpdate = await _context.Triturations.SingleOrDefaultAsync(c => c.Id == achat.TriturationId);
triturationUpdate.HuileRestante = triturationUpdate.HuileRestante - achat.QteAchete;
_context.Entry(triturationUpdate).State = EntityState.Modified;
AllHuile = 0; AllPrixUnitaire = 0; sommeAllAchat = 0;
achats.Clear();
achats = await _context.Achats.AsNoTracking().Where(c => c.Trituration.VarieteId == achat.Trituration.VarieteId).ToListAsync();
foreach (var achato in achats)
{
AllHuile = AllHuile + achato.QteAchete;
sommeAllAchat = sommeAllAchat + achato.MontantAchat;
}
AllPrixUnitaire = sommeAllAchat / AllHuile;
produitHuile = null;
produitHuile = await _context.ProduitHuilles.AsNoTracking().SingleOrDefaultAsync(c => c.VarieteId == achat.Trituration.VarieteId);
produitHuile.Qte_En_Stock = produitHuile.Qte_En_Stock + achat.QteAchete;
produitHuile.Prix_unitaire = AllPrixUnitaire;
_context.ProduitHuilles.Attach(produitHuile);
_context.Entry(produitHuile).State = EntityState.Modified;
await SaveAsync();
}
public async Task UpdateAchatAsync(Achat achat, Trituration triturationUpdate)
{
AllHuileUpdateOne = 0; AllPrixUnitaireUpdateOne = 0; sommeAllAchatUpdateOne = 0;
achatUpdateOne = await _context.Achats.AsNoTracking().SingleOrDefaultAsync(i => i.Id == achat.Id);
triturationUpdate.HuileRestante = triturationUpdate.HuileRestante + achatUpdateOne.QteAchete;
if (triturationUpdate.HuileRestante >= achat.QteAchete)
{
triturationUpdate.HuileRestante = triturationUpdate.HuileRestante - achat.QteAchete;
_context.Entry(triturationUpdate).State = EntityState.Modified;
_context.Entry(achat).State = EntityState.Modified;
_context.SaveChanges();
achatsUpdateOne.Clear();
achatsUpdateOne = await _context.Achats.Include(c => c.Trituration).Where(c => c.Trituration.VarieteId == achat.Trituration.VarieteId).ToListAsync();
produitHuilleUpdate = null;
produitHuilleUpdate = await _context.ProduitHuilles.SingleOrDefaultAsync(c => c.VarieteId == achat.Trituration.VarieteId);
produitHuilleUpdate.Qte_En_Stock = produitHuilleUpdate.Qte_En_Stock - achatUpdateOne.QteAchete;
produitHuilleUpdate.Qte_En_Stock = produitHuilleUpdate.Qte_En_Stock + achat.QteAchete;
foreach (var achato in achatsUpdateOne)
{
AllHuileUpdateOne = AllHuileUpdateOne + achato.QteAchete;
sommeAllAchatUpdateOne = sommeAllAchatUpdateOne + achato.MontantAchat;
}
AllPrixUnitaireUpdateOne = sommeAllAchatUpdateOne / AllHuileUpdateOne;
produitHuilleUpdate.Prix_unitaire = AllPrixUnitaireUpdateOne;
_context.Entry(produitHuilleUpdate).State = EntityState.Modified;
_context.SaveChanges();
}
await SaveAsync();
}
public async Task <ActionResult> Submit(int?id, string lbl)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Achat achat = await db.Achats.FindAsync(id);
if (achat == null)
{
return(HttpNotFound());
}
achat.State = StateDemande.DemandeAConfirmerFournisseur;
db.Entry(achat).State = EntityState.Modified;
await db.SaveChangesAsync();
Notification notif = new Notification {
AchatID = achat.ID, Role = SecurityRole.Demandeur, Lbl = "vous devez saisir votre avis technique et choisir un fournisseur Pour la Demande : " + achat.Des
};
db.Notifications.Add(notif);
ApplicationUser current = db.Users.Where(u => u.UserName == User.Identity.Name).First();
var A = new Models.Avis {
AchatID = achat.ID, Accept = true, Lbl = lbl, User = current, Code = AvisCode.init
};
db.Avis.Add(A);
await db.SaveChangesAsync();
return(RedirectToAction("Detail", new { id = achat.ID }));
}
public async Task <ActionResult> Detail(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Achat achat = await db.Achats.FindAsync(id);
if (achat == null)
{
return(HttpNotFound());
}
var four = db.CategoryInFournisseur.Where(c => c.Category.Lbl == achat.Categ).Select(f => f.Fournisseur).Distinct().ToList();
var af = db.AchaFournisseurs.Where(a => a.AchatID == achat.ID).ToList();
var av = db.Avis.Where(a => a.AchatID == achat.ID).ToList();
ViewBag.FournisseurID = new SelectList(four, "ID", "Nom_frn");
return(View(new Demande {
Achat = achat, AF = af, Avis = av
}));
}
public async Task <ActionResult> Reject(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Achat achat = await db.Achats.FindAsync(id);
if (achat == null)
{
return(HttpNotFound());
}
achat.State = StateDemande.BesoinRefuser;
ApplicationUser current = db.Users.Where(u => u.UserName == User.Identity.Name).First();
Notification notif = new Notification {
Achat = achat, Lbl = "Demande Refuser Par : " + current.Login, Role = SecurityRole.Demandeur
};
db.Entry(achat).State = EntityState.Modified;
db.Notifications.Add(notif);
await db.SaveChangesAsync();
return(RedirectToAction("IndexDem"));
}
private void btnImprimer_Click(object sender, EventArgs e)
{
List <ImpAchat> item = new List <ImpAchat>();
for (int i = 0; i < dataGridViewa.Rows.Count; i++)
{
Achat A = dataGridViewa.Rows[i].DataBoundItem as Achat;
item.Add
(
new ImpAchat
(
A.Code,
A.Designation,
A.Quantite,
A.Fournisseur,
A.Nfacture
)
);
}
Form f = new FrmPrint("PRINT.rdlc", item);
f.Show();
}
public ActionResult DeleteConfirmed(int id)
{
Achat achat = db.Achat.Find(id);
db.Achat.Remove(achat);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public FrmAchat(Achat achat, Action callback) : this(callback)
{
this.oldachat = achat;
txtCode.Text = achat.Code;
txtDesignation.Text = achat.Designation;
txtFournisseur.Text = achat.Designation;
txtQuantite.Text = achat.Quantite.ToString();
}
public async void UpdateTriturationBeforeDeleteAchat(Achat achat)
{
var triturationUpdate = await _context.Triturations.SingleOrDefaultAsync(c => c.Id == achat.TriturationId);
triturationUpdate.HuileRestante = triturationUpdate.HuileRestante + achat.QteAchete;
_context.Entry(triturationUpdate).State = EntityState.Modified;
_context.SaveChanges();
}
public string Put(Achat achat)
{
if (AchatDAO.Update(achat))
{
return("OK");
}
return("NOT_PUT");
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Achat achat = await db.Achats.FindAsync(id);
db.Achats.Remove(achat);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
Achat achat = db.Achat.Find(id);
db.Achat.Remove(achat);
db.SaveChanges();
var userID = User.Identity.GetUserId();
return(RedirectToAction("Panier", new { userId = userID }));
}
public async Task <IActionResult> PostAchat([FromBody] Achat achat)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
await _achatService.InsertAchatAsync(achat);
}
catch (Exception ex)
{
return(StatusCode(500, ex));
}
return(CreatedAtAction("GetAchat", new { id = achat.Id }, achat));
//var triturationUpdate = new Trituration();
//var stokageHuile = new ProduitHuille();
//int AllHuile = 0;
//float AllPrixUnitaire = 0;
//float sommeAllAchat = 0;
//_context.Achats.Add(achat);
//var etriturationUpdate = _context.Triturations.SingleOrDefault(c => c.Id == achat.TriturationId);
//if (triturationUpdate == null)
//{
// return BadRequest(ModelState);
//}
//etriturationUpdate.HuileRestante = etriturationUpdate.HuileRestante - achat.QteAchete;
//_context.Triturations.Attach(etriturationUpdate);
//_context.Entry(etriturationUpdate).Property(x => x.HuileRestante).IsModified = true;
//await _context.SaveChangesAsync();
////////////////////////// Stockage Huile ////////////////////////
//var achats = await _context.Achats.Where(c => c.Trituration.VarieteId == achat.Trituration.VarieteId).ToListAsync();
//foreach (var achato in achats)
//{
// AllHuile = AllHuile + achato.QteAchete;
// sommeAllAchat = sommeAllAchat + achato.MontantAchat;
//}
//AllPrixUnitaire = sommeAllAchat / AllHuile;
//var StockProduithuile = _context.ProduitHuilles.SingleOrDefault(c => c.VarieteId == achat.Trituration.VarieteId);
//StockProduithuile.Qte_En_Stock = StockProduithuile.Qte_En_Stock + achat.QteAchete;
//StockProduithuile.Prix_unitaire = AllPrixUnitaire;
//_context.ProduitHuilles.Attach(StockProduithuile);
//_context.Entry(StockProduithuile).Property(x => x.Qte_En_Stock).IsModified = true;
//_context.Entry(StockProduithuile).Property(x => x.Prix_unitaire).IsModified = true;
//await _context.SaveChangesAsync();
//return CreatedAtAction("GetAchat", new { id = achat.Id }, achat);
}
public ActionResult Edit(AchatCreateVM achat)
{
if (ModelState.IsValid)
{
StockManager stockManager = new StockManager(db);
Achat oldAchat = db.Achats.Where(v => v.Id == achat.ID).Include(v => v.Details.Select(d => d.Produit)).First();
//Restitution du stock
foreach (var detail in oldAchat.Details)
{
stockManager.RemoveStock(detail.ProduitID.Value, detail.QuantiteAchetee, OperationType.Vente);
}
//Annulation des reglements
var caisseManager = new CaisseManager(db);
caisseManager.AnnulerReglementsAchat(oldAchat, "suppression");
//Suppression des anciens details
oldAchat.Montant = 0;
oldAchat.Montant = achat.MontantPaye;
oldAchat.UserId = User.Identity.GetUserId();
for (int i = 0; i < oldAchat.Details.Count; i++)
{
db.DetailsAchat.Remove(oldAchat.Details[i]);
}
db.SaveChanges();
//Enregistrement des nouveaux details commande
double total = 0;
foreach (var detail in achat.Details)
{
if (detail.Quantite > 0)
{
oldAchat.Details.Add(new DetailAchat()
{
Produit = db.Produits.Find(detail.ProduitId),
QuantiteAchetee = detail.Quantite,
ProduitID = detail.ProduitId,
ID = Guid.NewGuid(),
PrixAchat = db.Produits.Find(detail.ProduitId).PrixAchat
});
}
//Sortie de stock
stockManager.AddStock(detail.ProduitId, detail.Quantite, OperationType.Achat);
total += detail.Quantite * db.Produits.Find(detail.ProduitId).PrixVente;
}
//Reglements
oldAchat.Montant = total;
//oldAchat.MontantRestant = total;
db.SaveChanges();
//caisseManager.reglerAchat(achat.MontantPaye, oldAchat, "Paiement de vente");
//return RedirectToAction("Confirmer", new { id = oldAchat.Id });
}
//ViewBag.ClientId = new SelectList(db.Clients, "ID", "Nom", achat.ClientId);
return(RedirectToAction("Index"));
}
public int Ajouter(Achat model)
{
try
{
return(Gestion.Ajouter(model.IdStock, model.Prix, model.Quantite, model.IdCommande));
}
catch (Exception e)
{
throw new Exception("Impossible d'ajouter l'achat : \n" + e.Message);
}
}
public int Modifier(Achat model)
{
try
{
return(Gestion.Modifier(model.Id, model.IdStock, model.Prix, model.Quantite, model.IdCommande));
}
catch (Exception e)
{
throw new Exception($"Impossible de modifier l'achat {model.Id} : \n" + e.Message);
}
}
public void Add(Achat achat)
{
var index = achats.IndexOf(achat);
if (index >= 0)
{
throw new DuplicateNameException("Le code de produit existe deja !");
}
achats.Add(achat);
Save();
}
public ActionResult Edit([Bind(Include = "IDAchat,Date_Achat,Prix,IDVelo,IDFournisseur")] Achat achat)
{
if (ModelState.IsValid)
{
db.Entry(achat).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.IDFournisseur = new SelectList(db.Fournisseur, "IDFournisseur", "Nom_Fournisseur", achat.IDFournisseur);
ViewBag.IDVelo = new SelectList(db.Velo, "IDVelo", "Marque", achat.IDVelo);
return(View(achat));
}
public ActionResult DeleteConfirmed(Guid id)
{
Achat achat = db.Operations.OfType <Achat>().Include(a => a.Details).FirstOrDefault(a => a.Id == id);
foreach (var detail in achat.Details)
{
stockManager.RemoveStock(detail.Produit.ID, detail.QuantiteAchetee, OperationType.Vente);
}
db.Operations.Remove(achat);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <IActionResult> Create([Bind("AchatId,ClientID,DateAchat")] Achat achat)
{
if (ModelState.IsValid)
{
_context.Add(achat);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ClientID"] = new SelectList(_context.Client, "ClientId", "ClientName", achat.ClientID);
return(View(achat));
}
public ActionResult Edit([Bind(Include = "Code_Achat,Code_Enregistrement,Code_Abonne,Achat_Confirme")] Achat achat)
{
if (ModelState.IsValid)
{
db.Entry(achat).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Code_Abonne = new SelectList(db.Abonne, "Code_Abonne", "Nom_Abonne", achat.Code_Abonne);
ViewBag.Code_Enregistrement = new SelectList(db.Enregistrement, "Code_Morceau", "Titre", achat.Code_Enregistrement);
return(View(achat));
}
public bool ApiDeny(int id, string lbl)
{
Achat a = db.Achats.Find(id);
if (a == null)
{
return(false);
}
ApplicationUser current = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
if (User.IsInRole(SecurityRole.DAF))
{
Models.Avis avis = new Models.Avis {
AchatID = id, Accept = false, Lbl = lbl, Code = AvisCode.daf, User = current
};
a.State = StateDemande.DemandeRefuser;
db.Entry(a).State = System.Data.Entity.EntityState.Modified;
db.Avis.Add(avis);
db.SaveChanges();
return(true);
}
else if (User.IsInRole(SecurityRole.AUDIT))
{
Models.Avis avis = new Models.Avis {
AchatID = id, Accept = false, Lbl = lbl, Code = AvisCode.audit, User = current
};
a.State = StateDemande.DemandeRefuser;
db.Entry(a).State = System.Data.Entity.EntityState.Modified;
db.Avis.Add(avis);
db.SaveChanges();
return(true);
}
else if (User.IsInRole(SecurityRole.DG))
{
Models.Avis avis = new Models.Avis {
AchatID = id, Accept = false, Lbl = lbl, Code = AvisCode.dg, User = current
};
a.State = StateDemande.DemandeRefuser;
db.Entry(a).State = System.Data.Entity.EntityState.Modified;
db.Avis.Add(avis);
db.SaveChanges();
return(true);
}
return(false);
}
public ActionResult AjoutPanier(int?morceau)
{
var userID = User.Identity.GetUserId();
var IdAbonne = db.Abonne.Single(a => a.UserId == userID);
Achat panier = new Achat {
Code_Enregistrement = morceau, Code_Abonne = IdAbonne.Code_Abonne
};
db.Achat.Add(panier);
db.SaveChanges();
return(RedirectToAction("Panier", "Achats1", new { userId = userID }));
}
public async Task <ActionResult> Edit([Bind(Include = "ID,DepartmentID,Des,Categ,DtAcha,Creation,LieuLiv,Imp,Qte,Type,State")] Achat achat)
{
if (ModelState.IsValid)
{
db.Entry(achat).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentID = new SelectList(db.Departments, "ID", "Dep", achat.DepartmentID);
return(View(achat));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Achat achat = db.Achat.Find(id);
if (achat == null)
{
return(HttpNotFound());
}
return(View(achat));
}
