Update in Asp.NET MVC
Sorry for the question, I'm learning Asp.net with EF and I'm having problems to do a specific update.
I want to do a system that has transactions between accounts. The structural part is ok, but the problem is the following:
When the update is executed, the system makes the transfer normally, in other words, both accounts has $100, I do a transaction of $10, so one account stays $110 and another with $90.
But in the second transfer, one account stays with $80 and another with $100.
Here's the code:
[HttpPost]
public ActionResult TransferCurrency(Usuario usuario, ViewModelTransfer viewModel)
{
if (usuario.Id == 0)
{
return HttpNotFound();
}
if (viewModel.ForId == null)
{
return HttpNotFound();
}
var usuarioTransaction = _context.Usuario.Single(c => c.NConta == viewModel.ForId);
usuarioTransaction.Currency = usuario.Currency + viewModel.Transfer;
var usuarioInDb = _context.Usuario.Single(m => m.Id == usuario.Id);
usuarioInDb.Currency = usuario.Currency - viewModel.Transfer;
_context.SaveChanges();
return RedirectToAction("Index");
}
Does anybody knows what am I doing wrong here?
Thanks!
c# asp.net crud
add a comment |
Sorry for the question, I'm learning Asp.net with EF and I'm having problems to do a specific update.
I want to do a system that has transactions between accounts. The structural part is ok, but the problem is the following:
When the update is executed, the system makes the transfer normally, in other words, both accounts has $100, I do a transaction of $10, so one account stays $110 and another with $90.
But in the second transfer, one account stays with $80 and another with $100.
Here's the code:
[HttpPost]
public ActionResult TransferCurrency(Usuario usuario, ViewModelTransfer viewModel)
{
if (usuario.Id == 0)
{
return HttpNotFound();
}
if (viewModel.ForId == null)
{
return HttpNotFound();
}
var usuarioTransaction = _context.Usuario.Single(c => c.NConta == viewModel.ForId);
usuarioTransaction.Currency = usuario.Currency + viewModel.Transfer;
var usuarioInDb = _context.Usuario.Single(m => m.Id == usuario.Id);
usuarioInDb.Currency = usuario.Currency - viewModel.Transfer;
_context.SaveChanges();
return RedirectToAction("Index");
}
Does anybody knows what am I doing wrong here?
Thanks!
c# asp.net crud
Your example is a little hard to follow since it isn't fully in "English" so I'm not entirely sure what your example is attempting to do. It appears to be looking up one account and adding to it the amount of the transfer and then attempting to decrement from the other. Since this works once, my guess is that your long running context is causing your issue. When do you initialize the db context? In the controller's constructor? I would recommend moving that db context initialization into this method and see if it fixes your issue.
– user1011627
Nov 26 '18 at 2:56
add a comment |
Sorry for the question, I'm learning Asp.net with EF and I'm having problems to do a specific update.
I want to do a system that has transactions between accounts. The structural part is ok, but the problem is the following:
When the update is executed, the system makes the transfer normally, in other words, both accounts has $100, I do a transaction of $10, so one account stays $110 and another with $90.
But in the second transfer, one account stays with $80 and another with $100.
Here's the code:
[HttpPost]
public ActionResult TransferCurrency(Usuario usuario, ViewModelTransfer viewModel)
{
if (usuario.Id == 0)
{
return HttpNotFound();
}
if (viewModel.ForId == null)
{
return HttpNotFound();
}
var usuarioTransaction = _context.Usuario.Single(c => c.NConta == viewModel.ForId);
usuarioTransaction.Currency = usuario.Currency + viewModel.Transfer;
var usuarioInDb = _context.Usuario.Single(m => m.Id == usuario.Id);
usuarioInDb.Currency = usuario.Currency - viewModel.Transfer;
_context.SaveChanges();
return RedirectToAction("Index");
}
Does anybody knows what am I doing wrong here?
Thanks!
c# asp.net crud
Sorry for the question, I'm learning Asp.net with EF and I'm having problems to do a specific update.
I want to do a system that has transactions between accounts. The structural part is ok, but the problem is the following:
When the update is executed, the system makes the transfer normally, in other words, both accounts has $100, I do a transaction of $10, so one account stays $110 and another with $90.
But in the second transfer, one account stays with $80 and another with $100.
Here's the code:
[HttpPost]
public ActionResult TransferCurrency(Usuario usuario, ViewModelTransfer viewModel)
{
if (usuario.Id == 0)
{
return HttpNotFound();
}
if (viewModel.ForId == null)
{
return HttpNotFound();
}
var usuarioTransaction = _context.Usuario.Single(c => c.NConta == viewModel.ForId);
usuarioTransaction.Currency = usuario.Currency + viewModel.Transfer;
var usuarioInDb = _context.Usuario.Single(m => m.Id == usuario.Id);
usuarioInDb.Currency = usuario.Currency - viewModel.Transfer;
_context.SaveChanges();
return RedirectToAction("Index");
}
Does anybody knows what am I doing wrong here?
Thanks!
c# asp.net crud
c# asp.net crud
edited Nov 26 '18 at 0:19
Felipe Jaquetto
asked Nov 26 '18 at 0:03
Felipe JaquettoFelipe Jaquetto
112
112
Your example is a little hard to follow since it isn't fully in "English" so I'm not entirely sure what your example is attempting to do. It appears to be looking up one account and adding to it the amount of the transfer and then attempting to decrement from the other. Since this works once, my guess is that your long running context is causing your issue. When do you initialize the db context? In the controller's constructor? I would recommend moving that db context initialization into this method and see if it fixes your issue.
– user1011627
Nov 26 '18 at 2:56
add a comment |
Your example is a little hard to follow since it isn't fully in "English" so I'm not entirely sure what your example is attempting to do. It appears to be looking up one account and adding to it the amount of the transfer and then attempting to decrement from the other. Since this works once, my guess is that your long running context is causing your issue. When do you initialize the db context? In the controller's constructor? I would recommend moving that db context initialization into this method and see if it fixes your issue.
– user1011627
Nov 26 '18 at 2:56
Your example is a little hard to follow since it isn't fully in "English" so I'm not entirely sure what your example is attempting to do. It appears to be looking up one account and adding to it the amount of the transfer and then attempting to decrement from the other. Since this works once, my guess is that your long running context is causing your issue. When do you initialize the db context? In the controller's constructor? I would recommend moving that db context initialization into this method and see if it fixes your issue.
– user1011627
Nov 26 '18 at 2:56
Your example is a little hard to follow since it isn't fully in "English" so I'm not entirely sure what your example is attempting to do. It appears to be looking up one account and adding to it the amount of the transfer and then attempting to decrement from the other. Since this works once, my guess is that your long running context is causing your issue. When do you initialize the db context? In the controller's constructor? I would recommend moving that db context initialization into this method and see if it fixes your issue.
– user1011627
Nov 26 '18 at 2:56
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53473249%2fupdate-in-asp-net-mvc%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53473249%2fupdate-in-asp-net-mvc%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Your example is a little hard to follow since it isn't fully in "English" so I'm not entirely sure what your example is attempting to do. It appears to be looking up one account and adding to it the amount of the transfer and then attempting to decrement from the other. Since this works once, my guess is that your long running context is causing your issue. When do you initialize the db context? In the controller's constructor? I would recommend moving that db context initialization into this method and see if it fixes your issue.
– user1011627
Nov 26 '18 at 2:56