/// <summary>
/// Thread Procedure for Compare Folder algorithm
/// </summary>
public void AuditFilesExecute()
{
lock (lockAudit)
{
try
{
//Retention Deletes older files based on algorithm
foreach (DataRow row in dtAuditFilesConfig.Rows)
{
AuditFolder AudFolder1 = new AuditFolder(row, dtSignaturesConfig);
if (ExecuteTime(AudFolder1))
{
AudFolder1.SMTPPort = SMTPPort;
AudFolder1.SMTPServer = SMTPServer;
AudFolder1.SMTPUseSSL = SMTPUseSSL;
AudFolder1.SMTPUseDefaultCredentials = SMTPUseDefaultCredentials;
AudFolder1.SMTPUsername = SMTPUsername;
AudFolder1.SMTPPassword = SMTPPassword;
AudFolder1.EmailFrom = EmailFrom;
AudFolder1.EmailTo = EmailTo;
AudFolder1.Execute(ref blShuttingDown);
}
}
}
catch (Exception ex)
{
string strErr = ex.Message + ": " + ex.Source + " " + ex.StackTrace;
writeError(strErr, System.Diagnostics.EventLogEntryType.Error, 6000, 60);
}
}
}
private ObservableCollection <AuditFolder> GenerateItems()
{
int conta = 1;
var folders = new ObservableCollection <AuditFolder>();
//using (var data = new DataAccess())
//{
//xoperac = data.GetList<taudit00>(false).Where(x => x.careas == taudit01).OrderBy(x => x.clinea).ToList();
//var taudit02 = (from a in xoperac
// group a by new
// {
// a.clinea,
// }
// into b
// select new
// {
// Clinea = b.Key.clinea,
// Qtaudi = b.Count()
// }).ToList();
var resumenaudit = App.baseDatos.GetList <raudit00>(false).Where(x => x.careas == taudit01).GroupBy(x => x.clinea).Select(x => x.First()).OrderBy(x => x.clinea).ToList();
foreach (var record in resumenaudit)
{
var subfol01 = new SubFolder();
var subfolders = new ObservableCollection <SubFolder>();
int xqaprob = App.baseDatos.GetList <raudit00>(false).Where(x => x.careas == taudit01 && x.clinea == record.clinea).ToList().Sum(x => x.qaprob);
int xqdesap = App.baseDatos.GetList <raudit00>(false).Where(x => x.careas == taudit01 && x.clinea == record.clinea).ToList().Sum(x => x.qdesap);
int xqaprex = App.baseDatos.GetList <raudit00>(false).Where(x => x.careas == taudit01 && x.clinea == record.clinea).ToList().Sum(x => x.qaprex);
var fol01 = new AuditFolder()
{
FolderName = desbloque + record.clinea, ImageName = "ic_bloque.jpg", AuditCount = xqaprob + xqdesap + xqaprex, FontBold = 1
};
conta = 1;
//xoperacs = data.GetList<taudit00>(false).Where(x => x.careas == taudit01 && x.clinea==record.Clinea).OrderByDescending(x=>x.faudit).ToList();
//var taudit03 = (from a in xoperacs
// group a by new
// {
// a.faudit.Date,
// }
// into b
// select new
// {
// Faudit = b.Key.Date,
// }).ToList();
var resumenlinea = App.baseDatos.GetList <raudit00>(false).Where(x => x.careas == taudit01 && x.clinea == record.clinea).OrderByDescending(x => x.faudit).ToList();
foreach (var recorda in resumenlinea)
{
//int qaudit = data.GetList<taudit00>(false).Where(x => x.careas == taudit01 && x.clinea == record.Clinea && x.faudit.Date == recorda.Faudit.Date).ToList().Count();
//int qaudia = data.GetList<taudit00>(false).Where(x => x.careas == taudit01 && x.clinea == record.Clinea && x.faudit.Date == recorda.Faudit.Date && x.status=="A").ToList().Count();
//int qaudid = data.GetList<taudit00>(false).Where(x => x.careas == taudit01 && x.clinea == record.Clinea && x.faudit.Date == recorda.Faudit.Date && x.status == "D").ToList().Count();
//int qaudie = data.GetList<taudit00>(false).Where(x => x.careas == taudit01 && x.clinea == record.Clinea && x.faudit.Date == recorda.Faudit.Date && x.status == "E").ToList().Count();
//resaud = data.GetList<taudit00>(false).Where(x => x.careas == taudit01 && x.clinea == record.Clinea && x.faudit.ToShortDateString()==recorda.Faudit.ToShortDateString()).FirstOrDefault();
if (conta == 1)
{
subfol01 = new SubFolder()
{
FolderName = recorda.faudit.ToString("dd-MM-yyyy"), ImageName = "ic_calendar_now.png", AuditCount = recorda.qaprob + recorda.qdesap + recorda.qaprex, Clinea = record.clinea, Faudit = recorda.faudit
};
subfol01.DetFolder = new ObservableCollection <DetFolder>
{
new DetFolder()
{
FolderName = "Aprobado", ImageName = "ic_aprobado.png", AuditCount = recorda.qaprob, Careas = taudit01, Status = "A", Clinea = record.clinea, Faudit = recorda.faudit.ToString("dd-MM-yyyy")
},
new DetFolder()
{
FolderName = "Desaprobado", ImageName = "ic_desaprobado.png", AuditCount = recorda.qdesap, Careas = taudit01, Status = "D", Clinea = record.clinea, Faudit = recorda.faudit.ToString("dd-MM-yyyy")
},
new DetFolder()
{
FolderName = "Aprobado Ext.", ImageName = "ic_aprobext.png", AuditCount = recorda.qaprex, Careas = taudit01, Status = "E", Clinea = record.clinea, Faudit = recorda.faudit.ToString("dd-MM-yyyy")
}
};
subfolders.Add(subfol01);
}
if (conta > 1)
{
subfol01 = new SubFolder()
{
FolderName = recorda.faudit.ToString("dd-MM-yyyy"), ImageName = "ic_calendar_past.png", AuditCount = recorda.qaprob + recorda.qdesap + recorda.qaprex, Clinea = record.clinea, Faudit = recorda.faudit
};
subfol01.DetFolder = new ObservableCollection <DetFolder>
{
new DetFolder()
{
FolderName = "Aprobado", ImageName = "ic_aprobado.png", AuditCount = recorda.qaprob, Careas = taudit01, Status = "A", Clinea = record.clinea, Faudit = recorda.faudit.ToString("dd-MM-yyyy")
},
new DetFolder()
{
FolderName = "Desaprobado", ImageName = "ic_desaprobado.png", AuditCount = recorda.qdesap, Careas = taudit01, Status = "D", Clinea = record.clinea, Faudit = recorda.faudit.ToString("dd-MM-yyyy")
},
new DetFolder()
{
FolderName = "Aprobado Ext.", ImageName = "ic_aprobext.png", AuditCount = recorda.qaprex, Careas = taudit01, Status = "E", Clinea = record.clinea, Faudit = recorda.faudit.ToString("dd-MM-yyyy")
}
};
subfolders.Add(subfol01);
}
conta = conta + 1;
}
fol01.SubFolder = subfolders;
folders.Add(fol01);
}
//}
return(folders);
}
private void init_dtAuditFilesConfig()
{
dtAuditFilesConfig = AuditFolder.init_dtConfig();
}
private void init_dtSignaturesConfig()
{
dtSignaturesConfig = AuditFolder.init_dtSignaturesConfig();
}
async void GenerateItems()
{
DependencyService.Get <IDownloader>().Show("Descargando");
var response = await apiService.GetFichasPdf <OrdenProduccion>(ety_op.Text);
if (!response.IsSuccess)
{
await dialogService.ShowMessage("Aviso", response.Message);
DependencyService.Get <IDownloader>().Hide();
return;
}
var fichas = (List <OrdenProduccion>)response.Result;
//********** INICIO DESCARGA DE ARCHIVOS DESDE FTP **********//
foreach (var recordf in fichas)
{
string fileName = recordf.drutaf + ".pdf";
IFolder rootFolder = await FileSystem.Current.GetFolderFromPathAsync("/storage/emulated/0/Fichas/");
ExistenceCheckResult folderexist = await rootFolder.CheckExistsAsync(fileName);
if (folderexist == ExistenceCheckResult.FileExists)
{
IFile file = await rootFolder.GetFileAsync(fileName);
await file.DeleteAsync();
}
string rutapdf = "ftp://192.168.2.55/" + recordf.drutaf + ".pdf";
downloader.DownloadFile(rutapdf, "Fichas");
}
//********** FIN DESCARGA DE ARCHIVOS DESDE FTP **********//
foreach (var recordc in fichas)
{
Dclien = recordc.dclien;
Nordpr = recordc.nordpr;
}
var folders = new ObservableCollection <AuditFolder>();
treeView.Nodes.Clear();
var fichascab = (from a in fichas
group a by new
{
a.cdaxes,
a.dficha,
}
into b
select new
{
Dficha = b.Key.dficha,
Cdaxes = b.Key.cdaxes,
Qficha = b.Count()
}).ToList();
foreach (var record in fichascab)
{
var subfol01 = new SubFolder();
var subfolders = new ObservableCollection <SubFolder>();
var fol01 = new AuditFolder()
{
FolderName = record.Dficha, ImageName = "ic_folder.png", AuditCount = record.Qficha, FontBold = 1
};
var fichasdet = fichas.Where(x => x.cdaxes == record.Cdaxes).ToList();
foreach (var records in fichasdet)
{
string fileName = records.drutaf + ".pdf";
string fileImage = "ic_check.png";
//FileInfo fi = new FileInfo("/storage/emulated/0/Fichas/" + fileName);
//if (fi.Length == 0){ fileImage = "ic_cancel.png"; }
//else{ fileImage = "ic_check.png"; }
if (string.IsNullOrEmpty(records.dcolor))
{
subfol01 = new SubFolder()
{
FolderName = records.drutaf, SubFolderName = records.drutaf, ImageName = "ic_pdf.png", SubImageName = fileImage
};
}
else
{
subfol01 = new SubFolder()
{
FolderName = records.dcolor, SubFolderName = records.drutaf, ImageName = "ic_pdf.png", SubImageName = fileImage
};
}
subfolders.Add(subfol01);
}
fol01.SubFolder = subfolders;
folders.Add(fol01);
}
Folders = folders;
treeView.ItemsSource = Folders;
//********** INICIO INSERTA EN SQLITE MOBILE **********//
//using (var data = new DataAccess())
//{
// var dataop = data.GetOP(ety_op.Text);
// if (dataop.Count == 0)
// {
// dataService.Save(fichas);
// }
// else
// {
// foreach (var recordf in fichas)
// {
// string fileName = recordf.drutaf + ".pdf";
// IFolder rootFolder = await FileSystem.Current.GetFolderFromPathAsync("/storage/emulated/0/Fichas/");
// ExistenceCheckResult folderexist = await rootFolder.CheckExistsAsync(fileName);
// if (folderexist == ExistenceCheckResult.FileExists)
// {
// IFile file = await rootFolder.GetFileAsync(fileName);
// await file.DeleteAsync();
// }
// }
// data.DeleteFichaOP(ety_op.Text);
// dataService.Save(fichas);
// }
//}
//********** FIN INSERTA EN SQLITE MOBILE **********//
DependencyService.Get <IDownloader>().Hide();
ety_op.Text = "";
//await DisplayAlert("Aviso", "Archivos descargados satisfactoriamente", "OK");
}
