public List <historial> buscar(int cliente) { List <historial> list = new List <historial>(); try { if (con == null) { con = new conexion(); } con.conectar(); SqlCommand cmd = new SqlCommand("_sp_BuscardetalleCita", con.cnxn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@cliente", cliente); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { historial h = new historial(); h.idCliente = dr.GetInt32(0); DateTime?f = (Convert.IsDBNull(dr["fecha"]) ? null : (DateTime?)Convert.ToDateTime(dr["fecha"])); h.fecha = f; h.observacion = (dr["observacion"].Equals(null) ? null : dr["observacion"].ToString().Trim(new char[] { ' ' })); // confirmador = dr.GetString(4).Trim(new char[] { ' ' }); h.veces = (Convert.IsDBNull(dr["veces"]) ? null : (int?)Convert.ToInt32(dr["veces"])); h.hora = (dr["hora"].Equals(null) ? null : dr["hora"].ToString().Trim(new char[] { ' ' })); h.teleoperador = (dr["teleoperador"].Equals(null) ? null : dr["teleoperador"].ToString().Trim(new char[] { ' ' })); list.Add(h); } con.desconectar(); } return(list); } catch { con.desconectar(); return(list); } }
private void MetroWindow_Loaded(object sender, RoutedEventArgs e) { /* txtConfirmador.ItemsSource = llenarCombo(); * txtConfirmador.DisplayMemberPath = "Value"; * txtConfirmador.SelectedValuePath = "Key";*/ txtTeleOperador.ItemsSource = llenarComboTO(); txtTeleOperador.DisplayMemberPath = "Value"; txtTeleOperador.SelectedValuePath = "Key"; if (subStatus != null) { this.Title = Title + " " + subStatus.descripcion + " | " + cli.nombre + " " + cli.apellido; txtobservacion.Focus(); switch (subStatus.idSubStatus) { case 1: txtobservacion.IsEnabled = true; dpFechaNac.IsEnabled = true; hora.IsEnabled = true; min.IsEnabled = true; // txtConfirmador.IsEnabled = true; txtVeces.IsEnabled = false; break; case 2: txtobservacion.IsEnabled = true; dpFechaNac.IsEnabled = false; hora.IsEnabled = false; min.IsEnabled = false; //txtConfirmador.IsEnabled = true; txtVeces.IsEnabled = true; break; case 3: txtobservacion.IsEnabled = true; dpFechaNac.IsEnabled = false; hora.IsEnabled = false; min.IsEnabled = false; //txtConfirmador.IsEnabled = true; txtVeces.IsEnabled = false; break; case 4: txtobservacion.IsEnabled = true; dpFechaNac.IsEnabled = true; hora.IsEnabled = true; min.IsEnabled = true; //txtConfirmador.IsEnabled = true; txtVeces.IsEnabled = false; break; case 5: txtobservacion.IsEnabled = true; dpFechaNac.IsEnabled = false; hora.IsEnabled = false; min.IsEnabled = false; //txtConfirmador.IsEnabled = true; txtVeces.IsEnabled = false; break; default: txtobservacion.IsEnabled = true; dpFechaNac.IsEnabled = false; hora.IsEnabled = false; min.IsEnabled = false; //txtConfirmador.IsEnabled = true; txtVeces.IsEnabled = false; break; } } else { this.Title = Title + " " + subStt.descripcion + " | " + cli.nombre + " " + cli.apellido; if (subStt.id_status == 11) { txtobservacion.IsEnabled = true; dpFechaNac.IsEnabled = true; hora.IsEnabled = true; min.IsEnabled = true; //txtConfirmador.IsEnabled = false; txtVeces.IsEnabled = false; } if (subStt.id_status == 12) { txtobservacion.IsEnabled = true; dpFechaNac.IsEnabled = true; hora.IsEnabled = false; min.IsEnabled = false; // txtConfirmador.IsEnabled = false; txtVeces.IsEnabled = true; } if (subStt.id_status == 2) { txtobservacion.IsEnabled = true; dpFechaNac.IsEnabled = true; hora.IsEnabled = true; min.IsEnabled = true; //txtConfirmador.IsEnabled = true; txtVeces.IsEnabled = false; } if (subStt.id_status != 12 && subStt.id_status != 12 && subStt.id_status != 11 && subStt.id_status != 2) { txtobservacion.IsEnabled = true; dpFechaNac.IsEnabled = false; hora.IsEnabled = false; min.IsEnabled = false; //txtConfirmador.IsEnabled = true; txtVeces.IsEnabled = false; } } Clases.historial his = new Clases.historial(); dtgrdetalle.ItemsSource = his.buscar(cli.id_cliente); }