public DataTable Search(string Query)
{
try
{
return(c.RunSelect(Query));
}
catch
{
return(new DataTable());
}
}
public bool Login(string Email, string Password)
{
string Query = String.Format("Select * From Member Where EmailAddress='{0}' and Password='******'", Email, Password);
if (c.RunSelect(Query).Rows.Count == 1)
{
return(true);
}
else
{
return(false);
}
}
public int ProCount()
{
DataTable tbl = c.RunSelect("SELECT Count(*) FROM [Product]");
return(Convert.ToInt16(tbl.Rows[0][0].ToString()));
}
