public ActionResult customerEdit(sp_viewbyid_CustomerTable_group2_Result tablecustomer) { try { ViewBag.username = Session["userName"]; ObjectParameter retCustID = new ObjectParameter("customeridout", typeof(int)); DateTime date = new DateTime(); date = Convert.ToDateTime(tablecustomer.Dob); int age = DateTime.Today.Year - date.Year; if (age < 18 || age > 90 || age == 0) { ViewBag.Show = "Customer is not in the age range of 18 to 90"; return(View()); } else { int State = Convert.ToInt32(Request.Form["State"]); int City = Convert.ToInt32(Request.Form["City"]); int res = bank.sp_CustomerTable_group2(tablecustomer.CustomerID, tablecustomer.AadhaarID, tablecustomer.CustomerName, tablecustomer.Dob, tablecustomer.AddressLine1, tablecustomer.AddressLine2, State, City, tablecustomer.Contact, tablecustomer.Email, retCustID); this.bank.SaveChanges(); TempData["Message"] = "Customer Updated Successfully"; return(RedirectToAction("ListCustomer")); } } catch (Exception e) { throw e; } }
public ActionResult Delete(long id, sp_viewbyid_CustomerTable_group2_Result byid) { try { ViewBag.username = Session["userName"]; if (byid.NoofAccounts == 0) { int res = bank.sp_deletebyid_CustomerTable_group2(id); this.bank.SaveChanges(); TempData["Mess5"] = "Customer Deactivated Succesfully"; return(RedirectToAction("ListCustomer")); } else { TempData["mess6"] = "Unable To Delete as the account has money"; return(View()); } } catch (Exception e) { throw e; } }
public ActionResult Delete(long?id) { try { ViewBag.username = Session["userName"]; if (Session["userName"] != null && Session["userroleId"].ToString() == "1") { if (id != null) { sp_viewbyid_CustomerTable_group2_Result byid = new sp_viewbyid_CustomerTable_group2_Result(); byid = bank.sp_viewbyid_CustomerTable_group2(id).FirstOrDefault(); return(View(byid)); } } else { return(Redirect("../login/login")); } return(View()); } catch (Exception e) { throw e; } }
public ActionResult customerEdit(long?id) { ViewBag.username = Session["userName"]; if (Session["userName"] != null && Session["userroleId"].ToString() == "1") { try { sp_viewbyid_CustomerTable_group2_Result ob = bank.sp_viewbyid_CustomerTable_group2(id).FirstOrDefault(); Session["state"] = ob.State; Session["city"] = ob.City; return(View(ob)); } catch (Exception e) { throw e; } } else { return(Redirect("/login/login")); } }