public DataSet DownloadTicketsHistory(String connection, UserDefinedClasses.Ticket ticket)
{
DataSet ds = new DataSet();
try
{
Press3.DataAccessLayer.Ticket ticketObj = new Press3.DataAccessLayer.Ticket(connection);
ds = ticketObj.GetTicketsHistory(ticket);
}
catch (Exception ex)
{
Logger.Error("Exception In DownloadTicketsHistory " + ex.ToString());
}
return(ds);
}
public JObject GetTicketsToMerge(String connection, string ticketIds)
{
try
{
Press3.DataAccessLayer.Ticket ticketObj = new Press3.DataAccessLayer.Ticket(connection);
DataSet ds = ticketObj.GetTicketsToMerge(ticketIds);
if (ds == null)
{
helper.CreateProperty(UDC.Label.MESSAGE, "No data returned from database");
helper.CreateProperty(UDC.Label.SUCCESS, false);
}
else
{
helper.ParseDataSet(ds);
}
}
catch (Exception ex)
{
Logger.Error("Exception In GetTicketsToMerge " + ex.ToString());
}
return(helper.GetResponse());
}
public JObject ManageTickets(String connection, UserDefinedClasses.Ticket ticketsObj)
{
try
{
Press3.DataAccessLayer.Ticket ticketObj = new Press3.DataAccessLayer.Ticket(connection);
DataSet ds = ticketObj.ManageTickets(ticketsObj);
if (ds == null)
{
helper.CreateProperty(UDC.Label.MESSAGE, "No data returned from database");
helper.CreateProperty(UDC.Label.SUCCESS, false);
}
else
{
helper.ParseDataSet(ds);
}
}
catch (Exception ex)
{
Logger.Error("Exception In GetAgentStatuses " + ex.ToString());
}
return(helper.GetResponse());
}
public JObject ManageTicketCategoryNodes(String connection, int mode, int accountId, string category, int parentId, string colorCode, int agentId)
{
try
{
Press3.DataAccessLayer.Ticket ticketObj = new Press3.DataAccessLayer.Ticket(connection);
DataSet ds = ticketObj.ManageTicketCategoryNodes(mode, accountId, category, parentId, colorCode, agentId);
if (ds == null)
{
helper.CreateProperty(UDC.Label.MESSAGE, "No data returned from database");
helper.CreateProperty(UDC.Label.SUCCESS, false);
}
else
{
helper.ParseDataSet(ds);
}
}
catch (Exception ex)
{
Logger.Error("Exception In GetAgentStatuses " + ex.ToString());
}
return(helper.GetResponse());
}
public JObject GetTicketDetails(String connection, int accountId, int ticketId)
{
try
{
Press3.DataAccessLayer.Ticket ticketObj = new Press3.DataAccessLayer.Ticket(connection);
DataSet ds = ticketObj.GetTicketDetails(accountId, ticketId);
if (ds == null)
{
helper.CreateProperty(UDC.Label.MESSAGE, "No data returned from database");
helper.CreateProperty(UDC.Label.SUCCESS, false);
}
else
{
helper.ParseDataSet(ds);
}
}
catch (Exception ex)
{
Logger.Error("Exception In StarOrUnstarTicket " + ex.ToString());
}
return(helper.GetResponse());
}
public JObject CloseTickets(String connection, int agentId, string ticketIds, string closureText)
{
try
{
Press3.DataAccessLayer.Ticket ticketObj = new Press3.DataAccessLayer.Ticket(connection);
DataSet ds = ticketObj.CloseTickets(agentId, ticketIds, closureText);
if (ds == null)
{
helper.CreateProperty(UDC.Label.MESSAGE, "No data returned from database");
helper.CreateProperty(UDC.Label.SUCCESS, false);
}
else
{
helper.ParseDataSet(ds);
}
}
catch (Exception ex)
{
Logger.Error("Exception In CloseTickets " + ex.ToString());
}
return(helper.GetResponse());
}
