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());
}
