private void LoadDataGrid()
{
teacher_list = context.teacher.ToList();
foreach (teacher t in teacher_list)
{
teacher_skillsView ts = new teacher_skillsView();
foreach (teacher_skills s in t.teacher_skills)
{
if (s.skillID == 1)
{
ts.TOEFL = true;
}
if (s.skillID == 2)
{
ts.Exp = true;
}
if (s.skillID == 3)
{
ts.training = true;
}
if (s.skillID == 4)
{
ts.similar = true;
}
}
ts.ID = t.idteacher;
ts.nombre = t.teacher_names;
ts.apellido = t.teacher_lastname;
ts.salario_base = t.salary_base;
ts.idioma = t.language;
ts.sexo = t.teacher_gender;
ts.ID = t.idteacher;
ts.RFC = t.RFC;
ts.CURP = t.CURP;
ts.AddressPhone = t.phone;
ts.CelPhone = t.celphone;
ts.Email = t.email;
ts.Birdthday = t.birthday;
ts.Address = t.street_address;
ts.Neighbordhood = t.neighborhood;
ts.ZipCode = t.zip_code;
ts.State = t.state;
ts.Substate = t.sub_state;
ts.EmergencyName = t.emergency_contact_name;
ts.EmergencyPhone = t.emergency_contact_number;
ts.StartDate = t.start_date;
ts.Picture = t.picture;
ts.UID = t.uid;
skillsandteacher.Add(ts);
}
myDataGrid.ItemsSource = skillsandteacher;
//dgrdTeachers.ItemsSource = teacher_list;
}
private void initializeFormtoEdit(teacher_skillsView rowdata)
{
BitmapImage b = new BitmapImage();
txtMaestroHeader.Text = "Editar " + txtMaestroHeader.Text;
txtIDTeacher.Text = rowdata.ID.ToString();
txtNewTeacherName.Text = rowdata.nombre;
txtNewTeacherApellidos.Text = rowdata.apellido;
txtTeacherRFC.Text = rowdata.RFC;
txtTeacherCURP.Text = rowdata.CURP;
txtAddressPhone.Text = rowdata.AddressPhone;
txtCelPhone.Text = rowdata.CelPhone;
txtEmail.Text = rowdata.Email;
dpBirthday.Text = rowdata.Birdthday;
txtAddress.Text = rowdata.Address;
txtNeighbordhood.Text = rowdata.Neighbordhood;
txtZipCode.Text = rowdata.ZipCode;
txtState.Text = rowdata.State;
txtSubState.Text = rowdata.Substate;
txtEmergencyName.Text = rowdata.EmergencyName;
txtEmergencyPhone.Text = rowdata.EmergencyPhone;
dpStartDate.Text = rowdata.StartDate;
txtUID.Text = rowdata.UID;
if (rowdata.Picture != null && rowdata.Picture != "")
{
b.BeginInit();
b.UriSource = new Uri(rowdata.Picture);
b.EndInit();
imgTeacher.ImageSource = b;
}
if (rowdata.sexo == "F")
{
rbtnTeacherFemenio.IsChecked = true;
}
else
{
rbtnTeacherMasculino.IsChecked = true;
}
if (rowdata.TOEFL)
{
chkTOEFL.IsChecked = true;
}
else
{
chkTOEFL.IsChecked = false;
}
if (rowdata.Exp)
{
chkExp.IsChecked = true;
}
else
{
chkExp.IsChecked = false;
}
if (rowdata.training)
{
chkTraining.IsChecked = true;
}
else
{
chkTraining.IsChecked = false;
}
if (rowdata.similar)
{
chkSimilar.IsChecked = true;
}
else
{
chkSimilar.IsChecked = false;
}
if (rowdata.idioma == "Ingles")
{
rbtnIngles.IsChecked = true;
}
else
{
rbtnFrances.IsChecked = true;
}
teacherID = rowdata.ID;
txtSalarioBase.Text = rowdata.salario_base.ToString();
btnSaveNewTeacher.Visibility = Visibility.Collapsed;
btnSaveEditTeacher.Visibility = Visibility.Visible;
}
