/// Check login validation
public bool LoginValidation(string userName, string userPass)
{
string query = "SELECT username ,password FROM tbLogin where username = '******' and password = '******'";
StockManagementDatabase smdb_class = new StockManagementDatabase();
if (smdb_class.ExecuteSelectQuery(query).Rows.Count == 1)
{
return(true);
}
else
{
return(false);
}
}
public DataTable SelectProduct()
{
string query = "Select * from tbProduct";
return(smdb_class.ExecuteSelectQuery(query));
}