public ActionResult DeleteAccount(castleaccount33 cstl)
{
try {
castleaccount33 tt = db.castleaccount33.Where(x => x.AccountId == cstl.AccountId).FirstOrDefault();
if (tt != null && tt.Balance != 0)
{
TempData["notdel"] = "Delete Operation unSuccessful as acount has balance";
return(RedirectToAction("ViewAccount"));
}
else
{
int rows = db.deleteaccount33(cstl.AccountId);
if (rows > 0)
{
TempData["delacc"] = "Account Deleted Successfully";
return(RedirectToAction("ViewAccount"));
}
else
{
ViewBag.Message = "Delete Operation Failed";
return(View("Error"));
}
}
}
catch (Exception e)
{
return(View("Error"));
}
}
public ActionResult Transfer(castleaccount33 acob)
{
//castleaccount33 tt = db.castleaccount33.Where(x => x.srcac == ct.srcac).FirstOrDefault();
//castleaccount33 tt1 = db.castleaccount33.Where(x => x.tgtac == ct.tgtac).FirstOrDefault();
//if (tt != null && tt.AccountStatus == "Inactive" && tt1 != null && tt1.AccountStatus == "Inactive")
//{
// TempData["lfl"] = "Transfer failed as account inactive";
// return RedirectToAction("ViewTransfer");
//}
//else
//{
try {
int id1 = acob.accid1;
int id2 = acob.accid2;
Session["id1"] = id1;
Session["id2"] = id2;
castleaccount33 ac1 = db.castleaccount33.Where(x => x.AccountId == id1).FirstOrDefault();
castleaccount33 ac2 = db.castleaccount33.Where(x => x.AccountId == id2).FirstOrDefault();
int bal1 = int.Parse(ac1.Balance.ToString());
int bal2 = int.Parse(ac2.Balance.ToString());
Session["bal1"] = bal1;
Session["bal2"] = bal2;
ObjectParameter para = new ObjectParameter("transid", typeof(int));
para.Value = 0;
ObjectParameter flag = new ObjectParameter("flag", typeof(int));
flag.Value = 0;
db.transfermoney(acob.accid1, acob.accid2, acob.amount, acob.ShowMessage = "Transfer successful", para, flag);
int transid = int.Parse((para.Value).ToString());
if (Convert.ToInt16(flag.Value) == 1)
{
TempData["sc"] = "<script>alert('Transaction successful, Transaction Id is" + transid + "');</script>";
return(RedirectToAction("ViewTransfer"));
}
else if (Convert.ToInt16(flag.Value) == 2)
{
TempData["fl"] = "<script>alert('Transaction failed because of insufficient balance');</script>";
//Response.Write("<script>alert('Transaction failed because of insufficient balance');</script>");
return(RedirectToAction("ViewTransfer"));
}
else if (Convert.ToInt16(flag.Value) == 0)
{
TempData["sm"] = "<script>alert('Transaction failed as source and target account are same';);</script>";
return(RedirectToAction("ViewTransfer"));
}
else if (Convert.ToInt16(flag.Value) == 3)
{
TempData["lfl"] = "Transfer failed as account inactive";
return(RedirectToAction("ViewTransfer"));
}
return(View());
}
catch (Exception e)
{
return(View("Error"));
}
}
public ActionResult depositdetails(string n)
{
try
{
castleaccount33 tt = db.castleaccount33.Where(x => x.AccountId == ct.AccountId).FirstOrDefault();
if (tt != null && tt.AccountStatus == "Inactive")
{
TempData["in"] = "Deposit not Successful as account is inactive";
return(RedirectToAction("ViewTransaction"));
}
else
{
int ab = int.Parse(n);
ct.depositamount = ab;
ObjectParameter para = new ObjectParameter("TransactionId", typeof(int));
para.Value = 0;
db.deposit(ct.AccountId, "Deposit Successful", ct.depositamount, para);
TempData["dep"] = "Deposit Successful";
return(RedirectToAction("ViewTransaction"));
}
}
catch (Exception e)
{
return(View("Error"));
}
}
public ActionResult AddAccount()
{
try {
castleaccount33 csob = new castleaccount33();
List <SelectListItem> acctype = new List <SelectListItem>()
{
new SelectListItem()
{
Text = "Current", Value = "Current"
},
new SelectListItem()
{
Text = "Savings", Value = "Savings"
},
};
List <SelectListItem> cidlist = new List <SelectListItem>();
cidlist = db.Custdet_1288.Select(x => new SelectListItem {
Text = x.custid.ToString(), Value = x.custid.ToString()
}).ToList();
csob.cidlist = cidlist;
//csob.amount = 0;
//csob.depositamount = 0;
//csob.withdrawlamount = 0;
csob.acctype = acctype;
return(View(csob));
}
catch (Exception e)
{
return(View("Error"));
}
}
public ActionResult Delete(Custdet_1288 cst)
{
try {
castleaccount33 ccc = db.castleaccount33.Where(x => x.CustomerId == cst.custid).FirstOrDefault();
if (ccc != null)
{
TempData["not"] = "Delete Operation unSuccessful as customer has an account";
return(RedirectToAction("Viewdet"));
}
else
{
int rows = db.delete_castle(cst.custid);
if (rows > 0)
{
TempData["second"] = "Delete Operation Successful";
return(RedirectToAction("Viewdet"));
}
else
{
ViewBag.Message = "Delete Operation Failed";
return(View("Error"));
}
}
}catch (Exception e)
{
ViewBag.Message = "Delete Operation Failed";
return(View("Error"));
}
}
public ActionResult withdrawldetails()
{
int dp = int.Parse(Session["dp"].ToString());
ct = db.castleaccount33.Where(x => x.AccountId == dp).FirstOrDefault();
ViewBag.actid = ct.AccountId;
ViewBag.csid = ct.CustomerId;
ViewBag.actp = ct.AccountType;
ViewBag.amt = ct.Balance;
return(View(ct));
}
public ActionResult searchaccountdetails()
{
int ac = int.Parse(Session["ac"].ToString());
castleaccount33 cstt = db.castleaccount33.Where(x => x.AccountId == ac).FirstOrDefault();
ViewBag.actid = cstt.AccountId;
ViewBag.csid = cstt.CustomerId;
ViewBag.asts = cstt.AccountStatus;
ViewBag.amt = cstt.Balance;
return(View());
}
public ActionResult ViewTransfer()
{
int id1 = int.Parse(Session["id1"].ToString());
int id2 = int.Parse(Session["id2"].ToString());
int bal1 = int.Parse(Session["bal1"].ToString());
int bal2 = int.Parse(Session["bal2"].ToString());
castleaccount33 ob1 = db.castleaccount33.Where(x => x.AccountId == id1).FirstOrDefault();
castleaccount33 ob2 = db.castleaccount33.Where(x => x.AccountId == id2).FirstOrDefault();
ViewBag.src = ob1.AccountId;
ViewBag.oldbs = bal1;
ViewBag.newbs = ob1.Balance;
ViewBag.tgt = ob2.AccountId;
ViewBag.oldbt = bal2;
ViewBag.newbt = ob2.Balance;
return(View());
}
public ActionResult Transfer()
{
castleaccount33 acob = new castleaccount33();
List <SelectListItem> srcac = new List <SelectListItem>();
srcac = db.castleaccount33.Select(x => new SelectListItem {
Text = x.AccountId.ToString(), Value = x.AccountId.ToString()
}).ToList();
List <SelectListItem> tgtac = new List <SelectListItem>();
tgtac = db.castleaccount33.Select(x => new SelectListItem {
Text = x.AccountId.ToString(), Value = x.AccountId.ToString()
}).ToList();
acob.srcac = srcac;
acob.tgtac = tgtac;
return(View(acob));
}
public ActionResult withdrawldetails(string n)
{
try {
castleaccount33 tt = db.castleaccount33.Where(x => x.AccountId == ct.AccountId).FirstOrDefault();
if (tt != null && tt.AccountStatus == "Inactive")
{
TempData["fll"] = "Withdrawl fail as account is inactive";
return(RedirectToAction("ViewTransaction"));
}
else
{
int ab = int.Parse(n);
ct.withdrawlamount = ab;
ObjectParameter para = new ObjectParameter("flag", typeof(int));
para.Value = 0;
ObjectParameter opara = new ObjectParameter("TransactionId", typeof(int));
opara.Value = 0;
db.withdrawl(ct.AccountId, "Withdrawl Successful", ct.withdrawlamount, para, opara);
if (Convert.ToInt16(para.Value) == 1)
{
TempData["with"] = "Withdrawl Successful";
return(RedirectToAction("ViewTransaction"));
}
else if (Convert.ToInt16(para.Value) == 0)
{
TempData["fail"] = "Withdrawl fail";
return(RedirectToAction("ViewTransaction"));
}
}
return(View());
}
catch (Exception e)
{
return(View("Error"));
}
}
public ActionResult DeleteAccount(int id)
{
castleaccount33 cstl = db.castleaccount33.Where(x => x.AccountId == id).FirstOrDefault();
return(View(cstl));
}
public ActionResult AddAccount(castleaccount33 csob /*,string CustomerId,string AccountType,string Balance*/)
{
try {
//csob.amount = 0;
//csob.depositamount = 0;
//csob.withdrawlamount = 0;
// castleaccount33 csob = new castleaccount33();
//if (ModelState.IsValid)
//{
ObjectParameter flag = new ObjectParameter("flagg", typeof(int));
flag.Value = 0;
db.addaccount33(csob.CustomerId, csob.AccountType, csob.ShowMessage = "Account Creation successful", csob.AccountStatus = "Active", csob.Balance, flag);
if (Convert.ToInt16(flag.Value) == 1)
{
// db.addaccount33(csob.CustomerId, csob.AccountType, csob.ShowMessage = "Account Creation successful", csob.AccountStatus = "Active", csob.Balance, flag);
TempData["acc"] = "Account added successfully";
return(RedirectToAction("ViewAccount"));
}
else if (Convert.ToInt16(flag.Value) == 0)
{
TempData["asc"] = "Account cannot be added as CustomerId is inactive";
return(RedirectToAction("ViewAccount"));
}
else if (Convert.ToInt16(flag.Value) == 2)
{
TempData["sim"] = "Account cannot be added as given CustomerId already has an account of similar type ";
return(RedirectToAction("ViewAccount"));
}
return(View());
//}
//else
//{
// castleaccount33 csob1 = new castleaccount33();
// List<SelectListItem> acctype = new List<SelectListItem>()
//{
// new SelectListItem() {Text="Current",Value="Current"},
// new SelectListItem() {Text="Savings",Value="Savings"},
//};
// List<SelectListItem> cidlist = new List<SelectListItem>();
// cidlist = db.Custdet_1288.Select(x => new SelectListItem { Text = x.custid.ToString(), Value = x.custid.ToString() }).ToList();
// csob1.cidlist = cidlist;
// csob1.acctype = acctype;
// return View(csob1);
//}
}
catch (Exception e)
{
return(View("Error"));
}
}
