Managing Entity Edits Between HTTP Posts And Rollback?
Jul 27, 2010
User amends an existing order. The order is complex - lots of related 'entities' (addresses, post options, suppliers, makes, models, various items etc). Across multiple http posts.
User wants to discard the changes.
I have an order entity and as the user is editing this I am making various changes to the entity associations e.g changing order.address, order.items.add(item)...
In a single post this is fine, but across posts I don't know how best store state. If I store the entities then I cannot save the changes as they are across different data contexts. I have read that it is bad practice to store the data context in the session state i.e. long-lived context. I can't save changes after each edit/post because I cannot roll-back (?). I really would like to work with the entities during the editing process rather than one big save at the end (taking UI settings and applying these in one chunk).
I have a model that consists of Order, OrderLine, Product.
I want to create an Order and add OrderLines (each OrderLine related to a Product). I create the Order and add new OrderLines to it. Between posts I store the Order entity in Session (or ViewState). Just so you know I have added suppport for binary serialisation which works fine.
The relationship is therefore Order > OrderLine(s) > Product(s).
You might have already guessed what the problem is - that when I SaveChanges() I get the usual 'AcceptChanges cannot continue because the object's key values conflict with another object in the ObjectStateManager.' error.
I have referred to a number of articles online but none seem to handle this case (where I have the relationship across more than two entities) e.g. [URL].
This must be a very common requirement surely? Is there anyone out there doing the same kind of thing with Entity Framework (and without using DTOs etc)?
I have an issue with a popup in Asp.net using AJAX modalpoup extender. Is it possible to show one kind of popup when the user edits few textboxes and the other kind of popup for the remaining textboxes.
Ex: Only when txtbox1's value is changed, it should show me popup1 when the save button is clicked. Or else popup2.
i want to rollback the changes if something goes wrong either in the clients sit(internet connection failed in the time the sub is running) or in the servers side(if the server falls)is the sqltrasnsaction the properly solution??
Code: Dim thisConnection As New SqlConnection("server=(local)SQLEXPRESS;" & _ "integrated security=sspi;database=MyDatabase") ' SQL Delete Commands Dim sql As String = "DELETE FROM Employee " & _ "WHERE ID = 10" ' Create command [code]...
I am using visual web developer 2010 and have a situation where if I make edits to either the master or default page text's, they are not refelcted in what is displayed when the site is run?
I have written several queries under one single transaction. When any of the query throws an error then the whole transaction should rollback. However, in some rare cases say 2% cases even after the error the next transaction is getting comitted.
note that all transaction processes (opening, committing and rollback) is done through .net.
I am using 64bit windows 2003 for data and application server. And website is configured for runapp32on64.
I have this page in my application that contains a couple of grids and a few text boxes. Now these grids are getting populated from a hidden field in the page. My requirement is like the main page should have an "Update All" button where as these grids have their individual Update and delete options. Now when I delete or update anything from the Grids it should do a soft update or delete function and eventually when I hit "Update All" an actual commit statement should be executed.
in sql server 2005, i have deleted row by mistake and now want to roolback them, i wrote a query is "delete tblmetric" nd pressed F5 now wanna to recover the rows
I have a page with a gridview. It has a select command and an edit command which are both SPs. I added a standard "Edit, Update, Cancel" CommandField to the gridview so that I can edit. The edit and update are working fine. However, I have found that if the underlying data changes after I have loaded the page and before I hit "Edit", and this change causes the row I'm going to edit to be in a different row than before, the gridview will open the wrong row for editing.
For example, say the gridview is sorted by the a field called ID, and currently there are rows in the DB with ID of 2,4,6 and 8. I load the page and see those 4 records. While I'm looking, someone adds a record with ID of 1. When I click Edit on the row with ID = 4, I will actually end up editing the record with ID 2. Basically, i'm clicking on Edit in the second row, and I end up editing the record in the 2nd row, but the 2nd row is now a different record than before.
It seems like there HAS to be a way to fix this, otherwise editing in the gridview seems exceptionally dangerous. Is there any easy way to handle this, to make sure the user is editing the row they think they are?
I am using more than one files to read and write to the server. Suppose during writing or reading any of files gets error the already stored files need to be rollback or removed from storing.So that the user agin try to write without error. Simply the all of the files need to be stored into the server without error, of error occurs to any of file none of files need to be read/write
Now, these two operations are done with two different connections (say con1 and con2). Both these connections are enlisted in the same TransactionScope.
Before the delete/insert operations the connections are opened and immediately closed.
So, now if the insert fails, then how is the delete rollbacked since con1 has been closed?
User clicks the Edit Link Button on my grid and I want to launch a new screen for the user to do some edits...I need to be able to pull the ID but I cannot figure out what I need to pass to the HandleSelect function and then how to read my column3 to get selectButton.Attributes.Add("onClick", "return HandleSelect(????);")
Is there a way to restrict being able to edit a gridview column to some users but not to others ? Say setting the column to read only and then resetting it when the row is in edit mode.
I have a form that collects some dates. The users can go to this form any time, view the data, and edit the data.
The user should only be able to enter today or future dates only. We don't want users to go in here and be able to past date these dates.
So I created a compare validator which compares the text box against today's date. This works great. The user saves the form and life goes on.
But then, lets say they come back 1 week later and want to change a date. Now all the old dates will fire this validator and they can't save anything unless they change all the dates to today or newer. This is a problem.
So what I thought was when I load the form with the data from the database, I would just disable the validator if there is a date, and if it's null enable the validator. But this won't work because then they can back-date all of those dates with the validator disabled.
So for the dates that are not null, it shouldn't fire the validator unless they change the date.
When I load the form, I'm going to load all these dates into Viewstate. I'm going to create a custom validator and check the value they enter against the previous date that is in Viewstate. If it matches that date then it is valid, if it doesn't match that date then I will run it through the validator to check for past-date.
I'm using Visual Web Developer 2010 against SQL Server 2008 R2.
I have a number of GridViews and FormViews working now, with edit functionality. However I have one field in my main database table that is of type 'Text'. With that one field, the edits won't take. I click Edit, change the text in the GridView, and click Update, but it just reverts back to the unchanged text.
It seems like I've tried everything. Is there a way to make that work without having to code it the hard way with a Textarea control?
I have an EDM, it includes the entities extension and history. My goal is to use history to keep track of all the changes made to extension entity. For example, if extension with ID 223 has its property 'Name_Display' changed - I want the history entity to record this.
I'm using ASP.NET with VB.NET. Where in my code do I put the hook to say, "update the history entity" and what should that hook look like?
I'm trying to save and update contacts. I can add new contacts, but when I try to update a contact it will be inserted as a new contact in the database. I can't understand what I'm doing wrong.
I have a gridview bound to a sqldatasource with editing enabled. If I click Edit, then either Cancel or Update, the update or cancel occurs and the Edit button reappears. However, I cannot then click the browser's back button without having the Update and Cancel buttons reappear. A second click of the back button takes me to a state where the Edit button shows again, *then* another back button click will take me to the referring page (the one before the one with the gridview on it.) IOW, it looks like the postbacks are cached. How can I prevent this and have the back button go straight to the referring page?
I am using Facebook Toolkit. I have appKey and appSecret, but I dont want that visitor need to conenct to facebook. I will use my login/passwork to get my wall posts.
I am doing my final year project and have decided to make a website in asp.net. For that I'll be using Micrsoft Visual Studio 2008. I'm making a Real ESTATE properties website. I want to know how to localize or create new posts in asp.net( like in WORDPRESS) and also when I hit SEARCH it should search for the desired keyword or the searched post.
If post is not possible then it should display pages...
On my site I've got a section which displays the latest tweets from my twitter account. I used Twitterizer to read latest tweets from my account and bind them to a Repeater However, with Twitter's new security, I can't use this as I must use oAuth.
What is the best way of returning tweets from an account?
I have a project in VS 2010 and works great in my dev environment, including a single post that has the def:
[Code]....
But when I publish to another box, I get an error "Could not instantiate file name generator.". This only occurs on the post, all the other ActionResults work fine.