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