private void AddDatabaseAssociation()
{
if (listViewRelationSets.SelectedItems.Count == 1)
{
FolderBrowserDialog folderDialog = new FolderBrowserDialog();
folderDialog.Description = "Please select a database root path...";
folderDialog.SelectedPath = _worker.DatabaseRootFolder;
folderDialog.ShowNewFolderButton = false;
if (folderDialog.ShowDialog(this) == DialogResult.OK)
{
string selectedDatabasePath = folderDialog.SelectedPath;
RelationSet existingRelationSet = _worker.RelationSets.FirstOrDefault(rs => rs.Databases
.Any(databasePath => databasePath.Equals(selectedDatabasePath, StringComparison.CurrentCultureIgnoreCase)));
if (existingRelationSet != null)
{
string existingDatabasePath = existingRelationSet.Databases
.First(databasePath => databasePath.Equals(selectedDatabasePath, StringComparison.CurrentCultureIgnoreCase));
existingRelationSet.Databases.Remove(existingDatabasePath);
RemoveDatabaseAssociationFromListView(existingDatabasePath);
}
RelationSet relationSet = (RelationSet)listViewRelationSets.SelectedItems[0].Tag;
relationSet.Databases.Add(selectedDatabasePath);
_worker.SaveRegistryRelationSets();
AddDatabaseAssociationToListView(selectedDatabasePath, relationSet, true);
}
}
}
public DatabaseRelationSetForm(Worker worker, RelationSet relationSet)
{
InitializeComponent();
listViewRelations.ListViewItemSorter = new ListViewItemComparer(0, 1);
_worker = worker;
_relationSet = relationSet;
}
private void UpdateRelationSetListView(RelationSet relationSet)
{
foreach (ListViewItem item in listViewRelationSets.Items)
{
if (item.Tag == relationSet)
{
item.Text = relationSet.Name;
item.SubItems[2].Text = relationSet.ModifyDate.ToString("yyyy-MM-dd HH:mm:ss");
}
}
}
private void AddDatabaseAssociationToListView(string databasePath, RelationSet relationSet, bool select)
{
listViewDatabases.SelectedItems.Clear();
ListViewItem item = listViewDatabases.Items.Add(databasePath);
item.SubItems.Add(relationSet.Name);
item.Tag = databasePath;
if (select)
{
item.Selected = true;
}
}
private void AddRelationSetToListView(RelationSet relationSet, bool select)
{
listViewRelationSets.SelectedItems.Clear();
ListViewItem item = listViewRelationSets.Items.Add(relationSet.Name);
item.SubItems.Add(relationSet.CreateDate.ToString("yyyy-MM-dd HH:mm:ss"));
item.SubItems.Add(relationSet.ModifyDate.ToString("yyyy-MM-dd HH:mm:ss"));
item.Tag = relationSet;
if (select)
{
item.Selected = true;
}
}
private void EditRelationSet()
{
if (listViewRelationSets.SelectedItems.Count == 1)
{
RelationSet relationSet = (RelationSet)listViewRelationSets.SelectedItems[0].Tag;
RelationSet relationSetClone = relationSet.Clone();
if (_worker.OpenDatabaseRelationSet(relationSetClone))
{
relationSet.Adopt(relationSetClone);
UpdateRelationSetListView(relationSet);
_worker.SaveRegistryRelationSets();
}
}
}
private void NewRelationSet()
{
RelationSet relationSet = new RelationSet();
if (_worker.OpenDatabaseRelationSet(relationSet))
{
if (!_worker.RelationSets.Contains(relationSet))
{
_worker.RelationSets.Add(relationSet);
AddRelationSetToListView(relationSet, true);
}
_worker.SaveRegistryRelationSets();
}
}
private void RemoveDatabaseAssociation()
{
if (listViewDatabases.SelectedItems.Count > 0)
{
foreach (ListViewItem selectedItem in listViewDatabases.SelectedItems)
{
string selectedDatabasePath = (string)selectedItem.Tag;
RelationSet relationSet = _worker.RelationSets.First(rs => rs.Databases
.Any(databasePath => databasePath.Equals(selectedDatabasePath, StringComparison.CurrentCultureIgnoreCase)));
relationSet.Databases.Remove(selectedDatabasePath);
listViewDatabases.Items.Remove(selectedItem);
}
_worker.SaveRegistryRelationSets();
}
}
private void CopyRelationSet()
{
if (listViewRelationSets.SelectedItems.Count == 1)
{
RelationSet relationSet = (RelationSet)listViewRelationSets.SelectedItems[0].Tag;
RelationSet relationSetCopy = relationSet.Clone();
relationSetCopy.Databases.Clear();
relationSetCopy.Name = _worker.GetRelationSetCopyName(relationSetCopy);
relationSetCopy.CreateDate = DateTime.Now;
relationSetCopy.ModifyDate = relationSetCopy.CreateDate;
_worker.RelationSets.Add(relationSetCopy);
AddRelationSetToListView(relationSetCopy, true);
_worker.SaveRegistryRelationSets();
}
}
private void InitializeForm()
{
textBoxDatabasePath.Text = _databasePath;
RelationSet associatedRelationSet = _worker.RelationSets.FirstOrDefault(rs => rs.Databases
.Any(dbPath => dbPath.Equals(_databasePath, StringComparison.CurrentCultureIgnoreCase)));
comboBoxRelationSets.Items.Add(new ComboBoxItem(string.Empty, null));
foreach (RelationSet relationSet in _worker.RelationSets)
{
int index = comboBoxRelationSets.Items.Add(new ComboBoxItem(relationSet.Name, relationSet));
if (associatedRelationSet != null && relationSet == associatedRelationSet)
{
comboBoxRelationSets.SelectedIndex = index;
}
}
}
private void DeleteRelationSet()
{
if (listViewRelationSets.SelectedItems.Count > 0)
{
foreach (ListViewItem selectedItem in listViewRelationSets.SelectedItems)
{
RelationSet relationSet = (RelationSet)selectedItem.Tag;
if (_worker.RelationSets.Contains(relationSet))
{
_worker.RelationSets.Remove(relationSet);
_worker.SaveRegistryRelationSets();
listViewRelationSets.Items.Remove(selectedItem);
PopulateDatabaseAssociationsListView();
}
}
}
}
private static void InitKinships()
{
fKinships = new List <KinshipRec>();
RegisterKinship(
RelationSet.Create(RelationKind.rkNone),
RelationSet.Create(RelationKind.rkFather, RelationKind.rkMother,
RelationKind.rkHusband, RelationKind.rkWife, RelationKind.rkSon, RelationKind.rkDaughter),
RelationKind.rkSame, 0, 0);
RegisterKinship(
RelationSet.Create(RelationKind.rkHusband, RelationKind.rkWife),
RelationSet.Create(RelationKind.rkSon, RelationKind.rkDaughter),
RelationKind.rkSame, 0, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkMother),
RelationSet.Create(RelationKind.rkHusband),
RelationKind.rkFather, 0, 0);
RegisterKinship(
RelationSet.Create(RelationKind.rkFather),
RelationSet.Create(RelationKind.rkWife),
RelationKind.rkMother, 0, 0);
RegisterKinship(
RelationSet.Create(RelationKind.rkGrandfather, RelationKind.rkGrandmother),
RelationSet.Create(RelationKind.rkSon),
RelationKind.rkUncle, 0, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkGrandfather, RelationKind.rkGrandmother),
RelationSet.Create(RelationKind.rkDaughter),
RelationKind.rkAunt, 0, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkBrother, RelationKind.rkSister),
RelationSet.Create(RelationKind.rkSon),
RelationKind.rkNephew, 0, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkBrother, RelationKind.rkSister),
RelationSet.Create(RelationKind.rkDaughter),
RelationKind.rkNiece, 0, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkSon, RelationKind.rkBrother),
RelationSet.Create(RelationKind.rkWife),
RelationKind.rkDaughterInLaw, 0, 0);
RegisterKinship(
RelationSet.Create(RelationKind.rkDaughter, RelationKind.rkSister),
RelationSet.Create(RelationKind.rkHusband),
RelationKind.rkSonInLaw, 0, 0);
RegisterKinship(
RelationSet.Create(RelationKind.rkWife),
RelationSet.Create(RelationKind.rkFather),
RelationKind.rkWifeFather, 0, -1);
RegisterKinship(
RelationSet.Create(RelationKind.rkWife),
RelationSet.Create(RelationKind.rkMother),
RelationKind.rkWifeMother, 0, -1);
RegisterKinship(
RelationSet.Create(RelationKind.rkHusband),
RelationSet.Create(RelationKind.rkFather),
RelationKind.rkHusbandFather, 0, -1);
RegisterKinship(
RelationSet.Create(RelationKind.rkHusband),
RelationSet.Create(RelationKind.rkMother),
RelationKind.rkHusbandMother, 0, -1);
RegisterKinship(
RelationSet.Create(RelationKind.rkFather, RelationKind.rkMother),
RelationSet.Create(RelationKind.rkFather),
RelationKind.rkGrandfather, 0, -1);
RegisterKinship(
RelationSet.Create(RelationKind.rkFather, RelationKind.rkMother),
RelationSet.Create(RelationKind.rkMother),
RelationKind.rkGrandmother, 0, -1);
RegisterKinship(
RelationSet.Create(RelationKind.rkFather, RelationKind.rkMother),
RelationSet.Create(RelationKind.rkSon),
RelationKind.rkBrother, 0, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkFather, RelationKind.rkMother),
RelationSet.Create(RelationKind.rkDaughter),
RelationKind.rkSister, 0, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkGrandfather, RelationKind.rkGrandmother),
RelationSet.Create(RelationKind.rkFather),
RelationKind.rkGrandfather, 1, -1);
RegisterKinship(
RelationSet.Create(RelationKind.rkGrandfather, RelationKind.rkGrandmother),
RelationSet.Create(RelationKind.rkMother),
RelationKind.rkGrandmother, 1, -1);
RegisterKinship(
RelationSet.Create(RelationKind.rkSon, RelationKind.rkDaughter, RelationKind.rkSonInLaw, RelationKind.rkDaughterInLaw),
RelationSet.Create(RelationKind.rkSon), RelationKind.rkGrandson, 0, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkSon, RelationKind.rkDaughter, RelationKind.rkSonInLaw, RelationKind.rkDaughterInLaw),
RelationSet.Create(RelationKind.rkDaughter),
RelationKind.rkGranddaughter, 0, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkGrandson, RelationKind.rkGranddaughter),
RelationSet.Create(RelationKind.rkSon),
RelationKind.rkGrandson, 1, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkGrandson, RelationKind.rkGranddaughter),
RelationSet.Create(RelationKind.rkDaughter),
RelationKind.rkGranddaughter, 1, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkUncle, RelationKind.rkAunt),
RelationSet.Create(RelationKind.rkDaughter),
RelationKind.rkNiece, 0, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkUncle, RelationKind.rkAunt),
RelationSet.Create(RelationKind.rkSon),
RelationKind.rkNephew, 0, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkHusband),
RelationSet.Create(RelationKind.rkBrother),
RelationKind.rkBrotherInLaw_H, 0, 0);
RegisterKinship(
RelationSet.Create(RelationKind.rkWife),
RelationSet.Create(RelationKind.rkBrother),
RelationKind.rkBrotherInLaw_W, 0, 0);
RegisterKinship(
RelationSet.Create(RelationKind.rkHusbandFather, RelationKind.rkHusbandMother),
RelationSet.Create(RelationKind.rkSon),
RelationKind.rkBrotherInLaw_H, 0, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkWifeFather, RelationKind.rkWifeMother),
RelationSet.Create(RelationKind.rkSon),
RelationKind.rkBrotherInLaw_W, 0, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkHusband),
RelationSet.Create(RelationKind.rkSister),
RelationKind.rkSisterInLaw_H, 0, 0);
RegisterKinship(
RelationSet.Create(RelationKind.rkWife),
RelationSet.Create(RelationKind.rkSister),
RelationKind.rkSisterInLaw_W, 0, 0);
RegisterKinship(
RelationSet.Create(RelationKind.rkHusbandFather, RelationKind.rkHusbandMother),
RelationSet.Create(RelationKind.rkDaughter),
RelationKind.rkSisterInLaw_H, 0, 1);
RegisterKinship(
RelationSet.Create(RelationKind.rkWifeFather, RelationKind.rkWifeMother),
RelationSet.Create(RelationKind.rkDaughter),
RelationKind.rkSisterInLaw_W, 0, 1);
}
private static void RegisterKinship(RelationSet prevRels, RelationSet currRels, RelationKind finRel, sbyte great, sbyte level)
{
fKinships.Add(new KinshipRec(prevRels, currRels, finRel, great, level));
}
private static void Main(string[] args)
{
// Setting a standard format for the generated files
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
// Data dumps are available from CCP
Console.Write(@"Loading Data from SQL Server... ");
#region Read Tables From Database
// Read tables from database
s_agents = Database.Agents();
UpdateProgress();
s_units = Database.Units();
UpdateProgress();
s_names = Database.Names();
UpdateProgress();
s_icons = Database.Icons();
UpdateProgress();
s_attributeTypes = Database.Attributes();
UpdateProgress();
s_attributeCategories = Database.AttributeCategories();
UpdateProgress();
s_regions = Database.Regions();
UpdateProgress();
s_constellations = Database.Constellations();
UpdateProgress();
s_solarSystems = Database.Solarsystems();
UpdateProgress();
s_stations = Database.Stations();
UpdateProgress();
s_jumps = Database.Jumps();
UpdateProgress();
s_typeAttributes = Database.TypeAttributes();
UpdateProgress();
s_blueprintTypes = Database.BlueprintTypes();
UpdateProgress();
s_marketGroups = Database.MarketGroups();
UpdateProgress();
s_groups = Database.Groups();
UpdateProgress();
s_metaTypes = Database.MetaTypes();
UpdateProgress();
s_typeEffects = Database.TypeEffects();
UpdateProgress();
s_types = Database.Types();
UpdateProgress();
s_typeMaterials = Database.TypeMaterials();
UpdateProgress();
s_typeRequirements = Database.TypeRequirements();
UpdateProgress();
s_crtCategories = Database.CertificateCategories();
UpdateProgress();
s_crtClasses = Database.CertificateClasses();
UpdateProgress();
s_certificates = Database.Certificates();
UpdateProgress();
s_crtRecommendations = Database.CertificateRecommendations();
UpdateProgress();
s_crtRelationships = Database.CertificateRelationships();
UpdateProgress();
Console.WriteLine();
Console.WriteLine();
#endregion
// Generate datafiles
Console.WriteLine(@"Datafile Generating In Progress");
Console.WriteLine();
GenerateProperties();
GenerateItems(); // Requires GenerateProperties()
GenerateSkills();
GenerateCertificates();
GenerateBlueprints();
GenerateGeography();
GenerateReprocessing(); // Requires GenerateItems()
GenerateMD5Sums();
Console.WriteLine(@"Done");
Console.ReadLine();
}
