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