private void btnSearch_Click(object sender, EventArgs e)
{
long memberID = 0;
int category = 0;
try
{
if (Memberobj != null)
{
memberID = Memberobj.MemberID;
}
string bookName = txtBookName.Text.Trim();
if (cboCategory.Text != "")
{
category = Convert.ToInt32(cboCategory.SelectedValue);
}
else
{
category = 0;
}
string startDate = dtpFromDate.Value.ToShortDateString();
string toDate = dtpToDate.Value.ToShortDateString();
dgvBookList.DataSource = Rent_DAO.getSearchRentBookHistory(bookName, memberID, category, startDate, toDate);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//Save Event
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtMemberCode.Text.Trim() == "" || txtDays.Text.Trim() == "" || dgvBookList.Rows.Count == 0)
{
MessageBox.Show("Please fill complete records", "Incomplete Records");
}
else
{
DetailBookDT = new DataTable();
DetailBookDT.Columns.Add("BookID");
for (int i = 0; i < dgvBookList.Rows.Count; i++)
{
if (dgvBookList.Rows[i].Cells[1].Value == null)
{
break;
}
DataRow dr = DetailBookDT.NewRow();
dr["BookID"] = dgvBookList.Rows[i].Cells[0].Value.ToString();
DetailBookDT.Rows.Add(dr);
}
if (btnSave.Text.Contains("Save"))
{
BookRent rentObj = new BookRent();
rentObj.MemberId = Memberobj.MemberID;
rentObj.StartDate = dtpFromDate.Value;
rentObj.IssueDate = dtpToDate.Value;
rentObj.NumberOfDay = Convert.ToInt32(txtDays.Text.Trim());
int l_return = Rent_DAO.SaveDAO(rentObj, DetailBookDT);
if (l_return > 0)
{
MessageBox.Show("Save Successfully", "Save");
Clear();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnRestore_Click(object sender, EventArgs e)
{
try
{
foreach (DataGridViewRow row in dgvBookList.Rows)
{
if (Convert.ToBoolean(row.Cells[ChkSelect.Name].Value) == true)
{
int Id = Convert.ToInt32(row.Cells[1].Value);
Rent_DAO.RestoreRentBook(Id);
}
}
MessageBox.Show("Update Successfully");
btnSearch_Click(sender, e);
}catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
