// GET: /Edit
public ActionResult Edit(int id, string languageCode)
{
//Get Item
PolicyHotelVendorGroupItemLanguage policyHotelVendorGroupItemLanguage = new PolicyHotelVendorGroupItemLanguage();
policyHotelVendorGroupItemLanguage = policyHotelVendorGroupItemLanguageRepository.GetItem(id, languageCode);
//Check Exists
if (policyHotelVendorGroupItemLanguage == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem();
policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id);
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Language SelectList
SelectList languageList = new SelectList(policyHotelVendorGroupItemLanguageRepository.GetUnUsedLanguages(id).ToList(), "LanguageCode", "LanguageName");
ViewData["Languages"] = languageList;
policyHotelVendorGroupItemLanguageRepository.EditItemForDisplay(policyHotelVendorGroupItemLanguage);
return(View(policyHotelVendorGroupItemLanguage));
}
public ActionResult Delete(int id, string languageCode)
{
//Get Item
PolicyHotelVendorGroupItemLanguage policyHotelVendorGroupItemLanguage = new PolicyHotelVendorGroupItemLanguage();
policyHotelVendorGroupItemLanguage = policyHotelVendorGroupItemLanguageRepository.GetItem(id, languageCode);
//Check Exists
if (policyHotelVendorGroupItemLanguage == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem();
policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id);
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Add Linked Information
policyHotelVendorGroupItemLanguageRepository.EditItemForDisplay(policyHotelVendorGroupItemLanguage);
//Return View
return(View(policyHotelVendorGroupItemLanguage));
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicyHotelVendorGroupItemLanguage policyHotelVendorGroupItemLanguage)
{
//Add LanguageName
if (policyHotelVendorGroupItemLanguage.LanguageCode != null)
{
LanguageRepository languageRepository = new LanguageRepository();
Language language = new Language();
language = languageRepository.GetLanguage(policyHotelVendorGroupItemLanguage.LanguageCode);
if (language != null)
{
policyHotelVendorGroupItemLanguage.LanguageName = language.LanguageName;
}
}
//Add PolicyGroupName
PolicyHotelVendorGroupItemRepository policyHotelVendorGroupItemRepository = new PolicyHotelVendorGroupItemRepository();
PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem();
policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(policyHotelVendorGroupItemLanguage.PolicyHotelVendorGroupItemId);
if (policyHotelVendorGroupItem != null)
{
policyHotelVendorGroupItemRepository.EditItemForDisplay(policyHotelVendorGroupItem);
policyHotelVendorGroupItemLanguage.PolicyGroupName = policyHotelVendorGroupItem.PolicyGroupName;
policyHotelVendorGroupItemLanguage.PolicyGroupId = policyHotelVendorGroupItem.PolicyGroupId;
}
}
public ActionResult Delete(int id)
{
//Get PolicyHotelVendorGroupItem
PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem();
policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id);
//Check Exists
if (policyHotelVendorGroupItem == null)
{
ViewData["ActionMethod"] = "GetDelete";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//populate new PolicyHotelVendorGroupItem with known PolicyGroup Information
policyHotelVendorGroupItemRepository.EditItemForDisplay(policyHotelVendorGroupItem);
//Show 'Create' Form
return(View(policyHotelVendorGroupItem));
}
//Delete
public void Delete(PolicyHotelVendorGroupItem policyHotelVendorGroupItem)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_DeletePolicyHotelVendorGroupItem_v1(
policyHotelVendorGroupItem.PolicyHotelVendorGroupItemId,
adminUserGuid,
policyHotelVendorGroupItem.VersionNumber
);
}
public ActionResult Create(PolicyHotelVendorGroupItemLanguage policyHotelVendorGroupItemLanguage)
{
PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem();
policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(policyHotelVendorGroupItemLanguage.PolicyHotelVendorGroupItemId);
//Check Exists
if (policyHotelVendorGroupItem == null)
{
ViewData["ActionMethod"] = "CreatePost";
return(View("RecordDoesNotExistError"));
}
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId))
{
//AccessRights Error
return(View("Error"));
}
//Update Model from Form
try
{
UpdateModel(policyHotelVendorGroupItemLanguage);
}
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
{
policyHotelVendorGroupItemLanguageRepository.Add(policyHotelVendorGroupItemLanguage);
}
catch
{
//Insert Error
return(View("Error"));
}
return(RedirectToAction("List", new { id = policyHotelVendorGroupItem.PolicyHotelVendorGroupItemId }));
}
//GET:List
public ActionResult List(int id, int?page, string sortField, int?sortOrder)
{
//Get PolicyHotelVendorGroupItem
PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem();
policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id);
//Check Exists
if (policyHotelVendorGroupItem == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
//Set Access Rights
ViewData["Access"] = "";
RolesRepository rolesRepository = new RolesRepository();
if (rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId))
{
ViewData["Access"] = "WriteAccess";
}
//SortField+SortOrder settings
if (sortField != "Name")
{
sortField = "LanguageName";
}
ViewData["CurrentSortField"] = sortField;
if (sortOrder == 1)
{
ViewData["NewSortOrder"] = 0;
ViewData["CurrentSortOrder"] = 1;
}
else
{
ViewData["NewSortOrder"] = 1;
ViewData["CurrentSortOrder"] = 0;
sortOrder = 0;
}
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyHotelVendorGroupItem.PolicyGroupId);
ViewData["PolicyGroupName"] = policyGroup.PolicyGroupName;
ViewData["PolicyHotelVendorGroupItemId"] = id;
//Get data
var cwtPaginatedList = policyHotelVendorGroupItemLanguageRepository.PagePolicyHotelVendorGroupItemHotelAdvice(id, page ?? 1, sortField, sortOrder ?? 0);
return(View(cwtPaginatedList));
}
// GET: /Edit
public ActionResult Edit(int id)
{
//Get PolicyHotelVendorGroupItem
PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem();
policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id);
//Check Exists
if (policyHotelVendorGroupItem == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.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 PolicyHotelStatuses
PolicyHotelStatusRepository policyHotelStatusRepository = new PolicyHotelStatusRepository();
SelectList policyHotelStatuses = new SelectList(policyHotelStatusRepository.GetAllPolicyHotelStatuses().ToList(), "PolicyHotelStatusId", "PolicyHotelStatusDescription");
ViewData["PolicyHotelStatusList"] = policyHotelStatuses;
//Populate List of Products
ProductRepository productRepository = new ProductRepository();
SelectList products = new SelectList(productRepository.GetAllProducts().ToList(), "ProductId", "ProductName");
ViewData["ProductList"] = products;
//Populate new PolicyHotelVendorGroupItem with known PolicyGroup Information
PolicyGroup policyGroup = policyGroupRepository.GetGroup(policyHotelVendorGroupItem.PolicyGroupId);
policyHotelVendorGroupItem.PolicyGroupName = policyGroup.PolicyGroupName;
//return edit form
policyHotelVendorGroupItemRepository.EditItemForDisplay(policyHotelVendorGroupItem);
return(View(policyHotelVendorGroupItem));
}
public ActionResult Create(PolicyHotelVendorGroupItem policyHotelVendorGroupItem)
{
PolicyGroup policyGroup = policyGroupRepository.GetGroup(policyHotelVendorGroupItem.PolicyGroupId);
if (policyGroup == null)
{
ViewData["ActionMethod"] = "CreatePost";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Model from Form
try
{
UpdateModel(policyHotelVendorGroupItem);
}
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
{
policyHotelVendorGroupItemRepository.Add(policyHotelVendorGroupItem);
}
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 = policyHotelVendorGroupItem.PolicyGroupId }));
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicyHotelVendorGroupItem policyHotelVendorGroupItem)
{
//PolicyHotelStatusDescription
if (policyHotelVendorGroupItem.PolicyHotelStatusId != null)
{
int policyHotelStatusId = (int)policyHotelVendorGroupItem.PolicyHotelStatusId;
PolicyHotelStatusRepository policyHotelStatusRepository = new PolicyHotelStatusRepository();
PolicyHotelStatus policyHotelStatus = new PolicyHotelStatus();
policyHotelStatus = policyHotelStatusRepository.GetPolicyHotelStatus(policyHotelStatusId);
policyHotelVendorGroupItem.PolicyHotelStatus = policyHotelStatus.PolicyHotelStatusDescription;
}
//PolicyGroupName
PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository();
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyHotelVendorGroupItem.PolicyGroupId);
policyHotelVendorGroupItem.PolicyGroupName = policyGroup.PolicyGroupName;
policyHotelVendorGroupItem.PolicyGroupId = policyGroup.PolicyGroupId;
//SupplierName
SupplierRepository supplierRepository = new SupplierRepository();
Supplier supplier = new Supplier();
supplier = supplierRepository.GetSupplier(policyHotelVendorGroupItem.SupplierCode, policyHotelVendorGroupItem.ProductId);
if (supplier != null)
{
policyHotelVendorGroupItem.SupplierName = supplier.SupplierName;
}
//PolicyLocationName
PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository();
PolicyLocation policyLocation = new PolicyLocation();
policyLocation = policyLocationRepository.GetPolicyLocation(policyHotelVendorGroupItem.PolicyLocationId);
if (policyLocation != null)
{
policyHotelVendorGroupItem.PolicyLocationName = policyLocation.PolicyLocationName;
}
ProductRepository productRepository = new ProductRepository();
Product product = new Product();
product = productRepository.GetProduct(policyHotelVendorGroupItem.ProductId);
if (product != null)
{
policyHotelVendorGroupItem.ProductName = product.ProductName;
}
}
public ActionResult Delete(int id, string languageCode, FormCollection collection)
{
//Get Item
PolicyHotelVendorGroupItemLanguage policyHotelVendorGroupItemLanguage = new PolicyHotelVendorGroupItemLanguage();
policyHotelVendorGroupItemLanguage = policyHotelVendorGroupItemLanguageRepository.GetItem(id, languageCode);
//Check Exists
if (policyHotelVendorGroupItemLanguage == null)
{
ViewData["ActionMethod"] = "DeletePost";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem();
policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id);
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Delete Item
try
{
policyHotelVendorGroupItemLanguage.VersionNumber = Int32.Parse(collection["VersionNumber"]);
policyHotelVendorGroupItemLanguageRepository.Delete(policyHotelVendorGroupItemLanguage);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/HotelAdvice.mvc/Delete/" + policyHotelVendorGroupItemLanguage.PolicyHotelVendorGroupItemId.ToString() + "/" + policyHotelVendorGroupItemLanguage.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 = policyHotelVendorGroupItemLanguage.PolicyHotelVendorGroupItemId }));
}
public ActionResult Delete(int id, FormCollection collection)
{
//Get PolicyHotelVendorGroupItem
PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem();
policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id);
//Check Exists
if (policyHotelVendorGroupItem == null)
{
ViewData["ActionMethod"] = "PostDelete";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId))
{
return(View("Error"));
}
//Delete Item
try
{
policyHotelVendorGroupItem.VersionNumber = Int32.Parse(collection["VersionNumber"]);
policyHotelVendorGroupItemRepository.Delete(policyHotelVendorGroupItem);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/PolicyHotelVendorGroupItem.mvc/Delete/" + policyHotelVendorGroupItem.PolicyHotelVendorGroupItemId;
return(View("VersionError"));
}
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
return(RedirectToAction("List", new { id = policyHotelVendorGroupItem.PolicyGroupId }));
}
//Add
public void Add(PolicyHotelVendorGroupItem policyHotelVendorGroupItem)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_InsertPolicyHotelVendorGroupItem_v1(
policyHotelVendorGroupItem.PolicyGroupId,
policyHotelVendorGroupItem.PolicyLocationId,
policyHotelVendorGroupItem.SupplierCode,
policyHotelVendorGroupItem.ProductId,
policyHotelVendorGroupItem.PolicyHotelStatusId,
policyHotelVendorGroupItem.EnabledFlag,
policyHotelVendorGroupItem.EnabledDate,
policyHotelVendorGroupItem.ExpiryDate,
policyHotelVendorGroupItem.TravelDateValidFrom,
policyHotelVendorGroupItem.TravelDateValidTo,
adminUserGuid
);
}
// GET: /View
public ActionResult View(int id)
{
//Get PolicyHotelVendorGroupItem
PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem();
policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id);
//Check Exists
if (policyHotelVendorGroupItem == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
//populate new PolicyHotelVendorGroupItem with known PolicyGroup Information
policyHotelVendorGroupItemRepository.EditItemForDisplay(policyHotelVendorGroupItem);
//Show 'View' Form
return(View(policyHotelVendorGroupItem));
}
// GET: /Create
public ActionResult Create(int id)
{
//Get PolicyHotelVendorGroupItem
PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem();
policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(id);
//Check Exists
if (policyHotelVendorGroupItem == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
//AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId))
{
ViewData["ActionMethod"] = "ViewGet";
return(View("Error"));
}
//New PolicyHotelVendorGroupItemLanguage
PolicyHotelVendorGroupItemLanguage policyHotelVendorGroupItemLanguage = new PolicyHotelVendorGroupItemLanguage();
policyHotelVendorGroupItemLanguage.PolicyHotelVendorGroupItemId = id;
policyHotelVendorGroupItemLanguageRepository.EditItemForDisplay(policyHotelVendorGroupItemLanguage);
//Language SelectList
SelectList languageList = new SelectList(policyHotelVendorGroupItemLanguageRepository.GetUnUsedLanguages(id).ToList(), "LanguageCode", "LanguageName");
ViewData["Languages"] = languageList;
//Show Create Form
return(View(policyHotelVendorGroupItemLanguage));
}
public ActionResult Edit(int policyHotelVendorGroupItemId, string languageCode, string hotelAdvice)
{
//Get Item
PolicyHotelVendorGroupItemLanguage policyHotelVendorGroupItemLanguage = new PolicyHotelVendorGroupItemLanguage();
policyHotelVendorGroupItemLanguage = policyHotelVendorGroupItemLanguageRepository.GetItem(policyHotelVendorGroupItemId, languageCode);
//Check Exists
if (policyHotelVendorGroupItemLanguage == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
PolicyHotelVendorGroupItem policyHotelVendorGroupItem = new PolicyHotelVendorGroupItem();
policyHotelVendorGroupItem = policyHotelVendorGroupItemRepository.GetPolicyHotelVendorGroupItem(policyHotelVendorGroupItemId);
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Item from Form
try
{
UpdateModel(policyHotelVendorGroupItemLanguage);
}
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
{
policyHotelVendorGroupItemLanguageRepository.Update(policyHotelVendorGroupItemLanguage);
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/HotelAdvice.mvc/Edit/" + policyHotelVendorGroupItemLanguage.PolicyHotelVendorGroupItemId.ToString();
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 = policyHotelVendorGroupItemLanguage.PolicyHotelVendorGroupItemId }));
}
