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)); }