private ModelFacture CreatefactureA(short id)
{
ModelFacture modelfacture = new ModelFacture();
Facture_achat Fa = new Facture_achat();
Preference preference = new Preference();
var facture = from l in db.Facture_achat.Include(l => l.Fournisseur)
where l.Id_facture == id
select l;
var ListeP = from l in db.Liste_produit_achat.Include(l => l.Article)
where l.Id_facture == id
select l;
preference = db.Preference.Find(1);
Fa = facture.ToList().ElementAt(0);
if (Fa.Type_facture == "Facture" || Fa.Type_facture == "Facture comptabilisée")
modelfacture.Type_Op = "Facture de vente";
else
modelfacture.Type_Op = Fa.Type_facture;
modelfacture.Nom_client = Fa.Fournisseur.Nom_fournisseur + " " + Fa.Fournisseur.Prenom_fournisseur;
modelfacture.Telephone_client = Fa.Fournisseur.Telephone_fournisseur;
modelfacture.Adresse_client = Fa.Fournisseur.Adresse_fournisseur;
modelfacture.Num_Facture = Fa.Code_facture;
modelfacture.Date_Facture = Fa.Date_facture.ToShortDateString();
modelfacture.Nom_E = preference.Nom;
modelfacture.Adresse_E = preference.Adresse;
modelfacture.Numtel_E = preference.Num_telephone;
modelfacture.Liste_produit_achat = ListeP.ToList();
return modelfacture;
}
private ModelFacture CreatefactureM(short id)
{
ModelFacture modelfacture = new ModelFacture();
Mouvement_stock Ms = new Mouvement_stock();
Preference preference = new Preference();
var facture = from l in db.Mouvement_stock
where l.ID_mouvement == id
select l;
var ListeP = from l in db.Liste_produit.Include(l => l.Article)
where l.Id_operation == id
select l;
preference = db.Preference.Find(1);
Ms = facture.ToList().ElementAt(0);
modelfacture.Num_Facture = Ms.Code_mouvement;
modelfacture.Type_Op = Ms.Type_mouvement;
modelfacture.Date_Facture = Ms.Date_mouvement.ToShortDateString();
modelfacture.Nom_E = preference.Nom;
modelfacture.Adresse_E = preference.Adresse;
modelfacture.Numtel_E = preference.Num_telephone;
modelfacture.Liste_produit = ListeP.ToList();
return modelfacture;
}
private ModelFacture Createfacture(short id)
{
ModelFacture modelfacture = new ModelFacture();
Facture_vente Fa = new Facture_vente();
Preference preference = new Preference();
var facture = from l in db.Facture_vente.Include(l => l.Client)
where l.Id_facture == id
select l;
var ListeP = from l in db.Liste_produit_vente.Include(l => l.Article)
where l.Id_facture == id
select l;
preference = db.Preference.Find(1);
Fa = facture.ToList().ElementAt(0);
if (Fa.Type_facture == "Facture" || Fa.Type_facture == "Facture comptabilisée")
modelfacture.Type_Op = "Facture de vente";
else
modelfacture.Type_Op = Fa.Type_facture;
modelfacture.Remise = (double)Fa.Remise;
modelfacture.TRemise = preference.Remise;
modelfacture.TVA = (Boolean)Fa.TVA;
modelfacture.Nom_client = Fa.Client.Nom_client + " " + Fa.Client.Prenom_client;
modelfacture.Telephone_client = Fa.Client.Telephone_client;
modelfacture.Adresse_client = Fa.Client.Adresse_client;
modelfacture.Num_Facture = Fa.Code_facture;
modelfacture.Date_Facture = Fa.Date_facture.ToShortDateString();
modelfacture.Nom_E = preference.Nom;
modelfacture.Adresse_E = preference.Adresse;
modelfacture.Numtel_E = preference.Num_telephone;
modelfacture.Liste_produit_vente = ListeP.ToList();
modelfacture.TauxTva = (double)preference.Taux_tva;
return modelfacture;
}
