コード例 #1
0
ファイル: Form1.cs プロジェクト: JBeni/TSP.NET
        private void InsertReview_Click(object sender, EventArgs e)
        {
            var book   = new BookRepository();
            var reader = new ReaderRepository();
            var review = new ReviewRepository();
            var loan   = new LoanRepository();

            var queryCarteId = book.GetBookIdByTitle(boxTitluCarteInsertReview.Text.Trim());

            if (queryCarteId.LongCount() > 0)
            {
                int idCarte = queryCarteId[0].CarteId;

                var queryDateCarteImprumutata = loan.GetLoanIdByBookId(idCarte);
                queryDateCarteImprumutata[0].DataRestituire = DateTime.Now;
                loan.UpdateLoan(queryDateCarteImprumutata[0]);

                var queryDateImprumut    = loan.GetLoanIdByBookId(idCarte);
                var queryCititorImprumut = loan.GetLoanIdByBookId(idCarte);

                if (queryDateImprumut[0].DataRestituire > queryDateImprumut[0].DataScadenta)
                {
                    var queryStareCititor = reader.GetReaderById(queryCititorImprumut[0].CititorId);
                    queryStareCititor[0].Stare = 1;
                    reader.UpdateReader(queryStareCititor[0]);
                }

                REVIEW rev = new REVIEW()
                {
                    Text       = boxTextReviewInsertReview.Text.Trim(),
                    ImprumutId = queryDateImprumut[0].ImprumutId,
                };

                review.InsertReview(rev);
                MessageBox((IntPtr)0, "\nInsert Operation Completed", "Message Box", 0);
            }
            else
            {
                MessageBox((IntPtr)0, "\nCartea nu exista/este imprumutata", "Message Box", 0);
            }

            boxTitluCarteInsertReview.Text = "";
            boxTextReviewInsertReview.Text = "";
        }