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).
View 2 Replies
Similar Messages:
Dec 14, 2010
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)?
View 2 Replies
Nov 24, 2010
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.
View 1 Replies
Sep 25, 2010
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]...
View 28 Replies
Jun 16, 2010
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?
View 1 Replies
Mar 15, 2010
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.
View 6 Replies
Apr 27, 2010
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.
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
begin
GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];
TextBox PhoneNo = (TextBox)row.FindControl("TextBox2");
[code]...
View 2 Replies
Aug 27, 2010
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
View 4 Replies
Jan 11, 2011
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?
View 17 Replies
Mar 9, 2011
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
View 2 Replies
Jul 24, 2010
Suppose say I am doing a couple of operations.
First a delete and then an insert.
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?
View 1 Replies
Aug 20, 2010
i have no idea about commit,rollback,tranasaction can any one explain with examples brefiely.
View 2 Replies
May 10, 2010
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(????);")
View 8 Replies
Feb 5, 2010
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.
View 2 Replies
Aug 20, 2010
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.
View 3 Replies
Apr 22, 2010
I have the web form whcih processing several web services calls.
If one call failed, it will rollback transactions. But it cannot.
Due to the web services will complete for each call.
I am using sql connection and sql command.
Is it possible to do this?
View 11 Replies
Oct 29, 2010
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?
View 4 Replies
Jun 30, 2010
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?
View 1 Replies
Nov 17, 2010
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.
[Code]....
View 9 Replies
Mar 31, 2010
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?
View 4 Replies
Jun 18, 2010
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.
View 1 Replies
Mar 14, 2011
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...
View 1 Replies
Mar 16, 2011
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?
View 2 Replies
Jul 22, 2010
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.
View 2 Replies
Sep 18, 2010
I have the following code in a stored procedure to retrieve all posts:
[Code]....
However, I am having trouble selecting posts by their tag..
View 9 Replies