need help MVC4

Question

Hi, I'm a student of TAFE. I created few tables as Login, Customer and Account. An Account table details as Account Detail as ID, Type and Balance and i don't know how to transfer some amount between accounts.

Guest User · Answer

What I understand you need to update Balance between some records in Account table. Right? in mvc4 you can have AccountDetailsController with PUT method which will leverage AccountDetail model to update data, e.g., Model class AccountDetail { public int ID; public int Type; public float Balance; } AccountDetailsController [HttpPut] class AccountDetailsController : BaseClass //I assume this base class is leveraging any //framework for db update like PetaPoco public void UpdateAccounts { AccountDetail ad=new AccountDetail(); ad = AccountDetail .FindByID(1); ad.Balance = 222; ad.Update(); }

Guest User · Answer

Thanks Sandra for accepting my solution! Looking forward for more interactions in future!

Guest User · Answer

Sorry for late response! I was out last week! So, what I understand is within same table you want to update data among different records ? Right. This is simple problem where you can use UPDATE queries or any ORM (PetaPoco or Massive) to leverage Update() function? The algo to do that is: AccountDetailsController [HttpPut] class AccountDetailsController : BaseClass //I assume this base class is leveraging any //framework for db update like PetaPoco public void UpdateAccounts(int id) { AccountDetail ad=new AccountDetail(); ad = AccountDetail .Find("select * from accounts where user_id=@0", id); //this will give you all accounts for same user. Now you want to transfer funds, so you need input for that, I assume you've passed data in Request Headers string baseAccountNo = Request.Header["baseAccount"]; string transferAccountNo = Request.Header["transferAccount"]; double transferAmt=Request.Header["amount"]; //get funds in base account double baseAccountAmount = ad.Select(x=>x.accountNo==baseAccountNo).FirstOrDefault().Amount; //check if baseAccountNo has required funds if ( baseAccountAmount >=transferAmt) { double amountInTransferAccount= ad.Select(x=>x.accountNo==transferAccountNo).FirstOrDefault().Amount; amountInTransferAccount+=transferAmt; ad.Select(x=>x.accountNo==baseAccountNo).FirstOrDefault().Amount -=transferAmt; } ad.Update(); }

Sandra F · Answer

I still couldn't solve my problem, can you help me how pls.

Sandra F · Answer

A customer shall be able to initiate fund transfers from one account to another account in the same bank and belonging to the same customer, for example, from savings to checking or checking to savings. The user shall provide two accounts and request fund transfers between accounts. Once the user has chosen the accounts and has indicated the amount of the transfer, the system shall verify that sufficient funds are available to perform the transfer. If successful, the transfer amount shall be debited from the current account and credited to the specified account~ otherwise, no transfer shall take place, and the user shall be notified appropriate1y

Sandra F · Answer

photo1.png you can see below

Guest User · Answer

can you please paste code snippet what you're trying to update as credit to saving account?

Sandra F · Answer

I have data already in and need to transfer the data from credit to saving account...and i used ... To Login need to use c100 and password is password100. thank you for advance...

need help MVC4

Answers (8)