コード例 #1
0
        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();
        }
コード例 #2
0
        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();
        }
コード例 #3
0
ファイル: Convertor.cs プロジェクト: abhishek-kumar/AIGA
        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();
        }
コード例 #4
0
ファイル: Convertor.cs プロジェクト: psyCHOder/conferencexp
        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();
        }