private void textBoxManageSearch_TextChanged(object sender, EventArgs e)
{
string value = textBoxManageSearch.Text;
if (value != null)
{
DataTable dt = bookloanD.Search(value);
dataGridViewManageBookLoanDatabase.DataSource = dt;
}
else
{
refreshData();
}
}
private void dataGridViewUsers_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
//find the row index of the row clicked on user data grid view
int RowIndex = e.RowIndex;
textBoxUserID.Text = dataGridViewUsers.Rows[RowIndex].Cells[0].Value.ToString();
textBoxUsername.Text = dataGridViewUsers.Rows[RowIndex].Cells[1].Value.ToString();
textBoxFirstName.Text = dataGridViewUsers.Rows[RowIndex].Cells[2].Value.ToString();
textBoxLastName.Text = dataGridViewUsers.Rows[RowIndex].Cells[3].Value.ToString();
textBoxEmail.Text = dataGridViewUsers.Rows[RowIndex].Cells[4].Value.ToString();
textBoxAddress.Text = dataGridViewUsers.Rows[RowIndex].Cells[5].Value.ToString();
textBoxMobile.Text = dataGridViewUsers.Rows[RowIndex].Cells[6].Value.ToString();
switch (dataGridViewUsers.Rows[RowIndex].Cells[7].Value.ToString().Trim())
{
case "Male":
comboBoxGender.SelectedIndex = 0;
break;
case "Female":
comboBoxGender.SelectedIndex = 1;
break;
case "Other":
comboBoxGender.SelectedIndex = 2;
break;
}
dateTimePickerEnrolledDate.Value = DateTime.Parse(dataGridViewUsers.Rows[RowIndex].Cells[8].Value.ToString());
dateTimePickerExpiryDate.Value = DateTime.Parse(dataGridViewUsers.Rows[RowIndex].Cells[9].Value.ToString());
textBoxBooksBorrowed.Text = dataGridViewUsers.Rows[RowIndex].Cells[10].Value.ToString();
List <BookLoanModel> listBooks = bloanD.Search(int.Parse(textBoxUserID.Text));
/* dataGridViewBooksBorrowed.DataSource = dt;
*
*/
/* MessageBox.Show(listBooks[0].issued_book_name);
*/
var columns = from t in listBooks
orderby t.return_date
select new
{
BookName = t.issued_book_name,
Username = t.issued_user_name,
Issue_Date = t.issued_date,
Return_Date = t.return_date,
Days_left_DAY_HR_MIN_SEC = t.return_date - t.issued_date
};
dataGridViewBooksBorrowed.DataSource = columns.ToList();
}