public void ImportAdTAskCArdOrCrateNew() { var env = GetEnviroment(); var itemRelationCore = new ItemsRelationsDataAccess(env); var aircraftCore = new AircraftsCore(env.Loader, env.NewKeeper, null); var directiveCore = new DirectiveCore(env.NewKeeper, env.NewLoader, env.Keeper, env.Loader, itemRelationCore); var componentCore = new ComponentCore(env, env.Loader, env.NewLoader, env.NewKeeper, aircraftCore, itemRelationCore); var aircraftId = 2336; var aircraft = env.NewLoader.GetObject <AircraftDTO, Aircraft>(new Filter("ItemId", aircraftId)); var directiveList = directiveCore.GetDirectives(aircraft, DirectiveType.AirworthenessDirectives); var bd = componentCore.GetAicraftBaseComponents(aircraftId, BaseComponentType.Frame.ItemId).LastOrDefault(); var d = new DirectoryInfo(@"D:\Work\doc\ALL AD 757 13 Feb 2019 1111\FAA 757"); var files = d.GetFiles(); foreach (var file in files) { var name = file.Name.Replace(" ", "").Replace(".pdf", ""); var directive = directiveList.FirstOrDefault(i => i.Title.Contains(name)); if (directive != null) { var _fileData = UsefulMethods.GetByteArrayFromFile(file.FullName); var attachedFile = new AttachedFile { FileData = _fileData, FileName = file.Name, FileSize = _fileData.Length }; directive.ADNoFile = attachedFile; env.NewKeeper.Save(directive); } else { var newDirective = new Directive { Title = name, DirectiveType = DirectiveType.AirworthenessDirectives, ADType = ADType.Airframe, HiddenRemarks = "NEW", IsApplicability = true, ParentBaseComponent = bd }; var _fileData = UsefulMethods.GetByteArrayFromFile(file.FullName); var attachedFile = new AttachedFile { FileData = _fileData, FileName = file.Name, FileSize = _fileData.Length }; newDirective.ADNoFile = attachedFile; env.NewKeeper.Save(newDirective); } } }
public void ImportAdTAskCArd() { var env = GetEnviroment(); var itemRelationCore = new ItemsRelationsDataAccess(env); var directiveCore = new DirectiveCore(env.NewKeeper, env.NewLoader, env.Keeper, env.Loader, itemRelationCore); var aircraft = env.NewLoader.GetObject <AircraftDTO, Aircraft>(new Filter("ItemId", 2348)); var directiveList = directiveCore.GetDirectives(aircraft, DirectiveType.AirworthenessDirectives); var d = new DirectoryInfo(@"H:\CRJ200 27.02.18 AD"); var files = d.GetFiles(); foreach (var mpd in directiveList) { var file = files.FirstOrDefault(f => mpd.Title.Contains(f.Name.Replace(" ", "").Replace(".pdf", ""))); if (file != null) { var _fileData = UsefulMethods.GetByteArrayFromFile(file.FullName); var attachedFile = new AttachedFile { FileData = _fileData, FileName = file.Name, FileSize = _fileData.Length }; mpd.ADNoFile = attachedFile; env.NewKeeper.Save(mpd); } } }
private void LinkLabelBrowseLinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { if (string.IsNullOrEmpty(_fileName) && ((_fileData == null && (_fileSize == null || _fileSize <= 0)) || string.IsNullOrEmpty(_filePath))) { OpenFileDialog dialog = new OpenFileDialog(); dialog.Filter = _filter; if (dialog.ShowDialog() == DialogResult.OK) { if (_file != null) { _file.IsDeleted = false; } _fileData = UsefulMethods.GetByteArrayFromFile(dialog.FileName); _fileName = string.IsNullOrEmpty(dialog.SafeFileName) ? "" : dialog.SafeFileName; _filePath = dialog.FileName; _fileSize = _fileData.Length; UpdateInfo(); if (FileChanged != null) { FileChanged(_fileName.Substring(0, _fileName.LastIndexOf('.'))); } } } else { progressBarLoad.Value = 0; progressBarLoad.Visible = true; backgroundWorker.RunWorkerAsync(); } }
private void UpdateFileLink(ItemFileLink link) { var fileData = UsefulMethods.GetByteArrayFromFile(@"D:\NewLinkTest.pdf"); link.File = new AttachedFile { FileData = fileData, FileName = "NewLinkTest.pdf", FileSize = fileData.Length }; }
/// <summary> /// Создает вкладку с информацией о рабочей карте /// </summary> /// <param name="maintenanceSubCheck"></param> /// <param name="dialogFileName"></param> public JobCardTabPageControl(MaintenanceSubCheck maintenanceSubCheck, string dialogFileName) { parentMaintenanceSubCheck = maintenanceSubCheck; currentJobCard = new JobCard(); currentJobCard.Date = DateTime.Today; currentJobCard.AttachedFile.FileData = UsefulMethods.GetByteArrayFromFile(dialogFileName); string cardNumber = dialogFileName.Substring(dialogFileName.LastIndexOf('\\') + 1); textBoxJobCard.Text = cardNumber.Substring(0, cardNumber.LastIndexOf('.')); mode = ScreenMode.Add; InitializeComponent(); UpdateInformation(); }
private ItemFileLink CreateItemFileLink(int parentId, int parentTypeId, int linkTypeId) { var fileData = UsefulMethods.GetByteArrayFromFile(@"D:\LinkTest.pdf"); return(new ItemFileLink { ParentId = parentId, ParentTypeId = parentTypeId, LinkType = (short)linkTypeId, File = new AttachedFile { FileData = fileData, FileName = "LinkTest.pdf", FileSize = fileData.Length } }); }
private void ButtonLoadClick(object sender, EventArgs e) { try { foreach (ListViewItem listViewItem in listViewFiles.SelectedItems) { AttachedFile file = new AttachedFile(); file.FileData = UsefulMethods.GetByteArrayFromFile(listViewItem.SubItems[2].Text); file.FileName = listViewItem.SubItems[0].Text; file.FileSize = file.FileData.Length; GlobalObjects.NewKeeper.Save(file); } } catch (Exception ex) { Program.Provider.Logger.Log("Error while save attached file", ex); } }
private void linkLabelBrowse_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { OpenFileDialog dialog = new OpenFileDialog(); dialog.Filter = filter; if (dialog.ShowDialog() == DialogResult.OK) { if (file == null) { file = new AttachedFile(); } file.FileData = UsefulMethods.GetByteArrayFromFile(dialog.FileName); file.FileName = dialog.FileName.Substring(dialog.FileName.LastIndexOf('\\') + 1); UpdateInfo(); if (FileChanged != null) { FileChanged(file.FileName.Substring(0, file.FileName.LastIndexOf('.'))); } } }
public void ImportTaskCard() { var env = GetEnviroment(); var aircraftCore = new AircraftsCore(env.Loader, env.NewKeeper, null); var itemRelationCore = new ItemsRelationsDataAccess(env); var maintenanceCore = new MaintenanceCore(env, env.NewLoader, env.NewKeeper, itemRelationCore, aircraftCore); var aircraft = env.NewLoader.GetObject <AircraftDTO, Aircraft>(new Filter("ItemId", 2340)); var mpdList = maintenanceCore.GetMaintenanceDirectives(aircraft); var d = new DirectoryInfo(@"D:\MPD\All Task Cards for UP-B6703"); var files = d.GetFiles(); foreach (var mpd in mpdList) { var file = files.FirstOrDefault(f => f.Name.Replace(".pdf", "") == mpd.TaskCardNumber); if (file != null) { var _fileData = UsefulMethods.GetByteArrayFromFile(file.FullName); var attachedFile = new AttachedFile { FileData = _fileData, FileName = file.Name, FileSize = _fileData.Length }; mpd.TaskCardNumberFile = attachedFile; env.NewKeeper.Save(mpd); } else { Trace.WriteLine(mpd.TaskNumberCheck); } } }
private void linkLabelBrowse_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { OpenFileDialog dialog = new OpenFileDialog(); dialog.Filter = "Adobe PDF Files|*.pdf"; if (dialog.ShowDialog() == DialogResult.OK) { pdfFileData = UsefulMethods.GetByteArrayFromFile(dialog.FileName); pdfFileDataChanged = true; UpdateDescription(); if (textBoxJobCard.Text == "") { string fileName = dialog.FileName.Substring(dialog.FileName.LastIndexOf('\\') + 1); if (fileName.LastIndexOf('.') == -1) { textBoxJobCard.Text = fileName; } else { textBoxJobCard.Text = fileName.Substring(0, fileName.LastIndexOf('.')); } } } }
public void Test() { var env = GetEnviroment(); var aircraftCore = new AircraftsCore(env.Loader, env.NewKeeper, null); var itemRelationCore = new ItemsRelationsDataAccess(env); var maintenanceCore = new MaintenanceCore(env, env.NewLoader, env.NewKeeper, itemRelationCore, aircraftCore); var componentCore = new ComponentCore(env, env.Loader, env.NewLoader, env.NewKeeper, aircraftCore, itemRelationCore); var aircraft = env.NewLoader.GetObject <AircraftDTO, Aircraft>(new Filter("ItemId", 2348)); var mpdList = maintenanceCore.GetMaintenanceDirectives(aircraft); var bd = componentCore.GetAicraftBaseComponents(2348, BaseComponentType.Frame.ItemId).FirstOrDefault(); var d = new DirectoryInfo(@"H:\TaskCard\ALL for Yevhenij"); var files = d.GetFiles(); var ds = ExcelToDataTableUsingExcelDataReader(@"H:\Card.xlsx"); var dict = new Dictionary <string, List <DataRow> >(); foreach (DataTable table in ds.Tables) { foreach (DataRow row in table.Rows) { if (!dict.ContainsKey(row[1].ToString())) { dict.Add(row[1].ToString(), new List <DataRow> { row }); } else { dict[row[1].ToString()].Add(row); } } } foreach (var mpd in mpdList) { int counter = 1; var description = mpd.Description; if (mpd.Program.ItemId == MaintenanceDirectiveProgramType.StructuresMaintenance.ItemId || mpd.Program.ItemId == MaintenanceDirectiveProgramType.SystemsAndPowerPlants.ItemId || mpd.Program.ItemId == MaintenanceDirectiveProgramType.ZonalInspection.ItemId) { if (!dict.ContainsKey(mpd.TaskNumberCheck)) { Trace.WriteLine(mpd.TaskNumberCheck); continue; } foreach (var row in dict[mpd.TaskNumberCheck]) { if (counter == 1) { mpd.TaskCardNumber = row[0].ToString(); var file = files.FirstOrDefault(f => f.Name.Replace(".pdf", "") == mpd.TaskCardNumber); if (file != null) { var _fileData = UsefulMethods.GetByteArrayFromFile(file.FullName); var attachedFile = new AttachedFile { FileData = _fileData, FileName = file.Name, FileSize = _fileData.Length }; mpd.Description += $" / TaskCard : {row[2]}"; mpd.TaskCardNumberFile = attachedFile; } if (dict[mpd.TaskNumberCheck].Count > 1) { mpd.TaskNumberCheck += $" ({counter})"; } env.NewKeeper.Save(mpd); counter++; } else { var newMpd = mpd.GetCopyUnsaved(); newMpd.TaskCardNumber = row[0].ToString(); newMpd.TaskCardNumberFile = null; var file = files.FirstOrDefault(f => f.Name.Replace(".pdf", "") == newMpd.TaskCardNumber); if (file != null) { var _fileData = UsefulMethods.GetByteArrayFromFile(file.FullName); var attachedFile = new AttachedFile { FileData = _fileData, FileName = file.Name, FileSize = _fileData.Length }; newMpd.TaskCardNumberFile = attachedFile; newMpd.Description = $"{description} / TaskCard : {row[2]}"; } newMpd.TaskNumberCheck = $"{row[1]} ({counter})"; newMpd.ParentBaseComponent = bd; env.NewKeeper.Save(newMpd); counter++; } } } } }