public ActionResult Deleteaccount1(Account a)
{
DB05TMS155_1718Entities1 bd = new DB05TMS155_1718Entities1();
ObjectParameter o = new ObjectParameter("succes", 0);
Account t = db.Accounts.Find(Convert.ToInt32(TempData["accountid"]));
if (t.accountstatus == "Inactive")
{
TempData["AlertMessage"] = 20;
return(RedirectToAction("ViewAccountexecutive"));
}
else
{
int s1 = Convert.ToInt32(TempData["accountid"]);
db.accountdelete5(s1, o);
if (Convert.ToInt32(o.Value) == 0)
{
TempData["AlertMessage"] = 7;
return(RedirectToAction("ViewAccountexecutive"));
}
else
{
TempData["AlertMessage"] = 8;
return(RedirectToAction("ViewAccountexecutive"));
}
}
}
public ActionResult accountregister(Account a)
{
if (ModelState.IsValid)
{
ObjectParameter o = new ObjectParameter("id", 0);
db.checkaccount(a.Customer_ID, o);
if (Convert.ToInt32(o.Value) == 0)
{
Response.Write("<script>alert('Invalid Customer Id')</script>)");
return(View());
}
else
{
DB05TMS155_1718Entities1 bd = new DB05TMS155_1718Entities1();
ObjectParameter r = new ObjectParameter("id", 0);
db.account_reg1(r, a.Customer_ID, a.Account_type, a.Deposit_Amount);
if (Convert.ToInt32(r.Value) == 0)
{
Response.Write("<script>alert('This ID already holds" + a.Account_type + "')</script>)");
}
else
{
Response.Write("<script>alert('Account created successfully with ID" + Convert.ToInt32(r.Value) + "')</script>)");
}
db.SaveChanges();
ModelState.Clear();
}
}
return(View());
}
public ActionResult Login(login_tab usermodel)
{
using (DB05TMS155_1718Entities1 db = new DB05TMS155_1718Entities1())
{
if (ModelState.IsValid)
{
var userdetails = db.login_tab.Where(x => x.userid == usermodel.userid && x.passwrd == usermodel.passwrd).FirstOrDefault();
if (userdetails == null)
{
Response.Write("<script>alert('Please enter valid credentials')</script>");
return(View("Login"));
}
else
{
ObjectParameter o = new ObjectParameter("userrole", 0);
db.checkrole(usermodel.userid, usermodel.passwrd, o);
if (o.Value.ToString() == "CAE")
{
db.login(usermodel.userid, usermodel.passwrd);
Session["userID"] = userdetails.userid;
return(RedirectToAction("startpage", "Executive"));
}
else
{
db.login(usermodel.userid, usermodel.passwrd);
Session["userID"] = userdetails.userid;
return(RedirectToAction("startpage", "Account"));
}
}
}
}
return(View());
}
public ActionResult cdelete(customerdetails_team m)
{
customerdetails_team d = new customerdetails_team();
DB05TMS155_1718Entities1 mn = new DB05TMS155_1718Entities1();
d = mn.customerdetails_team.Find(Convert.ToInt32(TempData["cid"]));
TempData["cnid"] = d.CustomerId;
return(View(d));
}
public ActionResult viewstatus()
{
DB05TMS155_1718Entities1 b = new DB05TMS155_1718Entities1();
List <customerdetails_team> s2 = new List <customerdetails_team>();
s2 = b.customerdetails_team.ToList();
b.SaveChanges();
return(View(s2));
}
//view
public ActionResult viewall(customerdetails_team c)
{
DB05TMS155_1718Entities1 db = new DB05TMS155_1718Entities1();
List <customerdetails_team> s1 = new List <customerdetails_team>();
s1 = db.customerdetails_team.ToList();
db.SaveChanges();
return(View(s1));
}
public ActionResult updatecus(customerdetails_team q)
{
customerdetails_team c = new customerdetails_team();
DB05TMS155_1718Entities1 mn = new DB05TMS155_1718Entities1();
c = mn.customerdetails_team.Find(Convert.ToInt32(TempData["cid"]));
TempData["cnid"] = c.CustomerId;
return(View(c));
}
public ActionResult updatecus(customerdetails_team q, FormCollection n)
{
try
{
DB05TMS155_1718Entities1 z = new DB05TMS155_1718Entities1();
customerdetails_team a = z.customerdetails_team.Find(Convert.ToInt32(TempData["cnid"]));
string s1 = n["newcname"];
string s2 = n["newaddress1"];
string s3 = n["newaddress2"];
string s4 = n["newage"];
if (s1.Length == 0)
{
n["newcname"] = a.CustomerName;
}
if (s2.Length == 0)
{
n["newaddress1"] = a.AddressLine1;
}
if (s3.Length == 0)
{
n["newaddress2"] = a.AddressLine2;
}
if (s4.Length == 0)
{
n["newage"] = a.CustomerAge.ToString();
}
if (a.stats == "inactive")
{
TempData["AlertMessage"] = 23;
return(RedirectToAction("viewall"));
}
else
{
string a1 = n["newcname"];
string a2 = n["newaddress1"];
string a3 = n["newaddress2"];
int a4 = Convert.ToInt32(n["newage"]);
z.team5ud(Convert.ToInt32(TempData["cnid"]), a1, a4, a2, a3);
TempData["AlertMessage"] = 24;
return(RedirectToAction("viewall"));
}
}
catch (Exception)
{
TempData["alert"] = 15;
return(RedirectToAction("update1"));
}
}
public JsonResult Getcity(int state)
{
DB05TMS155_1718Entities1 db = new DB05TMS155_1718Entities1();
List <citylist_Result> cityddl = new List <citylist_Result>();
cityddl = db.citylist(state).ToList();
List <SelectListItem> citylist = new List <SelectListItem>();
foreach (citylist_Result i in cityddl)
{
citylist.Add(new SelectListItem {
Text = i.cityname.ToString(), Value = i.cityname.ToString()
});
}
return(Json(citylist, JsonRequestBehavior.AllowGet));
}
public ActionResult viewall(FormCollection F)
{
DB05TMS155_1718Entities1 db = new DB05TMS155_1718Entities1();
string searchby = F["search by"];
string searchvalue = F["SearchValue"];
int search = Convert.ToInt32(searchvalue);
customerdetails_team tem = db.customerdetails_team.Find(search);
if (searchby == "CustomerId" || searchby == "CustomerSSNId")
{
if (tem != null)
{
if (searchby == "CustomerId")
{
List <customerdetails_team> templist = db.customerdetails_team.Where(x => x.CustomerId == search).ToList();
return(View("viewall", templist));
}
else
{
List <customerdetails_team> templist = db.customerdetails_team.Where(x => x.CustomerSSNId == (search)).ToList();
return(View("viewall", templist));
}
}
else
{
Response.Write("<script>alert('Please enter valid customerid')</script>");
List <customerdetails_team> s1 = new List <customerdetails_team>();
s1 = db.customerdetails_team.ToList();
db.SaveChanges();
return(View(s1));
}
}
else
{
Response.Write("<script>alert('Choose search by radio button')</script>");
List <customerdetails_team> s1 = new List <customerdetails_team>();
s1 = db.customerdetails_team.ToList();
db.SaveChanges();
return(View(s1));
}
}
public ActionResult Depositmoney(int id)
{
if (id == 0)
{
DB05TMS155_1718Entities1 db = new DB05TMS155_1718Entities1();
Account a = new Account();
a = db.Accounts.Find(Convert.ToInt32(TempData["aid"]));
TempData["accountid"] = a.Account_ID;
return(View(a));
}
else
{
TempData["aid"] = id;
Account a = new Account();
a = db.Accounts.Find(id);
return(View(a));
}
}
public ActionResult cdelete(customerdetails_team n, FormCollection a)
{
DB05TMS155_1718Entities1 z = new DB05TMS155_1718Entities1();
customerdetails_team s = z.customerdetails_team.Find(Convert.ToInt32(TempData["cnid"]));
if (s.stats == "inactive")
{
TempData["AlertMessage"] = 23;
return(RedirectToAction("viewall"));
}
else
{
z.team5delete(Convert.ToInt32(TempData["cnid"]));
TempData["AlertMessage"] = 30;
return(RedirectToAction("viewstatus"));
}
}
public ActionResult Deleteaccount1(int id)
{
if (id == 0)
{
DB05TMS155_1718Entities1 df = new DB05TMS155_1718Entities1();
Account c = new Account();
c = df.Accounts.Find(TempData["actid"]);
TempData["accountid"] = c.Account_ID;
return(View(c));
}
else
{
TempData["actid"] = id;
DB05TMS155_1718Entities1 df = new DB05TMS155_1718Entities1();
Account c = new Account();
c = df.Accounts.Find(id);
TempData["accountid"] = c.Account_ID;
return(View(c));
}
}
public ActionResult Account_Search(FormCollection F)
{
{
DB05TMS155_1718Entities1 db = new DB05TMS155_1718Entities1();
string searchby = F["search by"];
string search1 = F["Search1"];
int searchvalue1 = 0;
if (search1 != "")
{
searchvalue1 = Convert.ToInt32(search1);
}
int searchvalue2 = 0;
string search2 = F["Search2"];
if (search2 != "")
{
searchvalue2 = Convert.ToInt32(search2);
}
if (searchby == "Customer_ID" || searchby == "Account_ID")
{
if (searchby == "Customer_ID")
{
string accounttype = F["Account_Type"];
if (accounttype == "Current Account" || accounttype == "Savings Account")
{
// List<Account> tem1 = new List<Account>();
// tem1 = db.Accounts.Where(a => a.Customer_ID == searchvalue1).ToList();
ObjectParameter o = new ObjectParameter("id", 0);
db.accountsearch(searchvalue1, accounttype, o);
db.SaveChanges();
int tem1 = Convert.ToInt32(o.Value);
if (tem1 == 1)
{
// string accounttype = F["Customer_ID"];
List <Account> templist = new List <Account>();
templist = db.Accounts.Where(x => x.Customer_ID == searchvalue1 && x.Account_type == accounttype).ToList();
return(View("ViewAccount", templist));
}
return(View("ViewAccount"));
}
else
{
Response.Write("<script>alert('select account type')</script>");
List <Account> lst = new List <Account>();
lst = db.Accounts.ToList();
ViewBag.list = lst;
return(View("ViewAccount", lst));
}
}
else
{
Account tem2 = db.Accounts.Find(searchvalue2);
if (tem2 != null)
{
List <Account> templist = new List <Account>();
templist = db.Accounts.Where(x => x.Account_ID == searchvalue2).ToList();
return(View("ViewAccount", templist));
}
else
{
Response.Write("<script>alert('Invalid account id')</script>");
List <Account> lst = new List <Account>();
lst = db.Accounts.ToList();
ViewBag.list = lst;
return(View("ViewAccount", lst));
}
}
}
else
{
Response.Write("<script>alert('Choose search by radio button')</script>");
List <Account> lst = new List <Account>();
lst = db.Accounts.ToList();
ViewBag.list = lst;
return(View("ViewAccount", lst));
}
}
}
public ActionResult transfer(Account c, FormCollection f)
{
try
{
DB05TMS155_1718Entities1 db = new DB05TMS155_1718Entities1();
TempData["act"] = f["act"];
TempData["trt"] = f["trt"];
ObjectParameter r = new ObjectParameter("id", 0);
db.check123(Convert.ToInt32(f["act"]), Convert.ToInt32(f["trt"]), r);
if (Convert.ToInt32(r.Value) == 0)
{
Response.Write("<script>alert('Invalid account Id ')</script>)");
return(View());
}
else
{
long a1 = Convert.ToInt64(f["act"]);
long a2 = Convert.ToInt64(f["trt"]);
int a3 = Convert.ToInt32(f["transamount"]);
DB05TMS155_1718Entities1 m = new DB05TMS155_1718Entities1();
ObjectParameter n = new ObjectParameter("flag", 0);
ObjectParameter k = new ObjectParameter("temp1", 0);
ObjectParameter v = new ObjectParameter("temp2", 0);
m.transq(a1, a2, a3, n, k, v);
if (a1 == a2)
{
TempData["AlertMessage"] = 33;
return(RedirectToAction("transfer"));
}
else
{
if (Convert.ToInt32(k.Value) > 0)
{
if (Convert.ToInt32(v.Value) > 0)
{
if (Convert.ToInt32(n.Value) > 0)
{
m.SaveChanges();
TempData["AlertMessage"] = 22;
ModelState.Clear();
return(RedirectToAction("ViewAccount"));
}
else
{
TempData["AlertMessage"] = 21;
return(RedirectToAction("transfer"));
}
}
else
{
TempData["AlertMessage"] = 32;
return(RedirectToAction("transfer"));
}
}
else
{
TempData["AlertMessage"] = 31;
return(RedirectToAction("transfer"));
}
}
}
}
catch (Exception)
{
TempData["alert"] = 38;
return(RedirectToAction("transfer"));
}
}
