public List <ClsApp> GetListClsApps()
{
PurolatorReportingSQLDataContext prContext = new PurolatorReportingSQLDataContext();
List <ClsApp> oApplist = (from data in prContext.GetTable <tblPI_Application>()
orderby data.ApplicationName
select new ClsApp
{
idPIApplication = data.idPI_Application,
AppName = data.ApplicationName
}).ToList();
return(oApplist);
}
public List <ClsEmployee> GetListClsEmployees()
{
PurolatorReportingSQLDataContext prContext = new PurolatorReportingSQLDataContext();
List <ClsEmployee> oEmployeelist = (from data in prContext.GetTable <tblEmployee>()
orderby data.FirstName
select new ClsEmployee
{
idEmployee = data.idEmployee,
FirstName = data.FirstName,
LastName = data.LastName,
UserName = data.FirstName + " " + data.LastName
}).ToList();
return(oEmployeelist);
}
public string GetDistrictRestriction(int userID, string appName)
{
PurolatorReportingSQLDataContext prContext = new PurolatorReportingSQLDataContext();
clsDistrictRestriction oDist = (from data in prContext.GetTable <tblPI_ApplicationDistrictRestriction>()
join users in prContext.GetTable <tblPI_ApplicationUser>() on data.idPI_ApplicationUser equals users.idPI_ApplicationUser
join app in prContext.GetTable <tblPI_Application>() on users.idPI_Application equals app.idPI_Application
join emp in prContext.GetTable <tblEmployee>() on users.idEmployee equals emp.idEmployee
where app.ApplicationName == appName
where data.idPI_ApplicationUser == userID
orderby data.District
select new clsDistrictRestriction
{
District = data.District
}).FirstOrDefault();
return(oDist.District);
}
public List <ClsAppUsers> GetListClsAppUsers(int idPIApplication)
{
PurolatorReportingSQLDataContext prContext = new PurolatorReportingSQLDataContext();
List <ClsAppUsers> oAppUserlist = (from data in prContext.GetTable <vw_PI_ApplicationUser>()
where data.idPI_Application == idPIApplication
orderby data.UserName
select new ClsAppUsers
{
UserName = data.UserName,
ActiveDirectoryName = data.ActiveDirectoryName,
idPI_ApplicationUserRole = data.idPI_ApplicationUserRole,
idPI_ApplicationUser = data.idPI_ApplicationUser,
RoleName = data.RoleName,
role_UpdatedBy = data.role_UpdatedBy,
role_UpdatedOn = data.role_UpdatedOn,
idEmployee = data.idEmployee,
idPI_ApplicationRole = data.idPI_ApplicationRole
}).ToList();
return(oAppUserlist);
}
public ClsAppUsers GetAppUser(Int32 idApplicationUser)
{
PurolatorReportingSQLDataContext prContext = new PurolatorReportingSQLDataContext();
ClsAppUsers oAppUser = (from data in prContext.GetTable <vw_PI_ApplicationUser>()
where data.idPI_ApplicationUser == idApplicationUser
select new ClsAppUsers
{
UserName = data.UserName,
ActiveDirectoryName = data.ActiveDirectoryName,
idPI_ApplicationUserRole = data.idPI_ApplicationUserRole,
idPI_ApplicationUser = data.idPI_ApplicationUser,
RoleName = data.RoleName,
role_UpdatedBy = data.role_UpdatedBy,
role_UpdatedOn = data.role_UpdatedOn,
idEmployee = data.idEmployee,
idPI_ApplicationRole = data.idPI_ApplicationRole
}).FirstOrDefault();
return(oAppUser);
}
