public ActionResult withdrawmoney(FormCollection f, AccountDetails_3 c)
{
DB03TMS155_1718Entities db = new DB03TMS155_1718Entities();
ObjectParameter o = new ObjectParameter("flag", 0);
int amount = Convert.ToInt32(f["txtWithdraw"]);
AccountDetails_3 p2 = new AccountDetails_3();
p2 = db.AccountDetails_3.Find(Convert.ToInt64(Session["Account_ID"]));
if (p2 == null)
{
Response.Write("<script>alert('Account ID does not exist')</script>");
}
else
{
db.sp_withdraw(Convert.ToInt64(Session["Account_ID"]), amount, o);
if (Convert.ToInt32(o.Value) == 0)
{
TempData["AlertMessage"] = 10;
return(RedirectToAction("withdrawmoney"));
}
else
{
TempData["AlertMessage"] = 1;
return(RedirectToAction("Viewaftertrans"));
}
}
return(View());
}
//if (a.CustomerID_3 == 0 || a.CustomerID_3 == null)
//{
// TempData["id"] = a.AccountID_3;
//}
//else if (a.AccountID_3 == 0 || a.AccountID_3 == null)
//{
// TempData["id"] = a.CustomerID_3;
//}
//else if (a.CustomerID_3 == 0 && a.AccountID_3 == 0)
//{
// Response.Write("<script>alert('Enter either Customer Id or Account ID')</script>");
//}
//return RedirectToAction("SearchAccount1");
public ActionResult SearchAccount1(AccountDetails_3 a)
{
List <SearchAccount_fnl_Result> acclist = new List <SearchAccount_fnl_Result>();
acclist = db.SearchAccount_fnl(Convert.ToInt32(TempData["id"])).ToList();
return(View(acclist));
}
public ActionResult transfer(TransactionDetails_3 c, FormCollection f)
{
Session["Account_ID"] = f["txtAccountID1"];
long acc1 = Convert.ToInt64(f["txtAccountID1"]);
long acc2 = Convert.ToInt64(f["txtAccountID2"]);
int amount = Convert.ToInt32(f["txtAmount"]);
AccountDetails_3 p1 = new AccountDetails_3();
AccountDetails_3 p2 = new AccountDetails_3();
p1 = db.AccountDetails_3.Find(acc1);
p2 = db.AccountDetails_3.Find(acc2);
if (p1 == null || p2 == null)
{
Response.Write("<script>alert('Account ID does not exist')</script>");
}
else
{
ObjectParameter o = new ObjectParameter("flag", 0);
db.sp_transfer(acc1, acc2, amount, o);
if (Convert.ToInt32(o.Value) == 0)
{
TempData["AlertMessage"] = 1;
return(RedirectToAction("transfer"));
}
else
{
TempData["AlertMessage"] = 2;
return(RedirectToAction("Viewaftertrans"));
}
}
return(View());
}
public ActionResult withdrawmoney()
{
DB03TMS155_1718Entities db = new DB03TMS155_1718Entities();
long id = Convert.ToInt64(Session["Account_ID"]);
AccountDetails_3 abc = db.AccountDetails_3.Find(id);
return(View(abc));
}
public ActionResult Viewaftertrans()
{
long id = Convert.ToInt64(Session["Account_ID"]);
AccountDetails_3 o = new AccountDetails_3();
o = db.AccountDetails_3.Find(id);
return(View(o));
}
public ActionResult AccountStatement(AccountDetails_3 acc, FormCollection f)
{
try {
long id = Convert.ToInt64(Session["Account_ID"]);
AccountDetails_3 abc = db.AccountDetails_3.Find(id);
//if (abc == null)
//{
// TempData["AlertMessage"] = 145;
// return RedirectToAction("AccountStatement");
//}
//else
//{
Session["AccountID"] = f["AccountID"];
Session["TransactionNumber"] = f["TransactionNumber"];
Session["StartDate"] = f["StartDate"];
Session["EndDate"] = f["EndDate"];
ObjectParameter d = new ObjectParameter("id", 0);
db.SP_Accountidcheckintrans_3(Convert.ToInt64(Session["AccountID"]), d);
if (Convert.ToInt64(d.Value) == 0)
{
Response.Write("<script>alert('invalid Account_ID')</script>");
return(View());
}
if (f["CheckMethod"] == "number")
{
return(RedirectToAction("TransactionByNumber"));
}
else if (f["CheckMethod"] == "date")
{
return(RedirectToAction("Viewtransbydate"));
}
else
{
Response.Write("<script>alert('Select the Account Statement type!!')</script>");
//return View();
}
}
catch (Exception e)
{
Response.Write("<script>alert('Enter Account_ID')</script>");
}
//}
return(View());
}
public ActionResult depositmoney()
{
DB03TMS155_1718Entities db = new DB03TMS155_1718Entities();
long id = Convert.ToInt64(Session["Account_ID"]);
AccountDetails_3 abc = db.AccountDetails_3.Find(id);
if (abc == null)
{
TempData["AlertMessage"] = 18;
return(RedirectToAction("searchdeposit"));
}
else
{
return(View(abc));
}
return(View());
}
public ActionResult CreateAccount(AccountDetails_3 acc)
{
try {
if (ModelState.IsValid)
{
ObjectParameter d = new ObjectParameter("id", 0);
db.accountcheckteam3(acc.CustomerID_3, d);
if (Convert.ToInt64(d.Value) == 0)
{
Response.Write("<script>alert('invalid customer_ID')</script>");
return(View());
}
else
{
ObjectParameter s = new ObjectParameter("accountid", 0);
db.createaccountteam3(acc.CustomerID_3, acc.AccountType_3, acc.Balance_3, s);
long accid = Convert.ToInt64(s.Value);
// string bal = Convert.ToString(acc.AccountType_3);
if (accid == 0)
{
Response.Write("<script>alert(' user already have an account" + acc.AccountType_3 + "')</script>");
}
else
{
Response.Write("<script>alert('Successfully created a account with account_ID=" + accid + "')</script>");
}
db.SaveChanges();
ModelState.Clear();
}
}
}
catch (Exception e)
{
Response.Write("<script>alert('Please enter Custromer_ID')</script>");
}
return(View("CreateAccount"));
}
public ActionResult depositmoney(FormCollection f)
{
DB03TMS155_1718Entities db = new DB03TMS155_1718Entities();
ObjectParameter o = new ObjectParameter("flag", 0);
int amount = Convert.ToInt32(f["txtDeposit"]);
AccountDetails_3 p2 = new AccountDetails_3();
p2 = db.AccountDetails_3.Find(Convert.ToInt64(Session["Account_ID"]));
db.sp_deposit1(Convert.ToInt64(Session["Account_ID"]), amount, o);
if (Convert.ToInt32(o.Value) == 0)
{
TempData["AlertMessage"] = 13;
return(RedirectToAction("depositmoney"));
}
else
{
TempData["AlertMessage"] = 1;
return(RedirectToAction("Viewaftertrans"));
}
return(View());
}
public ActionResult AccountDelete(AccountDetails_3 acc)
{
//try {
ObjectParameter d = new ObjectParameter("id", 0);
db.accountcheckdeleteteam3(Convert.ToInt64(acc.AccountID_3), d);
//long acid = db.AccountDetails_3.Find(Convert.ToInt64(AccountID_3));
if (Convert.ToInt64(d.Value) > 0)
{
ObjectParameter t = new ObjectParameter("type", 0);
db.ReturnType(t, Convert.ToInt64(acc.AccountID_3));
string A = Convert.ToString(t.Value);
//ObjectParameter t = new ObjectParameter("type", 0);
//db.ReturnType(t, Convert.ToInt64(acc.AccountID_3));
//string A = Convert.ToString(t.Value);
if (Convert.ToString(acc.AccountType_3).Equals(A))
{
// ObjectParameter sat = new ObjectParameter("status", 0);
// string sats = Convert.ToString(sat.Value);
// if (sats == "INACTIVE")
// {
// Response.Write("<script>alert('account has been already deleted ')</script>");
// }
ObjectParameter s = new ObjectParameter("balance", 0);
ObjectParameter sat = new ObjectParameter("status", 0);
string sats = Convert.ToString(sat.Value);
db.DeleteAccountteam3(Convert.ToInt64(acc.AccountID_3), Convert.ToString(acc.AccountType_3), s, sat);
long bal = Convert.ToInt64(s.Value);
if (sats == "INACTIVE")
{
Response.Write("<script>alert('account has been already deleted ')</script>");
}
else
{
if (bal > 0)
{
TempData["AlertMessage"] = 52;
return(RedirectToAction("searchwithdraw", "Transaction"));
}
else
{
//db.DeleteAccountteam3(Convert.ToInt64(acc.AccountID_3), Convert.ToString(acc.AccountType_3), s, sat);
Response.Write("<script>alert('account has been deleted successfully')</script>");
}
}
}
else
{
Response.Write("<script>alert('invalid Account_type')</script>");
}
}
//else
//{
// Response.Write("<script>alert('invalid Account_ID')</script>");
// }
else
{
Response.Write("<script>alert('invalid Account_ID')</script>");
}
// }
//catch (Exception e)
//{
// // if (Convert.ToInt64(d.Value) > 0)
// Response.Write("<script>alert(' Please enterAccount_ID and AccountType')</script>");
// // Response.Write("<script>alert(' Please enter Account_ID')</script>");
//}
return(View());
}
