// PUT: api/Facturation/5 public void Put(int id, [FromBody] Facturation factu) { try { if (factu != null) // si l'objet source n'est pas null => update de la base { Facturation ts = db.Facturation.Where(res => res.ID == id).FirstOrDefault(); // recuperer la tache pointé par l'id pris en paramètre de la fonction db.Facturation.Attach(ts); // Faire ecouter le contexte de base de donnée sur les changements de l'objet ts ts.Commande = factu.Commande; // changement des différents attribut de l'objet pointé avec les attributs de l'objet pris en paramètre ts.Mois = factu.Mois; // same ts.Montant = factu.Montant; // same ts.FK_Devis = factu.FK_Devis; // same ts.Date = factu.Date; // same ts.Filename = factu.Filename; // same db.SaveChanges(); // mise a jour de la table } else // sinon je throw une exception { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.NotFound, "l'objet source est vide")); } } catch (Exception e) { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, e.Message)); } }
private void button1_Click(object sender, EventArgs e) { if (comboBox1.Text != null) { try { data = new SqlDataAdapter("select * from Facture where CodeComm=" + comboBox1.Text, con); data.Fill(set, "Facture"); data = new SqlDataAdapter("select C.* from Commande as C inner Join Facture as F on C.Codecommande=F.CodeComm where F.CodeComm=" + comboBox1.Text, con); data.Fill(set, "Commande"); data = new SqlDataAdapter("select Cl.* from Client as Cl inner join Commande as C on C.CodeClient=Cl.Codeclient inner Join Facture as F on C.Codecommande=F.CodeComm where F.CodeComm=" + comboBox1.Text, con); data.Fill(set, "Client"); Facturation f = new Facturation(); f.SetDataSource(set); Report_Viewer_Form r = new Report_Viewer_Form(); r.Text = "Facture N° " + comboBox1.Text; r.crystalReportViewer1.ReportSource = f; r.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Voulez choisir une Facture", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public async Task <IActionResult> Edit(long id, [Bind("FacturationId,AchatId,PrixTotal")] Facturation facturation) { if (id != facturation.FacturationId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(facturation); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FacturationExists(facturation.FacturationId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["AchatId"] = new SelectList(_context.Achat, "AchatId", "AchatId", facturation.AchatId); return(View(facturation)); }
public async Task <IActionResult> Create([Bind("FacturationId,AchatId,PrixTotal")] Facturation facturation) { if (ModelState.IsValid) { _context.Add(facturation); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["AchatId"] = new SelectList(_context.Achat, "AchatId", "AchatId", facturation.AchatId); return(View(facturation)); }
// GET: api/Facturation/5 public Facturation Get(int id) { Facturation res = this.db.Facturation.Where(s => s.ID == id).FirstOrDefault(); // renvoi l'objet pointé par l'id pris en paramètre if (res != null) { return(res); } else { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.NotFound, "pas d'objet pour cet ID")); } }
// DELETE: api/Facturation/5 public void Delete(int id) { try // vérrif si un objet a été trouvé pour l'id { Facturation ts = db.Facturation.Where(res => res.ID == id).FirstOrDefault(); // récupération de la tache pointé par l'id db.Facturation.Attach(ts); // ecouter les changement de l'objet db.Facturation.Remove(ts); // remove l'objet ts db.SaveChanges(); // mettre a jour la table } catch (Exception e) { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "Pas d'objet pour cet Id")); } }
public static void FacturerCommande_Print(int CodeCommande) { try { int CodeFacture = int.Parse(ExecuteScalar("select CodeFacture from Facture where CodeComm = '" + CodeCommande + "'").ToString()); DataSet Data_Set = getFacture(CodeCommande); Facturation reportCommande = new Facturation(); reportCommande.SetDataSource(Data_Set); Report_Viewer_Form frm = new Report_Viewer_Form(); frm.Text = "Facture N°: " + CodeFacture + " pour la commande N°: " + CodeCommande; frm.crystalReportViewer1.ReportSource = reportCommande; frm.Show(); } catch (Exception Err) { MessageBox.Show(Err.Message, "Un Erreur est survenue", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button1_Click(object sender, EventArgs e) { try { data = new SqlDataAdapter("select CodeFacture,Total from Facture where CodeComm=" + textBox6.Text, con); data.Fill(set, "Facture"); data = new SqlDataAdapter("select C.CodeDepot,C.CodeClient,C.DateCommande,C.Codecommande from Commande as C inner Join Facture as F on C.Codecommande=F.CodeComm where F.CodeComm=" + textBox6.Text, con); data.Fill(set, "Commande"); data = new SqlDataAdapter("select Cl.Nom,Cl.Prenom,Cl.Cin,Cl.Tel,Cl.Adresse,Cl.Email from Client as Cl inner join Commande as C on C.CodeClient=Cl.Codeclient inner Join Facture as F on C.Codecommande=F.CodeComm where F.CodeComm=" + textBox6.Text, con); data.Fill(set, "Client"); Facturation f = new Facturation(); f.SetDataSource(set); Report_Viewer_Form r = new Report_Viewer_Form(); r.Text = "Facture N° " + textBox6.Text; r.crystalReportViewer1.ReportSource = f; r.Show(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
// POST: api/Facturation public void Post(object genObjec_f) { var stringed = genObjec_f.ToString(); GeneralObject newGenObject = JsonConvert.DeserializeObject <GeneralObject>(stringed); foreach (Projet p in newGenObject.projets) { p.découpageStories.Add("B", new List <MasterStories>()); p.découpageStories.Add("PR", new List <MasterStories>()); p.découpageStories.Add("PNR", new List <MasterStories>()); foreach (MasterStories s in p.Stories) { if ((bool)s.Bonus) { p.découpageStories["B"].Add(s); } else if (s.nonEffetue) { p.découpageStories["PNR"].Add(s); } else { p.découpageStories["PR"].Add(s); } } } Calculator devisCalculator = new Calculator(newGenObject); //DevisCalculator devisCalculator = new DevisCalculator(genObjec_d); SumManager resultFromcallCalculator = devisCalculator.CalculateFactu(); Facturation facturation = new Facturation(); FileFiller filler = new FileFiller(facturation, true, resultFromcallCalculator, newGenObject); //StreamWriter logFile = new StreamWriter(System.AppDomain.CurrentDomain.BaseDirectory + @"\Content\test.txt"); //logFile.WriteLine("je suis juste un petit fichier de test qui va me permettre de savoir si j'arriva a renvoyer des fichiers au clients"); //logFile.Close(); // DateTime longDate = DateTime.Now; //var path = System.AppDomain.CurrentDomain.BaseDirectory + @"\Content\Devis" + longDate.Year.ToString() + "_" + longDate.AddMonths(-1).Month + @"\" + "Etat_des_lieux_VS_Devis_initial_All_NS_Reneco_" + longDate.Year.ToString() + "_" + longDate.AddMonths(-1).Month + ".docx"; //HttpResponseMessage result = new HttpResponseMessage(HttpStatusCode.OK); //var stream = new FileStream(path, FileMode.Open); //result.Content = new StreamContent(stream); //result.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment"); //result.Content.Headers.ContentDisposition.FileName = Path.GetFileName(path); //result.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.openxmlformats-officedocument.wordprocessingml.document"); //result.Content.Headers.ContentLength = stream.Length; // string strdocPath; //strdocPath = System.AppDomain.CurrentDomain.BaseDirectory + @"\Content\Devis" + longDate.Year.ToString() + "_" + longDate.AddMonths(-1).Month + @"\Calcul" + ".txt"; // strdocPath = System.AppDomain.CurrentDomain.BaseDirectory + @"\Content\Devis" + longDate.Year.ToString() + "_" + longDate.AddMonths(-1).Month + @"\" + "Etat_des_lieux_VS_Devis_initial_All_NS_Reneco_" + longDate.Year.ToString() + "_" + longDate.AddMonths(-1).Month + ".docx"; //FileStream objfilestream = new FileStream(strdocPath, FileMode.Open, FileAccess.Read); //int len = (int)objfilestream.Length; // Byte[] documentcontents = File.ReadAllBytes(strdocPath); // objfilestream.Read(documentcontents, 0, len); // objfilestream.Close(); //string stringFile = Convert.ToBase64String(documentcontents); //HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, "value"); //response.Content = new StringContent(stringFile, Encoding.UTF8); //response.Content = new StringContent(stringFile); //response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.openxmlformats-officedocument.wordprocessingml.document"); //return response; newGenObject.SaveToDb(true, facturation); //return new HttpResponseMessage(HttpStatusCode.Accepted); //} //catch (Exception e) //{ // throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.NotFound, e.Message)); //lance exception si un attribut dans l'objet est nulle //} }
public List <Employed> getListEmployed() { //int idEmployed = 0; List <Employed> listEmployed = new List <Employed>(); // List<Dependecy> listDependecies = new List<Dependecy>(); var QueryDistinct = from employed in dbContext.t_beneficiaires join Succursal in dbContext.t_succursales on employed.C_id_succ equals Succursal.C_id join Departement in dbContext.t_departement on employed.C_id_depart equals Departement.C_id select new{ employed, Succursal, Departement }; var Query = from employed in dbContext.t_beneficiaires join bonCommand in dbContext.t_bon_commandes on employed.C_id equals bonCommand.C_id_bene join Facturation in dbContext.t_factures on bonCommand.C_id_bon equals Facturation.C_id_bon into Facturation from subfacturation in Facturation.DefaultIfEmpty() join CenterHealth in dbContext.t_centre_soins on bonCommand.C_id_centre equals CenterHealth.C_id_centre join Succursal in dbContext.t_succursales on employed.C_id_succ equals Succursal.C_id join Departement in dbContext.t_departement on employed.C_id_depart equals Departement.C_id select new { employed, bonCommand, subfacturation, CenterHealth, Succursal, Departement }; foreach (var query in QueryDistinct) { List <BonCommand> listDependecies = new List <BonCommand>(); List <BonCommand> MyFacturations = new List <BonCommand>(); int id = query.employed.C_id; string _id = id.ToString(); var result = Query.Where(x => x.employed.C_id.Equals(id)).FirstOrDefault(); int nbreBCmd = Query.Where(x => x.employed.C_id.Equals(id)).ToList().Count; foreach (var itemMyFact in Query.Where(x => x.employed.C_id.Equals(id))) { BonCommand Bcommand = new BonCommand { id = itemMyFact.bonCommand.C_id_bon, datecmd = itemMyFact.bonCommand.C_datedeb, dateValidation = itemMyFact.bonCommand.C_datefin, motif = itemMyFact.bonCommand.C_motif, idBene = itemMyFact.bonCommand.C_id_bene.Value, idHealth = itemMyFact.CenterHealth.C_name, cout = (decimal)(itemMyFact.subfacturation == null ? (0.0M) : itemMyFact.subfacturation.C_cout), nameDoctor = itemMyFact.bonCommand.C_namedoctor, dateFacture = (itemMyFact.subfacturation == null ? String.Empty:itemMyFact.subfacturation.C_datefacture), nameAuthor = itemMyFact.employed.C_name }; if (itemMyFact.subfacturation != null) { MyFacturations.Add(Bcommand); } } var dependecies = from beneficiaire in dbContext.t_beneficiaires join bonCommand in dbContext.t_bon_commandes on beneficiaire.C_id equals bonCommand.C_id_bene join Facturation in dbContext.t_factures on bonCommand.C_id_bon equals Facturation.C_id_bon into Facturation from subFacturation in Facturation.DefaultIfEmpty() join CenterHealth in dbContext.t_centre_soins on bonCommand.C_id_centre equals CenterHealth.C_id_centre where beneficiaire.C_id_parent.Equals(_id) || beneficiaire.C_id_partenaire.Equals(_id) && beneficiaire.C_id_succ.Equals(null) select new { beneficiaire, subFacturation, CenterHealth, bonCommand }; int nbreChilds = dependecies.ToList().Count; foreach (var itemCmd in dependecies) { int idBon = itemCmd.bonCommand.C_id_bon; BonCommand bcmd = new BonCommand { id = itemCmd.bonCommand.C_id_bon, datecmd = itemCmd.bonCommand.C_datedeb, dateValidation = itemCmd.bonCommand.C_datefin, nameDoctor = itemCmd.bonCommand.C_namedoctor, motif = itemCmd.bonCommand.C_motif, idBene = itemCmd.bonCommand.C_id_bene.Value, idHealth = itemCmd.CenterHealth.C_name, cout = (decimal)(itemCmd.subFacturation == null?(0.0M):itemCmd.subFacturation.C_cout), nameAuthor = itemCmd.beneficiaire.C_name, sexeAuthor = itemCmd.beneficiaire.C_sex, dateFacture = (itemCmd.subFacturation == null?string.Empty:itemCmd.subFacturation.C_datefacture) }; if (itemCmd.subFacturation != null) { } listDependecies.Add(bcmd); } // this.AddMyFacturation(query.employed.C_id); if (result != null) { Employed employed = new Employed { Matricule = query.employed.C_mat, id = query.employed.C_id.ToString(), name = result.employed.C_name, sex = result.employed.C_sex, phone = result.employed.C_phone, datenaiss = result.employed.C_datenais, CivilStatus = result.employed.C_statusmaritalk, picture = result.employed.C_picture, ID_Succursale = result.Succursal.C_name, ID_Departement = result.Departement.C_id_depart, CtrBon = nbreBCmd, nbreDepencies = nbreChilds, dependecies = listDependecies, Facturations = MyFacturations }; listEmployed.Add(employed); } else { if (nbreChilds > 0) { Employed employed = new Employed { Matricule = query.employed.C_mat, id = query.employed.C_id.ToString(), name = query.employed.C_name, sex = query.employed.C_sex, phone = query.employed.C_phone, datenaiss = query.employed.C_datenais, CivilStatus = query.employed.C_statusmaritalk, picture = query.employed.C_picture, ID_Succursale = query.Succursal.C_name, ID_Departement = query.Departement.C_id_depart, CtrBon = 0, nbreDepencies = nbreChilds, dependecies = listDependecies }; listEmployed.Add(employed); } } } // HttpContext.Current.Session.Add("reporting", listEmployed); return(listEmployed); }
public void SaveToDb(bool isFactu, dynamic fichier) { DevisFacturationEntities db = new DevisFacturationEntities(); if (!isFactu) { fichier = (Devis)fichier; } else { fichier = (Facturation)fichier; } switch (isFactu) { case false: List <Devis> lesdevis = db.Devis.Where(devisVerif => devisVerif.Commande.Trim().ToLower() == this.epic.Trim().ToLower()).ToList(); if (lesdevis.Count() > 0) { Devis devisAsupprimer = lesdevis[0]; fichier = lesdevis[0]; List <Stories_Devis> storiesDevisASuprimer = db.Stories_Devis.Where(stdevis => stdevis.FK_Devis == devisAsupprimer.ID).ToList(); foreach (Stories_Devis myStoriesDevis in storiesDevisASuprimer) { Stories_d storyASupprimer = db.Stories_d.Where(sas => sas.ID == myStoriesDevis.FK_Stories_d).FirstOrDefault(); List <Tasks_d> tachesAsupprimer = db.Tasks_d.Where(tachasup => tachasup.FK_Stories_d == storyASupprimer.ID).ToList(); foreach (Tasks_d ta in tachesAsupprimer) { db.Tasks_d.Remove(ta); } db.Stories_d.Remove(storyASupprimer); db.Stories_Devis.Remove(myStoriesDevis); } devisAsupprimer.Date = DateTime.Now; db.SaveChanges(); foreach (Projet p in this.projets) { if (!this.verifyProjectExist(p)) { p.save(); } foreach (MasterStories s in p.Stories) { Stories_d stories_d = new Stories_d(s); Stories_Devis stories_Devis = new Stories_Devis(); Projet proj = db.Projet.Where(pro => pro.Nom.Trim().ToLower() == p.Nom.Trim().ToLower()).FirstOrDefault(); stories_d.Fk_Project = proj.Id; stories_d.IsPayed = false; stories_d.Epic = this.epic; stories_Devis.FK_Devis = fichier.ID; stories_d.save(); stories_Devis.FK_Stories_d = stories_d.ID; stories_Devis.CreationDate = DateTime.Now; db.Stories_Devis.Add(stories_Devis); db.SaveChanges(); foreach (MasterTasks ts in s.Tasks) { Tasks_d tasks_d = new Tasks_d(ts); string[] initiales = tasks_d.Initials.Split('+'); foreach (string init in initiales) { Ressource myressource = db.Ressource.Where(rez => rez.Initial == init).FirstOrDefault(); tasks_d.Fk_Ressource_Initials += myressource.ID + ";"; } tasks_d.FK_Stories_d = stories_d.ID; tasks_d.save(); } } } } break; case true: List <Facturation> lesFacturations = db.Facturation.Where(devisVerif => devisVerif.Commande.Trim().ToLower() == this.epic.Trim().ToLower()).ToList(); if (lesFacturations.Count() > 0) { Facturation facturationASupprimer = lesFacturations[0]; fichier = lesFacturations[0]; List <Stories_Facturation> storiesDevisASuprimer = db.Stories_Facturation.Where(stdevis => stdevis.FK_Facturation == facturationASupprimer.ID).ToList(); foreach (Stories_Facturation myStoriesFacturation in storiesDevisASuprimer) { Stories_f storyASupprimer = db.Stories_f.Where(sas => sas.ID == myStoriesFacturation.FK_Stories_f).FirstOrDefault(); List <Tasks_f> tachesAsupprimer = db.Tasks_f.Where(tachasup => tachasup.FK_Stories_f == storyASupprimer.ID).ToList(); foreach (Tasks_f ta in tachesAsupprimer) { db.Tasks_f.Remove(ta); } db.Stories_f.Remove(storyASupprimer); db.Stories_Facturation.Remove(myStoriesFacturation); } facturationASupprimer.Date = DateTime.Now; db.SaveChanges(); foreach (Projet p in this.projets) { if (!this.verifyProjectExist(p)) { p.save(); } foreach (MasterStories s in p.Stories) { Stories_f stories_f = new Stories_f(s); Stories_Facturation stories_Facturation = new Stories_Facturation(); Projet proj = db.Projet.Where(pro => pro.Nom.Trim().ToLower() == p.Nom.Trim().ToLower()).FirstOrDefault(); stories_f.Fk_Project = proj.Id; stories_f.IsPayed = true; stories_f.Epic = this.epic; stories_Facturation.FK_Facturation = fichier.ID; stories_f.save(); stories_Facturation.FK_Stories_f = stories_f.ID; stories_Facturation.CreationDate = DateTime.Now; db.Stories_Facturation.Add(stories_Facturation); db.SaveChanges(); foreach (MasterTasks ts in s.Tasks) { Tasks_f tasks_f = new Tasks_f(ts); string[] initiales = tasks_f.Initials.Split('+'); foreach (string init in initiales) { Ressource myressource = db.Ressource.Where(rez => rez.Initial == init).FirstOrDefault(); tasks_f.Fk_Ressource_Initials += myressource.ID + ";"; } tasks_f.FK_Stories_f = stories_f.ID; tasks_f.save(); } } } } break; } }