// GET: Manager
public ActionResult Index(int?page, int?pageSize, string searchString)
{
#region "BTSS"
string role;
string user_name;
try
{
role = Session["role"].ToString();
user_name = Session["logon_user"].ToString();
string grp_id = Session["grp_id"].ToString();
ViewBag.CanView = af.CanView(grp_id, "Manager");
ViewBag.CanAdd = af.CanAdd(grp_id, "Manager");
ViewBag.CanEdit = af.CanEdit(grp_id, "Manager");
ViewBag.CanDelete = af.CanDelete(grp_id, "Manager");
if (!ViewBag.CanView)
{
return(HttpNotFound());
}
}
catch (Exception exception)
{
//session expired
string result = exception.Message.ToString();
return(HttpNotFound());
}
#endregion "BTSS"
#region "Table"
int?defaultPageSize = 10;
if (pageSize != null)
{
defaultPageSize = pageSize;
}
var managers = (from m in db.Managers select m);
if (!String.IsNullOrEmpty(searchString))
{
managers = managers.Where(r => r.PRDUserId.Contains(searchString) || r.Name.Contains(searchString));
}
#endregion "Table"
#region "Return"
return(View(managers.OrderBy(r => r.Name).ToPagedList(page ?? 1, (int)defaultPageSize)));
#endregion "Return"
}
// GET: TeamScorecard
public ActionResult Index(long?teamId, int?month, int?year)
{
#region "BTSS"
string role;
string user_name;
try
{
role = Session["role"].ToString();
user_name = Session["logon_user"].ToString();
string grp_id = Session["grp_id"].ToString();
ViewBag.CanView = af.CanView(grp_id, "Team Scorecard");
if (!ViewBag.CanView)
{
return(HttpNotFound());
}
}
catch (Exception exception)
{
//session expired
string result = exception.Message.ToString();
return(HttpNotFound());
}
#endregion "BTSS"
#region "ViewBagMonths"
if (month != null)
{
ViewBag.Months = new SelectList(db.months, "Value", "Text", month);
}
else
{
ViewBag.Months = db.months;
}
#endregion "ViewBagMonths"
#region "ViewBagYears"
if (year != null)
{
ViewBag.Years = new SelectList(db.years, "Value", "Text", year);
}
else
{
ViewBag.Years = db.years;
}
#endregion "ViewBagYears"
#region "ViewBagTeams"
switch (role)
{
case "Admin":
ViewBag.Teams = new SelectList(db.Teams, "TeamId", "TeamName");
break;
case "Manager":
case "Team Leader":
case "Department Analyst":
List <long> TeamIds = new List <long>();
foreach (OSC_Team team in db.Teams)
{
if (af.IsManaged(team.TeamId, user_name, role))
{
if (!TeamIds.Contains(team.TeamId))
{
TeamIds.Add(team.TeamId);
}
}
}
ViewBag.Teams = new SelectList(db.Teams.Where(x => TeamIds.Contains(x.TeamId) && x.IsActive), "TeamId", "TeamName");
break;
case "Staff":
long repTeamId = (long)af.GetRepresentativeByPRD(user_name).TeamId;
ViewBag.Teams = new SelectList(db.Teams.Where(t => t.TeamId == repTeamId && t.IsActive), "TeamId", "TeamName");
break;
}
#endregion "ViewBagTeams"
#region "Return"
return(View());
#endregion "Return"
}
public ActionResult Index()
{
string logon_user = Request.ServerVariables["LOGON_USER"].ToString();
logon_user = logon_user.Remove(0, logon_user.IndexOf('\\') + 1);
//logon_user = "******";
//logon_user = "******";
Session["logon_user"] = logon_user;
Session["user_id"] = "";
try
{
var s = af.GetUserInfo(logon_user);
if (s != null)
{
string user_id = af.GetUserInfo(logon_user).user_id;
string grp_id = af.GetUserAccess(user_id).grp_id;
string full_name = af.GetUserInfo(logon_user).user_first_name + " " + af.GetUserInfo(logon_user).user_last_name;
string role = "";
Session["user_full_name"] = full_name;
Session["user_id"] = user_id;
Session["grp_id"] = grp_id;
if (af.IsAdmin(grp_id))
{
role = "Admin";
Session["role"] = role;
}
else
{
if (af.IsManager(grp_id))
{
Session["role"] = "Manager";
}
if (af.IsTeamLeader(grp_id))
{
Session["role"] = "Team Leader";
}
if (af.IsDepAnalyst(grp_id))
{
Session["role"] = "Department Analyst";
}
if (af.IsStaff(grp_id))
{
Session["role"] = "Staff";
}
Session["Maintenance"] = af.CanView(grp_id, "Maintenance");
Session["Department"] = af.CanView(grp_id, "Department");
Session["Team"] = af.CanView(grp_id, "Team");
Session["Representative"] = af.CanView(grp_id, "Representative");
Session["Manager"] = af.CanView(grp_id, "Manager");
Session["ActivityTracker"] = af.CanView(grp_id, "Activity Tracker");
Session["NPTTracker"] = af.CanView(grp_id, "NPT Tracker");
Session["ManualEntry"] = af.CanView(grp_id, "Manual Entries");
Session["Import"] = af.CanView(grp_id, "Import Data");
Session["Scorecard"] = af.CanView(grp_id, "Scorecards");
Session["IndividualScorecard"] = af.CanView(grp_id, "Individual Scorecard");
Session["TeamScorecard"] = af.CanView(grp_id, "Team Scorecard");
}
}
ViewBag.UserInfo = s;
return(View());
}
catch (Exception ex)
{
ViewBag.Error = ex.Message.ToString();
return(View("~/Views/Shared/UnableToAccess.cshtml"));
}
}
// GET: Department
public ActionResult Index(int?page, int?pageSize, string searchString)
{
#region "BTSS"
string role;
string user_name;
try
{
role = Session["role"].ToString();
user_name = Session["logon_user"].ToString();
string grp_id = Session["grp_id"].ToString();
ViewBag.CanView = af.CanView(grp_id, "Department");
ViewBag.CanAdd = af.CanAdd(grp_id, "Department");
ViewBag.CanEdit = af.CanEdit(grp_id, "Department");
ViewBag.CanDelete = af.CanDelete(grp_id, "Department");
if (!ViewBag.CanView)
{
return(HttpNotFound());
}
}
catch (Exception exception)
{
//session expired
string result = exception.Message.ToString();
return(HttpNotFound());
}
var departments = from d in db.Departments
select d;
switch (role)
{
case "Manager":
List <long> depIds = new List <long>();
OSC_Manager mgr = db.Managers.Where(t => t.PRDUserId == user_name).FirstOrDefault();
if (mgr == null)
{
departments = (from d in db.Departments
where d.DepartmentId == 0
select d);;
}
else
{
foreach (OSC_ManageGroup obj in db.ManageGroups.Where(t => t.ManagerId == mgr.ManagerId))
{
if (obj.Type == "DEPT")
{
depIds.Add(obj.EntityId);
}
}
departments = (from d in db.Departments
where depIds.Contains(d.DepartmentId) && d.IsActive
select d);
}
break;
case "Team Leader":
case "Department Analyst":
case "Staff":
departments = (from d in db.Departments
where d.DepartmentId == 0
select d);
break;
}
#endregion "BTSS"
#region "Table"
int?defaultPageSize = 10;
if (pageSize != null)
{
defaultPageSize = pageSize;
}
if (!String.IsNullOrEmpty(searchString))
{
departments = departments.Where(d => d.DepartmentName.Contains(searchString));
}
#endregion "Table"
#region "Return"
return(View(departments.OrderBy(d => d.DepartmentName).ToPagedList(page ?? 1, (int)defaultPageSize)));
#endregion "Return"
}
// GET: Representative
public ActionResult Index(int?page, int?pageSize, string searchByRep, string searchByTeam, string searchByRole, string searchByLocation)
{
#region "InitializeRepresentatives"
af.InitializeRepresentatives(db);
#endregion "InitializeRepresentatives"
#region "BTSS"
string role;
string user_name;
try
{
role = Session["role"].ToString();
user_name = Session["logon_user"].ToString();
string grp_id = Session["grp_id"].ToString();
ViewBag.CanView = af.CanView(grp_id, "Representative");
ViewBag.CanAdd = af.CanAdd(grp_id, "Representative");
ViewBag.CanEdit = af.CanEdit(grp_id, "Representative");
ViewBag.CanDelete = af.CanDelete(grp_id, "Representative");
if (!ViewBag.CanView)
{
return(HttpNotFound());
}
}
catch (Exception exception)
{
//session expired
string result = exception.Message.ToString();
return(HttpNotFound());
}
var reps = (from r in db.Representatives
select r);
List <long> TeamIds = new List <long>();
switch (role)
{
case "Manager":
case "Team Leader":
case "Department Analyst":
foreach (OSC_Representative obj in reps)
{
if (af.IsManaged(obj.TeamId, user_name, role))
{
if (!TeamIds.Contains((long)obj.TeamId))
{
TeamIds.Add((long)obj.TeamId);
}
}
}
reps = (from r in db.Representatives
where TeamIds.Contains((long)r.TeamId) && r.IsActive == true
select r);
break;
case "Staff":
OSC_Representative oSC_Representative = af.GetRepresentativeByPRD(user_name);
long repId;
repId = 0;
if (oSC_Representative != null)
{
repId = oSC_Representative.RepId;
}
reps = reps.Where(r => r.RepId == repId && r.IsActive);
break;
}
#endregion "BTSS"
#region "Table"
int?defaultPageSize = 10;
if (pageSize != null)
{
defaultPageSize = pageSize;
}
if (searchByRep != null || searchByTeam != null || searchByRole != null || searchByLocation != null)
{
//Session["RepFilter"] = true;
List <long> TeamIdResult = new List <long>();
TeamIdResult = null;
if (!String.IsNullOrEmpty(searchByTeam))
{
TeamIdResult = (from list in db.Teams where list.TeamName == searchByTeam select list.TeamId).ToList();
if (role != "Admin")
{
TeamIdResult = (from list in db.Teams where list.TeamName == searchByTeam && list.IsActive select list.TeamId).ToList();
}
}
List <int> RoleIdResult = new List <int>();
RoleIdResult = null;
if (!String.IsNullOrEmpty(searchByRole))
{
RoleIdResult = (from list in db.CoreRoles where list.CoreRole == searchByRole select list.CoreRoleId).ToList();
}
List <int> LocationIdResult = new List <int>();
LocationIdResult = null;
if (!String.IsNullOrEmpty(searchByLocation))
{
LocationIdResult = (from list in db.Locations where list.Location == searchByLocation select list.LocationId).ToList();
}
if (searchByRep != "")
{
reps = reps.Where(t => t.FirstName + " " + t.LastName == searchByRep);
}
if (searchByTeam != "")
{
reps = reps.Where(t => TeamIdResult.Contains((long)t.TeamId));
}
if (searchByRole != "")
{
reps = reps.Where(t => RoleIdResult.Contains((int)t.CoreRoleId));
}
if (searchByLocation != "")
{
reps = reps.Where(t => LocationIdResult.Contains((int)t.LocationId));
}
if (role != "Admin")
{
reps = reps.Where(t => t.IsActive);
}
}
#endregion "Table"
#region "ViewBagFilters"
if (searchByRep != null)
{
//Session["RepFilter_Rep"] = searchByRep;
ViewBag.Representative = searchByRep;
}
else
{
//Session["RepFilter_Rep"] = "";
ViewBag.Representative = "";
}
if (searchByTeam != null)
{
//Session["RepFilter_Team"] = searchByTeam;
ViewBag.Team = searchByTeam;
}
else
{
//Session["RepFilter_Team"] = "";
ViewBag.Team = "";
}
if (searchByRole != null)
{
//Session["RepFilter_Role"] = searchByRole;
ViewBag.CoreRole = searchByRole;
}
else
{
//Session["RepFilter_Role"] = "";
ViewBag.CoreRole = "";
}
if (searchByLocation != null)
{
//Session["RepFilter_Location"] = searchByLocation;
ViewBag.Location = searchByLocation;
}
else
{
//Session["RepFilter_Location"] = "";
ViewBag.Location = "";
}
#endregion "ViewBagFilters"
#region "Return"
return(View(reps.OrderBy(r => r.TeamId).ThenBy(r => r.FirstName).ToPagedList(page ?? 1, (int)defaultPageSize)));
#endregion "Return"
}
// GET: ActivityTracker
public ActionResult Index(int?page, int?pageSize, string searchByActivity, string searchByTeam, string searchByRep, string searchByDateFrom, string searchByDateTo)
{
#region "Initialize"
af.InitializeActivities(db);
#endregion "Initialize"
#region "BTSS"
string role;
string user_name;
try
{
role = Session["role"].ToString();
user_name = Session["logon_user"].ToString();
string grp_id = Session["grp_id"].ToString();
ViewBag.CanView = af.CanView(grp_id, "Activity Tracker");
ViewBag.CanAdd = af.CanAdd(grp_id, "Activity Tracker");
ViewBag.CanEdit = af.CanEdit(grp_id, "Activity Tracker");
ViewBag.CanDelete = af.CanDelete(grp_id, "Activity Tracker");
if (!ViewBag.CanView)
{
return(HttpNotFound());
}
}
catch (Exception exception)
{
//session expired
string result = exception.Message.ToString();
return(HttpNotFound());
}
var acts = (from a in db.ActivityTrackers
where a.Activity != "Attendance"
select a);
List <long> TeamIds = new List <long>();
switch (role)
{
case "Manager":
case "Team Leader":
case "Department Analyst":
foreach (OSC_ActivityTracker obj in acts)
{
if (af.IsManaged(obj.TeamId, user_name, role))
{
if (!TeamIds.Contains(obj.TeamId))
{
TeamIds.Add(obj.TeamId);
}
}
}
acts = (from a in db.ActivityTrackers
where a.Activity != "Attendance" && TeamIds.Contains(a.TeamId) && a.IsActive
select a);
break;
case "Staff":
OSC_Representative oSC_Representative = af.GetRepresentativeByPRD(user_name);
long repId;
repId = 0;
if (oSC_Representative != null)
{
repId = oSC_Representative.RepId;
}
acts = acts.Where(a => a.RepId == repId && a.IsActive);
break;
}
#endregion "BTSS"
#region "Table"
int?defaultPageSize = 10;
if (pageSize != null)
{
defaultPageSize = pageSize;
}
if (searchByActivity != null || searchByTeam != null || searchByRep != null || searchByDateFrom != null || searchByDateTo != null)
{
Session["ActivityFilter"] = true;
List <long> TeamIdResult = new List <long>();
TeamIdResult = null;
if (!String.IsNullOrEmpty(searchByTeam))
{
TeamIdResult = (from list in db.Teams where list.TeamName == searchByTeam select list.TeamId).ToList();
if (role != "Admin")
{
TeamIdResult = (from list in db.Teams where list.TeamName == searchByTeam && list.IsActive select list.TeamId).ToList();
}
}
List <long> RepIdResult = new List <long>();
if (!String.IsNullOrEmpty(searchByRep))
{
RepIdResult = (from list in db.Representatives where list.FirstName + " " + list.LastName == searchByRep select list.RepId).ToList();
if (role != "Admin")
{
RepIdResult = (from list in db.Representatives where (list.FirstName + " " + list.LastName == searchByRep) && list.IsActive select list.RepId).ToList();
}
}
if (searchByActivity != "")
{
acts = acts.Where(t => t.Activity == searchByActivity);
}
if (searchByTeam != "")
{
acts = acts.Where(t => TeamIdResult.Contains((long)t.TeamId));
}
if (searchByRep != "")
{
acts = acts.Where(t => RepIdResult.Contains((long)t.RepId));
}
if (searchByDateFrom != "")
{
var dt = Convert.ToDateTime(searchByDateFrom);
acts = acts.Where(t => dt == t.DateFrom);
}
if (searchByDateTo != "")
{
var dt = Convert.ToDateTime(searchByDateTo);
acts = acts.Where(t => dt == t.DateTo);
}
if (role != "Admin")
{
acts = acts.Where(t => t.IsActive);
}
}
#endregion "Table"
#region "ViewBagFilters"
if (searchByActivity != null)
{
Session["ActivityFilter_Activity"] = searchByActivity;
ViewBag.Activity = searchByActivity;
}
else
{
Session["ActivityFilter_Activity"] = "";
ViewBag.Activity = "";
}
if (searchByTeam != null)
{
Session["ActivityFilter_Team"] = searchByTeam;
ViewBag.Team = searchByTeam;
}
else
{
Session["ActivityFilter_Team"] = "";
ViewBag.Team = "";
}
if (searchByRep != null)
{
Session["ActivityFilter_Rep"] = searchByRep;
ViewBag.Representative = searchByRep;
}
else
{
Session["ActivityFilter_Rep"] = "";
ViewBag.Representative = "";
}
if (searchByDateFrom != null)
{
Session["ActivityFilter_DateFrom"] = searchByDateFrom;
ViewBag.DateFrom = searchByDateFrom;
}
else
{
Session["ActivityFilter_DateFrom"] = "";
ViewBag.DateFrom = "";
}
if (searchByDateTo != null)
{
Session["ActivityFilter_DateTo"] = searchByDateTo;
ViewBag.DateTo = searchByDateTo;
}
else
{
Session["ActivityFilter_DateTo"] = "";
ViewBag.DateTo = "";
}
#endregion "ViewBagFilters"
#region "Return"
return(View(acts.OrderByDescending(a => a.Year).ThenByDescending(a => a.Month).ThenByDescending(a => a.TeamId).ToPagedList(page ?? 1, (int)defaultPageSize)));
#endregion "Return"
}
// GET: Team
public ActionResult Index(int?page, int?pageSize, string searchString)
{
#region "Initialize"
af.InitializeTeams(db);
#endregion "Initialize"
#region "BTSS"
string role;
string user_name;
try
{
role = Session["role"].ToString();
user_name = Session["logon_user"].ToString();
string grp_id = Session["grp_id"].ToString();
ViewBag.CanView = af.CanView(grp_id, "Team");
ViewBag.CanAdd = af.CanAdd(grp_id, "Team");
ViewBag.CanEdit = af.CanEdit(grp_id, "Team");
ViewBag.CanDelete = af.CanDelete(grp_id, "Team");
if (!ViewBag.CanView)
{
return(HttpNotFound());
}
}
catch (Exception exception)
{
//session expired
string result = exception.Message.ToString();
return(HttpNotFound());
}
var teams = (from t in db.Teams
select t);
List <long> TeamIds = new List <long>();
switch (role)
{
case "Manager":
case "Team Leader":
case "Department Analyst":
case "Staff":
foreach (OSC_Team obj in teams)
{
if (af.IsManaged(obj.TeamId, user_name, role))
{
if (!TeamIds.Contains(obj.TeamId))
{
TeamIds.Add(obj.TeamId);
}
}
}
teams = (from t in db.Teams
where TeamIds.Contains(t.TeamId) && t.IsActive
select t);
break;
}
#endregion "BTSS"
#region "Table"
int?defaultPageSize = 10;
if (pageSize != null)
{
defaultPageSize = pageSize;
}
if (!String.IsNullOrEmpty(searchString))
{
teams = teams.Where(t => t.TeamName.Contains(searchString));
}
#endregion "Table"
#region "Return"
return(View(teams.OrderBy(t => t.DepartmentId).ThenBy(t => t.TeamName).ToPagedList(page ?? 1, (int)defaultPageSize)));
#endregion "Return"
}
// GET: ManualEntry
public ActionResult Index(int?page, int?pageSize, string searchString)
{
#region "Initialize"
af.InitializeManualEntries(db);
#endregion "Initialize"
#region "BTSS"
string role;
string user_name;
try
{
role = Session["role"].ToString();
user_name = Session["logon_user"].ToString();
string grp_id = Session["grp_id"].ToString();
ViewBag.CanView = af.CanView(grp_id, "Manual Entries");
ViewBag.CanAdd = af.CanAdd(grp_id, "Manual Entries");
ViewBag.CanEdit = af.CanEdit(grp_id, "Manual Entries");
ViewBag.CanDelete = af.CanDelete(grp_id, "Manual Entries");
if (!ViewBag.CanView)
{
return(HttpNotFound());
}
}
catch (Exception exception)
{
//session expired
string result = exception.Message.ToString();
return(HttpNotFound());
}
var mes = (from m in db.ManualEntries
select m);
List <long> TeamIds = new List <long>();
switch (role)
{
case "Manager":
case "Team Leader":
case "Department Analyst":
foreach (OSC_ManualEntry obj in mes)
{
if (af.IsManaged(obj.TeamId, user_name, role))
{
if (!TeamIds.Contains((long)obj.TeamId))
{
TeamIds.Add((long)obj.TeamId);
}
}
}
mes = (from m in db.ManualEntries
where TeamIds.Contains((long)m.TeamId) && m.IsActive == true
select m);
break;
case "Staff":
OSC_Representative oSC_Representative = af.GetRepresentativeByPRD(user_name);
long repId;
repId = 0;
if (oSC_Representative != null)
{
repId = oSC_Representative.RepId;
}
mes = mes.Where(m => m.RepId == repId && m.IsActive);
break;
}
#endregion "BTSS"
#region "Table"
int?defaultPageSize = 10;
if (pageSize != null)
{
defaultPageSize = pageSize;
}
if (!String.IsNullOrEmpty(searchString))
{
mes = mes.Where(m => m.MonthName.Contains(searchString) || m.Year.ToString().Contains(searchString));
}
#endregion "Table"
#region "Return"
return(View(mes.OrderByDescending(m => m.Year).ThenByDescending(m => m.Month).ThenByDescending(m => m.TeamId).ToPagedList(page ?? 1, (int)defaultPageSize)));
#endregion "Return"
}
