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