//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();
}
}
}
