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;
}
