//GDSRequestTypes to XML
public XElement GetGDSRequestTypesXML(GDSContact gdsContact)
{
XmlDocument doc = new XmlDocument();
XmlDeclaration dec = doc.CreateXmlDeclaration("1.0", null, null);
doc.AppendChild(dec);
XmlElement root = doc.CreateElement("GDSRequestTypes");
doc.AppendChild(root);
if (gdsContact.GDSRequestTypes != null)
{
foreach (GDSRequestType gdsRequestType in gdsContact.GDSRequestTypes)
{
XmlElement xmlGDSRequestType = doc.CreateElement("GDSRequestType");
XmlElement xmlGDSRequestTypeId = doc.CreateElement("GDSRequestTypeId");
xmlGDSRequestTypeId.InnerText = gdsRequestType.GDSRequestTypeId.ToString();
xmlGDSRequestType.AppendChild(xmlGDSRequestTypeId);
root.AppendChild(xmlGDSRequestType);
}
}
return(System.Xml.Linq.XElement.Parse(doc.OuterXml));
}
//Delete in DB
public void Delete(GDSContact gdsContact)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_DeleteGDSContact_v1(
gdsContact.GDSContactId,
adminUserGuid,
gdsContact.VersionNumber
);
}
// GET: /Edit
public ActionResult Edit(int id)
{
//Get Item
GDSContact gdsContact = new GDSContact();
gdsContact = gdsContactRepository.GetGDSContact(id);
//Check Exists
if (gdsContact == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
GDSContactVM GDSContactVM = new GDSContactVM();
gdsContactRepository.EditForDisplay(gdsContact);
//Countries
GDSContactVM.Countries = new SelectList(countryRepository.GetAllCountries().ToList(), "CountryCode", "CountryName", gdsContact.CountryCode);
//GDS
GDSContactVM.GDSs = new SelectList(gdsRepository.GetAllGDSs().ToList(), "GDSCode", "GDSName", gdsContact.GDSCode);
//GDSRegions
GDSContactVM.GlobalRegions = new SelectList(hierarchyRepository.GetAllGlobalRegions().ToList(), "GlobalRegionCode", "GlobalRegionName", gdsContact.GlobalRegionCode);
//GDSRequestTypes
GDSContactVM.GDSRequestTypes = new SelectList(gdsRequestTypeRepository.GetAllGDSRequestTypes().ToList(), "GDSRequestTypeId", "GDSRequestTypeName", gdsContact.GDSRequestTypeIds);
//PseudoCityOrOfficeBusinesses
GDSContactVM.PseudoCityOrOfficeBusinesses = new SelectList(pseudoCityOrOfficeBusinessRepository.GetAllPseudoCityOrOfficeBusinesses().ToList(), "PseudoCityOrOfficeBusinessId", "PseudoCityOrOfficeBusinessName", gdsContact.PseudoCityOrOfficeBusinessId);
//PseudoCityOrOfficeDefinedRegions
GDSContactVM.PseudoCityOrOfficeDefinedRegions = new SelectList(pseudoCityOrOfficeDefinedRegionRepository.GetAllPseudoCityOrOfficeDefinedRegions().ToList(), "PseudoCityOrOfficeDefinedRegionId", "PseudoCityOrOfficeDefinedRegionName", gdsContact.PseudoCityOrOfficeDefinedRegionId);
GDSContactVM.GDSContact = gdsContact;
return(View(GDSContactVM));
}
// GET: /View
public ActionResult ViewItem(int id)
{
//Check Exists
GDSContact GDSContact = new GDSContact();
GDSContact = gdsContactRepository.GetGDSContact(id);
if (GDSContact == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
gdsContactRepository.EditForDisplay(GDSContact);
return(View(GDSContact));
}
public ActionResult Delete(GDSContactVM gdsContactVM)
{
//Get Item
GDSContact gdsContact = new GDSContact();
gdsContact = gdsContactRepository.GetGDSContact(gdsContactVM.GDSContact.GDSContactId);
//Check Exists
if (gdsContactVM.GDSContact == null)
{
ViewData["ActionMethod"] = "DeletePost";
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"));
}
//Delete Item
try
{
gdsContactRepository.Delete(gdsContact);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/GDSContact.mvc/Delete/" + gdsContact.GDSContactId;
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"));
}
//Add to DB
public void Add(GDSContact gdsContact)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
XElement gdsRequestTypes = GetGDSRequestTypesXML(gdsContact);
db.spDesktopDataAdmin_InsertGDSContact_v1(
gdsContact.GDSCode,
gdsContact.CountryCode,
gdsContact.GlobalRegionCode,
gdsContact.PseudoCityOrOfficeBusinessId,
gdsContact.PseudoCityOrOfficeDefinedRegionId,
gdsContact.LastName,
gdsContact.FirstName,
gdsContact.EmailAddress,
gdsContact.Phone,
gdsRequestTypes,
adminUserGuid
);
}
public ActionResult Delete(int id)
{
GDSContactVM GDSContactVM = new GDSContactVM();
GDSContact gdsContact = new GDSContact();
gdsContact = gdsContactRepository.GetGDSContact(id);
//Check Exists
if (gdsContact == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
gdsContactRepository.EditForDisplay(gdsContact);
GDSContactVM.GDSContact = gdsContact;
return(View(GDSContactVM));
}
//Add Data From Linked Tables for Display
public void EditForDisplay(GDSContact gdsContact)
{
//GDSRequestTypeIds
GDSContactGDSRequestTypeRepository gdsContactGDSRequestTypeRepository = new GDSContactGDSRequestTypeRepository();
gdsContact.GDSRequestTypeIds = gdsContactGDSRequestTypeRepository.GetGDSContactGDSRequestTypes(gdsContact.GDSContactId).Select(x => x.GDSRequestTypeId);
//GDSRequestTypes
List <GDSRequestType> gdsContactRequestTypes = new List <GDSRequestType>();
foreach (int gdsContactRequestTypeId in gdsContact.GDSRequestTypeIds)
{
GDSRequestTypeRepository gdsRequestTypeRepository = new GDSRequestTypeRepository();
GDSRequestType gdsRequestType = gdsRequestTypeRepository.GetGDSRequestType(gdsContactRequestTypeId);
if (gdsRequestType != null)
{
gdsContactRequestTypes.Add(gdsRequestType);
}
}
gdsContact.GDSRequestTypes = gdsContactRequestTypes;
}
public ActionResult Create()
{
//AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
GDSContactVM GDSContactVM = new GDSContactVM();
//Create Item
GDSContact gdsContact = new GDSContact();
//Countries
GDSContactVM.Countries = new SelectList(countryRepository.GetAllCountries().ToList(), "CountryCode", "CountryName");
//GDS
GDSContactVM.GDSs = new SelectList(gdsRepository.GetAllGDSs().ToList(), "GDSCode", "GDSName");
//GDSRegions
GDSContactVM.GlobalRegions = new SelectList(hierarchyRepository.GetAllGlobalRegions().ToList(), "GlobalRegionCode", "GlobalRegionName");
//GDSRequestTypes
GDSContactVM.GDSRequestTypes = new SelectList(gdsRequestTypeRepository.GetAllGDSRequestTypes().ToList(), "GDSRequestTypeId", "GDSRequestTypeName");
//PseudoCityOrOfficeBusinesses
GDSContactVM.PseudoCityOrOfficeBusinesses = new SelectList(pseudoCityOrOfficeBusinessRepository.GetAllPseudoCityOrOfficeBusinesses().ToList(), "PseudoCityOrOfficeBusinessId", "PseudoCityOrOfficeBusinessName");
//PseudoCityOrOfficeDefinedRegions
GDSContactVM.PseudoCityOrOfficeDefinedRegions = new SelectList(pseudoCityOrOfficeDefinedRegionRepository.GetAllPseudoCityOrOfficeDefinedRegions().ToList(), "PseudoCityOrOfficeDefinedRegionId", "PseudoCityOrOfficeDefinedRegionName");
GDSContactVM.GDSContact = gdsContact;
return(View(GDSContactVM));
}
public ActionResult Create(GDSContact gdsContact, FormCollection formCollection)
{
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Convert GDSRequestTypeIds to GDSRequestTypes
List <GDSRequestType> gdsContactRequestTypes = new List <GDSRequestType>();
string key = "GDSContact.GDSRequestTypeIds";
if (formCollection[key] != null)
{
List <int> gdsContactRequestTypeIds = formCollection[key].Split(',').Select(Int32.Parse).ToList();
foreach (int gdsContactRequestTypeId in gdsContactRequestTypeIds)
{
GDSRequestTypeRepository gdsRequestTypeRepository = new GDSRequestTypeRepository();
GDSRequestType gdsRequestType = gdsRequestTypeRepository.GetGDSRequestType(gdsContactRequestTypeId);
if (gdsRequestType != null)
{
gdsContactRequestTypes.Add(gdsRequestType);
}
}
}
gdsContact.GDSRequestTypes = gdsContactRequestTypes;
//Update Model from Form
try
{
UpdateModel(gdsContact);
}
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
{
gdsContactRepository.Add(gdsContact);
}
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"));
}
public GDSContactVM(GDSContact gdsContact)
{
GDSContact = gdsContact;
}
