-
Notifications
You must be signed in to change notification settings - Fork 1
/
FixedDepositController.cs
106 lines (80 loc) · 3.53 KB
/
FixedDepositController.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
using OnlineBanking.Models;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Data;
namespace OnlineBanking.Controllers
{
public class FixedDepositController : Controller
{
// GET: FixedDeposit
public ActionResult Index()
{
return View();
}
[HttpPost]
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();
}
}
public ActionResult FdDetail()
{
FdDetails fdd = new FdDetails();
DataSet ds = new DataSet();
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", Session["account_no"]);
SqlDataAdapter da = new SqlDataAdapter(sqlCmd);
da.Fill(ds);
List<FdDetails> FdDetailList = new List<FdDetails>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
FdDetails fObj = new FdDetails();
fObj.account_no = Convert.ToInt32(ds.Tables[0].Rows[i]["account_no"].ToString());
fObj.deposit_id = Convert.ToInt32(ds.Tables[0].Rows[i]["deposit_id"].ToString());
fObj.fd_date = ds.Tables[0].Rows[i]["fd_date"].ToString();
fObj.fd_amount = Convert.ToInt64(ds.Tables[0].Rows[i]["fd_amount"].ToString());
fObj.duration = Convert.ToInt32(ds.Tables[0].Rows[i]["Duration"].ToString());
fObj.rate_of_interest = Convert.ToInt64(ds.Tables[0].Rows[i]["rate_of_interest"].ToString());
fObj.maturity_date = ds.Tables[0].Rows[i]["maturity_date"].ToString();
fObj.maturity_amount = Convert.ToInt32(ds.Tables[0].Rows[i]["maturity_amount"].ToString());
fObj.nominee = ds.Tables[0].Rows[i]["nominee"].ToString();
FdDetailList.Add(fObj);
}
fdd.FdDetailList = FdDetailList;
sqlCon.Close();
return View(fdd);
}
}
}