示例#1
0
        public MainForm()
        {
            InitializeComponent();

            _bookRepository   = new SqlBookRepository(ConfigurationManager.ConnectionStrings["dbLibrary"].ConnectionString);
            _memberRepository = new SqlMemberRepository(ConfigurationManager.ConnectionStrings["dbLibrary"].ConnectionString);
            _bookedRepository = new SqlBookedRepository(ConfigurationManager.ConnectionStrings["dbLibrary"].ConnectionString);
            _userRepository   = new SqlUserRepository(ConfigurationManager.ConnectionStrings["dbLibrary"].ConnectionString);
            // Fill BookDataGrid with all books
            IEnumerable <BookInfo> bookList = _bookRepository.SelectBooksInfo("", "");

            dataGridViewBooks.ClearSelection();
            dataGridViewBooks.DataSource = bookList;

            // Fill MemberDataGrid with all members
            IEnumerable <MemberIdInfo> memberList = _memberRepository.SelectMembersIdInfo("", "");

            dataGridViewMembers.ClearSelection();
            dataGridViewMembers.DataSource = memberList;

            IEnumerable <BookedInfo> bookedList = _bookedRepository.SelectInfo(cmbFilterBooked.Text, txtSearchBooked.Text);

            dataGridViewBooked.ClearSelection();
            dataGridViewBooked.DataSource = bookedList;
        }
示例#2
0
        public AddBookedForm()
        {
            // IP: Можливо було б доцільним винести IMemberRepository _memberRepository та IBookRepository _bookRepository з конкретних класів форм у спільний предок
            _bookedRepository = new SqlBookedRepository(ConfigurationManager.ConnectionStrings["dbLibrary"].ConnectionString);

            InitializeComponent();

            txtDateBooked.Text    = monthCalendarBooked.SelectionStart.ToString();
            txtDueDateBooked.Text = monthCalendarBooked.SelectionStart.ToString();
        }
示例#3
0
        public SetFineForm(Booked booked)
        {
            // IP: Можливо було б доцільним винести IMemberRepository _memberRepository та IBookRepository _bookRepository з конкретних класів форм у спільний предок
            _bookedRepository = new SqlBookedRepository(ConfigurationManager.ConnectionStrings["dbLibrary"].ConnectionString);
            _booked = booked;

            InitializeComponent();

            txtDateBooked.Text = _booked.dateBooked.ToString();
            txtDueDateBooked.Text = _booked.dueBooked.ToString();
            if (DateTime.Now > _booked.dueBooked)
            {
                txtDaysOverBooked.Text = (DateTime.Now - _booked.dueBooked).TotalDays.ToString();
            }
            else
            {
                txtDaysOverBooked.Text = "0";
            }
        }
 public BookedController(IBookedRepository bookedRepository)
 {
     this.bookedRepository = bookedRepository;
 }