public IActionResult OnGetAccountBal(long accountid) { var gbh = _transactionRepository.GetAccountBalance(accountid); AccountBal data = new AccountBal { OpenBal = gbh.OpenBal, Startdate = gbh.Startdate }; return(new JsonResult(data)); }
public bool MyAccount(AccountBal bal, out string IFSC, out int Acno) { bool status = false; SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ZigmaCS"].ToString()); try { SqlCommand cmd = new SqlCommand("sp_InsertIntoAccount", cn); cmd.CommandType = CommandType.StoredProcedure; cn.Open(); cmd.Parameters.Add("@Account_No", SqlDbType.Int); cmd.Parameters["@Account_No"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@IFSC", SqlDbType.VarChar, 20); cmd.Parameters["@IFSC"].Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@LoginId", bal.UserId); //cmd.Parameters.AddWithValue("@Account_No", bal.AccountNo); //cmd.Parameters.AddWithValue("@IFSC", bal.IfscCode); SqlDataReader dr = cmd.ExecuteReader(); Acno = Convert.ToInt32(cmd.Parameters["@Account_No"].Value); IFSC = (string)cmd.Parameters["@IFSC"].Value; if (Acno != 0) { status = true; } else { status = false; } } catch (Exception ex) { throw new Exception(ex.Message); } finally { cn.Close(); cn.Dispose(); } return(status); }
public ActionResult MyAccountAction(AccountModel account) { AccountBal bal = new AccountBal(); bal.UserId = Convert.ToInt32(Session["loginid"]); //bal.AccountNo = account.AccountNo; //bal.IfscCode = account.IfscCode; AccountDal dal = new AccountDal(); bool status = dal.MyAccount(bal, out string IFSC, out int Acno); AccountModel model = new AccountModel(); if (status) { //bal.AccountNo = account.AccountNo; //bal.IfscCode = account.IfscCode; model.AccountNo = Acno; model.IfscCode = IFSC; model.UserId = bal.UserId; } return(View(model)); }
public AccountController() { this._account = new AccountBal(); }