//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem)
{
//PolicyGroupName
PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository();
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyHotelCapRateGroupItem.PolicyGroupId);
policyHotelCapRateGroupItem.PolicyGroupName = policyGroup.PolicyGroupName;
//Currency
if (policyHotelCapRateGroupItem.CurrencyCode != null)
{
string currencyCode = policyHotelCapRateGroupItem.CurrencyCode;
CurrencyRepository currencyRepository = new CurrencyRepository();
Currency currency = new Currency();
currency = currencyRepository.GetCurrency(currencyCode);
policyHotelCapRateGroupItem.CurrencyName = currency.Name;
}
//PolicyLocation
PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository();
PolicyLocation policyLocation = new PolicyLocation();
policyLocation = policyLocationRepository.GetPolicyLocation(policyHotelCapRateGroupItem.PolicyLocationId);
if (policyLocation != null)
{
policyHotelCapRateGroupItem.PolicyLocation = policyLocation.PolicyLocationName;
}
}
public ActionResult Delete(int id)
{
//Get PolicyHotelCapRateGroupItem
PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem = new PolicyHotelCapRateGroupItem();
policyHotelCapRateGroupItem = policyHotelCapRateGroupItemRepository.GetPolicyHotelCapRateGroupItem(id);
//Check Exists
if (policyHotelCapRateGroupItem == null)
{
ViewData["ActionMethod"] = "GetDelete";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelCapRateGroupItem.PolicyGroupId))
{
return(View("Error"));
}
//populate new PolicyHotelCapRateGroupItem with known PolicyGroup Information
policyHotelCapRateGroupItemRepository.EditItemForDisplay(policyHotelCapRateGroupItem);
//Show 'Create' Form
return(View(policyHotelCapRateGroupItem));
}
public ActionResult Delete(int id, string languageCode)
{
//Get Item
PolicyHotelCapRateGroupItemLanguage policyHotelCapRateGroupItemLanguage = new PolicyHotelCapRateGroupItemLanguage();
policyHotelCapRateGroupItemLanguage = policyHotelCapRateGroupItemLanguageRepository.GetItem(id, languageCode);
//Check Exists
if (policyHotelCapRateGroupItemLanguage == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem = new PolicyHotelCapRateGroupItem();
policyHotelCapRateGroupItem = policyHotelCapRateGroupItemRepository.GetPolicyHotelCapRateGroupItem(id);
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelCapRateGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Add Linked Information
policyHotelCapRateGroupItemLanguageRepository.EditItemForDisplay(policyHotelCapRateGroupItemLanguage);
//Return View
return(View(policyHotelCapRateGroupItemLanguage));
}
// GET: /Edit
public ActionResult Edit(int id, string languageCode)
{
//Get Item
PolicyHotelCapRateGroupItemLanguage policyHotelCapRateGroupItemLanguage = new PolicyHotelCapRateGroupItemLanguage();
policyHotelCapRateGroupItemLanguage = policyHotelCapRateGroupItemLanguageRepository.GetItem(id, languageCode);
//Check Exists
if (policyHotelCapRateGroupItemLanguage == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem = new PolicyHotelCapRateGroupItem();
policyHotelCapRateGroupItem = policyHotelCapRateGroupItemRepository.GetPolicyHotelCapRateGroupItem(id);
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelCapRateGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Language SelectList
SelectList languageList = new SelectList(policyHotelCapRateGroupItemLanguageRepository.GetUnUsedLanguages(id).ToList(), "LanguageCode", "LanguageName");
ViewData["Languages"] = languageList;
policyHotelCapRateGroupItemLanguageRepository.EditItemForDisplay(policyHotelCapRateGroupItemLanguage);
return(View(policyHotelCapRateGroupItemLanguage));
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicyHotelCapRateGroupItemLanguage policyHotelCapRateGroupItemLanguage)
{
//Add LanguageName
if (policyHotelCapRateGroupItemLanguage.LanguageCode != null)
{
LanguageRepository languageRepository = new LanguageRepository();
Language language = new Language();
language = languageRepository.GetLanguage(policyHotelCapRateGroupItemLanguage.LanguageCode);
if (language != null)
{
policyHotelCapRateGroupItemLanguage.LanguageName = language.LanguageName;
}
}
//Add PolicyGroupName
PolicyHotelCapRateGroupItemRepository policyHotelCapRateGroupItemRepository = new PolicyHotelCapRateGroupItemRepository();
PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem = new PolicyHotelCapRateGroupItem();
policyHotelCapRateGroupItem = policyHotelCapRateGroupItemRepository.GetPolicyHotelCapRateGroupItem(policyHotelCapRateGroupItemLanguage.PolicyHotelCapRateItemId);
if (policyHotelCapRateGroupItem != null)
{
policyHotelCapRateGroupItemRepository.EditItemForDisplay(policyHotelCapRateGroupItem);
policyHotelCapRateGroupItemLanguage.PolicyGroupName = policyHotelCapRateGroupItem.PolicyGroupName;
policyHotelCapRateGroupItemLanguage.PolicyGroupId = policyHotelCapRateGroupItem.PolicyGroupId;
}
}
public ActionResult Create(PolicyHotelCapRateGroupItemLanguage policyHotelCapRateGroupItemLanguage)
{
PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem = new PolicyHotelCapRateGroupItem();
policyHotelCapRateGroupItem = policyHotelCapRateGroupItemRepository.GetPolicyHotelCapRateGroupItem(policyHotelCapRateGroupItemLanguage.PolicyHotelCapRateItemId);
//Check Exists
if (policyHotelCapRateGroupItem == null)
{
ViewData["ActionMethod"] = "CreatePost";
return(View("RecordDoesNotExistError"));
}
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelCapRateGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Model from Form
try
{
UpdateModel(policyHotelCapRateGroupItemLanguage);
}
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
{
policyHotelCapRateGroupItemLanguageRepository.Add(policyHotelCapRateGroupItemLanguage);
}
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 = policyHotelCapRateGroupItem.PolicyHotelCapRateItemId }));
}
//Delete
public void Delete(PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_DeletePolicyHotelCapRateGroupItem_v1(
policyHotelCapRateGroupItem.PolicyHotelCapRateItemId,
adminUserGuid,
policyHotelCapRateGroupItem.VersionNumber
);
}
public ActionResult Edit(int id, FormCollection collection)
{
PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem = new PolicyHotelCapRateGroupItem();
policyHotelCapRateGroupItem = policyHotelCapRateGroupItemRepository.GetPolicyHotelCapRateGroupItem(id);
//Check Exists
if (policyHotelCapRateGroupItem == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelCapRateGroupItem.PolicyGroupId))
{
return(View("Error"));
}
//Update PolicyHotelCapRateGroupItem Model From Form
try
{
UpdateModel(policyHotelCapRateGroupItem);
}
catch
{
return(View("Error"));
}
//Database Update
try
{
policyHotelCapRateGroupItemRepository.Update(policyHotelCapRateGroupItem);
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/PolicyHotelCapRateGroupItem.mvc/Edit/" + policyHotelCapRateGroupItem.PolicyHotelCapRateItemId.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 to Form
return(RedirectToAction("List", new { id = policyHotelCapRateGroupItem.PolicyGroupId }));
}
//GET:List
public ActionResult List(int id, int?page, string sortField, int?sortOrder)
{
//Get PolicyHotelCapRateGroupItem
PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem = new PolicyHotelCapRateGroupItem();
policyHotelCapRateGroupItem = policyHotelCapRateGroupItemRepository.GetPolicyHotelCapRateGroupItem(id);
//Check Exists
if (policyHotelCapRateGroupItem == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
//Set Access Rights
ViewData["Access"] = "";
RolesRepository rolesRepository = new RolesRepository();
if (rolesRepository.HasWriteAccessToPolicyGroup(policyHotelCapRateGroupItem.PolicyGroupId))
{
ViewData["Access"] = "WriteAccess";
}
//Parent Information
ViewData["PolicyHotelCapRateGroupItemId"] = policyHotelCapRateGroupItem.PolicyHotelCapRateItemId;
ViewData["PolicyGroupID"] = policyHotelCapRateGroupItem.PolicyGroupId;
ViewData["PolicyGroupName"] = policyGroupRepository.GetGroup(policyHotelCapRateGroupItem.PolicyGroupId).PolicyGroupName;
//SortField+SortOrder settings
if (sortField != "HotelCapRateAdvice")
{
sortField = "LanguageName";
}
ViewData["CurrentSortField"] = sortField;
if (sortOrder == 1)
{
ViewData["NewSortOrder"] = 0;
ViewData["CurrentSortOrder"] = 1;
}
else
{
ViewData["NewSortOrder"] = 1;
ViewData["CurrentSortOrder"] = 0;
}
//Get data
var cwtPaginatedList = policyHotelCapRateGroupItemLanguageRepository.PagePolicyHotelCapRateGroupItemHotelCapRateAdvice(id, page ?? 1, sortField, sortOrder ?? 0);
return(View(cwtPaginatedList));
}
public ActionResult Delete(int id, string languageCode, FormCollection collection)
{
//Get Item
PolicyHotelCapRateGroupItemLanguage policyHotelCapRateGroupItemLanguage = new PolicyHotelCapRateGroupItemLanguage();
policyHotelCapRateGroupItemLanguage = policyHotelCapRateGroupItemLanguageRepository.GetItem(id, languageCode);
//Check Exists
if (policyHotelCapRateGroupItemLanguage == null)
{
ViewData["ActionMethod"] = "DeletePost";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem = new PolicyHotelCapRateGroupItem();
policyHotelCapRateGroupItem = policyHotelCapRateGroupItemRepository.GetPolicyHotelCapRateGroupItem(id);
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelCapRateGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Delete Item
try
{
policyHotelCapRateGroupItemLanguage.VersionNumber = Int32.Parse(collection["VersionNumber"]);
policyHotelCapRateGroupItemLanguageRepository.Delete(policyHotelCapRateGroupItemLanguage);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/HOtelCapRateAdvice.mvc/Delete/" + policyHotelCapRateGroupItemLanguage.PolicyHotelCapRateItemId.ToString() + "/" + policyHotelCapRateGroupItemLanguage.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 = policyHotelCapRateGroupItemLanguage.PolicyHotelCapRateItemId }));
}
//Add
public void Add(PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_InsertPolicyHotelCapRateGroupItem_v1(
policyHotelCapRateGroupItem.PolicyGroupId,
policyHotelCapRateGroupItem.PolicyLocationId,
policyHotelCapRateGroupItem.EnabledFlag,
policyHotelCapRateGroupItem.CurrencyCode,
policyHotelCapRateGroupItem.CapRate,
policyHotelCapRateGroupItem.EnabledDate,
policyHotelCapRateGroupItem.ExpiryDate,
policyHotelCapRateGroupItem.TravelDateValidFrom,
policyHotelCapRateGroupItem.TravelDateValidTo,
policyHotelCapRateGroupItem.TaxInclusiveFlag,
adminUserGuid
);
}
// GET: /Edit
public ActionResult Edit(int id)
{
//Get PolicyHotelCapRateGroupItem
PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem = new PolicyHotelCapRateGroupItem();
policyHotelCapRateGroupItem = policyHotelCapRateGroupItemRepository.GetPolicyHotelCapRateGroupItem(id);
//Check Exists
if (policyHotelCapRateGroupItem == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelCapRateGroupItem.PolicyGroupId))
{
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 currencies
CurrencyRepository currencyRepository = new CurrencyRepository();
SelectList currencies = new SelectList(currencyRepository.GetAllCurrencies().ToList(), "CurrencyCode", "Name");
ViewData["CurrencyList"] = currencies;
//Populate new PolicyHotelCapRateGroupItem with known PolicyGroup Information
PolicyGroup policyGroup = policyGroupRepository.GetGroup(policyHotelCapRateGroupItem.PolicyGroupId);
policyHotelCapRateGroupItem.PolicyGroupName = policyGroup.PolicyGroupName;
//Show 'Edit' Form
policyHotelCapRateGroupItemRepository.EditItemForDisplay(policyHotelCapRateGroupItem);
return(View(policyHotelCapRateGroupItem));
}
// GET: /View
public ActionResult View(int id)
{
//Get PolicyHotelCapRateGroupItem
PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem = new PolicyHotelCapRateGroupItem();
policyHotelCapRateGroupItem = policyHotelCapRateGroupItemRepository.GetPolicyHotelCapRateGroupItem(id);
//Check Exists
if (policyHotelCapRateGroupItem == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
//populate new PolicyHotelCapRateGroupItem with known PolicyGroup Information
policyHotelCapRateGroupItemRepository.EditItemForDisplay(policyHotelCapRateGroupItem);
//Show 'View' Form
return(View(policyHotelCapRateGroupItem));
}
// GET: /Create
public ActionResult Create(int id)
{
PolicyGroup group = new PolicyGroup();
group = policyGroupRepository.GetGroup(id);;
//Check Exists
if (group == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(id))
{
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 currencies
CurrencyRepository currencyRepository = new CurrencyRepository();
SelectList currencies = new SelectList(currencyRepository.GetAllCurrencies().ToList(), "CurrencyCode", "Name");
ViewData["CurrencyList"] = currencies;
//populate new PolicyHotelCapRateGroupItem with known PolicyGroup Information
PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem = new PolicyHotelCapRateGroupItem();
policyHotelCapRateGroupItem.PolicyGroupId = id;
policyHotelCapRateGroupItem.PolicyGroupName = group.PolicyGroupName;
//Show 'Create' Form
return(View(policyHotelCapRateGroupItem));
}
public ActionResult Create(PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem)
{
PolicyGroup policyGroup = policyGroupRepository.GetGroup(policyHotelCapRateGroupItem.PolicyGroupId);
if (policyGroup == null)
{
ViewData["ActionMethod"] = "CreatePost";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelCapRateGroupItem.PolicyGroupId))
{
return(View("Error"));
}
//Update Model from Form
try
{
UpdateModel(policyHotelCapRateGroupItem);
}
catch
{
return(View("Error"));
}
try
{
policyHotelCapRateGroupItemRepository.Add(policyHotelCapRateGroupItem);
}
catch
{
//Could not insert to database
return(View("Error"));
}
return(RedirectToAction("List", new { id = policyHotelCapRateGroupItem.PolicyGroupId }));
}
public ActionResult Edit(int policyHotelCapRateItemId, string languageCode, string hotelCapRateAdvice)
{
//Get Item
PolicyHotelCapRateGroupItemLanguage policyHotelCapRateGroupItemLanguage = new PolicyHotelCapRateGroupItemLanguage();
policyHotelCapRateGroupItemLanguage = policyHotelCapRateGroupItemLanguageRepository.GetItem(policyHotelCapRateItemId, languageCode);
//Check Exists
if (policyHotelCapRateGroupItemLanguage == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem = new PolicyHotelCapRateGroupItem();
policyHotelCapRateGroupItem = policyHotelCapRateGroupItemRepository.GetPolicyHotelCapRateGroupItem(policyHotelCapRateItemId);
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyHotelCapRateGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Item from Form
try
{
UpdateModel(policyHotelCapRateGroupItemLanguage);
}
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 Advice
try
{
policyHotelCapRateGroupItemLanguageRepository.Update(policyHotelCapRateGroupItemLanguage);
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/HotelCapRateAdviceAdvice.mvc/Edit/" + policyHotelCapRateGroupItemLanguage.PolicyHotelCapRateItemId.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 = policyHotelCapRateGroupItemLanguage.PolicyHotelCapRateItemId }));
}
