public DataTable FillResumes(ITickets itickets)
{
DataTable dtblTickets = new DataTable();
Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS");
string sqlCommand = "proResumesSelect";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ID_Tickets", DbType.String, itickets.MasterID);
db.AddInParameter(dbCommand, "@TickNo", DbType.String, itickets.TickNo);
db.AddInParameter(dbCommand, "@TickSubject", DbType.String, itickets.TickSubject);
db.AddInParameter(dbCommand, "@PageIndex", DbType.Int32, itickets.PageIndex);
db.AddInParameter(dbCommand, "@PageSize", DbType.Int32, itickets.PageSize);
db.AddInParameter(dbCommand, "@Status", DbType.Int16, itickets.TickStatus);
db.AddInParameter(dbCommand, "@ClientName", DbType.String, itickets.ClientName);
db.AddInParameter(dbCommand, "@UserCode", DbType.Int64, itickets.UserCode);
db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, itickets.FK_Company);
try
{
dtblTickets = db.ExecuteDataSet(dbCommand).Tables[0];
return(dtblTickets);
}
catch (SqlException e)
{
throw e;
}
}
public Int32 UpdateTicketAssign(ITickets itickets)
{
Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS");
string sqlCommand = "proAgentTicketAssign";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@UserAction", DbType.Byte, itickets.UserAction);
db.AddInParameter(dbCommand, "@FK_Tickets", DbType.Int64, itickets.MasterID);
db.AddInParameter(dbCommand, "@AgentFrom", DbType.Int64, itickets.AgentCode);
db.AddInParameter(dbCommand, "@AgentTo", DbType.Int64, itickets.AgentTo);
db.AddInParameter(dbCommand, "@TransStatus", DbType.Int16, itickets.TickStatus);
db.AddInParameter(dbCommand, "@Description", DbType.String, itickets.Description);
db.AddInParameter(dbCommand, "@AgentNotes", DbType.String, itickets.AgentNotes == null ? "" : itickets.AgentNotes);
db.AddInParameter(dbCommand, "@AgentCode", DbType.Int64, itickets.AgentCode);
db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, itickets.FK_Company);
db.AddInParameter(dbCommand, "@XmlTickets", DbType.String, itickets.XmlTickets);
try
{
return(Convert.ToInt32(db.ExecuteScalar(dbCommand)));
}
catch (SqlException e)
{
return(0);
}
}
public TicketDetailsAgentController(
IDisplayTickets displayTickets,
IPriority priority,
IStatus status,
ITicketsReply ticketsReply,
IAttachments attachments,
ITicketHistory ticketHistory,
ITickets tickets,
IProfile profile,
ICategory category,
ITicketEscalationHistory iticketEscalationHistory,
IUserMaster userMaster
)
{
_displayTickets = displayTickets;
_priority = priority;
_status = status;
_ticketsReply = ticketsReply;
_attachments = attachments;
_ticketHistory = ticketHistory;
_tickets = tickets;
_profile = profile;
_category = category;
_iticketEscalationHistory = iticketEscalationHistory;
_userMaster = userMaster;
}
public UserDashboardController(IMenu menu, ITickets tickets, IDashboardTicketCount dashboardTicketCount, IAllTicketGrid allTicketGrid, IMenuCategory menuCategory)
{
_iMenu = menu;
_iTickets = tickets;
_dashboardTicketCount = dashboardTicketCount;
_allTicketGrid = allTicketGrid;
_menuCategory = menuCategory;
}
public TicketDetailsController(IDisplayTickets displayTickets, IPriority priority, IStatus status, ITicketsReply ticketsReply, IAttachments attachments, ITickets tickets, ITicketHistory ticketHistory)
{
_displayTickets = displayTickets;
_priority = priority;
_status = status;
_ticketsReply = ticketsReply;
_attachments = attachments;
_tickets = tickets;
_ticketHistory = ticketHistory;
}
public TicketController(ICategory category, IPriority priority, ITickets tickets, IAttachments attachments,
ITicketHistory ticketHistory, IProfile profile)
{
_category = category;
_priority = priority;
_tickets = tickets;
_attachments = attachments;
_ticketHistory = ticketHistory;
_profile = profile;
}
public TicketAdminController(ICategory category, IPriority priority, ITickets tickets, IAttachments attachments, ITicketHistory ticketHistory, IProfile profile, IUserMaster userMaster)
{
_category = category;
_priority = priority;
_tickets = tickets;
_attachments = attachments;
_ticketHistory = ticketHistory;
_profile = profile;
_userMaster = userMaster;
}
public HODDashboardController(IMenu menu,
ISubMenu subMenu,
ITickets tickets,
IPriority priority,
IStatus status,
IDashboardTicketCount dashboardTicketCount,
IChart chart, IUserMaster userMaster, IAllTicketGrid allTicketGrid, ITicketHistory ticketHistory, IMenuCategory menuCategory)
{
_iMenu = menu;
_iTickets = tickets;
_priority = priority;
_status = status;
_dashboardTicketCount = dashboardTicketCount;
_chart = chart;
_userMaster = userMaster;
_allTicketGrid = allTicketGrid;
_ticketHistory = ticketHistory;
_menuCategory = menuCategory;
}
public DataTable SelectAgentTicketDetails(ITickets itickets)
{
DataTable dtblTickets = new DataTable();
Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS");
string sqlCommand = "proAgentTicketDetailsSelect";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ID_Tickets", DbType.String, itickets.MasterID);
db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, itickets.FK_Company);
try
{
dtblTickets = db.ExecuteDataSet(dbCommand).Tables[0];
return(dtblTickets);
}
catch (SqlException e)
{
throw e;
}
}
public int DeleteTickets(ITickets itickets)
{
Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS");
string sqlCommand = "proResumesDelete";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ID_Resumes", DbType.Int64, itickets.MasterID);
db.AddInParameter(dbCommand, "@CancelledUser", DbType.Int64, itickets.UserCode);
db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, itickets.FK_Company);
try
{
return(Convert.ToInt32(db.ExecuteScalar(dbCommand)));
}
catch (SqlException e)
{
//UpdateErrorLog(iTopic, e);
throw e;
}
}
public AgentDashboardController(IMenu menu,
ITickets tickets,
IPriority priority,
IStatus status,
IDashboardTicketCount dashboardTicketCount,
IUserMaster userMaster,
ITicketHistory ticketHistory,
IChart chart, IAllTicketGrid allTicketGrid, ITicketNotification ticketNotification, IMenuCategory menuCategory, IAgentCheckInStatus agentCheckInStatus)
{
_iMenu = menu;
_iTickets = tickets;
_priority = priority;
_status = status;
_dashboardTicketCount = dashboardTicketCount;
_userMaster = userMaster;
_ticketHistory = ticketHistory;
_chart = chart;
_allTicketGrid = allTicketGrid;
_ticketNotification = ticketNotification;
_menuCategory = menuCategory;
_agentCheckInStatus = agentCheckInStatus;
}
public Int32 UpdateTickets(ITickets itickets)
{
Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS");
string sqlCommand = "proTicketsUpdate";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@UserAction", DbType.Byte, itickets.UserAction);
db.AddInParameter(dbCommand, "@ID_Tickets", DbType.String, itickets.MasterID);
db.AddInParameter(dbCommand, "@TickNo", DbType.String, itickets.TickNo);
db.AddInParameter(dbCommand, "@TickDate", DbType.DateTime, itickets.TickDate);
db.AddInParameter(dbCommand, "@TickPriority", DbType.Int16, itickets.TickPriority);
db.AddInParameter(dbCommand, "@TickStatus", DbType.Int16, itickets.TickStatus);
db.AddInParameter(dbCommand, "@FK_Product", DbType.Int64, itickets.FK_Product);
db.AddInParameter(dbCommand, "@FK_Topic", DbType.Int64, itickets.FK_Topic);
db.AddInParameter(dbCommand, "@FK_Department", DbType.Int64, itickets.FK_Department);
db.AddInParameter(dbCommand, "@FK_Client", DbType.Int64, itickets.FK_Client);
db.AddInParameter(dbCommand, "@TickSubject", DbType.String, itickets.TickSubject);
db.AddInParameter(dbCommand, "@Description", DbType.String, itickets.Description);
db.AddInParameter(dbCommand, "@XmlAttachment", DbType.String, itickets.XmlAttachment);
db.AddInParameter(dbCommand, "@AgentCode", DbType.Int64, itickets.AgentCode);
db.AddInParameter(dbCommand, "@UserCode", DbType.Int64, itickets.UserCode);
db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, itickets.FK_Company);
db.AddInParameter(dbCommand, "@UserName", DbType.String, itickets.UserName);
db.AddInParameter(dbCommand, "@UserMobile", DbType.String, itickets.UserMob);
db.AddInParameter(dbCommand, "@Useremail", DbType.String, itickets.UserEmail);
db.AddInParameter(dbCommand, "@FK_PositionRequest", DbType.Int64, itickets.FK_PositionRequest);
try
{
return(Convert.ToInt32(db.ExecuteScalar(dbCommand)));
}
catch (SqlException e)
{
return(0);
}
}
public TicketsController(ITickets ticketsRepo)
{
_ticketsRepo = ticketsRepo;
}
