/// <summary> /// Recupere un objet consultation via la BDD, à partir de son code. /// </summary> /// <param name="codeConsultation">Chaine de caractere correspondat au code de la consultation voulue</param> /// <returns>Objet BO.Consultation</returns> public static BO.Consultation GetConsultationDetail(string codeConsultation) { var consultation = new BO.Consultation(); var commandStored = General.CommandStored("GetConsultationDetail"); commandStored.Parameters.Add("@CodeConsultation", SqlDbType.UniqueIdentifier).Value = new Guid(codeConsultation); using (var resultCommand = commandStored.ExecuteReader(CommandBehavior.SingleRow)) { if (resultCommand.Read()) { consultation = new BO.Consultation { Date = Convert.ToDateTime(resultCommand["DateConsultation"].ToString().Trim()), Heure = resultCommand["DateConsultation"].ToString().Split(' ')[1].Trim(), CodeConsultation = resultCommand["CodeConsultation"].ToString().Trim(), CodeAnimal = resultCommand["CodeAnimal"].ToString().Trim(), NomAnimal = resultCommand["NomAnimal"].ToString().Trim(), NomClient = resultCommand["Nom"].ToString().Trim(), Race = resultCommand["Race"].ToString().Trim(), Couleur = resultCommand["Couleur"].ToString().Trim(), Espece = resultCommand["Espece"].ToString().Trim(), Sexe = resultCommand["Sexe"].ToString().Trim(), Tatouage = resultCommand["Tatouage"].ToString().Trim(), Commentaire = resultCommand["Commentaire"].ToString().Trim(), NomVeto = resultCommand["NomVeto"].ToString().Trim(), Etat = resultCommand["TypeActe"].ToString().Trim(), Libelle = resultCommand["Libelle"].ToString().Trim() }; } } return consultation; }
private void LoadDetail(string codeConsultation = null) { if (codeConsultation != null) { _consultation = BLL.Consultation.GetConsultationDetail(codeConsultation); } TextBoxCode.Text = _consultation.CodeAnimal; TextBoxNom.Text = _consultation.NomAnimal; TextBoxCouleur.Text = _consultation.Couleur; TextBoxEspece.Text = _consultation.Espece; TextBoxRace.Text = _consultation.Race; TextBoxSexe.Text = _consultation.Sexe; TextBoxTatouage.Text = _consultation.Tatouage; //??? TextBoxCommentaire.Document.Blocks.Add(new Paragraph(new Run(_consultation.Commentaire))); DatePickerConsultation.Text = _consultation.Date.ToString("d"); TextBoxNomVeto.Text = _consultation.NomVeto; ComboBoxType.SelectedItem = _consultation.Etat; ComboBoxLibelle.SelectedItem = _consultation.Libelle; //TODO : Autres controles }