public string GetNec([FromBody] ICollection <Filter> searchParams)
        {
            string jsonString = string.Empty;

            using (var db = new EverestPortalContext())
            {
                if (searchParams == null || searchParams.Count == 0)
                {
                    var query = db.ReportParameters.Select(nec1 => new { NEC_Code = nec1.NEC1_Code, NEC_Desc = nec1.NEC1_Desc })
                                .Union(db.ReportParameters.Select(nec2 => new { NEC_Code = nec2.NEC2_Code, NEC_Desc = nec2.NEC2_desc }))
                                .Union(db.ReportParameters.Select(nec3 => new { NEC_Code = nec3.NEC3_Code, NEC_Desc = nec3.NEC3_Desc }))
                                .Where(nec => !string.IsNullOrEmpty(nec.NEC_Code) && !string.IsNullOrEmpty(nec.NEC_Desc))
                                .Distinct().OrderBy(x => x.NEC_Code).Take(numberOfItems).ToList();

                    jsonString = JsonConvert.SerializeObject(query, Formatting.Indented,
                                                             new JsonSerializerSettings
                    {
                        PreserveReferencesHandling = PreserveReferencesHandling.Objects
                    });
                }
                else
                {
                    var value = searchParams.ToArray()[0].Value;
                    var query = db.ReportParameters.Select(nec1 => new { NEC_Code = nec1.NEC1_Code, NEC_Desc = nec1.NEC1_Desc })
                                .Union(db.ReportParameters.Select(nec2 => new { NEC_Code = nec2.NEC2_Code, NEC_Desc = nec2.NEC2_desc }))
                                .Union(db.ReportParameters.Select(nec3 => new { NEC_Code = nec3.NEC3_Code, NEC_Desc = nec3.NEC3_Desc }))
                                .Where(nec => (nec.NEC_Code.Contains(value) || nec.NEC_Desc.Contains(value)) &&
                                       !string.IsNullOrEmpty(nec.NEC_Code) && !string.IsNullOrEmpty(nec.NEC_Desc))
                                .Distinct().OrderBy(x => x.NEC_Code).Take(numberOfItems).ToList();

                    jsonString = JsonConvert.SerializeObject(query, Formatting.Indented,
                                                             new JsonSerializerSettings
                    {
                        PreserveReferencesHandling = PreserveReferencesHandling.Objects
                    });
                }
            }
            return(jsonString);
        }
        public HttpResponseMessage GetECPClients()
        {
            HttpResponseMessage message;

            using (EverestPortalContext context = new EverestPortalContext())
            {
                var clients = (from client in context.Clients
                               select new
                {
                    clientId = client.Id,
                    clientName = client.Name,
                }).ToList();

                var result = new
                {
                    data = clients
                };

                message = Request.CreateResponse(HttpStatusCode.OK, result);
                return(message);
            }
        }
Пример #3
0
        public string GetCADPagesString()
        {
            HttpResponseMessage message;
            string jsonString = string.Empty;

            using (EverestPortalContext context = new EverestPortalContext())
            {
                //var lstCADPages = context.CADPages.OrderBy(cp => cp.cadPageCreatedOn).Take(2).ToList()
                //    .Select(cpItem => new {
                //        cadPageId = cpItem.cadPageId,
                //        cadPageTitle = cpItem.cadPageTitle,
                //        cadPageDescription = cpItem.cadPageDescription });

                var lstCADPages = (from cpItem in context.CADPages
                                   select new CADPageViewModel
                {
                    CADPageId = cpItem.cadPageId,
                    CADPageTitle = cpItem.cadPageTitle,
                    CADPageDescription = cpItem.cadPageDescription,
                    CadPageModifiedOn = cpItem.cadPageModifiedOn
                }).OrderByDescending(x => x.CadPageModifiedOn).Take(2).ToList <CADPageViewModel>();
                if (lstCADPages == null)
                {
                    // message = new HttpResponseMessage(HttpStatusCode.InternalServerError);
                }
                else if (lstCADPages.Count() == 0)
                {
                    //message = new HttpResponseMessage(HttpStatusCode.NotFound);
                }
                else
                {
                    //message = Request.CreateResponse(HttpStatusCode.OK, lstCADPages);
                    jsonString = Newtonsoft.Json.JsonConvert.SerializeObject(lstCADPages);
                }

                //return message;
                return(jsonString);
            }
        }
        public HttpResponseMessage GetToReallocateClients([FromBody] RequestAllocation request)
        {
            var users = request.ReallocatedUsers;

            using (EverestPortalContext context = new EverestPortalContext())
            {
                var clientUsers = (from client in context.Clients
                                   join
                                   clUser in context.userClient on client.Id equals clUser.ClientID
                                   into gCUsers

                                   from clUser in gCUsers.DefaultIfEmpty()
                                   where clUser.user.userType.UserTypeName != "External users"

                                   select new
                {
                    clientId = client.Id,
                    clientName = client.Name,
                    userID = clUser.UserID == null ? 0 : clUser.UserID
                }).ToList();

                var toReallocationClient = clientUsers.GroupBy(x => x.clientId)
                                           .Where(g => !g.Any(gi => users.Contains(gi.userID)))
                                           .Select(x => new {
                    clientId   = x.Key,
                    clientName = x.First().clientName
                }).OrderBy(x => x.clientName);



                var response = new
                {
                    data = toReallocationClient
                };

                return(Request.CreateResponse(HttpStatusCode.OK, response));
            }
        }
        public HttpResponseMessage GetReportFiltersByModule(int ModuleId, int UserID)
        {
            HttpResponseMessage message;

            using (var db = new EverestPortalContext())
            {
                //var ReportFilterByModule = db.ReportFilters.Where(m => m.ModuleID == ModuleId).OrderByDescending(f=>f.FilterType).ToList();
                var ReportFilterByModule = db.ReportFilters.Where(m => m.ModuleID == ModuleId && (m.CreatedBy == UserID || m.FilterType == "Default")).OrderByDescending(f => f.FilterType).ToList();

                var  RoleID         = GetRoleforUser();
                var  clientID       = GetClientforUser();
                bool IsExternalUser = RoleID.Contains("1") || RoleID.Contains("2") || RoleID.Contains("8");
                int  territoryCount = 0;
                int  indx           = -1;
                if (IsExternalUser)
                {
                    foreach (string c in clientID)
                    {
                        territoryCount += db.Territories.Where(t => t.IsBrickBased == false && t.Client_Id.ToString() == c).ToList().Count;
                    }
                    if (territoryCount == 0)
                    {
                        indx = ReportFilterByModule.FindIndex(f => f.FilterName.Equals("Default Filter – Outlet") && f.ModuleID == 3);
                        if (indx > 0)
                        {
                            ReportFilterByModule.Remove(ReportFilterByModule[indx]);
                        }
                    }
                }

                var result = new
                {
                    data = ReportFilterByModule
                };
                message = Request.CreateResponse(HttpStatusCode.OK, result);
                return(message);
            }
        }
