Пример #1
0
 public HttpResponseMessage updateSettingGroupPolicy([FromBody] TicketGroupPolicyDto instance)
 {
     if (ticketService.isGroupPolicyExisted(instance))
     {
         return(Request.CreateResponse(HttpStatusCode.PreconditionFailed, new { msg = "This Group Policy was existed" }));
     }
     else
     {
         return(Request.CreateResponse(HttpStatusCode.OK, ticketService.updateGroupPolicy(instance)));
     }
 }
Пример #2
0
        public Boolean isGroupPoliciesExisted(TicketGroupPolicyDto instance)
        {
            Boolean existed   = false;
            var     sqlString = @"SELECT count(*) FROM TICKET.GROUP_POLICY A 
                    WHERE 
                    (@id > 0 OR RTRIM(LTRIM(LOWER(A.GROUP_NAME))) = RTRIM(LTRIM(LOWER(@name))))
                    AND (@id <= 0 OR (A.ID != @id AND RTRIM(LTRIM(LOWER(A.GROUP_NAME))) = RTRIM(LTRIM(LOWER(@name)))))";

            try
            {
                int total = DbContext.Database.SqlQuery <int>(sqlString, new object[] { new SqlParameter("@id", instance.id), new SqlParameter("@name", instance.groupName) }).FirstOrDefault <int>();
                if (total > 0)
                {
                    existed = true;
                }
            }
            catch (Exception e)
            {
                Console.Write("e ", e.InnerException);
            }
            return(existed);
        }
Пример #3
0
        public TicketGroupPolicy addNewGroupPolicy(TicketGroupPolicyDto instance)
        {
            TicketGroupPolicy gp = createGroupPolicyObject(instance);

            try
            {
                groupPolicyRepo.Add(gp);

                DateTime currentDate = DateTime.Now;
                foreach (GroupPolicyAssignTeamListDto dto in instance.assignTeamList)
                {
                    TicketGroupPolicyTeamAssign t = new TicketGroupPolicyTeamAssign();
                    t.GroupPolicyId = gp.Id;
                    t.TeamId        = dto.teamId;
                    t.CreatedDate   = currentDate;
                    t.Status        = "ACTIVE";
                    groupPolicyTeamAssignRepo.Add(t);
                }

                foreach (GroupPolicyAssignTeamListDto dto in instance.assignReportLimitAccessTeamList)
                {
                    TicketGroupPolicyReportAssign t = new TicketGroupPolicyReportAssign();
                    t.GroupPolicyId = gp.Id;
                    t.TeamId        = dto.teamId;
                    t.CreatedDate   = currentDate;
                    t.Status        = "ACTIVE";
                    groupPolicyReportAssignRepo.Add(t);
                }
                return(gp);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.StackTrace);
                return(gp);
            }
        }
Пример #4
0
        private TicketGroupPolicy createGroupPolicyObject(TicketGroupPolicyDto instance)
        {
            TicketGroupPolicy groupPolicy = new TicketGroupPolicy();

            groupPolicy.Description        = instance.description;
            groupPolicy.GroupName          = instance.groupName;
            groupPolicy.Status             = instance.status;
            groupPolicy.LimitAccess        = instance.limitAccess;
            groupPolicy.NewTicketNotify    = instance.newTicketNotify;
            groupPolicy.AssignedNotify     = instance.assignedNotify;
            groupPolicy.ReplyNotify        = instance.replyNotify;
            groupPolicy.ChangeStatusNotify = instance.changeStatusNotify;
            groupPolicy.CreateTicket       = instance.createTicket;
            groupPolicy.EditTicket         = instance.editTicket;
            groupPolicy.ChangeStatus       = instance.changeStatus;
            groupPolicy.PostTicket         = instance.postTicket;
            groupPolicy.CloseTicket        = instance.closeTicket;
            groupPolicy.AssignTicket       = instance.assignTicket;
            groupPolicy.MergeTicket        = instance.mergeTicket;
            groupPolicy.DeleteTicket       = instance.deleteTicket;
            groupPolicy.SubTicket          = instance.subTicket;
            groupPolicy.ReportAccess       = instance.reportAccess;
            return(groupPolicy);
        }
Пример #5
0
 public Boolean isGroupPolicyExisted(TicketGroupPolicyDto instance)
 {
     return(groupPolicyRepo.isGroupPoliciesExisted(instance));
 }
Пример #6
0
        public TicketGroupPolicy updateGroupPolicy(TicketGroupPolicyDto instance)
        {
            TicketGroupPolicy gp = createGroupPolicyObject(instance);

            try
            {
                gp.Id = instance.id;
                groupPolicyRepo.Update(gp);
                DateTime currentDate = DateTime.Now;
                //remove priouse ones
                foreach (TicketGroupPolicyTeamsDto obj in groupPolicyTeamAssignRepo.getListByPartners(0, gp.Id))
                {
                    TicketGroupPolicyTeamAssign gpTa = groupPolicyTeamAssignRepo.GetById(obj.id);
                    gpTa.CreatedDate = currentDate;
                    gpTa.Status      = "DELETE";
                    groupPolicyTeamAssignRepo.Update(gpTa);
                }

                foreach (TicketGroupPolicyTeamsDto obj in groupPolicyReportAssignRepo.getListByPartners(0, gp.Id))
                {
                    TicketGroupPolicyReportAssign gpTa = groupPolicyReportAssignRepo.GetById(obj.id);
                    gpTa.CreatedDate = currentDate;
                    gpTa.Status      = "DELETE";
                    groupPolicyReportAssignRepo.Update(gpTa);
                }

                IEnumerable <GroupPolicyAssignTeamListDto> gpTeamAssignList = instance.assignTeamList;

                foreach (GroupPolicyAssignTeamListDto dto in gpTeamAssignList)
                {
                    TicketGroupPolicyTeamAssign gpTaObj = new TicketGroupPolicyTeamAssign();
                    gpTaObj.CreatedDate   = currentDate;
                    gpTaObj.TeamId        = dto.teamId;
                    gpTaObj.GroupPolicyId = gp.Id;
                    gpTaObj.Status        = "ACTIVE";
                    gpTaObj.ModifiedDate  = currentDate;
                    gpTaObj.Description   = "Team assigned";
                    groupPolicyTeamAssignRepo.Add(gpTaObj);
                }

                IEnumerable <GroupPolicyAssignTeamListDto> gpReportAssignList = instance.assignReportLimitAccessTeamList;

                foreach (GroupPolicyAssignTeamListDto dto in gpReportAssignList)
                {
                    TicketGroupPolicyReportAssign gpTaObj = new TicketGroupPolicyReportAssign();
                    gpTaObj.CreatedDate   = currentDate;
                    gpTaObj.TeamId        = dto.teamId;
                    gpTaObj.GroupPolicyId = gp.Id;
                    gpTaObj.Status        = "ACTIVE";
                    gpTaObj.ModifiedDate  = currentDate;
                    gpTaObj.Description   = "Team assigned";
                    groupPolicyReportAssignRepo.Add(gpTaObj);
                }

                return(gp);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.StackTrace);
                return(gp);
            }
        }