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