Logic used to retrieve a data
public IQueryable<visitordm> GetCheckInVisitorList(int cityId, int page)
{
// DateTime todayDate = DateTime.Today;
using (VMSDBContext context = DAL.Instance.NewDefaultDbContext())
{
var lstVistorDetails = (from objVisitors in context.Visitors
join objVisits in context.Visits on objVisitors.ID equals objVisits.Visitor_id
join objVisitorLocation in context.VisitorLocations on objVisits.Visitor_location_id equals objVisitorLocation.ID
join objEmployee in context.Employees on objVisits.Employee_to_visit equals objEmployee.ID
join objprogram in context.Programs on objEmployee.Program_id equals objprogram.ID
join objIdProof in context.IdentificationProofs on objVisits.Identification_proof_id equals objIdProof.ID
join objLocation in context.Locations.Where(objlocations => objlocations.City_id == cityId) on objVisits.Location_id equals objLocation.ID
join objVisitorPurpose in context.VisitPurposes on objVisits.Visit_purpose_id equals objVisitorPurpose.ID
where (objVisits.Office_out_time == null)
// && objVisits.Office_in_time.Value.Day == todayDate.Day
// && objVisits.Office_in_time.Value.Month == todayDate.Month
// && objVisits.Office_in_time.Value.Year == todayDate.Year)
orderby objVisits.ID descending
select new VisitorDM
{
Visit_id = objVisits.ID,
Name = objVisitors.Name,
Mobile_number = objVisitors.Mobile_number,
Visitor_location = objVisitorLocation.Name,
EmployeeName_to_visit = objEmployee.First_name + " " + objEmployee.Last_name + "(" + objEmployee.Employee_code + ")",
IdProof = objIdProof.ID_proof,
OfficeLocation = objLocation.Name,
VisitorPurpose = objVisitorPurpose.Name,
Office_in_time = objVisits.Office_in_time,
Office_in_entry_by = objVisits.Office_in_entry_by,
Office_in_system_name = objVisits.Office_in_system_name,
Office_out_time = objVisits.Office_out_time,
Office_out_entry_by = objVisits.Office_out_entry_by,
Office_out_system_name = objVisits.Office_out_system_name,
Modified_on = objVisits.Modified_on,
Modified_by = objVisits.Office_in_system_name,
ID = objVisitors.ID
}).ToList().AsQueryable();
return lstVistorDetails;
}
}
Calls this function in another function
public IQueryable<VisitorDM> GetTypeVisitorDetails(string searchText, string searchType, int cityId, int page, [Optional] string columnName, [Optional]string sortType)
{
List<VisitorDM> lstVistorDetails = new List<VisitorDM>();
using (VMSDBContext context = DAL.Instance.NewDefaultDbContext())
{
if (!string.IsNullOrEmpty(columnName) && !string.IsNullOrEmpty(sortType))
{
switch (columnName)
{
case "Visit Id":
IEnumerable<VisitorDM> CheckInVisitID = (sortType == "ASC" ?
GetCheckInVisitorList(cityId, page).OrderBy(objCheckInlist => objCheckInlist.Visit_id) :
GetCheckInVisitorList(cityId, page).OrderByDescending(objCheckInlist => objCheckInlist.Visit_id));
lstVistorDetails = CheckInVisitID.ToList();
break;
case "Office Location":
IEnumerable<VisitorDM> CheckInOfficeLocation = (sortType == "ASC" ?
GetCheckInVisitorList(cityId, page).OrderBy(objCheckInlist => objCheckInlist.OfficeLocation) :
GetCheckInVisitorList(cityId, page).OrderByDescending(objCheckInlist => objCheckInlist.OfficeLocation));
lstVistorDetails = CheckInOfficeLocation.ToList();
break;
case "Visitor Name":
IEnumerable<VisitorDM> CheckInVisitorName = (sortType == "ASC" ?
GetCheckInVisitorList(cityId, page).OrderBy(objCheckInlist => objCheckInlist.Name) :
GetCheckInVisitorList(cityId, page).OrderByDescending(objCheckInlist => objCheckInlist.Name));
lstVistorDetails = CheckInVisitorName.ToList();
break;
case "Visitor Mobile Number":
IEnumerable<VisitorDM> CheckInVisitorMobileNumber = (sortType == "ASC" ?
GetCheckInVisitorList(cityId, page).OrderBy(objCheckInlist => objCheckInlist.Mobile_number) :
GetCheckInVisitorList(cityId, page).OrderByDescending(objCheckInlist => objCheckInlist.Mobile_number));
lstVistorDetails = CheckInVisitorMobileNumber.ToList();
break;
case "Person To Meet":
IEnumerable<VisitorDM> CheckInPersonToMeet = (sortType == "ASC" ?
GetCheckInVisitorList(cityId, page).OrderBy(objCheckInlist => objCheckInlist.EmployeeName_to_visit) :
GetCheckInVisitorList(cityId, page).OrderByDescending(objCheckInlist => objCheckInlist.EmployeeName_to_visit));
lstVistorDetails = CheckInPersonToMeet.ToList();
break;
case "In Time":
IEnumerable<VisitorDM> CheckInInTime = (sortType == "ASC" ?
GetCheckInVisitorList(cityId, page).OrderBy(objCheckInlist => objCheckInlist.EmployeeName_to_visit) :
GetCheckInVisitorList(cityId, page).OrderByDescending(objCheckInlist => objCheckInlist.EmployeeName_to_visit));
lstVistorDetails = CheckInInTime.ToList();
break;
}
}
else
{
if (Convert.ToString(VisitorListType.CurrentCheckInVisitor) == searchType)
{
IEnumerable<VisitorDM> CheckInVisitorList = GetCheckInVisitorList(cityId, page).Where(
objCheckInlist =>
(!string.IsNullOrEmpty(searchText) ? objCheckInlist.Mobile_number.Contains(searchText) : true)
|| (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Name.ToLower().Contains(searchText.ToLower()) : true)
|| (!string.IsNullOrEmpty(searchText) ? objCheckInlist.EmployeeName_to_visit.ToLower().Contains(searchText.ToLower()) : true)
|| (!string.IsNullOrEmpty(searchText) ? objCheckInlist.OfficeLocation.ToLower().Contains(searchText.ToLower()) : true)
|| (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Visit_id.ToString().Contains(searchText) : true)
);
lstVistorDetails = CheckInVisitorList.ToList();
}
}
if (!string.IsNullOrEmpty(columnName) && !string.IsNullOrEmpty(sortType))
{
}
else
{
if (Convert.ToString(VisitorListType.TodayAllInVisitor) == searchType)
{
IEnumerable<VisitorDM> TodayVisitorList = GetTodayVisitorList(cityId, page).Where(
objCheckInlist =>
(!string.IsNullOrEmpty(searchText) ? objCheckInlist.Mobile_number.Contains(searchText) : true)
|| (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Name.ToLower().Contains(searchText.ToLower()) : true)
|| (!string.IsNullOrEmpty(searchText) ? objCheckInlist.EmployeeName_to_visit.ToLower().Contains(searchText.ToLower()) : true)
|| (!string.IsNullOrEmpty(searchText) ? objCheckInlist.OfficeLocation.ToLower().Contains(searchText.ToLower()) : true)
|| (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Visit_id.ToString().Contains(searchText) : true)
);
lstVistorDetails = TodayVisitorList.ToList();
}
}
if (!string.IsNullOrEmpty(columnName) && !string.IsNullOrEmpty(sortType))
{
}
else
{
if (Convert.ToString(VisitorListType.VisitorHistory) == searchType)
{
IEnumerable<VisitorDM> AllVisitorHistoryList = GetVisitorHistoryList(cityId, page).Where(
objCheckInlist =>
(!string.IsNullOrEmpty(searchText) ? objCheckInlist.Mobile_number.ToLower().Contains(searchText.ToLower()) : true)
|| (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Name.ToLower().Contains(searchText.ToLower()) : true)
|| (!string.IsNullOrEmpty(searchText) ? objCheckInlist.EmployeeName_to_visit.ToLower().Contains(searchText.ToLower()) : true)
|| (!string.IsNullOrEmpty(searchText) ? objCheckInlist.OfficeLocation.ToLower().Contains(searchText.ToLower()) : true)
|| (!string.IsNullOrEmpty(searchText) ? objCheckInlist.Visit_id.ToString().Contains(searchText) : true)
);
lstVistorDetails = AllVisitorHistoryList.ToList<VisitorDM>();
}
}
}
return lstVistorDetails.ToList().AsQueryable();
}
calls in another function
public VisitorListVM GetAllTypeVisitorDetails(string searchText, string searchType, int cityId, int page, int UserId, [Optional] string columnName, [Optional]string sortType)
{
UserBL userBL = new UserBL();
VisitorListVM visitorListVM = new VisitorListVM();
visitorListVM.DefaultLocations = userBL.GetLocationList(UserId);
if (!string.IsNullOrEmpty(columnName) && !string.IsNullOrEmpty(sortType))
{
visitorListVM.Sort_Direction = sortType;
visitorListVM.PagedVisitorList = GetTypeVisitorDetails(searchText, searchType, cityId, page, columnName, sortType).ToPagedList(page);
}
else
{
visitorListVM.PagedVisitorList = GetTypeVisitorDetails(searchText, searchType, cityId, page).ToPagedList(page);
}
return visitorListVM;
}
Controller
public ActionResult Sorting(string searchType, int cityId,int Id, string columnName, string sortType)
{
visitorListBL = new VisitorListBL();
VisitorListVM visitorListVM = new VisitorListVM();
visitorListVM = visitorListBL.GetAllTypeVisitorDetails(string.Empty, searchType, Convert.ToInt32(cityId), Id, UserId, columnName, sortType);
visitorListVM.Sort_Direction=sortType;
if (Convert.ToString(VisitorListType.CurrentCheckInVisitor) == searchType)
{
return PartialView("~/Views/VisitorList/_CheckInVisitorList.cshtml", visitorListVM);
}
if (Convert.ToString(VisitorListType.TodayAllInVisitor) == searchType)
{
return PartialView("~/Views/VisitorList/_VisitorList.cshtml", visitorListVM);
}
if (Convert.ToString(VisitorListType.VisitorHistory) == searchType)
{
return PartialView("~/Views/VisitorList/_VisitorList.cshtml", visitorListVM);
}
return View();
}
JQuery
function Sorting(columnName, cityId, tabid) {
if (sort == "ASC")
{
sort = "DESC";
}
else
{
sort="ASC";
}
$.ajax({
type: "GET",
contentType: 'application/json',
url: "/VisitorList/Sorting",
data: { Id: currentPage, cityId: cityId, searchType: tabid, columnName: columnName, sortType: sort },
success: function (data) {
$('#divVisitorsList').replaceWith(data)
sort = data.Sort_Direction;
}
});
}
$(document).on('click', '.sorting', function(){
var columnName = $(this).text();
var cityId = $('#ddlLocation').val();
var tabid = $(".VisitorActiveTab").find('.active').attr('id');
Sorting(columnName, cityId, tabid)
});
Submit an article or tip