private void Modifbtn_Click(object sender, RoutedEventArgs e) { try { int id = int.Parse(txtid.Text); if (pathImagePortada != pathup) { } teacher = new Model.Teacher(id, txtnameMod.Text, txtlastnameMod.Text, txtsecondlastnameMod.Text, txtAddressMod.Text, txtPhoneMod.Text, txtemailMod.Text, ubicationPoint.Latitude, ubicationPoint.Longitude, idTown, pathup, pathImagePortada); teacherimpl = new TeacherImpl(); int res = teacherimpl.Update(teacher); if (res > 0) { MessageBox.Show("Teacher Modifed successfully!!!"); LoadDataGrid(); ocultar(); } else { MessageBox.Show("Something happened \nCommunicate with the Suport department \[email protected]"); } } catch (Exception ex) { } }
public void LoadDataGrid() { try { teacherimpl = new TeacherImpl(); dgvDatos.ItemsSource = null; dgvDatos.ItemsSource = teacherimpl.Select().DefaultView; } catch (Exception ex) { } }
public void LoadDataGridDis() { try { teacherimpl = new TeacherImpl(); dgvDatos.ItemsSource = null; dgvDatos.ItemsSource = teacherimpl.SelectDis().DefaultView; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void DgvDatos_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e) { if (dgvDatos.Items.Count > 0 && dgvDatos.SelectedItem != null) { try { modif(); DataRowView dataRow = (DataRowView)dgvDatos.SelectedItem; int id = int.Parse(dataRow.Row.ItemArray[0].ToString()); teacherimpl = new TeacherImpl(); teacher = teacherimpl.Get(id); txtid.Text = teacher.PersonId.ToString(); txtnameMod.Text = teacher.Names; txtnameDel.Text = teacher.Names; txtlastnameMod.Text = teacher.LastName; txtlastnameDel.Text = teacher.LastName; txtsecondlastnameMod.Text = teacher.SecondLastName; txtemailMod.Text = teacher.Email; txtPhoneMod.Text = teacher.Phone; txtAddressMod.Text = teacher.Address; image = new BitmapImage(); image.BeginInit(); image.CacheOption = BitmapCacheOption.OnLoad; image.UriSource = new Uri(DBImplementation.pathImages + teacher.Photo + ".png"); image.EndInit(); imagesector.Source = image; pathImagePortada = DBImplementation.pathImages + teacher.Photo + ".png"; pathup = pathImagePortada; Location ubi = new Location(teacher.Latitude, teacher.Longitude); MyMap.Center = ubi; ubicationPoint = ubi; Pushpin point = new Pushpin(); point.Location = ubi; MyMap.Children.Clear(); MyMap.Children.Add(point); idmodi = teacher.TownId; llamarmuni(teacher.TownId); Modif.IsEnabled = true; Delete.IsEnabled = true; } catch (Exception ex) { } } }
private void Delbtn_Click(object sender, RoutedEventArgs e) { try { int id = int.Parse(txtid.Text); teacher = new Model.Teacher(id, txtnameDel.Text, txtlastnameDel.Text); teacherimpl = new TeacherImpl(); teacherimpl.Delete(teacher); LoadDataGrid(); ocultar(); } catch (Exception ex) { MessageBox.Show("Something happened \nCommunicate with the Suport department \[email protected]"); } }
private void Disabledbtn_Click(object sender, RoutedEventArgs e) { try { if (enable == true) { int id = int.Parse(txtid.Text); teacher = new Model.Teacher(id, "", ""); teacherimpl = new TeacherImpl(); int res = teacherimpl.Disabled(teacher); if (res > 0) { MessageBox.Show("Teacher Disable successfully!!!"); LoadDataGrid(); ocultar(); } else { MessageBox.Show("Something happened \nCommunicate with the Suport department \[email protected]"); } } else { int id = int.Parse(txtid.Text); teacher = new Model.Teacher(id, "", ""); teacherimpl = new TeacherImpl(); int res = teacherimpl.Enabled(teacher); if (res > 0) { MessageBox.Show("Teacher Enable successfully!!!"); LoadDataGridDis(); ocultar(); } else { MessageBox.Show("Something happened \nCommunicate with the Suport department \[email protected]"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Txtsearch_TextChanged(object sender, TextChangedEventArgs e) { try { if (txtsearch.Text == "") { teacherimpl = new TeacherImpl(); dgvDatos.ItemsSource = null; dgvDatos.ItemsSource = teacherimpl.Select().DefaultView; ocultar(); } else { teacherimpl = new TeacherImpl(); dgvDatos.ItemsSource = null; dgvDatos.ItemsSource = teacherimpl.SelectSearch(txtsearch.Text).DefaultView; ocultar(); } } catch (Exception ex) { } }
private void DgvDatos_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e) { if (dgvDatos.Items.Count > 0 && dgvDatos.SelectedItem != null) { try { Disabledbtn.IsEnabled = true; subjects.IsEnabled = true; DataRowView dataRow = (DataRowView)dgvDatos.SelectedItem; int id = int.Parse(dataRow.Row.ItemArray[0].ToString()); teacherimpl = new TeacherImpl(); teacher = teacherimpl.Get(id); txtid.Text = teacher.PersonId.ToString(); namenabled.Content = teacher.Names; lastenabled.Content = teacher.LastName; } catch (Exception ex) { MessageBox.Show(ex.Message); } } }