private void InitializeConsultation() { //Pas connecté if (BLL.AccountMgr.loggedAccount == null) { this.Close(); } //Pas connecté en tant que vétérinaires, il est donc impossible de saisir la consultation vetoLogged = BLL.VeterinairesMgr.GetByAccount(BLL.AccountMgr.loggedAccount.Id); if (vetoLogged == null) { this.Close(); } //Chargement animal this.textBoxAniCode.Text = agenda.Animal.CodeAnimal.ToString(); this.textBoxAniColor.Text = agenda.Animal.Couleur; this.textBoxAniEspec.Text = agenda.Animal.Espece; this.textBoxAniName.Text = agenda.Animal.NomAnimal; this.textBoxAniRace.Text = agenda.Animal.Race; this.textBoxAniSexe.Text = agenda.Animal.Sexe.ToString(); this.textBoxAniTatoo.Text = agenda.Animal.Tatouage; //Chargement véto connecté this.textBoxActeVeto.Text = vetoLogged.NomVeto; try { consultation = BLL.ConsultationMgr.Get(agenda.DateRdv, agenda.Animal); this.buttonValidate.Enabled = true; if (consultation.Etat >= (short)BLL.ConsultationsEtat.SAISI_VETO_TERMINER_ET_FACTURE_POSSIBLE) { this.ReadOnly = true; } lignesConsultation = new BindingList <BO.LignesConsultations>(BLL.LignesConsultationsMgr.GetAll((Guid)consultation.CodeConsultation)); //Récupere tout les actes de la consultation } catch (Exception ex) //la consultation n'existe pas { consultation = new BO.Consultations { Animal = agenda.Animal, Etat = (short)BLL.ConsultationsEtat.EN_COURS_DE_SAISIE, Commentaire = "", Facture = null, DateConsultation = agenda.DateRdv, Veterinaire = vetoLogged, Archive = false }; this.buttonValidate.Enabled = false; } this.textBoxComment.Text = consultation.Commentaire; this.dataGridViewActe.DataSource = lignesConsultation; this.comboBoxActeType.DataSource = BLL.BaremesMgr.GetTypeActe(); }
/// <summary> /// Sauvegarde/Met à jour la consultation en base de donnée /// </summary> /// <param name="consultation"></param> /// <returns></returns> public static BO.Consultations Save(BO.Consultations consultation) { if (consultation.CodeConsultation == null) { return(BLL.ConsultationMgr.Create(consultation)); } else { BLL.ConsultationMgr.Update(consultation); return(consultation); } }
/// <summary> /// Met a jour la consultation /// </summary> /// <param name="consultation"></param> /// <returns></returns> public static bool Update(BO.Consultations consultation) { if (consultation.CodeConsultation == null) { throw new Exception("La consultation doit posséder un Guid pour être mis a jour"); } if (consultation.Etat >= (short)BLL.ConsultationsEtat.SAISI_VETO_TERMINER_ET_FACTURE_POSSIBLE) { throw new Exception("La consultation est non modifiable !"); } return(DAL.Consultations.Update(consultation)); }
private void buttonSave_Click(object sender, EventArgs e) { consultation = BLL.ConsultationMgr.Save(consultation); if (consultation == null) { return; } lignesConsultation = new BindingList <BO.LignesConsultations>(BLL.LignesConsultationsMgr.CreateAll(lignesConsultation.ToList(), (Guid)consultation.CodeConsultation)); this.buttonValidate.Enabled = true; this.dataGridViewActe.Refresh(); }
/// <summary> /// Valide la consultation /// La met a jour au préalable /// </summary> /// <param name="consultation"></param> /// <returns></returns> public static bool Validate(BO.Consultations consultation) { try { if (!BLL.ConsultationMgr.Update(consultation)) //On met a jour { return(false); } return(DAL.Consultations.Validate(consultation)); } catch (Exception ex) { throw new Exception(String.Format("Impossible de valider la consultation : {0}", ex.Message)); } }
public static bool Delete(BO.Consultations consultation) { try { SqlConnection cnx = DAL.SqlConnexion.OpenConnexion(); var query = @"DELETE FROM Consultations WHERE CodeConsultation=@consult"; int rowNb = cnx.Execute(query, new { consult = consultation.CodeConsultation }); SqlConnexion.CloseConnexion(cnx); return(rowNb > 0); } catch (Exception e) { throw e; } }
public static BO.Consultations Get(Guid id) { try { var query = @"SELECT * FROM Consultations c, Veterinaires v, Animaux a, Factures f WHERE c.CodeConsultation = @code AND (f.NumFacture=c.NumFacture OR c.NumFacture is null) AND v.CodeVeto=c.CodeVeto AND a.CodeAnimal=c.CodeAnimal"; SqlConnection cnx = DAL.SqlConnexion.OpenConnexion(); BO.Consultations results = cnx.Query <BO.Consultations, BO.Veterinaires, BO.Animaux, BO.Factures, BO.Consultations>(query, (consultation, veto, animal, facture) => { consultation.Veterinaire = veto; consultation.Animal = animal; consultation.Facture = facture; return(consultation); }, new { code = id }, splitOn: "CodeVeto,CodeAnimal,NumFacture").First(); SqlConnexion.CloseConnexion(cnx); return(results); } catch (Exception e) { throw e; } }
public static bool Update(BO.Consultations consultation) { try { SqlConnection cnx = DAL.SqlConnexion.OpenConnexion(); var query = @"UPDATE Consultations SET DateConsultation = @date, CodeVeto = @codeVeto, CodeAnimal = @codeAnimal, Commentaire = @comm, Etat = @etat, NumFacture = @facture, Archive = @archive WHERE CodeConsultation=@consult"; int rowNb = cnx.Execute(query, new { consult = consultation.CodeConsultation, date = consultation.DateConsultation, codeVeto = consultation.Veterinaire.CodeVeto, codeAnimal = consultation.Animal.CodeAnimal, comm = consultation.Commentaire, etat = consultation.Etat, facture = (consultation.Facture != null) ? consultation.Facture.NumFacture : null, archive = consultation.Archive }); SqlConnexion.CloseConnexion(cnx); return(rowNb > 0); } catch (Exception e) { throw e; } }
public static BO.Consultations Create(BO.Consultations consult) { try { SqlConnection cnx = DAL.SqlConnexion.OpenConnexion(); Guid temp = cnx.ExecuteScalar <Guid>("EXEC ajout_consultation @dateconsultation, @codeveto, @cadeanimal, @commentaire, @etat", new { dateconsultation = consult.DateConsultation, codeveto = consult.Veterinaire.CodeVeto, cadeanimal = consult.Animal.CodeAnimal, commentaire = consult.Commentaire, etat = consult.Etat }); consult.CodeConsultation = temp; SqlConnexion.CloseConnexion(cnx); return(consult); } catch (Exception e) { throw e; } }
/// <summary> /// Creer la consultation et retourne l'objet nouvelle crée (Guid définis) /// </summary> /// <param name="consultation"></param> /// <returns></returns> public static BO.Consultations Create(BO.Consultations consultation) { return(DAL.Consultations.Create(consultation)); }
/// <summary> /// Supprime la consultation passé en params /// </summary> /// <param name="consultation"></param> /// <returns></returns> public static bool Delete(BO.Consultations consultation) { return(DAL.Consultations.Delete(consultation)); }