Database

<code>static void Main(string[] args)
{
    try
    {
        SqlConnection LoadLastConnection = new SqlConnection();
        LoadLastConnection.ConnectionString = "User ID=blah;Password=Blah;Initial Catalog=sellmdat2kSQL;Data Source=jpltpharos";
        LoadLastConnection.Open();
        Console.Write("Please enter a Machine_Number(4 characters): ");
        string Machine_Number = Console.ReadLine();
        Console.Write("Please enter the Last_Shift_Number(4 characters): ");
        string Last_Shift_Number = Console.ReadLine();
        SqlCommand LoadLastInvoiceCmd = new SqlCommand();
        LoadLastInvoiceCmd.Connection = LoadLastConnection;
        //LoadLastInvoiceCmd.CommandText = "SELECT sum (Amount) From Transaction_table WHERE Location_ID = 'va60' and Shift_Number = 1" ;

        LoadLastInvoiceCmd.CommandText = "SELECT sum (Amount) From Transaction_table WHERE Location_ID = @machineName and Shift_Number = @ShiftNumber" ;
        LoadLastInvoiceCmd.Parameters.Add("@machineName", Machine_Number);
        LoadLastInvoiceCmd.Parameters.Add("@ShiftNumber", Last_Shift_Number);
        SqlDataReader dataReader = LoadLastInvoiceCmd.ExecuteReader();
        while (dataReader.Read())
        {
            int last_invoice = dataReader.GetInt32(0);
            string Amount = dataReader.GetString(1);
            Console.WriteLine("Current Invoice Period is {0}\nAnd the Cash Value is {1}\nTotal Dollars", last_invoice, Amount);

        }
        dataReader.Close();
        LoadLastConnection.Close();
    }
    catch(Exception e)
    {
        Console.WriteLine("An error occurred accessing the database:" + e.Message);
    }
}</code>