public ContactDirectory LoadEntries() // for loading existing entries in database
{
ContactDirectory cd = new ContactDirectory();
Cmd.CommandText = "select per.Pid, FirstName, LastName, Age, Gender, HouseNum, Street, City, State, Country, ZipCode, CountryCode, Number, Ext, EmailAddress " +
"from dbo.Person as per inner join dbo.Address as addr on per.Pid = addr.Pid " +
"inner join dbo.Phone as pho on per.Pid = pho.Pid inner join dbo.Email as email on per.Pid = email.Pid " +
"order by per.Pid";
try
{
Con.Open();
Reader = Cmd.ExecuteReader();
while (Reader.Read())
{
Person p = ParseEntry();
cd.AddPerson(p);
}
return(cd);
}
catch (Exception e)
{
logger.Error(e.StackTrace);
Console.WriteLine("Error loading database entries.");
Helper.PrintError(e);
return(null);
}
finally
{
Reader.Close();
Con.Close();
}
}
public ContactDirectory WatchDirecotry(DirectoryMetadata Directory)
{
ContactDirectory tempDirectory = new ContactDirectory(DirectoriesManager, Directory);
tempDirectory.StartWatching();
return(tempDirectory);
}
public void ShowAllPerson() // show all existing entries in database
{
ContactDirectory cd = LoadEntries();
Helper.PrintLegend();
foreach (Person p in cd.People)
{
Console.WriteLine(p.ToString());
}
}
public void WatchDirectory(DirectoryMetadataCategory directoryMetaDataCategory)
{
foreach (DirectoryMetadata d in DirectoryConfiguration.GetList())
{
if (d.Category == directoryMetaDataCategory)
{
WatchedDirectory = new ContactDirectory(DirectoriesManager, d);
WatchedDirectory.StartWatching();
}
}
}
/// <summary>
/// Handles the Loaded event of the ContactDirectoryWindow1 control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="RoutedEventArgs"/> instance containing the event data.</param>
private void ContactDirectoryWindow1_Loaded(object sender, RoutedEventArgs e)
{
var hwnd = new WindowInteropHelper(this).Handle;
SetWindowLong(hwnd, GWL_STYLE, GetWindowLong(hwnd, GWL_STYLE) & ~WS_SYSMENU);
dockContactDirectoryPanel.Children.Clear();
if (Pointel.Interactions.IPlugins.PluginCollection.GetInstance().PluginCollections.ContainsKey(Pointel.Interactions.IPlugins.Plugins.Contact))
{
ContactDirectory contactDirectory = new ContactDirectory();
contactDirectory.ContactSelectedEvent += new ContactDirectoryHandler(contactDirectory_ContactSelectedEvent);
dockContactDirectoryPanel.Children.Add(contactDirectory);
}
this.Topmost = true;
this.Activate();
this.Topmost = false;
}
static void PrintIntroPrompt(int option)
{
if (option == 1)
{
Console.WriteLine("1. Serialize to new file");
Console.WriteLine("2. Deserialize from existing file");
Console.WriteLine("3. Exit the application");
}
else
{
Console.WriteLine("1. Create a new contact directory");
Console.WriteLine("2. Load from existing contact directory");
Console.WriteLine("3. Exit the application");
}
Console.Write("Enter your choice: ");
switch (Console.ReadLine())
{
case "1": // clear old entries, create new file
cd = new ContactDirectory();
if (option == 1)
{
Console.Write("Specify file name: ");
fileName = Console.ReadLine();
}
if (option == 2)
{
db.ClearEntries();
}
break;
case "2": // load existing entries
if (option == 1)
{
Console.Write("Specify file name: ");
fileName = Console.ReadLine();
}
try
{
if (option == 1)
{
cd = new ContactDirectory(JsonHelper.JsonDeserializer <ContactDirectory>(File.ReadAllText(fileName)));
db.ClearEntries();
foreach (Person p in cd.People)
{
db.AddPerson(p);
}
}
else
{
cd = db.LoadEntries();
}
}
catch (Exception e)
{
logger.Error(e.StackTrace);
if (option == 1)
{
Console.WriteLine("Error occured while attempting to deserialize the existing file." + Environment.NewLine);
}
else
{
Console.WriteLine("Error occured while executing SQL commands." + Environment.NewLine);
}
PrintIntroPrompt(option);
}
break;
case "3": // exit app
Environment.Exit(0);
break;
default: // invalid arg
Console.WriteLine("Invalid choice, please try again." + Environment.NewLine);
PrintIntroPrompt(option);
break;
}
}
private void btnOK_Click(object sender, EventArgs e)
{
WatchedDirectory = connection.WatchDirecotry(connection.GetDirectoriesFromCategory(connection.GetDirectoryCategories()[lstDirectoryType.SelectedIndex])[lstDirectories.SelectedIndex]);
addTab();
this.Close();
}
