public ActionResult CContrat([Bind(Include = "CodePers,CodeLocal,CodeContrat,DateJuissance,Usage,LoyerDebase,Augementation,dateAugmentation,Charge,TaxeDedilite,Garage,LoyerNet,Caution,DateFinContrat,FrequencePaiement,adults,enfants,animaux,commentaire")] ContratLocation contratLocation,
int?payment)
{
contratLocation.CodeLocal = payment.Value;
Local loc = db.Locals.Find(contratLocation.CodeLocal);
loc.Staut = 1;
db.Entry(loc).State = EntityState.Modified;
double ln = ((100 + contratLocation.TaxeDedilite.Value + contratLocation.Charge.Value) / 100) * contratLocation.LoyerDebase.Value;
double test = (100 + contratLocation.TaxeDedilite.Value + contratLocation.Charge.Value);
contratLocation.LoyerNet = (test / 100) * contratLocation.LoyerDebase.Value + contratLocation.Garage;
contratLocation.isClosed = 1;
if (contratLocation.Garage == null)
{
contratLocation.Garage = 0;
}
if (contratLocation.Caution == null)
{
contratLocation.Caution = 0;
}
db.ContratLocations.Add(contratLocation);
db.SaveChanges();
return(RedirectToAction("Details", new { id = contratLocation.CodeContrat }));
//}
//ViewBag.CodeLocal = new SelectList(db.Locals, "CodeLocal", "TitreLocal", contratLocation.CodeLocal);
//ViewBag.CodePers = new SelectList(db.Personnes, "CodePers", "nom", contratLocation.CodePers);
//return RedirectToAction("Index");
}
// POST: Contrat/Delete/5
//[HttpPost, ActionName("Delete")]
//[ValidateAntiForgeryToken]
public ActionResult DeleteConfirmed(int id)
{
var contratLocations = db.ContratLocations;
ContratLocation contratLocation = null;
List <ContratLocation> ListeC = contratLocations.ToList();
for (int i = 0; i < db.ContratLocations.Count(); i++)
{
if (ListeC[i].CodeContrat == id)
{
contratLocation = ListeC[i];
}
}
Local local = db.Locals.Find(contratLocation.CodeLocal);
local.Staut = 0;
db.Entry(local).State = EntityState.Modified;
contratLocation.isClosed = 0;
contratLocation.dateClose = DateTime.Now;
//ContratLocation contratLocation = db.ContratLocations.Find(id);
//db.ContratLocations.Remove(contratLocation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult EditContrat(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var contratLocations = db.ContratLocations;
ContratLocation contratLocation = null;
List <ContratLocation> ListeC = contratLocations.ToList();
for (int i = 0; i < db.ContratLocations.Count(); i++)
{
if (ListeC[i].CodeContrat == id.Value)
{
contratLocation = ListeC[i];
}
}
//ContratLocation contratLocation = db.ContratLocations.Find(id);
if (contratLocation == null)
{
return(HttpNotFound());
}
ViewBag.CodeLocal = new SelectList(db.Locals, "CodeLocal", "TitreLocal", contratLocation.CodeLocal);
ViewBag.CodePers = new SelectList(db.Personnes, "CodePers", "nom", contratLocation.CodePers);
return(View(contratLocation));
}
public ActionResult DeleteConfirmed(int id)
{
ContratLocation contratLocation = db.ContratLocations.Find(id);
db.ContratLocations.Remove(contratLocation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Contrat/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
List <Augementation> ListAug = db.Augementations.Where(c => c.CodeContrat == id).ToList();
ViewBag.ListAug = ListAug;
if (ListAug.Count() > 0)
{
int pcAug = ListAug.Max(c => c.pcAug).Value;
ViewBag.PcAug = pcAug + 1;
}
var contratLocations = db.ContratLocations;
ContratLocation contratLocation = null;
List <ContratLocation> ListeC = contratLocations.ToList();
for (int i = 0; i < db.ContratLocations.Count(); i++)
{
if (ListeC[i].CodeContrat == id.Value)
{
contratLocation = ListeC[i];
if (contratLocation.Usage == 0)
{
ViewBag.us = "Habitation";
}
else if (contratLocation.Usage == 1)
{
ViewBag.us = "Commercial";
}
if (contratLocation.Garage == 0)
{
ViewBag.garage = "Non";
}
else if (contratLocation.Garage == 1)
{
ViewBag.garage = "Oui";
}
if (contratLocation.FrequencePaiement == 0)
{
ViewBag.fp = "Mensuel";
}
else if (contratLocation.FrequencePaiement == 1)
{
ViewBag.fp = "Trimestriel";
}
}
}
//ContratLocation contratLocation = db.ContratLocations.Find(id);
//if (contratLocation == null)
//{
// return HttpNotFound();
//}
return(View(contratLocation));
}
public ActionResult Edit([Bind(Include = "CodePers,CodeLocal,CodeContrat,DateJuissance,Usage,LoyerDebase,Augementation,dateAugmentation,Charge,TaxeDedilite,Garage,LoyerNet,Caution,DateFinContrat,FrequencePaiement")] ContratLocation contratLocation)
{
if (ModelState.IsValid)
{
db.Entry(contratLocation).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CodeLocal = new SelectList(db.Locals, "CodeLocal", "TitreLocal", contratLocation.CodeLocal);
ViewBag.CodePers = new SelectList(db.Personnes, "CodePers", "nom", contratLocation.CodePers);
return(View(contratLocation));
}
public ActionResult CreateAug([Bind(Include = "idAug,CodePers,CodeLocal,CodeContrat,dateAug,pcAug")] Augementation augementation)
{
//if (ModelState.IsValid)
//{
ContratLocation contrat = db.ContratLocations.Where(c => c.CodeContrat == augementation.CodeContrat).First();
if (!string.IsNullOrEmpty(contrat.DateFinContrat.ToString()))
{
if (augementation.dateAug > contrat.DateJuissance && augementation.dateAug < contrat.DateFinContrat)
{
if (augementation.pcAug.Value > db.Augementations.Where(c => c.CodeContrat == augementation.CodeContrat).Max(c => c.pcAug))
{
db.Augementations.Add(augementation);
db.SaveChanges();
}
return(RedirectToAction("Details", new { id = augementation.CodeContrat }));
}
else
{
//ModelState.AddModelError("dateAugErr", "La date est invalide");
return(RedirectToAction("Details", new { id = augementation.CodeContrat }));
}
}
else if (augementation.dateAug > contrat.DateJuissance)
{
if (contrat.Augementations.Count() > 0)
{
if (augementation.pcAug.Value > db.Augementations.Where(c => c.CodeContrat == augementation.CodeContrat).Max(c => c.pcAug) && augementation.dateAug.Value > db.Augementations.Where(c => c.CodeContrat == augementation.CodeContrat).Max(c => c.dateAug))
{
db.Augementations.Add(augementation);
db.SaveChanges();
}
}
else
{
db.Augementations.Add(augementation);
db.SaveChanges();
}
return(RedirectToAction("Details", new { id = augementation.CodeContrat }));
}
//}
ViewBag.CodePers = new SelectList(db.ContratLocations, "CodePers", "commentaire", augementation.CodePers);
return(View(augementation));
}
public ActionResult DeleteContrat(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ContratLocation contratLocation = db.ContratLocations.Where(c => c.CodeContrat == id).First();
if (contratLocation == null)
{
return(HttpNotFound());
}
return(View(contratLocation));
}
// GET: ContratLocations1/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ContratLocation contratLocation = db.ContratLocations.Find(id);
if (contratLocation == null)
{
return(HttpNotFound());
}
return(View(contratLocation));
}
public ActionResult DeleteContratConfirmed(int id)
{
ContratLocation contratLocation = db.ContratLocations.Where(c => c.CodeContrat == id).First();
Local local = db.Locals.Find(contratLocation.CodeLocal);
local.Staut = 0;
db.Entry(local).State = EntityState.Modified;
contratLocation.isClosed = 0;
contratLocation.dateClose = DateTime.Now;
//ContratLocation contratLocation = db.ContratLocations.Find(id);
//db.ContratLocations.Remove(contratLocation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: ContratLocations1/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ContratLocation contratLocation = db.ContratLocations.Find(id);
if (contratLocation == null)
{
return(HttpNotFound());
}
ViewBag.CodeLocal = new SelectList(db.Locals, "CodeLocal", "TitreLocal", contratLocation.CodeLocal);
ViewBag.CodePers = new SelectList(db.Personnes, "CodePers", "nom", contratLocation.CodePers);
return(View(contratLocation));
}
public ActionResult EditContrat([Bind(Include = "CodePers,CodeLocal,CodeContrat,DateJuissance,Usage,LoyerDebase,Augementation,dateAugmentation,Charge,TaxeDedilite,Garage,LoyerNet,Caution,DateFinContrat,FrequencePaiement")] ContratLocation contratLocation)
{
if (ModelState.IsValid)
{
double ln = ((100 + contratLocation.TaxeDedilite.Value + contratLocation.Charge.Value) / 100) * contratLocation.LoyerDebase.Value;
double test = (100 + contratLocation.TaxeDedilite.Value + contratLocation.Charge.Value);
contratLocation.LoyerNet = (test / 100) * contratLocation.LoyerDebase.Value;
db.Entry(contratLocation).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("DetailsContrat", new { id = contratLocation.CodeContrat }));
}
ViewBag.CodeLocal = new SelectList(db.Locals, "CodeLocal", "TitreLocal", contratLocation.CodeLocal);
ViewBag.CodePers = new SelectList(db.Personnes, "CodePers", "nom", contratLocation.CodePers);
return(View(contratLocation));
}
static void Main(string[] args)
{
var agence = new Agence();
agence.Nom = "Buget";
agence.Ville = "Paris";
var client = new Client();
client.Nom = "BAZAN";
client.Prenom = "Yannick";
client.Numero = "00001";
var categorieCompacte = new CategorieVoiture();
categorieCompacte.Nom = "Compacte";
categorieCompacte.PrixJour = 40;
var categorieFamiliale = new CategorieVoiture();
categorieFamiliale.Nom = "Familiale";
categorieFamiliale.PrixJour = 75;
var voiture1 = new Voiture();
voiture1.Categorie = categorieCompacte;
voiture1.Marque = "Peugeot";
voiture1.Modele = "308";
agence.Parc.Add(voiture1);
Console.WriteLine($"La agence {agence.Nom} a {agence.Parc.Count} voiture(s)");
var contratLocation = new ContratLocation();
contratLocation.Client = client;
contratLocation.DateDebut = DateTime.Today;
contratLocation.DateFin = DateTime.Today.AddDays(5);
contratLocation.KilometrageMaximum = 500;
contratLocation.Vehicule = voiture1;
Console.WriteLine($"Contrat pour le client {contratLocation.Client.Nom} {client.Prenom}" +
$"\nValeur jour: {contratLocation.Vehicule.GetPrixJour()} " +
$"\nValeur total: {contratLocation.CalculerMontantLocation()}");
}
static void Main(string[] args)
{
var agence = new Agence();
agence.Nom = "Budget";
agence.Ville = "Paris";
var client = new Client();
client.Nom = "ORSONI";
client.Prenom = "Alexina";
client.Numero = "00001";
var categorieCompacte = new CategorieVoiture();
categorieCompacte.Nom = "Compacte";
categorieCompacte.PrixJour = 40;
var categorieFamiliale = new CategorieVoiture();
categorieFamiliale.Nom = "Familiale";
categorieFamiliale.PrixJour = 75;
var voiture1 = new Voiture();
voiture1.Categorie = categorieCompacte;
voiture1.Marque = "Citroën";
voiture1.Modele = "C4 Cactus";
agence.Parc.Add(voiture1);
Console.WriteLine($"nombre de voiture: {agence.Parc.Count}");
var contratLocation = new ContratLocation();
contratLocation.Client = client;
contratLocation.DateDebut = DateTime.Today;
contratLocation.DateFin = DateTime.Today.AddDays(5);
contratLocation.KilometrageMaximum = 500;
contratLocation.Vehicule = voiture1;
Console.WriteLine($"Contrat pour {client.Nom} {client.Prenom}: " + $"{contratLocation.CalculerMontantLocation()} EUR");
Console.ReadKey();
}
//[ValidateAntiForgeryToken]
public ActionResult Edit([Bind(Include = "CodePers,CodeLocal,CodeContrat,DateJuissance,Usage,LoyerDebase,isClosed,dateModification,Charge,TaxeDedilite,Garage,LoyerNet,Caution,DateFinContrat,FrequencePaiement,adults,enfants,animaux,commentaire")] ContratLocation contratLocation)
{
//if (ModelState.IsValid)
//{
double ln = ((100 + contratLocation.TaxeDedilite.Value + contratLocation.Charge.Value) / 100) * contratLocation.LoyerDebase.Value;
double test = (100 + contratLocation.TaxeDedilite.Value + contratLocation.Charge.Value);
contratLocation.LoyerNet = (test / 100) * contratLocation.LoyerDebase.Value + contratLocation.Garage;
contratLocation.dateModification = DateTime.Now;
//DateTime Datetest = contratLocation.DateFinContrat.Value;
db.Entry(contratLocation).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Details", new { id = contratLocation.CodeContrat }));
//}
//ViewBag.CodeLocal = new SelectList(db.Locals, "CodeLocal", "TitreLocal", contratLocation.CodeLocal);
//ViewBag.CodePers = new SelectList(db.Personnes, "CodePers", "nom", contratLocation.CodePers);
//return View(contratLocation);
}
public ActionResult CreatePL([Bind(Include = "codeOp,CodePers,codeType,montant,dateOp,Commentaire")] Operation operation,
[Bind(Include = "codeOp,CodePers,CodeLocal,CodeContrat,MoyenPaiement,Reference,DteDebut,DteFin,NbrQuittanceImprime")] PaiementLoyer paiementLoyer, int?id)
{
if (ModelState.IsValid)
{
operation.dateOp = DateTime.Now;
operation.codeType = 1;
operation.CodePers = CodeLocataire;
db.Operations.Add(operation);
paiementLoyer.CodePers = CodeLocataire;
paiementLoyer.CodeLocal = CodeLocal;
paiementLoyer.codeOp = operation.codeOp;
paiementLoyer.CodeContrat = id;
ContratLocation contrat = db.ContratLocations.Where(c => c.CodeContrat == id).First();
if (contrat.DateFinContrat <= paiementLoyer.DteFin)
{
return(RedirectToAction("CreatePL", new { id = contrat.CodeContrat }));
}
else
{
contrat.LoyerNet = operation.montant;
db.Entry(contrat).State = EntityState.Modified;
db.PaiementLoyers.Add(paiementLoyer);
db.SaveChanges();
return(RedirectToAction("print", new { id = operation.codeOp }));
}
}
ViewBag.codeOp = new SelectList(db.Depenses, "codeOp", "Description", operation.codeOp);
ViewBag.CodePers = new SelectList(db.Personnes, "CodePers", "nom", operation.CodePers);
ViewBag.codeType = new SelectList(db.TypeOps, "codeType", "libelle", operation.codeType);
ViewBag.codeOp = new SelectList(db.PaiementLoyers, "codeOp", "MoyenPaiement", operation.codeOp);
return(View(operation));
}
static void Main(string[] args)
{
var agence = new Agence.Agence();
agence.Nom = "Budget";
agence.Ville = "Paris";
var client = new Client();
client.Nom = "BAZAN";
client.Prenom = "Yannick";
client.Numero = "00001";
var categorieCompacte = new CategorieVoiture();
categorieCompacte.Nom = "Compacte";
categorieCompacte.PrixJour = 40;
var voiture1 = new Voiture();
voiture1.Categorie = categorieCompacte;
voiture1.Marque = "Peugeot";
voiture1.Modele = "308";
categorieCompacte.Voitures.Add(voiture1);
agence.Parc.Add(voiture1);
var contratLocation = new ContratLocation();
contratLocation.Client = client;
contratLocation.DateDebut = DateTime.Today;
contratLocation.DateFin = DateTime.Today.AddDays(5);
contratLocation.KilometrageMaximum = 500;
contratLocation.Vehicule = voiture1;
Console.WriteLine($"Contrat pour {contratLocation.Client.Nom} {contratLocation.Client.Prenom}: " +
$"{contratLocation.CalculerMontantLocation()} EUR");
Console.ReadKey();
}
public ActionResult CreateAug([Bind(Include = "idAug,CodePers,CodeLocal,CodeContrat,dateAug,pcAug")] Augementation augementation)
{
if (ModelState.IsValid)
{
ContratLocation contrat = db.ContratLocations.Where(c => c.CodeContrat == augementation.CodeContrat).First();
if (augementation.dateAug > contrat.DateJuissance && augementation.dateAug < contrat.DateFinContrat)
{
db.Augementations.Add(augementation);
db.SaveChanges();
return(RedirectToAction("DetailsContrat", new { id = augementation.CodeContrat }));
}
else
{
ModelState.AddModelError("", "La date est invalide");
return(RedirectToAction("DetailsContrat", new { id = augementation.CodeContrat }));
}
}
ViewBag.CodePers = new SelectList(db.ContratLocations, "CodePers", "commentaire", augementation.CodePers);
return(View(augementation));
}
public ActionResult CreatePL(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ContratLocation contrat = db.ContratLocations.Where(x => x.CodeContrat == id.Value).First();
ViewBag.Statut = contrat.isClosed;
ViewBag.CodeC = id;
double loyerNet = 0;
ViewBag.NomPre = contrat.Personne.nom + " " + contrat.Personne.prenom;
ViewBag.CodePre = contrat.Personne.CodePers;
int aug;
var cll = db.ContratLocations;
CodeLocal = cll.Where(l => l.CodeContrat == id).First().CodeLocal;
if (contrat.Augementations.Count() > 0)
{
if (contrat.Augementations.Where(d => d.dateAug.Value < DateTime.Now).Count() > 0)
{
aug = contrat.Augementations.Where(d => d.dateAug.Value < DateTime.Now).OrderBy(d => d.dateAug).Last().pcAug.Value;
}
else
{
aug = 0;
}
}
else
{
aug = 0;
}
int taxe = contrat.TaxeDedilite.Value;
//DateTime dateDP;
if (contrat.PaiementLoyers.Count() > 0)
{
ViewBag.dateDP = contrat.PaiementLoyers.OrderBy(d => d.DteFin).Last().DteFin.Value.AddDays(1);
if (contrat.FrequencePaiement == 0)
{
ViewBag.dateFP = contrat.PaiementLoyers.OrderBy(d => d.DteFin).Last().DteFin.Value.AddMonths(1);
}
else if (contrat.FrequencePaiement == 1)
{
ViewBag.dateFP = contrat.PaiementLoyers.OrderBy(d => d.DteFin).Last().DteFin.Value.AddMonths(3);
}
}
else
{
ViewBag.dateDP = contrat.DateJuissance.Value;
if (contrat.FrequencePaiement == 0)
{
ViewBag.dateFP = contrat.DateJuissance.Value.AddMonths(1).AddDays(-1);
}
else if (contrat.FrequencePaiement == 1)
{
ViewBag.dateFP = contrat.DateJuissance.Value.AddMonths(3).AddDays(-1);
}
}
var paiementLoyers = db.PaiementLoyers.Include(p => p.ContratLocation).Include(p => p.Operation).Where(c => c.CodeContrat == id);
//ViewBag.NomPre = paiementLoyers.First().ContratLocation.Personne.nom + " " + paiementLoyers.First().ContratLocation.Personne.prenom;
//ViewBag.CodeContrat = id;
ViewBag.ListP = paiementLoyers.ToList();
int charge = contrat.Charge.Value;
int garage = contrat.Garage.Value;
double loyerBase = contrat.LoyerDebase.Value;
loyerNet = garage + ((100 + taxe + charge + aug) * loyerBase) / 100;
if (contrat.FrequencePaiement == 0)
{
ViewBag.loyerNet = loyerNet;
}
else if (contrat.FrequencePaiement == 1)
{
ViewBag.loyerNet = loyerNet * 3;
}
ViewBag.contrat = contrat;
ViewBag.CodePers = new SelectList(db.ContratLocations, "CodePers", "CodePers");
ViewBag.codeOp = new SelectList(db.Operations, "codeOp", "codeOp");
return(View());
}
