public TicketTeamDto addNewTeamAgents(TicketTeamDto instance)
{
try
{
TicketTeam team = new TicketTeam();
team.Description = instance.description;
team.DirectoryListing = instance.directoryListing;
team.Status = instance.status;
team.TeamName = instance.teamName;
teamRepo.Add(team);
foreach (AgentAssignListDto agent in instance.registeredAgents)
{
TicketTeamAgentAssign t = new TicketTeamAgentAssign();
t.ImmediateAssign = agent.immediateAssign;
t.Status = "ACTIVE";
t.TeamId = team.Id;
t.AgentId = agent.id;
teamAgentAssignRepo.Add(t);
}
}
catch (Exception e)
{
Console.WriteLine(e.StackTrace);
}
return(instance);
}
public HttpResponseMessage updateSettingTeam([FromBody] TicketTeamDto instance)
{
if (ticketService.isTeamExisted(instance))
{
return(Request.CreateResponse(HttpStatusCode.PreconditionFailed, new { msg = "This Team was existed" }));
}
else
{
return(Request.CreateResponse(HttpStatusCode.OK, ticketService.updateTeamAgents(instance)));
}
}
public TicketTeamDto updateTeamAgents(TicketTeamDto instance)
{
TicketTeam team = teamRepo.GetById(instance.id);
team.Description = instance.description;
team.DirectoryListing = instance.directoryListing;
team.Status = instance.status;
team.TeamName = instance.teamName;
teamRepo.Update(team);
IEnumerable <TicketTeamAgentAssign> removeList = teamAgentAssignRepo.getListByPartners(team.Id, 0);
//remove previous ones
try
{
foreach (TicketTeamAgentAssign a in removeList)
{
a.Status = "DELETE";
teamAgentAssignRepo.Update(a);
}
}
catch (Exception e)
{
Console.WriteLine(e.StackTrace);
}
if (instance.registeredAgents != null)
{
foreach (AgentAssignListDto agent in instance.registeredAgents)
{
TicketTeamAgentAssign t = new TicketTeamAgentAssign();
t.ImmediateAssign = agent.immediateAssign;
t.Status = "ACTIVE";
t.TeamId = team.Id;
t.AgentId = agent.id;
teamAgentAssignRepo.Add(t);
}
}
return(instance);
}
public Boolean isTeamExisted(TicketTeamDto instance)
{
Boolean existed = false;
var sqlString = @"SELECT count(*) FROM TICKET.TEAM A
WHERE
(@teamId > 0 OR RTRIM(LTRIM(LOWER(A.TEAM_NAME))) = RTRIM(LTRIM(LOWER(@teamName))))
AND (@teamId <= 0 OR (A.ID != @teamId AND RTRIM(LTRIM(LOWER(A.TEAM_NAME))) = RTRIM(LTRIM(LOWER(@teamName)))))";
try
{
int total = DbContext.Database.SqlQuery <int>(sqlString, new object[] { new SqlParameter("@teamId", instance.id), new SqlParameter("@teamName", instance.teamName) }).FirstOrDefault <int>();
if (total > 0)
{
existed = true;
}
}
catch (Exception e)
{
Console.Write("e ", e.InnerException);
}
return(existed);
}
public Boolean isTeamExisted(TicketTeamDto instance)
{
return(teamRepo.isTeamExisted(instance));
}
