public ActionResult CarReturnRequest(Car_Base oReq)
{
if (ModelState.IsValid)
{
ViewBag.Result = iCarRentalRepository.CarReturnRequest(oReq);
}
return(View());
}
public string CarDeRegistration(Car_Base 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_REGISTRATION";
objCmd.Parameters.Add(new SqlParameter("@FLAG", "CAR_DEREGISTRATION"));
objCmd.Parameters.Add(new SqlParameter("@CAR_NUMBER", oDetails.CarNumber));
objCmd.CommandTimeout = 0;
SqlDataAdapter objDa = new SqlDataAdapter(objCmd);
objDa.Fill(dt);
}
}
return(dt.Rows[0]["Result"].ToString());;
}
