public OutGetResumenRegistrosHistorial GetResumenRegistrosHistorial(InGetRegistrosHistorial Input) { //var response = new ResponseServices<List<MasterBue>>(); var connectionString = ConfigurationManager.ConnectionStrings["AbcMedicalContext"].ConnectionString; var response = new OutGetResumenRegistrosHistorial(); try { var conn = new MySqlConnection(connectionString); conn.Open(); MySqlCommand command = new MySqlCommand(); command.CommandTimeout = 0; command.Connection = conn; var PI_PacienteId = new MySqlParameter("_PacienteId", Input.PacienteId); command.Parameters.Add(PI_PacienteId); command.CommandText = "getResumenRegistrosHistorial"; command.CommandType = CommandType.StoredProcedure; MySqlDataReader datos = command.ExecuteReader(); var list = new List <ResumenRegistroHistorial>(); while (datos.Read()) { var master = new ResumenRegistroHistorial { RegistroClinicoId = datos["RegistroClinicoId"].ToString(), RegistroClinico = datos["RegistroClinico"].ToString(), Cantidad = datos["Cantidad"].ToString() }; list.Add(master); } response.ResumenRegistroHistorial = list; response.State = true; response.Message = "OK"; datos.Close(); command.Dispose(); conn.Dispose(); } catch (Exception ex) { response.State = false; response.Message = ex.Message; } return(response); }
public OutGetRegistrosHistorial getHistorialRegistros(InGetRegistrosHistorial Input) { var response = new OutGetRegistrosHistorial(); try { var dal = new HistoriaDAL(); response = dal.GetRegistrosHistorial(Input); } catch (Exception ex) { response.State = false; response.Message = ex.Message; } return(response); }
public OutGetRegistrosHistorial GetRegistrosHistorial(InGetRegistrosHistorial Input) { //var response = new ResponseServices<List<MasterBue>>(); var connectionString = ConfigurationManager.ConnectionStrings["AbcMedicalContext"].ConnectionString; var response = new OutGetRegistrosHistorial(); try { var conn = new MySqlConnection(connectionString); conn.Open(); MySqlCommand command = new MySqlCommand(); command.CommandTimeout = 0; command.Connection = conn; var PI_PacienteId = new MySqlParameter("_PacienteId", Input.PacienteId); var PI_RegistroClinicoId = new MySqlParameter("_registroClinicoId", Input.RegistroClinicoId); command.Parameters.Add(PI_PacienteId); command.Parameters.Add(PI_RegistroClinicoId); command.CommandText = "getRegistrosHistorial"; command.CommandType = CommandType.StoredProcedure; MySqlDataReader datos = command.ExecuteReader(); var list = new List <RegistroHistorial>(); int numeroFila = 0; while (datos.Read()) { if (numeroFila == 1) { numeroFila = 2; } else { numeroFila = 1; } var master = new RegistroHistorial { NumeroFila = numeroFila, RegistroHistoriaId = datos["RegistroHistoriaId"].ToString(), Asunto = datos["Asunto"].ToString(), Fecha = datos["Fecha"].ToString().Substring(0, 10), Hora = datos["Hora"].ToString(), Profesional = datos["Profesional"].ToString(), RegistroClinico = datos["RegistroClinico"].ToString() }; list.Add(master); } response.RegistrosHistorial = list.OrderByDescending(x => x.RegistroHistoriaId).ToList(); response.State = true; response.Message = "OK"; datos.Close(); command.Dispose(); conn.Dispose(); } catch (Exception ex) { response.State = false; response.Message = ex.Message; } return(response); }
public IHttpActionResult getResumenHistorialRegistros([FromBody] InGetRegistrosHistorial Input) { var action = new RegistroHistoriaAction(); return(Ok(action.getResumenHistorialRegistros(Input))); }