public ActionResult ValueList(int extendedAttributeId, DataTablesParam dataTableParam)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageCatalog))
{
return(AccessDeniedView());
}
var values = _extendedAttributeService.GetExtendedAttributeValues(extendedAttributeId);
var total = values.Count();
var result = new DataTablesData
{
iTotalRecords = total,
iTotalDisplayRecords = total,
sEcho = dataTableParam.sEcho,
aaData = values.Select(x =>
{
var model = x.ToModel();
//locales
//AddLocales(_languageService, model.Locales, (locale, languageId) =>
//{
// locale.Name = x.GetLocalized(y => y.Name, languageId, false, false);
//});
return(model);
}).Cast <object>().ToArray(),
};
return(new JsonResult
{
Data = result
});
}
public ActionResult List(DataTablesParam dataTableParam)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageUsers))
{
return(AccessDeniedView());
}
var users = _userService.GetOnlineUsers(DateTime.UtcNow.AddMinutes(-_userSettings.OnlineUserMinutes),
null, dataTableParam.PageIndex, dataTableParam.PageSize);
var total = users.Count();
var result = new DataTablesData
{
iTotalRecords = total,
iTotalDisplayRecords = total,
sEcho = dataTableParam.sEcho,
aaData = users.Select(x =>
{
return(new OnlineUserModel()
{
Id = x.Id,
UserInfo = x.IsRegistered() ? x.Email : _localizationService.GetResource("Admin.Users.Guest"),
LastIpAddress = x.LastIpAddress,
Location = _geoCountryLookup.LookupCountryName(x.LastIpAddress),
LastActivityDate = _dateTimeHelper.ConvertToUserTime(x.LastActivityDateUtc, DateTimeKind.Utc),
LastVisitedPage = x.GetAttribute <string>(SystemUserAttributeNames.LastVisitedPage)
});
}).Cast <object>().ToArray(),
};
return(new JsonResult
{
Data = result
});
}
public JsonResult GetDatosFamiliaresTable(DataTablesParam param)
{
int IdentityPersonal = SessionPersister.AccountSession.IdPersonal;
List <FamiliarDomainModel> familiares = new List <FamiliarDomainModel>();
int pageNo = 1;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
int totalCount = 0;
if (param.sSearch != null)
{
familiares = ifamiliarBusiness.GetFamiliaresById(IdentityPersonal).Where(p => p.StrNombre.Contains(param.sSearch)).ToList();
///ifamiliarBusiness.GetFamiliaresHijosById(IdentityPersonal).Where(p => p.StrNombre.Contains(param.sSearch)).ToList();
}
else
{
totalCount = ifamiliarBusiness.GetFamiliaresHijosById(IdentityPersonal).Count();
familiares = ifamiliarBusiness.GetFamiliaresById(IdentityPersonal).OrderBy(p => p.IdPersonal)
.Skip((pageNo - 1) * param.iDisplayLength).Take(param.iDisplayLength).ToList();
//ifamiliarBusiness.GetFamiliaresHijosById(IdentityPersonal).OrderBy(p => p.IdPersonal)
//.Skip((pageNo - 1) * param.iDisplayLength).Take(param.iDisplayLength).ToList();
}
return(Json(new
{
aaData = familiares,
sEcho = param.sEcho,
iTotalDisplayRecords = familiares.Count(),
iTotalRecords = familiares.Count()
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetDatosCompetenciaTiTable(DataTablesParam param)
{
int IdentityPersonal = SessionPersister.AccountSession.IdPersonal;
List <CompetenciasTiDomainModel> competencias = new List <CompetenciasTiDomainModel>();
int pageNo = 1;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
int totalCount = 0;
if (param.sSearch != null)
{
competencias = icompetenciasTiBusiness.GetCompetenciasTi(IdentityPersonal).Where(p => p.CompetenciaTiDomainModel.StrDescripcion.Contains(param.sSearch)).ToList();
}
else
{
totalCount = icompetenciasTiBusiness.GetCompetenciasTi(IdentityPersonal).Count();
competencias = icompetenciasTiBusiness.GetCompetenciasTi(IdentityPersonal).OrderBy(p => p.IdPersonal)
.Skip((pageNo - 1) * param.iDisplayLength).Take(param.iDisplayLength).ToList();
}
return(Json(new
{
aaData = competencias,
sEcho = param.sEcho,
iTotalDisplayRecords = competencias.Count(),
iTotalRecords = competencias.Count()
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCompetencias(DataTablesParam param)
{
int IdentityPersonal = SessionPersister.AccountSession.IdPersonal;
List <CompetenciasPersonalDomainModel> competenciaDM = new List <CompetenciasPersonalDomainModel>();
int pageNo = 1;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
int totalCount = 0;
if (param.sSearch != null)
{
competenciaDM = icompetenciaPersonalBusiness.GetAllCompetenciasPersonal(IdentityPersonal).Where(p => p.dteFechaRegistro.ToString().Contains(param.sSearch)).ToList();
}
else
{
totalCount = icompetenciaPersonalBusiness.GetAllCompetenciasPersonal(IdentityPersonal).Count();
competenciaDM = icompetenciaPersonalBusiness.GetAllCompetenciasPersonal(IdentityPersonal).OrderBy(p => p.dteFechaRegistro)
.Skip((pageNo - 1) * param.iDisplayLength).Take(param.iDisplayLength).ToList();
}
return(Json(new
{
aaData = competenciaDM,
sEcho = param.sEcho,
iTotalDisplayRecords = competenciaDM.Count(),
iTotalRecords = competenciaDM.Count()
}, JsonRequestBehavior.AllowGet));
}
public JsonResult LoadUserEnrolledList(DataTablesParam param, string CourseID)
{
List <VMViewCourseUser> CourseUserList = new List <VMViewCourseUser>();
DAL SQLcon = new DAL();
int pageNo = 1;
int totalCount = 0;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
totalCount = SQLcon.ViewCourseUserByCourseID(CourseID).Count();
CourseUserList = SQLcon.ViewCourseUserByCourseID(CourseID).Select(x => new VMViewCourseUser
{
EmployeeNumber = x.EmployeeNumber,
EmpName = x.EmpName,
Department = x.Department,
CompletionDate = x.CompletionDate
}).AsEnumerable().ToList();
return(Json(new
{
aaData = CourseUserList,
eEcho = param.sEcho,
iTotalDisplayRecords = totalCount,
iTotalRecords = CourseUserList.Count()
}, JsonRequestBehavior.AllowGet));
}
public ActionResult LoadCourseDetails(DataTablesParam param)
{
List <VMViewCourses> CoursesD = new List <VMViewCourses>();
DAL SQLcon = new DAL();
int pageNo = 1;
int totalCount = 0;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
totalCount = SQLcon.ViewCoursesList().Count();
CoursesD = SQLcon.ViewCoursesList().Select(x => new VMViewCourses
{
ID = x.ID,
Course = x.Course,
Description = x.Description
}).AsEnumerable().ToList();
return(Json(new
{
aaData = CoursesD,
eEcho = param.sEcho,
iTotalDisplayRecords = totalCount,
iTotalRecords = CoursesD.Count()
}, JsonRequestBehavior.AllowGet));
}
public JsonResult getTimeReg(DataTablesParam param, DateTime dFrom, DateTime dTo, int customerId, int projectId)
{
//Init and calculate variables
int pageNo = 1;
string crit = "";
if (param.sSearch != null)
{
crit = param.sSearch.ToUpper();
}
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
pdsTidRedLiveEntities db = new pdsTidRedLiveEntities();
int userId = Convert.ToInt32(Session["userId"]);
int totalRecords = 0;
int totalDisplayRecords = 0;
CTimeTrack ctt = new CTimeTrack();
List <CTimeTrack> listTT = ctt.getMyTimeTracks(param, userId, dFrom, dTo, customerId, projectId, ref totalRecords, ref totalDisplayRecords);
return(Json(new
{
aaData = listTT,
sEcho = param.sEcho,
iTotalDisplayRecords = totalDisplayRecords,
iTotalRecords = totalRecords
}, JsonRequestBehavior.AllowGet));
}
public JsonResult getProjects(DataTablesParam param, int customerID)
{
int pageNo = 1;
string crit = "";
if (param.sSearch != null)
{
crit = param.sSearch.ToUpper();
}
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
pdsTidRedLiveEntities db = new pdsTidRedLiveEntities();
int totalCount = db.project.Where(x => x.customerID == customerID).Count();
//int totalCount = db.project.Count();
List <CProject> projList = db.project.Select(x => new CProject
{
projectID = x.projectID,
customerID = x.customerID,
projectName = x.projectName,
active = x.active
}).Where(x => x.customerID == customerID).ToList();
if (crit != null && crit != "")
{
projList = projList.Where(x => x.projectName.ToUpper().Contains(crit)).ToList();
}
if (param.iSortCol_0 == 0 && param.sSortDir_0 == "asc")
{
projList = projList.OrderBy(o => o.projectName).ToList();
}
if (param.iSortCol_0 == 0 && param.sSortDir_0 == "desc")
{
projList = projList.OrderByDescending(o => o.projectName).ToList();
}
if (param.iSortCol_0 == 1 && param.sSortDir_0 == "asc")
{
projList = projList.OrderBy(o => o.active).ToList();
}
if (param.iSortCol_0 == 1 && param.sSortDir_0 == "desc")
{
projList = projList.OrderByDescending(o => o.active).ToList();
}
int countToDisplay = projList.Count();
projList = projList.Skip((pageNo - 1) * param.iDisplayLength).Take(param.iDisplayLength).ToList();
return(Json(new
{
aaData = projList,
sEcho = param.sEcho,
iTotalDisplayRecords = countToDisplay,
iTotalRecords = totalCount
}, JsonRequestBehavior.AllowGet));
}
public JsonResult LoadUserCurrentCourse(DataTablesParam param)
{
List <VMELearningCousesProgress> QuestList = new List <VMELearningCousesProgress>();
var userID = Session["EmployeeNumber"].ToString();
DAL SQLcon = new DAL();
int pageNo = 1;
int totalCount = 0;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
totalCount = SQLcon.ViewCurrentEmployeeCoursebyEmployeeNumber(userID).Count();
QuestList = SQLcon.ViewCurrentEmployeeCoursebyEmployeeNumber(userID).Select(x => new VMELearningCousesProgress
{
ID = x.ID,
EmployeeNumber = x.EmployeeNumber,
CourseID = x.CourseID,
Course = x.Course,
Progress = x.Progress,
Score = x.Score,
EnrolledDate = x.EnrolledDate,
CompletionDate = x.CompletionDate,
ConsumedTime = x.ConsumedTime
}).AsEnumerable().ToList();
return(Json(new
{
aaData = QuestList,
eEcho = param.sEcho,
iTotalDisplayRecords = totalCount,
iTotalRecords = QuestList.Count()
}, JsonRequestBehavior.AllowGet));
}
public ActionResult LoadEmployeeByCourseID(DataTablesParam param, string CourseID)
{
List <VMViewEmployeeCourseStatus> EmployeeD = new List <VMViewEmployeeCourseStatus>();
DAL SQLcon = new DAL();
int pageNo = 1;
int totalCount = 0;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
totalCount = SQLcon.ViewEmployeeCourseTakenByCourseID(CourseID).Count();
EmployeeD = SQLcon.ViewEmployeeCourseTakenByCourseID(CourseID).Select(x => new VMViewEmployeeCourseStatus
{
EmployeeNumber = x.EmployeeNumber,
EmpName = x.EmpName,
CampiagnName = x.CampiagnName,
Progress = x.Progress,
Score = x.Score
}).AsEnumerable().ToList();
return(Json(new
{
aaData = EmployeeD,
eEcho = param.sEcho,
iTotalDisplayRecords = totalCount,
iTotalRecords = EmployeeD.Count()
}, JsonRequestBehavior.AllowGet));
}
public ActionResult List(DataTablesParam dataTableParam)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageCatalog))
{
return(AccessDeniedView());
}
var extendedAttributes = _extendedAttributeService.GetAllExtendedAttributes(true);
var total = extendedAttributes.Count();
var result = new DataTablesData
{
iTotalRecords = total,
iTotalDisplayRecords = total,
sEcho = dataTableParam.sEcho,
aaData = extendedAttributes.Select(x =>
{
var caModel = x.ToModel();
caModel.AttributeControlTypeName = x.AttributeControlType.GetLocalizedEnum(_localizationService, _workContext);
return(caModel);
}).Cast <object>().ToArray(),
};
return(new JsonResult
{
Data = result
});
}
public JsonResult GetIdiomas(DataTablesParam param)
{
int IdentityPersonal = SessionPersister.AccountSession.IdPersonal;
List <IdiomaDomainModel> alergiasDM = new List <IdiomaDomainModel>();
int pageNo = 1;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
int totalCount = 0;
if (param.sSearch != null)
{
alergiasDM = IidiomaBusinnes.GetIdiomasByIdPersonal(IdentityPersonal).Where(p => p.strDescripcion.Contains(param.sSearch)).ToList();
}
else
{
totalCount = IidiomaBusinnes.GetIdiomasByIdPersonal(IdentityPersonal).Count();
alergiasDM = IidiomaBusinnes.GetIdiomasByIdPersonal(IdentityPersonal).OrderBy(p => p.strDescripcion)
.Skip((pageNo - 1) * param.iDisplayLength).Take(param.iDisplayLength).ToList();
}
return(Json(new
{
aaData = alergiasDM,
sEcho = param.sEcho,
iTotalDisplayRecords = alergiasDM.Count(),
iTotalRecords = alergiasDM.Count()
}, JsonRequestBehavior.AllowGet));
}
public IActionResult getMailArchive(DataTablesParam param)
{
int totalNo = 0, recordFilter = 0;
var obj = mailArchiveService.GetMailArchives(
param.sSearch,
param.iDisplayStart,
param.iDisplayLength,
out totalNo,
out recordFilter
).ToList();
var newObj = obj.Select(m => new {
id = m.ID,
mailId = m.MailId,
mailType = m.MailType?.MailName,
postType = m.PostType?.PostName,
// classificationType = m.Classification.ClassificationName,
insertdate = m.InsertDate.Value.ToString("dd/MM/yyy") ?? DateTime.Now.AddYears(-40).ToString("dd/MM/yyy"),
fromJehaz = m.FromJehazId?.Text,
toJehaz = m.ToJehazId?.Text,
topic = m.Topic?.ToString()
});
return(Json(new
{
data = newObj,
eEcho = param.sEcho,
iTotalDisplayRecords = recordFilter,
iTotalRecords = totalNo
}));
}
public JsonNetResult DataTables(DataTablesParam p)
{
// calculate total results to request from lucene search
int numResults = (p.iDisplayStart >= 0 && p.iDisplayLength > 0) ? (p.iDisplayStart + 1) * p.iDisplayLength : 10;
IList <LuceneSearchResult> results = this.luceneTasks.UnitSearch(p.sSearch, numResults);
int iTotalRecords = 0;
if (results != null && results.Count > 0)
{
iTotalRecords = results.First().TotalHits;
}
object[] aaData = results
.Select(x => new UnitDataTableLuceneView(x))
.Skip(p.iDisplayStart)
.Take(p.iDisplayLength)
.ToArray <UnitDataTableLuceneView>();
return(JsonNet(new DataTablesData
{
iTotalRecords = iTotalRecords,
iTotalDisplayRecords = iTotalRecords,
sEcho = p.sEcho,
aaData = aaData.ToArray()
}));
}
public DataTablesResult <RequestView> DataTables(DataTablesParam p)
{
IQueryable <Request> q = this.requestTasks.GetRequestsQueryable().Where(x => !x.Archive);
AdminUser user = this.userTasks.GetAdminUser(User.Identity.Name);
// a user with only the initiator role and none of the other screening roles can only view selected requests
if (User.IsInRole(AdminRole.ScreeningRequestInitiator) &&
!User.IsInRole(AdminRole.ScreeningRequestValidator) &&
!((PrfPrincipal)User).HasPermission(AdminPermission.CanPerformScreeningInput) &&
!User.IsInRole(AdminRole.ScreeningRequestConsolidator) &&
!User.IsInRole(AdminRole.ScreeningRequestFinalDecider) &&
user.ScreeningEntities.Count == 0) // being a member of a screening entity allows you to view any request
{
q = q.Where(x => x.UserHasPermission(user));
}
DataTablesResult <RequestView> result = DataTablesResult.Create(q.Select(x => new RequestView(x)), p, rv => new
{
// custom transform for date field - default is to transform datetimes from UTC to local time, but we store
// dates in local time (this could be rethought).
CurrentStatusDate = rv.CurrentStatusDate.ToString()
});
return(result);
}
public JsonResult GetDeportesPersonales(DataTablesParam param)
{
int IdentityPersonal = SessionPersister.AccountSession.IdPersonal;
List <DeportePersonalDomainModel> deportes = new List <DeportePersonalDomainModel>();
int pageNo = 1;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
int totalCount = 0;
if (param.sSearch != null)
{
deportes = IdeportePersonalBusiness.GetDeportesPersonalesById(IdentityPersonal).Where(p => p.Deporte.StrDescripcion.Contains(param.sSearch)).ToList();
}
else
{
totalCount = IdeportePersonalBusiness.GetDeportesPersonalesById(IdentityPersonal).Count();
deportes = IdeportePersonalBusiness.GetDeportesPersonalesById(IdentityPersonal).OrderBy(p => p.IdDeportePersonal)
.Skip((pageNo - 1) * param.iDisplayLength).Take(param.iDisplayLength).ToList();
}
return(Json(new
{
aaData = deportes,
sEcho = param.sEcho,
iTotalDisplayRecords = deportes.Count(),
iTotalRecords = deportes.Count()
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetTutorias(DataTablesParam param)
{
int IdentityPersonal = SessionPersister.AccountSession.IdPersonal;
List <TutoriasDomainModel> tutorias = new List <TutoriasDomainModel>();
int pageNo = 1;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
int totalCount = 0;
if (param.sSearch != null)
{
tutorias = tutoriasBusiness.GetAllTutoriasByIdPersonal(IdentityPersonal).Where(p => p.strNombreEstudantes.Contains(param.sSearch)).ToList();
}
else
{
totalCount = tutoriasBusiness.GetAllTutoriasByIdPersonal(IdentityPersonal).Count();
tutorias = tutoriasBusiness.GetAllTutoriasByIdPersonal(IdentityPersonal).OrderBy(p => p.strNombreEstudantes)
.Skip((pageNo - 1) * param.iDisplayLength).Take(param.iDisplayLength).ToList();
}
return(Json(new
{
aaData = tutorias,
sEcho = param.sEcho,
iTotalDisplayRecords = tutorias.Count(),
iTotalRecords = tutorias.Count()
}, JsonRequestBehavior.AllowGet));
}
public async Task <DataTablesResponseData> GetUserHistory(DataTablesParam model, int userId, int?count)
{
using (var context = DataContextFactory.CreateReadOnlyContext())
{
var query = context.Prize
.Where(p => p.IsClaimed && p.UserId == userId)
.Select(x => new
{
Id = x.Id,
GameId = x.GameId,
IsUnclaimed = x.Status == Enums.PrizeStatus.Unclaimed,
Game = x.Game.Name,
Name = x.Name,
Description = x.Description,
X = x.X,
Y = x.Y,
Points = x.Points,
Status = x.Status,
Timestamp = x.ClaimTime,
});
if (count.HasValue)
{
query = query
.OrderBy(x => x.Status)
.ThenByDescending(x => x.Timestamp)
.Take(count.Value);
}
return(await query.GetDataTableResponseAsync(model, disablePaging : count.HasValue));
}
}
public JsonResult GetEstadosDeSaludPersonal(DataTablesParam param)
{
int IdentityPersonal = SessionPersister.AccountSession.IdPersonal;
List <EstadoSaludDomainModel> enfermedades = new List <EstadoSaludDomainModel>();
int pageNo = 1;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
int totalCount = 0;
if (param.sSearch != null)
{
enfermedades = IestadoSaludBusiness.GetEnfermedadesPersonalById(1).Where(p => p.NombreEnfermedad.Contains(param.sSearch)).ToList();
}
else
{
totalCount = IestadoSaludBusiness.GetEnfermedadesPersonalById(IdentityPersonal).Count();
enfermedades = IestadoSaludBusiness.GetEnfermedadesPersonalById(IdentityPersonal).OrderBy(p => p.idEnfermedad)
.Skip((pageNo - 1) * param.iDisplayLength).Take(param.iDisplayLength).ToList();
}
return(Json(new
{
aaData = enfermedades,
sEcho = param.sEcho,
iTotalDisplayRecords = enfermedades.Count(),
iTotalRecords = enfermedades.Count()
}, JsonRequestBehavior.AllowGet));
}
public virtual int[] ExecuteParams(DataTablesParam dataTablesParam)
{
var result = new DataTablesResult <SomeModel>(SomeModelQueryable, dataTablesParam);
var data = result.Data;
return(data.aaData.Select(row => ((SomeModel)row).Id).ToArray());
}
public DataTablesResult <UserTableRowViewModel> GetUsers(DataTablesParam dataTableParam)
{
return(DataTablesResult.Create(FakeDatabase.Users.Select(user => new UserTableRowViewModel()
{
Id = user.Id,
Name = user.Name,
Email = user.Email,
Position = user.Position == null ? "" : user.Position.ToString(),
Number = user.Number,
Hired = user.Hired,
IsAdmin = user.IsAdmin,
Salary = user.Salary,
Thumb = "https://randomuser.me/api/portraits/thumb/men/" + user.Id + ".jpg"
}), dataTableParam,
rowViewModel => new
{
Name = "<b>" + rowViewModel.Name + "</b>",
Hired =
rowViewModel.Hired == null
? "<pending>"
: rowViewModel.Hired.Value.ToShortDateString() + " " +
rowViewModel.Hired.Value.ToShortTimeString() + " (" +
FriendlyDateHelper.GetPrettyDate(rowViewModel.Hired.Value) + ") ",
Thumb = "<img src='" + rowViewModel.Thumb + "' />"
}));
}
public ActionResult Resources(DataTablesParam dataTableParam, int languageId, string resourceName)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageLanguages))
{
return(AccessDeniedView());
}
// var languageId = dataTableParam.bQueryModel.Items.FirstOrDefault().Value.ToString().ToInt();
var language = _languageService.GetLanguageById(languageId);
var resources = _localizationService
.GetResourceValues(languageId, resourceName, true)
.OrderBy(x => x.Key)
.Where(x => x.Key != "!!___EOF___!!" && x.Value != null)
.ToList().AsQueryable();
if (!resourceName.IsEmpty())
{
resources = resources.Where(r => r.Key.Contains(resourceName));
}
return(DataTablesResult.Create(resources.Select(x =>
new LanguageResourceModel()
{
LanguageId = languageId,
LanguageName = language.Name,
Id = x.Value.Item1,
Name = x.Key,
Value = x.Value.Item2.EmptyNull(),
}), dataTableParam
));
}
public JsonResult GetDocumentos(DataTablesParam param)
{
int IdentityPersonal = SessionPersister.AccountSession.IdPersonal;
List <DocumentosDomainModel> documentosDM = new List <DocumentosDomainModel>();
int pageNo = 1;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
int totalCount = 0;
if (param.sSearch != null)
{
documentosDM = IdocumentosBusiness.GetDocumetosByIdPersonal(IdentityPersonal).Where(p => p.StrUrl.Contains(param.sSearch)).ToList();
}
else
{
totalCount = IdocumentosBusiness.GetDocumetosByIdPersonal(IdentityPersonal).Count();
documentosDM = IdocumentosBusiness.GetDocumetosByIdPersonal(IdentityPersonal).OrderBy(p => p.StrUrl)
.Skip((pageNo - 1) * param.iDisplayLength).Take(param.iDisplayLength).ToList();
}
return(Json(new
{
aaData = documentosDM,
sEcho = param.sEcho,
iTotalDisplayRecords = documentosDM.Count(),
iTotalRecords = documentosDM.Count()
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetExperiencias(DataTablesParam param)
{
int IdentityPersonal = SessionPersister.AccountSession.IdPersonal;
List <ExperienciaLaboralExternaDomainModel> experienciaDM = new List <ExperienciaLaboralExternaDomainModel>();
int pageNo = 1;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
int totalCount = 0;
if (param.sSearch != null)
{
experienciaDM = experienciaLaboralExterna.GetExperienciaLaboralByPersonal(IdentityPersonal).Where(p => p.strInstitucionEmpresa.Contains(param.sSearch)).ToList();
}
else
{
totalCount = experienciaLaboralExterna.GetExperienciaLaboralByPersonal(IdentityPersonal).Count();
experienciaDM = experienciaLaboralExterna.GetExperienciaLaboralByPersonal(IdentityPersonal).OrderBy(p => p.strInstitucionEmpresa)
.Skip((pageNo - 1) * param.iDisplayLength).Take(param.iDisplayLength).ToList();
}
return(Json(new
{
aaData = experienciaDM,
sEcho = param.sEcho,
iTotalDisplayRecords = experienciaDM.Count(),
iTotalRecords = experienciaDM.Count()
}, JsonRequestBehavior.AllowGet));
}
public JsonResult ShowAllOrders(DataTablesParam param)
{
ApplicationDbContext _context = new ApplicationDbContext();
List <OrderViewModel> orderList = new List <OrderViewModel>();
string userId = User.Identity.GetUserId();
int totalCount = 0;
int pageNo = 1;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
if (param.sSearch != null)
{
totalCount = _context.Orders.Include(x => x.OrderStatus).Include(x => x.user).Where(x => x.userID == userId && (x.Id.ToString().Contains(param.sSearch) || x.user.user_Name.ToLower().Contains(param.sSearch.ToLower()) || x.createAt.ToString().Contains(param.sSearch) || x.OrderStatus.statusName.ToLower().Contains(param.sSearch.ToLower()))).Count();
orderList = _context.Orders.Include(x => x.OrderStatus).Include(x => x.user)
.Where(x => x.userID == userId && (x.Id.ToString().Contains(param.sSearch) || x.user.user_Name.ToLower().Contains(param.sSearch.ToLower()) || x.createAt.ToString().Contains(param.sSearch) || x.OrderStatus.statusName.ToLower().Contains(param.sSearch.ToLower())))
.Select(x => new OrderViewModel
{
Id = x.Id,
userName = x.user.user_Name,
orderCreated = x.createAt,
orderStatud = x.OrderStatus.statusName,
totalBill = x.totalBill
})
.OrderBy(x => x.Id).Skip((pageNo - 1) * param.iDisplayLength).Take(param.iDisplayLength).ToList();
}
else
{
totalCount = _context.Orders.Where(x => x.userID == userId).Count();
orderList = _context.Orders.Include(x => x.OrderStatus).Include(x => x.user).Where(x => x.userID.Equals(userId))
.Select(x => new OrderViewModel
{
Id = x.Id,
userName = x.user.user_Name,
orderCreated = x.createAt,
orderStatud = x.OrderStatus.statusName,
totalBill = x.totalBill
}).OrderBy(x => x.Id).Skip((pageNo - 1) * param.iDisplayLength).Take(param.iDisplayLength)
.ToList();
}
return(Json(new
{
aaData = orderList,
sEcho = param.sEcho,
iTotalDisplayRecords = totalCount,
iTotalRecords = totalCount
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetDatosPersonalAsociacionTable(DataTablesParam param)
{
int IdentityPersonal = SessionPersister.AccountSession.IdPersonal;
List <PersonalAsociacionesDomainModel> personalAsociaciones = new List <PersonalAsociacionesDomainModel>();
int pageNo = 1;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
int totalCount = 0;
if (param.sSearch != null)
{
personalAsociaciones = IpersonalAsociacionesBusiness.GetPersonalAsociacinesById(IdentityPersonal).Where(p => p.StrTipoParticipacion
.Contains(param.sSearch)).ToList();
}
else
{
totalCount = IpersonalAsociacionesBusiness.GetPersonalAsociacinesById(IdentityPersonal).Count();
personalAsociaciones = IpersonalAsociacionesBusiness.GetPersonalAsociacinesById(IdentityPersonal).OrderBy(p => p.IdPersonal)
.Skip((pageNo - 1) * param.iDisplayLength).Take(param.iDisplayLength).ToList();
}
return(Json(new
{
aaData = personalAsociaciones,
sEcho = param.sEcho,
iTotalDisplayRecords = personalAsociaciones.Count(),
iTotalRecords = personalAsociaciones.Count()
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCapacitacionesRecibidas(DataTablesParam param)
{
int identityPersonal = SessionPersister.AccountSession.IdPersonal;
List <CapacitacionesRecibidasDomainModel> capacitacionesRecibidasDomainModels = new List <CapacitacionesRecibidasDomainModel>();
int pageNo = 1;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
int totalCount = 0;
if (param.sSearch != null)
{
capacitacionesRecibidasDomainModels = capacitacionesRecibidasBusiness.GetCapacitacionesRecibidas(identityPersonal).Where(p => p.strNombre.Contains(param.sSearch)).ToList();
}
else
{
totalCount = capacitacionesRecibidasBusiness.GetCapacitacionesRecibidas(identityPersonal).Count();
capacitacionesRecibidasDomainModels = capacitacionesRecibidasBusiness.GetCapacitacionesRecibidas(identityPersonal).OrderBy(p => p.strNombre).Skip((pageNo - 1)
* param.iDisplayLength).Take(param.iDisplayLength).ToList();
}
return(Json(new
{
aaData = capacitacionesRecibidasDomainModels,
sEcho = param.sEcho,
iTotalDisplayRecords = capacitacionesRecibidasDomainModels.Count(),
iTotalRecords = capacitacionesRecibidasDomainModels.Count()
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetLibros(DataTablesParam param)
{
int identityPersonal = SessionPersister.AccountSession.IdPersonal;
List <LibroDomainModel> librosDM = new List <LibroDomainModel>();
int pageNo = 1;
if (param.iDisplayStart >= param.iDisplayLength)
{
pageNo = (param.iDisplayStart / param.iDisplayLength) + 1;
}
int totalCount = 0;
if (param.sSearch != null)
{
librosDM = libroBusiness.GetLibrosByPersonal(identityPersonal).Where(p => p.strTituloLibro.Contains(param.sSearch)).ToList();
}
else
{
totalCount = libroBusiness.GetLibrosByPersonal(identityPersonal).Count();
librosDM = libroBusiness.GetLibrosByPersonal(identityPersonal).OrderBy(p => p.strTituloLibro).Skip((pageNo - 1)
* param.iDisplayLength).Take(param.iDisplayLength).ToList();
}
return(Json(new
{
aaData = librosDM,
sEcho = param.sEcho,
iTotalDisplayRecords = librosDM.Count(),
iTotalRecords = librosDM.Count()
}, JsonRequestBehavior.AllowGet));
}
public ActionResult List(DataTablesParam dataTableParam)
{
if (!_permissionService.Authorize(StandardPermissionProvider.ManageEmailAccounts))
{
return(AccessDeniedView());
}
var emailAccountModels = _emailAccountService.GetAllEmailAccounts()
.Select(x => x.ToModel())
.ToList();
foreach (var eam in emailAccountModels)
{
eam.IsDefaultEmailAccount = eam.Id == _emailAccountSettings.DefaultEmailAccountId;
}
var total = emailAccountModels.Count();
var result = new DataTablesData
{
iTotalRecords = total,
iTotalDisplayRecords = total,
sEcho = dataTableParam.sEcho,
aaData = emailAccountModels.Cast <object>().ToArray(),
};
return(new JsonResult
{
Data = result
});
}
public override int[] ExecuteParams(DataTablesParam dataTablesParam)
{
DataContext.Dispose(); //reset datacontext in order to clear local
DataContext = new SomeContext();
int[] returnVar = base.ExecuteParams(dataTablesParam);
Assert.AreEqual(returnVar.Length, DataContext.Models.Local.Count, "records loaded in memory");
return returnVar;
}
public virtual int[] ExecuteParamsAndTransform(DataTablesParam dataTablesParam)
{
var result = DataTablesResult.Create(SomeModelQueryable,
dataTablesParam,
m => new {
FriendlyWhen = m.When.ToShortDateString(),
});
var data = result.Data;
return data.aaData.Select(d=>Convert.ToInt32(((IList)d)[0])).ToArray();
}
public IDataTablesResult<UserView> GetUsers(DataTablesParam dataTableParam)
{
var users = new List<User>
(
Enumerable.Range(1, 100).Select(i => new User(){Id = i, Email = "user" + i + "@gmail.com", Name = "User" + i})
).AsQueryable();
return DataTablesResult.Create(users, dataTableParam, user => new UserView()
{
Id = user.Id,
Name = user.Name
});
}
public DataTablesResult<UserView> GetUsers(DataTablesParam dataTableParam)
{
var users = Users().AsQueryable();
return DataTablesResult.Create(users, dataTableParam, user => new UserView()
{
Id = user.Id,
Name = user.Name,
Email = user.Email,
Position = user.Position == null ? "" : user.Position.ToString(),
Hired = user.Hired
});
}
public DataTablesResult<UserView> GetUsers(DataTablesParam dataTableParam)
{
var users = Users().AsQueryable();
return DataTablesResult.Create(users, dataTableParam, user => new UserView()
{
Id = user.Id,
Name = new MvcHtmlString("<b>" + user.Name +"</b>"),
Email = user.Email,
Position = user.Position == null ? "" : user.Position.ToString(),
Number = user.Number,
Hired = user.Hired,
IsAdmin = user.IsAdmin
});
}
public DataTablesResult<UserView> GetUsers(DataTablesParam dataTableParam)
{
var users = Users().AsQueryable();
return DataTablesResult.Create(users, dataTableParam, user => new UserView()
{
Position = user.Position == null ? "" : user.Position.ToString(),
Number = user.Number,
Email = user.Email,
Name = new MvcHtmlString("<b>" + user.Name + "</b>"),
Hired = user.Hired,
someOtherInfo1 = "",
someOtherInfo2 = "",
someOtherInfo3 = string.Format("Id is {0}", user.Id)
});
}
public DataTablesResult<UserView> GetUsers(DataTablesParam dataTableParam)
{
return DataTablesResult.Create(FakeDatabase.Users.Select(user => new UserView()
{
Id = user.Id,
Name = user.Name,
Email = user.Email,
Position = user.Position == null ? "" : user.Position.ToString(),
Number = user.Number,
Hired = user.Hired,
IsAdmin = user.IsAdmin,
Salary = user.Salary
}), dataTableParam,
uv => new
{
Name = "<b>" + uv.Name + "</b>",
Hired = uv.Hired.ToShortDateString() + " (" + FriendlyDateHelper.GetPrettyDate(uv.Hired) + ") "
});
}
public DataTablesResult<UserView> GetUsers(DataTablesParam dataTableParam)
{
return DataTablesResult.Create(FakeDatabase.Users.Select(user => new UserView()
{
Id = user.Id,
Name = user.Name,
Email = user.Email,
Position = user.Position == null ? "" : user.Position.ToString(),
Number = user.Number,
Hired = user.Hired,
IsAdmin = user.IsAdmin,
Salary = user.Salary,
Thumb = "https://randomuser.me/api/portraits/thumb/men/" + user.Id + ".jpg"
}), dataTableParam,
uv => new
{
Name = "<b>" + uv.Name + "</b>",
Hired = uv.Hired == null ? "<pending>" : uv.Hired.Value.ToShortDateString() + " (" + FriendlyDateHelper.GetPrettyDate(uv.Hired.Value) + ") ",
Thumb = "<img src='" + uv.Thumb + "' />"
});
}
public void Setup()
{
queryable = new List<SomeModel>()
{
new SomeModel()
{
Category = 1,
DisplayName = "Cheddar",
Id = 123,
Scale = 123.456d,
Discounted = true,
Cost = 123
}
}.AsQueryable();
dataTablesParam = new DataTablesParam();
columns = DataTablesTypeInfo<SomeModel>.Properties.Select((p, i) =>
Tuple.Create(i, new DataTablesPropertyInfo(p.PropertyInfo, new DataTablesAttributeBase[]{}))).ToArray();
dataTablesParam.sSearchValues = new List<string>(columns.Select(c => null as string));
dataTablesParam.bSearchable = new List<bool>(columns.Select(c => true));
}
public ActionResult Index(DataTablesParam dataTableParam = null)
{
if (Request.IsAjaxRequest())
{
var cars = db.Cars.AsQueryable();
// swap out sort fields with ones DynamicLinq will handle.
var dataTableOptions = new DataTablesOptions();
dataTableOptions.SearchAliases.Add("Name", "Year");
return DataTablesResult.Create(cars, dataTableParam, dataTableOptions, oo => new
{
Name = oo.FriendlyName,
Year = oo.Year.ToString().Substring(2),
Id = oo.Id
});
}
else
{
return View();
}
}
public virtual int[] ExecuteParams(DataTablesParam dataTablesParam)
{
var result = new DataTablesResult<SomeModel>(SomeModelQueryable, dataTablesParam);
var data = result.Data;
return data.aaData.Select(row => ((SomeModel)row).Id).ToArray();
}
static DataTablesParam GetEmptyParam(int columns)
{
var returnVar = new DataTablesParam(columns);
returnVar.iDisplayLength = DefaultTestCasesLength;
returnVar.iSortingCols = 1;
returnVar.sEcho = 1;
returnVar.sSearch = "";
returnVar.bEscapeRegexColumns.AddRange(Enumerable.Repeat(false, columns));
returnVar.bSearchable.AddRange(Enumerable.Repeat(true, columns));
returnVar.bSortable.AddRange(Enumerable.Repeat(true, columns));
returnVar.iSortCol.AddRange(Enumerable.Repeat(0, columns));
returnVar.sSearchValues.AddRange(Enumerable.Repeat("", columns));
returnVar.sSortDir.AddRange(Enumerable.Repeat<string>(null, columns));
return returnVar;
}
public DataTablesResult GetUsersUntyped(DataTablesParam dataTableParam)
{
var users = Users();
return DataTablesResult.Create(users, dataTableParam);
}
