public ActionResult CreateCustomer(CustomerDetails_3 c, FormCollection f) { //c.State_3 = f["State_Name_3"]; // c.City_3 = f["City_Name_3"]; int state_id = Convert.ToInt32(c.State_3); int city_id = Convert.ToInt32(c.City_3); var temp = db.Select_State_3.Where(a => a.State_ID_3 == state_id).ToList(); if (temp != null) { foreach (var l in temp) { c.State_3 = l.State_Name_3; } } var temp1 = db.Select_City_3.Where(x => x.City_ID_3 == city_id).ToList(); if (temp1 != null) { foreach (var l in temp1) { c.City_3 = l.City_Name_3; } } if (ModelState.IsValid) { ObjectParameter op = new ObjectParameter("CustomerID_3", 0); db.create_customer_3(c.CustomerSSID_3, c.CustomerName_3, c.Age_3, c.CustomerAddress_3, c.State_3, c.City_3, op); db.SaveChanges(); ModelState.Clear(); if (Convert.ToInt32(op.Value) == 0) { Response.Write("<script>alert('Registration Unsuccessful!!! Try Re-Registering')</script>"); } else { Response.Write("<script>alert('Registration Successful!!! The Customer ID is : " + op.Value + "')</script>"); State_List(); return(View()); } } State_List(); 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")); }