// search books for borrowing private void btnSrc_Click(object sender, EventArgs e) { try { // btnSelectBook.Enabled = true; dataDataContext src = new dataDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in src.Tables where a.bookId == searchTF.Text select a; BookIdTF.Text = x.FirstOrDefault().bookId; bookNameTF.Text = x.FirstOrDefault().bookName; authorNameTF.Text = x.FirstOrDefault().authorName; bookTypeTF.Text = x.FirstOrDefault().bookType; bookCopyTF.Text = x.FirstOrDefault().bookCopy; // priceTF.Text = x.FirstOrDefault().price; dataGridView1.DataSource = x.ToList(); } catch (Exception) { MessageBox.Show("Not Found"); } }
private void btnLogIn_Click(object sender, EventArgs e) { try { dataDataContext log = new dataDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=H:\C#\calc\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in log.userDatas where a.id == userIdTF.Text && a.password == passTF.Text select a; // get values from database userId = x.FirstOrDefault().id; password = x.FirstOrDefault().password; Address = x.FirstOrDefault().address; userName = x.FirstOrDefault().name_; mobileNumebr = x.FirstOrDefault().phoneNumber; string userIdText = userIdTF.Text; string passwordtext = passTF.Text; // userId == userIdText || password == passwordtext if (cbSearch.Text == "user") { if (x.Any()) { UserDashboard user = new UserDashboard(userName, userId, password, Address, mobileNumebr); this.Hide(); user.Show(); // MessageBox.Show("User id:"+userId+"\nPassword :"******"wrong password"); } } else if (cbSearch.Text == "admin") { } } catch (Exception) { MessageBox.Show("Wrong password and user id "); } }
// insert data of borrower for admin to monitor the borrowe return the book or not private void InsertBorrowerInfoToDatabase() { borrowD = borrowDate.Value.ToString("dd-mm-yyyy"); returnD = returnDate.Value.ToString("dd-mm-yyyy"); dataDataContext borrowBook = new dataDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); Borrow borrowInfo = new Borrow { name = getNameLbl.Text, userId = getUserIdLbl.Text, bookId = BookIdTF.Text, borrowDate = borrowD, returnDate = returnD, totalDays = dateDiffTF.Text }; //borrowInfo.BookBorrowInfos.InsertOnSubmit(); borrowBook.Borrows.InsertOnSubmit(borrowInfo); borrowBook.SubmitChanges(); }
private void btnSend_Click(object sender, EventArgs e) { try { if (ReportTF.Text != "") { dataDataContext dc = new dataDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); Review r = new Review(); r.Id = Convert.ToInt32(userTF.Text); r.Rev = ReportTF.Text; dc.Reviews.InsertOnSubmit(r); dc.SubmitChanges(); ReportTF.Enabled = false; //userTF.Text = userId; //string getMessage = ReportTF.Text; userTF.Text = ""; ReportTF.Text = ""; //getMess.Text = getMessage; btnSend.Enabled = false; MessageBox.Show("Message sent successfully"); } else { MessageBox.Show("Message sent failed"); } } catch (Exception) { MessageBox.Show("You are already give your review "); } }
//confirm button private void btnConfirm_Click(object sender, EventArgs e) { count++; try { int totalBook = int.Parse(bookCopyTF.Text); int totalCopy = 0; totalCopy = totalBook; if (totalCopy <= 0) { MessageBox.Show("Book is not avaliable"); } else { //update bookCopyTF.Text = totalCopy.ToString(); dataDataContext update = new dataDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); var x = from a in update.Tables where a.bookId == BookIdTF.Text select a; x.First().bookId = BookIdTF.Text; x.First().bookName = bookNameTF.Text; x.First().authorName = authorNameTF.Text; x.First().bookType = bookTypeTF.Text; x.First().bookCopy = bookCopyTF.Text; update.SubmitChanges(); dataGridView1.DataSource = x.ToList(); int days = int.Parse(dateDiffTF.Text); //days = days +1; dateDiffTF.Text = days.ToString(); if (day > 7 || day <= 0) {//|| count == 2 || userName == getNameLbl.Text totalCopy = totalCopy - 1; MessageBox.Show("sorry ... order can't be processed"); } else { if (searchTF.Text == "" || BookIdTF.Text == "" || bookNameTF.Text == "" || bookTypeTF.Text == "" || bookCopyTF.Text == "") { MessageBox.Show(" Sorry your request is Not confirmed yet :)"); } else { if (count == 1) { MessageBox.Show("Welcome sir you borrowed this book for " + dateDiffTF.Text + " days"); InsertBorrowerInfoToDatabase(); } else if (count > 2) { MessageBox.Show(" Sorry your request is Not confirmed yet :)"); } } } } } catch (Exception) { if (searchTF.Text == "" || BookIdTF.Text == "" || bookNameTF.Text == "" || bookTypeTF.Text == "" || bookCopyTF.Text == "") { MessageBox.Show(" Sorry your request is Not confirmed yet :)"); } /*else if (count == 2 && userName == getNameLbl.Text) * { * MessageBox.Show("you can't select one more book"); * * }*/ } //if (day > 7 || day <= 0) //{ // MessageBox.Show("sorry ... order can't be processed"); //} //else //{ // MessageBox.Show("Welcome sir you borrowed this book for " + dateDiffTF.Text + " days"); // InsertBorrowerInfoToDatabase(); //} }
//load the data public void dataGridView() { dataDataContext grid = new dataDataContext(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=F:\C# project\LibraryManagementSystem\Library management software(final)\Library management software\Library management software\datatable.mdf;Integrated Security=True;Connect Timeout=30"); dataGridView1.DataSource = grid.Tables; }