public ActionResult Edit(VehicleCategoryViewModel model)
{
//Repopulate the dropdown list of vehicle types without asking SQL again
TempData.Keep();
model.VehicleType = (SelectList)TempData["SelectList"];
if (!ModelState.IsValid)
{
return(View(model));
}
try
{
var FullName = Request.Cookies["userInfo"]["FullName"];
VehicleCategoriesBLL.UpdateVehicleCategory(model, FullName);
//Take our ID with us to the confirmation form
ViewBag.Id = model.Id;
//Clear any temp data
TempData.Clear();
//Determine the kind of SQL transaction we have performed
ViewBag.Message = "updated";
//We can now safely go to the confirmation view
return(View("AddUpdateConfirm"));
}
catch (Exception ex)
{
TempData["ErrorMessage"] = ex.Message;
return(Redirect("~/Admin/Home/Error"));
}
}
//Update the vehicle category record
public static void UpdateVehicleCategory(VehicleCategoryViewModel model, string UpdatedBy)
{
VehicleCategoriesDAL.UpdateVehicleCategory((int)model.Id,
model.VehicleClassType,
model.VehicleTypeID,
model.ImageId,
model.DailyRate,
model.WeeklyRate,
model.WeekendRate,
model.MonthlyRate,
model.NumberOfSeats,
model.NumberOfDoors,
model.BasicDescription,
model.LuggageCapacity,
UpdatedBy);
}
public static VehicleCategoryViewModel GetVehicleList()
{
DataTable dt = VehicleCategoriesDAL.GetVehicleTypes();
var model = new VehicleCategoryViewModel();
var list = new List <VehicleTypeList>();
foreach (DataRow dataRow in dt.Rows)
{
list.Add(new VehicleTypeList
{
Id = (int)dataRow["VehicleTypeID"],
Display = dataRow["VehicleType"].ToString()
});
}
model.VehicleType = new SelectList(list, "id", "Display");
return(model);
}
public async Task <IActionResult> DeleteVehicleCategory([FromBody] VehicleCategoryViewModel vehicleCategoryViewModel)
{
try
{
var _serviceEndPoint = new ServicesEndPoint(_unitOfWork, _emailService);
var vehicleCategory = _Mapper.Map <VehicleCategory>(vehicleCategoryViewModel);
bool result = await _serviceEndPoint.DeleteVehicleCategory(vehicleCategory);
if (!result)
{
return(NotFound(vehicleCategoryViewModel));
}
return(Ok(new { message = "Succesfully Deleted!", result = result }));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task <IActionResult> GetVehicleCategoryById(int vehicleCategoryId)
{
try
{
var _serviceEndPoint = new ServicesEndPoint(_unitOfWork, _emailService);
VehicleCategory tpresult = await _serviceEndPoint.GetVehicleCategoryById(vehicleCategoryId);
VehicleCategoryViewModel result = _Mapper.Map <VehicleCategoryViewModel>(tpresult);
if (result == null)
{
return(NotFound(result));
}
return(Ok(result));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public static int AddNewVehicleCategory(VehicleCategoryViewModel model, string UpdatedBy)
{
var result = VehicleCategoriesDAL.AddNewVehicleCategory(model.VehicleClassType,
model.VehicleTypeID,
model.ImageId,
model.DailyRate,
model.WeeklyRate,
model.WeekendRate,
model.MonthlyRate,
model.NumberOfSeats,
model.NumberOfDoors,
model.BasicDescription,
model.LuggageCapacity,
UpdatedBy);
return(result);
}
//Get the individual vehicle category record
public static VehicleCategoryViewModel GetVehicleCategoryDataset(int CategoryID)
{
//Generate a new empty model
var model = new VehicleCategoryViewModel();
//Get the dataset from SQL
DataSet ds = VehicleCategoriesDAL.GetVehicleCategory(CategoryID);
//Move dataset to the first table
DataTable dt = ds.Tables[0];
//Get the first row from the table and populate the model propertites
DataRow row = dt.Rows[0];
model.Id = CategoryID;
model.BasicDescription = row["BasicDescription"].ToString().Trim();
model.DailyRate = (decimal)row["DailyRate"];
model.LuggageCapacity = (int)row["LuggageCapacity"];
model.MonthlyRate = (decimal)row["MonthlyRate"];
model.NumberOfSeats = (int)row["NumberOfSeats"];
model.NumberOfDoors = (int)row["NumberOfDoors"];
model.VehicleClassType = row["VehicleClassType"].ToString();
model.ImageId = (int)row["ImageId"];
model.VehicleTypeID = (int)row["VehicleTypeID"];
model.WeekendRate = (decimal)row["WeekendRate"];
model.WeeklyRate = (decimal)row["WeeklyRate"];
model.ImageName = row["ImageName"].ToString().Replace(Path.GetExtension(row["ImageName"].ToString()).ToLower(), "_thumb") + Path.GetExtension(row["ImageName"].ToString()).ToLower().Trim();
//Get the second table in order to populate the related dropdown list
dt = ds.Tables[1];
var list = new List <VehicleTypeList>();
foreach (DataRow dataRow in dt.Rows)
{
list.Add(new VehicleTypeList
{
Id = (int)dataRow["VehicleTypeID"],
Display = dataRow["VehicleType"].ToString()
});
}
model.VehicleType = new SelectList(list, "id", "Display");
return(model);
}
