public ActionResult Delete(int id, string languageCode)
{
//Get Item
PolicyCarVendorGroupItemLanguage policyCarVendorGroupItemLanguage = new PolicyCarVendorGroupItemLanguage();
policyCarVendorGroupItemLanguage = policyCarVendorGroupItemLanguageRepository.GetItem(id, languageCode);
//Check Exists
if (policyCarVendorGroupItemLanguage == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
PolicyCarVendorGroupItem policyCarVendorGroupItem = new PolicyCarVendorGroupItem();
policyCarVendorGroupItem = policyCarVendorGroupItemRepository.GetPolicyCarVendorGroupItem(id);
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Add Linked Information
policyCarVendorGroupItemLanguageRepository.EditItemForDisplay(policyCarVendorGroupItemLanguage);
//Return View
return(View(policyCarVendorGroupItemLanguage));
}
public ActionResult Delete(int id)
{
//Get PolicyCarVendorGroupItem
PolicyCarVendorGroupItem policyCarVendorGroupItem = new PolicyCarVendorGroupItem();
policyCarVendorGroupItem = policyCarVendorGroupItemRepository.GetPolicyCarVendorGroupItem(id);
//Check Exists
if (policyCarVendorGroupItem == null)
{
ViewData["ActionMethod"] = "GetDelete";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//populate new PolicyCarVendorGroupItem with known PolicyGroup Information
policyCarVendorGroupItemRepository.EditItemForDisplay(policyCarVendorGroupItem);
//Show 'Create' Form
return(View(policyCarVendorGroupItem));
}
// GET: /Edit
public ActionResult Edit(int id, string languageCode)
{
//Get Item
PolicyCarVendorGroupItemLanguage policyCarVendorGroupItemLanguage = new PolicyCarVendorGroupItemLanguage();
policyCarVendorGroupItemLanguage = policyCarVendorGroupItemLanguageRepository.GetItem(id, languageCode);
//Check Exists
if (policyCarVendorGroupItemLanguage == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
PolicyCarVendorGroupItem policyCarVendorGroupItem = new PolicyCarVendorGroupItem();
policyCarVendorGroupItem = policyCarVendorGroupItemRepository.GetPolicyCarVendorGroupItem(id);
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Language SelectList
SelectList languageList = new SelectList(policyCarVendorGroupItemLanguageRepository.GetUnUsedLanguages(id).ToList(), "LanguageCode", "LanguageName");
ViewData["Languages"] = languageList;
policyCarVendorGroupItemLanguageRepository.EditItemForDisplay(policyCarVendorGroupItemLanguage);
return(View(policyCarVendorGroupItemLanguage));
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicyCarVendorGroupItemLanguage policyCarVendorGroupItemLanguage)
{
//Add LanguageName
if (policyCarVendorGroupItemLanguage.LanguageCode != null)
{
LanguageRepository languageRepository = new LanguageRepository();
Language language = new Language();
language = languageRepository.GetLanguage(policyCarVendorGroupItemLanguage.LanguageCode);
if (language != null)
{
policyCarVendorGroupItemLanguage.LanguageName = language.LanguageName;
}
}
//Add PolicyGroupName
PolicyCarVendorGroupItemRepository policyCarVendorGroupItemRepository = new PolicyCarVendorGroupItemRepository();
PolicyCarVendorGroupItem policyCarVendorGroupItem = new PolicyCarVendorGroupItem();
policyCarVendorGroupItem = policyCarVendorGroupItemRepository.GetPolicyCarVendorGroupItem(policyCarVendorGroupItemLanguage.PolicyCarVendorGroupItemId);
if (policyCarVendorGroupItem != null)
{
policyCarVendorGroupItemRepository.EditItemForDisplay(policyCarVendorGroupItem);
policyCarVendorGroupItemLanguage.PolicyGroupName = policyCarVendorGroupItem.PolicyGroupName;
policyCarVendorGroupItemLanguage.PolicyGroupId = policyCarVendorGroupItem.PolicyGroupId;
}
}
public ActionResult Create(PolicyCarVendorGroupItemLanguage policyCarVendorGroupItemLanguage)
{
PolicyCarVendorGroupItem policyCarVendorGroupItem = new PolicyCarVendorGroupItem();
policyCarVendorGroupItem = policyCarVendorGroupItemRepository.GetPolicyCarVendorGroupItem(policyCarVendorGroupItemLanguage.PolicyCarVendorGroupItemId);
//Check Exists
if (policyCarVendorGroupItem == null)
{
ViewData["ActionMethod"] = "CreatePost";
return(View("RecordDoesNotExistError"));
}
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Model from Form
try
{
UpdateModel(policyCarVendorGroupItemLanguage);
}
catch
{
string n = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
n += error.ErrorMessage;
}
}
ViewData["Message"] = "ValidationError : " + n;
return(View("Error"));
}
try
{
policyCarVendorGroupItemLanguageRepository.Add(policyCarVendorGroupItemLanguage);
}
catch (SqlException ex)
{
LogRepository logRepository = new LogRepository();
logRepository.LogError(ex.Message);
ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
return(View("Error"));
}
return(RedirectToAction("List", new { id = policyCarVendorGroupItem.PolicyCarVendorGroupItemId }));
}
//Delete
public void Delete(PolicyCarVendorGroupItem policyCarVendorGroupItem)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_DeletePolicyCarVendorGroupItem_v1(
policyCarVendorGroupItem.PolicyCarVendorGroupItemId,
adminUserGuid,
policyCarVendorGroupItem.VersionNumber
);
}
//GET:List
public ActionResult List(int id, int?page, string sortField, int?sortOrder)
{
//Get PolicyCarVendorGroupItem
PolicyCarVendorGroupItem policyCarVendorGroupItem = new PolicyCarVendorGroupItem();
policyCarVendorGroupItem = policyCarVendorGroupItemRepository.GetPolicyCarVendorGroupItem(id);
//Check Exists
if (policyCarVendorGroupItem == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
//Set Access Rights
ViewData["Access"] = "";
RolesRepository rolesRepository = new RolesRepository();
if (rolesRepository.HasWriteAccessToPolicyGroup(policyCarVendorGroupItem.PolicyGroupId))
{
ViewData["Access"] = "WriteAccess";
}
//Parent Information
ViewData["PolicyCarVendorGroupItemID"] = policyCarVendorGroupItem.PolicyCarVendorGroupItemId;
ViewData["PolicyGroupID"] = policyCarVendorGroupItem.PolicyGroupId;
ViewData["PolicyGroupName"] = policyGroupRepository.GetGroup(policyCarVendorGroupItem.PolicyGroupId).PolicyGroupName;
//SortField+SortOrder settings
if (sortField != "CarAdvice")
{
sortField = "LanguageName";
}
ViewData["CurrentSortField"] = sortField;
if (sortOrder == 1)
{
ViewData["NewSortOrder"] = 0;
ViewData["CurrentSortOrder"] = 1;
}
else
{
ViewData["NewSortOrder"] = 1;
ViewData["CurrentSortOrder"] = 0;
sortOrder = 0;
}
//Get data
var cwtPaginatedList = policyCarVendorGroupItemLanguageRepository.PagePolicyCarVendorGroupItemCarAdvice(id, page ?? 1, sortField, sortOrder ?? 0);
return(View(cwtPaginatedList));
}
// GET: /Edit
public ActionResult Edit(int id)
{
//Get PolicyCarVendorGroupItem
PolicyCarVendorGroupItem policyCarVendorGroupItem = new PolicyCarVendorGroupItem();
policyCarVendorGroupItem = policyCarVendorGroupItemRepository.GetPolicyCarVendorGroupItem(id);
//Check Exists
if (policyCarVendorGroupItem == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Populate List of PolicyLocations
PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository();
SelectList policyLocations = new SelectList(policyLocationRepository.GetAllPolicyLocations().ToList(), "PolicyLocationId", "PolicyLocationName");
ViewData["PolicyLocationList"] = policyLocations;
//Populate List of PolicyCarStatuses
PolicyCarStatusRepository policyCarStatusRepository = new PolicyCarStatusRepository();
SelectList policyCarStatuses = new SelectList(policyCarStatusRepository.GetAllPolicyCarStatuses().ToList(), "PolicyCarStatusId", "PolicyCarStatusDescription");
ViewData["PolicyCarStatusList"] = policyCarStatuses;
//Populate List of Products
ProductRepository productRepository = new ProductRepository();
SelectList products = new SelectList(productRepository.GetAllProducts().ToList(), "ProductId", "ProductName");
ViewData["ProductList"] = products;
//Populate new PolicyCarVendorGroupItem with known PolicyGroup Information
PolicyGroup policyGroup = policyGroupRepository.GetGroup(policyCarVendorGroupItem.PolicyGroupId);
policyCarVendorGroupItem.PolicyGroupName = policyGroup.PolicyGroupName;
//return edit form
policyCarVendorGroupItemRepository.EditItemForDisplay(policyCarVendorGroupItem);
return(View(policyCarVendorGroupItem));
}
public ActionResult Delete(int id, string languageCode, FormCollection collection)
{
//Get Item
PolicyCarVendorGroupItemLanguage policyCarVendorGroupItemLanguage = new PolicyCarVendorGroupItemLanguage();
policyCarVendorGroupItemLanguage = policyCarVendorGroupItemLanguageRepository.GetItem(id, languageCode);
//Check Exists
if (policyCarVendorGroupItemLanguage == null)
{
ViewData["ActionMethod"] = "DeletePost";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
PolicyCarVendorGroupItem policyCarVendorGroupItem = new PolicyCarVendorGroupItem();
policyCarVendorGroupItem = policyCarVendorGroupItemRepository.GetPolicyCarVendorGroupItem(id);
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Delete Item
try
{
policyCarVendorGroupItemLanguage.VersionNumber = Int32.Parse(collection["VersionNumber"]);
policyCarVendorGroupItemLanguageRepository.Delete(policyCarVendorGroupItemLanguage);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/CarAdvice.mvc/Delete/" + policyCarVendorGroupItem.PolicyCarVendorGroupItemId.ToString() + "/" + policyCarVendorGroupItemLanguage.LanguageCode;
return(View("VersionError"));
}
//Generic Error
ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
return(View("Error"));
}
//Return
return(RedirectToAction("List", new { id = policyCarVendorGroupItemLanguage.PolicyCarVendorGroupItemId }));
}
//Add
public void Add(PolicyCarVendorGroupItem policyCarVendorGroupItem)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_InsertPolicyCarVendorGroupItem_v1(
policyCarVendorGroupItem.PolicyGroupId,
policyCarVendorGroupItem.PolicyLocationId,
policyCarVendorGroupItem.SupplierCode,
policyCarVendorGroupItem.ProductId,
policyCarVendorGroupItem.PolicyCarStatusId,
policyCarVendorGroupItem.EnabledFlag,
policyCarVendorGroupItem.EnabledDate,
policyCarVendorGroupItem.ExpiryDate,
policyCarVendorGroupItem.TravelDateValidFrom,
policyCarVendorGroupItem.TravelDateValidTo,
adminUserGuid
);
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicyCarVendorGroupItem policyCarVendorGroupItem)
{
//PolicyCarStatusDescription
if (policyCarVendorGroupItem.PolicyCarStatusId != null)
{
int policyCarStatusId = (int)policyCarVendorGroupItem.PolicyCarStatusId;
PolicyCarStatusRepository policyCarStatusRepository = new PolicyCarStatusRepository();
PolicyCarStatus policyCarStatus = new PolicyCarStatus();
policyCarStatus = policyCarStatusRepository.GetPolicyCarStatus(policyCarStatusId);
policyCarVendorGroupItem.PolicyCarStatus = policyCarStatus.PolicyCarStatusDescription;
}
//PolicyGroupName
PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository();
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyCarVendorGroupItem.PolicyGroupId);
policyCarVendorGroupItem.PolicyGroupName = policyGroup.PolicyGroupName;
//SupplierName
SupplierRepository supplierRepository = new SupplierRepository();
Supplier supplier = new Supplier();
supplier = supplierRepository.GetSupplier(policyCarVendorGroupItem.SupplierCode, policyCarVendorGroupItem.ProductId);
if (supplier != null)
{
policyCarVendorGroupItem.SupplierName = supplier.SupplierName;
}
//PolicyLocationName
PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository();
PolicyLocation policyLocation = new PolicyLocation();
policyLocation = policyLocationRepository.GetPolicyLocation(policyCarVendorGroupItem.PolicyLocationId);
if (policyLocation != null)
{
policyCarVendorGroupItem.PolicyLocationName = policyLocation.PolicyLocationName;
}
ProductRepository productRepository = new ProductRepository();
Product product = new Product();
product = productRepository.GetProduct(policyCarVendorGroupItem.ProductId);
if (product != null)
{
policyCarVendorGroupItem.ProductName = product.ProductName;
}
}
// GET: /View
public ActionResult View(int id)
{
//Get PolicyCarVendorGroupItem
PolicyCarVendorGroupItem policyCarVendorGroupItem = new PolicyCarVendorGroupItem();
policyCarVendorGroupItem = policyCarVendorGroupItemRepository.GetPolicyCarVendorGroupItem(id);
//Check Exists
if (policyCarVendorGroupItem == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
//populate new PolicyCarVendorGroupItem with known PolicyGroup Information
policyCarVendorGroupItemRepository.EditItemForDisplay(policyCarVendorGroupItem);
//Show 'View' Form
return(View(policyCarVendorGroupItem));
}
public ActionResult Edit(int id, FormCollection collection)
{
PolicyCarVendorGroupItem policyCarVendorGroupItem = new PolicyCarVendorGroupItem();
policyCarVendorGroupItem = policyCarVendorGroupItemRepository.GetPolicyCarVendorGroupItem(id);
//Check Exists
if (policyCarVendorGroupItem == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update PolicyCarVendorGroupItem Model From Form
try
{
UpdateModel(policyCarVendorGroupItem);
}
catch
{
string n = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
n += error.ErrorMessage;
}
}
ViewData["Message"] = "ValidationError : " + n;
return(View("Error"));
}
//Database Update
try
{
policyCarVendorGroupItemRepository.Update(policyCarVendorGroupItem);
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/PolicyCarVendorGroupItem.mvc/Edit/" + policyCarVendorGroupItem.PolicyCarVendorGroupItemId;
return(View("VersionError"));
}
//Generic Error
ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
return(View("Error"));
}
//Return to Form
return(RedirectToAction("List", new { id = policyCarVendorGroupItem.PolicyGroupId }));
}
public ActionResult Edit(int policyCarVendorGroupItemId, string languageCode, string carAdvice)
{
//Get Item
PolicyCarVendorGroupItemLanguage policyCarVendorGroupItemLanguage = new PolicyCarVendorGroupItemLanguage();
policyCarVendorGroupItemLanguage = policyCarVendorGroupItemLanguageRepository.GetItem(policyCarVendorGroupItemId, languageCode);
//Check Exists
if (policyCarVendorGroupItemLanguage == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
PolicyCarVendorGroupItem policyCarVendorGroupItem = new PolicyCarVendorGroupItem();
policyCarVendorGroupItem = policyCarVendorGroupItemRepository.GetPolicyCarVendorGroupItem(policyCarVendorGroupItemId);
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyCarVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Item from Form
try
{
UpdateModel(policyCarVendorGroupItemLanguage);
}
catch
{
string n = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
n += error.ErrorMessage;
}
}
ViewData["Message"] = "ValidationError : " + n;
return(View("Error"));
}
//Update CountryAdvice
try
{
policyCarVendorGroupItemLanguageRepository.Update(policyCarVendorGroupItemLanguage);
}
catch (SqlException ex)
{
LogRepository logRepository = new LogRepository();
logRepository.LogError(ex.Message);
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/CarAdvice.mvc/Edit/" + policyCarVendorGroupItemLanguage.PolicyCarVendorGroupItemId.ToString() + "/" + languageCode;
return(View("VersionError"));
}
//Generic Error
ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
return(View("Error"));
}
return(RedirectToAction("List", new { id = policyCarVendorGroupItemLanguage.PolicyCarVendorGroupItemId }));
}
