//4)Registering a Student public static void Pagestudent() { Design.Welcome2(); Console.SetCursorPosition(0, 7); Console.ForegroundColor = ConsoleColor.DarkBlue; Console.WriteLine("Enter your ID: "); Console.ForegroundColor = ConsoleColor.Red; l2: try { id = int.Parse(Console.ReadLine()); } catch { Console.ForegroundColor = ConsoleColor.DarkBlue; Console.WriteLine("Enter your ID ((Number)): "); Console.ForegroundColor = ConsoleColor.Red; goto l2; } Console.ForegroundColor = ConsoleColor.DarkBlue; Console.WriteLine("Enter your First name: "); Console.ForegroundColor = ConsoleColor.Red; Fname = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.DarkBlue; Console.WriteLine("Enter your Middel name: "); Console.ForegroundColor = ConsoleColor.Red; Mname = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.DarkBlue; Console.WriteLine("Enter your Last name: "); Console.ForegroundColor = ConsoleColor.Red; Lname = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.DarkBlue; Console.WriteLine("Enter your Colloge's name: "); Console.ForegroundColor = ConsoleColor.Red; colloge = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.DarkBlue; Console.WriteLine("Enter your University's name:"); Console.ForegroundColor = ConsoleColor.Red; university = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.DarkBlue; Console.WriteLine("Enter your Department's name:"); Console.ForegroundColor = ConsoleColor.Red; dept = Console.ReadLine(); Console.ForegroundColor = ConsoleColor.Black; Console.Write("\nPlease Wait ..."); //Collection With the database of student { try { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\السباعي\Desktop\Library System\Library System\Library System\Students.mdf;Integrated Security=True"); con.Open(); Console.WriteLine("\n\n\t\t\t\t\t\tDatabase Connected"); SqlCommand insert = new SqlCommand("Insert into Students values ('" + id + "','" + Fname + "','" + Mname + "','" + Lname + "','" + colloge + "','" + university + "','" + dept + "')", con); insert.ExecuteNonQuery(); Console.WriteLine("\t\t\t\t\t ^_^ The Information Inserted ^_^"); con.Close(); } catch (Exception x) { Console.WriteLine(x.Message); } } Design.Lines(); LibrarySystem.book(); }
/*3)verification from the Student * he is found? * yes goto booklist * no Question Card */ public static void verification() { Design.Welcome2(); Console.ForegroundColor = ConsoleColor.DarkRed; Console.SetCursorPosition(45, 12); Console.Write("Enter your ID: "); Console.ForegroundColor = ConsoleColor.DarkGreen; l3: try { id = int.Parse(Console.ReadLine()); } catch { Console.ForegroundColor = ConsoleColor.DarkRed; Console.Write("Enter your ID ((Number)): "); Console.ForegroundColor = ConsoleColor.DarkGreen; goto l3; } Console.ForegroundColor = ConsoleColor.Black; Console.Write("\nPlease Wait ..."); //Collection With the database of student { try { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\السباعي\Desktop\Library System\Library System\Library System\Students.mdf;Integrated Security=True"); con.Open(); Console.WriteLine("\n\n\t\t\t\t\t\tDatabase Connected"); SqlCommand search = new SqlCommand("Select Id from Students", con); SqlDataReader value = search.ExecuteReader(); while (value.Read()) { TempID = value.GetValue(0).ToString(); if (TempID == Convert.ToString(id)) { Not = 0; Console.WriteLine("\t\t\t\t\t ^_^ We find you ^_^"); } } if (Not == 1) { Console.WriteLine("\t\t\t\t\t<'_'> You are Not in our system <'_'>"); } con.Close(); } catch (Exception x) { Console.WriteLine(x.Message); } Design.Lines(); if (Not == 1) { page2(); } else { LibrarySystem.book(); } } }