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; }