Security :: Using Membership To Filter Query Results / View/ Reports?
Nov 16, 2010
I am developing this website which requires multiple groups of roles inside membership. Here is an example:
I want to create a group of states (would be the first group of roles):
* Oregon
* California
* Kansas
* Texas
* Ohio
Then I want to use the membership provider to filter the query results. Example:
* Patrick is an website admin and he can view all states from the query results
* Laura is from Kansas, so she can view only Kansas results from the query (reports, submission form only to Kansas, and so on..
i have a "Users today" function that i am trying to work on, i have all the tables set up, and a TimeStamp column, i would like to know how i could get all the users that appeared, but for that day only.
So i used the select statement, but then when i tried to add into query, filtering, i tried using the DateTime.Now, but it only got the users specific to that date, hour, and second.
I have master page, menu on master page, i use asp roles and trim menu item based on user roles and rights this process is working fine.
Now i have to create some reports based on user roles, and responsibility in a company like country head will view country wide reports, manager region will only view regional report and rest will view reports related to them.
How can i achieve this efficiently using asp roles.
i currently develop an asp.net mvc 2 web app using asp.net membership and role management for authenticating and authorizing my users. I get complaints though that when adding a role to some user, he is not able to see new role assigned functionality, unless he re-enters (logout and login again) the application.
I have a list of about 20 products, each with up to 30 possible attributes. I'm trying to figure out the best way to use checkboxes (representing the 30 possible attributes) on a form to filter the products, so that only products with the matching attributes would be shown. I can use SQL Server 2005, but it seems like that might be overkill.
(Additional) Edit: Ok, given the data structure below, how would you query the database to return products that have ALL of the matching features? Say Product #1 has features 1, 2 and 3. Product # 2 has features 2, 3 and 4. A query for features 1 and 3 should return Product #1, but not Product #2.
Products table productID int productname nvarchar(50) Features table featureID int featurename nvarchar(50) FeatureMap table featuremapID int productID_fk int featureID_fk int
I have a page which is used to filter through a list of jobs. The form is built dynamically with values available in a database (ex. education level, element, full/part time, etc). I have checkboxes and radio buttons.
On submit, I am able to pass the FormCollection, loop through all that, generate my parameters, pass them on to my stored procedure, and return the resulting job list. The problem is that when the page reloads with the results, the filters are reset. How would I make sure that the search parameters (filters), are kept ? How would I re-select the fields in my form ?
I have a task in which i have to compare 2 access databases
and in these 2 databases, there is a field "Customer_Name" Let's name both databases as DatabaseA and DatabaseB
In DatabaseA there is a list of Customer_Name that includes all the customers
Now I have to match this CustomerList with "Customer_Name" field present in DatabaseB
If Customer Name of DatabaseA is present in Customer Name of DatabaseB then leave it as it is
If Customer Name of DatabaseA is not present in Customer Neme of DatabaseB then rename the name of that customer as "NA" in DatabaseA'S Customer Name field
So i have to perform these 2 above mentioned things, is it possible to do it in asp.net coding ? just with a press of button (in button click even) to save time as the list of customers includes 3000 customers approx
I'm using Visual Studio 2010 with .net Framework 3.5. I have a couple of textboxes: First Name, Last Name. As the user begins entering values in those textboxes I'd like the Listview to display the results querying from a database and filter those results as more letters are typed in.
I'm trying to create a HttpModule that changes the Response.Filter like so(for this demonstration just set the filter back to itself):
public class ContentTrafficMonitor : IHttpModule { public void Init( HttpApplication context ) { context.BeginRequest += OnBeginRequest;[code]....
Doing so sets the transfer encoding of the response to chunked, rather than using the Content-Length header.If I remove the line where the Response.Filter is set, the response does have the Content-Length header. Our application depends on the Content-Length header, is there any way to prevent this behavior?
I have enabled User Rolls and assigned several Roll names such as 10, 11, 12, etc. I have a SQL Table that contains various fields of information including one named AuthorizedUserRoll, it's nchar(2).
A logged in user should only see the records in Gridview that matches his/her roll.
My question is how can I filter the content of crystal report using dropdownlist, just like for example I have a dropdownlist and that dropdownlist is consist of YEAR...
 protected void btn_showReport_Click(object sender, EventArgs e) { //ReportViewer1.Visible is set to false in design mode ReportViewer1.Visible = true;
[Code].....
Parameter 'Comp_Name' does not exist on this report
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentException: Parameter 'Comp_Name' does not exist on this reportSource Error:
Line 96:Â Â Â Â Â Â Â Â Â Â Â Â ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://dell-pc/ReportServer");Line 97:Â Â Â Â Â Â Â Â Â Â Â Â ReportViewer1.ServerReport.ReportPath = "/test Report/test1";Line 98:Â Â Â Â Â Â Â Â Â Â Â Â ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { Comp_Name });Line 99:Â Â Â Â Â Â Â Â Â Â Â Â ReportViewer1.ServerReport.Refresh();Line 100:Â Â Â Â Â Â Â }
I need to filter LINQ query using comboboxes and textboxes. The problem is I can't manage to get the result and I always get the empty gridview (used for showing filtered data). Can anyone help me why am I getting no results at all? I've checked the debugger and the data sent to query is valid, although, I'm not sure about "string.Empty" value.
The SQL is below - each result is coming up 3 times rather than just once.
SELECT Consignments.LegacyID, TripDate, CollectionName, DeliveryName, Pallets, Weight, BaseRate, Consignments.FuelSurcharge, AdditionalCharges, BaseRate * Quantity AS 'InvoiceValue', Consignments.Customer, InvoiceNumber, CASE WHEN child.LegacyID = Consignments.Customer THEN child.LegacyID WHEN parent.LegacyID = Consignments.Customer THEN parent.LegacyID ELSE this.LegacyID END AS 'InvoiceAcc' FROM SageAccount this LEFT JOIN SageAccount parent on parent.LegacyID = this.InvoiceAccount LEFT JOIN SageAccount child on this.LegacyID = child.InvoiceAccount JOIN Consignments on (Consignments.Customer = this.LegacyID AND this.Customer = 'True') OR (Consignments.Customer = parent.LegacyID AND parent.Customer = 'True') OR (Consignments.Customer = child.LegacyID AND child.Customer = 'True') WHERE (this.LegacyID = @Customer) AND (TripDate BETWEEN @fromdate AND @todate) AND (InvoiceNumber IS NOT NULL)
The SQL was given to me for another similar query, but this time I have modified it to try to use it for the query I'm doing now, so I'm assuming that I'm doing something stupid.
I have a query using LINQ-to-SQL. It queries an underlying database table Rooms. It uses Where conditions to narrow down the results, namely:
Gender. Current Occupancy < Max Occupancy Available Flag is Checked
I know this should return results but it keeps returning an empty set. Any ideas? Code is below
Dim selectedHalls = (From sh In dbHalls.Rooms _ Where sh.gender = Session("gender").ToString _ Where sh.max_occupancy > sh.current_occupancy _ Where sh.is_available = 1 _ Select sh.building_name).Distinct()
UPDATE: I've verified that the issue is with the statement where sh.is_available = 1, which doesn't make sense since this is a bit field.
I've managed to use my MS Access database with repeaters and gridviews in my website. Basically, printing the result of a query directly to the website seems easy enough using something like this :
[Code]....
After quite a bit of googling this seems to be a common way to do this. My question then seems kinda silly.
I want to use some of the data from the query in for example a variable without sending the data to a repeater or gridview and so on. Say I just want the username and a password from a database and want to store the username in one variable and the password in another for further use in the code. What do I do?
I can't seem to change the order of the results coming back from a linq to sql query, I want just to return the distinct values from the field x.manufacturer in alphabetical order, this is what I have and it isn't working:
public IQueryable<string> Dropone() { return (from x in CAT.CatalogueDatas where x.Parent == null orderby x.Manufacturer select x.Manufacturer).Distinct(); }
Currently I get the distinct values in non-alphabetical order, in fact I'm not sure what order they're coming out in, don't think it's the order in which they appear though.
i query a database for retreiving all the columns. I will probably have many rows. Im trying to output the query results into an html table. This is what i have so far:
[code]....
How could i store the many rows and output them using html as soon as i open a page?
I have an asp.net intranet site hosted on IIS on my computer.
On one page you can enter two user id's and get a side by side comparison of their roles in our (custom app) system.
I often use it to add roles when I'm setting up new users. After running the query, if i change a role and run the query again it will not show updated results. It's being cached somehow. I have to go to another page and come back and them run the query to get updated results.
How can avoid having to navigate away to get the updated query results displayed.n
A field in my table can have arbitrary strings. On the UI, there is a drop down having options like
All, Value1, Value2
And the results were filtered by the selected option value. So far this is easy and adding new filters to the UI is not a problem. Needs no changes in my stored procedure. Now I want to have an "Others" option here as well, which will return rows not having the column value as Value1 or Value2.
Apparently this will require a "not in" operator in my query, and will make maintenance difficult, as the list of values is likely to change
I want to display sql query results in my web application (asp.net webpage) dynamically at the run time. But I don't know how to do that. Is there any control to do that? Or is there any code? Could you give some examples?
I then check whether one of the result values is more recent than six months ago using an if..then like so:
If rhcexists.First.SignatureDate > Date.Today.AddMonths(-6) Then End If
However, if there are no results returned this will return an error. Is there a way for me to tell it to act as if the date is older than six months if there is no value at all? e.g., could I in pseudo do something like:
If Exists(rhcexists.First.SignatureDate, Date.Today.AddMonths(-8)) > Date.Today.AddMonths(-6) Then End If
