public MeetingPNROutputLanguageVM(
MeetingPNROutputLanguage meetingPNROutputLanguage,
MeetingPNROutput meetingPNROutput)
{
MeetingPNROutputLanguage = MeetingPNROutputLanguage;
MeetingPNROutput = meetingPNROutput;
}
//Add Data From Linked Tables for Display
public void EditGroupForDisplay(MeetingPNROutput group)
{
if (group.GDSCode != "")
{
GDSRepository GDSRepository = new GDSRepository();
GDS GDS = GDSRepository.GetGDS(group.GDSCode);
if (GDS != null)
{
group.GDS = GDS;
}
}
if (group.CountryCode != "")
{
CountryRepository countryRepository = new CountryRepository();
Country country = countryRepository.GetCountry(group.CountryCode);
if (country != null)
{
group.Country = country;
}
}
if (group.DefaultLanguageCode != "")
{
LanguageRepository languageRepository = new LanguageRepository();
Language language = languageRepository.GetLanguage(group.DefaultLanguageCode);
if (language != null)
{
group.Language = language;
}
}
}
// GET: /Create
public ActionResult Create(int id)
{
Meeting meeting = new Meeting();
meeting = meetingRepository.GetGroup(id);
//Check Exists
if (meeting == 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"));
}
MeetingPNROutputVM meetingPNROutputVM = new MeetingPNROutputVM();
MeetingPNROutput meetingPNROutput = new MeetingPNROutput();
meetingPNROutputVM.MeetingPNROutput = meetingPNROutput;
meetingRepository.EditGroupForDisplay(meeting);
ViewData["ClientTopUnitGuid"] = meeting.ClientTopUnitGuid;
ViewData["ClientTopUnitName"] = meeting.ClientTopUnit.ClientTopUnitName;
ViewData["MeetingID"] = meeting.MeetingID;
ViewData["MeetingName"] = meeting.MeetingName;
meetingPNROutputVM.Meeting = meeting;
meetingPNROutput.MeetingID = meeting.MeetingID;
//GDS
GDSRepository GDSRepository = new GDSRepository();
meetingPNROutputVM.GDSList = new SelectList(GDSRepository.GetAllGDSsExceptALL().OrderBy(x => x.GDSName).ToList(), "GDSCode", "GDSName");
//PNR Output Remark Types
PNROutputRemarkTypeRepository PNROutputRemarkTypeRepository = new PNROutputRemarkTypeRepository();
meetingPNROutputVM.PNROutputRemarkTypeCodes = new SelectList(PNROutputRemarkTypeRepository.GetMeetingPNROutputRemarkTypes(), "PNROutputRemarkTypeCode", "PNROutputRemarkTypeName", "");
//Languages
LanguageRepository languageRepository = new LanguageRepository();
meetingPNROutputVM.Languages = new SelectList(languageRepository.GetAllLanguages().ToList(), "LanguageCode", "LanguageName");
//Countries
CountryRepository countryRepository = new CountryRepository();
meetingPNROutputVM.Countries = new SelectList(countryRepository.GetAllCountries().ToList(), "CountryCode", "CountryName");
return(View(meetingPNROutputVM));
}
// GET: /Edit
public ActionResult Edit(int id)
{
MeetingPNROutputVM meetingPNROutputVM = new MeetingPNROutputVM();
MeetingPNROutput meetingPNROutput = new MeetingPNROutput();
meetingPNROutput = meetingPNROutputRepository.GetMeetingPNROutput(id);
if (meetingPNROutput == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
meetingPNROutputVM.MeetingPNROutput = meetingPNROutput;
//Check Exists Meeting for VM
Meeting meeting = new Meeting();
meeting = meetingRepository.GetGroup(meetingPNROutput.MeetingID);
if (meeting != null)
{
meetingRepository.EditGroupForDisplay(meeting);
meetingPNROutputVM.Meeting = meeting;
}
meetingRepository.EditGroupForDisplay(meeting);
ViewData["ClientTopUnitGuid"] = meeting.ClientTopUnitGuid;
ViewData["ClientTopUnitName"] = meeting.ClientTopUnit.ClientTopUnitName;
ViewData["MeetingID"] = meeting.MeetingID;
ViewData["MeetingName"] = meeting.MeetingName;
meetingPNROutputVM.Meeting = meeting;
meetingPNROutput.MeetingID = meeting.MeetingID;
//GDS
GDSRepository GDSRepository = new GDSRepository();
meetingPNROutputVM.GDSList = new SelectList(GDSRepository.GetAllGDSsExceptALL().OrderBy(x => x.GDSName).ToList(), "GDSCode", "GDSName", meetingPNROutput.GDSCode);
//PNR Output Remark Types
PNROutputRemarkTypeRepository PNROutputRemarkTypeRepository = new PNROutputRemarkTypeRepository();
meetingPNROutputVM.PNROutputRemarkTypeCodes = new SelectList(PNROutputRemarkTypeRepository.GetMeetingPNROutputRemarkTypes(), "PNROutputRemarkTypeCode", "PNROutputRemarkTypeName", meetingPNROutput.PNROutputRemarkTypeCode);
//Languages
LanguageRepository languageRepository = new LanguageRepository();
meetingPNROutputVM.Languages = new SelectList(languageRepository.GetAllLanguages().ToList(), "LanguageCode", "LanguageName", meetingPNROutput.DefaultLanguageCode);
//Countries
CountryRepository countryRepository = new CountryRepository();
meetingPNROutputVM.Countries = new SelectList(countryRepository.GetAllCountries().ToList(), "CountryCode", "CountryName", meetingPNROutput.CountryCode);
return(View(meetingPNROutputVM));
}
public ActionResult Edit(MeetingPNROutputVM meetingPNROutputVM)
{
MeetingPNROutput meetingPNROutput = new MeetingPNROutput();
meetingPNROutput = meetingPNROutputRepository.GetMeetingPNROutput(meetingPNROutputVM.MeetingPNROutput.MeetingPNROutputId);
//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(meetingPNROutputVM);
}
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
{
meetingPNROutputRepository.Update(meetingPNROutputVM.MeetingPNROutput);
}
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"));
}
return(RedirectToAction("List", new
{
id = meetingPNROutputVM.MeetingPNROutput.MeetingID
}));
}
//Delete Item
public void Delete(MeetingPNROutput meetingPNROutput)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_DeleteMeetingPNROutput_v1(
meetingPNROutput.MeetingPNROutputId,
meetingPNROutput.VersionNumber,
adminUserGuid
);
}
// GET: /Create
public ActionResult Create(int id)
{
MeetingPNROutput meetingPNROutput = new MeetingPNROutput();
meetingPNROutput = meetingPNROutputRepository.GetMeetingPNROutput(id);
//Check Exists
if (meetingPNROutput == 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"));
}
MeetingPNROutputLanguageVM meetingPNROutputLanguageVM = new MeetingPNROutputLanguageVM();
Meeting meeting = new Meeting();
meeting = meetingRepository.GetGroup(meetingPNROutput.MeetingID);
//Check Exists
if (meeting == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
meetingRepository.EditGroupForDisplay(meeting);
ViewData["ClientTopUnitGuid"] = meeting.ClientTopUnitGuid;
ViewData["ClientTopUnitName"] = meeting.ClientTopUnit.ClientTopUnitName;
ViewData["MeetingID"] = meeting.MeetingID;
ViewData["MeetingName"] = meeting.MeetingName;
ViewData["MeetingPNROutputId"] = meetingPNROutput.MeetingPNROutputId;
MeetingPNROutputLanguage meetingPNROutputLanguage = new MeetingPNROutputLanguage();
meetingPNROutputLanguage.MeetingPNROutputId = meetingPNROutput.MeetingPNROutputId;
meetingPNROutputLanguageVM.MeetingPNROutputLanguage = meetingPNROutputLanguage;
meetingPNROutputLanguageVM.MeetingPNROutput = meetingPNROutput;
//Languages
LanguageRepository languageRepository = new LanguageRepository();
meetingPNROutputLanguageVM.Languages = new SelectList(meetingPNROutputLanguageRepository.GetAvailableLanguages(meetingPNROutput.MeetingPNROutputId).ToList(), "LanguageCode", "LanguageName");
return(View(meetingPNROutputLanguageVM));
}
//Add Item
public void Add(MeetingPNROutput meetingPNROutput)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_InsertMeetingPNROutput_v1(
meetingPNROutput.MeetingID,
meetingPNROutput.PNROutputRemarkTypeCode,
meetingPNROutput.DefaultLanguageCode,
meetingPNROutput.GDSCode,
meetingPNROutput.GDSRemarkQualifier,
meetingPNROutput.DefaultRemark,
meetingPNROutput.CountryCode,
adminUserGuid
);
}
public ActionResult Delete(int id)
{
MeetingPNROutput meetingPNROutput = new MeetingPNROutput();
meetingPNROutput = meetingPNROutputRepository.GetMeetingPNROutput(id);
//Check Exists
if (meetingPNROutput == 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"));
}
MeetingPNROutputVM meetingPNROutputVM = new MeetingPNROutputVM();
Meeting meeting = new Meeting();
meeting = meetingRepository.GetGroup(meetingPNROutput.MeetingID);
//Check Exists
if (meeting == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
meetingRepository.EditGroupForDisplay(meeting);
ViewData["ClientTopUnitGuid"] = meeting.ClientTopUnitGuid;
ViewData["ClientTopUnitName"] = meeting.ClientTopUnit.ClientTopUnitName;
ViewData["MeetingID"] = meeting.MeetingID;
ViewData["MeetingName"] = meeting.MeetingName;
meetingPNROutputVM.Meeting = meeting;
meetingPNROutput.MeetingID = meeting.MeetingID;
meetingPNROutputRepository.EditGroupForDisplay(meetingPNROutput);
meetingPNROutputVM.MeetingPNROutput = meetingPNROutput;
return(View(meetingPNROutputVM));
}
//Get one MeetingPNROutput
public MeetingPNROutput GetMeetingPNROutput(int meetingPNROutputId)
{
MeetingPNROutput meetingPNROutput = new MeetingPNROutput();
meetingPNROutput = db.MeetingPNROutputs.SingleOrDefault(c => c.MeetingPNROutputId == meetingPNROutputId);
if (meetingPNROutput != null)
{
PNROutputRemarkType PNROutputRemarkType = new PNROutputRemarkType();
PNROutputRemarkTypeRepository PNROutputRemarkTypeRepository = new PNROutputRemarkTypeRepository();
PNROutputRemarkType = PNROutputRemarkTypeRepository.GetPNROutputRemarkType(meetingPNROutput.PNROutputRemarkTypeCode);
if (PNROutputRemarkType != null)
{
meetingPNROutput.PNROutputRemarkType = PNROutputRemarkType;
}
}
return(meetingPNROutput);
}
public ActionResult Delete(MeetingPNROutputVM meetingPNROutputVM)
{
MeetingPNROutput meetingPNROutput = new MeetingPNROutput();
meetingPNROutput = meetingPNROutputRepository.GetMeetingPNROutput(meetingPNROutputVM.MeetingPNROutput.MeetingPNROutputId);
//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
{
meetingPNROutputRepository.Delete(meetingPNROutputVM.MeetingPNROutput);
}
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"));
}
return(RedirectToAction("List", new
{
id = meetingPNROutputVM.MeetingPNROutput.MeetingID
}));
}
public MeetingPNROutputVM(
MeetingPNROutput meetingPNROutput,
Meeting meeting)
{
MeetingPNROutput = meetingPNROutput;
}
// GET: /List/
public ActionResult List(int id, string filter, int?page, string sortField, int?sortOrder, string csu, string can, string ssc)
{
MeetingPNROutput meetingPNROutput = new MeetingPNROutput();
meetingPNROutput = meetingPNROutputRepository.GetMeetingPNROutput(id);
//Check Exists
if (meetingPNROutput == 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;
}
Meeting meeting = new Meeting();
meeting = meetingRepository.GetGroup(meetingPNROutput.MeetingID);
//Check Exists
if (meeting == null)
{
ViewData["ActionMethod"] = "ListGet";
return(View("RecordDoesNotExistError"));
}
meetingRepository.EditGroupForDisplay(meeting);
ViewData["ClientTopUnitGuid"] = meeting.ClientTopUnitGuid;
ViewData["ClientTopUnitName"] = meeting.ClientTopUnit.ClientTopUnitName;
ViewData["MeetingID"] = meeting.MeetingID;
ViewData["MeetingName"] = meeting.MeetingName;
ViewData["MeetingPNROutputId"] = meetingPNROutput.MeetingPNROutputId;
var items = meetingPNROutputLanguageRepository.PageMeetingPNROutputLanguages(id, filter ?? "", page ?? 1, sortField, sortOrder ?? 0);
return(View(items));
}
