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