//Add Data From Linked Tables for Display
public void EditItemForDisplay(TicketQueueItem ticketQueueItem)
{
TicketTypeRepository ticketTypeRepository = new TicketTypeRepository();
TicketType ticketType = new TicketType();
ticketType = ticketTypeRepository.GetTicketType(ticketQueueItem.TicketTypeId);
if (ticketType != null)
{
ticketQueueItem.TicketTypeDescription = ticketType.TicketTypeDescription;
}
TicketQueueGroupRepository ticketQueueGroupRepository = new TicketQueueGroupRepository();
TicketQueueGroup ticketQueueGroup = new TicketQueueGroup();
ticketQueueGroup = ticketQueueGroupRepository.GetGroup(ticketQueueItem.TicketQueueGroupId);
if (ticketQueueGroup != null)
{
ticketQueueItem.TicketQueueGroupName = ticketQueueGroup.TicketQueueGroupName;
}
GDSRepository gdsRepository = new GDSRepository();
GDS gds = new GDS();
gds = gdsRepository.GetGDS(ticketQueueItem.GDSCode);
if (gds != null)
{
ticketQueueItem.GDSName = gds.GDSName;
}
}
public ActionResult Delete(int id)
{
//Get Item
TicketQueueItem ticketQueueItem = new TicketQueueItem();
ticketQueueItem = ticketQueueItemRepository.GetItem(id);
//Check Exists
if (ticketQueueItem == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToTicketQueueGroup(ticketQueueItem.TicketQueueGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Parent Information
ViewData["TicketQueueGroupId"] = ticketQueueItem.TicketQueueGroupId;
ViewData["TicketQueueGroupName"] = ticketQueueGroupRepository.GetGroup(ticketQueueItem.TicketQueueGroupId).TicketQueueGroupName;
//Add Linked Informationn
ticketQueueItemRepository.EditItemForDisplay(ticketQueueItem);
//Show To User
return(View(ticketQueueItem));
}
public ActionResult Create(TicketQueueItem ticketQueueItem)
{
//Get WorkFlowGroup
TicketQueueGroup ticketQueueGroup = new TicketQueueGroup();
ticketQueueGroup = ticketQueueGroupRepository.GetGroup(ticketQueueItem.TicketQueueGroupId);
//Check Exists
if (ticketQueueGroup == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToTicketQueueGroup(ticketQueueItem.TicketQueueGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Update Model from Form
try
{
UpdateModel(ticketQueueItem);
}
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
{
ticketQueueItemRepository.Add(ticketQueueItem);
}
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 = ticketQueueItem.TicketQueueGroupId }));
}
//Delete From DB
public void Delete(TicketQueueItem ticketQueueItem)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_DeleteTicketQueueItem_v1(
ticketQueueItem.TicketQueueItemId,
adminUserGuid,
ticketQueueItem.VersionNumber);
}
public static string GetTicketQueueItem(RestCommand command, int ticketQueueID)
{
TicketQueueItem ticketQueueItem = TicketQueue.GetTicketQueueItem(command.LoginUser, ticketQueueID);
if (ticketQueueItem.OrganizationID != command.Organization.OrganizationID)
{
throw new RestException(HttpStatusCode.Unauthorized);
}
return(ticketQueueItem.GetXml("TicketQueueItem", true));
}
//Add to DB
public void Add(TicketQueueItem ticketQueueItem)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_InsertTicketQueueItem_v1(
ticketQueueItem.TicketQueueGroupId,
ticketQueueItem.TicketQueueItemDescription,
ticketQueueItem.PseudoCityOrOfficeId,
ticketQueueItem.GDSCode,
ticketQueueItem.QueueNumber,
ticketQueueItem.QueueCategory,
ticketQueueItem.TicketTypeId,
ticketQueueItem.TicketingFieldRemark,
ticketQueueItem.TicketingCommand,
adminUserGuid
);
}
public ActionResult Delete(int id, FormCollection collection)
{
//Get Item
TicketQueueItem ticketQueueItem = new TicketQueueItem();
ticketQueueItem = ticketQueueItemRepository.GetItem(id);
//Check Exists
if (ticketQueueItem == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToTicketQueueGroup(ticketQueueItem.TicketQueueGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Delete Item
try
{
ticketQueueItem.VersionNumber = Int32.Parse(collection["VersionNumber"]);
ticketQueueItemRepository.Delete(ticketQueueItem);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/TicketQueueItem.mvc/Delete?id=" + ticketQueueItem.TicketQueueItemId.ToString();
return(View("VersionError"));
}
//Generic Error
ViewData["Message"] = ex.Message;
return(View("Error"));
}
//Return
return(RedirectToAction("List", new { id = ticketQueueItem.TicketQueueGroupId }));
}
// GET: /Edit
public ActionResult Edit(int id)
{
//AccessRights
TicketQueueItem ticketQueueItem = new TicketQueueItem();
ticketQueueItem = ticketQueueItemRepository.GetItem(id);
//Check Exists
if (ticketQueueItem == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToTicketQueueGroup(ticketQueueItem.TicketQueueGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
TicketTypeRepository ticketTypeRepository = new TicketTypeRepository();
SelectList ticketTypeList = new SelectList(ticketTypeRepository.GetAllTicketTypes().ToList(), "TicketTypeId", "TicketTypeDescription");
ViewData["TicketTypes"] = ticketTypeList;
GDSRepository gdsRepository = new GDSRepository();
SelectList gdsList = new SelectList(gdsRepository.GetAllGDSs().ToList(), "GDSCode", "GDSName");
ViewData["GDSs"] = gdsList;
//Parent Information
ViewData["TicketQueueGroupId"] = ticketQueueItem.TicketQueueGroupId;
ViewData["TicketQueueGroupName"] = ticketQueueGroupRepository.GetGroup(ticketQueueItem.TicketQueueGroupId).TicketQueueGroupName;
//Add Linked Information
ticketQueueItemRepository.EditItemForDisplay(ticketQueueItem);
//Show To User
return(View(ticketQueueItem));
}
// GET: /Create
public ActionResult Create(int Id)
{
//Get WorkFlowGroup
TicketQueueGroup ticketQueueGroup = new TicketQueueGroup();
ticketQueueGroup = ticketQueueGroupRepository.GetGroup(Id);
//Check Exists
if (ticketQueueGroup == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToTicketQueueGroup(Id))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
TicketTypeRepository ticketTypeRepository = new TicketTypeRepository();
SelectList ticketTypeList = new SelectList(ticketTypeRepository.GetAllTicketTypes().ToList(), "TicketTypeId", "TicketTypeDescription");
ViewData["TicketTypes"] = ticketTypeList;
GDSRepository gdsRepository = new GDSRepository();
SelectList gdsList = new SelectList(gdsRepository.GetAllGDSs().ToList(), "GDSCode", "GDSName");
ViewData["GDSs"] = gdsList;
TicketQueueItem ticketQueueItem = new TicketQueueItem();
ticketQueueItem.TicketQueueGroupId = ticketQueueGroup.TicketQueueGroupId;
ticketQueueItem.TicketQueueGroupName = ticketQueueGroup.TicketQueueGroupName;
return(View(ticketQueueItem));
}
// GET: /View
public ActionResult View(int id)
{
//Get Item
TicketQueueItem ticketQueueItem = new TicketQueueItem();
ticketQueueItem = ticketQueueItemRepository.GetItem(id);
//Check Exists
if (ticketQueueItem == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
//Parent Information
ViewData["TicketQueueGroupId"] = ticketQueueItem.TicketQueueGroupId;
ViewData["TicketQueueGroupName"] = ticketQueueGroupRepository.GetGroup(ticketQueueItem.TicketQueueGroupId).TicketQueueGroupName;
//Add Linked Information
ticketQueueItemRepository.EditItemForDisplay(ticketQueueItem);
//Show To User
return(View(ticketQueueItem));
}
public ActionResult Edit(int id, FormCollection collection)
{
//Get Item
TicketQueueItem ticketQueueItem = new TicketQueueItem();
ticketQueueItem = ticketQueueItemRepository.GetItem(id);
//Check Exists
if (ticketQueueItem == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToTicketQueueGroup(ticketQueueItem.TicketQueueGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
try
{
UpdateModel(ticketQueueItem);
}
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
{
ticketQueueItemRepository.Edit(ticketQueueItem);
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/TicketQueueItem.mvc/Edit?id=" + ticketQueueItem.TicketQueueItemId.ToString();
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(RedirectToAction("List", new { id = ticketQueueItem.TicketQueueGroupId }));
}
