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