public ActionResult Deposit(AccountSearch PD)
{
if (PD.DepositAmount == 0 || PD.DepositAmount < 0)
{
TempData["AlertMessage"] = "Please enter some valid amount to deposit.";
return(View("Deposit", PD));
}
else
{
ViewBag.accid = PD.AccountID;
ViewBag.BalBeforwith = PD.BalanceAmount;
int latbalance = PD.BalanceAmount + PD.DepositAmount;
CreateCustomerAccounts2porDbData objad = new CreateCustomerAccounts2porDbData();
int mi = objad.depositamount(PD, latbalance);
if (mi > 0)
{
if (Request.HttpMethod == "POST")
{
TempData["AlertMessage"] = "Amount INR " + PD.DepositAmount + " deposited successfully.";
}
ViewBag.latbalance = latbalance;
return(View("AfterDeposit"));
}
else
{
return(RedirectToAction("Exception"));
}
}
}
public void DownloadWordAccountDetails()
{
CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData();
AccountSearch acc = new AccountSearch();
acc.AccountDATA = obj.AccountSearch(Convert.ToInt32(Session["acc_data"]), Session["acc_mode"].ToString());
GridView gv = new GridView();
gv.DataSource = acc.AccountDATA;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=accountdetails.doc");
//Response.ContentType = "application/vnd.ms-word ";
//Response.Write(gv);
Response.Charset = "";
Response.ContentType = "application/vnd.ms-word ";
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
gv.RenderControl(hw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
public ActionResult ViewAllAccount()
{
CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData();
List <AccountSearch> clist = obj.viewALLAccount();
return(View(clist));
}
public ActionResult InsertCustomer(CreateCustomerAccounts2por meth)
{
if (ModelState.IsValid)
{
DataAccessLayer.DBManager obj = new DataAccessLayer.DBManager();
int check = obj.checkCustomer(meth.CustomerID, "ByCustomerID");
if (check > 0)
{
CreateCustomerAccounts2porDbData ab = new CreateCustomerAccounts2porDbData();
int result = ab.insertdata(meth);
if (result == 0)
{
return(RedirectToAction("Exception"));
}
ViewData["Result"] = result;
TempData["AlertMessage"] = "Account is created successfully with " + result + " AccountID";
ModelState.Clear();
return(View());
}
else
{
TempData["AlertMessage"] = "Requested customer ID is not present in system.";
return(View());
}
}
else
{
return(View());
}
}
public ActionResult transfer(int id)
{
CreateCustomerAccounts2porDbData objDB = new CreateCustomerAccounts2porDbData();
DataSet ds = objDB.AccountSearch(id, "ByAccountID");
transfer_amount PD = new transfer_amount();
PD.source_account_id = Convert.ToInt32(ds.Tables[0].Rows[0]["AccountID"].ToString());
return(View(PD));
}
public ActionResult AccountsearchExecutive(int data, string mode)
{
CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData();
AccountSearch acc = new AccountSearch();
acc.AccountDATA = obj.AccountSearch(data, mode);
return(View(acc));
}
public ActionResult AccountById(int data, string mode)
{
CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData();
AccountSearch acc = new AccountSearch();
Session["acc_data"] = data;
Session["acc_mode"] = mode;
acc.AccountDATA = obj.AccountSearch(data, mode);
return(View(acc));
}
public ActionResult Withdraw(int id)
{
CreateCustomerAccounts2porDbData objDB = new CreateCustomerAccounts2porDbData();
DataSet ds = objDB.AccountSearch(id, "ByAccountID");
AccountSearch PD = new AccountSearch();
PD.AccountID = Convert.ToInt32(ds.Tables[0].Rows[0]["AccountID"].ToString());
PD.CustomerID = Convert.ToInt32(ds.Tables[0].Rows[0]["CustomerID"].ToString());
PD.AccountType = ds.Tables[0].Rows[0]["AccountType"].ToString();
PD.BalanceAmount = Convert.ToInt32(ds.Tables[0].Rows[0]["DepositAmount"].ToString());
return(View("Withdraw", PD));
}
public ActionResult DeleteAccount(int id, int accountID)
{
CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData();
DataSet ds = obj.AccountSearch(id, "ByCustomerID");
AccountSearch MB = new AccountSearch();
//MB.AccountID = Convert.ToInt32(ds.Tables[0].Rows[0]["AccountID"].ToString());
MB.CustomerID = Convert.ToInt32(ds.Tables[0].Rows[0]["CustomerID"].ToString());
MB.AccountType = ds.Tables[0].Rows[0]["AccountType"].ToString();
MB.DepositAmount = Convert.ToInt32(ds.Tables[0].Rows[0]["DepositAmount"].ToString());
MB.AccountID = accountID;
return(View(MB));
}
public ActionResult viewAccountStatement(int Temp_id, int Cycle)
{
CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData();
List <AccountSearch> list = obj.viewAccountStatement(Temp_id, Cycle);
Session["id"] = Temp_id;
Session["Cycle"] = Cycle;
if (list == null)
{
return(RedirectToAction("Exception"));
}
return(View(list));
}
public ActionResult DeleteAccount(AccountSearch MB)
{
int c_id = Convert.ToInt32(MB.CustomerID);
int bal = Convert.ToInt32(MB.DepositAmount);
int a_id = Convert.ToInt32(MB.AccountID);
CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData();
int result = obj.DeleteAccount(c_id, bal, a_id);
if (result == 0)
{
return(RedirectToAction("Exception"));
}
ViewData["resultDelete"] = result;
return(View());
}
public ActionResult Withdraw(AccountSearch PD)
{
if (!(PD.withdrawamount == 0 || PD.BalanceAmount == 0 || PD.withdrawamount < 0))
{
if (PD.withdrawamount <= PD.BalanceAmount)
{
ViewBag.accid = PD.AccountID;
ViewBag.BalBeforwith = PD.BalanceAmount;
int latbalance = PD.BalanceAmount - PD.withdrawamount;
CreateCustomerAccounts2porDbData objad = new CreateCustomerAccounts2porDbData();
int mi = objad.withdrawamount(PD, latbalance);
if (mi > 0)
{
if (Request.HttpMethod == "POST")
{
TempData["AlertMessage"] = "Amount INR " + PD.withdrawamount + " withdrawn successfull.";
}
ViewBag.latbalance = latbalance;
return(View("AfterWithdraw"));
}
else
{
return(RedirectToAction("Exception"));
}
}
else
{
if (Request.HttpMethod == "POST")
{
TempData["AlertMessage"] = "Withdraw is not allowed choose a amount smaller than balance amount.";
}
return(View("Withdraw", PD));
}
}
else
{
if (PD.withdrawamount == 0 || PD.withdrawamount < 0)
{
TempData["AlertMessage"] = "Please enter some valid amount to withdraw.";
}
else if (PD.BalanceAmount == 0)
{
TempData["AlertMessage"] = "Please deposit some amount.";
}
return(View("Withdraw", PD));
}
}
public void DownloadExcelAccountStatement()
{
CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData();
List <AccountSearch> list = obj.viewAccountStatement(Convert.ToInt32(Session["id"]), Convert.ToInt32(Session["Cycle"]));
WebGrid grid = new WebGrid(source: list);
string gridData = grid.GetHtml(columns: grid.Columns(
grid.Column("TransactionID", "Transaction ID"),
grid.Column("TransactionDescription", "Description"),
grid.Column("TransactionDate", "Date(mm-dd-yyyy)"),
grid.Column("TransactionAmount", "Amount(INR)")
)).ToString();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=AccountStatementexcel.xls");
Response.ContentType = "application/excel";
Response.Write(gridData);
Response.End();
}
public void DownloadExcelAllAccount()
{
CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData();
List <AccountSearch> clist = obj.viewALLAccount();
WebGrid grid = new WebGrid(source: clist);
string gridData = grid.GetHtml(columns: grid.Columns(
grid.Column("AccountID", "Account ID"),
grid.Column("Customer_Id", "Customer ID"),
grid.Column("AccountType", "Account Type"),
grid.Column("account_status", "Status"),
grid.Column("account_message", "Message"),
grid.Column("update_date", "Last Updated(mm-dd-yyyy)")
)).ToString();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=accountexcel.xls");
Response.ContentType = "application/excel";
Response.Write(gridData);
Response.End();
}
public ActionResult AccountStatement(AccountSearch acc)
{
if (!ModelState.IsValid)
{
CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData();
int temp_id = acc.AccountID;
int check = obj.checkAccount(temp_id, "ByAccountID");
if (check > 0)
{
int cycle = Convert.ToInt32(acc.transaction_no);
return(RedirectToAction("viewAccountStatement", new { Temp_id = temp_id, Cycle = cycle }));
}
else
{
if (Request.HttpMethod == "POST")
{
TempData["AlertMessage"] = "Requested account is not present in the system.";
ModelState.Clear();
}
return(View());
}
}
return(View());
}
public ActionResult AccountsearchforExecutive(AccountSearch cu)
{
if (!ModelState.IsValid)
{
CreateCustomerAccounts2porDbData obj = new CreateCustomerAccounts2porDbData();
int temp_id = cu.Customer_Id;
string temp_search = cu.Account_Search;
int check = obj.checkAccount(temp_id, temp_search);
if (check > 0)
{
return(RedirectToAction("AccountsearchExecutive", new { data = temp_id, mode = temp_search }));
}
else
{
if (Request.HttpMethod == "POST")
{
TempData["AlertMessage"] = "Requested account is not present in system.";
ModelState.Clear();
}
return(View());
}
}
return(View());
}
public ActionResult transfer(transfer_amount tu)
{
if (ModelState.IsValid) // Check the model state for any validation errors
{
List <int> balist = new List <int>();
CreateCustomerAccounts2porDbData cu = new CreateCustomerAccounts2porDbData();
if (tu.source_account_id != tu.target_account_id)
{
int bal1 = cu.viewbalance(tu.source_account_id);
int bal2 = cu.viewbalance(tu.target_account_id);
if (bal1 < 0 || bal2 < 0)
{
return(RedirectToAction("Exeption"));
}
balist.Add(bal1);
balist.Add(bal2);
if (tu.Transfer_amount > 0)
{
if (bal1 >= tu.Transfer_amount)
{
int a = bal1;
int b = bal2;
int c = tu.Transfer_amount;
a = a - c;
b = b + c;
balist.Add(a);
balist.Add(b);
int m = cu.transfer_amount(balist, tu);
int firstaccountupdate = balist.ElementAt(2);
int secondaccountupdate = balist.ElementAt(3);
if (m != 0)
{
if (m == 1)
{
ViewBag.acc1 = tu.source_account_id;
ViewBag.acc2 = tu.target_account_id;
ViewBag.balbefupdateacc1 = bal1;
ViewBag.balbefupdateacc2 = bal2;
ViewBag.balaftupdateacc1 = firstaccountupdate;
ViewBag.balaftupdateacc2 = secondaccountupdate;
ViewBag.amount = tu.Transfer_amount;
if (Request.HttpMethod == "POST")
{
TempData["AlertMessage"] = "Amount INR " + tu.Transfer_amount + " has been transferred succesfully.";
}
return(View("aftertransfer"));
}
else if (m == 2)
{
TempData["AlertMessage"] = "Please enter existing target account ID.";
}
}
else if (m == 0)
{
return(RedirectToAction("Exception"));
}
}
else
{
if (Request.HttpMethod == "POST")
{
string sp = "Amount should be less than or equal to " + bal1 + " Rs.";
TempData["AlertMessage"] = sp;
}
return(View());
}
}
else
{
TempData["AlertMessage"] = "Please enter some valid amount to transfer.";
}
return(View());
}
else
{
TempData["AlertMessage"] = "Target account ID can not be same as source account ID.";
}
return(View());
}
else
{
return(View());
}
}