public ActionResult AddCustomer(customer_details objCustomer, FormCollection objForm, long SSNID) { int saveVal = 0; if (ModelState.IsValid) { ObjectParameter objParam = new ObjectParameter("Id_out", typeof(int)); objCustomer.State = objForm["dropdownState"]; objCustomer.City = objForm["dropdownCity"]; objCustomer.Status = "Active"; int save = db.usp_save_customer(objCustomer.CustomerId, SSNID, objCustomer.CustomerName, objCustomer.DOB, objCustomer.Address1, objCustomer.Address2, objCustomer.City, objCustomer.State, objCustomer.Status, objParam); this.db.SaveChanges(); saveVal = Convert.ToInt32(objParam.Value); TempData["notice"] = "Customer added successfully with Customer ID:" + saveVal; ModelState.Clear(); //return RedirectToAction("CustomerList"); return(View()); } return(View(objCustomer)); }
public ActionResult Search(customer_details cus) { if (cus.CustomerId != 0) { List <usp_view_by_customerid_or_ssnid_Result> ob = new List <usp_view_by_customerid_or_ssnid_Result>(); //ob = db.usp_view_by_customerid(cus.CustomerId).ToList(); long c = 0; //customer_details c_details = new customer_details(); ob = db.usp_view_by_customerid_or_ssnid(cus.CustomerId, c).ToList(); return(View("dis", ob)); } else if (cus.SSNID != 0) { Int32 c = 0; List <usp_view_by_customerid_or_ssnid_Result> ssn = new List <usp_view_by_customerid_or_ssnid_Result>(); ssn = db.usp_view_by_customerid_or_ssnid(c, cus.SSNID).ToList(); return(View("dis", ssn)); } return(View()); }