public JsonResult LoadThongTinCaNhanDDL(string searchTerm, int pageSize, int pageNumber)
{
var thongTinCaNhanService = this.Service <IThongTinCaNhanService>();
var select2pagedResult = new Select2PagedResult();
#region GetData
string cacheKey = "Select2Options";
var listThongTinCaNhan = new List <Select2OptionModel>();
//check cache
if (System.Web.HttpContext.Current.Cache[cacheKey] != null)
{
listThongTinCaNhan = (List <Select2OptionModel>)System.Web.HttpContext.Current.Cache[cacheKey];
}
else
{
listThongTinCaNhan = thongTinCaNhanService.GetActive()
.AsEnumerable()
.Select(q => new Select2OptionModel()
{
id = q.Id.ToString(),
text = q.HoTen + " - " + Utils.FormatDate(q.NgaySinh),
})
.ToList();
//cache results
System.Web.HttpContext.Current.Cache[cacheKey] = listThongTinCaNhan;
}
#endregion
var totalSearchRecords = listThongTinCaNhan.Count;
select2pagedResult.Results = listThongTinCaNhan.Where(q => string.IsNullOrEmpty(searchTerm) ||
q.text.ToLower().Contains(searchTerm.ToLower()));
select2pagedResult.Total = select2pagedResult.Results.Count();
select2pagedResult.Results = select2pagedResult.Results.Skip((pageNumber - 1) * pageSize)
.Take(pageSize);
return(Json(select2pagedResult, JsonRequestBehavior.AllowGet));
}
public ActionResult AirportSearch(string searchTerm, int pageSize, int pageNum)
{
var ca_o = HttpRuntime.Cache["airports-data"];
var sel_o = new Select2Result[] { new Select2Result {
id = "", text = "none"
} };
Suggest sg = new Suggest();
Select2PagedResult aps_o = new Select2PagedResult
{
Total = 1,
Results = sel_o
};
try
{
if (ca_o != null)
{
Airports[] all_airports = (Airports[])ca_o;
aps_o.Results = sg.Airports(searchTerm, all_airports);
}
} catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
return(new JsonResult
{
Data = aps_o,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult SearchByTypeName(string searchTerm, int pageSize, int pageNum)
{
//Get the paged results and the total count of the results for this query.
_productFacade = new ProductFacade();
List <TypeEntity> types = _productFacade.GetTypeByName(searchTerm, pageSize, pageNum);
int typesCount = _productFacade.GetTypeCountByName(searchTerm, pageSize, pageNum);
//Translate the attendees into a format the select2 dropdown expects
//Select2PagedResult pagedBranches = TypeToSelect2Format(types, typesCount);
Select2PagedResult pagedBranches = new Select2PagedResult();
pagedBranches.Results = new List <Select2Result>();
foreach (TypeEntity type in types)
{
pagedBranches.Results.Add(new Select2Result {
id = type.TypeId, text = type.TypeName
});
}
pagedBranches.Total = typesCount;
//Return the data as a jsonp result
return(Json(pagedBranches, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> GetAdministrators(string q, int i)
{
int _skip = i == 1 ? 0 : (i - 1) * 20;
var _query = from a in db.Administrators
where a.IsDataActive && a.Name.Contains(q)
orderby a.Name
select new
{
a.ID,
a.Name,
};
Select2PagedResult _result = new Select2PagedResult
{
Total = await _query.OrderBy(t => t.Name).CountAsync(),
Results = (await _query.OrderBy(t => t.Name).Skip(_skip).Take(20).ToListAsync()).Select(r => new Select2Item
{
id = r.ID,
text = r.Name
}).ToList()
};
return(Json(_result, JsonRequestBehavior.AllowGet));
}
public JsonResult SearchBySubAreaName(string searchTerm, int pageSize, int pageNum, int?areaId)
{
//Get the paged results and the total count of the results for this query.
_productFacade = new ProductFacade();
List <SubAreaEntity> subareas = _productFacade.GetSubAreaByName(searchTerm, pageSize, pageNum, areaId);
int subareasCount = _productFacade.GetSubAreaCountByName(searchTerm, pageSize, pageNum, areaId);
//Translate the attendees into a format the select2 dropdown expects
//Select2PagedResult pagedBranches = SubAreaToSelect2Format(subareas, subareasCount);
Select2PagedResult pagedBranches = new Select2PagedResult();
pagedBranches.Results = new List <Select2Result>();
foreach (SubAreaEntity subarea in subareas)
{
pagedBranches.Results.Add(new Select2Result {
id = subarea.SubareaId, text = subarea.SubareaName
});
}
pagedBranches.Total = subareasCount;
//Return the data as a jsonp result
return(Json(pagedBranches, JsonRequestBehavior.AllowGet));
}
public Select2PagedResult GetData(string searchTerm, int pageSize, int pageNumber)
{
Select2PagedResult dataResult = new Select2PagedResult();
IEnumerable <Vendor> data;
if (searchTerm != null)
{
data = repo.Get(x => x.Code.Contains(searchTerm) || x.Name.Contains(searchTerm), null, "");
}
else
{
data = repo.Get(x => true, null, "");
}
dataResult.Total = data.Count();
data = data.Skip(pageSize * pageNumber).Take(pageSize);
dataResult.Results = data.Select(x => new Select2OptionModel()
{
id = x.Id.ToString(),
text = x.Name + " (" + x.Code + ")"
}).ToList();
return(dataResult);
}
public async Task <IActionResult> GetCities(string searchTerm, int pageSize, int pageNum)
{
Select2PagedResult PagedCity = new Select2PagedResult();
try
{
pageNum = pageNum == 0 ? 1 : pageNum;
var offset = (pageSize * pageNum) - pageSize;
var accounts = CommonContext.Cities.AsQueryable();
accounts = accounts
.Where(s => s.Name.ToLower().Contains(searchTerm.ToLower()))
.OrderBy(s => s.StateCode).ThenBy(n => n.Name);
List <City> citiess = await accounts.Skip(offset).Take(pageSize).ToListAsync();
var totalQueryCount = await accounts.CountAsync();
PagedCity = CitiesToSelect2Format(citiess, totalQueryCount);
}
catch (Exception ex)
{
throw ex;
}
return(Json(PagedCity));
}
public JsonResult SearchByBranchName(string searchTerm, int pageSize, int pageNum)
{
//Get the paged results and the total count of the results for this query.
_commonFacade = new CommonFacade();
List <BranchEntity> branches = _commonFacade.GetBranchesByName(searchTerm, pageSize, pageNum);
int branchCount = _commonFacade.GetBranchCountByName(searchTerm, pageSize, pageNum);
//Translate the attendees into a format the select2 dropdown expects
//Select2PagedResult pagedBranches = BranchesToSelect2Format(branches, branchCount);
Select2PagedResult pagedBranches = new Select2PagedResult();
pagedBranches.Results = new List <Select2Result>();
//Loop through our branches and translate it into a text value and an id for the select list
foreach (BranchEntity branch in branches)
{
pagedBranches.Results.Add(new Select2Result {
id = branch.BranchId, text = branch.BranchName
});
}
//Set the total count of the results from the query.
pagedBranches.Total = branchCount;
//Return the data as a jsonp result
return(Json(pagedBranches, JsonRequestBehavior.AllowGet));
}
public ActionResult _SearchKeyVisitors() //string searchTerm, int pageSize, int pageNum)
{
//var keyVisitors = KeyVisitorServices.SearchKeyVisitors(searchTerm.Trim(), pageSize, pageNum);
var pagedKeyVisitors = new Select2PagedResult(); // KeyVisitorsToSelect2Format(keyVisitors, pageSize);
return(new JsonResult
{
Data = pagedKeyVisitors,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult SelectMnn(string searchTerm, int pageSize, int pageNum)
{
var founder = new ExternalRepository().SearchMnn(searchTerm);
Select2PagedResult pagedAttendees = AttendeesToSelect2Format(founder, founder.Count);
return(new JsonpResult
{
Data = pagedAttendees,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult GetCountryList(string searchTerm, int pageSize, int pageNumber)
{
AllItemsList = AllCountryLists();
var select2pagedResult = new Select2PagedResult();
var totalResults = 0;
select2pagedResult.Results = GetPagedListOptions(searchTerm, pageSize, pageNumber, out totalResults);
select2pagedResult.Total = totalResults;
var result = select2pagedResult;
return(Json(result, JsonRequestBehavior.AllowGet));
}
public async Task <Select2PagedResult> GetUsersSelect2(string searchTerm, int pageSize, int pageNumber)
{
var users = !string.IsNullOrEmpty(searchTerm) ? await _unitOfWork.Repository.FindAsync(n => n.IsDeleted != true && n.UserName.ToLower().Contains(searchTerm.ToLower())) : await _unitOfWork.Repository.FindAsync(q => q.IsDeleted != true);
var result = users.OrderBy(q => q.Id).Skip((pageNumber - 1) * pageSize).Take(pageSize).Select(q => new Select2OptionModel {
id = q.Id.ToString(), text = q.UserName
}).ToList();
var select2pagedResult = new Select2PagedResult();
select2pagedResult.Total = users.Count();
select2pagedResult.Results = result;
return(select2pagedResult);
}
public async Task <Select2PagedResult> GetChildScreensSelect2(string searchTerm, int pageSize, int pageNumber, string parentId, string lang)
{
var entityData = !string.IsNullOrEmpty(searchTerm) ? await _unitOfWork.Repository.FindAsync(n => !(n.IsStop ?? false) && n.ParentId == parentId && n.ScreenNameAr.ToLower().Contains(searchTerm.ToLower())) : await _unitOfWork.Repository.FindAsync(n => !(n.IsStop ?? false) && n.ParentId == parentId);
var result = entityData.OrderBy(q => q.Id).Skip((pageNumber - 1) * pageSize).Take(pageSize).Select(q => new Select2OptionModel {
id = q.Id, text = lang == "ar-EG" ? q.ScreenNameAr : q.ScreenNameEn
}).ToList();
var select2pagedResult = new Select2PagedResult();
select2pagedResult.Total = entityData.Count();
select2pagedResult.Results = result;
return(select2pagedResult);
}
public ActionResult GetEmployees(string searchTerm, int pageSize, int pageNum)
{
EmployeeRepository er = new EmployeeRepository();
List <Emp_Employee> employees = er.GetEmployees(searchTerm, pageSize, pageNum);
int employeeCount = er.GetEmployeesCount(searchTerm, pageSize, pageNum);
Select2PagedResult pageEmployees = EmployeesToSelect2Format(employees, employeeCount);
return(new JsonpResult
{
Data = pageEmployees,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
/// <summary>
/// get cities
/// </summary>
/// <param name="ctiess"></param>
/// <param name="totalQueryCount"></param>
/// <returns></returns>
private Select2PagedResult CitiesToSelect2Format(List <City> ctiess, int totalQueryCount)
{
Select2PagedResult jsonCities = new Select2PagedResult();
var citites = ctiess.Select(a => new SelectListItem {
Text = a.Name + " (" + a.StateCode + " )", Value = a.Id.ToString()
});
jsonCities.Results.AddRange(citites);
//Set the total count of the results from the query.
jsonCities.Total = totalQueryCount;
return(jsonCities);
}
public ActionResult GetStudents(short deptId, string searchTerm, int pageSize, int pageNum)
{
StudentRepository sr = new StudentRepository();
List <Acd_Student> students = sr.GetStudents(deptId, searchTerm, pageSize, pageNum);
int studentCount = sr.GetStudentsCount(deptId, searchTerm, pageSize, pageNum);
Select2PagedResult pageStudents = StudentsToSelect2Format(students, studentCount);
return(new JsonpResult
{
Data = pageStudents,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult GetRoles(string searchTerm, int pageSize, int pageNum)
{
//Get the paged results and the total count of the results for this query.
RoleRepository ur = new RoleRepository();
List <ApplicationRole> roles = ur.GetRoles(searchTerm, pageSize, pageNum);
int count = ur.GetRolesCount(searchTerm, pageSize, pageNum);
//Translate the roles into a format the select2 dropdown expects
Select2PagedResult pagedRoles = ur.ToSelect2Format(roles, count);
//Return the data as a jsonp result
return(new JsonResultHelper
{
Data = pagedRoles,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
private static Select2PagedResult AttendeesToSelect2Format(IEnumerable <TermSearch> attendees, int totalAttendees)
{
var jsonAttendees = new Select2PagedResult {
Results = new List <Select2Result>()
};
foreach (var a in attendees)
{
jsonAttendees.Results.Add(new Select2Result {
id = a.Id.ToString(CultureInfo.InvariantCulture), text = a.Term
});
}
jsonAttendees.Total = totalAttendees;
return(jsonAttendees);
}
private Select2PagedResult EmployeesToSelect2Format(List <Emp_Employee> employees, int totalEmployees)
{
Select2PagedResult jsonEmployees = new Select2PagedResult();
jsonEmployees.Results = new List <Select2Result>();
foreach (Emp_Employee e in employees)
{
jsonEmployees.Results.Add(new Select2Result {
id = e.Employee_Id.ToString(), text = e.Full_Name
});
}
jsonEmployees.Total = totalEmployees;
return(jsonEmployees);
}
public ActionResult GetAttendees(string searchTerm, int pageSize, int pageNum)
{
//Get the paged results and the total count of the results for this query.
AttendeeRepository ar = new AttendeeRepository();
List <LocationMaster> attendees = ar.GetAttendees(searchTerm, pageSize, pageNum);
int attendeeCount = ar.GetAttendeesCount(searchTerm, pageSize, pageNum);
//Translate the attendees into a format the select2 dropdown expects
Select2PagedResult pagedAttendees = AttendeesToSelect2Format(attendees, attendeeCount);
//Return the data as a jsonp result
return(new JsonpResult
{
Data = pagedAttendees,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
private Select2PagedResult StudentsToSelect2Format(List <Acd_Student> students, int totalStudents)
{
Select2PagedResult jsonStudents = new Select2PagedResult();
jsonStudents.Results = new List <Select2Result>();
foreach (Acd_Student s in students)
{
jsonStudents.Results.Add(new Select2Result {
id = s.Student_Id.ToString(), text = s.Full_Name + " " + s.Nim
});
}
jsonStudents.Total = totalStudents;
return(jsonStudents);
}
private static Select2PagedResult CountriesToSelect2Format(IEnumerable <CountryEntity> countries, int totalCountries)
{
var jsonCountries = new Select2PagedResult
{
Results = new List <Select2Result>()
};
foreach (var c in countries)
{
jsonCountries.Results.Add(new Select2Result {
id = c.CountryCode, text = c.CountryName
});
}
jsonCountries.Total = totalCountries;
return(jsonCountries);
}
public async Task <ActionResult> UserDDL(string searchTerm, int pageSize, int pageNum, int companyId)
{
int activeUserId = 2;
//List<NameAndIDModel> lst = null;
//if (string.IsNullOrEmpty(searchTerm) && pageNum == 1)
//{
// var products = await unitOfWork.ProductRepository.GetAll(whiteLabelID, excludeID: excludeID, licenseType: licenseType);
// if (includeAll)
// {
// products.Insert(0, new ProductModel { ID = 0, Title = "All" });
// }
// lst = products.Select(x => new NameAndIDModel { ID = x.ID, Name = x.SubTitle != null ? x.Title + " (" + x.SubTitle + ")" : x.Title }).ToList();
// cacheManager.ProductDDL = lst;
//}
//else
//{
// lst = cacheManager.ProductDDL as List<NameAndIDModel>;
//}
var items = await _unitOfWork.UserRepository.Get(companyId);
//Search
if (searchTerm != null)
{
searchTerm = searchTerm.Trim().ToLower();
}
if (!string.IsNullOrEmpty(searchTerm))
{
items = items.Where(s => s.FirstName.ToLower().Contains(searchTerm) || s.LastName.ToLower().Contains(searchTerm)).ToList();
}
Select2PagedResult pItems = new Select2PagedResult();
pItems.Results = items.Where(p => p.Id != activeUserId).Skip(pageSize * (pageNum - 1))
.Take(pageSize)
.Select(e => new Select2Result
{
id = e.Id.ToString(),
text = e.FirstName + " " + e.LastName,
}).ToList();
pItems.Total = items.Count();
return(Json(pItems));
}
private static Select2PagedResult CitiesToSelect2Format(IEnumerable <string> cities, int totalCities)
{
var jsonCities = new Select2PagedResult
{
Results = new List <Select2Result>()
};
foreach (var c in cities)
{
jsonCities.Results.Add(new Select2Result {
id = c, text = c
});
}
jsonCities.Total = totalCities;
return(jsonCities);
}
private static Select2PagedResult KeyVisitorsToSelect2Format(IEnumerable <KeyVisitorEntity> keyVisitors, int totalKeyVisitors)
{
var jsonKeyVisitors = new Select2PagedResult
{
Results = new List <Select2Result>()
};
foreach (var kv in keyVisitors)
{
jsonKeyVisitors.Results.Add(new Select2Result {
id = kv.KeyVisitorId.ToString(), text = kv.Name
});
}
jsonKeyVisitors.Total = totalKeyVisitors;
return(jsonKeyVisitors);
}
private static Select2PagedResult UsersToSelect2Format(IEnumerable <UserEntity> users, int totalUsers)
{
var jsonUsers = new Select2PagedResult
{
Results = new List <Select2Result>()
};
foreach (var u in users)
{
jsonUsers.Results.Add(new Select2Result {
id = u.UserId + "|" + u.Email, text = u.Email + " (" + u.FullName + ")"
});
}
jsonUsers.Total = totalUsers;
return(jsonUsers);
}
private static Select2PagedResult EventsToSelect2Format(IEnumerable <EventEntityLight> events, int totalEvents)
{
var jsonEvents = new Select2PagedResult
{
Results = new List <Select2Result>()
};
foreach (var a in events)
{
jsonEvents.Results.Add(new Select2Result {
id = a.EventId.ToString(), text = a.MasterName
});
}
jsonEvents.Total = totalEvents;
return(jsonEvents);
}
public ActionResult GetGroups(string searchTerm, int pageSize, int pageNum, string userId)
{
var userGroups = GroupManager.GetUserGroups(userId).Select(ug => ug.Id).ToList();
//Get the paged results and the total count of the results for this query.
GroupRepository gr = new GroupRepository();
List <ApplicationGroup> Groups = gr.GetGroups(searchTerm, pageSize, pageNum, userGroups);
int count = gr.GetGroupsCount(searchTerm, pageSize, pageNum, userGroups);
//Translate the Groups into a format the select2 dropdown expects
Select2PagedResult pagedGroups = gr.ToSelect2Format(Groups, count);
//Return the data as a jsonp result
return(new JsonResultHelper
{
Data = pagedGroups,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public Select2PagedResult ToSelect2Format(List <ApplicationUser> users, int totalUsers)
{
Select2PagedResult json = new Select2PagedResult();
json.Results = new List <Select2Result>();
//Loop through our users and translate it into a text value and an id for the select list
foreach (ApplicationUser m in users)
{
json.Results.Add(new Select2Result {
id = m.UserName, text = m.UserName
});
}
//Set the total count of the results from the query.
json.Total = totalUsers;
return(json);
}
private Select2PagedResult AttendeesToSelect2Format(List <LocationMaster> attendees, int totalAttendees)
{
Select2PagedResult jsonAttendees = new Select2PagedResult();
jsonAttendees.Results = new List <Select2Result>();
//Loop through our attendees and translate it into a text value and an id for the select list
foreach (LocationMaster a in attendees)
{
jsonAttendees.Results.Add(new Select2Result {
id = a.Lid.ToString(), text = a.LocationName
});
}
//Set the total count of the results from the query.
jsonAttendees.Total = totalAttendees;
return(jsonAttendees);
}
