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