Beispiel #1
0
        public static void Department(int dept)
        {
            //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.Line();
                    Console.WriteLine();
                    Console.WriteLine("\n\t\t\t\t\t   Database Connected");
                    if (dept == 1)
                    {
                        Console.WriteLine("\t\t\t\t ^_^ The Information System's 1books ^_^");
                        quere = "select * from books where [IS] != 0 ";
                    }
                    if (dept == 2)
                    {
                        Console.WriteLine("\t\t\t\t ^_^ The Information Technology's  books ^_^");
                        quere = "select * from books where IT != 0 ";
                    }
                    if (dept == 3)
                    {
                        Console.WriteLine("\t\t\t\t ^_^ The Computer Science's  books ^_^");
                        quere = "select * from books where CS != 0 ";
                    }
                    SqlCommand department = new SqlCommand(quere, con);
                    department.ExecuteNonQuery();
                    SqlDataReader Dr = department.ExecuteReader();

                    while (Dr.Read())
                    {
                        Console.WriteLine(Dr.GetValue(0).ToString() + ") " + Dr.GetValue(1).ToString());
                    }
                    con.Close();
                    con.Open();
                    SqlCommand insert = new SqlCommand("Insert into books (tokenFrom) values ('" + dept + "')", con);
                    insert.ExecuteNonQuery();
                    con.Close();
                }
                catch (Exception x)
                {
                    Console.WriteLine(x.Message);
                }
            }
        }
Beispiel #2
0
        /*2)Question Card
         * yes goto verification from that
         * no goto Registering a Student
         */
        public static void page2()
        {
            Console.BackgroundColor = ConsoleColor.Red;
            Console.Clear();
            Console.SetCursorPosition(0, 3);
            Console.ForegroundColor = ConsoleColor.Black;
            Design.Line();
            Design.Line();
            Console.ForegroundColor = ConsoleColor.Yellow;
            Console.SetCursorPosition(40, 7);
            Console.WriteLine("Do You Have an universal card?");
            Console.SetCursorPosition(40, 9);
            Console.Write("1- Yes.");
            Console.WriteLine("\t\t    2- No.");
            Console.SetCursorPosition(40, 11);
            Console.Write("Enter the number: ");
l1:
            try
            {
                number = int.Parse(Console.ReadLine());
            }
            catch
            {
                Console.Write("Enter the number: ((1 or 2)): ");
                goto l1;
            }
            switch (number)
            {
            case 1:
                Design.Lines();
                verification();
                break;

            case 2:
                Design.Lines();
                Pagestudent();
                break;

            default:
                Console.Write("Enter Just number: ((1 or 2)): ");
                goto l1;
            }
        }
Beispiel #3
0
 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);
         }
     }
 }
Beispiel #4
0
        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);
                }
            }
        }
Beispiel #5
0
        public static void List()
        {
            Console.BackgroundColor = ConsoleColor.Black;
            Console.Clear();
            Console.ForegroundColor = ConsoleColor.Red;
            Design.Line();
            Design.Line();
            Console.SetCursorPosition(47, 3);
            Console.WriteLine("Welcome To Library System");
            Console.SetCursorPosition(0, 5);
            Design.Line();
            Design.Line();
            Console.SetCursorPosition(45, 10);
            Console.ForegroundColor = ConsoleColor.DarkRed;
            Console.WriteLine("Enter Number from  1 to 4: ");
            Console.ForegroundColor = ConsoleColor.DarkBlue;
            Console.SetCursorPosition(45, 11);
            Console.WriteLine("1- Read the Book.");
            Console.ForegroundColor = ConsoleColor.DarkMagenta;
            Console.SetCursorPosition(45, 12);
            Console.WriteLine("2- Borrow the book.");
            Console.ForegroundColor = ConsoleColor.DarkYellow;
            Console.SetCursorPosition(45, 13);
            Console.WriteLine("3- Return the book.");
            Console.ForegroundColor = ConsoleColor.DarkGreen;
            Console.SetCursorPosition(45, 14);
            Console.WriteLine("4- Exit from the System.");
            Console.ForegroundColor = ConsoleColor.Gray;
            Console.SetCursorPosition(45, 17);
            Console.Write("Enter the number:");
l4:
            try
            {
                number = int.Parse(Console.ReadLine());
            }
            catch
            {
                Console.Write("Enter the number: ((1 or 2 or 3 or 4)): ");
                goto l4;
            }

            switch (number)
            {
            case 1:
                Design.Lines2red();
                Read();
                break;

            case 2:
                Design.Lines2red();
                Borrow();
                break;

            case 3:
                Design.Lines2red();
                Return();
                break;

            case 4:
                Design.Lines2red();
                Design.exit();
                break;

            default:
                Console.Write("Enter Just number: ((1 or 2 or 3 or 4)): ");
                goto l4;
            }
        }
Beispiel #6
0
        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);
                }
            }
        }
Beispiel #7
0
        //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();
        }
Beispiel #8
0
        /*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();
                }
            }
        }
Beispiel #9
0
        //method of calss Windows

        //1) Welcome To Library System
        public static void page1()
        {
            Design.Welcome1();
            Design.clear();
        }