Forms Data Controls :: How To Implement A Rating Mechanism Into Database Design
Mar 5, 2010
I have the attached database design.
The database has been designed for a tradesman web site, i.e. Plumbers, Builders etc. The two main tables are tblCustomer and tblTrader which will stored data from two frontend web pages where the customer and trader can enter their personal details. After a customer enters their personal details (i.e. registers through the site) they will then be directed to a child page where they can progress to entering a specific job attached to a specific trade (i.e. Plumber) and trade type (i.e. Bathroom Installation), once a customer job has been entered I want these details to be emailed to all the trader_email addresses from tblTrader, from this email alert the traders will then enter the system and offer quotes to the customer through tblTraderQuote where the customer will then accept the best quote for them.
What I also want to implement is some sort of rating option that will allow the customer to rate their trader, either something like ebay's feedback or just a simple 1-5 rating option? How can I implement this into my database design or is this something that should be performed within the programming layer?
View 3 Replies
Similar Messages:
Aug 18, 2015
Article [URL] .....
Above article show rating only integer part .
How can i show decimal rating on ajax rating control not any labels?
View 1 Replies
Dec 10, 2010
How to design login-logout mechanism in asp.net manually(no using standard control for login) by storing login id and password details in table but password must be in encrypted format in table for security !
View 9 Replies
Aug 25, 2010
i am using dot net open id for implementing openid in my website i want to redirect user to any of the open id provider site for sign up just like that of stack overflow provides for myopenid how to achieve this
View 1 Replies
Aug 18, 2010
I want to display records based on the Prod ID entered by the user in the text box. Where can I find a tutorial to do that?
I can't find a simple one. I am completely new to .NET, and hardly know anything about grid view, SQL connections and stuff.
I need a step-by-step tutorial that explains how to do it. I want to learn about all of this.
Oh, BTW, I did establish an SQL connection and was successful in displaying my table on the web page. I want to learn how to search from that table and display records.
View 1 Replies
Sep 20, 2015
In .aspx page:
<asp:DataList ID="dataList1" runat="server" RepeatLayout="Flow" RepeatDirection="Horizontal">
<ItemTemplate>
<div class="single-blog-post">
<h3><%# Eval("PName") %></h3>
<div class="post-meta">
[code]....
I want to set the ImageUrl property of IMAGE control in code.
View 1 Replies
Mar 6, 2011
I want to implement an app-wide error handling mechanism for an ASP.NET MVC2 web app. What is the standard way to do this?
I want to make sure that the user never sees a 404 error, a 500 error, or a core dump.
View 2 Replies
Feb 17, 2010
I'm trying to write a web app using 4-tier design pattern ( Data Store, DAL, BLL and UI).
Among other things this app would also implement a forum.
Suppose I want to move a thread from one forum to another. In order to do this, UI layer must pass down to other layers the ID of a thread and the ID of a forum to which I wish to move this thread ( UI would pass these parameters by calling method A in BLL layer and A would in turn call method B in DAL layer... ).
a) Now should one of the bottom layers provide some sort of checking mechanism to ensure that the two ID arguments supplied by UI layer really represent an existing thread and an existing forum or is it the responsibility of UI layer to provide valid ID values?
EDIT:
I would consider the ability to pass invalid IDs a bug.
Should non existing ID be considered a bug just in the case of moving a thread, or also in the case of displaying a thread. Thus when user navigates to page Showthread.aspx?ID={0}, if query string parameter ID references non existing ID, If none of the layers check for the validity of ID, then GridView simply won't display any
"But in this case it doesn't look like the ids are in any sort of list. If they were one could only assume that this would never happen as I assume the lists would be populated by a stored procedure or a DAL procedure that pulls all valid IDs."
But even if user chooses IDs from a set of list, by the time it posts the page back, the DB table containing this ID could be changed in the mean time by admin or whomever?!
View 5 Replies
Feb 20, 2011
I have a rating control that shows the average rating of a user supplied posting (think of a forum post that others will rate). So if the average rating for that posting is lets say 3 out of 5 all users will see 3 stars. If someone wants to rate the posting, then they could click lets say 4 stars and I save the rating to the database, re-average the current rating and display the result (which may or may not still be 3 at this point). So far so good. The problem comes in when a user wants to agree that it's 3 stars. Since the rating control currently shows 3 stars, choosing 3 again does not cause a postback. In my case even though the value didnt technically change, I need to capture the users choice so I can average it in and save that users rating. I also modify the UI so that I can show each user of the site what he/she choose as a rating.How can i get the control to let me know that a user choose a star rating even if its the same one the control is currently displaying?
View 3 Replies
Feb 7, 2014
I want to create a 5 star rating in which 5 stars will show. On mouse over, the color of star will change and it will show Bad, Average, Good, Very Good and Excellent. Near stars currently rated and number of raters will show. On mouse over, "currently rated" and "number of raters" will change into "Rate Now!". If you are rating first time then number of raters is increased by 1 and currently rated is calculated by Adding total ratings of raters divided by number of raters. After your rating the result is shown instantly. If you have already rated then in javascript the message will show that you have already rated this article. For checking that you have rated this article, there will be no login page. we can use cookies or other method to check that this user has alraedy rated this article or not. I want to create this 5 Star rating system using jQuery, ASP.Net, C# and SQL Server.How i will create this,
View 1 Replies
Feb 5, 2014
How to create 5 Star rating using jQuery and SqlServer.
View 1 Replies
Sep 17, 2010
While going through MSDN I found that in button properties useSubmitBeheviour there is written that if useSubmitBeheviour is true then it cause the Button control to use the browser's submit mechanism and false then the ASP.NET page framework adds client-side script to the page to post the form to the server.
View 2 Replies
Jan 8, 2011
Button.UseSubmitBehavior property is used to gets or sets a value indicating whether the Button control uses the client browser's submit mechanism or the ASP.NET postback mechanism.
So, What is the difference between client browser's submit mechanism and the ASP.NET postback mechanism?
View 2 Replies
Mar 28, 2011
I have an aspx page with detailsview whose datasource is an objectdatasource. I have a dropdownbox, showing categories, which act as a filter. If the user selects a different value in the dropdown box, the data obtained through the objectdatasource will be changed, and the new set of data will be displayed on the detailsview. This dropdownbox, is being used as the ControlParameter in the objectdatasource, so whenever a new item is selected the detialsview is updated accordingly. Now I want to add another filter in the form of a textbox, when the user could type in the title and hit a button, which should get a filtered set of data from the database.
View 1 Replies
Jul 23, 2010
On my page I have a list of items with ajax rating controls next to them. These controls I create dynamically from Page_load where I give the rating controls the rating of each corresponding item from the database. The problem is now that when the rating-event is fired I want to go to my event handler och add the new rating of the selected item into my database, but between my click and the event handler-method is fired the Page_load method is run, where all ratings is set from the database again, which means that the new rating I clicked on was restored and that the new rating I was supposed to update my database with will be the old rating already in the database. I create my ratings like this:
SqlDataReader r = cmd.ExecuteReader(); //calling a stored procedure
RadRating rating = new RadRating();
rating.Rate += new System.EventHandler(rating_Click);
rating.ID = r["id"].ToString();
rating.AutoPostBack = true;
rating.Value = Convert.ToDecimal(r["Overall_rating"].ToString());
In my event handler:
protected void rating_Click(object sender, EventArgs e){
RadRating rt = (RadRating) sender;
double myRate = Double.Parse(rt.Value.ToString());
updating database with myRate
}
From what I heard I need to recreate the dynamic controls i Page_load in order for them to persist throug postbacks, but when I do this the old rating writes over the new rating that I clicked on and need to use for database insertion. How can I solve this?
View 5 Replies
Feb 23, 2010
I am binding DataView data to GridView and using paging and sorting mechanism of the GridView.
In case of sorting, I define the sort expression based on user's selection and assign the same to DataView and then bind the same to GridView.
Issue:
Everytime I sort the DataView, I see different set of rows on the same page on GridView. The issue is, the column which is used in sorting has many rows with same values. So everytime I sort DataView using sort expression and bind it to GridView, it displays different sets of rows and sorts randomly.
What should I do to make sure that it always display same rows? I cant change the sorting expression as it is selected by the user. Or only way is to append sort expression containing unique key internally ?
I need the consistent set of rows as I am operating on rows selected by users and make them editable and allow user to udate values and display the same.
View 3 Replies
Oct 8, 2013
How to design and bind the grid view.
View 1 Replies
Jul 23, 2013
The user enter the name,address,country,qualifiction,experience the user enter more than one qualification, and experience the add another button click will add another qualification, and experience...i am confused in designing the database how to design the database for this . i am design this tables .
==employee table== ===Qualification== ==Experience===
employee_id qualificatin-id Experience_Id
employee_name University Company
employee_address Degree Year-of-0experience
employee_qualification End_Date employee-id
employee_Experience employee-id
View 1 Replies
Feb 9, 2010
anyone point me to a good/simple code to use for implementing a star rating system (5 star preferably) on my website. I am using asp.net 2.0 and C#.
View 1 Replies
Jan 29, 2011
I am now doing a project mobile musical website. I have used Ajax Toolkit in my last project and so that I know how to install it and work with it...
I have used CalenderExtender, TextboxWatermark, Password Strength, etc. But I am not familiar with the rating control. How does it work ?
View 1 Replies
May 7, 2010
I have a small table that has ratings for a album let's say.
Instead of showing the rating from 1-4 I want to show start instead
Rating 1 the 1 star
Rating 3 3 stars
Rating 0 no star
etc.
I have an tiny int field in the table and I will make a drop down list to allow 0-4
Currently I have a list view to show the list of comments and ratings but not sure how to convert the 0-4 from tiny int to a the same amount of stars
View 2 Replies
Mar 19, 2010
I am trying to convert 22 rating control currentrating values to a double instead of int
I am also displaying in a label control so it is converted to String here is what I have
[Code]....
My display label displays
Rating is x stars out of 5.0 stars
I also record the results in a decimal 1.1 form
I did Convert.ToDouble(rate1.CurrentRating) + Convert.ToDouble(rate2.CurrentRating) .....
but I get a 7 digit after 0 return, how do i round that to a single point?
View 1 Replies
Oct 11, 2013
I am using AJAX Rating Control.I want half star rating.For Example,If My AVG Rating Count is 3 Then My Stars Wants to be show 3If My AVG Rating Count is 2.5 Then My Stars Wants to be Show 2 1/2 mark i.e., two & half stars.But,it was not showing then also it is showing 3 stars.
View 1 Replies
Jan 20, 2010
how to call AJax rating control in Form view ?
I have 1 rating control in fromview in code behid page i wan to call Ajax rating contrl in formview for determine event and property .
View 1 Replies
Nov 22, 2015
Incrementing and decrementing a count table by button click, when a user clicks a button the count table will increment by 1 and when the same user clicks the button the second time it will decrement by 1...
View 1 Replies
