예제 #1
0
 public static void MakeEmptyLines(int NumberOfEmptyLines)
 {
     for (int Counter = 0; Counter < NumberOfEmptyLines; Counter++)
     {
         ToolsOutput.PrintStringOnSeperateLine("");
     }
 }
        public static bool OpenDatabaseConnection()
        {
            try
            {
                // Build connection string
                Builder                    = new SqlConnectionStringBuilder();
                Builder.DataSource         = "PCM15715"; // update me
                Builder.InitialCatalog     = "h1pd080119";
                Builder.IntegratedSecurity = true;

                Connection = new SqlConnection(Builder.ConnectionString);

                // Connect to SQL
                ToolsOutput.PrintStringOnSeperateLine("Connecting to SQL Server ... ");

                Connection.Open();
                ToolsOutput.PrintStringOnSeperateLine("Done.");
                Connection.Close();

                return(true);
            }
            catch (SqlException e)
            {
                ToolsOutput.PrintStringOnSeperateLine(e.ToString());
                return(false);
            }
        }
        public static void WatchStudentList(SQLAndDatabaseInfo SQLTable)
        {
            int    Counter;
            string OutputString;

            Connection.Open();

            ToolsOutput.PrintStringOnSeperateLine(SQLTable.SQLCommandString);
            ToolsOutput.PrintStringOnSeperateLine("");

            using (SqlCommand Command = new SqlCommand(SQLTable.SQLCommandString, Connection))
            {
                OutputString = "";
                for (Counter = 0; Counter < SQLTable.DatabseInfoList.Count; Counter++)
                {
                    if (true == SQLTable.DatabseInfoList[Counter].ShowField)
                    {
                        OutputString += SQLTable.DatabseInfoList[Counter].FieldName + '\t';
                    }
                }
                ToolsOutput.PrintStringOnSeperateLine(OutputString);
                ToolsOutput.PrintStringOnSeperateLine("");

                using (SqlDataReader Reader = Command.ExecuteReader())
                {
                    while (Reader.Read())
                    {
                        OutputString = "";
                        for (Counter = 0; Counter < StudentListInfo.Count; Counter++)
                        {
                            if (true == StudentListSQL.DatabseInfoList[Counter].ShowField)
                            {
                                OutputString += SQLTable.DatabseInfoList[Counter].ConvertReceivedDatabaseValueFunc(Reader, SQLTable.DatabseInfoList[Counter].FieldColumnNumber) + '\t';
                            }
                        }
                        ToolsOutput.PrintStringOnSeperateLine(OutputString);
                    }
                }
            }

            Connection.Close();

            ToolsInput.WaitForUser();
        }
예제 #4
0
        public static int MakeMenu(string[] StringListHere)
        {
            int  KeypressedValue     = 0;
            char KeypressedValueChar = '0';

            char[] ValidCharArray = new char[StringListHere.Length];

            for (int Counter = 0; Counter < StringListHere.Length; Counter++)
            {
                char[] _chars = (Counter + 1).ToString().ToCharArray();
                ValidCharArray[Counter] = _chars[0];
            }

            ToolsScreen.ClearScreen();
            foreach (string Item in StringListHere)
            {
                ToolsOutput.PrintStringOnSeperateLine(Item);
            }
            KeypressedValueChar = ToolsInput.GetKeyPress("Indtast dit valg (1 - " + StringListHere.Length + ") : ", ValidCharArray, false);
            KeypressedValue     = KeypressedValueChar.ParseInt32();

            return(KeypressedValue);
        }