static void Main(string[] args)
{
#region Create the file store
string filePath = ConfigurationManager.AppSettings["FilePath"];
if (filePath == null || filePath == String.Empty)
{
// Use the registry key
using (RegistryKey key = Registry.LocalMachine.OpenSubKey(StorageInstaller.LocalMachineSubkey))
{
filePath = (string)key.GetValue("DataFile");
}
}
FileStorage filestore = new FileStorage(filePath);
#endregion
#region Delete existing participants & venues
Venue[] oldVenues = filestore.GetVenues();
Participant[] oldParts = filestore.GetParticipants();
if (oldVenues.Length == 2 && (oldParts == null || oldParts.Length == 0))
{
// This is the default install. Just delete them.
foreach (Venue oldVenue in oldVenues)
{
filestore.DeleteVenue(oldVenue.Identifier);
}
}
#endregion
#region Get the connection string
string connString = ConfigurationManager.AppSettings["SqlConnectionString"];
DatabaseStorage database = new DatabaseStorage(connString);
#endregion
try
{
#region Move the venues
Console.WriteLine("Getting venues from database...");
Venue[] venues = database.GetVenues();
Console.WriteLine("Writing venues to filestore...");
filestore.WriteCaching = true;
foreach (Venue ven in venues)
{
string[] acls = database.GetVenueSecurity(ven.Identifier);
ven.AccessList = new SecurityPatterns(acls);
filestore.AddVenue(ven);
}
filestore.WriteCaching = false;
#endregion
#region Move the participants
Console.WriteLine("Getting participants from database...");
Participant[] participants = database.GetParticipants();
Console.WriteLine("Writing participants to filestore...");
filestore.WriteCaching = true;
foreach (Participant part in participants)
{
filestore.AddParticipant(part);
}
filestore.WriteCaching = false;
#endregion
}
catch (System.Data.SqlClient.SqlException)
{
Console.WriteLine();
Console.WriteLine("The database could not be properly accessed. Utility failed to execute.");
Console.WriteLine("Press 'enter' to exit...");
Console.ReadLine();
}
filestore.Dispose();
}
static void Main(string[] args)
{
// Override the system UICulture
string cultureOverride = null;
if ((cultureOverride = ConfigurationManager.AppSettings["MSR.LST.ConferenceXP.VenueService.UICulture"]) != null)
{
try {
System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo(cultureOverride);
System.Threading.Thread.CurrentThread.CurrentUICulture = ci;
}
catch { }
}
#region Create the file store
string filePath = ConfigurationManager.AppSettings["FilePath"];
if (filePath == null || filePath == String.Empty)
{
// Use the registry key
using (RegistryKey key = Registry.LocalMachine.OpenSubKey(StorageInstaller.LocalMachineSubkey))
{
filePath = (string)key.GetValue("DataFile");
}
}
FileStorage filestore = new FileStorage(filePath);
#endregion
#region Delete existing participants & venues
Venue[] oldVenues = filestore.GetVenues();
Participant[] oldParts = filestore.GetParticipants();
if (oldVenues.Length == 2 && (oldParts == null || oldParts.Length == 0))
{
// This is the default install. Just delete them.
foreach (Venue oldVenue in oldVenues)
{
filestore.DeleteVenue(oldVenue.Identifier);
}
}
#endregion
#region Get the connection string
string connString = ConfigurationManager.AppSettings["SqlConnectionString"];
DatabaseStorage database = new DatabaseStorage(connString);
#endregion
try
{
#region Move the venues
Console.WriteLine(Strings.GettingVenuesFromDatabase);
Venue[] venues = database.GetVenues();
Console.WriteLine(Strings.WritingVenuesToFilestore);
filestore.WriteCaching = true;
foreach (Venue ven in venues)
{
string[] acls = database.GetVenueSecurity(ven.Identifier);
ven.AccessList = new SecurityPatterns(acls);
filestore.AddVenue(ven, new PrivateVenueState());
}
filestore.WriteCaching = false;
#endregion
#region Move the participants
Console.WriteLine(Strings.GettingParticipantsFromDatabase);
Participant[] participants = database.GetParticipants();
Console.WriteLine(Strings.WritingParticipantsToFilestore);
filestore.WriteCaching = true;
foreach (Participant part in participants)
{
filestore.AddParticipant(part);
}
filestore.WriteCaching = false;
#endregion
}
catch (System.Data.SqlClient.SqlException)
{
Console.WriteLine();
Console.WriteLine(Strings.DatabaseCouldNotBeProperlyAccessed);
Console.WriteLine(Strings.PressEnterToExit);
Console.ReadLine();
}
filestore.Dispose();
}
static void Main(string[] args)
{
#region Create the file store
string filePath = ConfigurationManager.AppSettings["FilePath"];
if (filePath == null || filePath == String.Empty)
{
// Use the registry key
using(RegistryKey key = Registry.LocalMachine.OpenSubKey(StorageInstaller.LocalMachineSubkey))
{
filePath = (string)key.GetValue("DataFile");
}
}
FileStorage filestore = new FileStorage(filePath);
#endregion
#region Delete existing participants & venues
Venue[] oldVenues = filestore.GetVenues();
Participant[] oldParts = filestore.GetParticipants();
if (oldVenues.Length == 2 && (oldParts == null || oldParts.Length == 0))
{
// This is the default install. Just delete them.
foreach(Venue oldVenue in oldVenues)
{
filestore.DeleteVenue(oldVenue.Identifier);
}
}
#endregion
#region Get the connection string
string connString = ConfigurationManager.AppSettings["SqlConnectionString"];
DatabaseStorage database = new DatabaseStorage(connString);
#endregion
try
{
#region Move the venues
Console.WriteLine("Getting venues from database...");
Venue[] venues = database.GetVenues();
Console.WriteLine("Writing venues to filestore...");
filestore.WriteCaching = true;
foreach(Venue ven in venues)
{
string[] acls = database.GetVenueSecurity(ven.Identifier);
ven.AccessList = new SecurityPatterns(acls);
filestore.AddVenue(ven);
}
filestore.WriteCaching = false;
#endregion
#region Move the participants
Console.WriteLine("Getting participants from database...");
Participant[] participants = database.GetParticipants();
Console.WriteLine("Writing participants to filestore...");
filestore.WriteCaching = true;
foreach(Participant part in participants)
{
filestore.AddParticipant(part);
}
filestore.WriteCaching = false;
#endregion
}
catch (System.Data.SqlClient.SqlException)
{
Console.WriteLine();
Console.WriteLine("The database could not be properly accessed. Utility failed to execute.");
Console.WriteLine("Press 'enter' to exit...");
Console.ReadLine();
}
filestore.Dispose();
}
static void Main(string[] args)
{
// Override the system UICulture
string cultureOverride = null;
if ((cultureOverride = ConfigurationManager.AppSettings["MSR.LST.ConferenceXP.VenueService.UICulture"]) != null) {
try {
System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo(cultureOverride);
System.Threading.Thread.CurrentThread.CurrentUICulture = ci;
}
catch { }
}
#region Create the file store
string filePath = ConfigurationManager.AppSettings["FilePath"];
if (filePath == null || filePath == String.Empty)
{
// Use the registry key
using(RegistryKey key = Registry.LocalMachine.OpenSubKey(StorageInstaller.LocalMachineSubkey))
{
filePath = (string)key.GetValue("DataFile");
}
}
FileStorage filestore = new FileStorage(filePath);
#endregion
#region Delete existing participants & venues
Venue[] oldVenues = filestore.GetVenues();
Participant[] oldParts = filestore.GetParticipants();
if (oldVenues.Length == 2 && (oldParts == null || oldParts.Length == 0))
{
// This is the default install. Just delete them.
foreach(Venue oldVenue in oldVenues)
{
filestore.DeleteVenue(oldVenue.Identifier);
}
}
#endregion
#region Get the connection string
string connString = ConfigurationManager.AppSettings["SqlConnectionString"];
DatabaseStorage database = new DatabaseStorage(connString);
#endregion
try
{
#region Move the venues
Console.WriteLine(Strings.GettingVenuesFromDatabase);
Venue[] venues = database.GetVenues();
Console.WriteLine(Strings.WritingVenuesToFilestore);
filestore.WriteCaching = true;
foreach(Venue ven in venues)
{
string[] acls = database.GetVenueSecurity(ven.Identifier);
ven.AccessList = new SecurityPatterns(acls);
filestore.AddVenue(ven, new PrivateVenueState());
}
filestore.WriteCaching = false;
#endregion
#region Move the participants
Console.WriteLine(Strings.GettingParticipantsFromDatabase);
Participant[] participants = database.GetParticipants();
Console.WriteLine(Strings.WritingParticipantsToFilestore);
filestore.WriteCaching = true;
foreach(Participant part in participants)
{
filestore.AddParticipant(part);
}
filestore.WriteCaching = false;
#endregion
}
catch (System.Data.SqlClient.SqlException)
{
Console.WriteLine();
Console.WriteLine(Strings.DatabaseCouldNotBeProperlyAccessed);
Console.WriteLine(Strings.PressEnterToExit);
Console.ReadLine();
}
filestore.Dispose();
}
