Beispiel #1
0
 public void ShowTable()
 {
     con.Open();
     for (int i = 0; i < dt_borrower.Rows.Count; i++)
     {
         BORROWERSLIST.Add(new BORROWER(dt_borrower.Rows[i]["LastName"].ToString(), dt_borrower.Rows[i]["FirstName"].ToString(), dt_borrower.Rows[i]["Gender"].ToString(), dt_borrower.Rows[i]["BorrowerType"].ToString(), Convert.ToInt16(dt_borrower.Rows[i]["BorrowerID"]), dt_borrower.Rows[i]["BorrowStatus"].ToString()));
     }
     for (int i = 0; i < dt_book.Rows.Count; i++)
     {
         BOOKSLIST.Add(new BOOK(dt_book.Rows[i]["Title"].ToString(), dt_book.Rows[i]["Category"].ToString(), int.Parse(dt_book.Rows[i]["AuthorID"].ToString()), Convert.ToInt16(dt_book.Rows[i]["BookID"]), dt_book.Rows[i]["Availability"].ToString()));
     }
     con.Close();
 }
Beispiel #2
0
        public void ShowTable()
        {
            SqlConnection  con   = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\JulyEd\Downloads\4th year 2nd semester\OOP\LIBRARYMANAGEMENTPART2\LIBRARYMANAGEMENTPART2\LibraryManagementSysytem.mdf;Integrated Security=True;Connect Timeout=30;");
            DataTable      dt    = new DataTable();
            DataTable      dt1   = new DataTable();
            DataTable      dt2   = new DataTable();
            SqlDataAdapter node1 = new SqlDataAdapter("SELECT LastName,FirstName,Gender,BorrowerType,ID FROM [BORROWER]", con);
            SqlDataAdapter node2 = new SqlDataAdapter("SELECT ID,Title, Category, Availability FROM[BOOK]", con);
            SqlDataAdapter node3 = new SqlDataAdapter("SELECT LastName,FirstName FROM[Author]", con);

            node1.Fill(dt);
            node2.Fill(dt1);
            node3.Fill(dt2);
            for (int i = 0; i < 5; i++)
            {
                BORROWERSLIST.Add(new BORROWER(dt.Rows[i]["LastName"].ToString(), dt.Rows[i]["FirstName"].ToString(), dt.Rows[i]["Gender"].ToString(), dt.Rows[i]["BorrowerType"].ToString(), Convert.ToInt16(dt.Rows[i]["ID"]), CheckBorrowedBook.NONE.ToString()));
                BOOKSLIST.Add(new BOOK(dt1.Rows[i]["Title"].ToString(), dt1.Rows[i]["Category"].ToString(), dt2.Rows[i]["LastName"].ToString(), dt2.Rows[i]["FirstName"].ToString(), Convert.ToInt16(dt1.Rows[i]["ID"]), dt1.Rows[i]["Availability"].ToString()));
            }
        }
Beispiel #3
0
        public MainViewModel()
        {
            viewborrowers = CollectionViewSource.GetDefaultView(BORROWERSLIST);
            viewbooks     = CollectionViewSource.GetDefaultView(BOOKSLIST);
            viewviolators = CollectionViewSource.GetDefaultView(VIOLATORSLIST);

            BOOKCATEGORIES.Add("Math");
            BOOKCATEGORIES.Add("Science");
            BOOKCATEGORIES.Add("Religion");
            BOOKCATEGORIES.Add("Arts");
            BOOKCATEGORIES.Add("History");
            BOOKCATEGORIES.Add("English");
            BOOKCATEGORIES.Add("Business");

            BORROWERSLIST.Add(new Borrower("Catubog", "July", "Male", "Student", 10293, CheckBorrowedBook.NONE.ToString()));
            BORROWERSLIST.Add(new Borrower("Libadisos", "Keiji", "Male", "Student", 62748, CheckBorrowedBook.NONE.ToString()));
            BORROWERSLIST.Add(new Borrower("Yamamoto", "Ryu", "Male", "Teacher", 81639, CheckBorrowedBook.NONE.ToString()));
            BORROWERSLIST.Add(new Borrower("Salazar", "Aprilyn", "Female", "Teacher", 72538, CheckBorrowedBook.NONE.ToString()));
            BORROWERSLIST.Add(new Borrower("Jaleco", "Rene", "Male", "Student", 13256, CheckBorrowedBook.NONE.ToString()));
            BORROWERSLIST.Add(new Borrower("Ottoman", "GG", "Male", "Teacher", 12345, CheckBorrowedBook.NONE.ToString()));
            BORROWERSLIST.Add(new Borrower("Ferraren", "Jiji", "Female", "Teacher", 37702, CheckBorrowedBook.NONE.ToString()));
            BORROWERSLIST.Add(new Borrower("Nursing", "Puti", "Female", "Student", 72635, CheckBorrowedBook.NONE.ToString()));
            BORROWERSLIST.Add(new Borrower("Saluage", "Angelito", "Male", "Teacher", 25363, CheckBorrowedBook.NONE.ToString()));
        }