public DataSet GetTicketsHistory(UserDefinedClasses.Ticket ticketsObj)
{
_cmd = new SqlCommand();
_da = new SqlDataAdapter();
_ds = new DataSet();
try
{
_cmd.CommandText = "GetTicketsHistory";
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Connection = Connection;
_cmd.Parameters.Add("@Mode", SqlDbType.Int).Value = ticketsObj.Mode;
_cmd.Parameters.Add("@AccountId", SqlDbType.Int).Value = ticketsObj.AccountId;
_cmd.Parameters.Add("@AgentId", SqlDbType.Int).Value = ticketsObj.AgentId;
_cmd.Parameters.Add("@RoleId", SqlDbType.Int).Value = ticketsObj.RoleId;
_cmd.Parameters.Add("@TicketId", SqlDbType.BigInt).Value = ticketsObj.Id;
_cmd.Parameters.Add("@CustomerId", SqlDbType.Int).Value = ticketsObj.CustomerId;
_cmd.Parameters.Add("@SelectedAgentId", SqlDbType.Int).Value = ticketsObj.SelectedAgentId;
_cmd.Parameters.Add("@StatusIds", SqlDbType.VarChar, 50).Value = ticketsObj.StatusIds;
_cmd.Parameters.Add("@PriorityIds", SqlDbType.VarChar, 50).Value = ticketsObj.PriorityIds;
_cmd.Parameters.Add("@TicketType", SqlDbType.Int).Value = ticketsObj.TicketType;
_cmd.Parameters.Add("@OverDueType", SqlDbType.Int).Value = ticketsObj.OverDueType;
_cmd.Parameters.Add("@DurationType", SqlDbType.Int).Value = ticketsObj.DurationType;
_cmd.Parameters.Add("@FromDate", SqlDbType.VarChar, 30).Value = ticketsObj.FromDate;
_cmd.Parameters.Add("@ToDate", SqlDbType.VarChar, 30).Value = ticketsObj.ToDate;
_cmd.Parameters.Add("@PageIndex", SqlDbType.Int).Value = ticketsObj.PageIndex;
_cmd.Parameters.Add("@IsStarred", SqlDbType.Bit).Value = ticketsObj.IsStarred;
_cmd.Parameters.Add("@PageSize", SqlDbType.Int).Value = ticketsObj.PageSize;
_cmd.Parameters.Add("@Subject", SqlDbType.NVarChar, 100).Value = ticketsObj.Subject;
_cmd.Parameters.Add("@CategoryId", SqlDbType.Int).Value = ticketsObj.CategoryId;
_cmd.Parameters.Add("@Message", SqlDbType.VarChar, 500).Direction = ParameterDirection.Output;
_cmd.Parameters.Add("@Success", SqlDbType.Bit).Direction = ParameterDirection.Output;
//_cmd.Parameters.Add("@TotalTickets", SqlDbType.Int).Direction = ParameterDirection.Output;
//_cmd.Parameters.Add("@OverDueCount", SqlDbType.Int).Direction = ParameterDirection.Output;
//_cmd.Parameters.Add("@TodayDueCount", SqlDbType.Int).Direction = ParameterDirection.Output;
//_cmd.Parameters.Add("@TicketsOpenCount", SqlDbType.Int).Direction = ParameterDirection.Output;
_da.SelectCommand = _cmd;
_da.Fill(_ds);
if (_ds.Tables.Count > 0)
{
_ds.Tables[0].TableName = "TicketDetails";
_ds.Tables[1].TableName = "Tickets";
}
_ds.Tables.Add(_helper.ConvertOutputParametersToDataTable(_cmd.Parameters));
}
catch (Exception ex)
{
Logger.Error(ex.ToString());
throw;
}
finally
{
Connection.Close();
_cmd = null;
}
return(_ds);
}
public DataSet ManageTickets(UserDefinedClasses.Ticket ticketsObj)
{
_cmd = new SqlCommand();
_da = new SqlDataAdapter();
_ds = new DataSet();
try
{
_cmd.CommandText = "TicketManagement";
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Connection = Connection;
_cmd.Parameters.Add("@Mode", SqlDbType.Int).Value = ticketsObj.Mode;
_cmd.Parameters.Add("@AccountId", SqlDbType.Int).Value = ticketsObj.AccountId;
_cmd.Parameters.Add("@AgentId", SqlDbType.Int).Value = ticketsObj.AgentId;
_cmd.Parameters.Add("@PriorityId", SqlDbType.Int).Value = ticketsObj.PriorityId;
_cmd.Parameters.Add("@Description", SqlDbType.NVarChar, -1).Value = ticketsObj.Decscription;
if (ticketsObj.Mode == 1)
{
_cmd.Parameters.Add("@CategoryId", SqlDbType.Int).Value = ticketsObj.CategoryId;
_cmd.Parameters.Add("@CallId", SqlDbType.Int).Value = ticketsObj.CallId;
_cmd.Parameters.Add("@CustomerId", SqlDbType.Int).Value = ticketsObj.CustomerId;
_cmd.Parameters.Add("@Subject", SqlDbType.NVarChar, 100).Value = ticketsObj.Subject;
_cmd.Parameters.Add("@DueDate", SqlDbType.VarChar, 50).Value = ticketsObj.DueDate;
_cmd.Parameters.Add("@IsOffline", SqlDbType.Bit).Value = ticketsObj.IsOffline;
}
else if (ticketsObj.Mode == 2)
{
_cmd.Parameters.Add("@TicketId", SqlDbType.Int).Value = ticketsObj.Id;
_cmd.Parameters.Add("@StatusId", SqlDbType.Int).Value = Convert.ToInt32(ticketsObj.StatusIds);
_cmd.Parameters.Add("@CallId", SqlDbType.Int).Value = ticketsObj.CallId;
}
_cmd.Parameters.Add("@Message", SqlDbType.VarChar, 200).Direction = ParameterDirection.Output;
_cmd.Parameters.Add("@Success", SqlDbType.Bit).Direction = ParameterDirection.Output;
_da.SelectCommand = _cmd;
_da.Fill(_ds);
if (_ds.Tables.Count > 0)
{
_ds.Tables[0].TableName = "TicketDetails";
}
_ds.Tables.Add(_helper.ConvertOutputParametersToDataTable(_cmd.Parameters));
}
catch (Exception ex)
{
Logger.Error(ex.ToString());
throw;
}
finally
{
Connection.Close();
_cmd = null;
}
return(_ds);
}
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 GetTicketsHistory(String connection, UserDefinedClasses.Ticket ticket)
{
try
{
Press3.DataAccessLayer.Ticket ticketObj = new Press3.DataAccessLayer.Ticket(connection);
DataSet ds = ticketObj.GetTicketsHistory(ticket);
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 GetTicketsHistory " + ex.ToString());
}
return(helper.GetResponse());
}
private JObject ManageTickets(HttpContext context)
{
JObject responseJObj = new JObject();
try
{
UserDefinedClasses.Ticket ticketObj = new UserDefinedClasses.Ticket();
ticketObj.Mode = Convert.ToInt32(context.Request["Mode"]);
ticketObj.AccountId = accountId;
ticketObj.AgentId = agentId;
ticketObj.PriorityId = Convert.ToInt32(context.Request["PriorityId"]);
ticketObj.Decscription = context.Request["Description"].ToString();
if (Convert.ToInt32(context.Request["Mode"]) == 1)
{
ticketObj.CategoryId = Convert.ToInt32(context.Request["CategoryId"]);
ticketObj.CustomerId = Convert.ToInt32(context.Request["CustomerId"]);
ticketObj.Subject = context.Request["Topic"].ToString();
ticketObj.DueDate = context.Request["DueDate"].ToString();
ticketObj.CallId = Convert.ToInt32(context.Request["CallId"]);
ticketObj.IsOffline = (context.Request["IsOffline"] != null && context.Request["IsOffline"] != "") ? Convert.ToBoolean(Convert.ToInt32(context.Request["IsOffline"])) : false;
}
else if (Convert.ToInt32(context.Request["Mode"]) == 2)
{
ticketObj.Id = Convert.ToInt32(context.Request["TicketId"]);
ticketObj.StatusIds = context.Request["StatusId"].ToString();
ticketObj.CallId = (context.Request["CallId"] != null && context.Request["CallId"] != "") ? Convert.ToInt32(context.Request["CallId"]) : 0;
}
Press3.BusinessRulesLayer.Ticket ticketsObj = new Press3.BusinessRulesLayer.Ticket();
responseJObj = ticketsObj.ManageTickets(MyConfig.MyConnectionString, ticketObj);
}
catch (Exception ex)
{
Logger.Error(ex.ToString());
}
return(responseJObj);
}
