public string CarRentingRequest(CarRentingRequest oDetails) { DataTable dt = new DataTable(); ConnectionStringSettings objCSS = ConfigurationManager.ConnectionStrings["ConnectionString"]; using (SqlConnection objCnn = new SqlConnection(objCSS.ConnectionString)) { using (SqlCommand objCmd = new SqlCommand()) { objCmd.Connection = objCnn; objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "SP_CAR_RENTING"; objCmd.Parameters.Add(new SqlParameter("@FLAG", "REQUEST_RENTING")); objCmd.Parameters.Add(new SqlParameter("@CAR_NUMBER", oDetails.CarNumber)); objCmd.Parameters.Add(new SqlParameter("@CUSTOMER_NAME", oDetails.CustomerName)); objCmd.Parameters.Add(new SqlParameter("@REQUESTED_BY", 1)); objCmd.CommandTimeout = 0; SqlDataAdapter objDa = new SqlDataAdapter(objCmd); objDa.Fill(dt); } } return(dt.Rows[0]["Result"].ToString());; }
public ActionResult CarRentingRequest(CarRentingRequest oReq) { if (ModelState.IsValid) { ViewBag.Result = iCarRentalRepository.CarRentingRequest(oReq); } return(View()); }