//Contexts to XML
private XmlElement GetClientDefinedReferenceItemContexts(ClientDefinedReferenceItem clientDefinedReferenceItem)
{
XmlDocument docContexts = new XmlDocument();
XmlDeclaration decContexts = docContexts.CreateXmlDeclaration("1.0", null, null);
docContexts.AppendChild(decContexts);
XmlElement rootContexts = docContexts.CreateElement("ClientDefinedReferenceItemContexts");
docContexts.AppendChild(rootContexts);
if (!string.IsNullOrEmpty(clientDefinedReferenceItem.ClientDefinedReferenceItemContextIds))
{
string[] clientDefinedReferenceItemContextIds = clientDefinedReferenceItem.ClientDefinedReferenceItemContextIds.Split(',');
XmlElement xmlClientDefinedReferenceItemContexts = docContexts.CreateElement("ClientDefinedReferenceItemContexts");
foreach (string clientDefinedReferenceItemContextIdValue in clientDefinedReferenceItemContextIds)
{
if (!string.IsNullOrEmpty(clientDefinedReferenceItemContextIdValue))
{
int clientDefinedReferenceItemContextId;
if (Int32.TryParse(clientDefinedReferenceItemContextIdValue, out clientDefinedReferenceItemContextId))
{
XmlElement xmlClientDefinedReferenceItemContext = docContexts.CreateElement("ClientDefinedReferenceItemContext");
xmlClientDefinedReferenceItemContext.InnerText = clientDefinedReferenceItemContextId.ToString();
xmlClientDefinedReferenceItemContexts.AppendChild(xmlClientDefinedReferenceItemContext);
}
}
}
rootContexts.AppendChild(xmlClientDefinedReferenceItemContexts);
}
return(rootContexts);
}
public ActionResult Delete(string id, string csu)
{
//Check Exists
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(id);
if (clientDefinedReferenceItem == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
ClientDefinedReferenceItemVM clientDefinedReferenceItemVM = new ClientDefinedReferenceItemVM();
clientDefinedReferenceItemRepository.EditForDisplay(clientDefinedReferenceItem);
clientDefinedReferenceItemVM.ClientDefinedReferenceItem = clientDefinedReferenceItem;
//Check Exists CSU for VM
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu);
if (clientSubUnit != null)
{
clientSubUnitRepository.EditGroupForDisplay(clientSubUnit);
clientDefinedReferenceItemVM.ClientSubUnit = clientSubUnit;
ViewData["ClientTopUnitGuid"] = clientSubUnit.ClientTopUnitGuid;
ViewData["ClientTopUnitName"] = clientSubUnit.ClientTopUnitName;
ViewData["ClientSubUnitGuid"] = clientSubUnit.ClientSubUnitGuid;
ViewData["ClientSubUnitName"] = clientSubUnit.ClientSubUnitName;
}
return(View(clientDefinedReferenceItemVM));
}
//Update Item
public void Update(ClientDefinedReferenceItem clientDefinedReferenceItem)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
XmlElement clientDefinedReferenceItemProducts = GetClientDefinedReferenceItemProducts(clientDefinedReferenceItem);
XmlElement clientDefinedReferenceItemContexts = GetClientDefinedReferenceItemContexts(clientDefinedReferenceItem);
db.spDesktopDataAdmin_UpdateClientDefinedReferenceItem_v1(
clientDefinedReferenceItem.ClientDefinedReferenceItemId,
clientDefinedReferenceItem.ClientSubUnitGuid,
clientDefinedReferenceItem.DisplayName,
clientDefinedReferenceItem.DisplayNameAlias,
clientDefinedReferenceItem.EntryFormat,
clientDefinedReferenceItem.MandatoryFlagNullable,
clientDefinedReferenceItem.MinLength,
clientDefinedReferenceItem.MaxLength,
clientDefinedReferenceItem.TableDrivenFlagNullable,
clientDefinedReferenceItem.SourceSystemCode,
clientDefinedReferenceItem.ClientAccountNumber,
clientDefinedReferenceItem.OnlineDefaultValue,
System.Xml.Linq.XElement.Parse(clientDefinedReferenceItemProducts.OuterXml), //Products
System.Xml.Linq.XElement.Parse(clientDefinedReferenceItemContexts.OuterXml), //Contexts
clientDefinedReferenceItem.VersionNumber,
adminUserGuid
);
}
//Contexts
private IEnumerable <SelectListItem> GetSelectedContexts(ClientDefinedReferenceItem clientDefinedReferenceItem)
{
ContextRepository contextRepository = new ContextRepository();
IEnumerable <SelectListItem> defaultContexts = new SelectList(contextRepository.GetAllContexts().ToList(), "ContextId", "ContextName");
List <SelectListItem> selectedContexts = new List <SelectListItem>();
foreach (SelectListItem item in defaultContexts)
{
bool selected = false;
if (clientDefinedReferenceItem.ClientDefinedReferenceItemContextIds != null && clientDefinedReferenceItem.ClientDefinedReferenceItemContextIds.Length > 0)
{
foreach (string contextId in clientDefinedReferenceItem.ClientDefinedReferenceItemContextIds.Split(','))
{
if (item.Value == contextId)
{
selected = true;
}
}
}
selectedContexts.Add(
new SelectListItem()
{
Text = item.Text,
Value = item.Value,
Selected = selected
}
);
}
return(selectedContexts);
}
// GET: /Delete/5
public ActionResult Delete(int id, string csu, string can, string ssc)
{
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu);
//Check Exists
if (clientSubUnit == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
ClientDefinedReferenceItemPNROutputVM clientDefinedReferenceItemPNROutputVM = new ClientDefinedReferenceItemPNROutputVM();
ClientDefinedReferenceItemPNROutput clientDefinedReferenceItemPNROutput = new ClientDefinedReferenceItemPNROutput();
clientDefinedReferenceItemPNROutput = clientDefinedReferenceItemPNROutputRepository.GetClientDefinedReferenceItemPNROutput(id);
//Check Exists
if (clientDefinedReferenceItemPNROutput == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItemId);
//Check Exists
if (clientDefinedReferenceItem == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
clientSubUnitRepository.EditGroupForDisplay(clientSubUnit);
ViewData["ClientTopUnitGuid"] = clientSubUnit.ClientTopUnitGuid;
ViewData["ClientTopUnitName"] = clientSubUnit.ClientTopUnitName;
ViewData["ClientSubUnitGuid"] = clientSubUnit.ClientSubUnitGuid;
ViewData["ClientSubUnitName"] = clientSubUnit.ClientSubUnitName;
ViewData["ClientDefinedReferenceItemId"] = clientDefinedReferenceItem.ClientDefinedReferenceItemId;
ViewData["DisplayNameAlias"] = clientDefinedReferenceItem.DisplayNameAlias != null ? clientDefinedReferenceItem.DisplayNameAlias : clientDefinedReferenceItem.DisplayName;
clientDefinedReferenceItemPNROutputVM.ClientSubUnit = clientSubUnit;
clientDefinedReferenceItem.ClientSubUnitGuid = clientSubUnit.ClientSubUnitGuid;
clientDefinedReferenceItemPNROutputVM.ClientDefinedReferenceItemPNROutput = clientDefinedReferenceItemPNROutput;
return(View(clientDefinedReferenceItemPNROutputVM));
}
// GET: /View/5
public ActionResult View(string id, string csu, string can, string ssc)
{
//Check Exists
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(id);
if (clientDefinedReferenceItem == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
clientDefinedReferenceItemRepository.EditForDisplay(clientDefinedReferenceItem);
ClientDefinedReferenceItemVM clientDefinedReferenceItemVM = new ClientDefinedReferenceItemVM();
//Check Exists (CDR CSU could be null)
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu);
if (clientSubUnit != null)
{
clientDefinedReferenceItem.ClientSubUnitGuid = clientSubUnit.ClientSubUnitGuid;
clientDefinedReferenceItemVM.ClientSubUnit = clientSubUnit;
}
if (can != null && ssc != null)
{
ClientSubUnitClientAccount clientSubUnitClientAccount = new ClientSubUnitClientAccount();
clientSubUnitClientAccount = clientSubUnitClientAccountRepository.GetClientSubUnitClientAccount(can, ssc, csu);
if (clientSubUnitClientAccount != null)
{
ViewData["ClientSubUnitClientAccountClientAccountName"] = clientSubUnitClientAccount.ClientAccount.ClientAccountName;
}
clientDefinedReferenceItem.ClientAccountNumber = clientDefinedReferenceItem.ClientAccountNumber;
clientDefinedReferenceItem.SourceSystemCode = clientDefinedReferenceItem.SourceSystemCode;
}
clientDefinedReferenceItemVM.ClientDefinedReferenceItem = clientDefinedReferenceItem;
if (can != null && ssc != null)
{
ClientAccount clientAccount = new ClientAccount();
ClientAccountRepository clientAccountRepository = new ClientAccountRepository();
clientAccount = clientAccountRepository.GetClientAccount(can, ssc);
if (clientAccount != null)
{
ViewData["ClientAccountName"] = clientAccount.ClientAccountName;
}
ViewData["ClientAccountNumber"] = can;
ViewData["SourceSystemCode"] = ssc;
}
return(View(clientDefinedReferenceItemVM));
}
public ActionResult Delete(string id, string csu)
{
//Check Exists
ClientDefinedReferenceItemValue clientDefinedReferenceItemValue = new ClientDefinedReferenceItemValue();
clientDefinedReferenceItemValue = clientSubUnitClientDefinedReferenceItemValueRepository.GetClientDefinedReferenceItemValue(id);
if (clientDefinedReferenceItemValue == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check Exists
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(clientDefinedReferenceItemValue.ClientDefinedReferenceItemId);
if (clientDefinedReferenceItem == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu);
//Check Exists
if (clientSubUnit == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
ClientDefinedReferenceItemValueVM clientDefinedReferenceItemValueVM = new ClientDefinedReferenceItemValueVM();
clientDefinedReferenceItemValueVM.ClientDefinedReferenceItemValue = clientDefinedReferenceItemValue;
clientDefinedReferenceItemValueVM.ClientDefinedReferenceItem = clientDefinedReferenceItem;
clientDefinedReferenceItemValueVM.ClientSubUnit = clientSubUnit;
clientDefinedReferenceItemValueVM.ClientDefinedReferenceItemValue = clientDefinedReferenceItemValue;
clientSubUnitRepository.EditGroupForDisplay(clientSubUnit);
ViewData["ClientTopUnitGuid"] = clientSubUnit.ClientTopUnitGuid;
ViewData["ClientTopUnitName"] = clientSubUnit.ClientTopUnitName;
ViewData["ClientSubUnitGuid"] = clientSubUnit.ClientSubUnitGuid;
ViewData["ClientSubUnitName"] = clientSubUnit.ClientSubUnitName;
ViewData["ClientDefinedReferenceItemId"] = clientDefinedReferenceItem.ClientDefinedReferenceItemId ?? "";
ViewData["ClientDefinedReferenceItemDisplayNameAlias"] = clientDefinedReferenceItem.DisplayNameAlias ?? "";
return(View(clientDefinedReferenceItemValueVM));
}
//Delete Item
public void Delete(ClientDefinedReferenceItem clientDefinedReferenceItem)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_DeleteClientSubUnitClientDefinedReferenceItem_v1(
clientDefinedReferenceItem.ClientDefinedReferenceItemId,
adminUserGuid,
clientDefinedReferenceItem.VersionNumber
);
}
public ClientDefinedReferenceItemValueVM(
ClientDefinedReferenceItemValue clientDefinedReferenceItemValue,
ClientDefinedReferenceItem clientDefinedReferenceItem,
ClientSubUnit clientSubUnit,
ClientSubUnitClientAccount clientSubUnitClientAccount)
{
ClientDefinedReferenceItemValue = clientDefinedReferenceItemValue;
ClientDefinedReferenceItem = clientDefinedReferenceItem;
ClientSubUnit = clientSubUnit;
ClientSubUnitClientAccount = clientSubUnitClientAccount;
}
// GET: /Create
public ActionResult Create(string id, string can, string ssc)
{
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(id);
//Check Exists
if (clientSubUnit == null)
{
ViewData["ActionMethod"] = "ListBySubUnitGet";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
ClientDefinedReferenceItemVM clientDefinedReferenceItemVM = new ClientDefinedReferenceItemVM();
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItemRepository.EditForDisplay(clientDefinedReferenceItem);
if (can != null && ssc != null)
{
ClientSubUnitClientAccount clientSubUnitClientAccount = new ClientSubUnitClientAccount();
clientSubUnitClientAccount = clientSubUnitClientAccountRepository.GetClientSubUnitClientAccount(can, ssc, clientSubUnit.ClientSubUnitGuid);
if (clientSubUnitClientAccount != null)
{
ViewData["ClientSubUnitClientAccountClientAccountName"] = clientSubUnitClientAccount.ClientAccount.ClientAccountName;
}
clientDefinedReferenceItem.ClientAccountNumber = can;
clientDefinedReferenceItem.SourceSystemCode = ssc;
}
//Products
ProductRepository productRepository = new ProductRepository();
clientDefinedReferenceItemVM.Products = new SelectList(productRepository.GetAllProducts().ToList(), "ProductId", "ProductName");
//Contexts
ContextRepository contextRepository = new ContextRepository();
clientDefinedReferenceItemVM.Contexts = new SelectList(contextRepository.GetAllContexts().ToList(), "ContextId", "ContextName");
clientDefinedReferenceItem.ClientSubUnitGuid = clientSubUnit.ClientSubUnitGuid;
clientDefinedReferenceItemVM.ClientDefinedReferenceItem = clientDefinedReferenceItem;
clientDefinedReferenceItemVM.ClientSubUnit = clientSubUnit;
return(View(clientDefinedReferenceItemVM));
}
public ActionResult Delete(ClientDefinedReferenceItemPNROutputVM clientDefinedReferenceItemPNROutputVM)
{
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(clientDefinedReferenceItemPNROutputVM.ClientDefinedReferenceItemPNROutput.ClientDefinedReferenceItemId);
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Delete item
try
{
clientDefinedReferenceItemPNROutputRepository.Delete(clientDefinedReferenceItemPNROutputVM.ClientDefinedReferenceItemPNROutput);
}
catch (SqlException ex)
{
//Non-Unique Name
if (ex.Message == "NonUniqueName")
{
return(View("NonUniqueNameError"));
}
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"));
}
ViewData["NewSortOrder"] = 0;
return(RedirectToAction("List", new
{
id = clientDefinedReferenceItem.ClientDefinedReferenceItemId,
csu = clientDefinedReferenceItemPNROutputVM.ClientSubUnit.ClientSubUnitGuid,
can = clientDefinedReferenceItem.ClientAccountNumber,
ssc = clientDefinedReferenceItem.SourceSystemCode
}));
}
//Add Data From Linked Tables for Display
public void EditForDisplay(ClientDefinedReferenceItem clientDefinedReferenceItem)
{
//MandatoryFlag
clientDefinedReferenceItem.MandatoryFlagNullable = (clientDefinedReferenceItem.MandatoryFlag == true) ? true : false;
//TableDrivenFlag
clientDefinedReferenceItem.TableDrivenFlagNullable = (clientDefinedReferenceItem.TableDrivenFlag == true) ? true : false;
//ClientDefinedReferenceItemProducts
if (clientDefinedReferenceItem.ClientDefinedReferenceItemProducts != null)
{
clientDefinedReferenceItem.ClientDefinedReferenceItemProductIds = string.Join(",", clientDefinedReferenceItem.ClientDefinedReferenceItemProducts.OrderBy(x => x.ProductId).Select(p => p.ProductId.ToString()));
}
//ClientDefinedReferenceItemContexts
if (clientDefinedReferenceItem.ClientDefinedReferenceItemContexts != null)
{
clientDefinedReferenceItem.ClientDefinedReferenceItemContextIds = string.Join(",", clientDefinedReferenceItem.ClientDefinedReferenceItemContexts.OrderBy(x => x.ContextId).Select(p => p.ContextId.ToString()));
}
}
public ActionResult Delete(int id, string csu, string can, string ssc)
{
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu);
//Check Exists
if (clientSubUnit == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
ClientDefinedReferenceItemPNROutputVM clientDefinedReferenceItemPNROutputVM = new ClientDefinedReferenceItemPNROutputVM();
ClientDefinedReferenceItemPNROutput clientDefinedReferenceItemPNROutput = new ClientDefinedReferenceItemPNROutput();
clientDefinedReferenceItemPNROutput = clientDefinedReferenceItemPNROutputRepository.GetClientDefinedReferenceItemPNROutput(id);
//Check Exists
if (clientDefinedReferenceItemPNROutput == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItemId);
//Check Exists
if (clientDefinedReferenceItem == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
ViewData["DsplayName"] = !string.IsNullOrEmpty(clientDefinedReferenceItem.DisplayNameAlias) ? clientDefinedReferenceItem.DisplayNameAlias : clientDefinedReferenceItem.DisplayName;
if (can != null && ssc != null)
{
ClientSubUnitClientAccount clientSubUnitClientAccount = new ClientSubUnitClientAccount();
clientSubUnitClientAccount = clientSubUnitClientAccountRepository.GetClientSubUnitClientAccount(can, ssc, clientSubUnit.ClientSubUnitGuid);
if (clientSubUnitClientAccount != null)
{
ViewData["ClientSubUnitClientAccountClientAccountName"] = clientSubUnitClientAccount.ClientAccount.ClientAccountName;
}
clientDefinedReferenceItem.ClientAccountNumber = can;
clientDefinedReferenceItem.SourceSystemCode = ssc;
ViewData["ClientDefinedReferenceItemId"] = clientDefinedReferenceItem.ClientDefinedReferenceItemId;
ViewData["ClientAccountNumber"] = can;
ViewData["SourceSystemCode"] = ssc;
}
clientDefinedReferenceItemPNROutputVM.ClientDefinedReferenceItemPNROutput = clientDefinedReferenceItemPNROutput;
clientDefinedReferenceItemPNROutputVM.ClientSubUnit = clientSubUnit;
clientDefinedReferenceItem.ClientSubUnitGuid = clientSubUnit.ClientSubUnitGuid;
clientDefinedReferenceItemPNROutputVM.ClientSubUnit = clientSubUnit;
clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItem = clientDefinedReferenceItem;
clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItemId = clientDefinedReferenceItem.ClientDefinedReferenceItemId;
return(View(clientDefinedReferenceItemPNROutputVM));
}
// GET: /List/
public ActionResult List(string filter, int?page, string id, string sortField, int?sortOrder, string csu, string can, string ssc)
{
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(id);
//Check Exists
if (clientDefinedReferenceItem == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu);
//Check Exists
if (clientSubUnit == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
//Set Access Rights
ViewData["Access"] = "";
if (hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Access"] = "WriteAccess";
}
//Set Create/Order Rights
ViewData["CreateAccess"] = "";
RolesRepository rolesRepository = new RolesRepository();
if (rolesRepository.HasWriteAccessToClientDefinedReferenceItem(id, can, ssc) && hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["CreateAccess"] = "CreateAccess";
}
//SortField
if (string.IsNullOrEmpty(sortField))
{
sortField = "GDSName";
}
ViewData["CurrentSortField"] = sortField;
//SortOrder
if (sortOrder == 1)
{
ViewData["NewSortOrder"] = 0;
ViewData["CurrentSortOrder"] = 1;
}
else
{
ViewData["NewSortOrder"] = 1;
ViewData["CurrentSortOrder"] = 0;
}
clientSubUnitRepository.EditGroupForDisplay(clientSubUnit);
ViewData["ClientTopUnitGuid"] = clientSubUnit.ClientTopUnitGuid;
ViewData["ClientTopUnitName"] = clientSubUnit.ClientTopUnitName;
ViewData["ClientSubUnitGuid"] = clientSubUnit.ClientSubUnitGuid;
ViewData["ClientSubUnitName"] = clientSubUnit.ClientSubUnitName;
ViewData["ClientDefinedReferenceItemId"] = clientDefinedReferenceItem.ClientDefinedReferenceItemId;
ViewData["DisplayNameAlias"] = clientDefinedReferenceItem.DisplayNameAlias;
if (can != null && ssc != null)
{
ClientAccount clientAccount = new ClientAccount();
ClientAccountRepository clientAccountRepository = new ClientAccountRepository();
clientAccount = clientAccountRepository.GetClientAccount(can, ssc);
if (clientAccount != null)
{
ViewData["ClientAccountName"] = clientAccount.ClientAccountName;
}
ViewData["ClientAccountNumber"] = can;
ViewData["SourceSystemCode"] = ssc;
}
var items = clientDefinedReferenceItemPNROutputRepository.PageClientDefinedReferenceItemPNROutputItems(filter ?? "", id, page ?? 1, sortField, sortOrder ?? 0);
return(View(items));
}
public ActionResult Edit(ClientDefinedReferenceItemPNROutputVM clientDefinedReferenceItemPNROutputVM)
{
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(clientDefinedReferenceItemPNROutputVM.ClientDefinedReferenceItemPNROutput.ClientDefinedReferenceItemId);
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Model From Form + Validate against DB
try
{
UpdateModel(clientDefinedReferenceItemPNROutputVM);
}
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
{
clientDefinedReferenceItemPNROutputRepository.Update(clientDefinedReferenceItemPNROutputVM.ClientDefinedReferenceItemPNROutput);
}
catch (SqlException ex)
{
//Non-Unique Name
if (ex.Message == "NonUniqueName")
{
return(View("NonUniqueNameError"));
}
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"));
}
ViewData["NewSortOrder"] = 0;
return(RedirectToAction("List", new
{
id = clientDefinedReferenceItem.ClientDefinedReferenceItemId,
csu = clientDefinedReferenceItemPNROutputVM.ClientSubUnit.ClientSubUnitGuid,
can = clientDefinedReferenceItem.ClientAccountNumber,
ssc = clientDefinedReferenceItem.SourceSystemCode
}));
}
// GET: /Edit
public ActionResult Edit(int id, string csu, string can, string ssc)
{
ClientDefinedReferenceItemPNROutputVM clientDefinedReferenceItemPNROutputVM = new ClientDefinedReferenceItemPNROutputVM();
ClientDefinedReferenceItemPNROutput clientDefinedReferenceItemPNROutput = new ClientDefinedReferenceItemPNROutput();
clientDefinedReferenceItemPNROutput = clientDefinedReferenceItemPNROutputRepository.GetClientDefinedReferenceItemPNROutput(id);
if (clientDefinedReferenceItemPNROutput == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
clientDefinedReferenceItemPNROutputVM.ClientDefinedReferenceItemPNROutput = clientDefinedReferenceItemPNROutput;
//Check Exists
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItemId);
if (clientDefinedReferenceItem == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
ViewData["DsplayName"] = !string.IsNullOrEmpty(clientDefinedReferenceItem.DisplayNameAlias) ? clientDefinedReferenceItem.DisplayNameAlias : clientDefinedReferenceItem.DisplayName;
//Check Exists CSU for VM
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu);
if (clientSubUnit != null)
{
clientSubUnitRepository.EditGroupForDisplay(clientSubUnit);
clientDefinedReferenceItemPNROutputVM.ClientSubUnit = clientSubUnit;
}
// Check Exists CDR CSU (can be null)
ClientSubUnit clientSubUnitCDR = new ClientSubUnit();
if (clientDefinedReferenceItem.ClientSubUnitGuid != null)
{
clientSubUnitCDR = clientSubUnitRepository.GetClientSubUnit(clientDefinedReferenceItem.ClientSubUnitGuid);
if (clientSubUnit != null)
{
clientSubUnitRepository.EditGroupForDisplay(clientSubUnitCDR);
clientDefinedReferenceItem.ClientSubUnitGuid = clientSubUnitCDR.ClientSubUnitGuid;
}
}
if (can != null && ssc != null)
{
ClientSubUnitClientAccount clientSubUnitClientAccount = new ClientSubUnitClientAccount();
clientSubUnitClientAccount = clientSubUnitClientAccountRepository.GetClientSubUnitClientAccount(can, ssc, csu);
if (clientSubUnitClientAccount != null)
{
ViewData["ClientSubUnitClientAccountClientAccountName"] = clientSubUnitClientAccount.ClientAccount.ClientAccountName;
}
clientDefinedReferenceItem.ClientAccountNumber = clientDefinedReferenceItem.ClientAccountNumber;
clientDefinedReferenceItem.SourceSystemCode = clientDefinedReferenceItem.SourceSystemCode;
}
if (can != null && ssc != null)
{
ClientAccount clientAccount = new ClientAccount();
ClientAccountRepository clientAccountRepository = new ClientAccountRepository();
clientAccount = clientAccountRepository.GetClientAccount(can, ssc);
if (clientAccount != null)
{
ViewData["ClientAccountName"] = clientAccount.ClientAccountName;
}
clientDefinedReferenceItem.ClientAccountNumber = can;
clientDefinedReferenceItem.SourceSystemCode = ssc;
ViewData["ClientDefinedReferenceItemId"] = clientDefinedReferenceItem.ClientDefinedReferenceItemId;
ViewData["ClientAccountNumber"] = can;
ViewData["SourceSystemCode"] = ssc;
}
//ClientDefinedReferenceItem
clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItem = clientDefinedReferenceItem;
clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItemId = clientDefinedReferenceItem.ClientDefinedReferenceItemId;
//GDS
GDSRepository GDSRepository = new GDSRepository();
clientDefinedReferenceItemPNROutputVM.GDSList = new SelectList(GDSRepository.GetAllGDSsExceptALL().OrderBy(x => x.GDSName).ToList(), "GDSCode", "GDSName");
//PNR Output Remark Types
PNROutputRemarkTypeRepository PNROutputRemarkTypeRepository = new PNROutputRemarkTypeRepository();
clientDefinedReferenceItemPNROutputVM.PNROutputRemarkTypeCodes = new SelectList(PNROutputRemarkTypeRepository.GetPNROutputRemarkTypes(), "PNROutputRemarkTypeCode", "PNROutputRemarkTypeName");
//Languages
LanguageRepository languageRepository = new LanguageRepository();
clientDefinedReferenceItemPNROutputVM.Languages = new SelectList(languageRepository.GetAllLanguages().ToList(), "LanguageCode", "LanguageName");
return(View(clientDefinedReferenceItemPNROutputVM));
}
public ClientDefinedReferenceItemVM(ClientDefinedReferenceItem clientDefinedReferenceItem, ClientSubUnit clientSubUnit)
{
ClientSubUnit = clientSubUnit;
ClientDefinedReferenceItem = clientDefinedReferenceItem;
}
public ActionResult Create(ClientSubUnitCDRsVM clientSubUnitCDRsVM, string btnSubmit)
{
string clientSubUnitGuid = clientSubUnitCDRsVM.ClientSubUnitGuid;
string displayName = clientSubUnitCDRsVM.DisplayName;
string relatedToDisplayName = clientSubUnitCDRsVM.RelatedToDisplayName ?? "";
if (btnSubmit == "Import")
{
return(RedirectToAction("ImportStep1", new { id = clientSubUnitGuid, displayName = displayName, relatedToDisplayName = relatedToDisplayName }));
}
//Get ClientSubUnit
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(clientSubUnitGuid);
//Check Exists
if (clientSubUnit == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
//Check Exists
//if (clientdefinedReferenceItem2 == null)
//{
// ViewData["ActionMethod"] = "CreateGet";
// return View("RecordDoesNotExistError");
//}
//Access Rights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToClientSubUnit(clientSubUnitGuid))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
ClientSubUnitCDRVM clientSubUnitCDRVM = new ClientSubUnitCDRVM();
clientSubUnitCDRVM.ClientSubUnit = clientSubUnit;
//Get ClientSubUnit/ClientDefinedReferenceItem
ClientDefinedReferenceItem clientdefinedReferenceItem2 = new ClientDefinedReferenceItem();
//if(string.IsNullOrEmpty(displayName)){
//clientdefinedReferenceItem2. = ClientDefinedReferenceItemId;// clientDefinedReferenceItemRepository.GetCSUClientDefinedReferenceItemByCDRId(clientSubUnitGuid, ClientDefinedReferenceItemId);
// ClientSubUnitClientDefinedReference clientSubUnitClientDefinedReference = new ClientSubUnitClientDefinedReference();
// clientSubUnitClientDefinedReference.DisplayName = displayName;
// clientSubUnitCDRVM.ClientSubUnitClientDefinedReference = clientSubUnitClientDefinedReference;
//}else{
// clientdefinedReferenceItem2 = clientDefinedReferenceItemRepository.GetCSUClientDefinedReferenceItem(clientSubUnitGuid,displayName);
// clientSubUnitCDRVM.ClientDefinedReferenceItemId = clientdefinedReferenceItem2.ClientDefinedReferenceItemId;
//}
//Add MaskedCreditCardNumber and CreditCardHolderName into Select List
CreditCardClientSubUnitRepository creditCardClientSubUnitRepository = new CreditCardClientSubUnitRepository();
List <CreditCard> creditCards = creditCardClientSubUnitRepository.GetAllCreditCardsBySubUnit(clientSubUnitGuid).ToList();
List <SelectListItem> creditCardList = new List <SelectListItem>();
foreach (CreditCard creditCardItem in creditCards)
{
creditCardList.Add(new SelectListItem
{
Value = creditCardItem.CreditCardId.ToString(),
Text = string.Format("{0}\xA0\xA0\xA0\xA0\xA0\xA0\xA0\xA0\xA0\xA0\xA0\xA0{1}", creditCardItem.MaskedCreditCardNumber, creditCardItem.CreditCardHolderName) //Space out items
});
}
clientSubUnitCDRVM.CreditCardSelectList = new SelectList(creditCardList, "Value", "Text");
ClientSubUnitClientAccountRepository clientSubUnitClientAccountRepository = new ClientSubUnitClientAccountRepository();
clientSubUnitCDRVM.ClientAccountSelectList = clientSubUnitClientAccountRepository.GetClientAccountsBySubUnit(clientSubUnitGuid, "");
clientSubUnitCDRVM.CreditCardValidTo = null;
//Show Create Form
return(View(clientSubUnitCDRVM));
}
public ActionResult Create(ClientSubUnitCDRVM clientSubUnitCDRVM)
{
//Validate data against Tables
if (!ModelState.IsValid)
{
string clientSubUnitGuid = clientSubUnitCDRVM.ClientSubUnit.ClientSubUnitGuid;
//Get ClientSubUnit
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(clientSubUnitGuid);
ClientTopUnit clientTopUnit = new ClientTopUnit();
ClientTopUnitRepository clientTopUnitRepository = new ClientTopUnitRepository();
clientTopUnit = clientTopUnitRepository.GetClientTopUnit(clientSubUnit.ClientTopUnitGuid);
clientSubUnit.ClientTopUnit = clientTopUnit;
clientSubUnitCDRVM.ClientSubUnit = clientSubUnit;
clientSubUnitCDRVM.ClientSubUnit = clientSubUnit;
CreditCardClientSubUnitRepository creditCardClientSubUnitRepository = new CreditCardClientSubUnitRepository();
clientSubUnitCDRVM.CreditCardSelectList = new SelectList(creditCardClientSubUnitRepository.GetAllCreditCardsBySubUnit(clientSubUnitGuid).ToList(), "CreditCardId", "MaskedCreditCardNumber");
ClientSubUnitClientAccountRepository clientSubUnitClientAccountRepository = new ClientSubUnitClientAccountRepository();
clientSubUnitCDRVM.ClientAccountSelectList = clientSubUnitClientAccountRepository.GetClientAccountsBySubUnit(clientSubUnitGuid, "");
//ClientTopUnitRepository clientTopUnitRepository = new ClientTopUnitRepository();
//clientSubUnitCDRVM.ClientSubUnit.ClientTopUnit = clientTopUnitRepository.GetClientTopUnit(clientSubUnitCDRVM.ClientSubUnit.ClientSubUnitGuid);
return(View(clientSubUnitCDRVM));
}
CreditCard creditCard = new CreditCard();
int? creditCardId = clientSubUnitCDRVM.ClientSubUnitClientDefinedReference.CreditCardId;
if (creditCardId != null)
{
creditCard = creditCardRepository.GetCreditCard((int)creditCardId, false);
}
ClientAccount clientAccount = new ClientAccount();
string clientAccountNumber = null;
string sourceSystemCode = null;
if (!String.IsNullOrEmpty(clientSubUnitCDRVM.ClientSubUnitClientDefinedReference.ClientAccountNumberSourceSystemCode))
{
clientAccountNumber = clientSubUnitCDRVM.ClientSubUnitClientDefinedReference.ClientAccountNumberSourceSystemCode.Split(new[] { '|' })[0];
sourceSystemCode = clientSubUnitCDRVM.ClientSubUnitClientDefinedReference.ClientAccountNumberSourceSystemCode.Split(new[] { '|' })[1];
clientAccount = clientAccountRepository.GetClientAccount(clientAccountNumber, sourceSystemCode);
}
//Check Exists (at least one
if (creditCard == null && clientAccount == null)
{
ViewData["ActionMethod"] = "CreatePost";
return(View("RecordDoesNotExistError"));
}
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToClientSubUnit(clientSubUnitCDRVM.ClientSubUnit.ClientSubUnitGuid))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Model from Form
ClientSubUnitClientDefinedReference clientSubUnitClientDefinedReference = new ClientSubUnitClientDefinedReference();
clientSubUnitClientDefinedReference.ClientSubUnitGuid = clientSubUnitCDRVM.ClientSubUnit.ClientSubUnitGuid;
clientSubUnitClientDefinedReference.Value = clientSubUnitCDRVM.ClientSubUnitClientDefinedReference.Value;
clientSubUnitClientDefinedReference.ClientAccountNumber = clientAccountNumber;
clientSubUnitClientDefinedReference.SourceSystemCode = sourceSystemCode;
clientSubUnitClientDefinedReference.CreditCardId = creditCardId;
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
ClientDefinedReferenceItemRepository clientDefinedReferenceItemRepository = new ClientDefinedReferenceItemRepository();
//clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(clientSubUnitCDRVM.ClientDefinedReferenceItemId);
//if(clientDefinedReferenceItem != null){
clientSubUnitClientDefinedReference.DisplayName = clientSubUnitCDRVM.DisplayName;
//}
try
{
clientSubUnitCDRRepository.Add(clientSubUnitClientDefinedReference);
}
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 = clientSubUnitCDRVM.ClientSubUnit.ClientSubUnitGuid }));
}
public ActionResult List(string filter, int?page, string id, string sortField, int?sortOrder)
{
//SortField + SortOrder settings
if (string.IsNullOrEmpty(sortField))
{
sortField = "RelatedToValue";
}
ViewData["CurrentSortField"] = sortField;
if (sortOrder == 1)
{
ViewData["NewSortOrder"] = 0;
ViewData["CurrentSortOrder"] = 1;
}
else
{
ViewData["NewSortOrder"] = 1;
ViewData["CurrentSortOrder"] = 0;
sortOrder = 0;
}
ClientSubUnitCDRsVM clientSubUnitCDRsVM = new ClientSubUnitCDRsVM();
clientSubUnitCDRsVM.ClientDefinedReferences = clientSubUnitCDRRepository.PageClientSubUnitCDRs(page ?? 1, filter ?? "", id, sortField, sortOrder);
RolesRepository rolesRepository = new RolesRepository();
clientSubUnitCDRsVM.HasWriteAccess = rolesRepository.HasWriteAccessToClientSubUnit(id);
clientSubUnitCDRsVM.HasCDRLinkImportAccess = rolesRepository.HasWriteAccessToCDRLinkImport();
/*
* DisplayName
* The ClientSubUnit may only be asscoiated with one Itemtype of ClientDefinedReference
* Therefore, we show Itemtype value if it has ClientDefinedReferenceItems assigned, otherwise a list of available Itemtype
*/
ClientDefinedReferenceItemRepository cdrItemRepository = new ClientDefinedReferenceItemRepository();
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
if (clientSubUnitCDRsVM.ClientDefinedReferences.Count == 0)
{
clientSubUnitCDRsVM.ClientDefinedReferenceItemId = null;
}
else
{
clientSubUnitCDRsVM.DisplayName = clientSubUnitCDRsVM.ClientDefinedReferences[0].DisplayName;
}
//ClientSubUnit
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(id);
if (clientSubUnit == null)
{
ViewData["ActionMethod"] = "List";
return(View("RecordDoesNotExistError"));
}
clientSubUnitCDRsVM.ClientSubUnit = clientSubUnit;
//RelatedToDisplayName
if (clientSubUnitCDRsVM.ClientDefinedReferences.Count > 0)
{
int clientSubUnitClientDefinedReferenceId = clientSubUnitCDRsVM.ClientDefinedReferences[0].ClientSubUnitClientDefinedReferenceId;
ClientSubUnitCDRItemRepository clientSubUnitCDRItemRepository = new ClientSubUnitCDRItemRepository();
List <ClientSubUnitClientDefinedReferenceItem> clientSubUnitClientDefinedReferenceItems = new List <ClientSubUnitClientDefinedReferenceItem>();
clientSubUnitClientDefinedReferenceItems = clientSubUnitCDRItemRepository.GetClientSubUnitCDRItems(clientSubUnitClientDefinedReferenceId);
if (clientSubUnitClientDefinedReferenceItems != null && clientSubUnitClientDefinedReferenceItems.Count > 0)
{
clientSubUnitCDRsVM.RelatedToDisplayName = clientSubUnitClientDefinedReferenceItems[0].RelatedToDisplayName;
}
}
//return items
return(View(clientSubUnitCDRsVM));
}
// GET: /List/
public ActionResult List(int id, string filter, int?page, string sortField, int?sortOrder, string csu)
{
ClientDefinedReferenceItemPNROutput clientDefinedReferenceItemPNROutput = new ClientDefinedReferenceItemPNROutput();
clientDefinedReferenceItemPNROutput = clientDefinedReferenceItemPNROutputRepository.GetClientDefinedReferenceItemPNROutput(id);
//Check Exists
if (clientDefinedReferenceItemPNROutput == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
//Set Access Rights
ViewData["Access"] = "";
if (hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Access"] = "WriteAccess";
}
//SortField
if (string.IsNullOrEmpty(sortField))
{
sortField = "LanguageName";
}
ViewData["CurrentSortField"] = sortField;
//SortOrder
if (sortOrder == 1)
{
ViewData["NewSortOrder"] = 0;
ViewData["CurrentSortOrder"] = 1;
}
else
{
ViewData["NewSortOrder"] = 1;
ViewData["CurrentSortOrder"] = 0;
}
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu);
//Check Exists
if (clientSubUnit == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItemId);
//Check Exists
if (clientDefinedReferenceItem == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
clientSubUnitRepository.EditGroupForDisplay(clientSubUnit);
ViewData["ClientTopUnitGuid"] = clientSubUnit.ClientTopUnitGuid;
ViewData["ClientTopUnitName"] = clientSubUnit.ClientTopUnitName;
ViewData["ClientSubUnitGuid"] = clientSubUnit.ClientSubUnitGuid;
ViewData["ClientSubUnitName"] = clientSubUnit.ClientSubUnitName;
ViewData["ClientDefinedReferenceItemId"] = clientDefinedReferenceItem.ClientDefinedReferenceItemId;
ViewData["ClientDefinedReferenceItemPNROutputId"] = clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItemPNROutputId;
ViewData["ClientDefinedReferenceItemPNROutputDefaultRemark"] = clientDefinedReferenceItemPNROutput.DefaultRemark;
ViewData["DisplayNameAlias"] = clientDefinedReferenceItem.DisplayNameAlias != null ? clientDefinedReferenceItem.DisplayNameAlias : clientDefinedReferenceItem.DisplayName;
var items = clientDefinedReferenceItemPNROutputLanguageRepository.PageClientDefinedReferenceItemPNROutputLanguages(id, filter ?? "", page ?? 1, sortField, sortOrder ?? 0);
return(View(items));
}
public ActionResult Delete(int id, string languageCode, string csu, string can, string ssc)
{
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu);
//Check Exists
if (clientSubUnit == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
ClientDefinedReferenceItemPNROutputLanguageVM clientDefinedReferenceItemPNROutputLanguageVM = new ClientDefinedReferenceItemPNROutputLanguageVM();
ClientDefinedReferenceItemPNROutput clientDefinedReferenceItemPNROutput = new ClientDefinedReferenceItemPNROutput();
clientDefinedReferenceItemPNROutput = clientDefinedReferenceItemPNROutputRepository.GetClientDefinedReferenceItemPNROutput(id);
//Check Exists
if (clientDefinedReferenceItemPNROutput == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItemId);
//Check Exists
if (clientDefinedReferenceItem == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
clientSubUnitRepository.EditGroupForDisplay(clientSubUnit);
ViewData["ClientTopUnitGuid"] = clientSubUnit.ClientTopUnitGuid;
ViewData["ClientTopUnitName"] = clientSubUnit.ClientTopUnitName;
ViewData["ClientSubUnitGuid"] = clientSubUnit.ClientSubUnitGuid;
ViewData["ClientSubUnitName"] = clientSubUnit.ClientSubUnitName;
ViewData["ClientDefinedReferenceItemId"] = clientDefinedReferenceItem.ClientDefinedReferenceItemId;
ViewData["ClientDefinedReferenceItemPNROutputId"] = clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItemPNROutputId;
ViewData["ClientDefinedReferenceItemPNROutputDefaultRemark"] = clientDefinedReferenceItemPNROutput.DefaultRemark;
ViewData["DisplayNameAlias"] = clientDefinedReferenceItem.DisplayNameAlias != null ? clientDefinedReferenceItem.DisplayNameAlias : clientDefinedReferenceItem.DisplayName;
if (can != null && ssc != null)
{
ClientAccount clientAccount = new ClientAccount();
ClientAccountRepository clientAccountRepository = new ClientAccountRepository();
clientAccount = clientAccountRepository.GetClientAccount(can, ssc);
if (clientAccount != null)
{
ViewData["ClientAccountName"] = clientAccount.ClientAccountName;
}
ViewData["ClientAccountNumber"] = can;
ViewData["SourceSystemCode"] = ssc;
}
ClientDefinedReferenceItemPNROutputLanguage clientDefinedReferenceItemPNROutputLanguage = new ClientDefinedReferenceItemPNROutputLanguage();
clientDefinedReferenceItemPNROutputLanguage = clientDefinedReferenceItemPNROutputLanguageRepository.GetClientDefinedReferenceItemPNROutputLanguage(id, languageCode);
//Check Exists
if (clientDefinedReferenceItemPNROutputLanguage == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
clientDefinedReferenceItemPNROutputLanguageVM.ClientDefinedReferenceItemPNROutputLanguage = clientDefinedReferenceItemPNROutputLanguage;
clientDefinedReferenceItemPNROutputLanguageVM.ClientDefinedReferenceItemPNROutput = clientDefinedReferenceItemPNROutput;
clientDefinedReferenceItemPNROutputLanguageVM.ClientSubUnit = clientSubUnit;
clientDefinedReferenceItem.ClientSubUnitGuid = clientSubUnit.ClientSubUnitGuid;
//Languages
LanguageRepository languageRepository = new LanguageRepository();
List <Language> languages = clientDefinedReferenceItemPNROutputLanguageRepository.GetAvailableLanguages(clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItemPNROutputId).ToList();
Language language = languageRepository.GetLanguage(clientDefinedReferenceItemPNROutputLanguage.LanguageCode);
if (language != null)
{
languages.Add(language);
}
clientDefinedReferenceItemPNROutputLanguageVM.Languages = new SelectList(languages, "LanguageCode", "LanguageName", clientDefinedReferenceItemPNROutputLanguage.LanguageCode);
return(View(clientDefinedReferenceItemPNROutputLanguageVM));
}
public ActionResult Delete(string id, FormCollection formCollection)
{
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Check Exists
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(id);
if (clientDefinedReferenceItem == null)
{
ViewData["ActionMethod"] = "ViewBySubUnitGet";
return(View("RecordDoesNotExistError"));
}
//Check Exists
ClientSubUnit clientSubUnit = new ClientSubUnit();
if (clientDefinedReferenceItem.ClientSubUnitGuid != null)
{
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(clientDefinedReferenceItem.ClientSubUnitGuid);
if (clientSubUnit == null)
{
ViewData["ActionMethod"] = "ViewBySubUnitGet";
return(View("RecordDoesNotExistError"));
}
}
//Delete Item
try
{
clientDefinedReferenceItemRepository.Delete(clientDefinedReferenceItem);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/ClientDefinedReferenceItem.mvc/Delete/" + clientDefinedReferenceItem.ClientDefinedReferenceItemId.ToString();
return(View("VersionError"));
}
//Restraint Error - go to standard DeleteError page
if (ex.Message == "SQLDeleteError")
{
ViewData["ReturnURL"] = "/ClientDefinedReferenceItem.mvc/Delete/" + clientDefinedReferenceItem.ClientDefinedReferenceItemId.ToString();
return(View("DeleteError"));
}
//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("ListBySubUnit", new {
id = formCollection["ClientSubUnit.ClientSubUnitGuid"],
can = clientDefinedReferenceItem.ClientAccountNumber,
ssc = clientDefinedReferenceItem.SourceSystemCode
}));
}
public ActionResult Delete(string id, string csu, string can, string ssc)
{
//Check Exists
ClientDefinedReferenceItemValue clientDefinedReferenceItemValue = new ClientDefinedReferenceItemValue();
clientDefinedReferenceItemValue = clientDefinedReferenceItemValueRepository.GetClientDefinedReferenceItemValue(id);
if (clientDefinedReferenceItemValue == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check Exists
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(clientDefinedReferenceItemValue.ClientDefinedReferenceItemId);
if (clientDefinedReferenceItem == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu);
//Check Exists
if (clientSubUnit == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
ClientDefinedReferenceItemValueVM clientDefinedReferenceItemValueVM = new ClientDefinedReferenceItemValueVM();
clientDefinedReferenceItemValueVM.ClientDefinedReferenceItemValue = clientDefinedReferenceItemValue;
ClientSubUnitClientAccount clientSubUnitClientAccount = new ClientSubUnitClientAccount();
clientSubUnitClientAccount = clientSubUnitClientAccountRepository.GetClientSubUnitClientAccount(clientDefinedReferenceItem.ClientAccountNumber, clientDefinedReferenceItem.SourceSystemCode, clientSubUnit.ClientSubUnitGuid);
if (clientSubUnitClientAccount != null)
{
clientDefinedReferenceItemValueVM.ClientSubUnitClientAccount = clientSubUnitClientAccount;
ViewData["ClientSubUnitClientAccountClientAccountName"] = clientSubUnitClientAccount.ClientAccount.ClientAccountName;
}
clientDefinedReferenceItemValueVM.ClientDefinedReferenceItem = clientDefinedReferenceItem;
clientDefinedReferenceItemValueVM.ClientSubUnit = clientSubUnit;
clientDefinedReferenceItemValueVM.ClientDefinedReferenceItemValue = clientDefinedReferenceItemValue;
if (can != null && ssc != null)
{
ClientAccount clientAccount = new ClientAccount();
ClientAccountRepository clientAccountRepository = new ClientAccountRepository();
clientAccount = clientAccountRepository.GetClientAccount(can, ssc);
if (clientAccount != null)
{
ViewData["ClientAccountName"] = clientAccount.ClientAccountName;
ViewData["ClientAccountNumber"] = clientDefinedReferenceItem.ClientAccountNumber;
ViewData["SourceSystemCode"] = clientDefinedReferenceItem.SourceSystemCode;
}
}
return(View(clientDefinedReferenceItemValueVM));
}
// GET: /List/
public ActionResult List(string filter, int?page, string id, string csu, string sortField, int?sortOrder)
{
//Check Exists
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(id);
if (clientDefinedReferenceItem == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu);
//Check Exists
if (clientSubUnit == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
//Set Access Rights
ViewData["Access"] = "";
if (hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Access"] = "WriteAccess";
}
//Set Create/Order Rights
ViewData["CreateAccess"] = "";
RolesRepository rolesRepository = new RolesRepository();
if (rolesRepository.HasWriteAccessToClientSubUnitClientDefinedReferenceItemValue(id))
{
ViewData["CreateAccess"] = "CreateAccess";
}
//SortField
if (string.IsNullOrEmpty(sortField))
{
sortField = "Value";
}
ViewData["CurrentSortField"] = sortField;
//SortOrder
if (sortOrder == 1)
{
ViewData["NewSortOrder"] = 0;
ViewData["CurrentSortOrder"] = 1;
}
else
{
ViewData["NewSortOrder"] = 1;
ViewData["CurrentSortOrder"] = 0;
}
clientSubUnitRepository.EditGroupForDisplay(clientSubUnit);
ViewData["ClientTopUnitGuid"] = clientSubUnit.ClientTopUnitGuid;
ViewData["ClientTopUnitName"] = clientSubUnit.ClientTopUnitName;
ViewData["ClientSubUnitGuid"] = clientSubUnit.ClientSubUnitGuid;
ViewData["ClientSubUnitName"] = clientSubUnit.ClientSubUnitName;
ViewData["ClientDefinedReferenceItemId"] = clientDefinedReferenceItem.ClientDefinedReferenceItemId ?? "";
ViewData["ClientDefinedReferenceItemDisplayNameAlias"] = clientDefinedReferenceItem.DisplayNameAlias ?? "";
var items = clientSubUnitClientDefinedReferenceItemValueRepository.PageClientDefinedReferenceItemValues(filter ?? "", id, page ?? 1, sortField, sortOrder ?? 0);
return(View(items));
}
// GET: /Create
public ActionResult Create(string id, string csu, string can, string ssc)
{
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu);
//Check Exists
if (clientSubUnit == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
ClientDefinedReferenceItemPNROutputVM clientDefinedReferenceItemPNROutputVM = new ClientDefinedReferenceItemPNROutputVM();
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(id);
ClientDefinedReferenceItemPNROutput clientDefinedReferenceItemPNROutput = new ClientDefinedReferenceItemPNROutput();
//ClientDefinedReferenceItem
if (clientDefinedReferenceItem == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
clientDefinedReferenceItem.ClientSubUnitGuid = clientSubUnit.ClientSubUnitGuid;
clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItem = clientDefinedReferenceItem;
clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItemId = clientDefinedReferenceItem.ClientDefinedReferenceItemId;
clientDefinedReferenceItemPNROutputVM.ClientDefinedReferenceItemPNROutput = clientDefinedReferenceItemPNROutput;
ViewData["DsplayName"] = !string.IsNullOrEmpty(clientDefinedReferenceItem.DisplayNameAlias) ? clientDefinedReferenceItem.DisplayNameAlias : clientDefinedReferenceItem.DisplayName;
if (can != null && ssc != null)
{
ClientSubUnitClientAccount clientSubUnitClientAccount = new ClientSubUnitClientAccount();
clientSubUnitClientAccount = clientSubUnitClientAccountRepository.GetClientSubUnitClientAccount(can, ssc, clientSubUnit.ClientSubUnitGuid);
if (clientSubUnitClientAccount != null)
{
ViewData["ClientSubUnitClientAccountClientAccountName"] = clientSubUnitClientAccount.ClientAccount.ClientAccountName;
}
clientDefinedReferenceItem.ClientAccountNumber = can;
clientDefinedReferenceItem.SourceSystemCode = ssc;
ViewData["ClientDefinedReferenceItemId"] = clientDefinedReferenceItem.ClientDefinedReferenceItemId;
ViewData["ClientAccountNumber"] = can;
ViewData["SourceSystemCode"] = ssc;
}
//ClientSubUnit
clientDefinedReferenceItemPNROutputVM.ClientSubUnit = clientSubUnit;
//GDS
GDSRepository GDSRepository = new GDSRepository();
clientDefinedReferenceItemPNROutputVM.GDSList = new SelectList(GDSRepository.GetAllGDSsExceptALL().OrderBy(x => x.GDSName).ToList(), "GDSCode", "GDSName");
//PNR Output Remark Types
PNROutputRemarkTypeRepository PNROutputRemarkTypeRepository = new PNROutputRemarkTypeRepository();
clientDefinedReferenceItemPNROutputVM.PNROutputRemarkTypeCodes = new SelectList(PNROutputRemarkTypeRepository.GetPNROutputRemarkTypes(), "PNROutputRemarkTypeCode", "PNROutputRemarkTypeName", "");
//Languages
LanguageRepository languageRepository = new LanguageRepository();
clientDefinedReferenceItemPNROutputVM.Languages = new SelectList(languageRepository.GetAllLanguages().ToList(), "LanguageCode", "LanguageName");
return(View(clientDefinedReferenceItemPNROutputVM));
}
public ClientDefinedReferenceItemPNROutputVM(
ClientDefinedReferenceItemPNROutput clientDefinedReferenceItemPNROutput,
ClientDefinedReferenceItem clientDefinedReferenceItem)
{
ClientDefinedReferenceItemPNROutput = clientDefinedReferenceItemPNROutput;
}
// GET: /Edit
public ActionResult Edit(int id, string csu, string can, string ssc)
{
ClientDefinedReferenceItemPNROutputVM clientDefinedReferenceItemPNROutputVM = new ClientDefinedReferenceItemPNROutputVM();
ClientDefinedReferenceItemPNROutput clientDefinedReferenceItemPNROutput = new ClientDefinedReferenceItemPNROutput();
clientDefinedReferenceItemPNROutput = clientDefinedReferenceItemPNROutputRepository.GetClientDefinedReferenceItemPNROutput(id);
if (clientDefinedReferenceItemPNROutput == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
clientDefinedReferenceItemPNROutputVM.ClientDefinedReferenceItemPNROutput = clientDefinedReferenceItemPNROutput;
//Check Exists
ClientDefinedReferenceItem clientDefinedReferenceItem = new ClientDefinedReferenceItem();
clientDefinedReferenceItem = clientDefinedReferenceItemRepository.GetClientDefinedReferenceItem(clientDefinedReferenceItemPNROutput.ClientDefinedReferenceItemId);
if (clientDefinedReferenceItem == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
//Check Exists CSU for VM
ClientSubUnit clientSubUnit = new ClientSubUnit();
clientSubUnit = clientSubUnitRepository.GetClientSubUnit(csu);
if (clientSubUnit != null)
{
clientSubUnitRepository.EditGroupForDisplay(clientSubUnit);
clientDefinedReferenceItemPNROutputVM.ClientSubUnit = clientSubUnit;
}
clientSubUnitRepository.EditGroupForDisplay(clientSubUnit);
ViewData["ClientTopUnitGuid"] = clientSubUnit.ClientTopUnitGuid;
ViewData["ClientTopUnitName"] = clientSubUnit.ClientTopUnitName;
ViewData["ClientSubUnitGuid"] = clientSubUnit.ClientSubUnitGuid;
ViewData["ClientSubUnitName"] = clientSubUnit.ClientSubUnitName;
ViewData["ClientDefinedReferenceItemId"] = clientDefinedReferenceItem.ClientDefinedReferenceItemId;
ViewData["DisplayNameAlias"] = clientDefinedReferenceItem.DisplayNameAlias != null ? clientDefinedReferenceItem.DisplayNameAlias : clientDefinedReferenceItem.DisplayName;
clientDefinedReferenceItemPNROutputVM.ClientSubUnit = clientSubUnit;
clientDefinedReferenceItem.ClientSubUnitGuid = clientSubUnit.ClientSubUnitGuid;
//GDS
GDSRepository GDSRepository = new GDSRepository();
clientDefinedReferenceItemPNROutputVM.GDSList = new SelectList(GDSRepository.GetAllGDSsExceptALL().OrderBy(x => x.GDSName).ToList(), "GDSCode", "GDSName");
//PNR Output Remark Types
PNROutputRemarkTypeRepository PNROutputRemarkTypeRepository = new PNROutputRemarkTypeRepository();
clientDefinedReferenceItemPNROutputVM.PNROutputRemarkTypeCodes = new SelectList(PNROutputRemarkTypeRepository.GetPNROutputRemarkTypes(), "PNROutputRemarkTypeCode", "PNROutputRemarkTypeName");
//Languages
LanguageRepository languageRepository = new LanguageRepository();
clientDefinedReferenceItemPNROutputVM.Languages = new SelectList(languageRepository.GetAllLanguages().ToList(), "LanguageCode", "LanguageName");
return(View(clientDefinedReferenceItemPNROutputVM));
}
