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; }