public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Pret pret = db.prets.Find(id);
if (pret == null)
{
return(HttpNotFound());
}
Adherent adherent = db.adherents.Find(pret.AdherentID);
pret.emprunteur = adherent;
Livre livre = db.livres.Find(pret.LivreID);
pret.leLivrePrete = livre;
return(View(pret));
}
public void PretMultiple_Test()
{
var montantBien = 263000;
var apport = 91186;
var fraisDeGarantie = 2500;
var montantAEmprunter = montantBien - apport + fraisDeGarantie;
var dureeEnAnnees = 15;
var tauxNominal = 1.50 / 100;
var pret_1 = new Pret("Crédit Test (teg de 1,50%)", montantAEmprunter, dureeEnAnnees, tauxNominal, new DateTime(2018, 12, 1));
var pret_2 = new Pret("Crédit pour frais de notaire", 19300, 4, 0.946 / 100, new DateTime(2018, 12, 1));
var doublePret = new PretMultiple("Prêt composé d'1 crédit appart + 1 crédit pour frais d'acte de vente", new List <Pret> {
pret_1, pret_2
});
Assert.AreEqual(20453.55, pret_1.GetCoutTotal(), 0.01);
Assert.AreEqual(375.06, pret_2.GetCoutTotal(), 0.01);
Assert.AreEqual(20828.62, doublePret.GetCoutTotal(), 0.01);
}
public static List <Pret> TousPretcritere(string param)
{
List <Pret> l = new List <Pret>();
string req = "select * from pret where nocompte='" + param + "' or code_client='" + param + "' or montant='" + param + "' or devise='" + param + "' or date_pret='" + param + "' or date_remise='" + param + "'";
string chaine = "Server=localhost;Database=gestion_codevi;Uid=root;Pwd=";
MySqlConnection con = null;
MySqlCommand cmd = null;
MySqlDataReader rs = null;
try
{
con = new MySqlConnection(chaine);
con.Open();
cmd = new MySqlCommand(req, con);
rs = cmd.ExecuteReader();
while (rs.Read())
{
Pret c = new Pret(rs.GetString(0), rs.GetString(1), rs.GetFloat(2), rs.GetString(3), rs.GetString(4), rs.GetDateTime(5));;
l.Add(c);
}
}
catch (MySqlException se)
{
Console.WriteLine(se.Message);
}
finally
{
if (con != null)
{
con.Close();
}
}
return(l);
}
//LABORATOR2 EX 2
public string ConvertToString()
{
string optiuni = string.Empty;
for (int i = 0; i < Optiuni.Count; i++)
{
optiuni += Optiuni[i] + "\n";
}
return("Firma: " + (Marca ?? "NECUNOSCUT") + "\n" +
"Model: " + (Model ?? "NECUNOSCUT") + "\n" +
"An Fabricatie: " + (AnFabricatie.ToString() ?? "NECUNOSCUT") + "\n" +
"Capacitate Cilindrica: " + (CapacitateCilindrica.ToString() ?? "NECUNOSCUT") + "\n" +
"Putere: " + (Putere.ToString() ?? "NECUNOSCUT") + "\n" +
"Combustibil: " + (Combustibil.ToString() ?? "NECUNOSCUT") + "\n" +
"Cutie de viteze: " + (CutieDeViteze.ToString() ?? "NECUNOSCUT") + "\n" +
"Caroserie: " + (Caroserie.ToString() ?? "NECUNOSCUT") + "\n" +
"Culoare: " + (Culoare.ToString() ?? "NECUNOSCUT") + "\n" +
"Pret: " + (Pret.ToString() ?? "NECUNOSCUT") + "\n" +
"Nume Vanzator: " + (Nume_Vanzator + " " + Prenume_Vanzator ?? "NECUNOSCUT") + "\n" +
"Nume Cumparator: " + (Nume_Cumparator + " " + Prenume_Cumparator ?? "NECUNOSCUT") + "\n" +
"Data Tranzactie: " + (DataTranzactie.ToString("dd.MM.yyyy") ?? "01.01.2000") + "\n" +
"Optiuni:\n" + optiuni);
}
public void Pret_10_Test()
{
var montantAEmprunter = 110000;
var dureeEnAnnees = 10;
var tauxNominal = 1.85 / 100;
var pretSeul = new Pret("Crédit Test", montantAEmprunter, dureeEnAnnees, tauxNominal, new DateTime(2014, 03, 1));
Assert.AreEqual(montantAEmprunter, pretSeul.MontantAEmprunter);
Assert.AreEqual(tauxNominal, pretSeul.TauxNominal);
Assert.AreEqual(dureeEnAnnees, pretSeul.DureeEnAnnees);
Assert.AreEqual(120, pretSeul.GetDureeEnMois());
Assert.AreEqual(new DateTime(2024, 3, 1), pretSeul.GetFinPret());
Assert.AreEqual(1004.77, pretSeul.GetMensualitée(), 0.01);
Assert.AreEqual(10573, pretSeul.GetCoutTotal(), 1);
Assert.AreEqual(10.4, pretSeul.GetTAEG(), 0.01);
var echeances = pretSeul.GetEcheances();
Assert.AreEqual(120, echeances.Count);
Assert.AreEqual(835.19, echeances.First().MensualitéDontCapital, 0.01);
Assert.AreEqual(169.58, echeances.First().MensualitéDontInterets, 0.01);
Assert.AreEqual(1003.23, echeances.Last().MensualitéDontCapital, 0.01);
Assert.AreEqual(1.55, echeances.Last().MensualitéDontInterets, 0.01);
}
public void RetourEchec()
{
Pret pret = adherent.Emprunte(exemplaire1);
adherent.Retourne(exemplaire2);
}
public ActionResult Modifier(Pret unPret)
{
return(View(unPret));
}
/// <summary>
/// Affiche les résultats dans la console.
/// </summary>
public static void AffichePret(double montantBien, double fraisNotariés, double apport, Pret pret)
{
Console.WriteLine("#############################################");
Console.WriteLine($"CREDIT \"{pret.Nom}\"");
Console.WriteLine();
Console.WriteLine($"Montant du bien: {montantBien.ToString("N2")}");
Console.WriteLine($"Frais de notaire: {fraisNotariés.ToString("N2")}");
Console.WriteLine($"Montant apport: {apport.ToString("N2")}");
Console.WriteLine($"TAEG: {pret.GetTAEG().ToString("P3")}");
Console.WriteLine($"MontantAEmprunter: {pret.MontantAEmprunter.ToString("N2")}");
Console.WriteLine($"Mensualités de {pret.GetMensualitée().ToString("N2")} sur {pret.GetDureeEnMois()/12} ans");
Console.WriteLine($"Montant total du prêt {pret.GetMontantTotal().ToString("N2")}");
Console.WriteLine($"Coût du prêt {pret.GetCoutTotal().ToString("N2")}");
Console.WriteLine("#############################################");
Console.WriteLine();
}
public FormEmprunt(Pret _pretAModifier)
{
InitializeComponent();
cp = _pretAModifier;
MettreAJourLIHM();
}
public static List <ServiceSocial> GetListPrets(int EmpID)
{
List <ServiceSocial> serviceSocials = new List <ServiceSocial>();
PV pv; Service service; TypePret type; Bon_Cmd bon_Cmd; Facture facture;
ServiceSocial serviceSocial;
SqlConnection sqlConnection = new SqlConnection(constr);
sqlConnection.Open();
String command = "SELECT * FROM " + table + " WHERE EmpID = @emp ; ";
SqlCommand sqlCommand = new SqlCommand(command, sqlConnection);
using (sqlCommand)
{
sqlCommand.CommandType = CommandType.Text;
sqlCommand.Parameters.AddWithValue("@emp", EmpID);
SqlDataReader dataReader = sqlCommand.ExecuteReader();
while (dataReader.Read())
{
service = ConnectionService.GetService((int)dataReader[2]);
if (service.nom.Equals("Pret sociale"))
{
PretSociale pretSociale = new PretSociale();
type = new TypePret();
type = ConnectionTypes.GetTypePret((int)dataReader[26]);
pretSociale.setType(type);
serviceSocial = pretSociale;
}
else if (service.nom.Equals("Dons"))
{
Dons dons = new Dons();
type = ConnectionTypes.GetTypePret((int)dataReader[26]);
dons.setType(type);
serviceSocial = dons;
}
else if (service.nom.Equals("Credit Eledtromenager"))
{
Electromenager electromenager = new Electromenager();
try
{
bon_Cmd = ConnectionBonCmd.GetBonCmd((int)dataReader[0]);
electromenager.setBon_cmd(bon_Cmd);
facture = ConnectionFacture.GetFacture((int)dataReader[0]);
electromenager.setFournissure(facture.GetFournisseur());
electromenager.setFacture(facture);
}
catch { }
serviceSocial = electromenager;
}
else
{
serviceSocial = new Pret();
// Cette cas n'est pas valide
throw new Exception();
}
pv = ConnectionPV.GetPV((int)dataReader[3]);
serviceSocial.setPV(pv);
serviceSocial.setid((int)dataReader[0]);
serviceSocial.setEmployer((int)dataReader[1]);
serviceSocial.setPrix(Convert.ToDouble(dataReader[4]));
if (dataReader[25] != DBNull.Value)
{
serviceSocial.setobservation((string)dataReader[25]);
}
int indice = 5;
List <Double> prelev = new List <double>();
List <DateTime> dates = new List <DateTime>();
while (indice < 25)
{
prelev.Add(Convert.ToDouble(dataReader[indice]));
indice++;
if (!(String.IsNullOrEmpty(dataReader[indice].ToString())))
{
dates.Add(Convert.ToDateTime(dataReader[indice]));
}
indice++;
}
serviceSocial.setDates(dates);
serviceSocial.setprelevements(prelev);
serviceSocials.Add(serviceSocial);
}
dataReader.Close();
}
sqlCommand.Dispose();
sqlConnection.Close();
return(serviceSocials);
}
public string ConvertToString2()
{
return($"{Marca,-20}{Model,-15}{AnFabricatie.ToString(),-5}{CapacitateCilindrica.ToString(), -7}" +
$"{Putere.ToString(), -7}{Combustibil.ToString(), -12}{CutieDeViteze.ToString(), -11}{Caroserie.ToString(), -11}{Culoare.ToString(), -11}" +
$"{Pret.ToString(), -10}{Nume_Cumparator + " " + Prenume_Cumparator, -35}{Nume_Vanzator + " " + Prenume_Cumparator, -35}{DataTranzactie.ToString("dd.MM.yyyy"), -17}");
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Pret pret = db.prets.Find(id);
if (pret == null)
{
return(HttpNotFound());
}
pret.emprunteur = db.adherents.Find(pret.AdherentID);
pret.leLivrePrete = db.livres.Find(pret.LivreID);
var livresPretes = from l in db.prets select l.leLivrePrete;
var livreNonPretes = from l in db.livres where !livresPretes.Contains(l) select l;
var adherentAutorisable = from a in db.adherents where a.pretsEnCours.Count == 3 select a;
List <Adherent> adherentAutorise = adherentAutorisable.ToList <Adherent>();
List <Adherent> adhWithDepas = new List <Adherent>();
var listpret = from p in db.prets select p;
List <Pret> listprets = listpret.ToList <Pret>();
var listAdherents = from a in db.adherents select a;
List <Adherent> listAdherent = listAdherents.ToList <Adherent>();
foreach (Pret pr in listprets)
{
Adherent d = db.adherents.Find(pr.AdherentID);
if (DateTime.Compare(pr.getDateRetour().Date, DateTime.Now.Date) < 0)
{
adhWithDepas.Add(d);
listAdherent.Remove(d);
}
}
foreach (Adherent d in adherentAutorise)
{
listAdherent.Remove(d);
}
var list = adhWithDepas.GroupBy(x => x.ID).Select(y => y.First());
List <Adherent> lista = list.ToList <Adherent>();
lista.Union(adherentAutorise);
if (livreNonPretes.Count() == 0 || listAdherent.Count() == 0)
{
var adherentAutorisee = from a in db.adherents where a.ID == pret.AdherentID select a;;
livreNonPretes = from l in db.livres where l.ID == pret.LivreID select l;
ViewBag.AdherentID = new SelectList(adherentAutorisee, "ID", "nom", pret.AdherentID);
}
else
{
ViewBag.AdherentID = new SelectList(listAdherent, "ID", "nom", pret.AdherentID);
}
ViewBag.LivreID = new SelectList(livreNonPretes, "ID", "titre", pret.LivreID);
return(View(pret));
}