CommandLineWorkerDba.cs

#region Copyright Notice
/* Copyright (c) 2017, Deb'jyoti Das - debjyoti@debjyoti.com
 All rights reserved.
 Redistribution and use in source and binary forms, with or without
 modification, are not permitted.Neither the name of the 
 'Deb'jyoti Das' nor the names of its contributors may be used 
 to endorse or promote products derived from this software without 
 specific prior written permission.
 THIS SOFTWARE IS PROVIDED BY Deb'jyoti Das 'AS IS' AND ANY
 EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
 WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
 DISCLAIMED. IN NO EVENT SHALL Debjyoti OR Deb'jyoti OR Debojyoti Das OR Eyedia BE LIABLE FOR ANY
 DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
 (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
 LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
 ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */

#region Developer Information
/*
Author  - Debjyoti Das (debjyoti@debjyoti.com)
Created - 11/12/2017 3:31:31 PM
Description  - 
Modified By - 
Description  - 
*/
#endregion Developer Information

#endregion Copyright Notice

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Eyedia.Aarbac.Framework;
using System.Configuration;

namespace Eyedia.Aarbac.Command
{
    public class CommandLineWorkerDba: CommandLineWorker
    {
        const string __csformat = "data source={0};Integrated security=True;";
        const string __csformatuser = "data source={0};User Id={1};Password={2};";
   
        public CommandLineWorkerDba():base()
        {

        }
        /// <summary>
        /// Create new rbac database on specified MS Sql Server instance. usage: aarbac -c id -s servername [-i false] [-u username] [-p password] [-n dbname]
        /// </summary>
        /// <param name="options"></param>
        public void CreateNew(Options options)
        {
            bool errored = false;
            if (string.IsNullOrEmpty(options.Server))
            {
                WriteErrorLine("Sql server name is required. Please use -s <servername>");
                errored = true;
            }

            if (!options.IntegratedSecurity)
            {
                if (string.IsNullOrEmpty(options.UserName))
                {
                    WriteErrorLine("Sql server user name is required when integrated security is false. Please use -u <username>");
                    errored = true;
                }

                if (string.IsNullOrEmpty(options.Password))
                {
                    WriteErrorLine("Sql server name user password is required required when integrated security is false. Please use -p <password>");
                }

                Console.WriteLine("Please use -is <true/false> to set integrated security");
            }
            if (string.IsNullOrEmpty(options.Name))
                options.Name = "aarbac";

            if (errored)
                return;

            string connectionString = string.Empty;
            if (options.IntegratedSecurity)
                connectionString = string.Format(__csformat, options.Server);
            else
                connectionString = string.Format(__csformatuser, options.Server, options.UserName, options.Password);

            RbacDba dba = new RbacDba(connectionString);
            if (dba.DatabaseExists(options.Name))
            {
                WriteErrorLine("Database {0} already exist!", options.Name);
                return;
            }

            Console.Write("Contacting server...".PadRight(RbacDba.__maxInfoLen, '.'));
            new RbacDba(connectionString).CreateDatabase(options.Name);
            WriteColor(ConsoleColor.Green, "All done!" + Environment.NewLine);
            Console.WriteLine();
            string connectionStringWithDb = connectionString + "Initial Catalog=" + options.Name;


            var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
            var connectionStringsSection = (ConnectionStringsSection)config.GetSection("connectionStrings");
            if (connectionStringsSection.ConnectionStrings["aarbac"] != null)
                connectionStringsSection.ConnectionStrings["aarbac"].ConnectionString = connectionStringWithDb;
            else
                connectionStringsSection.ConnectionStrings.Add(new ConnectionStringSettings("aarbac", connectionStringWithDb));
            config.Save();
            ConfigurationManager.RefreshSection("connectionStrings");

        }
        
    }
}