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