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