Update in Asp.NET MVC












2















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!










share|improve this question

























  • 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
















2















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!










share|improve this question

























  • 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














2












2








2








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!










share|improve this question
















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








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



















  • 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












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
});


}
});














draft saved

draft discarded


















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
















draft saved

draft discarded




















































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.




draft saved


draft discarded














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





















































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







Popular posts from this blog

Create new schema in PostgreSQL using DBeaver

Deepest pit of an array with Javascript: test on Codility

Costa Masnaga