protected void btnSearch_Click(object sender, EventArgs e)
{
int state = Convert.ToInt32(textticket.Text);
ent_loan = bsn_loan.searchLoan(state);
if (ent_loan.StateL == "Finalizado")
{
string script = @"<script type='text/javascript'>
alert('Ya se devolvio el libro anteriormente');
</script>";
ScriptManager.RegisterStartupScript(this, typeof(Page), "BookAdmin", script, false);
btnReturnBook.Enabled = false;
}
else
{
int search = Convert.ToInt32(textticket.Text);
ent_returnBook = bsn_returnBook.ReturnBook(search);
if (ent_returnBook.Code == null)
{
errorMessage();
}
else
{
showReturnBook(ent_returnBook);
btnReturnBook.Enabled = true;
}
}
}
public EntClsReturnBook ReturnBook(int id)
{
EntClsReturnBook objReturn = new EntClsReturnBook();
string storeProcedure = "ReturnBook";
using (DbConnection con = dpf.CreateConnection())
{
con.ConnectionString = constr;
using (DbCommand cmd = dpf.CreateCommand())
{
cmd.Connection = con;
cmd.CommandText = storeProcedure;
cmd.CommandType = CommandType.StoredProcedure;
DbParameter param = cmd.CreateParameter();
param.DbType = DbType.Int32;
param.ParameterName = "id";
param.Value = id;
cmd.Parameters.Add(param);
con.Open();
using (DbDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
objReturn = new EntClsReturnBook((int)dr["id"], (string)dr["identificationCard"], (string)dr["name"], (string)dr["lastName"], (string)dr["nameBook"], (string)dr["code"]);
}
}
}
}
return(objReturn);
}
protected void showReturnBook(EntClsReturnBook ReturnBook)
{
textIdentificationCard.Text = ent_returnBook.IdentificationCard;
textName.Text = ent_returnBook.Name;
textLastname.Text = ent_returnBook.LastName;
textNameBook.Text = ent_returnBook.NameBook;
textCode.Text = ent_returnBook.Code;
}
