public static void AddUser()
        {
            Console.WriteLine("Enter a First name");
            string FirstName = Console.ReadLine();

            Console.WriteLine("Enter a Last name");
            string LastName = Console.ReadLine();

            Console.WriteLine("Enter a Email Address ");
            string EmailAddress = Console.ReadLine();

            Console.WriteLine("Enter Pass Word  ");
            string PasswordHash = Console.ReadLine();

            Console.WriteLine("Enter User Type  ");
            int UserType = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter Gender ID  ");
            int GenderId = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter DepId ");
            int DepartmentId = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter Statusid  ");
            int StatusId = Convert.ToInt32(Console.ReadLine());



            var _Obj = new Add_User();

            _Obj.InsertUsers(FirstName, LastName, EmailAddress, PasswordHash, UserType, GenderId, DepartmentId, StatusId);
        }
        public static void AddUser()
        {
            Console.WriteLine("Enter a First name");
            string FirstName = Console.ReadLine().Trim();;

            Console.WriteLine("Enter a Last name");
            string LastName = Console.ReadLine().Trim();;

            Console.WriteLine("Enter a Email Address ");
            string EmailAddress = Console.ReadLine().Trim();

            Console.WriteLine("Enter Pass Word  ");
            string PasswordHash = Console.ReadLine().Trim();


            SHA256 hash = new SHA256Cng();

            byte[] hashvalue = hash.ComputeHash(System.Text.Encoding.UTF8.GetBytes(PasswordHash));
            PasswordHash = System.Text.Encoding.Default.GetString(hashvalue);

            Console.WriteLine("Enter User Type  ");
            int UserType = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter Gender ID  ");
            int GenderId = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter DepId ");
            int DepartmentId = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter Statusid  ");
            int StatusId = Convert.ToInt32(Console.ReadLine());

            var _Obj   = new Add_User();
            var userId = _Obj.InsertUsers(FirstName, LastName, EmailAddress, PasswordHash, UserType, GenderId, DepartmentId, StatusId);



            //write address
            Console.WriteLine("Province");
            int ProvinceId = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter Region");
            int RegionId = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter CityId");
            int CityId = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("Enter Surburb ID");
            int SurburbId = Convert.ToInt32(Console.ReadLine());

            Console.WriteLine("StreetName");
            string Streetname = Console.ReadLine();

            Console.WriteLine("Enter Unit No ");
            int Unit = Convert.ToInt32(Console.ReadLine());



            var _ObjAdd = new Add_Physical_Address();


            _ObjAdd.AddressAdd(userId, ProvinceId, CityId, SurburbId, RegionId, Streetname, Unit);

            // Writing postal addfess


            //Console.WriteLine("Enter a PostalAddress");
            //int PostalAddressID = Convert.ToInt32(Console.ReadLine());


            //Console.WriteLine("Enter a PostalAddress");
            //int PostalAddress = Convert.ToInt32(Console.ReadLine());

            //Console.WriteLine("Enter a PostalAddress");
            //int PostalCode = Convert.ToInt32(Console.ReadLine());


            //Console.WriteLine("Enter a PostalAddress");
            //int AreaCode = Convert.ToInt32(Console.ReadLine());



            //  public void PostalAddressAdd(PostalAddress, PostalAddress, PostalAddressID, PostalAddress, PostalCode, AreaCode);
        }