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