public List <EntClsSearch> queryForIsbnName() { List <EntClsSearch> resultList = new List <EntClsSearch>(); BsnClsSearch bsn_search = new BsnClsSearch(); resultList = bsn_search.ForIsbnBook(searchvalue); if (resultList.Count() == 0) { return(null); } return(resultList); }
public EntClsSearch queryForIsbnName() { EntClsSearch resultQuery = new EntClsSearch(); BsnClsSearch bsn_search = new BsnClsSearch(); resultQuery = bsn_search.ForIsbnBook(searchvalue); if (resultQuery.Book == null) { return(null); } return(resultQuery); }
public List <EntClsSearch> queryForNameEditorial() { char signo = '%'; List <EntClsSearch> resultList = new List <EntClsSearch>(); BsnClsSearch bsn_search = new BsnClsSearch(); string searchN = signo + searchvalue + signo; resultList = bsn_search.ForNameEditorial(searchN); if (resultList.Count() == 0) { return(null); } return(resultList); }
protected void Page_Load(object sender, EventArgs e) { if (Session["admin"] == null) { Response.Redirect("Login.aspx"); } searchvalue = Session["search"].ToString(); Response.Write(searchvalue); List <EntClsSearch> searchCategory = new List <EntClsSearch>(); BsnClsSearch bls_search = new BsnClsSearch(); searchCategory = bls_search.ForCategoryBook(searchvalue); loadGrid(searchCategory); }
public List <EntClsSearch> queryForAuthorCompleteName() { List <EntClsSearch> resultList = new List <EntClsSearch>(); string name; string lastName; BsnClsSearch bsn_search = new BsnClsSearch(); name = bsn_search.returnName(searchvalue); lastName = bsn_search.returnLastName(searchvalue); resultList = bsn_search.ForAuthorCompleteName(name, lastName); if (resultList.Count() == 0) { return(null); } return(resultList); }
protected void buttonRegister_Click(object sender, EventArgs e) { BsnClsBook bsn_Libro = new BsnClsBook(); EntClsBook bookFind = bsn_Libro.checkBook(textTitle.Text); if (bookFind.Code == null) { if (change1 == 1) { BsnClsAuthor bsn_author = new BsnClsAuthor(); bsn_author.insertAuthor(textNameAuth.Text, textLastName.Text, textNationality.Text); } if (change2 == 1) { BsnClsEditorial bsn_editorial = new BsnClsEditorial(); bsn_editorial.insertEditorial(textNameEdit.Text, textCountry.Text, textCity.Text); } EntClsSearch consulExist = new EntClsSearch(); BsnClsSearch bsn_search = new BsnClsSearch(); consulExist = bsn_search.ForCodeBook(textCode.Text); if (consulExist.Book == null) { //verificar que no se repita el isbn consulExist = bsn_search.ForIsbnBook(textIsbn.Text); if (consulExist.Book == null) { //verificar que no se repita el titulo consulExist = bsn_search.ForNameBook(textTitle.Text); if (consulExist.Book == null) { EntClsAuthor obj_Author = registerBook(); BsnClsWrite bsn_write = new BsnClsWrite(); bsn_write.insertWrite(obj_Author.Id, textCode.Text); registerSucces(); clear(); } else { string script = @"<script type='text/javascript'> alert('Ya existe este libro ingrese otro'); </script>"; ScriptManager.RegisterStartupScript(this, typeof(Page), "BookAdmin", script, false); } } else { string script = @"<script type='text/javascript'> alert('Ya existe ese ISBN ingrese otro'); </script>"; ScriptManager.RegisterStartupScript(this, typeof(Page), "BookAdmin", script, false); } } else { string script = @"<script type='text/javascript'> alert('Ya existe ese codigo ingrese otro'); </script>"; ScriptManager.RegisterStartupScript(this, typeof(Page), "BookAdmin", script, false); } } else { registerFail(); } }