public ActionResult ListaUsuarios(string val, string valSearch, int?page)
{
ViewBag.CurrentSort = val;
ViewBag.Buscar = valSearch;
IRepository repository = new Model.Repository();
List <Usuarios> objProduct = new List <Usuarios>();
if (string.IsNullOrEmpty(valSearch))
{
objProduct = repository.FindEntitySet <Usuarios>(c => true).OrderBy(c => c.IdUsuario).ToList();
}
else
{
objProduct = repository.FindEntitySet <Usuarios>(c => true && (c.NombreUsuario.ToString().Contains(valSearch) || c.TipoUsuario.Contains(valSearch))).OrderBy(c => c.IdUsuario).ToList();
}
if (val == "IdUsuario)" || string.IsNullOrEmpty(val))
{
val = "IdUsuario)";
objProduct = objProduct.OrderBy(c => c.IdUsuario).ToList();
}
ViewBag.Order = val;
int pageSize = 5;
int pageNumber = page ?? 1;
return(PartialView(objProduct.ToPagedList(pageNumber, pageSize)));
}
public ActionResult ListaPacientes(string val, string valSearch, int?page)
{
ViewBag.CurrentSort = val;
ViewBag.Buscar = valSearch;
IRepository repository = new Model.Repository();
List <Pacientes> objProduct = new List <Pacientes>();
if (string.IsNullOrEmpty(valSearch))
{
objProduct = repository.FindEntitySet <Pacientes>(c => true).OrderBy(c => c.IdPaciente).ToList();
}
else
{
objProduct = repository.FindEntitySet <Pacientes>(c => true && (c.ApellidoPaterno.Contains(valSearch) || c.ApellidoMaterno.Contains(valSearch))).OrderBy(c => c.Dni).ToList();
}
if (val == "IdPaciente" || string.IsNullOrEmpty(val))
{
val = "IdPaciente";
objProduct = objProduct.OrderBy(c => c.IdPaciente).ToList();
}
ViewBag.Order = val;
int pageSize = 5;
int pageNumber = page ?? 1;
return(PartialView(objProduct.ToPagedList(pageNumber, pageSize)));
}
public ActionResult Retroceso(int min, int max)
{
IRepository repository = new Model.Repository();
var cuestionario = repository.FindEntitySet <Cuestionario>(c => c.Id >= min && c.Id < max + 1).OrderBy(c => c.Id);
return(Json(cuestionario.ToList()));
}
// GET: Productos
public ActionResult Index()
{
IRepository repository = new Model.Repository();
var objProduct = repository.FindEntitySet <Productos>(c => true).OrderBy(c => c.Nombre);
return(View(objProduct));
}
public static string ConsultarFechafin(DateTime fechafinal)
{
IRepository repository = new Model.Repository();
int cantidadcitas = repository.FindEntitySet <Citas>(c => true).Last().IdCita;
Citas objProduct = repository.FindEntitySet <Citas>(c => c.IdCita == cantidadcitas).First();
if (objProduct.Hora_final < fechafinal)
{
return(fechafinal.ToString());
}
else
{
return("error");
}
}
public ActionResult Index()
{
IRepository repository = new Model.Repository();
var cuestionario = repository.FindEntitySet <Cuestionario>(c => c.Id > 0 && c.Id < 6).OrderBy(c => c.Id);
return(View(cuestionario));
}
public static int HistoriasTotales()
{
IRepository repository = new Model.Repository();
var objProduct = repository.FindEntitySet <Historias>(c => true).Count();
return(objProduct);
}
public static int CitasHoy()
{
IRepository repository = new Model.Repository();
var fecha = DateTime.Now.ToString("dd/MM/yyyy");
var objProduct = repository.FindEntitySet <Citas>(c => c.IdCita > 0).Where(c => c.Hora_inicial.Value.ToString("dd/MM/yyyy").Substring(0, 10).Equals(fecha)).Count();
return(objProduct);
}
public static int PacientesTotalesSexo(string sexo)
{
IRepository repository = new Model.Repository();
var objProduct = repository.FindEntitySet <Pacientes>(c => c.Sexo.Equals(sexo)).Count();
return(objProduct);
}
public static DateTime FechaFinal()
{
IRepository repository = new Model.Repository();
Citas cantidadcitas = repository.FindEntitySet <Citas>(c => c.IdCita > 0).Last();
return(Convert.ToDateTime(cantidadcitas.Hora_final));
}
public ActionResult ListaPacientes(int?page, string search = null)
{
IRepository repository = new Model.Repository();
List <Pacientes> objProduct = new List <Pacientes>();
if (string.IsNullOrEmpty(search))
{
objProduct = repository.FindEntitySet <Pacientes>(c => true).OrderBy(c => c.IdPaciente).ToList();
}
else
{
objProduct = repository.FindEntitySet <Pacientes>(c => true && (c.FechaNacimiento.ToString().Contains(search) || c.Nombres.Contains(search) || c.ApellidoPaterno.Contains(search) || c.ApellidoMaterno.ToString().Contains(search) || c.Dni.Contains(search))).OrderBy(c => c.IdPaciente).ToList();
}
int pageSize = 3;
int pageNumber = page ?? 1;
return(PartialView(objProduct.ToPagedList(pageNumber, pageSize)));
}
public ActionResult ListaPsicologos3(int?page)
{
IRepository repository = new Model.Repository();
List <Psicologos> objProduct = new List <Psicologos>();
objProduct = repository.FindEntitySet <Psicologos>(c => true).OrderBy(c => c.IdPsicologo).ToList();
int pageSize = 3;
int pageNumber = page ?? 1;
return(PartialView(objProduct.ToPagedList(pageNumber, pageSize)));
}
public ActionResult ListaDiagnosticos2(int?page, string search = null)
{
IRepository repository = new Model.Repository();
List <Diagnosticos> objProduct = new List <Diagnosticos>();
if (string.IsNullOrEmpty(search))
{
objProduct = repository.FindEntitySet <Diagnosticos>(c => true).OrderBy(c => c.IdDiagnostico).ToList();
}
else
{
objProduct = repository.FindEntitySet <Diagnosticos>(c => true && (c.Fecha.ToString().Contains(search) || c.HoraInicio.Contains(search) || c.IdDiagnostico.ToString().Contains(search) || c.DniPaciente.Contains(search))).OrderBy(c => c.IdDiagnostico).ToList();
}
int pageSize = 3;
int pageNumber = page ?? 1;
return(PartialView(objProduct.ToPagedList(pageNumber, pageSize)));
}
public ActionResult BuscarPacientes(string consulta, int?page = null)
{
ViewBag.Buscar = consulta;
IRepository repository = new Model.Repository();
List <Pacientes> objProduct = new List <Pacientes>();
if (string.IsNullOrEmpty(consulta))
{
objProduct = repository.FindEntitySet <Pacientes>(c => true).OrderBy(c => c.IdPaciente).ToList();
}
else
{
objProduct = repository.FindEntitySet <Pacientes>(c => true && (c.ApellidoPaterno.Contains(consulta) || c.Nombres.Contains(consulta) || c.ApellidoMaterno.Contains(consulta))).OrderBy(c => c.Dni).ToList();
}
int pageSize = 5;
int pageNumber = page ?? 1;
return(View(objProduct.ToPagedList(pageNumber, pageSize)));
}
public ActionResult GetHorarios()
{
IRepository repository = new Model.Repository();
var events = repository.FindEntitySet <Citas>(c => true).ToList();
return(Json(events.AsEnumerable().Select(e => new
{
Id = e.IdCita.ToString(),
title = nombres(e.DniPaciente),
start = e.Hora_inicial.Value.ToString("yyyy-MM-ddTHH:mm"),
end = e.Hora_final.Value.ToString("yyyy-MM-ddTHH:mm")
}).ToList(), JsonRequestBehavior.AllowGet));
}
public static DateTime FechaIni()
{
IRepository repository = new Model.Repository();
try
{
Citas cantidadcitas = repository.FindEntitySet <Citas>(c => c.IdCita > 0).Last();
return(Convert.ToDateTime(cantidadcitas.Hora_inicial));
}
catch (Exception)
{
throw;
}
}
public ActionResult GetAllHorarios()
{
IRepository repository = new Model.Repository();
var events = repository.FindEntitySet <Horarios>(c => true).ToList();
return(Json(events.AsEnumerable().Select(e => new
{
Id = e.Id.ToString(),
title = e.Descripcion,
start = e.FechaInicio.Value.ToString("yyyy-MM-ddTHH:mm"),
end = e.FechaFinal.Value.ToString("yyyy-MM-ddTHH:mm"),
dniPsicologo = e.DniPsicologo.ToString(),
Psicologo = nombres_Psicologo(e.DniPsicologo)
}).ToList(), JsonRequestBehavior.AllowGet));
}
public ActionResult GetEventsPsicolog(string dni)
{
IRepository repository = new Model.Repository();
var events = repository.FindEntitySet <Citas>(c => c.DniPsicologo == dni).ToList();
return(Json(events.AsEnumerable().Select(e => new
{
Id = e.IdCita.ToString(),
title = nombres(e.DniPaciente),
start = e.Hora_inicial.Value.ToString("yyyy-MM-ddTHH:mm"),
end = e.Hora_final.Value.ToString("yyyy-MM-ddTHH:mm"),
description = e.Descripcion,
dniPsicologo = e.DniPsicologo.ToString(),
dniPaciente = e.DniPaciente.ToString(),
Psicologo = nombres_Psicologo(e.DniPsicologo)
}).ToList(), JsonRequestBehavior.AllowGet));
}
public static int DiagnosticosTotalesMes(int mes)
{
IRepository repository = new Model.Repository();
var fechayear = DateTime.Now.Year;
var fechafinal = "";
var fechames = "0";
if (mes >= 1 && mes <= 9)
{
fechames = "0" + mes;
fechafinal = fechayear + "-" + fechames;
}
else if (mes >= 10 && mes <= 12)
{
fechames = mes.ToString();
fechafinal = fechayear + "-" + fechames;
}
var objProduct = repository.FindEntitySet <Diagnosticos>(c => c.Fecha.Value.ToString().Substring(0, 7).Equals(fechafinal)).Count();
return(objProduct);
}
