using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;

namespace DatabaseActions
{
    class Program
    {
        public static void AddUser(string firstname, string lastname, string username, string password, string password2, string email, string location, string birthday, string gender)
        {
            string connectionstring = @"Data Source=(localdb)\MSSQLLocalDB;initial catalog=GedgetsDB";

            SqlConnection connection = new SqlConnection(connectionstring);

            connection.Open();
            string insert1 = "INSERT INTO TBL_Users(FirstName, LastName, UserName, Password, Password2, Email, Location, Birthday, Gender)";
            string insert2 = "VALUES ('" + firstname + "' , '" + lastname + "' , '" + username + "' , '" + password + "' , '" + password2 + "' , '" + email + "' , '" + location + "' , '" + birthday + "' , '" + gender+"')";
            string Insertcommandtext = insert1 + insert2;

            SqlCommand command = new SqlCommand(Insertcommandtext, connection);
            command.ExecuteNonQuery();
            connection.Close();
        }
        static void Main(string[] args)
        {
            Console.Write("Enter firstname: ");
            string firstname = Console.ReadLine();
            Console.Write("Enter lastname: ");
            string lastname = Console.ReadLine();
            Console.Write("Enter username: ");
            string username = Console.ReadLine();
            Console.Write("Enter password: ");
            string password = Console.ReadLine();
            Console.Write("Enter password2: ");
            string password2 = Console.ReadLine();
            Console.Write("Enter email: ");
            string email = Console.ReadLine();
            Console.Write("Enter location: ");
            string location = Console.ReadLine();
            Console.Write("Enter birthday: ");
            string birthday = Console.ReadLine();
            Console.Write("Enter gender: ");
            string gender = Console.ReadLine();
            AddUser(firstname, lastname, username, password, password2, email, location, birthday, gender);

        }
    }
}