// 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;
}
