public List <SearchLoggedInUserInfoResultVM> GetLoggedInUserInfo(SearchLoggedInUserInfoParametersVM model)
{
SqlParameter[] parameters =
{
new SqlParameter {
ParameterName = "@UserRoleId", Value = model.UserRoleId
},
new SqlParameter {
ParameterName = "@CollegeGroupId", Value = model.CollegeGroupId
},
new SqlParameter {
ParameterName = "@TutorId", Value = model.TutorId
},
new SqlParameter {
ParameterName = "@Name", Value = model.Name
},
new SqlParameter {
ParameterName = "@Email", Value = model.Email
}
};
var dt = DALHelper.GetDataTableWithExtendedTimeOut("GetLoggedInUserInfo", parameters);
var users = new List <SearchLoggedInUserInfoResultVM>();
users = DALHelper.CreateListFromTable <SearchLoggedInUserInfoResultVM>(dt);
return(users);
}
public List <SearchLoggedInUserInfoResultVM> SearchLoggedInUserInfo(SearchLoggedInUserInfoParametersVM model, string sortColumn, string sortDirection)
{
SqlParameter[] parameters =
{
new SqlParameter {
ParameterName = "@UserRoleId ", Value = model.UserRoleId
},
new SqlParameter {
ParameterName = "@CollegeGroupId", Value = model.CollegeGroupId
},
new SqlParameter {
ParameterName = "@TutorId", Value = model.TutorId
},
new SqlParameter {
ParameterName = "@Name", Value = model.Name
},
new SqlParameter {
ParameterName = "@Email", Value = model.Email
},
new SqlParameter {
ParameterName = "@IsViewAll", Value = model.IsViewAll
},
new SqlParameter {
ParameterName = "@PageNum", Value = model.PageNum
},
new SqlParameter {
ParameterName = "@PageSize", Value = model.PageSize
},
new SqlParameter {
ParameterName = "@SortColumn", Value = sortColumn
},
new SqlParameter {
ParameterName = "@SortDirection", Value = sortDirection
}
};
var dt = DALHelper.GetDataTableWithExtendedTimeOut("SearchLoggedInUserInfo", parameters);
var users = new List <SearchLoggedInUserInfoResultVM>();
users = DALHelper.CreateListFromTable <SearchLoggedInUserInfoResultVM>(dt);
return(users);
}
public ActionResult LoggedInUserInfo(SearchLoggedInUserInfoParametersVM model)
{
try
{
object sortColumn = "";
object sortDirection = "";
if (model.order.Count == 0)
{
sortColumn = "LastLoggedOn";
sortDirection = "desc";
}
else
{
sortColumn = model.columns[Convert.ToInt32(model.order[0].column)].data ?? (object)DBNull.Value;
sortDirection = model.order[0].dir ?? (object)DBNull.Value;
}
model.PageSize = Constants.PAGESIZE;
if (LogInManager.HasRights("TUTOR"))
{
model.TutorId = LogInManager.LoggedInUser.Id;
var userRoles = userRoleRepository.GetUserRoles();
var studentRoleId = userRoles.Where(m => m.Code == "STUDENT").FirstOrDefault().Id;
model.UserRoleId = studentRoleId;
}
var users = userRepository.SearchLoggedInUserInfo(model, Convert.ToString(sortColumn), Convert.ToString(sortDirection));
int totalRecords = 0;
var dbRecords = users.Select(m => m.TotalCount).FirstOrDefault();
if (dbRecords != 0)
{
totalRecords = Convert.ToInt32(dbRecords);
}
//Get Total Users (student)
var loggedInUsers = userRepository.GetLoggedInUserInfo(model);
int totalUsers = 0;
var dbTotalUsers = loggedInUsers.Count;
if (dbTotalUsers != 0)
{
totalUsers = Convert.ToInt32(dbTotalUsers);
}
return(Json(new
{
IsSuccess = true,
CurrentPage = model.PageNum,
PageSize = Constants.PAGESIZE,
TotalRecords = totalRecords,
TotalUsers = totalUsers,
data = users
}, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
Utility.Utility.LogError(e, "LoggedInUserInfo");
return(Json(new { IsSuccess = false, errorMessage = e.Message }));
}
}
