/// <summary> /// Mode ajout de la fenètre /// </summary> public DialogAnimal(BO.Clients client = null) { InitializeComponent(); UpdateContent(); CreateMode(client); I18N(); ///!\ DOIT TOUJOURS ETRE APPELER EN DERNIER /!\ }
/// <summary> /// Creation d'un client /// </summary> /// <param name="client"></param> /// <returns></returns> public static BO.Clients Create(BO.Clients client) { try { SqlConnection cnx = DAL.SqlConnexion.OpenConnexion(); Guid temp = cnx.ExecuteScalar <Guid>("EXEC ajout_client @nom, @prenom, @add, @add2, @cp, @ville, @tel, @ass, @mail, @arch", new { nom = client.NomClient, prenom = client.PrenomClient, add = client.Adresse1, add2 = client.Adresse2, cp = client.CodePostal, ville = client.Ville, tel = client.NumTel, ass = client.Assurance, mail = client.Email, arch = 0 }); client.CodeClient = temp; SqlConnexion.CloseConnexion(cnx); return(client); } catch (Exception e) { throw e; } }
/// <summary> /// Retourne tout les animaux par client, archivé ou non /// </summary> /// <param name="client"></param> /// <param name="archived"></param> /// <returns></returns> public static List <BO.Animaux> GetAllByClient(BO.Clients client, bool archived) { if (client.CodeClient == null) { throw new Exception(Lang.ANIMAUX_CANT_GET_BY_CLIENT_WITHOUT_GUID); } return(DAL.Animaux.GetAllByClient(client, archived)); }
/// <summary> /// Déactive/Active un client /// </summary> /// <param name="client"></param> /// <returns></returns> public static bool Archive(BO.Clients client, bool archived) { try { SqlConnection cnx = DAL.SqlConnexion.OpenConnexion(); var query = @"UPDATE Clients SET Archive=@archive WHERE CodeClient = @codeClient"; int rowNb = cnx.Execute(query, new { codeClient = client.CodeClient, archive = (archived) ? 1 : 0 }); SqlConnexion.CloseConnexion(cnx); return(rowNb > 0); } catch (Exception e) { throw e; } }
private void buttonAddAnimal_Click(object sender, EventArgs e) { BO.Clients client = (BO.Clients) this.comboBoxClient.SelectedItem; if (client != null) { GUI.Dialog.DialogAnimal dialog = new DialogAnimal(client); dialog.ShowDialog(); dialog.Disposed += UpdateContentEvent; } else { MessageBox.Show(GUI.Lang.SUBFORM_PRENDRERDV_ERROR_NOCLIENT, GUI.Lang.FORM_DEFAULT_ERROR_TITLE, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// Archive tout les animaux du clients passé en params /// </summary> /// <param name="client"></param> public static void DeleteAllByClient(BO.Clients client) { if (client.CodeClient == null) { throw new Exception(Lang.ANIMAUX_CANT_DELETE_ANI_CUST_WITHOUT_GUID); } List <BO.Animaux> animaux = DAL.Animaux.GetAllByClient(client); foreach (BO.Animaux animal in animaux) { if (DAL.Consultations.GetNonPayed(animal) > 0) { throw new Exception(String.Format(Lang.ANIMAUX_CANT_ARCHIVE_CONSULT_NOT_PAID, client.getFullName())); } } DAL.Animaux.ArchiveAllByClient(client); }
/// <summary> /// Archive le client passé en paramètre /// </summary> /// <param name="client"></param> /// <returns></returns> public static void Delete(BO.Clients client) { //Vérification du guid if (client.CodeClient == null) { throw new Exception(Lang.CLIENTS_CANT_DELETE_WITHOUT_GUID); } //Vérification client //Toutes les factures doivent être payé pour archiver le client Int32 factureImpayee = BLL.FacturesMgr.Impayees(client); if (factureImpayee > 0) { throw new Exception(String.Format(Lang.CLIENTS_CANT_DELETE_HAVE_NOT_PAID_FACTURE, factureImpayee)); } BLL.AnimauxMgr.DeleteAllByClient(client); DAL.Clients.Archive(client, true); }
/// <summary> /// Retourne le client liée au Guid /// </summary> /// <param name="id"></param> /// <returns></returns> public static BO.Clients Get(Guid?id) { if (id == null) { return(null); } try { var query = @"SELECT * FROM Clients c WHERE CodeClient = @code"; SqlConnection cnx = DAL.SqlConnexion.OpenConnexion(); BO.Clients results = cnx.Query <BO.Clients>(query, new { code = id }).ToList <BO.Clients>().First(); SqlConnexion.CloseConnexion(cnx); return(results); } catch (Exception e) { throw e; } }
/// <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 }
/// <summary> /// Creer le client passé en paramètre /// </summary> /// <param name="client"></param> /// <returns></returns> public static BO.Clients Create(BO.Clients client) { return(DAL.Clients.Create(client)); }
/// <summary> /// Retourne le nombre de facture non payée du client /// </summary> /// <param name="client"></param> /// <returns></returns> public static Int32 Impayees(BO.Clients client) { return(DAL.Factures.CountFactureByClient(client) - DAL.Factures.CountFactureEtatByClient(client, (short)BLL.FacturesEtat.PAYEE)); }
private void comboBoxClient_SelectedIndexChanged(object sender, EventArgs e) { BO.Clients client = (BO.Clients) this.comboBoxClient.SelectedItem; this.comboBoxAnimal.DataSource = BLL.AnimauxMgr.GetAllByClient(client, false); }
/// <summary> /// Retourne l'ensemble des factures d'un client /// </summary> /// <param name="client"></param> /// <returns></returns> public static List <BO.Factures> GetFactureByClient(BO.Clients client) { return(new List <BO.Factures>()); }
/// <summary> /// Retourne le nombre de facture d'un client avec cet état /// </summary> /// <param name="client"></param> /// <param name="etat"></param> /// <returns></returns> public static Int32 CountFactureEtatByClient(BO.Clients client, int etat) { return(0); }
/// <summary> /// Retourne le nombre de facture d'un client /// </summary> /// <param name="client"></param> /// <returns></returns> public static Int32 CountFactureByClient(BO.Clients client) { return(0); }