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