Пример #6
0
        public string UserLoginCheck(string userName, string pwd)
        {
            DataTable dataTable = new DataTable();

            dataTable.Columns.Add(new DataColumn("UserID", typeof(Int32)));
            dataTable.Columns.Add(new DataColumn("RoleID", typeof(Int32)));
            dataTable.Columns.Add(new DataColumn("RoleName", typeof(String)));
            dataTable.Columns.Add(new DataColumn("EmailId", typeof(String)));
            dataTable.Columns.Add(new DataColumn("username", typeof(String)));

            //Get userid from identity
            var identity = (ClaimsIdentity)User.Identity;
            var id       = identity.Claims.FirstOrDefault(c => c.Type == "userid").Value.ToString();
            var userid   = Convert.ToInt32(id);

            if (userid > 0)
            {
                using (var context = new EverestPortalContext())
                {
                    var userRole = context.userRole.FirstOrDefault(r => r.UserID == userid);
                    if (userRole != null && userRole.role != null && userRole.user != null)
                    {
                        DataRow dr = dataTable.NewRow();
                        dr["UserID"]   = userRole.UserID;
                        dr["RoleID"]   = userRole.role.RoleID;
                        dr["RoleName"] = userRole.role.RoleName;
                        dr["EmailId"]  = userRole.user.Email;
                        dr["username"] = userRole.user.FirstName + "." + userRole.user.LastName;
                        dataTable.Rows.Add(dr);
                    }
                }
            }

            string JSONString = string.Empty;

            JSONString = JsonConvert.SerializeObject(dataTable);
            return(JSONString);
        }
        public bool EditCustomFilter([FromBody] ReportFilter Filter)
        {
            bool blnEdit = false;

            if (Filter != null)
            {
                using (var db = new EverestPortalContext())
                {
                    ReportFilter ReportFilterUpdate = db.ReportFilters.Where(m => m.FilterID == Filter.FilterID).SingleOrDefault();
                    if (ReportFilterUpdate != null)
                    {
                        //ReportFilterUpdate.FilterName = Filter.FilterName;
                        //ReportFilterUpdate.FilterDescription = Filter.FilterDescription;
                        ReportFilterUpdate.SelectedFields  = Filter.SelectedFields;
                        ReportFilterUpdate.UpdatedBy       = Filter.UpdatedBy;
                        db.Entry(ReportFilterUpdate).State = EntityState.Modified;
                        db.SaveChanges();
                        blnEdit = true;
                    }
                }
            }
            return(blnEdit);
        }
Пример #8
0
        public async Task <FilterResult <Manufacturer> > GetManufacturerByMFRsId(int clientID, int currentPage, int pageSize)
        {
            List <string> mfrs = new List <string>();

            using (EverestPortalContext context = new EverestPortalContext())
            {
                var clientMfrs = context.ClientMFR.Where(x => x.ClientId == clientID).Select(x => x.MFRId).ToList();
                mfrs = clientMfrs.Select(x => Convert.ToString(x)).ToList();
            }

            ICollection <Filter> searchFilter = new List <Filter>();

            foreach (var item in mfrs)
            {
                searchFilter.Add(new Filter {
                    Condition = "Add", Criteria = "OrgCode", Value = item
                });
            }

            var result = dimProductExpanded.GetManufacturer(searchFilter, currentPage, pageSize);

            return(result);
        }
Пример #9
0
        public void GetUserInfo(string UserName, ref string FirstName, ref string LastName, ref string Email, ref string Pwd)
        {
            using (EverestPortalContext context = new EverestPortalContext())
            {
                var currrentUser = (from u in context.Users
                                    where u.UserName == UserName && u.IsActive == true
                                    select new
                {
                    FirstName = u.FirstName,
                    LastName = u.LastName == null ? "" : u.LastName,
                    Email = u.Email,
                    Pwd = u.Password
                }).ToList();

                if (currrentUser.Count() > 0)
                {
                    Email     = currrentUser[0].Email;
                    FirstName = currrentUser[0].FirstName;
                    LastName  = currrentUser[0].LastName;
                    Pwd       = currrentUser[0].Pwd;
                }
            }
        }
Пример #10
0
        public HttpResponseMessage GetIRPClients()
        {
            HttpResponseMessage message;

            using (EverestPortalContext context = new EverestPortalContext())
            {
                var clients = (from irpclient in context.IRPClients
                               where irpclient.VersionTo == 32767
                               select new
                {
                    clientId = irpclient.ClientID,
                    clientName = irpclient.ClientName,
                    clientNo = irpclient.ClientNo
                }).ToList();

                var result = new
                {
                    data = clients
                };

                message = Request.CreateResponse(HttpStatusCode.OK, result);
                return(message);
            }
        }
        public HttpResponseMessage AddPopularLink([FromBody] PopularLink postedData)
        {
            HttpResponseMessage response = null;

            try
            {
                PopularLink newPopLink = new PopularLink();
                newPopLink.popularLinkTitle       = postedData.popularLinkTitle;
                newPopLink.popularLinkDescription = postedData.popularLinkDescription;


                using (EverestPortalContext context = new EverestPortalContext())
                {
                    context.PopularLinks.Add(newPopLink);
                    context.SaveChanges();
                }

                response = Request.CreateResponse <PopularLink>(HttpStatusCode.Created, newPopLink);
            }
            catch (Exception ex)
            {
            }
            return(response);
        }
