protected void btnreturnbook_Click(object sender, EventArgs e)
{
if (lblpanalty.Text == "Yes")
{
lblbook.Text = "Please, Pays first Panalty";
lblbook.ForeColor = System.Drawing.Color.Red;
PDT = PAdapter.Select_by_SID_Bookname(Convert.ToInt32(drppublication.SelectedValue), lblbname.Text);
if (PDT.Rows.Count == 0)
{
PAdapter.Insert(Convert.ToInt32(drppublication.SelectedValue), lblbname.Text, Convert.ToDouble(lblprice.Text), 0, "");
}
else
{
for (int i = 0; i < PDT.Rows.Count; i++)
{
if (PDT.Rows[i]["panalty"].ToString() != "0")
{
PAdapter.Insert(Convert.ToInt32(drppublication.SelectedValue), lblbname.Text, Convert.ToDouble(lblprice.Text), 0, "");
break;
}
}
}
}
else
{
RAdapter.RENT_SELECT_RETURN(Convert.ToInt32(ViewState["RRID"].ToString()), 1, Convert.ToInt32(ViewState["BBID"].ToString()));
lblbook.Text = "Book Returd Successfully";
lblbook.ForeColor = System.Drawing.Color.Green;
}
}
protected void drpstudent_SelectedIndexChanged(object sender, EventArgs e)
{
PDT = PAdapter.Select_by_SID_Panalty_0(Convert.ToInt32(drpstudent.SelectedValue));
drpbook.DataSource = PDT;
drpbook.DataTextField = "bookname";
drpbook.DataValueField = "pid";
drpbook.DataBind();
drpbook.Items.Insert(0, "SELECT");
}
protected void Page_Load(object sender, EventArgs e)
{
PDT = PAdapter.Select_By_SID(Convert.ToInt32(Session["sid"].ToString()));
GridView3.DataSource = PDT;
GridView3.DataBind();
}
