public ActionResult ServiceAppointment() { ServiceApointment sa = new ServiceApointment(); IRepository rep = new Repository(); sa.locations = rep.showLocations(); //for car years:- int[] years = new int[38]; int start = 1980; for (int i = 0; i <= 37; i++) { years[i] = start; start++; } List <int> yearslist = years.ToList <int>(); sa.caryear = new List <SelectListItem>(); foreach (int year in yearslist) { SelectListItem si = new SelectListItem { Value = year.ToString(), Text = year.ToString() }; sa.caryear.Add(si); } return(View(sa)); }
public int serviceAppointment(ServiceApointment sa, string date) { int loginstatus; try { string sql = "insert into ServiceAppointments values(@LocationName, @Year, @Make, @Model, @Date, @Time, @FirstName, @LastName, @Email, @Phone, @OilChange, @TyreServices, @BrakeServices, @EmmisionCheckup, @Maintenance, @ElectricalServices, @HeatingCoolingServices, @BatteryServices, @FluidFlush)"; List <SqlParameter> parmList = new List <SqlParameter>(); SqlParameter p1 = new SqlParameter("@LocationName", SqlDbType.NVarChar); SqlParameter p2 = new SqlParameter("@Year", SqlDbType.Int); SqlParameter p3 = new SqlParameter("@Make", SqlDbType.NVarChar); SqlParameter p4 = new SqlParameter("@Model", SqlDbType.NVarChar); SqlParameter p6 = new SqlParameter("@Date", SqlDbType.NVarChar); SqlParameter p7 = new SqlParameter("@Time", SqlDbType.NVarChar); SqlParameter p8 = new SqlParameter("@FirstName", SqlDbType.NVarChar); SqlParameter p9 = new SqlParameter("@LastName", SqlDbType.NVarChar); SqlParameter p10 = new SqlParameter("@Email", SqlDbType.NVarChar); SqlParameter p11 = new SqlParameter("@Phone", SqlDbType.Int); SqlParameter p12 = new SqlParameter("@OilChange", SqlDbType.NVarChar); SqlParameter p13 = new SqlParameter("@TyreServices", SqlDbType.NVarChar); SqlParameter p14 = new SqlParameter("@BrakeServices", SqlDbType.NVarChar); SqlParameter p15 = new SqlParameter("@EmmisionCheckup", SqlDbType.NVarChar); SqlParameter p16 = new SqlParameter("@Maintenance", SqlDbType.NVarChar); SqlParameter p17 = new SqlParameter("@ElectricalServices", SqlDbType.NVarChar); SqlParameter p18 = new SqlParameter("@HeatingCoolingServices", SqlDbType.NVarChar); SqlParameter p19 = new SqlParameter("@BatteryServices", SqlDbType.NVarChar); SqlParameter p20 = new SqlParameter("@FluidFlush", SqlDbType.NVarChar); p1.Value = sa.locationselected; parmList.Add(p1); p2.Value = sa.caryearselected; parmList.Add(p2); p3.Value = sa.carmakeselected; parmList.Add(p3); p4.Value = sa.carmodelselected; parmList.Add(p4); p6.Value = date; parmList.Add(p6); p7.Value = sa.timeselected; parmList.Add(p7); p8.Value = sa.firstname; parmList.Add(p8); p9.Value = sa.lastname; parmList.Add(p9); p10.Value = sa.email; parmList.Add(p10); p11.Value = sa.phone; parmList.Add(p11); p12.Value = sa.oilChange; parmList.Add(p12); p13.Value = sa.tyreServices; parmList.Add(p13); p14.Value = sa.brakeservices; parmList.Add(p14); p15.Value = sa.emmisionCheckup; parmList.Add(p15); p16.Value = sa.maintenance; parmList.Add(p16); p17.Value = sa.electricalServices; parmList.Add(p17); p18.Value = sa.heatingCoolingServices; parmList.Add(p18); p19.Value = sa.batteryServices; parmList.Add(p19); p20.Value = sa.fluidFlush; parmList.Add(p20); loginstatus = _idac.InsertUpdateDelete(sql, parmList); } catch (Exception) { throw; } return(loginstatus); }
public ActionResult ServiceAppointment(ServiceApointment sa, string date) { IRepository rep = new Repository(); int saveform = 0; saveform = rep.serviceAppointment(sa, date); if (saveform != 0) { TempData["Success"] = "Appointment Booked successfully."; return(RedirectToAction("Index", "Home")); } else { TempData["Success"] = "Appointment not sucessfull. Please try again later.!"; return(RedirectToAction("Index", "Home")); } }