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