/// <summary> /// /// </summary> /// <param name="StudentData"></param> public void InsertRegistro(Registro RegData) { try { using (TableContext RT = new TableContext(ConnectionString)) { Registro hora = new Registro(); hora.Matricula = RegData.Matricula; hora.Hora_Entrada = RegData.Hora_Entrada; hora.Hora_Salida = RegData.Hora_Salida; hora.Fecha_Entrada = RegData.Fecha_Entrada; hora.Fecha_Salida = RegData.Fecha_Salida; hora.Tipo_Registro = RegData.Tipo_Registro; RT.Registros.InsertOnSubmit(hora); RT.SubmitChanges(); } } catch (Exception ex) { Exception ex2 = ex; while (ex2.InnerException != null) { ex2 = ex2.InnerException; } throw; } }
/// <summary> /// /// </summary> /// <param name="StudentData"></param> public void InsertHorario(Horario HorarioData) { try { using (TableContext HT = new TableContext(ConnectionString)) { Horario horario = new Horario(); horario.Matricula = HorarioData.Matricula; horario.Dia = HorarioData.Dia; horario.Entrada = HorarioData.Entrada; horario.Salida = HorarioData.Salida; HT.Horarios.InsertOnSubmit(horario); HT.SubmitChanges(); } } catch (Exception ex) { Exception ex2 = ex; while (ex2.InnerException != null) { ex2 = ex2.InnerException; } throw; } }
/// <summary> /// /// </summary> /// <param name="StudentData"></param> public void InsertStudent(Student StudentData) { try { using (TableContext ST = new TableContext(ConnectionString)) { Student Stdnt = new Student(); Stdnt.Matricula = StudentData.Matricula; Stdnt.Nombre = StudentData.Nombre; Stdnt.Second_Name = StudentData.Second_Name; Stdnt.Second_Name2 = StudentData.Second_Name2; Stdnt.T_Servicio = StudentData.T_Servicio; Stdnt.Semestre = StudentData.Semestre; Stdnt.Periodo = StudentData.Periodo; Stdnt.Carrera = StudentData.Carrera; ST.Students.InsertOnSubmit(Stdnt); ST.SubmitChanges(); } } catch (Exception ex) { Exception ex2 = ex; while (ex2.InnerException != null) { ex2 = ex2.InnerException; } throw; } }
/// <summary> /// /// </summary> /// <param name="StudentData"></param> public void UpdateHorario(Horario HorarioData) { using (TableContext HT = new TableContext(ConnectionString)) { var horario = (from Row in HT.Horarios where Row.Matricula == HorarioData.Matricula select Row).FirstOrDefault(); horario.Matricula = HorarioData.Matricula; HT.SubmitChanges(); } }
/// <summary> /// /// </summary> /// <param name="StudentData"></param> public void DeleteStudent(Student StudentData) { using (TableContext ST = new TableContext(ConnectionString)) { var student = (from Row in ST.Students where Row.Matricula == StudentData.Matricula select Row).FirstOrDefault(); if (student != null) { ST.Students.DeleteOnSubmit(student); ST.SubmitChanges(); } } }
/// <summary> /// /// </summary> /// <param name="RegData"></param> public void UpdateFromNotification(Registro RegData) { using (TableContext RT = new TableContext(ConnectionString)) { var horario = (from Row in RT.Registros where Row.Matricula == RegData.Matricula select Row).AsEnumerable().LastOrDefault(); if (horario != null) { horario.Hora_Salida = RegData.Hora_Salida; horario.Fecha_Salida = RegData.Fecha_Salida; horario.Tipo_Registro = RegData.Tipo_Registro; RT.SubmitChanges(); } } }
/// <summary> /// /// </summary> /// <param name="StudentData"></param> public void UpdateRegistro(Registro RegData) { using (TableContext RT = new TableContext(ConnectionString)) { var horario = (from Row in RT.Registros where Row.Matricula == RegData.Matricula & Row.Hora_Salida == "00:00" & Row.Tipo_Registro == "E" select Row).FirstOrDefault(); if (horario != null) { horario.Hora_Salida = RegData.Hora_Salida; horario.Fecha_Salida = RegData.Fecha_Salida; horario.Tipo_Registro = RegData.Tipo_Registro; RT.SubmitChanges(); } } }
/// <summary> /// /// </summary> /// <param name="StudentData"></param> public void UpdateStudent(Student StudentData) { using (TableContext ST = new TableContext(ConnectionString)) { var student = (from Row in ST.Students where Row.Matricula == StudentData.Matricula select Row).FirstOrDefault(); student.Matricula = StudentData.Matricula; student.Nombre = StudentData.Nombre; student.Second_Name = StudentData.Second_Name; student.Second_Name2 = StudentData.Second_Name2; student.Carrera = StudentData.Carrera; student.Semestre = StudentData.Semestre; student.T_Servicio = StudentData.T_Servicio; student.Periodo = StudentData.Periodo; ST.SubmitChanges(); } }
/// <summary> /// /// </summary> /// <param name="HorarioData"></param> public void DeleteHorario(Horario HorarioData) { using (TableContext HT = new TableContext(ConnectionString)) { var student = (from Row in HT.Horarios where Row.Matricula == HorarioData.Matricula & Row.Dia == HorarioData.Dia & Row.Entrada == HorarioData.Entrada & Row.Salida == HorarioData.Salida select Row).FirstOrDefault(); if (student != null) { HT.Horarios.DeleteOnSubmit(student); HT.SubmitChanges(); } } }
/// <summary> /// /// </summary> /// <param name="RegData"></param> public void UpdateRegistroFromControl(Registro RegData, Registro NewData) { using (TableContext RT = new TableContext(ConnectionString)) { var horario = (from Row in RT.Registros where Row.Matricula == RegData.Matricula & Row.Fecha_Entrada == RegData.Fecha_Entrada & Row.Fecha_Salida == RegData.Fecha_Salida & Row.Hora_Entrada == RegData.Hora_Entrada & Row.Hora_Salida == RegData.Hora_Salida select Row).FirstOrDefault(); if (horario != null) { horario.Hora_Entrada = NewData.Hora_Entrada; horario.Hora_Salida = NewData.Hora_Salida; horario.Fecha_Entrada = NewData.Fecha_Entrada; horario.Fecha_Salida = NewData.Fecha_Salida; RT.SubmitChanges(); } } }
/// <summary> /// /// </summary> /// <param name="Name"></param> /// <param name="Pass"></param> public void InsertUser(string Name, string Pass) { try { using (TableContext ST = new TableContext(ConnectionString)) { Login sesion = new Login(); sesion.NombreUsuario = Name; sesion.PasswordUsuario = Pass; ST.InicioSesion.InsertOnSubmit(sesion); ST.SubmitChanges(); } } catch (Exception ex) { Exception ex2 = ex; while (ex2.InnerException != null) { ex2 = ex2.InnerException; } throw; } }