public override string[] GetRolesForUser(string username)
{
//using (EmployeeDBContext context = new EmployeeDBContext())
//{
//var userRoles = (from user in context.Users
// join roleMapping in context.UserRolesMappings
// on user.ID equals roleMapping.UserID
// join role in context.RoleMasters
// on roleMapping.RoleID equals role.ID
// where user.UserName == username
// select role.RollName).ToArray();
Tbl_LoginBusinessModelLayers tbl_loginBusinessModelLayers = new Tbl_LoginBusinessModelLayers();
BusinessModelLayer.Tbl_LoginSingle tbl_login = tbl_loginBusinessModelLayers.GetAllTbl_Logins().FirstOrDefault(x => x.Username == username);
var userRoles = "User".Split(',').ToArray();
if (tbl_login != null)
{
userRoles = tbl_login.Roles.Split(',').ToArray();
}
return(userRoles);
//}
}
public ActionResult Details(string Username)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
Tbl_LoginBusinessModelLayers tbl_loginBusinessModelLayers = new Tbl_LoginBusinessModelLayers();
BusinessModelLayer.Tbl_LoginSingle tbl_login = tbl_loginBusinessModelLayers.GetAllTbl_Logins().FirstOrDefault(x => x.Username == Username);
return(View(tbl_login));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
public ViewResult List(string sortOrder, string currentFilter, string searchString, int?page, string PgeSize)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
ViewBag.CurrentSort = sortOrder;
ViewBag.UsernameSortParm = String.IsNullOrEmpty(sortOrder) ? "Username_desc" : "";
BusinessLayer.Validation pge = new BusinessLayer.Validation();
List <SelectListItem> PgeSizes = pge.PageSize();
//Assigning generic list to ViewBag
ViewBag.PgeSizeList = PgeSizes;
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
Tbl_LoginBusinessModelLayers tbl_loginBusinessModelLayers = new Tbl_LoginBusinessModelLayers();
List <BusinessModelLayer.Vwtbl_login> vwtbl_logins = tbl_loginBusinessModelLayers.GetAllVwtbl_logins();
if (!String.IsNullOrEmpty(searchString))
{
vwtbl_logins = vwtbl_logins.Where(s => s.Username.ToString().ToLower().Contains(searchString.ToLower())).ToList();
}
switch (sortOrder)
{
case "Username_desc":
vwtbl_logins = vwtbl_logins.OrderByDescending(s => s.Username).ToList();
break;
//case "!!!":
// vwtbl_logins = vwtbl_logins.OrderBy(s => s.!!!).ToList();
// break;
//case "!!!_desc":
// vwtbl_logins = vwtbl_logins.OrderByDescending(s => s.!!!).ToList();
// break;
default: // Username ascending
vwtbl_logins = vwtbl_logins.OrderBy(s => s.Username).ToList();
break;
}
int pageSize = 10;
if (PgeSize != null)
{
Int32.TryParse(PgeSize, out pageSize);
}
ViewBag.PgeSize = pageSize;
int pageNumber = (page ?? 1);
return(View(vwtbl_logins.ToPagedList(pageNumber, pageSize)));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
