private void btnDeleteClient_Click(object sender, RoutedEventArgs e) { if (listBoxClient.SelectedItems != null) { OVClient ovClient = new OVClient(); ovClient = (OVClient)listBoxClient.SelectedItem; string IdClientDelete = ovClient.Identifiant.ToString(); string connectionString = "SERVER=localhost" + ";" + "DATABASE=megacastingv2" + ";" + "UID=root" + ";" + "PASSWORD="******";"; string Query = @"DELETE FROM client WHERE Identifiant ='" + IdClientDelete + "';"; MySqlConnection MyConn = new MySqlConnection(connectionString); MySqlCommand MyCommand = new MySqlCommand(Query, MyConn); MySqlDataReader MyReader; MyConn.Open(); MyReader = MyCommand.ExecuteReader(); //Rafraichir listBoxClient ListClients.Remove(ovClient); MessageBox.Show("Client Supprimé !"); } else { MessageBox.Show("Sélectionner un élément"); } }
public IActionResult Index() { var model = new ListClients(); model.Clients = _context.Client.Include(c => c.Address).ToList(); return(View("ClientListView", model)); }
public MainWindow() { InitializeComponent(); ListClients newPage = new ListClients(); pageTransitionControl.ShowPage(newPage); cboDate.Content = DateTime.Now.ToString("dd MMMM yyyy"); lbTime.Content = DateTime.Now.ToString("hh:mm:ss tt"); }
private void UpdateListClients() { List <clients> AllClients = Srv.GetAllClients(); foreach (clients cli in AllClients) { ClientViewModel newCli = new ClientViewModel(Srv, cli); ListClients.Add(newCli); } }
/// <summary> /// 收到客户端上线信息 /// </summary> /// <param name="clientAddress"></param> private void ReceiveClientOnline(string clientAddress) { if (App.Current == null) { return; } App.Current.Dispatcher.Invoke(() => { ListClients.Add(clientAddress); }); }
//CHAMP ONGLET CLIENT private void btnAddClient_Click(object sender, RoutedEventArgs e) { if ((MessageBox.Show("Êtes-vous sûr de vouloir créer un nouveau client?", "Warning ! Ajout d'un nouveau client", MessageBoxButton.YesNo, MessageBoxImage.Exclamation) == MessageBoxResult.Yes)) { MainWindow dialog = new MainWindow(); try { OVClient ovClient = new OVClient(); ovClient.NomEntreprise = this.tbNomEts.Text; ovClient.NomResponsable = this.tbNomResp.Text; ovClient.PrenomResponsable = this.tbPrenomResp.Text; ovClient.CiviliteResponsable = this.cbCivResp.Text; ovClient.RueEntreprise = this.tbRueEnt.Text; ovClient.CpEntreprise = int.Parse(this.tbCpEnt.Text); ovClient.VilleEntreprise = tbVilleEnt.Text; ovClient.MailEntreprise = this.tbMailEnt.Text; ovClient.FaxEntreprise = this.tbFaxEnt.Text; ovClient.TelephoneEntreprise = this.tbTelephoneEnt.Text; string connectionString = "SERVER=localhost" + ";" + "DATABASE=megacastingv2" + ";" + "UID=root" + ";" + "PASSWORD="******";"; string Query = @"INSERT INTO client (NomEntreprise, NomResponsable, PrenomResponsable, CiviliteResponsable, RueEntreprise, CpEntreprise, VilleEntreprise, MailEntreprise, FaxEntreprise, TelephoneEntreprise) values('" + ovClient.NomEntreprise + "','" + ovClient.NomResponsable + "','" + ovClient.PrenomResponsable + "','" + ovClient.CiviliteResponsable + "','" + ovClient.RueEntreprise + "','" + ovClient.CpEntreprise + "','" + ovClient.VilleEntreprise + "','" + ovClient.MailEntreprise + "','" + ovClient.FaxEntreprise + "','" + ovClient.TelephoneEntreprise + "');"; MySqlConnection MyConn = new MySqlConnection(connectionString); MySqlCommand MyCommand = new MySqlCommand(Query, MyConn); MySqlDataReader MyReader; MyConn.Open(); MyReader = MyCommand.ExecuteReader(); //Vider donnnées apres insertion tbNomEts.Text = string.Empty; tbNomResp.Text = string.Empty; tbPrenomResp.Text = string.Empty; cbCivResp.Text = string.Empty; tbRueEnt.Text = string.Empty; tbCpEnt.Text = string.Empty; tbVilleEnt.Text = string.Empty; tbMailEnt.Text = string.Empty; tbTelephoneEnt.Text = string.Empty; tbFaxEnt.Text = string.Empty; //Rafraichir listBoxClient ListClients.Add(ovClient); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } } }
private void btnFollowUp_Click(object sender, RoutedEventArgs e) { // FollowUp follow = new FollowUp(); launcherFlag = 1; ListClients newPage = new ListClients(launcherFlag); pageTransitionControl.ShowPage(newPage); // to comment //Change Background btnNewClient.Background = Brushes.White; btnScreening.Background = Brushes.White; btnFollowUp.Background = Brushes.LightGray; button_Copy2.Background = Brushes.White; }
private void button_Copy2_Click(object sender, RoutedEventArgs e) { // ClinicVisit clinic = new ClinicVisit();///that may come back launcherFlag = 2; ListClients newPage = new ListClients(launcherFlag); pageTransitionControl.ShowPage(newPage); // to comment //Change Background btnNewClient.Background = Brushes.White; btnScreening.Background = Brushes.White; btnFollowUp.Background = Brushes.White; button_Copy2.Background = Brushes.LightGray; }
public async Task <IActionResult> IndexSearch(string search) { if (!String.IsNullOrEmpty(search)) { var Clients = await _context.Clients .Where(t => t.Name.Contains(search) || t.Email.Contains(search)) .ToListAsync(); var model = new ListClients(); model.Clients = Clients; return(View("ClientListView", model)); } return(RedirectToAction("Index")); }
public void UnRegisterClient([FromBody] Client client) { try { ListClients.removeClient(client); } catch (Exception) { HttpResponseMessage resMessage = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest) { Content = new StringContent($"Failed unregister this client with the port num {client.port}") }; logger.LogFunc($"Failed to remove the client with the port {client.port}"); throw new HttpResponseException(resMessage); } }
public void RegisterClient([FromBody] Client client) { try { ListClients.addClient(client); } catch (Exception)//Catching all exceptions here as I don't know the specifics { HttpResponseMessage resMessage = new HttpResponseMessage(System.Net.HttpStatusCode.BadRequest) { Content = new StringContent($"Failed to add the client with the port {client.port}") }; logger.LogFunc($"Failed to add the client with the port {client.port}"); throw new HttpResponseException(resMessage); } }
private void HomePage_Click_1(object sender, RoutedEventArgs e) { ListClients newPage = new ListClients(); pageTransitionControl.ShowPage(newPage); }
public void Nouveau() { ClientCourant = Client.GetNewClient(); ListClients.Add(ClientCourant); }
public Clients() { InitializeComponent(); listClient = new ListClients(); this.OpenForms(listClient); }