private void buttonUrgence_Click(object sender, EventArgs e)
{
BO.Veterinaires veto = (BO.Veterinaires) this.comboBoxVeterianire.SelectedItem;
BO.Animaux animal = (BO.Animaux) this.comboBoxAnimal.SelectedItem;
DateTime date = new DateTime(
DateTime.Now.Year,
DateTime.Now.Month,
DateTime.Now.Day,
DateTime.Now.Hour,
DateTime.Now.Minute,
0);
BO.Agenda agenda = new BO.Agenda();
agenda.Veterinaires = veto;
agenda.DateRdv = date;
agenda.Animal = animal;
agenda.Urgence = true;
try
{
BLL.AgendaMgr.Add(agenda);
UpdateContent();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,
GUI.Lang.FORM_DEFAULT_ERROR_TITLE,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
/// <summary>
/// Mode édition de la fenètre pour un animal
/// </summary>
/// <param name="animal"></param>
public DialogAnimal(BO.Animaux animal)
{
InitializeComponent();
UpdateContent();
EditMode(animal);
I18N(); ///!\ DOIT TOUJOURS ETRE APPELER EN DERNIER /!\
}
private void buttonSubmit_Click(object sender, EventArgs e)
{
BO.Veterinaires veto = (BO.Veterinaires) this.comboBoxVeterianire.SelectedItem;
BO.Animaux animal = (BO.Animaux) this.comboBoxAnimal.SelectedItem;
DateTime date = new DateTime(
this.dateTimePicker1.Value.Year,
this.dateTimePicker1.Value.Month,
this.dateTimePicker1.Value.Day,
(int)this.numericUpDownHeure.Value,
(int)this.numericUpDownMin.Value,
0);
BO.Agenda agenda = new BO.Agenda();
agenda.Veterinaires = veto;
agenda.DateRdv = date;
agenda.Animal = animal;
agenda.Urgence = false;
try
{
BLL.AgendaMgr.Add(agenda);
UpdateContent();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,
GUI.Lang.FORM_DEFAULT_ERROR_TITLE,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
/// <summary>
/// Permet de creer l'animal passer en param
/// </summary>
/// <param name="animal"></param>
/// <returns></returns>
public static BO.Animaux Create(BO.Animaux animal)
{
//Ne peut pas être creer si aucun client
if (animal.Client == null)
{
throw new Exception(Lang.ANIMAUX_CREATE_SHOULD_HAVE_CLIENT);
}
return(DAL.Animaux.Create(animal));
}
/// <summary>
/// Permet de passer en mode édition
/// </summary>
/// <param name="animal"></param>
private void EditMode(BO.Animaux animal)
{
mode = DialogAnimalMode.ANIMAL;
animalEdited = animal;
this.textBoxCode.Text = animalEdited.CodeAnimal.ToString();
this.textBoxColor.Text = animalEdited.Couleur;
this.textBoxName.Text = animalEdited.NomAnimal;
this.textBoxTatoo.Text = animalEdited.Tatouage;
this.comboBoxSexe.SelectedIndex = ((List <Char>) this.comboBoxSexe.DataSource).IndexOf(animalEdited.Sexe, 0);
this.comboBoxEspece.SelectedIndex = ((List <String>) this.comboBoxEspece.DataSource).IndexOf(animalEdited.Espece, 0);
this.comboBoxRace.SelectedIndex = ((List <String>) this.comboBoxRace.DataSource).IndexOf(animalEdited.Race, 0);
}
private void buttonValidate_Click(object sender, EventArgs e)
{
try
{
BO.Animaux finalAnimal = animalEdited;
switch (mode)
{
case DialogAnimalMode.CREATE:
case DialogAnimalMode.CLIENT:
finalAnimal = BLL.AnimauxMgr.Create(
new BO.Animaux
{
Sexe = (char)comboBoxSexe.SelectedItem,
Client = (BO.Clients)comboBoxCustomer.SelectedItem,
Couleur = textBoxColor.Text,
NomAnimal = textBoxName.Text,
Tatouage = textBoxTatoo.Text,
Espece = (String)comboBoxEspece.SelectedItem,
Race = (String)comboBoxRace.SelectedItem,
});
break;
case DialogAnimalMode.ANIMAL:
animalEdited.Sexe = (char)comboBoxSexe.SelectedItem;
animalEdited.Client = (BO.Clients)comboBoxCustomer.SelectedItem;
animalEdited.Couleur = textBoxColor.Text;
animalEdited.NomAnimal = textBoxName.Text;
animalEdited.Tatouage = textBoxTatoo.Text;
animalEdited.Espece = (String)comboBoxEspece.SelectedItem;
animalEdited.Race = (String)comboBoxRace.SelectedItem;
if (!BLL.AnimauxMgr.Update(animalEdited))
{
throw new Exception("L'animal n'a pas pu être mis à jour");
}
break;
}
MessageBox.Show(String.Format(Lang.DIALOG_ANIMAL_CREATE_UPDATE_SUCCEFULL, finalAnimal.NomAnimal), Lang.FORM_DEFAULT_CREATE_UPDATE_TITLE, MessageBoxButtons.OK, MessageBoxIcon.Information);
UpdateContent(); //reload data
EditMode(finalAnimal); //Mode edition de cet animal
I18N(); //rafraichis la trad
}
catch (Exception ex)
{
MessageBox.Show(ex.Message,
GUI.Lang.FORM_DEFAULT_ERROR_TITLE,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
/// <summary>
/// Mise a jour de l'animal selectionné
/// </summary>
/// <param name="animal"></param>
public static bool Update(BO.Animaux animal)
{
if (animal.Client == null)
{
throw new Exception(Lang.ANIMAUX_UPDATE_SHOULD_HAVE_CLIENT);
}
if (animal.CodeAnimal == null)
{
throw new Exception(Lang.ANIMAUX_UPDATE_SHOULD_HAVE_CODE);
}
return(DAL.Animaux.Update(animal));
}
/// <summary>
/// Archive l'animal passé en params
/// </summary>
/// <param name="animal"></param>
public static void Delete(BO.Animaux animal)
{
if (animal.CodeAnimal == null)
{
throw new Exception(Lang.ANIMAUX_CANT_DELETE_WITHOUT_GUID);
}
if (DAL.Consultations.GetNonPayed(animal) > 0)
{
throw new Exception(String.Format(Lang.ANIMAUX_CANT_ARCHIVE_CONSULT_NOT_PAID, animal.NomAnimal));
}
DAL.Animaux.Archive(animal);
}
public static int GetNonPayed(BO.Animaux animal)
{
try
{
SqlConnection cnx = DAL.SqlConnexion.OpenConnexion();
String query = @"SELECT COUNT(*)
FROM Consultations c
INNER JOIN Factures f on c.NumFacture = f.NumFacture
WHERE f.Etat<2
AND c.CodeAnimal = @code";
int result = cnx.Query <int>(query, new { code = animal.CodeAnimal }).ToList <int>()[0];
SqlConnexion.CloseConnexion(cnx);
return(result);
}
catch (Exception e)
{
throw e;
}
}
private void buttonDossierMedical_Click(object sender, EventArgs e)
{
BO.Animaux animal = null;
if (this.dataGridViewAgenda.CurrentCell != null)
{
animal = ((BO.Agenda) this.dataGridViewAgenda.CurrentCell.OwningRow.DataBoundItem).Animal;
}
SubFormDossierMedical frm;
if (animal != null)
{
frm = new SubFormDossierMedical(animal);
}
else
{
frm = new SubFormDossierMedical();
}
frm.Show();
}
/// <summary>
/// Permet de passer en mode création
/// </summary>
private void CreateMode(BO.Clients client = null)
{
animalEdited = null;
if (client != null)
{
clientEdited = clientsList.Find(x => x.CodeClient == client.CodeClient);
if (clientEdited == null)
{
this.Close();
MessageBox.Show(GUI.Lang.DIALOG_ANIMAL_CLIENT_ERROR,
GUI.Lang.FORM_DEFAULT_ERROR_TITLE,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
this.comboBoxCustomer.SelectedItem = clientEdited;
mode = DialogAnimalMode.CLIENT;
this.comboBoxCustomer.Enabled = false;
}
this.buttonMedicalFolder.Enabled = false; //Mode création pas de bouton de liaison
}
public static List <BO.Consultations> GetAllByAnimal(BO.Animaux currentAnimal)
{
try
{
var query = @"SELECT * FROM Consultations c, Veterinaires v, Animaux a, Factures f
WHERE c.CodeAnimal = @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();
List <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 = currentAnimal.CodeAnimal },
splitOn: "CodeVeto,CodeAnimal,NumFacture").ToList <BO.Consultations>();
SqlConnexion.CloseConnexion(cnx);
return(results);
}
catch (Exception e)
{
throw e;
}
}
public static BO.Consultations Get(DateTime dateConsultation, BO.Animaux animalParam)
{
try
{
var query = @"SELECT * FROM Consultations c, Veterinaires v, Animaux a, Factures f
WHERE c.CodeAnimal = @animal
AND c.DateConsultation = @date
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 { animal = animalParam.CodeAnimal, date = dateConsultation },
splitOn: "CodeVeto,CodeAnimal,NumFacture").First();
SqlConnexion.CloseConnexion(cnx);
return(results);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Retourne la consultation pour l'animal à la date
/// </summary>
/// <param name="dateConsultation"></param>
/// <param name="animal"></param>
/// <returns></returns>
public static BO.Consultations Get(DateTime dateConsultation, BO.Animaux animal)
{
return(DAL.Consultations.Get(dateConsultation, animal));
}
public static List <BO.Consultations> GetAllByAnimal(BO.Animaux currentAnimal)
{
return(DAL.Consultations.GetAllByAnimal(currentAnimal));
}
