private void Btn_search_mem_Click(object sender, EventArgs e)
{
if (txt_memse.Text == "")
{
MessageBox.Show("Empty Member Id", "Empty Field",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
Classes.Members mb = new Classes.Members();
DataTable dt = mb.searchmem(Convert.ToInt32(txt_memse.Text));
if (dt.Rows.Count == 0)
{
MessageBox.Show("No User with this Member Id", "No User",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
foreach (DataRow row in dt.Rows)
{
txt_memse.Text = row["mem_ID"].ToString();
f_namese.Text = row["memFirstName"].ToString();
l_namese.Text = row["memLastName"].ToString();
add_se.Text = row["memaddressLine1"].ToString();
city_se.Text = row["memaddressLine2"].ToString();
contact_se.Text = row["memcontactNumber"].ToString();
}
}
}
}
private void Btn_issueBook_Click(object sender, EventArgs e)
{
Classes.Members mem = new Classes.Members();
if (txt_memid.Text == "")
{
MessageBox.Show("User ID Is Empty", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else if (txt_bookid.Text == "")
{
MessageBox.Show("BOOK ID is Empty", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
int r = mem.borrw_book(Convert.ToInt32(txt_memid.Text), Convert.ToInt32(txt_bookid.Text),
Convert.ToString(today_datetime.Text), Convert.ToString(rtndate.Text));
if (r > 0)
{
MessageBox.Show("Borrow Book Successfull");
}
else if (r == -1)
{
//Do Nothing
}
else
{
MessageBox.Show("User ID or BOOK ID Incorrect", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
clean();
}
private void Cmb_book_DropDownClosed(object sender, EventArgs e)
{
Classes.Members mem = new Classes.Members();
if (Convert.ToString(cmb_book.SelectedValue) == "")
{
MessageBox.Show("NO Book Selected", "",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
DataTable data = mem.fill_book(Convert.ToInt32(txt_mem_se.Text), Convert.ToInt32(cmb_book.SelectedValue));
foreach (DataRow row in data.Rows)
{
txt_mem_se.Text = row["mem_id"].ToString();
rtn_dateDB.Text = row["ret_date"].ToString();
DateTime today = DateTime.Today;
DateTime rtndt = Convert.ToDateTime(row["ret_date"].ToString());
double difference = (today - rtndt).TotalDays;
if (difference > 0)
{
int finetot = 5 * Convert.ToInt32(difference);
fine.Text = Convert.ToString(finetot);
}
else
{
fine.Text = Convert.ToString(0);
}
}
}
}
private void Btn_search_mem_Click(object sender, EventArgs e)
{
if (txt_mem_se.Text == "")
{
MessageBox.Show("User ID Is Empty", "Error",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
Classes.Members mem = new Classes.Members();
DataTable dt = mem.findb_book(Convert.ToInt32(txt_mem_se.Text));
if (dt.Rows.Count == 0)
{
MessageBox.Show("No Books Borrowed Currently", "",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
cmb_book.DataSource = dt;
cmb_book.DisplayMember = "book_name";
cmb_book.ValueMember = "book_id";
}
clean();
}
}
private void Btn_delete_Click(object sender, EventArgs e)
{
if (txt_memse.Text == "")
{
MessageBox.Show("Empty Member Id", "Empty Field",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
Classes.Members mb = new Classes.Members();
int r = mb.delete_member(Convert.ToInt32(txt_memse.Text));
if (r != 0)
{
MessageBox.Show("Data Deleted");
}
else
{
MessageBox.Show("Error Deleting Data");
}
clean_edit();
}
}
private void Button2_Click(object sender, EventArgs e)
{
if ((txt_firstName.Text == "") || (txt_lastName.Text == "") || (txt_addLine1.Text == "") ||
(txt_addCity.Text == "") || (txt_contactNo.Text == ""))
{
MessageBox.Show("Some Required Fields Are Empty", "Empty Fields",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
Classes.Members mb = new Classes.Members();
int r = mb.addMember(txt_firstName.Text, txt_lastName.Text, txt_addLine1.Text,
txt_addCity.Text, txt_contactNo.Text);
if (r != 0)
{
MessageBox.Show("Data Saved");
}
else
{
MessageBox.Show("Data Not Saved");
}
clean();
}
}
private void Button4_Click(object sender, EventArgs e)
{
if ((f_namese.Text == "") || (l_namese.Text == "") || (add_se.Text == "") ||
(city_se.Text == "") || (contact_se.Text == "") || (txt_memse.Text == ""))
{
MessageBox.Show("Some Required Fields Are Empty", "Empty Fields",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
Classes.Members mb = new Classes.Members();
int r = mb.update_member(f_namese.Text, l_namese.Text, add_se.Text,
city_se.Text, contact_se.Text, Convert.ToInt32(txt_memse.Text));
if (r != 0)
{
MessageBox.Show("Data Updated");
}
else
{
MessageBox.Show("Error Updatig Data");
}
clean_edit();
}
}
private void Btn_acceptBook_Click(object sender, EventArgs e)
{
Classes.Members mem = new Classes.Members();
if (cmb_book.Text == "")
{
MessageBox.Show("NO Book Selected", "",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
int r = mem.ret_book(Convert.ToInt32(txt_mem_se.Text), Convert.ToInt32(cmb_book.SelectedValue), Convert.ToString(datertn.Text),
Convert.ToInt32(fine.Text));
if (r > 0)
{
MessageBox.Show("Succesfull");
}
else
{
MessageBox.Show("Unsuccssfull");
}
}
clean();
}
