public ActionResult CompanyCodeToUser(string username) { if (string.IsNullOrEmpty(username)) { return(RedirectToAction("Index")); } MembershipUser user = membershipService.GetUser(User.Identity.Name); var AvailableCompanyCodeForUser = from c in memberShipContext.MembershipFranchise where !(from o in memberShipContext.UserFranchise select o.FranchiseID).Contains(c.FranchiseID) select c; var AllCompanyCodeForUser = memberShipContext.UserFranchise.ToList(); var GrantedCompanyCode = memberShipContext.UserFranchise.Where(uf => uf.UserId == (Guid)user.ProviderUserKey).ToList(); var model = new GrantCompaniesToUser { UserName = username, AvailibleCompanies = (string.IsNullOrEmpty(username) ? new SelectList(AllCompanyCodeForUser) : new SelectList(AvailableCompanyCodeForUser)), GrantedCompanies = (string.IsNullOrEmpty(username) ? new SelectList(new string[] { }) : new SelectList(GrantedCompanyCode)) }; return(View(model)); }
/// <summary> /// Return two lists: /// 1) a list of Company Code not granted to the user /// 2) a list of Company Code granted to the user /// </summary> /// <param name="username"></param> /// <returns></returns> public ActionResult CompanyCodeToUser(string username) { if (string.IsNullOrEmpty(username)) { return(RedirectToAction("Index", "CompanyCode")); } MembershipUser user = membershipService.GetUser(username); var AvailableCompanyCodeForUser = default(IList); var AllCompanyCodeForUser = default(IList); var isCorporate = User.IsInRole("Corporate"); int[] assignedFranchises; using (var ctx = new MembershipConnection()) { assignedFranchises = ctx.UserFranchise .Where(uf => uf.UserId == (Guid)user.ProviderUserKey) .Select(f => f.FranchiseID) .ToArray(); } AvailableCompanyCodeForUser = (from a in memberShipContext.MembershipFranchise where !(from o in memberShipContext.UserFranchise where o.UserId == (Guid)user.ProviderUserKey select o.FranchiseID).Contains(a.FranchiseID) select a.FranchiseNumber).Distinct().ToList(); var model = new GrantCompaniesToUser { UserName = username, AvailibleCompanies = (string.IsNullOrEmpty(username) ? new SelectList(AllCompanyCodeForUser) : new SelectList(AvailableCompanyCodeForUser)), GrantedCompanyCode = memberShipContext.MembershipFranchise .Where(f => assignedFranchises.Contains(f.FranchiseID)) .OrderBy(f => f.FranchiseNumber) .Select(d => new SelectListItem { Text = d.FranchiseNumber, Value = d.FranchiseNumber }) .ToList(), }; return(View(model)); }
public ActionResult UserCompanyCode() { IMembershipService membershipService; IAuthenticationService authenticationService; membershipService = new MembershipService(Membership.Provider); authenticationService = new AuthenticationService(membershipService, new FormsAuthenticationService()); MembershipUser user = membershipService.GetUser(User.Identity.Name); var userId = user == null ? Guid.Empty : (Guid)(user.ProviderUserKey ?? Guid.Empty); var isCorporate = User.IsInRole("Corporate"); string username = user.UserName; int[] assignedFranchises; var DefaultCompamyName = default(String); var DefaultCompanyID = default(int); if (Session["selectedFranchiseId"] != null) { DefaultCompanyID = Convert.ToInt32(Session["selectedFranchiseId"]); DefaultCompamyName = (from g in db.tbl_Franchise where g.FranchiseID == DefaultCompanyID select string.Concat(g.LegalName, " - ", g.FranchiseNUmber)).FirstOrDefault(); ViewBag.code = DefaultCompamyName; } else { DefaultCompamyName = (from g in memberShipContext.UserFranchise where g.FranchiseID == 56 && g.UserId == userId select g.Franchise.FranchiseNumber).FirstOrDefault(); if (DefaultCompamyName != null) { DefaultCompamyName = (from g in db.tbl_Franchise where g.FranchiseNUmber == DefaultCompamyName select string.Concat(g.LegalName, " - ", g.FranchiseNUmber)).FirstOrDefault(); } if (DefaultCompamyName == null) { DefaultCompamyName = (from g in memberShipContext.UserFranchise where g.UserId == userId select g.Franchise.FranchiseNumber).FirstOrDefault(); DefaultCompamyName = (from g in db.tbl_Franchise where g.FranchiseNUmber == DefaultCompamyName select string.Concat(g.LegalName, " - ", g.FranchiseNUmber)).FirstOrDefault(); } DefaultCompanyID = (from g in memberShipContext.UserFranchise where g.FranchiseID == 56 && g.UserId == userId select g.Franchise.FranchiseID).FirstOrDefault(); if (DefaultCompanyID == 0) { DefaultCompanyID = (from g in memberShipContext.UserFranchise where g.UserId == userId select g.Franchise.FranchiseID).FirstOrDefault(); } if (RouteData.Values["id"] != null) { int companyCodeID = int.Parse(Convert.ToString(RouteData.Values["id"])); DefaultCompamyName = (from g in memberShipContext.UserFranchise where g.FranchiseID == companyCodeID && g.UserId == userId select g.Franchise.FranchiseNumber).FirstOrDefault(); DefaultCompanyID = (from g in memberShipContext.UserFranchise where g.FranchiseID == companyCodeID && g.UserId == userId select g.Franchise.FranchiseID).FirstOrDefault(); } } using (var ctx = new MembershipConnection()) { assignedFranchises = ctx.UserFranchise .Where(uf => uf.UserId == userId) .Select(f => f.FranchiseID) .ToArray(); } var model = new GrantCompaniesToUser { UserName = username, GrantedCompanyCode = db.tbl_Franchise .Where(f => assignedFranchises.Contains(f.FranchiseID)) .OrderBy(f => f.FranchiseNUmber) .Select(d => new SelectListItem { Text = string.Concat(d.LegalName, " - ", d.FranchiseNUmber), Value = System.Data.Objects.SqlClient.SqlFunctions.StringConvert((double)d.FranchiseID) }) .ToList(), defaultCompanyName = DefaultCompamyName, defaultCompanyID = DefaultCompanyID }; var swapBranding = false; if (HttpContext.User.IsInRole("CompanyOwner")) { using (var ctx = new MembershipConnection()) { swapBranding = ctx.UserFranchise .Where(uf => uf.UserId == userId) .ToArray() .Select(uf => (from f in db.tbl_Franchise where f.FranchiseID == uf.FranchiseID select f).SingleOrDefault()) .Any(f => f.FranchiseTypeID == 6); } } ViewBag.SwapBranding = swapBranding; return(PartialView("CompanyCodeUser", model)); }
//Running Code public ActionResult UserCompanyCode() { IMembershipService membershipService; IAuthenticationService authenticationService; membershipService = new MembershipService(Membership.Provider); authenticationService = new AuthenticationService(membershipService, new FormsAuthenticationService()); MembershipUser user = membershipService.GetUser(User.Identity.Name); var userId = user == null ? Guid.Empty : (Guid)(user.ProviderUserKey ?? Guid.Empty); var isCorporate = User.IsInRole("Corporate"); string username = user.UserName; int[] assignedFranchises; var DefaultCompamyName = default(String); var DefaultCompanyID = default(int); DefaultCompamyName = (from g in memberShipContext.UserFranchise where g.FranchiseID == 56 && g.UserId == userId select g.Franchise.FranchiseNumber).FirstOrDefault(); if (DefaultCompamyName == null) { DefaultCompamyName = (from g in memberShipContext.UserFranchise where g.UserId == userId select g.Franchise.FranchiseNumber).FirstOrDefault(); } DefaultCompanyID = (from g in memberShipContext.UserFranchise where g.FranchiseID == 56 && g.UserId == userId select g.Franchise.FranchiseID).FirstOrDefault(); if (DefaultCompanyID == 0) { DefaultCompanyID = (from g in memberShipContext.UserFranchise where g.UserId == userId select g.Franchise.FranchiseID).FirstOrDefault(); } if (RouteData.Values["id"] != null) { int companyCodeID = int.Parse(Convert.ToString(RouteData.Values["id"])); DefaultCompamyName = (from g in memberShipContext.UserFranchise where g.FranchiseID == companyCodeID && g.UserId == userId select g.Franchise.FranchiseNumber).FirstOrDefault(); DefaultCompanyID = (from g in memberShipContext.UserFranchise where g.FranchiseID == companyCodeID && g.UserId == userId select g.Franchise.FranchiseID).FirstOrDefault(); } using (var ctx = new MembershipConnection()) { assignedFranchises = ctx.UserFranchise .Where(uf => uf.UserId == userId) .Select(f => f.FranchiseID) .ToArray(); } var model = new GrantCompaniesToUser { UserName = username, GrantedCompanyCode = memberShipContext.MembershipFranchise .Where(f => assignedFranchises.Contains(f.FranchiseID)) .OrderBy(f => f.FranchiseNumber) .Select(d => new SelectListItem { Text = d.FranchiseNumber, Value = SqlFunctions.StringConvert((double)d.FranchiseID) }) .ToList(), defaultCompanyName = DefaultCompamyName, defaultCompanyID = DefaultCompanyID }; return(PartialView("CompanyCodeUser", model)); }