void LoadDataGridWorker_DoWork(object sender, DoWorkEventArgs e) { ImageVisibility(true); ProcessingStatus("Loading backup logs..."); try { var logPath = Helper.GetLogPathForUi; var CurrentMonth = DateTime.Now.ToString("MMMM"); logPath = logPath + "\\" + e.Argument.ToString(); List <string> files = new List <string>(); if (Directory.Exists(logPath)) { files = Directory.GetFiles(logPath).ToList(); files.OrderByDescending(m => Name); } List <BackupSuccessLog> objListBackupSuccessLog = new List <BackupSuccessLog>(); foreach (var item in files) { var EncryptedXml = File.ReadAllText(item); var DecryptedXml = CipherUtil.Decrypt(EncryptedXml, Helper.AppConstants.CipherKey); var ObjBackupSuccessLog = Helper.XmlStringToObject <BackupSuccessLog>(DecryptedXml); objListBackupSuccessLog.Add(ObjBackupSuccessLog); } List <DataTableBackupSuccessLog> objDtLogs = new List <DataTableBackupSuccessLog>(); foreach (var item in objListBackupSuccessLog) { for (var i = 0; i < item.DatabaseName.Count; i++) { DataTableBackupSuccessLog obj = new DataTableBackupSuccessLog(); obj.DatabaseName = item.DatabaseName[i]; obj.DateTime = item.DateTime[i]; obj.BackupType = item.BackupType[i]; obj.Status = item.Status[i]; obj.Location = item.Location[i]; objDtLogs.Add(obj); } } var dt = Helper.ToDataTable <DataTableBackupSuccessLog>(objDtLogs); e.Result = dt; ImageVisibility(false); } catch (Exception ex) { ImageVisibility(false); log.Error(ex); } idLabelLogMonth.Text = idCmbSelectMonth.Text + " Logs"; }
public void LoadDataGrid() { try { var logPath = Helper.GetLogPathForUi; var CurrentMonth = DateTime.Now.ToString("MMMM"); logPath = logPath + "\\" + idCmbSelectMonth.Text; var files = Directory.GetFiles(logPath); files.OrderByDescending(m => Name); List <BackupSuccessLog> objListBackupSuccessLog = new List <BackupSuccessLog>(); foreach (var item in files) { var EncryptedXml = File.ReadAllText(item); var DecryptedXml = CipherUtil.Decrypt(EncryptedXml, Helper.AppConstants.CipherKey); var ObjBackupSuccessLog = Helper.XmlStringToObject <BackupSuccessLog>(DecryptedXml); objListBackupSuccessLog.Add(ObjBackupSuccessLog); } List <DataTableBackupSuccessLog> objDtLogs = new List <DataTableBackupSuccessLog>(); foreach (var item in objListBackupSuccessLog) { for (var i = 0; i < item.DatabaseName.Count; i++) { DataTableBackupSuccessLog obj = new DataTableBackupSuccessLog(); obj.DatabaseName = item.DatabaseName[i]; obj.DateTime = item.DateTime[i]; obj.BackupType = item.BackupType[i]; obj.Status = item.Status[i]; obj.Location = item.Location[i]; objDtLogs.Add(obj); } } var dt = Helper.ToDataTable <DataTableBackupSuccessLog>(objDtLogs); idDataGridViewBackupLog.DataSource = dt; } catch (Exception ex) { log.Error(ex); } }