public HttpResponseMessage LogearEmpleado(objGeneral obj)
{
using (gasStationBDEntities entities = new gasStationBDEntities())
{
if (ModelState.IsValid)
{
try
{
string rol = "";
string contrasena = MD5Hash(obj.opcion);
var empleado = entities.empleado.Select(m => new { m.rol, m.activo, m.cedula, m.contrasena }).
Where((x) => x.activo && x.cedula == obj.opcion2 && x.contrasena == contrasena).First();
rol = empleado.rol;
if (rol != "Cajero" && rol != "Administrador")
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized));
}
var informacion = (from e in entities.empleado
join s in entities.sucursal on e.sucursal equals s.nombre
where e.activo && e.cedula == obj.opcion2
select new{ e.sucursal, s.compania, e.rol }).First();
return(Request.CreateResponse(HttpStatusCode.OK, informacion));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Unauthorized)); }
}
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public HttpResponseMessage ReporteTec(objGeneral obj)
{
using (HorasBecaEntities entities = new HorasBecaEntities())
{
if (ModelState.IsValid)
{
try
{
var reporte = (from s in entities.SOLICITUD
join rxe in entities.RESPONSABLEXESTUDIANTE on s.Id equals rxe.IdSolicitud
join u in entities.usuario on rxe.IdResponsable equals u.id
join b in entities.BANCO on s.IdBanco equals b.Id
where s.IdSemestre == obj.opcionInt && s.IdEstado == 4
select new
{
s.Carne,
s.Nombre,
s.Apellido1,
s.Apellido2,
s.HorasAsignadas,
s.AbreviaturaBeca,
s.NumeroCuenta,
Banco = b.Nombre,
NombreR = u.primer_nombre,
Apellido1R = u.primer_apellido,
Apellido2R = u.segundo_apellido
}).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, reporte));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Conflict)); }
}
return(Request.CreateResponse(HttpStatusCode.NotAcceptable));
}
}
public HttpResponseMessage ReporteTS(objGeneral obj)
{
using (HorasBecaEntities entities = new HorasBecaEntities())
{
if (ModelState.IsValid)
{
try
{
var reporte = (from s in entities.SOLICITUD
join b in entities.BECA on s.AbreviaturaBeca equals b.Abreviatura
where s.IdSemestre == obj.opcionInt && s.IdEstado == 4
select new
{
s.Carne,
s.Nombre,
s.Apellido1,
s.Apellido2,
s.HorasAsignadas,
Promedio = s.PonderadoGeneral,
TipoBeca = b.Tipo,
HorasRealizadas = (from ev in entities.EVALUACION
where s.Id == ev.IdSolicitud
select new { ev.HorasLaboradas }).FirstOrDefault()
}).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, reporte));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Conflict)); }
}
return(Request.CreateResponse(HttpStatusCode.NotAcceptable));
}
}
public HttpResponseMessage ReporteAuditoria(objGeneral obj)
{
using (HorasBecaEntities entities = new HorasBecaEntities())
{
if (ModelState.IsValid)
{
try
{
var reporte = (from s in entities.SOLICITUD
join b in entities.BECA on s.AbreviaturaBeca equals b.Abreviatura
join es in entities.ESTADOSOLICITUD on s.IdEstado equals es.Id
where s.IdSemestre == obj.opcionInt
select new
{
s.Carne,
s.Nombre,
s.Apellido1,
s.Apellido2,
Estado = es.Nombre,
TipoBeca = b.Tipo,
}).OrderBy((x) => x.TipoBeca).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, reporte));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Conflict)); }
}
return(Request.CreateResponse(HttpStatusCode.NotAcceptable));
}
}
public HttpResponseMessage certificacionHoras(objGeneral obj)
{
using (HorasBecaEntities entities = new HorasBecaEntities())
{
if (ModelState.IsValid)
{
try
{
var reporte = (from ev in entities.EVALUACION
join s in entities.SOLICITUD on ev.IdSolicitud equals s.Id
join b in entities.BECA on s.AbreviaturaBeca equals b.Abreviatura
join se in entities.SEMESTRE on s.IdSemestre equals se.Id
where ev.IdEstudiante == obj.opcionStr
select new
{
se.Ano,
se.Semestre1,
TipoBeca = b.Tipo,
s.Carne,
ev.HorasLaboradas,
ev.Observacion
}).OrderBy((x) => x.Ano).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, reporte));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Conflict)); }
}
return(Request.CreateResponse(HttpStatusCode.NotAcceptable));
}
}
public HttpResponseMessage VerPeriodo(objGeneral obj)
{
using (HorasBecaEntities entities = new HorasBecaEntities())
{
if (ModelState.IsValid)
{
try
{
var periodo = (from p in entities.PERIODO
where p.Id == obj.opcionInt
select new
{
p.FechaApertura,
p.FechaCierre,
Becas = (from bp in entities.BECAXPERIODO
where bp.IdPeriodo == obj.opcionInt
select new
{
bp.AbreviaturaBeca,
bp.Horas
}).ToList()
}).FirstOrDefault();
return(Request.CreateResponse(HttpStatusCode.OK, periodo));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Conflict)); }
}
return(Request.CreateResponse(HttpStatusCode.NotAcceptable));
}
}
public HttpResponseMessage VerPeriodos(objGeneral obj)
{
using (HorasBecaEntities entities = new HorasBecaEntities())
{
if (ModelState.IsValid)
{
try
{
DateTime actual = DateTime.Now;
var periodos = (from p in entities.PERIODO
where p.IdSemestre == obj.opcionInt
select new
{
p.FechaApertura,
p.FechaCierre,
p.Id,
becas = (from bp in entities.BECAXPERIODO
where bp.IdPeriodo == p.Id
select new
{
bp.AbreviaturaBeca
}).ToList()
}).OrderBy((x) => x.FechaApertura).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, periodos));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Conflict)); }
}
return(Request.CreateResponse(HttpStatusCode.NotAcceptable));
}
}
public void rechazarCancelacion()
{
var controller = new SolicitudesController();
controller.Request = new HttpRequestMessage();
controller.Configuration = new HttpConfiguration();
objGeneral obj = new objGeneral {
opcionInt = 1
};
var response = controller.rechazarCancelacion(obj);
Assert.IsTrue(response.IsSuccessStatusCode);
}
public void VerPeriodos()
{
var controller = new ConfiguracionController();
controller.Request = new HttpRequestMessage();
controller.Configuration = new HttpConfiguration();
objGeneral obj = new objGeneral {
opcionInt = 1
};
var response = controller.VerPeriodos(obj);
Assert.IsNotNull(response.Content);
Assert.IsTrue(response.IsSuccessStatusCode);
}
public void VerGuardadas()
{
var controller = new SolicitudesController();
controller.Request = new HttpRequestMessage();
controller.Configuration = new HttpConfiguration();
objGeneral obj = new objGeneral {
opcionStr = "2015010203"
};
var response = controller.VerGuardadas(obj);
Assert.IsNotNull(response.Content);
Assert.IsTrue(response.IsSuccessStatusCode);
}
public void certificacionHoras()
{
var controller = new ReportesController();
controller.Request = new HttpRequestMessage();
controller.Configuration = new HttpConfiguration();
objGeneral obj = new objGeneral {
opcionStr = "2015010203"
};
var response = controller.certificacionHoras(obj);
Assert.IsNotNull(response.Content);
}
public void ReporteAuditoria()
{
var controller = new ReportesController();
controller.Request = new HttpRequestMessage();
controller.Configuration = new HttpConfiguration();
objGeneral obj = new objGeneral {
opcionInt = 1
};
var response = controller.ReporteAuditoria(obj);
Assert.IsNotNull(response.Content);
}
public void solicitarEstudiantes()
{
var controller = new RetroalimentacionController();
controller.Request = new HttpRequestMessage();
controller.Configuration = new HttpConfiguration();
objGeneral obj = new objGeneral {
opcionInt = 1, opcionInt2 = 1
};
var response = controller.solicitarEstudiantes(obj);
Assert.IsTrue(response.IsSuccessStatusCode);
Assert.IsNotNull(response.Content);
}
public HttpResponseMessage BorrarMedicamento(objGeneral obj)
{
using (gasStationBDEntities entities = new gasStationBDEntities())
{
if (ModelState.IsValid)
{
try
{
entities.BorrarMedicamento(obj.opcion);
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Unauthorized)); }
}
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public HttpResponseMessage ConsultarSucursal(objGeneral obj)
{
using (gasStationBDEntities entities = new gasStationBDEntities())
{
if (ModelState.IsValid)
{
try
{
var sucursales = entities.sucursal.Select(p => new { p.nombre, p.provincia, p.descripcion, p.ciudad, p.senas, p.compania, p.activo }).
Where((x) => x.activo && x.compania == obj.opcion).OrderBy((x) => x.nombre).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, sucursales));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Unauthorized)); }
}
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public void consultarCorreo()
{
var controller = new SolicitudesController();
controller.Request = new HttpRequestMessage();
controller.Configuration = new HttpConfiguration();
objGeneral obj = new objGeneral {
opcionStr = "2015010203"
};
var response = controller.consultarCorreo(obj);
object a;
response.TryGetContentValue(out a);
System.Reflection.PropertyInfo pi = a.GetType().GetProperty("correo_electronico");
string nombre = (string)(pi.GetValue(a, null));
Assert.AreEqual("*****@*****.**", nombre);
Assert.IsNotNull(response.Content);
}
public HttpResponseMessage solicitarEstudiantes(objGeneral obj)
{
using (HorasBecaEntities entities = new HorasBecaEntities())
{
if (ModelState.IsValid)
{
try
{
var estudiantes = (from rxe in entities.RESPONSABLEXESTUDIANTE
join e in entities.estudiantes on rxe.IdEstudiante equals e.carne
join s in entities.SOLICITUD on rxe.IdSolicitud equals s.Id
join se in entities.SEMESTRE on s.IdSemestre equals se.Id
where rxe.IdResponsable == obj.opcionInt2 && se.Id == obj.opcionInt
select new
{
Nombre = e.primer_nombre,
Apellido1 = e.primer_apellido,
Apellido2 = e.segundo_apellido,
Carne = e.carne,
s.HorasAsignadas,
IdSolicitud = s.Id,
Id = (from ev in entities.EVALUACION
where ev.IdEstudiante == e.carne && ev.IdSolicitud == s.Id
select new
{
ev.Id
}).FirstOrDefault(),
Evaluacion = (from ev in entities.EVALUACION
where ev.IdEstudiante == e.carne && ev.IdSolicitud == s.Id
select new
{
ev.HorasLaboradas,
Observaciones = ev.Observacion,
Recomendado = ev.Recomendable
}).FirstOrDefault()
}).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, estudiantes));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Conflict)); }
}
return(Request.CreateResponse(HttpStatusCode.NotAcceptable));
}
}
public void VerSolicitudHATU()
{
var controller = new SolicitudesController();
controller.Request = new HttpRequestMessage();
controller.Configuration = new HttpConfiguration();
objGeneral obj = new objGeneral {
opcionInt = 2
};
var response = controller.VerSolicitudHATU(obj);
object a;
response.TryGetContentValue(out a);
System.Reflection.PropertyInfo pi = a.GetType().GetProperty("Nombre");
string nombre = (string)(pi.GetValue(a, null));
Assert.AreEqual("Raul", nombre);
Assert.IsNotNull(response.Content);
}
public void VerFechasSemestre()
{
var controller = new ConfiguracionController();
controller.Request = new HttpRequestMessage();
controller.Configuration = new HttpConfiguration();
objGeneral obj = new objGeneral {
opcionInt = 1
};
var response = controller.VerFechasSemestre(obj);
object a;
response.TryGetContentValue(out a);
System.Reflection.PropertyInfo pi = a.GetType().GetProperty("FechaInicioEvaluacion");
DateTime fecha = (DateTime)(pi.GetValue(a, null));
Assert.AreEqual(DateTime.Parse("2017-10-10 00:00:00.000"), fecha);
}
public HttpResponseMessage ConsultarEmpleados(objGeneral obj)
{
using (gasStationBDEntities entities = new gasStationBDEntities())
{
if (ModelState.IsValid)
{
try
{
var empleados = (from e in entities.empleado
join s in entities.sucursal on e.sucursal equals s.nombre
where e.activo && s.compania == obj.opcion
select new {
e.nombre1, e.nombre2, e.cedula, e.apellido1, e.apellido2, e.provincia, e.ciudad, e.senas, e.rol, e.sucursal, e.fechanacimiento
}).OrderBy((x) => x.nombre1).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, empleados));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Unauthorized)); }
}
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public HttpResponseMessage ConsultarPedidos(objGeneral obj)
{
using (gasStationBDEntities entities = new gasStationBDEntities())
{
if (ModelState.IsValid)
{
try
{
var pedidos = (from p in entities.pedido
where p.activo && p.sucursal == obj.opcion
select new
{
p.numero,
p.cliente
}).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, pedidos));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Unauthorized)); }
}
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public HttpResponseMessage VerFechasSemestre(objGeneral obj)
{
using (HorasBecaEntities entities = new HorasBecaEntities())
{
if (ModelState.IsValid)
{
try
{
var fechas = (from s in entities.SEMESTRE
where s.Id == obj.opcionInt
select new
{
s.FechaInicioEvaluacion,
s.FechaCierreEvaluacion,
s.FechaTrabajoSocial
}).FirstOrDefault();
return(Request.CreateResponse(HttpStatusCode.OK, fechas));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Conflict)); }
}
return(Request.CreateResponse(HttpStatusCode.NotAcceptable));
}
}
public HttpResponseMessage VerificarCaja(objGeneral obj)
{
using (gasStationBDEntities entities = new gasStationBDEntities())
{
if (ModelState.IsValid)
{
try
{
int cedula = -1;
var cliente = entities.cliente.Select(p => new { p.cedula, p.activo }).
Where((x) => x.activo && x.cedula == obj.opcion2).First();
cedula = cliente.cedula;
if (cedula == -1)
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Unauthorized)); }
}
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public HttpResponseMessage VerificarCaja(objGeneral obj)
{
using (gasStationBDEntities entities = new gasStationBDEntities())
{
if (ModelState.IsValid)
{
try
{
int id = -1;
var caja = entities.caja.Select(p => new { p.id, p.activo, p.sucursal }).
Where((x) => x.activo && x.id == obj.opcion2 && x.sucursal == obj.opcion).First();
id = caja.id;
if (id == -1)
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Unauthorized)); }
}
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public HttpResponseMessage consultarMedicamentosSucursal(objGeneral obj)
{
using (gasStationBDEntities entities = new gasStationBDEntities())
{
if (ModelState.IsValid)
{
try
{
var medicamentos = (from m in entities.medicamento
join ms in entities.medicamentoxsucursal on m.nombre equals ms.medicamento
where ms.activo && ms.sucursal == obj.opcion
select new
{
m.nombre,
m.precio,
m.prescripcion
}).OrderBy((x) => x.nombre).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, medicamentos));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Unauthorized)); }
}
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public HttpResponseMessage consultarDetallePedido(objGeneral obj)
{
using (gasStationBDEntities entities = new gasStationBDEntities())
{
if (ModelState.IsValid)
{
try
{
var detallePedido = (from medPed in entities.medicamentoxpedido
join med in entities.medicamento on medPed.medicamento equals med.nombre
where medPed.pedido == obj.opcion2
select new
{
medPed.medicamento,
medPed.cantidad,
med.precio
}).ToList();
return(Request.CreateResponse(HttpStatusCode.OK, detallePedido));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Unauthorized)); }
}
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public HttpResponseMessage verificarSupervisor(objGeneral obj)
{
using (gasStationBDEntities entities = new gasStationBDEntities())
{
if (ModelState.IsValid)
{
try
{
string rol = "";
string contrasena = MD5Hash(obj.opcion);
var empleado = entities.empleado.Select(m => new { m.rol, m.activo, m.cedula, m.contrasena }).
Where((x) => x.activo && x.cedula == obj.opcion2 && x.contrasena == contrasena).First();
rol = empleado.rol;
if (rol != "Supervisor")
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized));
}
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (DataException) { return(Request.CreateResponse(HttpStatusCode.Unauthorized)); }
}
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