Пример #12
0
        public HttpResponseMessage updateServices([FromBody] requestMasterData request)
        {
            var msg       = "successfully saved";
            var isSuccess = false;
            HttpResponseMessage message;

            using (EverestPortalContext context = new EverestPortalContext())
            {
                if (Convert.ToString(request.Action).Equals("delete", StringComparison.InvariantCultureIgnoreCase))
                {
                    var deleteEntity = context.Services.FirstOrDefault(c => c.ServiceId == request.ServiceId);
                    context.Services.Remove(deleteEntity);
                    context.SaveChanges();
                    msg = "Successfully removed";
                    var deleteResponse = new
                    {
                        msg,
                        isSuccess = true
                    };

                    message = Request.CreateResponse(HttpStatusCode.OK, deleteResponse);
                    return(message);
                }


                if (request.ServiceId != null && request.ServiceId != 0)
                {
                    if (context.Services.Any(s => s.Name.Equals(request.ServiceName, StringComparison.InvariantCultureIgnoreCase) &&
                                             s.ServiceId != request.ServiceId))
                    {
                        msg       = "Name already exists";
                        isSuccess = false;
                    }
                    else
                    {
                        var updateEntity = context.Services.FirstOrDefault(c => c.ServiceId == request.ServiceId);
                        updateEntity.Name = request.ServiceName;
                        isSuccess         = true;
                    }
                }
                else
                {
                    if (context.Services.Any(s => s.Name.Equals(request.ServiceName, StringComparison.InvariantCultureIgnoreCase)))
                    {
                        msg       = "Name already exists";
                        isSuccess = false;
                    }
                    else
                    {
                        var newEntity = new Service()
                        {
                            Name = request.ServiceName
                        };
                        context.Services.Add(newEntity);
                        isSuccess = true;
                    }
                };

                context.SaveChanges();
                var response = new
                {
                    msg,
                    isSuccess
                };

                message = Request.CreateResponse(HttpStatusCode.OK, response);
                return(message);
            }
        }
        public HttpResponseMessage CreateDeliverable([FromBody] DeliverableModel request)
        {
            try
            {
                HttpResponseMessage responseMessage;
                var message   = "deliverable successfully created for the selected subscription";
                var isSuccess = false;

                var validationResult = validateRequest(request);
                if (!validationResult.isSuccess)
                {
                    responseMessage = Request.CreateResponse(HttpStatusCode.OK, new { message = validationResult.message, validationResult.isSuccess });
                    return(responseMessage);
                }
                var reportNo = Convert.ToInt32(request.ReportNo);

                using (EverestPortalContext context = new EverestPortalContext())
                {
                    if (!IsDeliverableExists(request))
                    {
                        //adding the new deliverables to the selected clients
                        var deliverable = new Deliverables()
                        {
                            SubscriptionId = request.SubscriptionId,
                            ReportWriterId = request.ReportWriterId,
                            StartDate      = new DateTime(request.StartDate.Year, request.StartDate.Month, 1),                                       //change into first day of the month
                            EndDate        = new DateTime(request.EndDate.Year, request.EndDate.Month, DateTime.DaysInMonth(request.EndDate.Year,
                                                                                                                            request.EndDate.Month)), //change into last day of the month
                            FrequencyTypeId = request.FrequencyTypeId,
                            FrequencyId     = request.FrequencyId,
                            RestrictionId   = request.RestrictionId,
                            PeriodId        = request.PeriodId,
                            DeliveryTypeId  = request.DeliveryTypeId,
                            LastModified    = DateTime.Now,
                            ModifiedBy      = 1,
                        };
                        deliverable = context.deliverables.Add(deliverable);
                        context.SaveChanges();
                        isSuccess = true;
                        //add reportno.
                        //context.DeliveryReports.Add(new DeliveryReport() { DeliverableId = 218,
                        //    ReportNo = reportNo });
                        //context.SaveChanges();

                        AddReportNoDeliverable(new DeliveryReport()
                        {
                            DeliverableId = deliverable.DeliverableId, ReportNo = reportNo
                        });
                    }
                    else
                    {
                        message = "Already same deliverable exists for the selected subscription";
                    }
                }

                var response = new
                {
                    msg = message,
                    isSuccess
                };

                responseMessage = Request.CreateResponse(HttpStatusCode.OK, response);
                return(responseMessage);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #14
0
        public string Getclients()
        {
            Role userRole = GetRoleforUser();

            if (userRole.IsExternal)
            {
                List <string> ClientIDList = new List <string>();
                var           identity     = (ClaimsIdentity)User.Identity;
                //force to use login id, can not pass other value for security reasons.
                var tid = identity.Claims.FirstOrDefault(c => c.Type == "userid").Value.ToString();
                int uid = Convert.ToInt32(tid);

                using (var db = new EverestPortalContext())
                {
                    var Clients = (from u in db.Users
                                   join uClient in db.userClient
                                   on u.UserID equals uClient.UserID
                                   join client in db.Clients on uClient.ClientID equals client.Id
                                   where uClient.UserID == uid
                                   select new
                    {
                        clientID = client.Id,
                        Name = client.Name,
                    }).Distinct().ToList();


                    var result = new
                    {
                        data = Clients.OrderBy(o => o.Name)
                    };

                    var json = JsonConvert.SerializeObject(result, Formatting.Indented,
                                                           new JsonSerializerSettings
                    {
                        ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                    });


                    return(json);
                }
            }
            else
            {
                using (EverestPortalContext context = new EverestPortalContext())
                {
                    var ClientList = (from client in context.Clients
                                      join userClient in context.userClient on client.Id equals userClient.ClientID

                                      select new
                    {
                        clientID = client.Id,
                        Name = client.Name,
                    }).Distinct().ToList();


                    var result = new
                    {
                        data = ClientList.OrderBy(o => o.Name)
                    };

                    var json = JsonConvert.SerializeObject(result, Formatting.Indented,
                                                           new JsonSerializerSettings
                    {
                        ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                    });


                    return(json);
                }
            }
        }
Пример #15
0
        public HttpResponseMessage ChangePasswordByResetToken([FromBody] UserDetail userdeatil)
        {
            HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.ExpectationFailed);

            try
            {
                using (EverestPortalContext context = new EverestPortalContext())
                {
                    var result = context.ResetTokens.FirstOrDefault(x => x.Token == userdeatil.Token);

                    if (result != null && result.user != null)
                    {
                        //if (result.ExpiryDate >= DateTime.Now && result.user.IsPasswordVerified)
                        if (result.ExpiryDate >= DateTime.Now)
                        {
                            AuthController authController = new AuthController();
                            var            passwordHashed = authController.GenerateHashedPassword(userdeatil.Password);

                            var passwordHistoryExist = context.PasswordHistories.Where(x => x.UserID.Equals(result.user.UserID))
                                                       .OrderByDescending(x => x.CreatedDate).Take(12).FirstOrDefault(x => x.Password == passwordHashed);
                            if (passwordHistoryExist != null || result.user.Password == passwordHashed)
                            {
                                response = Request.CreateResponse(HttpStatusCode.OK, new { isSuccess = false, message = " You cannot reuse one of your last 13 passwords" });
                            }
                            else
                            {
                                context.PasswordHistories.Add(
                                    new Models.Security.PasswordHistory
                                {
                                    UserID      = result.user.UserID,
                                    Password    = passwordHashed,
                                    CreatedDate = DateTime.Now
                                });
                                result.user.Password = passwordHashed;
                                result.user.FailedPasswordAttempt = 0;
                                result.user.IsPasswordVerified    = true;
                                result.user.PasswordCreatedDate   = DateTime.Now;
                                result.ExpiryDate = DateTime.Now;
                                context.SaveChanges();
                                response = Request.CreateResponse(HttpStatusCode.OK, new { isSuccess = true, message = "" });
                            }
                        }
                        else if (result.ExpiryDate < DateTime.Now)
                        {
                            response = Request.CreateResponse(HttpStatusCode.OK, new { isSuccess = false, message = "Your password reset link has been expired." });
                        }
                        else
                        {
                            response = Request.CreateResponse(HttpStatusCode.OK, new { isSuccess = false, message = "Your account has not yet been verified. Please contact support." });
                        }
                    }
                    else
                    {
                        response = Request.CreateResponse(HttpStatusCode.OK, new { isSuccess = false, message = "User inactive or email address invalid." });
                    }
                }
            }
            catch (Exception ex)
            {
            }
            return(response);
        }
Пример #16
0
        private void SaveTdwExportHistory(List <int> selectedClients, bool isSelectedAll)
        {
            //var Tdw
            var identity = (ClaimsIdentity)User.Identity;
            //force to use login id, can not pass other value for security reasons.
            var actionUserId = identity.Claims.FirstOrDefault(c => c.Type == "userid").Value.ToString();

            using (EverestPortalContext context = new EverestPortalContext())
            {
                if (isSelectedAll)
                {
                    var result = context.Tdw_export_history.OrderByDescending(x => x.versionId)
                                 .FirstOrDefault(t => t.ClientId == 0);
                    var version = 1;
                    if (result != null)
                    {
                        version = result.versionId + 1;
                    }
                    var exportHistory = new Tdw_export_history()
                    {
                        versionId   = version,
                        ClientId    = 0,
                        Deliverable = "All",
                        Market      = "All",
                        Territory   = "All",
                        //ClientName = "All",
                        SubmittedBy   = int.Parse(actionUserId),
                        SubmittedDate = DateTime.Now
                    };

                    context.Tdw_export_history.Add(exportHistory);
                    context.SaveChanges();
                }
                else
                {
                    foreach (var clientId in selectedClients)
                    {
                        var result = context.Tdw_export_history.OrderByDescending(x => x.versionId)
                                     .FirstOrDefault(t => t.ClientId == clientId);
                        var version = 1;
                        if (result != null)
                        {
                            version = result.versionId + 1;
                        }
                        var exportHistory = new Tdw_export_history()
                        {
                            versionId   = version,
                            ClientId    = clientId,
                            Deliverable = "All",
                            Market      = "All",
                            Territory   = "All",
                            //ClientName = "All",
                            SubmittedBy   = int.Parse(actionUserId),
                            SubmittedDate = DateTime.Now
                        };

                        context.Tdw_export_history.Add(exportHistory);
                        context.SaveChanges();
                    }
                }
            };
        }
Пример #17
0
        public async Task <FilterResult <ReleasePack> > GetPacksByFCC(int clientID, int currentPage, int pageSize)
        {
            string delimiter = " ";
            var    packids   = string.Empty;

            List <ReleasePack>         packs       = new List <ReleasePack>();
            List <ClientPackException> clientPacks = new List <ClientPackException>();

            using (EverestPortalContext context = new EverestPortalContext())
            {
                clientPacks = context.ClientPackException.Where(x => x.ClientId == clientID).ToList();
                var temp = clientPacks.Select(x => Convert.ToString(x.PackExceptionId)).ToList();
                if (temp.Count() > 0)
                {
                    packids = temp.Aggregate((i, j) => i + delimiter + j);
                }
            }

            var    query         = string.Format("?q=FCC:({0})&rows=" + pageSize, packids);
            string resultContent = null;

            using (var client = new HttpClient())
            {
                client.BaseAddress = new Uri(packsSolrURL);
                client.DefaultRequestHeaders
                .Accept
                .Add(new MediaTypeWithQualityHeaderValue("application/json"));

                var result = await client.GetAsync(query);

                resultContent = result.Content.ReadAsStringAsync().Result;
            }

            XmlDocument doc = new XmlDocument();

            doc.LoadXml(resultContent);
            foreach (XmlNode node in doc.DocumentElement.SelectNodes("/response/result/doc"))
            {
                packs.Add(ParsePack(node));
            }

            int         rCount   = 0;
            XmlNodeList nodeList = doc.SelectNodes("/response/result");

            foreach (XmlNode node in nodeList)
            {
                rCount = Convert.ToInt32(node.Attributes["numFound"].Value);
            }

            foreach (var pack in packs)
            {
                var aClientPack = clientPacks.FirstOrDefault(x => x.PackExceptionId == pack.Id);
                pack.ProductLevel = aClientPack.ProductLevel;
                pack.ExpiryDate   = SetExpiryDate(aClientPack.ExpiryDate);
            }

            //taking the distinct values
            var distinct = packs.GroupBy(i => i.Id).Select(i => i.First()).ToList();

            return(new FilterResult <ReleasePack>
            {
                Data = distinct.OrderBy(x => x.ProductName).ToList(),
                TotalCount = rCount
            });
        }
Пример #18
0
        public string MarketDefinitionReport(int Id, int startVersion, int endVersion, string reportname)
        {
            List <MarketbaseDTO>           marketbaseAuditReport   = new List <MarketbaseDTO>();
            List <MarketDefNameChanges>    MarketDefNameChanges    = new List <MarketDefNameChanges>();
            List <MarketDefPackChanges>    MarketDefPackChanges    = new List <MarketDefPackChanges>();
            List <MarketDefBaseMapChanges> MarketDefBaseMapChanges = new List <MarketDefBaseMapChanges>();
            List <MarketDefGroupChanges>   MarketDefGroupChanges   = new List <MarketDefGroupChanges>();



            using (EverestPortalContext context = new EverestPortalContext())
            {
                if (reportname == "Name Changes")
                {
                    MarketDefNameChanges = context.Database.SqlQuery <MarketDefNameChanges>("exec [AuditMarketDefNameReport] " + startVersion + "," + endVersion + "," + Id + "").ToList();
                    var json = JsonConvert.SerializeObject(MarketDefNameChanges, Formatting.Indented,
                                                           new JsonSerializerSettings
                    {
                        ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                    });


                    return(json);
                }
                else if (reportname == "Market Base Changes")
                {
                    MarketDefBaseMapChanges = context.Database.SqlQuery <MarketDefBaseMapChanges>("exec [AuditMarketDefBaseMapReport] " + startVersion + "," + endVersion + "," + Id + "").ToList();
                    var json = JsonConvert.SerializeObject(MarketDefBaseMapChanges, Formatting.Indented,
                                                           new JsonSerializerSettings
                    {
                        ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                    });


                    return(json);
                }
                else if (reportname == "Pack Changes")
                {
                    MarketDefPackChanges = context.Database.SqlQuery <MarketDefPackChanges>("exec [AuditMarketDefPacksReport] " + startVersion + "," + endVersion + "," + Id + "").ToList();
                    var json = JsonConvert.SerializeObject(MarketDefPackChanges, Formatting.Indented,
                                                           new JsonSerializerSettings
                    {
                        ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                    });


                    return(json);
                }
                else if (reportname == "Group Changes")
                {
                    MarketDefGroupChanges = context.Database.SqlQuery <MarketDefGroupChanges>("exec [AuditMarketDefGroupReport]  " + startVersion + "," + endVersion + "," + Id + "").ToList();
                    var json = JsonConvert.SerializeObject(MarketDefGroupChanges, Formatting.Indented,
                                                           new JsonSerializerSettings
                    {
                        ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                    });


                    return(json);
                }
            }

            return("");
        }
Пример #19
0
        public HttpResponseMessage ImportDeliverablesAndSubscriptionForClient(RequestImport req)
        {
            //var clientid = req.clientId;
            HttpResponseMessage message;
            var selectedClientIds = req.selectedClients;
            var importMessage     = string.Empty;

            try
            {
                if (req.selectAll)
                {
                    return(ImportDeliverablesforAllClients("IRP_Import_Subscription_Deliverables_All", req.EmailId));
                }
                using (EverestPortalContext context = new EverestPortalContext())
                {
                    //if (req.selectAll)
                    //{
                    // return ImportDeliverablesforAllClients("IRP_Import_Subscription_Deliverables_All");
                    //var clients = context.ClientMaps.ToList();
                    //selectedClientIds = new List<int>();
                    //foreach (var ic in clients)
                    //{
                    //    if (ic.ClientId != null)
                    //    {
                    //        selectedClientIds.Add(Convert.ToInt32(ic.ClientId));
                    //    }
                    //}
                    // }

                    List <DataRow> nonIAMCollection = new List <DataRow>();
                    List <DataRow> IAMCollection    = new List <DataRow>();

                    List <DataRow> subResponse  = new List <DataRow>();
                    List <DataRow> deliResponse = new List <DataRow>();


                    foreach (var clientid in selectedClientIds)
                    {
                        List <DataRow> subTempResponse  = new List <DataRow>();
                        List <DataRow> deliTempResponse = new List <DataRow>();
                        var            clientNo         = context.ClientMaps.FirstOrDefault(c => c.ClientId == clientid).IRPClientNo;
                        executeDeliverablesIAM(clientNo, ref subTempResponse, ref deliTempResponse);
                        subResponse.AddRange(subTempResponse);
                        deliResponse.AddRange(deliTempResponse);

                        subTempResponse  = new List <DataRow>();
                        deliTempResponse = new List <DataRow>();
                        executeDeliverablesNonIAM(clientNo, ref subTempResponse, ref deliTempResponse);
                        subResponse.AddRange(subTempResponse);
                        deliResponse.AddRange(deliTempResponse);
                    }

                    var dataDeli = deliResponse.Select(dr => new
                    {
                        SubscriptionId = dr != null ? Convert.ToString(dr["SubscriptionId"]) : "",
                        DeliverableId  = dr != null ? Convert.ToString(dr["DeliverableId"]) : "",
                        Frequency      = dr != null ? Convert.ToString(dr["Frequency"]) : "",
                        FrequencyType  = dr != null ? Convert.ToString(dr["FrequencyType"]) : "",
                        Period         = dr != null ? Convert.ToString(dr["Period"]) : "",
                        Status         = dr != null ? Convert.ToString(dr["Status"]) : ""
                    });

                    var dataSub = subResponse.Select(dr => new
                    {
                        SubscriptionId = dr != null ? Convert.ToString(dr["SubscriptionId"]) : "",
                        Country        = dr != null ? Convert.ToString(dr["Country"]) : "",
                        Service        = dr != null ? Convert.ToString(dr["Service"]) : "",
                        TerritoryBase  = dr != null ? Convert.ToString(dr["TerritoryBase"]) : "",
                        DataType       = dr != null ? Convert.ToString(dr["DataType"]) : "",
                        ClienId        = dr != null ? Convert.ToString(dr["ClientId"]) : "",
                        Status         = dr != null ? Convert.ToString(dr["Status"]) : ""
                    });

                    var result = new
                    {
                        sResponse   = dataSub,
                        dResponse   = dataDeli,
                        IsSelectAll = false,
                        importMessage
                    };

                    message = Request.CreateResponse(HttpStatusCode.OK, result);
                    return(message);
                }
            }
            catch (Exception ex)
            {
                string exMessage = ex.Message;
                throw ex;
            }
        }
        public async Task <HttpResponseMessage> EditMarketBase(int ClientId, int MarketBaseId)
        {
            AuthController objAuth = new AuthController();

            if (objAuth.CheckUserClients(ClientId) == 0)
            {
                return(Request.CreateResponse(HttpStatusCode.Unauthorized, "You have no permission to view/edit this marketbase"));
            }

            HttpContent requestContent = Request.Content;
            var         jsonContent    = requestContent.ReadAsStringAsync().Result;
            // var marketBase = JsonConvert.DeserializeObject<MarketBase>(jsonContent);

            var marketBaseDetails             = JsonConvert.DeserializeObject <MarketbaseDetails>(jsonContent);
            List <DimensionBaseMap> Dimension = marketBaseDetails.Dimension; //to get dimension seperatly.
            List <PxR> PxRCollection          = marketBaseDetails.PxR;       //to get PxR seperatly.
            MarketBase marketBase             = marketBaseDetails.MarketBase;

            var identity = (ClaimsIdentity)User.Identity;
            int uid      = Convert.ToInt32(identity.Claims.FirstOrDefault(c => c.Type == "userid").Value.ToString());

            Guid Id = Guid.NewGuid();

            if (jsonContent.Trim() != string.Empty)
            {
                MarketBase MBObj = null;
                using (var db = new EverestPortalContext())
                {
                    var oldBaseFilter = db.BaseFilters.Where(i => i.MarketBaseId == MarketBaseId).ToList();
                    if (oldBaseFilter != null)
                    {
                        db.BaseFilters.RemoveRange(oldBaseFilter);
                        db.SaveChanges();
                    }

                    MBObj = db.MarketBases.Where(i => i.Id == MarketBaseId).FirstOrDefault();

                    if (MBObj != null)
                    {
                        MBObj.BaseType     = marketBase.BaseType;
                        MBObj.Description  = marketBase.Description;
                        MBObj.DurationFrom = marketBase.DurationFrom;
                        MBObj.DurationTo   = marketBase.DurationTo;
                        MBObj.Name         = marketBase.Name;
                        MBObj.Suffix       = marketBase.Suffix;
                        MBObj.LastSaved    = DateTime.Now;
                        foreach (BaseFilter fil in marketBase.Filters)
                        {
                            BaseFilter obj = fil;
                            obj.MarketBaseId = MarketBaseId;
                            MBObj.Filters.Add(obj);
                        }
                        MBObj.LastModified = DateTime.Now;
                        MBObj.ModifiedBy   = uid;
                    }
                    else
                    {
                        marketBase.GuiId = Id.ToString();
                        // marketBase.LastSaved = DateTime.Now;
                        marketBase.LastModified = DateTime.Now;
                        marketBase.ModifiedBy   = uid;
                        db.MarketBases.Add(marketBase);
                    }

                    db.SaveChanges();
                    //to save dimension base map
                    await SaveDimensionBaseMap(MarketBaseId, Dimension);
                    await SavePxRBaseMap(MarketBaseId, PxRCollection);
                }
            }

            var objClient = _db.MarketBases.Where(u => u.Id == MarketBaseId).ToList <MarketBase>().FirstOrDefault();

            // place the request in queue
            var result = _db.Database.SqlQuery <string>("exec PutInMarketBaseQueue " + MarketBaseId + "," + uid).FirstOrDefault();

            var json = JsonConvert.SerializeObject(result, Formatting.Indented,
                                                   new JsonSerializerSettings
            {
                ReferenceLoopHandling = ReferenceLoopHandling.Ignore
            });

            return(Request.CreateResponse(HttpStatusCode.OK, json));
        }
        public async Task <HttpResponseMessage> saveClientMarketDef(int ID)
        {
            HttpContent requestContent = Request.Content;
            var         jsonContent    = requestContent.ReadAsStringAsync().Result;
            Guid        Id             = Guid.NewGuid();
            int         MarketDefId;
            var         client = JsonConvert.DeserializeObject <Client[]>(jsonContent);
            var         marketDefinitionPacks = client[0].MarketDefinitions[0].MarketDefinitionPacks;//store Packs

            //to remove marketdefinition packs from Marketdefinition model
            client[0].MarketDefinitions[0].MarketDefinitionPacks = null;
            //to clear market base when client save market base
            for (var i = 0; i < client[0].MarketDefinitions[0].MarketDefinitionBaseMaps.Count(); i++)
            {
                client[0].MarketDefinitions[0].MarketDefinitionBaseMaps[i].MarketBase = null;
            }

            client[0].MarketDefinitions[0].GuiId        = Id.ToString();
            client[0].MarketDefinitions[0].LastModified = DateTime.Now;
            var identity = (ClaimsIdentity)User.Identity;
            int uid      = Convert.ToInt32(identity.Claims.FirstOrDefault(c => c.Type == "userid").Value.ToString());

            client[0].MarketDefinitions[0].ModifiedBy = uid;
            using (var db = new EverestPortalContext())
            {
                _db.MarketDefinitions.Add(client[0].MarketDefinitions[0]).ClientId = ID;
                //_db.SaveChanges();
                await _db.SaveChangesAsync();

                MarketDefId = client[0].MarketDefinitions[0].Id;
            }



            var packsDt = new DataTable();

            packsDt.Columns.Add("Pack", typeof(string));
            packsDt.Columns.Add("MarketBase", typeof(string));
            packsDt.Columns.Add("MarketBaseId", typeof(string));
            packsDt.Columns.Add("GroupNumber", typeof(string));
            packsDt.Columns.Add("GroupName", typeof(string));
            packsDt.Columns.Add("Factor", typeof(string));
            packsDt.Columns.Add("PFC", typeof(string));
            packsDt.Columns.Add("Manufacturer", typeof(string));
            packsDt.Columns.Add("ATC4", typeof(string));
            packsDt.Columns.Add("NEC4", typeof(string));
            packsDt.Columns.Add("DataRefreshType", typeof(string));
            packsDt.Columns.Add("StateStatus", typeof(string));
            packsDt.Columns.Add("MarketDefinitionId", typeof(int));
            packsDt.Columns.Add("Alignment", typeof(string));
            packsDt.Columns.Add("Product", typeof(string));
            packsDt.Columns.Add("ChangeFlag", typeof(string));
            packsDt.Columns.Add("Molecule", typeof(string));


            foreach (var item in marketDefinitionPacks)
            {
                item.MarketDefinitionId = MarketDefId;
                packsDt.Rows.Add(item.Pack, item.MarketBase, item.MarketBaseId, item.GroupNumber, item.GroupName, item.Factor, item.PFC, item.Manufacturer, item.ATC4, item.NEC4, item.DataRefreshType, item.StateStatus, MarketDefId, item.Alignment, item.Product, item.ChangeFlag, item.Molecule);
            }

            SqlParameter paramMarketDefinitionID = new SqlParameter("@marketdefinitionid", MarketDefId);
            SqlParameter paramPacks = new SqlParameter("@TVP", packsDt);

            paramPacks.SqlDbType = System.Data.SqlDbType.Structured;
            paramPacks.TypeName  = "TYP_MarketDefinitionPacks";
            //_db.Database.ExecuteSqlCommand("exec  EditMarketDefinition @marketdefinitionid,@TVP", paramMarketDefinitionID, paramPacks);
            await _db.Database.ExecuteSqlCommandAsync("exec  EditMarketDefinition @marketdefinitionid,@TVP", paramMarketDefinitionID, paramPacks);


            var objClient = _db.MarketDefinitions.Where(u => u.ClientId == ID && u.GuiId == Id.ToString()).FirstOrDefault();

            /*var json = JsonConvert.SerializeObject(objClient, Formatting.Indented,
             *          new JsonSerializerSettings
             *          {
             *              ReferenceLoopHandling = ReferenceLoopHandling.Ignore
             *          });*/

            return(Request.CreateResponse(HttpStatusCode.OK, objClient));
        }
Пример #22
0
        public bool SaveSubchannel([FromBody] EntityType entityType)
        {
            bool result = false;

            if (entityType != null)
            {
                using (var context = new EverestPortalContext())
                {
                    if (entityType.EntityTypeId == 0) //Add a new record
                    {
                        var isExist = context.EntityTypes.FirstOrDefault(e =>
                                                                         e.EntityTypeName == entityType.EntityTypeCode.Trim() ||
                                                                         e.Abbrev == entityType.Abbrev.Trim() ||
                                                                         e.Display == entityType.Display.Trim() ||
                                                                         e.Description == entityType.Description.Trim()
                                                                         );

                        if (isExist != null)
                        {
                            return(false);
                        }

                        var entity = new EntityType()
                        {
                            EntityTypeCode = entityType.EntityTypeCode.Trim(),
                            EntityTypeName = entityType.Display.Trim(),
                            DataTypeId     = entityType.DataTypeId,
                            Abbrev         = entityType.Abbrev.Trim(),
                            Display        = entityType.Display.Trim(),
                            Description    = entityType.Description.Trim(),
                            IsActive       = entityType.IsActive
                        };

                        context.EntityTypes.Add(entity);
                    }
                    else //Update existing record
                    {
                        var isExist = context.EntityTypes.FirstOrDefault(e =>
                                                                         (e.EntityTypeName == entityType.EntityTypeCode.Trim() ||
                                                                          e.Abbrev == entityType.Abbrev.Trim() ||
                                                                          e.Display == entityType.Display.Trim() ||
                                                                          e.Description == entityType.Description.Trim()) &&
                                                                         e.EntityTypeId != entityType.EntityTypeId
                                                                         );

                        if (isExist != null)
                        {
                            return(false);
                        }

                        var entity = context.EntityTypes.SingleOrDefault(e => e.EntityTypeId == entityType.EntityTypeId);
                        if (entity != null)
                        {
                            entity.EntityTypeCode = entityType.EntityTypeCode.Trim();
                            entity.EntityTypeName = entityType.EntityTypeName.Trim();
                            entity.DataTypeId     = entityType.DataTypeId;
                            entity.Abbrev         = entityType.Abbrev.Trim();
                            entity.Display        = entityType.Display.Trim();
                            entity.Description    = entityType.Description.Trim();
                            entity.IsActive       = entityType.IsActive;
                        }

                        //If enity type is inactive then delete all respective subchannels
                        if (!entityType.IsActive)
                        {
                            var subchannels = context.SubChannels.Where(s => s.EntityTypeId == entityType.EntityTypeId).ToList();
                            context.SubChannels.RemoveRange(subchannels);
                        }
                    }

                    context.SaveChanges();
                    result = true;
                }
            }

            return(result);
        }
Пример #23
0
        public HttpResponseMessage ImportClients([FromBody] RequestImport request)
        {
            HttpResponseMessage message;

            using (EverestPortalContext context = new EverestPortalContext())
            {
                var isSuccess = false;

                List <int> clientids = request.selectedClients;
                if (request.selectAll)
                {
                    var irpclients = context.IRPClients.ToList();
                    clientids = new List <int>();
                    foreach (var ic in irpclients)
                    {
                        if (ic.ClientId != null)
                        {
                            clientids.Add(Convert.ToInt32(ic.ClientId));
                        }
                    }
                }

                foreach (var clientid in clientids)
                {
                    if (!context.ClientMaps.Any(x => x.IRPClientId == clientid))
                    {
                        var irpClient = context.IRPClients.FirstOrDefault(i => i.ClientId == clientid);
                        if (irpClient != null && !string.IsNullOrEmpty(irpClient.ClientName))
                        {
                            var newClient = new Client()
                            {
                                Name       = irpClient.ClientName,
                                IsMyClient = false
                            };

                            if (!context.Clients.Any(c => c.Name == newClient.Name))
                            {
                                context.Clients.Add(newClient);
                                context.SaveChanges();

                                context.ClientMaps.Add(new ClientMap
                                {
                                    ClientId    = newClient.Id,
                                    IRPClientId = irpClient.ClientId,
                                    IRPClientNo = irpClient.ClientNo,
                                });
                                context.SaveChanges();
                            }
                        }
                    }
                    isSuccess = true;
                }



                var result = new
                {
                    message = "selected client is successfully imported",
                    isSuccess
                };

                message = Request.CreateResponse(HttpStatusCode.OK, result);
                return(message);
            }
        }
Пример #24
0
        public HttpResponseMessage ImportMarkets(RequestImport req)
        {
            try
            {
                //var clientid = req.clientId;
                HttpResponseMessage message;
                var selectedClients = req.selectedClients;
                using (EverestPortalContext context = new EverestPortalContext())
                {
                    if (req.selectAll)
                    {
                        return(ImportMarketsForAllClients("IRP_Import_Market_All", req.EmailId));
                        //var importedClients = (from c in context.Clients
                        //                       join
                        //                       cm in context.ClientMaps on c.Id equals cm.ClientId
                        //                       select c.Id).Distinct().ToList();
                        ////var clients = context.Clients.ToList();
                        //selectedClients = new List<int>();
                        //foreach (var ic in importedClients)
                        //{
                        //    if (ic != null)
                        //    {
                        //        selectedClients.Add(Convert.ToInt32(ic));
                        //    }
                        //}
                    }
                }

                var drs = executeImportMarketDefinitions(selectedClients);

                string msg = "Market definitions imported sucessfully";
                if (drs.Count == 0)
                {
                    msg = "No market definitions are imported";
                }

                var logCollection = drs.Select(row => new
                {
                    clientId         = Convert.ToString(row["ClientId"]),
                    clientName       = Convert.ToString(row["ClientName"]),
                    dimensionId      = Convert.ToString(row["DimensionId"]),
                    marketDefinition = Convert.ToString(row["MarketDefinition"]),
                    status           = Convert.ToString(row["Status"]),
                    timeOfImport     = Convert.ToString(row["TimeOfImport"]),
                    username         = Convert.ToString(row["UserName"])
                }).ToList();


                var result = new
                {
                    message   = msg,
                    isSuccess = true,
                    log       = logCollection
                };

                message = Request.CreateResponse(HttpStatusCode.OK, result);
                return(message);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public HttpResponseMessage GetReportSectionListByUserType(int id)
        {
            HttpResponseMessage message;
            var ReportSections = new List <ReportSection>();
            var identity       = (ClaimsIdentity)User.Identity;
            //force to use login id, can not pass other value for security reasons.
            var tid = identity.Claims.FirstOrDefault(c => c.Type == "userid").Value.ToString();
            int uid = Convert.ToInt32(tid);


            using (var db = new EverestPortalContext())
            {
                ReportSections = db.ReportSections.ToList();

                //Where( m => m.UserTypeID == id).ToList();
                var RoleID = (from u in db.Users
                              join urole in db.userRole
                              on u.UserID equals urole.UserID
                              where urole.UserID == uid
                              select urole.RoleID).ToList();

                var UserTypeID = db.Users.FirstOrDefault(u => u.UserID == id).UserTypeID;

                if (RoleID.Contains(1) || RoleID.Contains(2))  // External User
                {
                    ReportSections = ReportSections.Where(q => q.UserTypeID == 2).ToList();
                }

                if (RoleID.Contains(8))
                {
                    ReportSections = ReportSections.Where(r => r.ReportSectionName == "Territories").ToList();
                }
            }

            if (ReportSections.Count > 1)
            {
                //interchange territories and subscriptions  in the section drop down
                var index = ReportSections.FindIndex(f => string.Equals(f.ReportSectionName, "Territories", StringComparison.InvariantCultureIgnoreCase));
                if (index >= 0)
                {
                    var fItem = ReportSections[index];
                    ReportSections.RemoveAt(index);
                    ReportSections.Insert(1, fItem);
                }

                var newindex = ReportSections.FindIndex(f => string.Equals(f.ReportSectionName, "Allocation", StringComparison.InvariantCultureIgnoreCase));
                if (newindex >= 0)
                {
                    var fAllocationItem = ReportSections[newindex];
                    ReportSections.RemoveAt(newindex);
                    ReportSections.Insert(ReportSections.Count, fAllocationItem);
                }
            }



            var response = new
            {
                data = ReportSections
            };

            message = Request.CreateResponse(HttpStatusCode.OK, response);
            return(message);
        }
Пример #26
0
        public HttpResponseMessage GetClientReleaseDetails(string id, string isAllClients)
        {
            var identity = (ClaimsIdentity)User.Identity;
            //force to use login id, can not pass other value for security reasons.
            var tid = identity.Claims.FirstOrDefault(c => c.Type == "userid").Value.ToString();

            var getAllClients = false;

            if (!string.IsNullOrWhiteSpace(isAllClients))
            {
                getAllClients = Convert.ToBoolean(isAllClients);
            }
            HttpResponseMessage message;

            using (EverestPortalContext context = new EverestPortalContext())
            {
                var clientReleaseDetails = (from client in context.Clients
                                            join
                                            clRelease in context.ClientRelease on client.Id equals clRelease.ClientId into rClients
                                            from r in rClients.DefaultIfEmpty()

                                            join cMfr in context.ClientMFR on client.Id equals cMfr.ClientId into mCLients
                                            from m in mCLients.DefaultIfEmpty()

                                            join pException in context.ClientPackException on client.Id equals pException.ClientId into pClients
                                            from p in pClients.DefaultIfEmpty()

                                            select new
                {
                    clientId = client.Id,
                    clientName = client.Name,
                    CapitalChemist = r.CapitalChemist == null ? false : r.CapitalChemist,
                    Census = r.Census == null ? false : r.Census,
                    OneKey = r.OneKey == null ? false : r.OneKey,
                    MfrId = m.MFRId,
                    packExceptionId = p.PackExceptionId
                }).GroupBy(x => x.clientId).Select(x => new
                {
                    clientId       = x.Key,
                    clientName     = x.FirstOrDefault().clientName,
                    OneKey         = x.FirstOrDefault().OneKey,
                    CapitalChemist = x.FirstOrDefault().CapitalChemist,
                    Census         = x.FirstOrDefault().Census,
                    MfrCount       = x.Select(m => m.MfrId).Distinct().Where(w => w != null).Count(),
                    packCount      = x.Select(p => p.packExceptionId).Distinct().Where(w => w != null).Count()
                }).
                                           ToList();

                var uId         = Convert.ToInt32(tid); //force to use login id, not querystring
                var userClients = context.userClient.Where(u => u.UserID == uId).Select(x => x.ClientID).ToList();


                var responseReleaseClients = new List <ReleaseClient>();

                foreach (var cr in clientReleaseDetails)
                {
                    var aClientRelease = new ReleaseClient()
                    {
                        clientId       = cr.clientId,
                        clientName     = cr.clientName,
                        CapitalChemist = cr.CapitalChemist == null ? false : Convert.ToBoolean(cr.CapitalChemist),
                        Census         = cr.Census == null ? false : Convert.ToBoolean(cr.Census),
                        OneKey         = cr.OneKey == null ? false : Convert.ToBoolean(cr.OneKey),
                        MfrCount       = cr.MfrCount,
                        packCount      = cr.packCount,
                        isMyClient     = userClients.Contains(cr.clientId)
                    };
                    if (getAllClients || aClientRelease.isMyClient)
                    {
                        responseReleaseClients.Add(aClientRelease);
                    }
                }


                var response = new
                {
                    //data = clientReleaseDetails.Where(cr => userClients.Contains(cr.clientId)).ToList()
                    data = responseReleaseClients.OrderBy(r => r.clientName).ToList()
                };

                message = Request.CreateResponse(HttpStatusCode.OK, response);
                return(message);
            }
        }