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