コード例 #1
0
        /// <summary>
        /// Get proxy user list.
        /// </summary>
        /// <param name="userName">user name</param>
        /// <returns></returns>
        public IVoteProxyListVM GetVoteProxyListVM(string userName)
        {
            int?userid         = GetUserID(userName);
            var _voteproxylist = _kernel.Get <IVoteProxyListVM>();

            if (userid != null)
            {
                var ProxyList = (from PPU in this.dataContext.Poll_ProxyUser
                                 join UD in this.dataContext.UserDetails on PPU.UserId equals UD.UserID
                                 join U in this.dataContext.Users on UD.UserID equals U.UserID
                                 join PG in this.dataContext.Partner_Types on UD.PartnerTypeID equals PG.PTID
                                 where PPU.IsEnabled == true && UD.IsDeleted == false && U.IsEnabled == true && PPU.ProxyUserId == userid
                                 select new
                {
                    U.UserID,
                    U.Initial,
                    UD.FirstName,
                    UD.LastName,
                    UD.Title,
                    UD.PartnerTypeID,
                    UD.OfficeLocation,
                    UD.IsInternationalPartner,
                    PG.PartnerTypeDescription
                }).ToList();

                if (ProxyList.Count > 0)
                {
                    foreach (var pl in ProxyList)
                    {
                        IPersonnelForProxyVM pp = new PersonnelForProxyVM();
                        pp.Grade = pl.PartnerTypeDescription;
                        pp.Name  = pl.Title + " " + pl.FirstName + " " + pl.LastName;
                        if (pl.IsInternationalPartner == true)
                        {
                            pp.International = "Y";
                        }
                        else if (pl.IsInternationalPartner == false)
                        {
                            pp.International = "N";
                        }
                        else
                        {
                            pp.International = "";
                        }

                        pp.Initials = pl.Initial;
                        pp.Office   = pl.OfficeLocation;
                        pp.UserID   = pl.UserID;
                        _voteproxylist.proxyPersonnelList.Add(pp);
                    }
                    return(_voteproxylist);
                }
                else
                {
                    return(_voteproxylist);
                }
            }

            return(_voteproxylist);
        }
コード例 #2
0
        /// <summary>
        /// Get assigned proxy
        /// </summary>
        /// <returns>Assign Proxy VM</returns>
        public IAssignProxyVM GetAssignProxyVM()
        {
            var objUserDetails = (from UD in this.dataContext.UserDetails
                                  join U in this.dataContext.Users on UD.UserID equals U.UserID
                                  where UD.IsDeleted == false &&
                                  U.IsEnabled == true && U.IsAllowedToVote == true && UD.isResigned == false
                                  select new
            {
                U.UserID,
                UD.LastName,
                UD.FirstName,
                U.Initial,
                UD.Title,
                UD.PartnerTypeID,
                UD.UserTypeID,
                UD.IsInternationalPartner,
                UD.OfficeLocation,
                UD.isResigned,
                UD.ResignationDate,
                UD.DateLeft,
                UD.EmailAddress
            }).OrderBy(x => x.FirstName).ToList();

            if (objUserDetails.Count > 0)
            {
                foreach (var a in objUserDetails)
                {
                    IPersonnelForProxyVM po = new PersonnelForProxyVM();
                    po.UserID = a.UserID;
                    po.Name   = a.Title + ' ' + a.FirstName + ' ' + a.LastName;

                    po.Initials = a.Initial;

                    po.Office = a.OfficeLocation;
                    po.Title  = a.Title;

                    int?proxyid = GetProxy(a.UserID);
                    if (proxyid != null)
                    {
                        var proxydetails = (from UD in this.dataContext.UserDetails
                                            join U in this.dataContext.Users on UD.UserID equals U.UserID
                                            where UD.IsDeleted == false && U.UserID == proxyid && U.IsAllowedToVote == true

                                            select new
                        {
                            U.UserID,
                            UD.LastName,
                            UD.FirstName,
                            U.Initial,
                            UD.Title,
                            UD.PartnerTypeID,
                            UD.UserTypeID,
                            UD.IsInternationalPartner,
                            UD.OfficeLocation,
                            UD.isResigned,
                            UD.ResignationDate,
                            UD.DateLeft,
                            UD.EmailAddress
                        }).OrderBy(x => x.FirstName).ToList();

                        if (proxydetails.Count > 0)
                        {
                            po.ProxyInitials = proxydetails[0].Initial;
                            po.ProxyName     = proxydetails[0].FirstName + " " + proxydetails[0].LastName + " (" + proxydetails[0].Initial + ")";
                        }
                    }

                    if (a.IsInternationalPartner == true)
                    {
                        po.International = "Y";
                    }
                    else
                    {
                        po.International = "N";
                    }

                    if (a.PartnerTypeID == 1)
                    {
                        po.Grade = "A";
                    }
                    else if (a.PartnerTypeID == 2)
                    {
                        po.Grade = "B";
                    }
                    else
                    {
                        po.Grade = "Admin";
                    }



                    if (a.UserTypeID == 1)
                    {
                        po.AdminRights = "Y";
                    }
                    else if (a.UserTypeID == 2)
                    {
                        po.AdminRights = "S";
                    }
                    else
                    {
                        po.AdminRights = "N";
                    }

                    proxyDropDownListClass pdd = new proxyDropDownListClass()
                    {
                        usrid   = a.UserID,
                        usrname = a.FirstName + " " + a.LastName + " (" + a.Initial + ")"
                    };

                    this.assignProxyVM.proxyDropDownlist.Add(pdd);
                    this.assignProxyVM.proxyPersonnelList.Add(po);
                }
            }

            return(this.assignProxyVM);
        }