public ActionResult Index_Post()
{
try
{
ViewData["Message"] = " ";
FixedDepositClass fdc = new FixedDepositClass();
UpdateModel(fdc);
string con = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
SqlConnection sqlCon = new SqlConnection(con);
sqlCon.Open();
SqlCommand sqlCmd = new SqlCommand("fixed_deposit_sp", sqlCon);
sqlCmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@account_no", Session["Accountno"]);
sqlCmd.Parameters.AddWithValue("@amount", fdc.fd_amount);
sqlCmd.Parameters.AddWithValue("@duration", fdc.duration);
sqlCmd.Parameters.AddWithValue("@nominee", fdc.nominee);
sqlCmd.ExecuteNonQuery();
sqlCon.Close();
ViewData["Message"] = "Fixed deposit created Successfully";
return(View());
}
catch
{
ViewData["Message"] = " Fixed deposit Failed";
return(View());
}
}
public ActionResult Create_Fd()
{
try
{
ViewData["Message"] = " ";
FixedDepositClass fdc = new FixedDepositClass();
UpdateModel(fdc);
string con = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
SqlConnection sqlCon = new SqlConnection(con);
sqlCon.Open();
SqlCommand sqlCmd = new SqlCommand("fixed_deposit_sp", sqlCon);
sqlCmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@ACCOUNT_NO", Session["Accountno"]);
sqlCmd.ExecuteNonQuery();
sqlCon.Close();
ViewData["Message"] = "Fixed deposit created Successfully";
return(RedirectToRoute(new
{
controller = "FixedDeposit",
action = "FdDetails"
}));
}
catch
{
ViewData["Message"] = " Fixed deposit Failed";
return(View());
}
}
