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