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