Stock Management When Payment Of Customer Failed Using SQL Server?
Mar 20, 2010
I am currently building a webshop for my own where I want to increment the product-stock when the user fails to complete payment within 10 minutes after the customer placed the order. I want to gather information from this thread to make a design decision. I am using SQL Server 2008 and ASP.NET 3.5. Should I use a SQL Server Job who intervals check the orders which are not payed yet or are there better solutions to do this.
I am building an ecommerce site and I struggle to find a way to check the stock levels for each order.I have created an "in house" procedure that involves the administrator having to push a "check stock" button for each item on the order but it doesn'tlook too elegant.
I am building an ecommerce site and I struggle to find a way to check the stock levels for each order. I have created an "in house" procedure that involves the administrator having to push a "check stock" button for each item on the order but it doesn't look too elegant.
I sucessfully installed SQL Server Express 2010 on my windows server. I then tried to install the SQL Server 2008 management studio via Web Platform Installer but it failed (it did however sucessfully install powershell).
i want to design a stock financial report system and fortunately i hooked in the database design part. The report is made up of different sector and under the sectors thier are companies. All sectors have some unique entry fields which makes it different from the other. for example banking sector is different from insurance sector because there are entries that differ. My problem is how to create a non-redundant database that features all the sectors and companies. the idea i thought is to make a table for every sector and i found out that with these idea i wil have some relational issues for example in each sector i will have company id as primary so in establsiing relation i will hav constraint.
how to design a non-redundant databse with respect to these subject.
We need to integrate creditcard/paypal payment process using paypal gateway in our asp.net web application.The process goes like this:User picks item in our Web site User fills out order info and goes to our payment option page User selects PayPal as payment User gets PayPal payment process in our site (without payment gatway redirection)nally we need to confirm to PayPal that we want to process this order and PayPal confirms to us that the order went through.
have developed a payment processing form where user fills the payment details and submit the button "Pay Now" what i want is to block the entire UI with the message "Processing Payment..." and with a slight delay right after payment processing stored procedure executes (in code behind) it should UNBLOCK the UI. Actually i was having multiple postbacks from user due to the slight delay ...I dont want to disable button. how to achieve this.
Now i have a database table holds all info of my (customers) such as first last names and address phone number etc ... and i able to edit delete update their info from my side using the admin page that contians gridview i created. If several customers logged into their account pages, and each one wants to update his information,
How can i let the specific customer info be showin on his page for each customer? (I have one databse table and it contains a primery key column called "MemberID") how can i make the new subscribed user get his info that he did input or i would like to add to it, showin on his account page?
I'm not really sure where to start with this and therefore can't pick a more specific area to post. At first I though this might be something I would do in IIS7 but on reflection i think it needs to be at the application level. I am developing an application which will as part of it's function provide a unique website (custom CMS) to my customers. Each person who registers will have their own site accessible via a url such as [URL]. I need someway to take this and work out which customer it is and then load the rest of the pages with their content. So the site may have a home, about us and news pages for example and be themed to the customers requirements. Each of the pages will be the same aspx file and application for all customers but the content and style will be loaded from the database at runtime. I'd like for the duration of the visit for everything to appear as if from this subdirectory without actually creating them for each customer. so thy could visit [URL] but it actually loads [URL] and loads the content based on the customer site the visit is viewing.
I'm not really sure how to approach this. Maybe using a session value to store the customerid for the site the person is viewing which could be calculated from the URL on the first visit. I presume other people have done something simialr in the past. Where it gets more complex is if I then want to offer customers to have there own domain name pointed to the site. In that scenario they would have say [URL] which points to my server and bound to my application [URL]. All pages would have look as though they were on the customer website such as [URL] but still point to [URL] in the background and also somehow link to the customerid in the database to load the correct content.
so a given Customer can have many orders in this table however I only want to return the last order (using OrderDate) for each customer. how do you do this? I assume that I need to group by customerID and then use max on the OrderDate but not sure of the exact syntax.
I have developed a desktop program for a customer.I have used SQL Server on my ofiice while i am developing.Now its time to install the program my customer's office,Which SQL edition i should use? (At least)Only usage for them about SQL is: Backup and storing datas.
next week i'll have to install the ASP.NET Website on a customer server on site. All server side requirements for hosting a ASP.NET website are met.
So how do i now create a installation / setup for the website to make sure that everything runs fine? I think it's important to mention, that i'm using 3rd party compos (DevExpress).
For example where i have to install (path) the site?
I have data for the payment system: - Credit card number (Visa, Mastercard, etc ...) - Paypal - Moneybookers - NETeller - Etc ...
how to set the table and columns.
Current proposal: Column AttributeName, in which I have text (credit card number, name on credit, email, etc ...) Column Value, in which I have data about a particular attribute.
I wish that all data is stored in one table.I do not wish for any payment system, use the new table, as for example:
Just looking through database design and wondering what would be the better option. I have customers, who all have orders, pickings, deliveries and invoices. Now an invoice can't exist without a delivery, a delivery can't exist without a picking and a picking can't exist without an order. So I could set the tables up in a linear fashion. e.g.
then in Orders, there would be an ID field, with a customerID field and in Picking, there would be an ID field, with an orderID field and in Delivery, there would be an ID field, with pickingID and in Invoice, there would be an deliveryID field. Linking them altogether, again, in a 'linear' fashion.
The problem is if I want to get, say, all the invoices for a specific customer, my query would be something like
[Code]....
My other option would be to have in a customerID column in each of the tables meaning a much easier query
comes with another calculation query.In this one I like to get the total amount for the customer in the OrderDetail table. I can't figure out how to do it. And I only want to receive one row. With this SP I get all rows in the orderDetail table.
In our control environment, we've started, somewhat intermittently, getting:
Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.
on our website.It also suggests:
Source Error: The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:
1. Add a "Debug=true" directive at the top of the file that generated the error. Example:
<%@ Page Language="C#" Debug="true" %> or:
2) Add the following section to the configuration file of your application:
Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.
Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.
We already have compilation debug as true. We have upgraded our website to ASP.NET 4.0, although our middle tier components are still at 3.5. As we do in out production machine configs (which are using ASP.NET 3.5) we have
This control environment is not in a server farm. Why is it suggesting that I turn on debug, when it's already on. Why isn't it showing me my source code?
Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.
my website was designed using dotnet 2003 worked under dotnet framework 1.0 the website was working fine then i had to upgrade the server to windows 2008 iis 7.0 so i configured the website to work under dotnet frame work 2.0 and the problem started to show up
I am having this problem with, it seems, Viewstate. This issue only occurs on certain machines, if I browse the website myself it works fine but if another user browses the pages they will lock up and timeout with the error "Viewstate verification failed. Reason: Viewstate was invalid." appering in the event log. Full error is as follows:
I deploy a simple web app,that works fine on my local system, on a remote server. The webform consist of a Menu control and a Listview control. If I browse the page and then leave it for like 20 minutes untouched and then try to select an entry from the menu I am getting the following error -
Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; InfoPath.1; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; AskTB5.6) Timestamp: Wed, 28 Apr 2010 07:39:24 UTC
Message: Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500 Line: 4723 Char: 21 Code: 0 URI: http://www.shoeslocation.com/ScriptResource.axd?d=w3IpLZb6A3e5QHkk7kOTg4vdE8qw_8oIJ-6Kv5NpYYlCqyodfByoMbMvCI7RsUpH3U_p3tMqnuLd_nCq_qPaX4weg2w6s1FlfA_eQbVY-nU1&t=55414254
Before that I used to get the following error -
Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.So I added the following to the Pages tag in the web.config validateRequest="false" enableEventValidation="false" viewStateEncryptionMode ="Never"
I am writing a search results page for an airline booking system. I have Next/Previous buttons to view flights for the next or previous days. The way i have done my results grid is that i use an HtmlTable and dynamically add rows, cells and controls into the cells. This gives ultimate flexibility given that we can add any control type we want and have it function as it does everywhere else in the system. As you should be aware - i must recreate these controls each time the page is reloaded (in the page_init event) since asp does not handle this automatically.
When they go next/previous it refreshes the flight data and re-populates the grids. If they select a flight in the return grid (by checking the RadioButton), and go next on the FIRST leg grid, the selection of the return leg stays the same after the postback - which is great. But the problem is, if the flight they selected on the return leg is no longer available it will not create the control and i get the following error;
"Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request."
Is there any way to tell asp.net that if you do not find the control anymore, simply ignore it rather than throwing the error? The nature of this design is that there potentioally WILL be a different layout after the page is posted back.
