public static List <string> GetAutoCompleteData(string productCategoryName) { CommanFunctions cf = new CommanFunctions(); List <string> result = new List <string>(); cf.setQuery("select productCategoryID,productCategoryName from productcategory where productCategoryName LIKE '%" + productCategoryName + "%'"); DataTable dtD = cf.QueryEx(); if (dtD.Rows.Count > 0) { for (int i = 0; i < dtD.Rows.Count; i++) { result.Add(string.Format("{0}/{1}", dtD.Rows[i]["productCategoryName"].ToString(), dtD.Rows[i]["productCategoryID"].ToString())); } } else { cf.setQuery("select productID,productName from product where productName LIKE '%" + productCategoryName + "%'"); dtD = cf.QueryEx(); for (int i = 0; i < dtD.Rows.Count; i++) { result.Add(string.Format("{0}/{1}", dtD.Rows[i]["productName"].ToString(), dtD.Rows[i]["productID"].ToString())); } } return(result); }
protected void btnSignIn_Click(object sender, EventArgs e) { try { cf = new CommanFunctions(); cf.setQuery("select * from users where userName='******' and BINARY password ='******'"); dt = cf.QueryEx(); if (dt.Rows.Count > 0) { fail_div.Attributes.CssStyle.Add("display", "none"); Session["Login"] = true; Response.Redirect("/Default.aspx"); } else { //wrong credentials Session["Login"] = false; fail_div.Attributes.CssStyle.Add("display", "block"); lblfail.Attributes.CssStyle.Add("display", "block"); ScriptManager.RegisterStartupScript(this, this.GetType(), "showpanel", "autoHide();", true); } } catch (Exception EX) { lblfail.Text = "Exception! Contact [email protected]"; fail_div.Attributes.CssStyle.Add("display", "block"); lblfail.Attributes.CssStyle.Add("display", "block"); ScriptManager.RegisterStartupScript(this, this.GetType(), "showpanel", "autoHide();", true); } }
//Function to load categories protected void fillCategories() { try { string categories = ""; cf.setQuery("SELECT distinct productCategoryName, productCategoryID from productcategory order by productCategoryName"); dt = cf.QueryEx(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { categories = categories + "<button type='button' id='btn_" + dt.Rows[i]["productCategoryID"].ToString() + "' class='btn btn-block btn-outline-success btn-sm' onclick='return ans(" + dt.Rows[i]["productCategoryID"].ToString() + ");'>" + dt.Rows[i]["productCategoryName"].ToString() + "</button>"; } divCategory.InnerHtml = categories; } } catch { } }