public static void refreshCombos(LIVEX.UserControls.AsistenciaMaestros am) { livexEntities context = new livexEntities(); asistencia_maestros a = new asistencia_maestros(); teacher t = new teacher(); if (am.cmbUID.SelectedItem != null || am.cmbUID.Text != "") { string uid = am.cmbUID.SelectedItem.ToString(); a = context.asistencia_maestros.FirstOrDefault(x => x.UID == uid); if (a != null) { am.cmbName.Text = a.Name; am.cmbName.SelectedValue = a.Name; //teacher teacherFound = context.teacher.FirstOrDefault(x => x.uid == a.UID); //if (teacherFound != null) //{ // am.cmbTeacherNames.Text = teacherFound.teacher_names + " " + teacherFound.teacher_lastname; // am.cmbTeacherNames.SelectedValue = teacherFound.teacher_names + " " + teacherFound.teacher_lastname; //} } } }
public static List <TeacherAttendanceView> initTable() { List <TeacherAttendanceView> lstTAttendance = new List <TeacherAttendanceView>(); livexEntities context = new livexEntities(); string today = DateTime.Now.ToString("yyyy-MM-dd"); DateTime todayIS = Convert.ToDateTime(today); List <asistencia_maestros> lstAM = context.asistencia_maestros.Where(x => x.date >= todayIS).ToList(); foreach (asistencia_maestros am in lstAM) { teacher t = context.teacher.FirstOrDefault(x => x.uid == am.UID); TeacherAttendanceView tav = new TeacherAttendanceView(); DateTime shortdate = Convert.ToDateTime(am.date.ToString()); tav.UID = am.UID; tav.Name = am.Name; tav.Date = shortdate.ToShortDateString(); tav.Time = am.hour + ":" + am.min + ":" + am.sec; tav.id = am.asistencia_maestrosID; if (t != null) { tav.TeacherName = t.teacher_names + " " + t.teacher_lastname; } else { tav.TeacherName = ""; } lstTAttendance.Add(tav); } return(lstTAttendance); }
public static void EditSelected(LIVEX.UserControls.AsistenciaMaestros am) { string uid = am.cmbUID.Text; livexEntities context = new livexEntities(); asistencia_maestros teacherAtt = context.asistencia_maestros.FirstOrDefault(x => x.UID == uid); string hour = am.cmbHour.Text; var time = hour.Split(':'); teacherAtt.Name = am.cmbName.Text; teacherAtt.hour = Int32.Parse(time[0]); teacherAtt.min = Int32.Parse(time[1]); if (time.Count() > 2) { teacherAtt.sec = Int32.Parse(time[2]); } else { teacherAtt.sec = 0; } teacherAtt.date = Convert.ToDateTime(am.dpDate.Text); int result = context.SaveChanges(); if (result >= 0) { MessageBox.Show("El registro se guardó exitosamente"); } else { MessageBox.Show("El registro NO se guardó"); } }
public static List <TeacherAttendanceView> FilterTable(DateTime from, DateTime until) { livexEntities context = new livexEntities(); List <TeacherAttendanceView> lstTAttendance = new List <TeacherAttendanceView>(); List <asistencia_maestros> lstAm = context.asistencia_maestros.Where(x => x.date >= from && x.date <= until).ToList(); foreach (asistencia_maestros am in lstAm) { teacher t = context.teacher.FirstOrDefault(x => x.uid == am.UID); TeacherAttendanceView tav = new TeacherAttendanceView(); DateTime shortdate = Convert.ToDateTime(am.date.ToString()); tav.UID = am.UID; tav.Name = am.Name; tav.Date = shortdate.ToShortDateString(); tav.Time = am.hour + ":" + am.min + ":" + am.sec; tav.id = am.asistencia_maestrosID; if (t != null) { tav.TeacherName = t.teacher_names + " " + t.teacher_lastname; } else { tav.TeacherName = ""; } lstTAttendance.Add(tav); } return(lstTAttendance); }
public static int uploadTimerFile(string path, string filename) { try { livexEntities context = new livexEntities(); int result = 0; using (var reader = new StreamReader(path))//(@"C:\Users\Tania\Documents\NewCo\Proyectos\LIVEX\Docs\LogData\HisGLog_0001_20171201.csv")) { int isduplicated = context.asistencia_maestros.Count(x => x.filename == filename); if (isduplicated > 0) { MessageBox.Show("El archivo ya ha sido cargado"); return(0); } int i = 0; while (!reader.EndOfStream) { asistencia_maestros am = new asistencia_maestros(); var line = reader.ReadLine(); var values = line.Split('\t'); if (i > 0) { am.No = Int32.Parse(values[0]); am.DN = Int32.Parse(values[1]); am.UID = values[2]; am.Name = values[3]; am.Status = values[4]; am.Action = Int32.Parse(values[5]); am.APB = Int32.Parse(values[6]); am.JobCode = Int32.Parse(values[7]); am.date = Convert.ToDateTime(Convert.ToDateTime(values[8]).ToShortDateString()); am.hour = Convert.ToDateTime(values[8]).Hour; am.min = Convert.ToDateTime(values[8]).Minute; am.sec = Convert.ToDateTime(values[8]).Second; am.filename = filename; context.asistencia_maestros.Add(am); } i++; } result = context.SaveChanges(); } if (result > 0) { MessageBox.Show("Archivo cargado exitosamente"); return(1); } return(0); } catch (Exception e) { MessageBox.Show(e.Message); return(0); } }
public static void initForm(LIVEX.UserControls.AddStudent s) { livexEntities context = new livexEntities(); categoria c = new categoria(); List <string> catList = new List <string>(); catList = context.categoria.Select(x => x.categoria_nombre).Distinct().ToList(); s.cmbCategoria.ItemsSource = catList; }
public static void initFormtoEdit(LIVEX.UserControls.AddStudent s, object row) { initForm(s); s.btnSaveNewStudent.Visibility = Visibility.Collapsed; s.btnSaveEditStudent.Visibility = Visibility.Visible; livexEntities context = new livexEntities(); BitmapImage b = new BitmapImage(); alumno aToEdit = (alumno)row; s.txtID.Text = aToEdit.idalumno.ToString(); s.txtLabelHeader.Text = "Editar Alumno"; s.txtName.Text = aToEdit.alumno_nombre; s.txtLastName.Text = aToEdit.alumno_apellido_p; s.txtMotherName.Text = aToEdit.alumno_apellido_m; s.dtpBirthDay.Text = aToEdit.fecha_nac; s.txtPhoneHome.Text = aToEdit.telefono_casa; s.txtCellPhone.Text = aToEdit.telefono_celular; s.txtStreet.Text = aToEdit.domicilio_calle; s.txtNumExt.Text = aToEdit.domicilio_no; s.txtCol.Text = aToEdit.domicilio_col; s.cmbMunicipio.Text = aToEdit.domicilio_mun; s.txtZipCode.Text = aToEdit.domicilio_cp; s.cmbState.Text = aToEdit.domicilio_edo; string[] curso; curso = aToEdit.curso_inicial.Split(' '); s.cmbNivel12.Text = curso[1]; s.cmbNivel4.Text = curso[1]; s.cmbTipo.Text = curso[2]; s.cmbTipo2.Text = curso[2]; s.cmbCategoria.Text = curso[0]; if (aToEdit.picture != "" && aToEdit.picture != null) { b.BeginInit(); b.UriSource = new Uri(aToEdit.picture); b.EndInit(); s.imgStudent.ImageSource = b; } if (aToEdit.alumno_factura != null) { s.chkInvoicing.IsChecked = true; s.txtNameInvo.Text = aToEdit.alumno_factura.nombre; s.txtRfc.Text = aToEdit.alumno_factura.rfc; s.cmbStateInv.Text = aToEdit.alumno_factura.estado; s.cmbCiudadInv.Text = aToEdit.alumno_factura.ciudad; s.txtAdressInv.Text = aToEdit.alumno_factura.direccion; s.txtNumAddinv.Text = aToEdit.alumno_factura.direccion_no; s.txtNeighInv.Text = aToEdit.alumno_factura.colonia; s.txtZipCodeInv.Text = aToEdit.alumno_factura.cp; } }
public static List <alumno> DeleteTeacher(object row) { alumno a = (alumno)row; livexEntities context = new livexEntities(); alumno aToDelete = context.alumno.FirstOrDefault(x => x.idalumno == a.idalumno); context.alumno.Remove(aToDelete); context.SaveChanges(); List <alumno> lstStudents = context.alumno.ToList(); return(lstStudents); }
public static void InitCombos(LIVEX.UserControls.AsistenciaMaestros am) { livexEntities context = new livexEntities(); List <teacher> lstTeachers = context.teacher.ToList(); List <asistencia_maestros> lstasm = context.asistencia_maestros.ToList(); List <string> lstUID = new List <string>(); List <string> lstNames = new List <string>(); List <string> lstTeacherNames = new List <string>(); List <string> lstHours = new List <string>(); foreach (asistencia_maestros a in lstasm) { lstUID.Add(a.UID); lstNames.Add(a.Name); } foreach (teacher t in lstTeachers) { lstTeacherNames.Add(t.teacher_names + " " + t.teacher_lastname); } //am.cmbTeacherNames.ItemsSource = lstTeacherNames.Distinct().ToList(); am.cmbUID.ItemsSource = lstUID.Distinct().ToList(); am.cmbName.ItemsSource = lstNames.Distinct().ToList(); am.cmbHour.Items.Add("01:00"); am.cmbHour.Items.Add("02:00"); am.cmbHour.Items.Add("03:00"); am.cmbHour.Items.Add("04:00"); am.cmbHour.Items.Add("05:00"); am.cmbHour.Items.Add("06:00"); am.cmbHour.Items.Add("07:00"); am.cmbHour.Items.Add("08:00"); am.cmbHour.Items.Add("09:00"); am.cmbHour.Items.Add("10:00"); am.cmbHour.Items.Add("11:00"); am.cmbHour.Items.Add("12:00"); am.cmbHour.Items.Add("13:00"); am.cmbHour.Items.Add("14:00"); am.cmbHour.Items.Add("15:00"); am.cmbHour.Items.Add("16:00"); am.cmbHour.Items.Add("17:00"); am.cmbHour.Items.Add("18:00"); am.cmbHour.Items.Add("19:00"); am.cmbHour.Items.Add("20:00"); am.cmbHour.Items.Add("21:00"); am.cmbHour.Items.Add("22:00"); am.cmbHour.Items.Add("23:00"); am.cmbHour.Items.Add("00:00"); }
public static void InitializeCiclo(UserControls.TableTeacherGroup ttg, int teacherID) { livexEntities context = new livexEntities(); List <grupo> lstg = new List <grupo>(); List <ciclo> lstc = new List <ciclo>(); lstg = context.grupo.Where(x => x.MaestroID == teacherID).ToList(); foreach (grupo g in lstg) { lstc.Add(context.ciclo.FirstOrDefault(x => x.idciclo == g.CicloID)); } //c= context.ciclo.Where(x=>x.idciclo==g.) ttg.cmbCiclo.IsEnabled = true; ttg.cmbCiclo.ItemsSource = lstc; }
public static void DeleteTeacher(object dataRow) { teacher_skillsView ts = (teacher_skillsView)dataRow; livexEntities context = new livexEntities(); List <teacher_skills> ls = new List <teacher_skills>(); teacher t = context.teacher.First(x => x.idteacher == ts.ID); ls = context.teacher_skills.Where(x => x.teacherID == ts.ID).ToList(); foreach (teacher_skills s in ls) { context.teacher_skills.Remove(s); } context.teacher.Remove(t); context.SaveChanges(); }
public static void DeleteRow(LIVEX.UserControls.AsistenciaMaestros am, object attRow) { TeacherAttendanceView row = (TeacherAttendanceView)attRow; livexEntities context = new livexEntities(); asistencia_maestros teacherDelete = context.asistencia_maestros.FirstOrDefault(x => x.asistencia_maestrosID == row.id); if (teacherDelete != null) { context.asistencia_maestros.Remove(teacherDelete); int result = context.SaveChanges(); if (result > 0) { MessageBox.Show("El registro se borró exitosamente"); } else { MessageBox.Show("Error al borrar el registro"); } } }
public static void AddAttendaceRow(LIVEX.UserControls.AsistenciaMaestros am) { livexEntities context = new livexEntities(); asistencia_maestros newAtt = new asistencia_maestros(); DateTime date = Convert.ToDateTime(am.dpDate.Text); string hour = am.cmbHour.Text; var time = hour.Split(':'); newAtt.DN = 1; newAtt.UID = am.cmbUID.Text; newAtt.Name = am.cmbName.Text; newAtt.Status = "0"; newAtt.Action = 3; newAtt.APB = 0; newAtt.JobCode = 0; newAtt.date = Convert.ToDateTime(date.ToShortDateString()); newAtt.No = 0; newAtt.filename = "LIVEX_Sys"; newAtt.hour = Int32.Parse(time[0]); newAtt.min = Int32.Parse(time[1]); if (time.Count() > 2) { newAtt.sec = Int32.Parse(time[2]); } else { newAtt.sec = 0; } context.asistencia_maestros.Add(newAtt); int result = context.SaveChanges(); if (result > 0) { MessageBox.Show("El registro se guardó exitosamente"); } else { MessageBox.Show("El registro NO se guardó"); } }
public static void InitializeForm1(UserControls.TableTeacherGroup ttg) { livexEntities context = new livexEntities(); List <ciclo> lstCiclo = new List <ciclo>(); ttg.cmbTeacherNames.ItemsSource = context.teacher.Select(x => new { x.idteacher, x.teacher_names }).ToList(); ttg.cmbTeacherNames.DisplayMemberPath = "teacher_names"; ttg.cmbTeacherNames.SelectedValuePath = "idteacher"; lstCiclo = context.ciclo.Where(x => x.year == DateTime.Today.Year && x.ciclo_side == "A" || x.ciclo_side == "B").OrderBy(x => x.ciclo_num).ToList(); List <string> ciclostring = new List <string>(); foreach (ciclo c in lstCiclo) { string ciclo = "Ciclo " + c.ciclocol + " del " + c.Fecha_inicio + " al " + c.Fecha_fin; ciclostring.Add(ciclo); } ttg.cmbCiclo.ItemsSource = ciclostring; }
public static void LoadCycles(int cNum, LIVEX.UserControls.NewGroup nGroup) { List <ciclo> lstCycle = new List <ciclo>(); livexEntities context = new livexEntities(); lstCycle = context.ciclo.Where(x => x.ciclo_num == cNum && x.year == DateTime.Today.Year).ToList(); if (lstCycle != null) { foreach (ciclo c in lstCycle) { if (c.ciclo_side == "A") { nGroup.dtpFechaInicioEscolar.Text = c.Fecha_inicio; } else if (c.ciclo_side == "B") { nGroup.dtpFechaFinEscolar.Text = c.Fecha_fin; } } } }
public static void DeleteGroup(object datarow) { livexEntities context = new livexEntities(); grupo g = (grupo)datarow; ciclo c = context.ciclo.FirstOrDefault(x => x.idciclo == g.CicloID); grupo_categoria gc = context.grupo_categoria.FirstOrDefault(x => x.idgrupo_categoria == g.CategoriaID); grupo grp = context.grupo.FirstOrDefault(x => x.idgrupo == g.idgrupo); if (c != null && c.ciclo_side == "C") { context.ciclo.Remove(c); } if (gc != null) { context.grupo_categoria.Remove(gc); } if (grp != null) { context.grupo.Remove(grp); } context.SaveChanges(); }
public static int SaveSkills(LIVEX.UserControls.AddTeacher teacher_form_values, int teacherID) { livexEntities context = new livexEntities(); //List<teacher_skills> lts = new List<teacher_skills>(); List <int> skID = new List <int>(); if (teacher_form_values.chkTOEFL.IsChecked == true) { skID.Add(1); } if (teacher_form_values.chkExp.IsChecked == true) { skID.Add(2); } if (teacher_form_values.chkTraining.IsChecked == true) { skID.Add(3); } if (teacher_form_values.chkSimilar.IsChecked == true) { skID.Add(4); } foreach (int s in skID) { teacher_skills ts = new teacher_skills(); ts.teacherID = teacherID; ts.skillID = s; context.teacher_skills.Add(ts); } int result = context.SaveChanges(); return(result); }
public static int SaveGroup(LIVEX.UserControls.NewGroup newGroup) { livexEntities context = new livexEntities(); grupo g = new grupo(); //grupo_categoria gc = new grupo_categoria(); //ciclo c = new ciclo(); string catname = newGroup.cmbCategoria.SelectionBoxItem.ToString(); //int maxg = context.grupo.Count(); //int maxc = context.ciclo.Count(); //int maxgc = 0; string clasificacion = ""; string nivel, dias = "", idioma = ""; ComboBox cmb = new ComboBox(); //maxgc = context.grupo_categoria.Count(); if (newGroup.cmbTipo.Visibility == Visibility.Visible) { cmb = newGroup.cmbTipo; } else { cmb = newGroup.cmbTipo2; } if (cmb.Text == "A" || cmb.Text == "B") { clasificacion = "semi-Intensivo"; } else { clasificacion = "Intensivo"; } foreach (ListBoxItem i in newGroup.lstDias.SelectedItems) { dias = dias + " " + i.Content; } if (newGroup.chkingles.IsChecked == true) { idioma = "Inglés"; } else { idioma = "Francés"; } if (newGroup.cmbNivel4.Visibility == Visibility.Visible) { nivel = newGroup.cmbNivel4.SelectionBoxItem.ToString(); } else { nivel = newGroup.cmbNivel12.SelectionBoxItem.ToString(); } //c.Fecha_inicio = newGroup.dtpFechaInicio.Text; //c.Fecha_fin = newGroup.dtpFechaFin.Text; //c.ciclo_nombre = newGroup.cmbCiclo.SelectionBoxItem.ToString(); //context.ciclo.Add(c); //context.SaveChanges(); categoria catid = context.categoria.FirstOrDefault(x => x.categoria_nombre == catname && x.clasificacion == clasificacion); //gc.grupo_ID = maxg + 1; //gc.categoria_ID = catid.idcategoria; //gc.nivel = Int32.Parse(nivel); //gc.tipo = cmb.SelectionBoxItem.ToString(); //context.grupo_categoria.Add(gc); //context.SaveChanges(); g.nombre_nivel = catname + " " + nivel + " " + cmb.SelectionBoxItem.ToString(); g.Horario_inicio = newGroup.cmbHrInicio.SelectionBoxItem.ToString(); g.Horario_fin = newGroup.cmbHrFin.SelectionBoxItem.ToString(); g.Dias = dias; g.MaestroID = Int32.Parse(newGroup.cmbTeacher.SelectedValue.ToString()); teacher t = context.teacher.FirstOrDefault(x => x.idteacher == g.MaestroID); g.teacher = t; g.Idioma = idioma; if (newGroup.cmbCicloEscolar.SelectedValue != null) { g.CicloID = Int32.Parse(newGroup.cmbCicloEscolar.SelectedValue.ToString()); if (newGroup.dtpFechaInicioEscolar.Text != "") { g.year = Convert.ToDateTime(newGroup.dtpFechaInicioEscolar.Text).Year; } } if (newGroup.cmbCiclo.SelectedValue != null) { g.CicloID = Int32.Parse(newGroup.cmbCiclo.SelectedValue.ToString()); if (newGroup.dtpFechaInicio.Text != "" && newGroup.dtpFechaFin.Text != "") { ciclo c = new ciclo(); c.ciclo_num = (int)g.CicloID; c.Fecha_inicio = newGroup.dtpFechaInicio.Text; c.Fecha_fin = newGroup.dtpFechaFin.Text; c.ciclo_side = "C"; c.ciclocol = "C" + " " + g.nombre_nivel; c.year = Convert.ToDateTime(newGroup.dtpFechaInicio.Text).Year; //context.ciclo.Add(c); g.ciclo = c; g.year = Convert.ToDateTime(newGroup.dtpFechaInicio.Text).Year; } } //g.CategoriaID = maxgc + 1; //g.CicloID = maxc + 1; g.numero_alumnos = Int32.Parse(newGroup.txtCantAlumnos.Text); g.grupo_categoria = new grupo_categoria(); g.grupo_categoria.categoria_ID = catid.idcategoria; g.grupo_categoria.nivel = Int32.Parse(nivel); g.grupo_categoria.tipo = cmb.SelectionBoxItem.ToString(); context.grupo.Add(g); //context.SaveChanges(); return(context.SaveChanges()); }
/// <summary> /// this function creates a new teacher in teachers's table and also adds the list of skills into skill's table /// </summary> /// <param name="teacher_form_values"></param> /// <param name="skills_Values"></param> /// <returns>0-if the DB was updated successfully 1-if there was an exception</returns> public static int SaveTeacher(LIVEX.UserControls.AddTeacher teacher_form_values, int[] skills_Values) { livexEntities context = new livexEntities(); teacher teacher_ = new teacher(); int t_sSaved = 0; int result = 0; //int maxTeacherID = context.teacher.Count(); //int maxTeacher_skillID = context.teacher_skills.Count(); //teacher_.idteacher = maxTeacherID + 1; teacher_.teacher_names = teacher_form_values.txtNewTeacherName.Text; teacher_.teacher_lastname = teacher_form_values.txtNewTeacherApellidos.Text; teacher_.RFC = teacher_form_values.txtTeacherRFC.Text; teacher_.CURP = teacher_form_values.txtTeacherCURP.Text; teacher_.phone = teacher_form_values.txtAddressPhone.Text; teacher_.celphone = teacher_form_values.txtCelPhone.Text; teacher_.email = teacher_form_values.txtEmail.Text; teacher_.birthday = teacher_form_values.dpBirthday.Text; teacher_.street_address = teacher_form_values.txtAddress.Text; teacher_.neighborhood = teacher_form_values.txtNeighbordhood.Text; teacher_.zip_code = teacher_form_values.txtZipCode.Text; teacher_.state = teacher_form_values.txtState.Text; teacher_.sub_state = teacher_form_values.txtSubState.Text; teacher_.emergency_contact_name = teacher_form_values.txtEmergencyName.Text; teacher_.emergency_contact_number = teacher_form_values.txtEmergencyPhone.Text; teacher_.start_date = teacher_form_values.dpStartDate.Text; teacher_.uid = teacher_form_values.txtUID.Text; if (teacher_form_values.imgTeacher.ImageSource != null) { teacher_.picture = teacher_form_values.imgTeacher.ImageSource.ToString(); } else { teacher_.picture = ""; } if (teacher_form_values.rbtnTeacherFemenio.IsChecked == true)//Femenino { teacher_.teacher_gender = "F"; } else if (teacher_form_values.rbtnTeacherMasculino.IsChecked == true)//Masculino { teacher_.teacher_gender = "M"; } teacher_.salary_base = Int32.Parse(teacher_form_values.txtSalarioBase.Text); if (teacher_form_values.rbtnIngles.IsChecked == true)//Ingles { teacher_.language = "Ingles"; } else if (teacher_form_values.rbtnFrances.IsChecked == true)//Frances { teacher_.language = "Frances"; } for (int i = 0; i < skills_Values.Count(); i++) { if (skills_Values[i] == 1) { teacher_skills teacher_Skill = new teacher_skills(); teacher_Skill.skillID = i + 1; teacher_Skill.teacherID = teacher_.idteacher; teacher_Skill.teacher = teacher_; teacher_.teacher_skills.Add(teacher_Skill); //context.teacher_skills.Add(teacher_Skill); //t_sSaved = context.SaveChanges(); } } context.teacher.Add(teacher_); int teachersaved = context.SaveChanges(); //if (teachersaved > 0) //{ // //teacher_Skill.idteacher_skills = maxTeacher_skillID + 1; // teacher_Skill.teacherID = teacher_.idteacher; // for(int i=0; i<skills_Values.Count();i++) // { // if (skills_Values[i] == 1) // { // teacher_Skill.skillID = i+1; // context.teacher_skills.Add(teacher_Skill); // t_sSaved = context.SaveChanges(); // } // } //} //if (t_sSaved > 0 && teachersaved > 0) // result = 0; //else // result = -1; return(result); }
public static int SaveEditTeacher(LIVEX.UserControls.AddTeacher teacher_form_values, int teacherID) { livexEntities context = new livexEntities(); teacher t = new teacher(); bool[] skills = new bool[4]; List <teacher_skills> sl = new List <teacher_skills>(); int result = 0; int resultS = 0; t = context.teacher.FirstOrDefault(x => x.idteacher == teacherID); //sl = context.teacher_skills.Where(x => x.teacherID == teacherID).ToList(); //foreach (teacher_skills s in sl) foreach (teacher_skills s in t.teacher_skills) { switch (s.skillID) { case 1: skills[0] = true; break; case 2: skills[1] = true; break; case 3: skills[2] = true; break; case 4: skills[3] = true; break; } } if (teacher_form_values.chkTOEFL.IsChecked == true) { if (!skills[0]) { teacher_skills ts = new teacher_skills(); ts.skillID = 1; ts.teacher = t; t.teacher_skills.Add(ts); } } if (teacher_form_values.chkExp.IsChecked == true) { if (!skills[1]) { teacher_skills ts = new teacher_skills(); ts.skillID = 2; ts.teacher = t; t.teacher_skills.Add(ts); } } if (teacher_form_values.chkTraining.IsChecked == true) { if (!skills[2]) { teacher_skills ts = new teacher_skills(); ts.skillID = 3; ts.teacher = t; t.teacher_skills.Add(ts); } } if (teacher_form_values.chkSimilar.IsChecked == true) { if (!skills[3]) { teacher_skills ts = new teacher_skills(); ts.skillID = 4; ts.teacher = t; t.teacher_skills.Add(ts); } } t.teacher_names = teacher_form_values.txtNewTeacherName.Text; t.teacher_lastname = teacher_form_values.txtNewTeacherApellidos.Text; t.RFC = teacher_form_values.txtTeacherRFC.Text; t.CURP = teacher_form_values.txtTeacherCURP.Text; t.phone = teacher_form_values.txtAddressPhone.Text; t.celphone = teacher_form_values.txtCelPhone.Text; t.email = teacher_form_values.txtEmail.Text; t.birthday = teacher_form_values.dpBirthday.Text; t.street_address = teacher_form_values.txtAddress.Text; t.neighborhood = teacher_form_values.txtNeighbordhood.Text; t.zip_code = teacher_form_values.txtZipCode.Text; t.state = teacher_form_values.txtState.Text; t.sub_state = teacher_form_values.txtSubState.Text; t.emergency_contact_name = teacher_form_values.txtEmergencyName.Text; t.emergency_contact_number = teacher_form_values.txtEmergencyPhone.Text; t.start_date = teacher_form_values.dpStartDate.Text; t.uid = teacher_form_values.txtUID.Text; if (teacher_form_values.imgTeacher.ImageSource != null) { t.picture = teacher_form_values.imgTeacher.ImageSource.ToString(); } else { t.picture = ""; } if (teacher_form_values.rbtnTeacherFemenio.IsChecked == true) { t.teacher_gender = "F"; } else { t.teacher_gender = "M"; } if (teacher_form_values.rbtnIngles.IsChecked == true) { t.language = "Ingles"; } else { t.language = "Frances"; } t.salary_base = Int32.Parse(teacher_form_values.txtSalarioBase.Text); int resultT = context.SaveChanges(); //if(resultT>=0) //{ // resultS = SaveSkills(teacher_form_values,teacherID); //} if (resultS >= 0 && resultT >= 0) { result = 0; } else { result = -1; } return(result); }
public static int saveEditStudent(LIVEX.UserControls.AddStudent s) { livexEntities context = new livexEntities(); int id = Int32.Parse(s.txtID.Text); alumno a = context.alumno.FirstOrDefault(x => x.idalumno == id); a.alumno_nombre = s.txtName.Text; a.alumno_apellido_p = s.txtLastName.Text; a.alumno_apellido_m = s.txtMotherName.Text; a.fecha_nac = s.dtpBirthDay.Text; a.telefono_casa = s.txtPhoneHome.Text; a.telefono_celular = s.txtCellPhone.Text; a.domicilio_calle = s.txtStreet.Text; a.domicilio_no = s.txtNumExt.Text; a.domicilio_col = s.txtCol.Text; a.domicilio_mun = s.cmbMunicipio.Text; a.domicilio_cp = s.txtZipCode.Text; a.domicilio_edo = s.cmbState.Text; string levelnum = ""; string leveltype = ""; if (s.cmbNivel12.Visibility == Visibility.Visible) { levelnum = s.cmbNivel12.Text; } else { levelnum = s.cmbNivel4.Text; } if (s.cmbTipo.Visibility == Visibility.Visible) { leveltype = s.cmbTipo.Text; } else { leveltype = s.cmbTipo2.Text; } a.curso_inicial = s.cmbCategoria.Text + " " + levelnum + " " + leveltype; if (s.imgStudent.ImageSource != null) { a.picture = s.imgStudent.ImageSource.ToString(); } else { a.picture = ""; } if (s.chkInvoicing.IsChecked == true) { alumno_factura af = new alumno_factura(); af.nombre = s.txtNameInvo.Text; af.rfc = s.txtRfc.Text; af.estado = s.cmbStateInv.Text; af.ciudad = s.cmbCiudadInv.Text; af.direccion = s.txtAdressInv.Text; af.direccion_no = s.txtNumAddinv.Text; af.colonia = s.txtNeighInv.Text; af.cp = s.txtZipCode.Text; a.alumno_factura = af; } int result = context.SaveChanges(); return(result); }
private static void AddGroups(int idTeacher, LIVEX.UserControls.NominaMaestros nom, string[] ciclo) { livexEntities context = new livexEntities(); List <grupo> lstg = new List <grupo>(); int numCycle = Int32.Parse(ciclo[1]); string cycleside = ciclo[2]; string startDate = ciclo[4]; string endDate = ciclo[6]; DateTime date1 = Convert.ToDateTime(startDate); DateTime date2 = Convert.ToDateTime(endDate); ciclo c = context.ciclo.FirstOrDefault(x => x.ciclo_num == numCycle && x.ciclo_side == cycleside && x.Fecha_inicio == startDate && x.Fecha_fin == endDate); List <ciclo> lstCyclesC = context.ciclo.Where(x => x.ciclo_side == "C" && x.year == date1.Year).ToList();// all the 1:1 and enterprise cycles of the year List <ciclo> lstCs = new List <LIVEX.ciclo>(); if (c != null) { lstg = context.grupo.Where(x => x.teacher.idteacher == idTeacher && x.CicloID == c.idciclo).ToList(); foreach (ciclo iC in lstCyclesC) { bool addCycle = false; DateTime d1 = Convert.ToDateTime(iC.Fecha_inicio); DateTime d2 = Convert.ToDateTime(iC.Fecha_fin); if (date1 >= d1 && date1 <= d2) { addCycle = true; } if (addCycle) { //lstCs.Add(iC); grupo g = context.grupo.FirstOrDefault(x => x.teacher.idteacher == idTeacher && x.CicloID == iC.idciclo); if (g != null) { lstg.Add(g); } } } } if (lstg != null) { for (int x = 0; x < lstg.Count; x++) { Grid grdGroup = new Grid(); Thickness margin = grdGroup.Margin; margin.Top = 20; grdGroup.Margin = margin; //Columns ColumnDefinition col1 = new ColumnDefinition(); ColumnDefinition col2 = new ColumnDefinition(); ColumnDefinition col3 = new ColumnDefinition(); ColumnDefinition col4 = new ColumnDefinition(); ColumnDefinition col5 = new ColumnDefinition(); ColumnDefinition col6 = new ColumnDefinition(); ColumnDefinition col7 = new ColumnDefinition(); grdGroup.ColumnDefinitions.Add(col1); grdGroup.ColumnDefinitions.Add(col2); grdGroup.ColumnDefinitions.Add(col3); grdGroup.ColumnDefinitions.Add(col4); grdGroup.ColumnDefinitions.Add(col5); grdGroup.ColumnDefinitions.Add(col6); grdGroup.ColumnDefinitions.Add(col7); //Row RowDefinition row1 = new RowDefinition(); RowDefinition row2 = new RowDefinition(); row2.Height = new GridLength(48); RowDefinition row3 = new RowDefinition(); grdGroup.RowDefinitions.Add(row1); grdGroup.RowDefinitions.Add(row2); grdGroup.RowDefinitions.Add(row3); //Column Header Border myborderGrupo = new Border(); Border myborderHorario = new Border(); Border myborderHr = new Border(); Border myborderLevel = new Border(); Border myborderNivel = new Border(); Border myborderHoras = new Border(); Border myborderHrs = new Border(); myborderGrupo.Background = Brushes.White; myborderGrupo.BorderBrush = Brushes.Black; myborderGrupo.BorderThickness = new Thickness(2, 2, 1, 0); myborderHrs.BorderThickness = new Thickness(0, 2, 2, 0); myborderHorario.BorderThickness = new Thickness(0, 2, 1, 0); myborderHoras.BorderThickness = myborderNivel.BorderThickness = myborderLevel.BorderThickness = myborderHr.BorderThickness = myborderHorario.BorderThickness; myborderHrs.BorderBrush = myborderHoras.BorderBrush = myborderNivel.BorderBrush = myborderLevel.BorderBrush = myborderHr.BorderBrush = myborderHorario.BorderBrush = myborderGrupo.BorderBrush; myborderHrs.Background = myborderHoras.Background = myborderNivel.Background = myborderLevel.Background = myborderHr.Background = myborderHorario.Background = myborderGrupo.Background; TextBlock txtGrupo = new TextBlock(); txtGrupo.Text = "GRUPO " + (x + 1); txtGrupo.TextAlignment = TextAlignment.Center; txtGrupo.FontWeight = FontWeights.Bold; myborderGrupo.Child = txtGrupo; Grid.SetRow(myborderGrupo, 0); Grid.SetColumn(myborderGrupo, 0); TextBlock txtHorario = new TextBlock(); txtHorario.Text = "HORARIO"; txtHorario.FontWeight = FontWeights.Bold; txtHorario.TextAlignment = TextAlignment.Center; myborderHorario.Child = txtHorario; Grid.SetRow(myborderHorario, 0); Grid.SetColumn(myborderHorario, 1); TextBlock txtHr = new TextBlock(); txtHr.Text = lstg[x].Horario_inicio; txtHr.TextAlignment = TextAlignment.Center; txtHr.FontWeight = FontWeights.Bold; myborderHr.Child = txtHr; Grid.SetRow(myborderHr, 0); Grid.SetColumn(myborderHr, 2); TextBlock txtLevel = new TextBlock(); txtLevel.Text = "NIVEL"; txtLevel.TextAlignment = TextAlignment.Center; txtLevel.FontWeight = FontWeights.Bold; myborderLevel.Child = txtLevel; Grid.SetRow(myborderLevel, 0); Grid.SetColumn(myborderLevel, 3); TextBlock txtNivel = new TextBlock(); txtNivel.Text = lstg[x].nombre_nivel; txtNivel.TextAlignment = TextAlignment.Center; txtNivel.FontWeight = FontWeights.Bold; myborderNivel.Child = txtNivel; Grid.SetRow(myborderNivel, 0); Grid.SetColumn(myborderNivel, 4); TextBlock txtHoras = new TextBlock(); txtHoras.Text = "HORAS"; txtHoras.FontWeight = FontWeights.Bold; txtHoras.TextAlignment = TextAlignment.Center; myborderHoras.Child = txtHoras; Grid.SetRow(myborderHoras, 0); Grid.SetColumn(myborderHoras, 5); TextBox txtHrs = new TextBox(); txtHrs.Text = "0"; txtHrs.TextAlignment = TextAlignment.Center; txtHrs.FontWeight = FontWeights.Bold; myborderHrs.Child = txtHrs; txtHrs.KeyUp += new KeyEventHandler(txtHrs_KeyUp); Grid.SetRow(myborderHrs, 0); Grid.SetColumn(myborderHrs, 6); //Add columns header grdGroup.Children.Add(myborderGrupo); grdGroup.Children.Add(myborderHorario); grdGroup.Children.Add(myborderHr); grdGroup.Children.Add(myborderLevel); grdGroup.Children.Add(myborderNivel); grdGroup.Children.Add(myborderHoras); grdGroup.Children.Add(myborderHrs); //Middle Row Border myborderAlumnos = new Border(); Border myborder_SalBase = new Border(); Border myborderComAl = new Border(); Border myborderBAsiP = new Border(); Border myborderBExe = new Border(); Border myborderTotByHr = new Border(); Border myborderTot = new Border(); myborderAlumnos.Background = new SolidColorBrush(Color.FromRgb(25, 156, 174)); myborderAlumnos.BorderBrush = Brushes.Black; myborderAlumnos.BorderThickness = new Thickness(2, 1, 1, 0); myborderTot.BorderThickness = new Thickness(0, 1, 2, 0); myborder_SalBase.BorderThickness = new Thickness(0, 1, 1, 0); myborderTotByHr.BorderThickness = myborderBExe.BorderThickness = myborderBAsiP.BorderThickness = myborderComAl.BorderThickness = myborder_SalBase.BorderThickness; myborderTot.BorderBrush = myborderTotByHr.BorderBrush = myborderBExe.BorderBrush = myborderBAsiP.BorderBrush = myborderComAl.BorderBrush = myborder_SalBase.BorderBrush = myborderAlumnos.BorderBrush; myborderTot.Background = myborderTotByHr.Background = myborderBExe.Background = myborderBAsiP.Background = myborderComAl.Background = myborder_SalBase.Background = myborderAlumnos.Background; TextBlock txtAlumnos = new TextBlock(); txtAlumnos.Text = "# Alumnos "; txtAlumnos.TextAlignment = TextAlignment.Center; myborderAlumnos.Child = txtAlumnos; Grid.SetRow(myborderAlumnos, 1); Grid.SetColumn(myborderAlumnos, 0); TextBlock txtSalBase = new TextBlock(); txtSalBase.Text = "Salario base"; txtSalBase.TextAlignment = TextAlignment.Center; myborder_SalBase.Child = txtSalBase; Grid.SetRow(myborder_SalBase, 1); Grid.SetColumn(myborder_SalBase, 1); TextBlock txtComAl = new TextBlock(); txtComAl.Text = "Comision por\nAlumno"; txtComAl.TextAlignment = TextAlignment.Center; myborderComAl.Child = txtComAl; Grid.SetRow(myborderComAl, 1); Grid.SetColumn(myborderComAl, 2); TextBlock txtBAsiP = new TextBlock(); txtBAsiP.Text = "Bono\nAsistencia y\npuntualidad"; txtBAsiP.TextAlignment = TextAlignment.Center; myborderBAsiP.Child = txtBAsiP; Grid.SetRow(myborderBAsiP, 1); Grid.SetColumn(myborderBAsiP, 3); TextBlock txtBExe = new TextBlock(); txtBExe.Text = "Bono de\nExcelencia "; txtBExe.TextAlignment = TextAlignment.Center; myborderBExe.Child = txtBExe; Grid.SetRow(myborderBExe, 1); Grid.SetColumn(myborderBExe, 4); TextBlock txtTotByHr = new TextBlock(); txtTotByHr.Text = "TOTAL POR\nHORA"; txtTotByHr.TextAlignment = TextAlignment.Center; myborderTotByHr.Child = txtTotByHr; Grid.SetRow(myborderTotByHr, 1); Grid.SetColumn(myborderTotByHr, 5); TextBlock txtTot = new TextBlock(); txtTot.Text = "TOTAL"; txtTot.TextAlignment = TextAlignment.Center; myborderTot.Child = txtTot; Grid.SetRow(myborderTot, 1); Grid.SetColumn(myborderTot, 6); //Add Middle row grdGroup.Children.Add(myborderAlumnos); grdGroup.Children.Add(myborder_SalBase); grdGroup.Children.Add(myborderComAl); grdGroup.Children.Add(myborderBAsiP); grdGroup.Children.Add(myborderBExe); grdGroup.Children.Add(myborderTotByHr); grdGroup.Children.Add(myborderTot); //Last Row Border myborderNoAlumnos = new Border(); Border myborderSalBase = new Border(); Border myborderCComAl = new Border(); Border myborderCBAsiP = new Border(); Border myborderCBExe = new Border(); Border myborderCTotByHr = new Border(); Border mybordercTot = new Border(); myborderNoAlumnos.Background = Brushes.White; myborderCTotByHr.Background = mybordercTot.Background = Brushes.LightBlue; myborderNoAlumnos.BorderBrush = Brushes.Black; myborderNoAlumnos.BorderThickness = new Thickness(2, 1, 1, 2); mybordercTot.BorderThickness = new Thickness(0, 1, 2, 2); myborderCComAl.BorderThickness = new Thickness(0, 1, 1, 2); mybordercTot.BorderBrush = myborderCTotByHr.BorderBrush = myborderCBExe.BorderBrush = myborderCBAsiP.BorderBrush = myborderCComAl.BorderBrush = myborderSalBase.BorderBrush = myborderNoAlumnos.BorderBrush; myborderCBExe.BorderThickness = myborderCBAsiP.BorderThickness = myborderCTotByHr.BorderThickness = myborderSalBase.BorderThickness = myborderCComAl.BorderThickness; myborderCBExe.Background = myborderCBAsiP.Background = myborderCComAl.Background = myborderSalBase.Background = myborderNoAlumnos.Background; TextBlock txtNoAlumnos = new TextBlock(); txtNoAlumnos.Text = lstg[x].numero_alumnos.ToString(); txtNoAlumnos.TextAlignment = TextAlignment.Center; myborderNoAlumnos.Child = txtNoAlumnos; Grid.SetRow(myborderNoAlumnos, 2); Grid.SetColumn(myborderNoAlumnos, 0); TextBlock txtCSalBase = new TextBlock(); txtCSalBase.Text = lstg[x].teacher.salary_base.ToString(); txtCSalBase.TextAlignment = TextAlignment.Center; myborderSalBase.Child = txtCSalBase; Grid.SetRow(myborderSalBase, 2); Grid.SetColumn(myborderSalBase, 1); TextBlock txtCComAl = new TextBlock(); txtCComAl.Text = ((lstg[x].numero_alumnos) * (lstg[x].teacher.salary_base) * (0.15)).ToString(); txtCComAl.TextAlignment = TextAlignment.Center; myborderCComAl.Child = txtCComAl; Grid.SetRow(myborderCComAl, 2); Grid.SetColumn(myborderCComAl, 2); TextBlock txtCBAsiP = new TextBlock(); Decimal bono_asis = (lstg[x].teacher.salary_base + Decimal.Parse(txtCComAl.Text)); txtCBAsiP.TextAlignment = TextAlignment.Center; Decimal Prop_bonoAsis = Decimal.Multiply(bono_asis, 0.2M); txtCBAsiP.Text = Prop_bonoAsis.ToString(); myborderCBAsiP.Child = txtCBAsiP; Grid.SetRow(myborderCBAsiP, 2); Grid.SetColumn(myborderCBAsiP, 3); TextBlock txtCBExe = new TextBlock(); txtCBExe.Text = Prop_bonoAsis.ToString(); txtCBExe.TextAlignment = TextAlignment.Center; myborderCBExe.Child = txtCBExe; Grid.SetRow(myborderCBExe, 2); Grid.SetColumn(myborderCBExe, 4); TextBlock txtCTotByHr = new TextBlock(); txtCTotByHr.Text = (lstg[x].teacher.salary_base + Decimal.Parse(txtCComAl.Text) + Decimal.Parse(txtCBAsiP.Text) + Decimal.Parse(txtCBExe.Text)).ToString(); txtCTotByHr.TextAlignment = TextAlignment.Center; myborderCTotByHr.Child = txtCTotByHr; Grid.SetRow(myborderCTotByHr, 2); Grid.SetColumn(myborderCTotByHr, 5); TextBlock txtcTot = new TextBlock(); txtcTot.Text = Decimal.Multiply(Decimal.Parse(txtCTotByHr.Text), Decimal.Parse(txtHrs.Text)).ToString(); txtcTot.TextAlignment = TextAlignment.Center; txtcTot.FontWeight = FontWeights.Bold; mybordercTot.Child = txtcTot; Grid.SetRow(mybordercTot, 2); Grid.SetColumn(mybordercTot, 6); //Add Last row grdGroup.Children.Add(myborderNoAlumnos); grdGroup.Children.Add(myborderSalBase); grdGroup.Children.Add(myborderCComAl); grdGroup.Children.Add(myborderCBAsiP); grdGroup.Children.Add(myborderCBExe); grdGroup.Children.Add(myborderCTotByHr); grdGroup.Children.Add(mybordercTot); nom.stkContainer.Children.Add(grdGroup); } } }
public static void FillHeaderNom(LIVEX.UserControls.TableTeacherGroup ttg, LIVEX.UserControls.NominaMaestros nom) { livexEntities context = new livexEntities(); List <teacher_skills> lstTs = new List <teacher_skills>(); teacher t = new teacher(); string[] ciclo = ttg.cmbCiclo.Text.Split(' '); string middleDay; int idTeacher = Int32.Parse(ttg.cmbTeacherNames.SelectedValue.ToString()); lstTs = context.teacher_skills.Where(x => x.teacherID == idTeacher).ToList(); t = context.teacher.FirstOrDefault(x => x.idteacher == idTeacher); DateTime firstDay = DateTime.Parse(ciclo[4]); DateTime lastDay = DateTime.Parse(ciclo[6]); middleDay = firstDay.AddDays(12).ToShortDateString(); nom.txtTName.Text = ttg.cmbTeacherNames.Text; nom.txtCiclo.Text = ciclo[0] + " " + ciclo[1] + " " + ciclo[2]; nom.txtFechas.Text = ciclo[4] + " AL\n " + middleDay; nom.txtYear.Text = DateTime.Parse(ciclo[4]).Year.ToString(); nom.txtAlta.Text = t.start_date; if (ciclo[2] == "A") { nom.txtNoSemanas.Text = "SEMANA 1 y 2"; } else { nom.txtNoSemanas.Text = "SEMANA 3 y 4"; } nom.txtFechaInicio.Text = "INICIA \n" + firstDay.ToShortDateString(); nom.txtFechaFin.Text = "TERMINA \n" + lastDay.ToShortDateString(); nom.txtFechaDep.Text = "PARA DEPOSITO " + lastDay.AddDays(2).ToLongDateString().ToUpper(); foreach (teacher_skills ts in lstTs) { switch (ts.skillID) { case 1: nom.txtTOEFL.Foreground = Brushes.Green; break; case 2: nom.txtExp.Foreground = Brushes.Green; break; case 3: nom.txtTra.Foreground = Brushes.Green; break; case 4: nom.txtLic.Foreground = Brushes.Green; break; } } nom.txtSalario_Base.Text = t.salary_base.ToString(); nom.txtSignName.Text = ttg.cmbTeacherNames.Text.ToUpper() + " " + t.teacher_lastname.ToUpper(); nom.txtTeacherName.Text = "TEACHER: " + ttg.cmbTeacherNames.Text.ToUpper() + " " + t.teacher_lastname.ToUpper(); AddGroups(idTeacher, nom, ciclo); }
public static int SaveEditGroup(LIVEX.UserControls.NewGroup editGroup, int idGroupCat, grupo grupo) { livexEntities context = new livexEntities(); grupo g = context.grupo.FirstOrDefault(x => x.idgrupo == grupo.idgrupo); //grupo_categoria gc = context.grupo_categoria.FirstOrDefault(x => x.idgrupo_categoria == idGroupCat); //grupo g = context.grupo.FirstOrDefault(x =>x.idgrupo==gc.grupo_ID); //ciclo c = context.ciclo.FirstOrDefault(x => x.idciclo == g.CicloID); string catname = editGroup.cmbCategoria.SelectionBoxItem.ToString(); string cycle = "", cycleSide = ""; if (editGroup.cmbCicloEscolar.Visibility == Visibility.Visible) { cycle = editGroup.cmbCicloEscolar.SelectedValue.ToString(); cycleSide = "A"; } else { cycle = editGroup.cmbCiclo.SelectedValue.ToString(); cycleSide = "C"; } int cycleNum = Int32.Parse(cycle); ciclo idCiclo = context.ciclo.FirstOrDefault(x => x.ciclo_num == cycleNum && x.year == DateTime.Today.Year && x.ciclo_side == cycleSide); string nivel, dias = "", idioma = ""; ComboBox cmb = new ComboBox(); if (editGroup.chkingles.IsChecked == true) { idioma = "Inglés"; } else { idioma = "Francés"; } string l = "", m = "", mi = "", j = "", v = "", s = ""; foreach (ListBoxItem i in editGroup.lstDias.SelectedItems) { switch (i.Content) { case "L": l = "L "; break; case "M": m = "M "; break; case "Mi": mi = "Mi "; break; case "J": j = "J "; break; case "V": v = "V "; break; case "S": s = "S "; break; } } dias = l + m + mi + j + v + s; if (editGroup.cmbTipo.Visibility == Visibility.Visible) { cmb = editGroup.cmbTipo; } else { cmb = editGroup.cmbTipo2; } if (editGroup.cmbNivel4.Visibility == Visibility.Visible) { nivel = editGroup.cmbNivel4.SelectionBoxItem.ToString(); } else { nivel = editGroup.cmbNivel12.SelectionBoxItem.ToString(); } //c.Fecha_inicio = editGroup.dtpFechaInicio.Text; //c.Fecha_fin = editGroup.dtpFechaFin.Text; //c.ciclocol = editGroup.cmbCiclo.Text; if (g != null) { //g.ciclo.Fecha_inicio = editGroup.dtpFechaInicio.Text; //g.ciclo.Fecha_fin = editGroup.dtpFechaFin.Text; //g.ciclo.ciclocol = editGroup.cmbCiclo.Text; g.CicloID = idCiclo.idciclo; if (editGroup.dtpFechaFinEscolar.Visibility == Visibility.Visible) { //g.ciclo.Fecha_inicio = editGroup.dtpFechaInicioEscolar.Text; //g.ciclo.Fecha_fin = editGroup.dtpFechaFinEscolar.Text; } else { g.ciclo.Fecha_inicio = editGroup.dtpFechaInicio.Text; g.ciclo.Fecha_fin = editGroup.dtpFechaFin.Text; } g.nombre_nivel = catname + " " + nivel + " " + cmb.SelectionBoxItem.ToString(); g.Horario_inicio = editGroup.cmbHrInicio.SelectionBoxItem.ToString(); g.Horario_fin = editGroup.cmbHrFin.SelectionBoxItem.ToString(); g.Dias = dias; g.MaestroID = Int32.Parse(editGroup.cmbTeacher.SelectedValue.ToString()); g.Idioma = idioma; g.numero_alumnos = Int32.Parse(editGroup.txtCantAlumnos.Text); g.grupo_categoria.nivel = Int32.Parse(nivel); g.grupo_categoria.tipo = cmb.SelectionBoxItem.ToString(); g.grupo_categoria.nivel = Int32.Parse(nivel); g.grupo_categoria.tipo = cmb.SelectionBoxItem.ToString(); g.grupo_categoria.grupo_ID = g.idgrupo; //gc.nivel = Int32.Parse(nivel); //gc.tipo = cmb.SelectionBoxItem.ToString(); context.SaveChanges(); } return(0); }