public static void Read() { Design.Welcome2(); Console.Write("How many hour you want to read this book:"); l7: try { hour = int.Parse(Console.ReadLine()); if (hour > 12) { Console.Write("Enter number of hours less than 12 hours: "); goto l7; } } catch { Console.Write("Enter the ((number)) of hours: "); goto l7; } Console.WriteLine(); Console.WriteLine(); Design.Line(); Console.WriteLine(); studentInformation(); array[5] = "The book's situation is: Read for " + hour + " hours. "; Console.WriteLine("The book's situation is: Read for {0} hours. ", hour); bookInformation(); Design.Lines2(); Design.clear(); Design.exit(); }
public static void Return() { //Collection With the database of book { try { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\السباعي\Desktop\Library System\Library System\Library System\Books.mdf;Integrated Security=True"); con.Open(); Design.Welcome2(); Console.WriteLine(); SqlCommand readB = new SqlCommand("select * from books where number= '" + bookId + "'", con); SqlDataReader drB = readB.ExecuteReader(); drB.Read(); if (drB.GetValue(10).ToString() != Convert.ToString(Windows.id)) { array[5] = "You didn't borrow this book Before!"; Console.WriteLine("You didn't borrow this book Before!"); Design.Lines2(); Design.clear(); book(); } else { studentInformation(); thatday = Convert.ToDateTime(drB.GetValue(5)); Dept = Convert.ToInt32(drB.GetValue(9)); st = thatday - today; days = st.Days - 1; if (dept == Dept) { if (days > 3) { array[5] = "The book's situation is: Return after " + days + " days of the metaphor from " + today.ToShortDateString() + " to " + Convert.ToDateTime(drB.GetValue(5)).ToShortDateString() + ". "; Console.WriteLine("The book's situation is: Return after {0} days of the metaphor from {1} to {2}. ", drB.GetValue(4).ToString(), today.ToShortDateString(), Convert.ToDateTime(drB.GetValue(5)).ToShortDateString()); for (int i = days - 3; i > 0; i--) { money += 3; } array[10] = "The money that you must to pay is " + money + "$."; Console.WriteLine("The money that you must to pay is {0}$.", money); } else { array[5] = "Thanks for returning our book ^_^"; Console.WriteLine("Thanks for returning our book ^_^"); } bookInformation(); con.Close(); con.Open(); SqlCommand NullDays = new SqlCommand("update books set borrow = DEFAULT where number= '" + bookId + "'", con); NullDays.ExecuteNonQuery(); SqlCommand NullDate = new SqlCommand("update books set Returning = DEFAULT where number= '" + bookId + "'", con); NullDate.ExecuteNonQuery(); SqlCommand NullDepartment = new SqlCommand("update books set tokenFrom = DEFAULT where number= '" + bookId + "'", con); NullDepartment.ExecuteNonQuery(); SqlCommand NullStudentID = new SqlCommand("update books set studentID = DEFAULT where number= '" + bookId + "'", con); NullStudentID.ExecuteNonQuery(); Design.Lines2(); Design.clear(); Design.exit(); } else { array[5] = "<'_'> You Don't borrow this book from this depatment. <'_'>"; Console.WriteLine("<'_'> You Don't borrow this book from this depatment. <'_'>"); } } con.Close(); } catch (Exception x) { Console.WriteLine(x.Message); } } }
public static void Borrow() { //Collection With the database of book { try { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\السباعي\Desktop\Library System\Library System\Library System\Books.mdf;Integrated Security=True"); con.Open(); Design.Welcome2(); SqlCommand readborrow = new SqlCommand("select * from books where number='" + bookId + "'", con); SqlDataReader read = readborrow.ExecuteReader(); read.Read(); if (read.GetValue(4).ToString() != "0") { array[5] = "Sorry <-_-> You can't borrow this book!"; Console.WriteLine("Sorry <-_-> You can't borrow this book!"); con.Close(); Design.Lines2(); Design.clear(); book(); } else { Console.WriteLine("\nNote: "); Console.WriteLine("You can borrow the book for 3 days"); Console.Write("How many days you want to borrow the book:"); l8: try { days = int.Parse(Console.ReadLine()); if (days != 1 && days != 2 && days != 3) { Console.Write("Enter number of days <<1 or 2 or 3>>: "); goto l8; } } catch { Console.Write("Enter the ((number)) of days: "); goto l8; } con.Close(); con.Open(); SqlCommand readDays = new SqlCommand("update books set borrow= '" + days + "'where number= '" + bookId + "'", con); readDays.ExecuteNonQuery(); SqlCommand readDept = new SqlCommand("update books set tokenFrom= '" + dept + "'where number= '" + bookId + "'", con); readDept.ExecuteNonQuery(); SqlCommand readID = new SqlCommand("update books set studentID= '" + Windows.id + "'where number= '" + bookId + "'", con); readID.ExecuteNonQuery(); Console.WriteLine(); Design.Line(); Console.WriteLine(); studentInformation(); thatday = today.AddDays(days); if (days == 1) { array[5] = "The book's situation is: Borrow for " + days + " day from " + today.ToString("d/M/yyyy") + " to " + thatday.ToString("d/M/yyyy") + ". "; Console.WriteLine("The book's situation is: Borrow for {0} day from {1} to {2}. ", days, today.ToString("d/M/yyyy"), thatday.ToString("d/M/yyyy")); } else { array[5] = "The book's situation is: Borrow for " + days + " days from " + today.ToString("d/M/yyyy") + " to " + thatday.ToString("d/M/yyyy") + ". "; Console.WriteLine("The book's situation is: Borrow for {0} days from {1} to {2}. ", days, today.ToString("d/M/yyyy"), thatday.ToString("d/M/yyyy")); } SqlCommand setDate = new SqlCommand("update books set Returning= '" + thatday.ToShortDateString() + "'where number= '" + bookId + "'", con); setDate.ExecuteNonQuery(); bookInformation(); Console.WriteLine(); Design.Line(); Console.WriteLine("\nNote: "); Console.WriteLine("If you return the book after more than three days you'll pay 3$ for each day."); Design.Lines2(); Design.clear(); Design.exit(); con.Close(); } } catch (Exception x) { Console.WriteLine(x.Message); } } }
public static void book() { //Collection With the database of book { try { SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\السباعي\Desktop\Library System\Library System\Library System\Books.mdf;Integrated Security=True"); Design.Welcome2(); Console.WriteLine(); Console.WriteLine("\n\t\t\t\t\t Database Connected"); Console.WriteLine("Choose number from 1 to 3: "); Console.WriteLine("1) Information System. "); Console.WriteLine("2) Information Technology. "); Console.WriteLine("3) Computer Science. "); Console.Write("Please enter your choice:"); l5: try { number = int.Parse(Console.ReadLine()); } catch { Console.Write("Enter the number: ((1 or 2 or 3 )): "); goto l5; } dept = number; switch (number) { case 1: Department(1); break; case 2: Department(2); break; case 3: Department(3); break; default: Console.Write("Enter Just number: ((1 or 2 or 3 )): "); goto l5; } l7: Console.Write("\nEnter the number of book: "); l6: try { bookId = int.Parse(Console.ReadLine()); con.Open(); SqlCommand search = new SqlCommand("Select number from books", con); SqlDataReader value = search.ExecuteReader(); while (value.Read()) { if (value.GetValue(0).ToString() == Convert.ToString(bookId)) { Not = 0; Console.WriteLine("\t\t\t\t\t ^_^ We find the book ^_^"); break; } } con.Close(); if (Not == 1) { Console.WriteLine("\t\t\t\t\t<'_'> The book is Not in our Libraray <'_'>"); goto l7; } } catch (Exception x) { Console.WriteLine(x.Message); Console.Write("\nEnter THE NUMBER OF BOOK: "); goto l6; } Design.Lines2(); Design.clear(); List(); } catch (Exception x) { Console.WriteLine(x.Message); } } }
//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(); } } }