public ActionResult Delete(int id) { ChatMessageFAQVM chatMessageFAQVM = new ChatMessageFAQVM(); ChatMessageFAQ chatMessageFAQ = new ChatMessageFAQ(); chatMessageFAQ = chatMessageFAQRepository.GetChatMessageFAQ(id); //Check Exists if (chatMessageFAQ == null) { ViewData["ActionMethod"] = "ViewGet"; return(View("RecordDoesNotExistError")); } chatMessageFAQVM.ChatMessageFAQ = chatMessageFAQ; //Attached Items List <ChatMessageFAQReference> chatMessageFAQReferences = chatMessageFAQRepository.GetChatMessageFAQReferences(chatMessageFAQ.ChatMessageFAQId); if (chatMessageFAQReferences.Count > 0) { chatMessageFAQVM.AllowDelete = false; chatMessageFAQVM.ChatMessageFAQReferences = chatMessageFAQReferences; } chatMessageFAQRepository.EditForDisplay(chatMessageFAQ); return(View(chatMessageFAQVM)); }
// GET: /Edit public ActionResult Edit(int id) { //Get Item ChatMessageFAQ chatMessageFAQ = new ChatMessageFAQ(); chatMessageFAQ = chatMessageFAQRepository.GetChatMessageFAQ(id); //Check Exists if (chatMessageFAQ == 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")); } chatMessageFAQRepository.EditForDisplay(chatMessageFAQ); return(View(chatMessageFAQ)); }
//Add to DB public void Add(ChatMessageFAQ chatMessageFAQ) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_InsertChatMessageFAQ_v1( chatMessageFAQ.ChatMessageFAQName, adminUserGuid ); }
//Delete in DB public void Delete(ChatMessageFAQ chatMessageFAQ) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_DeleteChatMessageFAQ_v1( chatMessageFAQ.ChatMessageFAQId, adminUserGuid, chatMessageFAQ.VersionNumber ); }
// GET: /View public ActionResult ViewItem(int id) { //Check Exists ChatMessageFAQ chatMessageFAQ = new ChatMessageFAQ(); chatMessageFAQ = chatMessageFAQRepository.GetChatMessageFAQ(id); if (chatMessageFAQ == null) { ViewData["ActionMethod"] = "ViewGet"; return(View("RecordDoesNotExistError")); } chatMessageFAQRepository.EditForDisplay(chatMessageFAQ); return(View(chatMessageFAQ)); }
public ActionResult Create() { //Create Item ChatMessageFAQ chatMessageFAQ = new ChatMessageFAQ(); //AccessRights RolesRepository rolesRepository = new RolesRepository(); if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } return(View(chatMessageFAQ)); }
public ActionResult Create(ChatMessageFAQ chatMessageFAQ) { //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 try { UpdateModel(chatMessageFAQ); } 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 { chatMessageFAQRepository.Add(chatMessageFAQ); } 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 ActionResult Delete(ChatMessageFAQVM chatMessageFAQVM) { //Get Item ChatMessageFAQ chatMessageFAQ = new ChatMessageFAQ(); chatMessageFAQ = chatMessageFAQRepository.GetChatMessageFAQ(chatMessageFAQVM.ChatMessageFAQ.ChatMessageFAQId); //Check Exists if (chatMessageFAQVM.ChatMessageFAQ == 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 { chatMessageFAQRepository.Delete(chatMessageFAQ); } catch (SqlException ex) { //Versioning Error - go to standard versionError page if (ex.Message == "SQLVersioningError") { ViewData["ReturnURL"] = "/ChatMessageFAQ.mvc/Delete/" + chatMessageFAQ.ChatMessageFAQId; 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 Data From Linked Tables for Display public void EditItemForDisplay(ChatFAQResponseItem chatFAQResponseItem) { //ChatMessageFAQName if (chatFAQResponseItem.ChatMessageFAQId > 0) { ChatMessageFAQRepository chatMessageFAQRepository = new ChatMessageFAQRepository(); ChatMessageFAQ chatMessageFAQ = chatMessageFAQRepository.GetChatMessageFAQ(chatFAQResponseItem.ChatMessageFAQId); if (chatMessageFAQ != null) { chatFAQResponseItem.ChatMessageFAQName = chatMessageFAQ.ChatMessageFAQName; } } //Set LanguageName to en-gb LanguageRepository languageRepository = new LanguageRepository(); Language language = languageRepository.GetLanguage("en-GB"); if (language != null) { chatFAQResponseItem.LanguageCode = language.LanguageCode; chatFAQResponseItem.LanguageName = language.LanguageName; } }
//Add Data From Linked Tables for Display public void EditForDisplay(ChatMessageFAQ chatMessageFAQ) { }
private void ValidateLines(ref XmlDocument doc, string[] lines, ref List <string> returnMessages) { XmlDeclaration dec = doc.CreateXmlDeclaration("1.0", null, null); doc.AppendChild(dec); XmlElement root = doc.CreateElement("ChatFAQResponseItems"); doc.AppendChild(root); string returnMessage; int i = 0; //Store Valid ClientSubUnits List <int> validChatMessageFAQIds = new List <int>(); List <int> invalidChatMessageFAQIds = new List <int>(); //loop through CSV lines foreach (string line in lines) { i++; if (i > 1) //ignore first line with titles { Regex csvParser = new Regex(",(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))"); String[] cells = csvParser.Split(line); //extract the data items from the file string chatMessageFAQIdValue = CWTStringHelpers.NullToEmpty(CWTStringHelpers.UnescapeQuotes(cells[0])); //Required string chatFAQResponseItemDescription = CWTStringHelpers.NullToEmpty(CWTStringHelpers.UnescapeQuotes(cells[1])); //Required //Build the XML Element for items XmlElement xmlChatFAQResponseItem = doc.CreateElement("ChatFAQResponseItem"); //Validate data /* ChatMessageFAQId */ int chatMessageFAQId = 0; //Required if (string.IsNullOrEmpty(chatMessageFAQIdValue) == true || !int.TryParse(chatMessageFAQIdValue, out chatMessageFAQId)) { returnMessage = "Row " + i + ": ChatMessageFAQId is missing. Please provide a Chat Message FAQ Id"; if (!returnMessages.Contains(returnMessage)) { returnMessages.Add(returnMessage); } } else { bool existingValidChatMessageFAQId = validChatMessageFAQIds.Contains(chatMessageFAQId); bool existingInvalidChatMessageFAQId = invalidChatMessageFAQIds.Contains(chatMessageFAQId); //Check Chat Message FAQ Id is valid if (existingInvalidChatMessageFAQId) { //Error: Chat Message FAQ Id is invalid returnMessage = string.Format("Row " + i + ": ChatMessageFAQId {0} is invalid. Please provide a valid Chat Message FAQ Id", chatMessageFAQId.ToString()); if (!returnMessages.Contains(returnMessage)) { returnMessages.Add(returnMessage); } } else if (existingValidChatMessageFAQId) { //Error: Chat Message FAQ Id is duplicated in file returnMessage = string.Format("Row " + i + ": ChatMessageFAQId {0} is not unique. Please remove duplicate Chat Message FAQ Id", chatMessageFAQId.ToString()); if (!returnMessages.Contains(returnMessage)) { returnMessages.Add(returnMessage); } } else { //Check if valid Chat Message FAQ ChatMessageFAQRepository chatMessageFAQRepository = new ChatMessageFAQRepository(); ChatMessageFAQ chatMessageFAQ = chatMessageFAQRepository.GetChatMessageFAQ(chatMessageFAQId); //Error: Chat Message FAQ Id is invalid if (chatMessageFAQ == null) { returnMessage = string.Format("Row " + i + ": ChatMessageFAQId {0} is invalid. Please provide a valid Chat Message FAQ Id", chatMessageFAQId.ToString()); if (!returnMessages.Contains(returnMessage)) { returnMessages.Add(returnMessage); } if (!invalidChatMessageFAQIds.Contains(chatMessageFAQId)) { invalidChatMessageFAQIds.Add(chatMessageFAQId); } } else { validChatMessageFAQIds.Add(chatMessageFAQId); } } } XmlElement xmlChatMessageFAQId = doc.CreateElement("ChatMessageFAQId"); xmlChatMessageFAQId.InnerText = chatMessageFAQId.ToString(); xmlChatFAQResponseItem.AppendChild(xmlChatMessageFAQId); //ChatFAQResponseItemDescription string dataRegex = @"^([À-ÿ\w\s\/\*\-\.\(\)\,\u0022\“\'\%\$\=\+\?\!\:\;\@\<\>\""]+)"; if (string.IsNullOrEmpty(chatFAQResponseItemDescription.Trim())) { //Error: ChatFAQResponseItemDescription is missing returnMessage = string.Format("Row " + i + ": ChatFAQResponseItemDescription is missing. Please provide a Chat FAQ Response"); if (!returnMessages.Contains(returnMessage)) { returnMessages.Add(returnMessage); } } else if (chatFAQResponseItemDescription.Length > 400) { //Error: ChatFAQResponseItemDescription is too long returnMessage = string.Format("Row " + i + ": ChatFAQResponseItemDescription contains more than 400 characters. Please provide a valid Chat FAQ Response"); if (!returnMessages.Contains(returnMessage)) { returnMessages.Add(returnMessage); } } else if (!Regex.Match(chatFAQResponseItemDescription, dataRegex).Success) { //Error: ChatFAQResponseItemDescription contains invalid characters returnMessage = string.Format("Row " + i + ": ChatFAQResponseItemDescription contains invalid special characters. Please provide a valid Chat FAQ Response"); if (!returnMessages.Contains(returnMessage)) { returnMessages.Add(returnMessage); } } XmlElement xmlChatFAQResponseItemDescription = doc.CreateElement("ChatFAQResponseItemDescription"); xmlChatFAQResponseItemDescription.InnerText = chatFAQResponseItemDescription; xmlChatFAQResponseItem.AppendChild(xmlChatFAQResponseItemDescription); //Attach the XML Element for an item to the Document root.AppendChild(xmlChatFAQResponseItem); } } if (i < 2) { returnMessage = "There is no data in the file"; returnMessages.Add(returnMessage); } }
public ChatMessageFAQVM(ChatMessageFAQ chatMessageFAQ) { ChatMessageFAQ = chatMessageFAQ; }