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