public static Tabla_Catalogo_DiagnosticoDTO GetOneById(Tabla_Catalogo_DiagnosticoDTO oneDiagnostico) { string query = "Select * from Tabla_Catalogo_Diagnostico where Id_Diagnostico = @Id_Diagnostico"; Helpers h = new Helpers(); return(h.GetAllParametized(query, oneDiagnostico)[0]); }
public static Tabla_Catalogo_DiagnosticoDTO GetOneByName(Tabla_Catalogo_DiagnosticoDTO oneDiagnostico) { try { string query = "Select * from Tabla_Catalogo_Diagnostico where Descripcion_Diagnostico = @Descripcion_Diagnostico"; Helpers h = new Helpers(); return(h.GetAllParametized(query, oneDiagnostico)[0]); } catch { /*string conexion = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString; * * SqlConnection cnn; * cnn = new SqlConnection(conexion); * cnn.Open(); * SqlCommand comando = new SqlCommand("SP_Catalogo_Diagnostico", cnn); * comando.CommandType = CommandType.StoredProcedure; * comando.Parameters.AddWithValue("@Opcion", "INSERTAR"); * comando.Parameters.AddWithValue("@Descripcion_Diagnostico", oneDiagnostico.Descripcion_Diagnostico); * SqlDataReader reader = comando.ExecuteReader(); * reader.Read(); * reader.Close();*/ string query = "Select * from Tabla_Catalogo_Diagnostico where Descripcion_Diagnostico = @Descripcion_Diagnostico"; Helpers h = new Helpers(); return(h.GetAllParametized(query, oneDiagnostico)[0]); } /*if (oneDiagnostico.Id_Diagnostico > 0) { * } * else * { * string conexion = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString; * * SqlConnection cnn; * cnn = new SqlConnection(conexion); * cnn.Open(); * SqlCommand comando = new SqlCommand("SP_Catalogo_Diagnostico", cnn); * comando.CommandType = CommandType.StoredProcedure; * comando.Parameters.AddWithValue("@Opcion", "INSERTAR"); * comando.Parameters.AddWithValue("@Descripcion_Diagnostico", oneDiagnostico.Descripcion_Diagnostico); * SqlDataReader reader = comando.ExecuteReader(); * reader.Read(); * reader.Close(); * } * * string query = "Select * from Tabla_Catalogo_Diagnostico where Descripcion_Diagnostico = @Descripcion_Diagnostico"; * Helpers h = new Helpers(); * return h.GetAllParametized(query, oneDiagnostico)[0];*/ }
public static Tabla_Catalogo_DiagnosticoDTO GetOneByName(Tabla_Catalogo_DiagnosticoDTO oneDiagnostico) { try { string query = "Select * from Tabla_Catalogo_Diagnostico where Descripcion_Diagnostico = @Descripcion_Diagnostico"; Helpers h = new Helpers(); return h.GetAllParametized(query, oneDiagnostico)[0]; } catch { /*string conexion = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString; SqlConnection cnn; cnn = new SqlConnection(conexion); cnn.Open(); SqlCommand comando = new SqlCommand("SP_Catalogo_Diagnostico", cnn); comando.CommandType = CommandType.StoredProcedure; comando.Parameters.AddWithValue("@Opcion", "INSERTAR"); comando.Parameters.AddWithValue("@Descripcion_Diagnostico", oneDiagnostico.Descripcion_Diagnostico); SqlDataReader reader = comando.ExecuteReader(); reader.Read(); reader.Close();*/ string query = "Select * from Tabla_Catalogo_Diagnostico where Descripcion_Diagnostico = @Descripcion_Diagnostico"; Helpers h = new Helpers(); return h.GetAllParametized(query, oneDiagnostico)[0]; } /*if (oneDiagnostico.Id_Diagnostico > 0) { } else { string conexion = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString; SqlConnection cnn; cnn = new SqlConnection(conexion); cnn.Open(); SqlCommand comando = new SqlCommand("SP_Catalogo_Diagnostico", cnn); comando.CommandType = CommandType.StoredProcedure; comando.Parameters.AddWithValue("@Opcion", "INSERTAR"); comando.Parameters.AddWithValue("@Descripcion_Diagnostico", oneDiagnostico.Descripcion_Diagnostico); SqlDataReader reader = comando.ExecuteReader(); reader.Read(); reader.Close(); } string query = "Select * from Tabla_Catalogo_Diagnostico where Descripcion_Diagnostico = @Descripcion_Diagnostico"; Helpers h = new Helpers(); return h.GetAllParametized(query, oneDiagnostico)[0];*/ }
protected void addDiagnostico(object sender, EventArgs e) { var oneDiagnostico = new Tabla_Catalogo_DiagnosticoDTO(); oneDiagnostico = DiagnosticoDAO.GetOneByName(oneDiagnostico); ConsultaDiagnosticoDTO oneConsultaDiag = new ConsultaDiagnosticoDTO(); oneConsultaDiag.Id_ConsultaDiagnostico = Id_Agenda; oneConsultaDiag.Id_Consulta = Id_Agenda; oneConsultaDiag.Fecha_ConsultaDiagnostico = DateTime.Now; oneConsultaDiag.Id_FichaIdentificacion = Id_FichaIdentificacion; oneConsultaDiag.Estatus_ConsultaDiagnostico = true; oneConsultaDiag.Id_Diagnostico = oneDiagnostico.Id_Diagnostico; oneConsultaDiag.Observaciones_ConsultaDiagnostico = ""; ConsultaDiagnosticoDAO Insert = new ConsultaDiagnosticoDAO(); Insert.Insert(oneConsultaDiag); loadDiagnosticos(); loadUsuario(); }
public static Tabla_Catalogo_DiagnosticoDTO GetOneById(Tabla_Catalogo_DiagnosticoDTO oneDiagnostico) { string query = "Select * from Tabla_Catalogo_Diagnostico where Id_Diagnostico = @Id_Diagnostico"; Helpers h = new Helpers(); return h.GetAllParametized(query, oneDiagnostico)[0]; }
protected void addDiagnostico() { var oneDiagnostico = new Tabla_Catalogo_DiagnosticoDTO(); oneDiagnostico.Descripcion_Diagnostico = txtSearch.Text; oneDiagnostico = DiagnosticoDAO.GetOneByName(oneDiagnostico); ConsultaDiagnosticoDTO oneConsultaDiag = new ConsultaDiagnosticoDTO(); oneConsultaDiag.Id_ConsultaDiagnostico = Id_Agenda; oneConsultaDiag.Id_Consulta = Id_Agenda; oneConsultaDiag.Fecha_ConsultaDiagnostico = DateTime.Now; oneConsultaDiag.Id_FichaIdentificacion = Id_FichaIdentificacion; oneConsultaDiag.Estatus_ConsultaDiagnostico = true; oneConsultaDiag.Id_Diagnostico = oneDiagnostico.Id_Diagnostico; oneConsultaDiag.Observaciones_ConsultaDiagnostico = ""; ConsultaDiagnosticoDAO Insert = new ConsultaDiagnosticoDAO(); Insert.Insert(oneConsultaDiag); txtSearch.Text=""; Page.Response.Redirect(Page.Request.Url.ToString(), true); loadDiagnosticos(); return; }
public string GetDiagnosticoItems(string search) { List<string> lSearch = search.Split(new char[] { ' ' }).ToList(); var oneDiagnostico = new Tabla_Catalogo_DiagnosticoDTO(); oneDiagnostico.Descripcion_Diagnostico = "%" + search.Trim() + "%"; string query = "Select * from Tabla_Catalogo_Diagnostico where Descripcion_Diagnostico like @Descripcion_Diagnostico"; Helpers h = new Helpers(); var lDiag = h.GetAllParametized(query, oneDiagnostico); string json = JsonConvert.SerializeObject(lDiag); return json; }