protected void gvMemberRequest_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Select")
{
taBookHistory.Fill(ds1.BookHistory);
GridViewRow row = gvMemberRequest.Rows[Convert.ToInt32(e.CommandArgument)];
DataRow[] dRows = ds1.BookHistory.Select("MemberID=" + Convert.ToInt32(row.Cells[1].Text) + " AND DateReturned NOT IS NULL ");
if (dRows.Length <= 0)
{
taMember.Fill(ds1.Member);
DataRow[] dr = ds1.Member.Select("MemberID=" + Convert.ToInt32(row.Cells[1].Text));
dr[0].Delete();
taMember.Update(ds1.Member);
gvMemberRequest.DataBind();
}
else
{
this.PromptMessage("Cannot delete member with unsettled transactions.");
}
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
//CommandName is property to find which Commmand Field has been clicked by user
if (e.CommandName == "Select")
{
//ADD VALIDATION based on Issue Limit and Books available
bool allowBorrow = false;
// Select the row which is clicked by the user
GridViewRow row = GridView1.Rows[Convert.ToInt32(e.CommandArgument)];
txtMemberName.Text = row.Cells[3].Text;
txtPassword.Text = "xxxxxxxxxx";
txtPhone.Text = row.Cells[4].Text;
txtEmail.Text = row.Cells[5].Text;
updateID = Convert.ToInt16(row.Cells[2].Text);
this.btnSave.Text = "Update";
}
if (e.CommandName == "Delete")
{
GridViewRow row = GridView1.Rows[Convert.ToInt32(e.CommandArgument)];
taMember.Fill(ds1.Member);
DataRow[] dr = ds1.Member.Select("MemberID=" + row.Cells[2].Text);
dr[0].Delete();
taMember.Update(ds1.Member);
GridView1.DataBind();
}
}
