Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public string _SaveUsedCarDetails(JLR_PageDetailsBO BO)
- {
- try
- {
- dt = new DataTable();
- cmd = new SqlCommand("SP_JLR_PageDetail", con);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.Add("@MobileNo", BO.MobileNo);
- cmd.Parameters.Add("@CustomerName", BO.Name);
- cmd.Parameters.Add("@CustomerEmail", BO.Email);
- cmd.Parameters.Add("@UserID", BO.UserID);
- cmd.Parameters.Add("@Manufacturer", BO.Manufacturer);
- cmd.Parameters.Add("@Model", BO.Model);
- cmd.Parameters.Add("@CarModelType", BO.CarModelType);
- cmd.Parameters.Add("@Year", BO.Year);
- cmd.Parameters.Add("@Month", BO.Month);
- cmd.Parameters.Add("@OnRoadValue", BO.OnRoadValue);
- cmd.Parameters.Add("@Owner", BO.Owner);
- cmd.Parameters.Add("@Colour", BO.Colour);
- cmd.Parameters.Add("@Insurance", BO.Insurance);
- cmd.Parameters.Add("@category", BO.category);
- cmd.Parameters.Add("@KMS", BO.KMS);
- cmd.Parameters.Add("@CBUTOCKD", BO.CBUTOCKD);
- cmd.Parameters.Add("@Accidental", BO.Accidental);
- cmd.Parameters.Add("@Fuel", BO.Fuel);
- cmd.Parameters.Add("@REFURBISHMENT", BO.REFURBISHMENT);
- cmd.Parameters.Add("@OFFERPRICE", BO.OFFERPRICE);
- cmd.Parameters.Add("@Mode", "InsertUsedCar");
- da = new SqlDataAdapter(cmd);
- da.Fill(dt);
- return "success";
- }
- catch {
- return "Error";
- }
- }
- public string _SaveLoanEstimatorDetails(JLR_PageDetailsBO BO)
- {
- try
- {
- dt = new DataTable();
- cmd = new SqlCommand("SP_JLR_PageDetail", con);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.Add("@MobileNo", BO.MobileNo);
- cmd.Parameters.Add("@CustomerName", BO.Name);
- cmd.Parameters.Add("@CustomerEmail", BO.Email);
- cmd.Parameters.Add("@UserID", BO.UserID);
- cmd.Parameters.Add("@LoanAmountOnExistingCar", BO.LoanAmountOnExistingCar);
- cmd.Parameters.Add("@RateOfInterest", BO.RateOfInterest);
- cmd.Parameters.Add("@LoanTenure", BO.LoanTenure);
- cmd.Parameters.Add("@Monthlypayment", BO.Monthlypayment);
- cmd.Parameters.Add("@ActualEMI", BO.ActualEMI);
- cmd.Parameters.Add("@EstimatedForeclosure", BO.EstimatedForeclosure);
- cmd.Parameters.Add("@FinalPriceOffered", BO.FinalPriceOffered);
- cmd.Parameters.Add("@OutstandingLoanAmount", BO.OutstandingLoanAmount);
- cmd.Parameters.Add("@NetPositiveValue", BO.NetPositiveValue);
- cmd.Parameters.Add("@Mode", "InsertEstimator");
- da = new SqlDataAdapter(cmd);
- da.Fill(dt);
- return "success";
- }
- catch
- {
- return "Error";
- }
- }
- public string _SaveNewCarDetails(JLR_PageDetailsBO BO)
- {
- try
- {
- dt = new DataTable();
- cmd = new SqlCommand("SP_JLR_PageDetail", con);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.Add("@MobileNo", BO.MobileNo);
- cmd.Parameters.Add("@CustomerName", BO.Name);
- cmd.Parameters.Add("@CustomerEmail", BO.Email);
- cmd.Parameters.Add("@UserID", BO.UserID);
- cmd.Parameters.Add("@Make", BO.Make);
- cmd.Parameters.Add("@CarModel", BO.CarModel);
- cmd.Parameters.Add("@CarType", BO.CarType);
- cmd.Parameters.Add("@Octroi", BO.Octroi);
- cmd.Parameters.Add("@ExShowroomPrice", BO.ExShowroomPrice);
- cmd.Parameters.Add("@Insurance", BO.Insurance);
- cmd.Parameters.Add("@LogisticsCharges", BO.LogisticsCharges);
- cmd.Parameters.Add("@Regcharges", BO.Regcharges);
- cmd.Parameters.Add("@RoadValue", BO.RoadValue);
- cmd.Parameters.Add("@Serviceplan", BO.Serviceplan);
- cmd.Parameters.Add("@Ewarranty", BO.Ewarranty);
- cmd.Parameters.Add("@Accessories", BO.Accessories);
- cmd.Parameters.Add("@Discount", BO.Discount);
- cmd.Parameters.Add("@loanEnclosure", BO.loanEnclosure);
- cmd.Parameters.Add("@DownPayment", BO.DownPayment);
- cmd.Parameters.Add("@SuggestedAmount", BO.SuggestedAmount);
- cmd.Parameters.Add("@ServicePlan_Text", BO.ServicePlan_Text);
- cmd.Parameters.Add("@ExtendedW_Text", BO.ExtendedW_Text);
- cmd.Parameters.Add("@Mode", "InsertNewCar");
- da = new SqlDataAdapter(cmd);
- da.Fill(dt);
- return "success";
- }
- catch
- {
- return "Error";
- }
- }
- public string _SaveFinanceOfferDetails(JLR_PageDetailsBO BO)
- {
- try
- {
- dt = new DataTable();
- cmd = new SqlCommand("SP_JLR_PageDetail", con);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.Add("@MobileNo",BO.MobileNo);
- cmd.Parameters.Add("@CustomerName", BO.Name);
- cmd.Parameters.Add("@CustomerEmail", BO.Email);
- cmd.Parameters.Add("@UserID", BO.UserID);
- cmd.Parameters.Add("@LoanAmount",BO.LoanAmount);
- cmd.Parameters.Add("@OnRoadValue",BO.OnRoadValue);
- cmd.Parameters.Add("@loanEnclosure",BO.loanEnclosure);
- cmd.Parameters.Add("@Mode", "InsertFO");
- da = new SqlDataAdapter(cmd);
- da.Fill(dt);
- return "success";
- }
- catch
- {
- return "Error";
- }
- }
- public string _SaveBalloonPmtDetails(JLR_PageDetailsBO BO)
- {
- try
- {
- dt = new DataTable();
- cmd = new SqlCommand("SP_JLR_PageDetail", con);
- cmd.CommandType = CommandType.StoredProcedure;
- cmd.Parameters.Add("@MobileNo", BO.MobileNo);
- cmd.Parameters.Add("@CustomerName", BO.Name);
- cmd.Parameters.Add("@CustomerEmail", BO.Email);
- cmd.Parameters.Add("@UserID", BO.UserID);
- cmd.Parameters.Add("@LoanAmount", BO.LoanAmount);
- cmd.Parameters.Add("@RegularEMI_3Yr", BO.RegularEMI_3Yr);
- cmd.Parameters.Add("@RegularEMI_5Yr", BO.RegularEMI_5Yr);
- cmd.Parameters.Add("@Mode", "InsertBalloon");
- da = new SqlDataAdapter(cmd);
- da.Fill(dt);
- return "success";
- }
- catch
- {
- return "Error";
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement