private void borrowBtn_Click(object sender, EventArgs e)
{
LibraryDataContext dbContext = new LibraryDataContext();
String borrowStr = borrowTxt.Text;
Book book = null;
if (borrowCombo.SelectedItem.ToString().Equals("Name"))
{
book = dbContext.Books.SingleOrDefault(x => x.B_NAME == borrowStr);
}
else if (borrowCombo.SelectedItem.ToString().Equals("Book ID"))
{
book = dbContext.Books.SingleOrDefault(x => x.B_ID == borrowStr);
}
Borrow borrow = new Borrow();
borrow.ID = ID;
borrow.B_ID = book.B_ID;
borrow.B_NAME = book.B_NAME;
borrow.TOPIC = book.TOPIC;
dbContext.Borrows.InsertOnSubmit(borrow);
dbContext.SubmitChanges();
MessageBox.Show("Book borrowed!");
table.DataSource = dbContext.Books;
}
private void button1_Click(object sender, EventArgs e)
{
LibraryDataContext dbContext = new LibraryDataContext();
var result = dbContext.Borrows.Where(x => x.ID == ID);
table.DataSource = result;
}
public AdminForm()
{
InitializeComponent();
LibraryDataContext dbContext = new LibraryDataContext();
table.DataSource = dbContext.Books;
}
public AdminForm(bool loggedIn, String ID)
{
InitializeComponent();
this.loggedIn = loggedIn;
this.ID = ID;
this.adminIDTxt.Text = ID;
LibraryDataContext dbContext = new LibraryDataContext();
table.DataSource = dbContext.Books;
}
private void removeBtn_Click(object sender, EventArgs e)
{
String bookID = bookIDTxt.Text;
LibraryDataContext dbContext = new LibraryDataContext();
Book book = dbContext.Books.SingleOrDefault(x => x.B_ID == bookID);
dbContext.Books.DeleteOnSubmit(book);
dbContext.SubmitChanges();
MessageBox.Show("Book Removed!");
table.DataSource = dbContext.Books;
}
private void updateBtn_Click(object sender, EventArgs e)
{
String bookID = bookIDTxt.Text;
LibraryDataContext dbContext = new LibraryDataContext();
Book book = dbContext.Books.SingleOrDefault(x => x.B_ID == bookID);
book.B_NAME = bookNameTxt.Text;
book.TOPIC = bookTopicTxt.Text;
book.T_QTY = Int32.Parse(tQtyTxt.Text);
book.A_QTY = Int32.Parse(aQtyTxt.Text);
dbContext.SubmitChanges();
MessageBox.Show("Information Updated!");
table.DataSource = dbContext.Books;
}
private void addBtn_Click(object sender, EventArgs e)
{
LibraryDataContext dbContext = new LibraryDataContext();
Book book = new Book();
book.B_ID = bookIDTxt.Text;
book.B_NAME = bookNameTxt.Text;
book.TOPIC = bookTopicTxt.Text;
book.T_QTY = Int32.Parse(tQtyTxt.Text);
book.A_QTY = Int32.Parse(aQtyTxt.Text);
dbContext.Books.InsertOnSubmit(book);
dbContext.SubmitChanges();
MessageBox.Show("Book Added!");
table.DataSource = dbContext.Books;
}
private void registerBtn_Click(object sender, EventArgs e)
{
Credential cred = new Credential();
cred.ID = idTxt.Text;
String p1 = passTxt.Text;
String p2 = passReTxt.Text;
if (!p1.Equals(p2))
{
MessageBox.Show("Password do not match!");
return;
}
cred.PASS = passTxt.Text;
cred.ROLE = "STUDENT";
LibraryDataContext dbContext = new LibraryDataContext();
dbContext.Credentials.InsertOnSubmit(cred);
dbContext.SubmitChanges();
MessageBox.Show("Registration Successful!");
}
private void searchBtn_Click(object sender, EventArgs e)
{
LibraryDataContext dbContext = new LibraryDataContext();
String searchStr = searchTxt.Text;
if (searchCombo.SelectedItem.ToString().Equals("Topic"))
{
var result = dbContext.Books.Where(x => x.TOPIC == searchStr);
table.DataSource = result;
}
else if (searchCombo.SelectedItem.ToString().Equals("Name"))
{
var result = dbContext.Books.Where(x => x.B_NAME == searchStr);
table.DataSource = result;
}
else if (searchCombo.SelectedItem.ToString().Equals("Book ID"))
{
var result = dbContext.Books.Where(x => x.B_ID == searchStr);
table.DataSource = result;
}
}
private void loginBtn_Click(object sender, EventArgs e)
{
String inpID = null, inpPass = null;
inpID = loginIDTxt.Text;
inpPass = loginPassTxt.Text;
LibraryDataContext dbContext = new LibraryDataContext();
Credential cred = null;
try
{
cred = dbContext.Credentials.SingleOrDefault(x => x.ID == inpID);
}
catch (Exception)
{
MessageBox.Show("Invalid Input!");
}
String role = cred.ROLE;
if (cred.PASS.Equals(inpPass))
{
if (role.Equals("STUDENT"))
{
this.Visible = false;
new StudentForm(true, inpID).ShowDialog();
}
else if (role.Equals("ADMIN"))
{
this.Visible = false;
new AdminForm(true, inpID).ShowDialog();
}
}
else
{
MessageBox.Show("Wrong Input!");
}
}