private void MyRefresh(string siEnReydi) { try { using (SqlExcuteCommand get = new SqlExcuteCommand() { DBCnnStr = DBEndososCnnStr, DBCeeMasterCnnStr = DBCeeMasterImgCnnStr, DBRadicacionesCEECnnStr = DBRadicacionesCEECnnStr }) { txtTotal = "0"; _T = get.MyGetLotInReydi(siEnReydi); txtTotal = string.Format("{0:0,0}", _T.Rows.Count); ItemsSource = new ObservableCollection <InfoReydi>(); foreach (DataRow row in _T.Rows) { int Amount = 0; int ValidatedEndorsements = 0; int RejectedEndorsements = 0; int Num_Candidato = 0; int.TryParse(row["Amount"].ToString(), out Amount); int.TryParse(row["ValidatedEndorsements"].ToString(), out ValidatedEndorsements); int.TryParse(row["RejectedEndorsements"].ToString(), out RejectedEndorsements); int.TryParse(row["Num_Candidato"].ToString(), out Num_Candidato); ItemsSource.Add(new InfoReydi() { Lot = row["Lot"].ToString(), Num_Candidato = Num_Candidato, Nombre = get.MyCandidatoNameToInforme(row["Num_Candidato"].ToString().PadLeft(7, '0')), TotalDeEndosos = Amount, ValidatedEndorsements = ValidatedEndorsements, RejectedEndorsements = RejectedEndorsements, FinUser = row["FinUser"].ToString(), FinDate = row["FinDate"].ToString(), StatusReydi = row["StatusReydi"].ToString() == "1"?"SI":"NO" }); } } } catch (Exception ex) { MethodBase site = ex.TargetSite; MessageBox.Show(ex.Message, site.Name, MessageBoxButton.OK, MessageBoxImage.Error); } }