/// <summary>
/// search the LocalizedResources.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchLocalizedResources(JqSearchIn si, string language)
{
var localizedResources = Fetch(l => l.LanguageId.Equals(language)).Select(u => new LocalizedResourceModel
{
Id = u.Id,
TextKey = u.TextKey,
LanguageId = u.LanguageId,
DefaultValue = u.DefaultValue,
TranslatedValue = u.TranslatedValue,
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
});
return si.Search(localizedResources);
}
public string _AjaxBinding(JqSearchIn si)
{
return JsonConvert.SerializeObject(_clientMenuServices.SearchClientMenus(si));
}
/// <summary>
/// search the user groups.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchPageLogs(JqSearchIn si)
{
var pageLogs = GetAll().Select(audit => new PageLogModel
{
Id = audit.Id,
PageId = audit.PageId,
Title = audit.Title,
ChangeLog = audit.ChangeLog,
FileTemplateId = audit.FileTemplateId,
PageTemplateId = audit.PageTemplateId,
Status = audit.Status,
FriendlyUrl = audit.FriendlyUrl,
ParentId = audit.ParentId,
Created = audit.Created,
CreatedBy = audit.CreatedBy
});
return si.Search(pageLogs);
}
public string _AjaxBinding(JqSearchIn si)
{
return JsonConvert.SerializeObject(_curlyBracketServices.SearchCurlyBrackets(si));
}
public string _AjaxHistory(JqSearchIn si)
{
return JsonConvert.SerializeObject(_sqlCommandServices.SearchCommands(si));
}
/// <summary>
/// search the NewsCategories.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchNewsCategories(JqSearchIn si)
{
var newsCategories = GetAll().Select(u => new NewsCategoryModel
{
Id = u.Id,
Name = u.Name,
Description = u.Description,
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
ParentId = u.ParentId,
ParentName = u.NewsCategory1.Name,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
});
return si.Search(newsCategories);
}
public string _AjaxBinding(JqSearchIn si)
{
return JsonConvert.SerializeObject(_hotelBookingServices.SearchHotelBookings(si));
}
public string _AjaxBinding(JqSearchIn si)
{
return JsonConvert.SerializeObject(_pageTemplateServices.SearchPageTemplates(si));
}
/// <summary>
/// search the HotelBookings.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchHotelBookings(JqSearchIn si)
{
var hotelBookings = GetAll().Select(u => new HotelBookingModel
{
Id = u.Id,
TotalMoney = u.TotalMoney,
Note = u.Note,
Status = u.Status,
HotelCustomerId = u.HotelCustomerId,
HotelCustomerName = u.HotelCustomer.FullName,
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
});
return si.Search(hotelBookings);
}
public string _AjaxBinding(JqSearchIn si)
{
return JsonConvert.SerializeObject(_emailAccountServices.SearchEmailAccounts(si));
}
/// <summary>
/// search the ClientMenus.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchClientMenus(JqSearchIn si)
{
var clientMenus = GetAll().Select(u => new ClientMenuModel
{
Id = u.Id,
Url = u.Url,
Name = u.Name,
StartPublishingDate = u.StartPublishingDate,
EndPublishingDate = u.EndPublishingDate,
IsPageMenu = u.PageId.HasValue,
Hierarchy = u.Hierarchy,
ParentId = u.ParentId,
ParentName = u.ClientMenu1.Name,
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
});
return si.Search(clientMenus);
}
public string _AjaxBinding(JqSearchIn si)
{
return JsonConvert.SerializeObject(_rotatingImageServices.SearchRotatingImages(si));
}
/// <summary>
/// search the user groups.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchSettingTypes(JqSearchIn si)
{
var settingTypes = GetAll().Select(u => new SettingTypeModel
{
Id = u.Id,
Name = u.Name,
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
});
return si.Search(settingTypes);
}
/// <summary>
/// Search curly brackets
/// </summary>
/// <param name="si"></param>
/// <returns></returns>
public JqGridSearchOut SearchCurlyBrackets(JqSearchIn si)
{
var curlyBrackets = GetAllCurlyBracketsOfApplication().AsQueryable();
return si.Search(curlyBrackets);
}
/// <summary>
/// search the HotelServices.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchHotelServices(JqSearchIn si)
{
var hotelServices = GetAll().Select(u => new HotelServiceModel
{
Id = u.Id,
Name = u.Name,
ServiceIcon = u.ServiceIcon,
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
});
return si.Search(hotelServices);
}
public string _AjaxBinding(JqSearchIn si)
{
return JsonConvert.SerializeObject(_userServices.SearchUsers(si));
}
/// <summary>
/// search the Languages.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchLanguages(JqSearchIn si)
{
var languages = GetAll().Select(u => new LanguageModel
{
Id = u.Id,
Name = u.Name,
ShortName = u.ShortName,
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
});
return si.Search(languages);
}
/// <summary>
/// search the FileTemplates.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchFileTemplates(JqSearchIn si)
{
var fileTemplates = GetAll().Select(u => new FileTemplateModel
{
Id = u.Id,
Name = u.Name,
Controller = u.Controller,
Action = u.Action,
Parameters = u.Parameters,
PageTemplateId = u.PageTemplateId,
PageTemplateName = u.PageTemplateId.HasValue ? u.PageTemplate.Name : string.Empty,
ParentId = u.ParentId,
ParentName = u.ParentId.HasValue ? u.FileTemplate1.Name : string.Empty,
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
});
return si.Search(fileTemplates);
}
/// <summary>
/// search the Pages.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchPages(JqSearchIn si)
{
var pages = GetAll().Select(p => new PageModel
{
Id = p.Id,
PageTemplateId = p.PageTemplateId,
Title = p.Title,
PageTemplateName = p.PageTemplate.Name,
ParentName = p.ParentId.HasValue ? p.Page1.Title : string.Empty,
FriendlyUrl = p.FriendlyUrl,
Status = p.Status,
RecordActive = p.RecordActive,
RecordOrder = p.RecordOrder,
Created = p.Created,
CreatedBy = p.CreatedBy,
Updated = p.Updated,
UpdatedBy = p.UpdatedBy,
IsHomePage = p.IsHomePage
});
return si.Search(pages);
}
public string _AjaxBinding(JqSearchIn si)
{
return JsonConvert.SerializeObject(_languageServices.SearchLanguages(si));
}
/// <summary>
/// search the testimonials.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchTestimonials(JqSearchIn si)
{
var testimonials = GetAll().Select(u => new TestimonialModel
{
Id = u.Id,
Author = u.Author,
Content = u.Content,
AuthorDescription = u.AuthorDescription,
AuthorImageUrl = u.AuthorImageUrl,
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
});
return si.Search(testimonials);
}
public string _AjaxBinding(JqSearchIn si)
{
return JsonConvert.SerializeObject(_tagServices.SearchTags(si));
}
/// <summary>
/// search the user groups.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchNews(JqSearchIn si)
{
var news = GetAll().ToList().Select(u => new NewsModel
{
Id = u.Id,
Title = u.Title,
Description = u.Description,
ImageUrl = u.ImageUrl,
Content = u.Content,
Status = u.Status,
IsHotNews = u.IsHotNews,
Categories = string.Join(",", u.NewsNewsCategories.Select(c => c.NewsCategory.Name)),
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
}).AsQueryable();
return si.Search(news);
}
/// <summary>
/// search the email accounts.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchEmailAccounts(JqSearchIn si)
{
var emailAccounts = GetAll().Select(u => new EmailAccountModel
{
Id = u.Id,
Email = u.Email,
DisplayName = u.DisplayName,
IsDefault = u.IsDefault,
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
});
return si.Search(emailAccounts);
}
public string _AjaxBinding(JqSearchIn si)
{
return JsonConvert.SerializeObject(_settingTypeServices.SearchSettingTypes(si));
}
/// <summary>
/// search the Menus.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchMenus(JqSearchIn si)
{
var menus = GetAll().Select(u => new MenuModel
{
Id = u.Id,
Url = u.Url,
Controller = u.Controller,
Action = u.Action,
Name = u.Name,
Hierarchy = u.Hierarchy,
MenuIcon = u.MenuIcon,
ParentId = u.ParentId,
ParentName = u.Menu1.Name,
Visible = u.Visible,
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
});
return si.Search(menus);
}
public string _AjaxCurlyBracketBinding(JqSearchIn si)
{
return JsonConvert.SerializeObject(_templateServices.SearchTemplates(si));
}
/// <summary>
/// search the PageTemplates.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchPageTemplates(JqSearchIn si)
{
var pageTemplates = GetAll().Select(u => new PageTemplateModel
{
Id = u.Id,
Name = u.Name,
ParentId = u.ParentId,
ParentName = u.ParentId.HasValue ? u.PageTemplate1.Name : string.Empty,
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
});
return si.Search(pageTemplates);
}
/// <summary>
/// search the rotating images.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchRotatingImages(JqSearchIn si)
{
var rotatingImages = GetAll().Select(u => new RotatingImageModel
{
Id = u.Id,
ImageUrl = u.ImageUrl,
Url = u.Url,
GroupId = u.GroupId,
GroupName = u.RotatingImageGroup.Name,
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
});
return si.Search(rotatingImages);
}
/// <summary>
/// search the tags.
/// </summary>
/// <returns></returns>
public JqGridSearchOut SearchTags(JqSearchIn si)
{
var tags = GetAll().Select(u => new TagModel
{
Id = u.Id,
Name = u.Name,
RecordActive = u.RecordActive,
RecordOrder = u.RecordOrder,
Created = u.Created,
CreatedBy = u.CreatedBy,
Updated = u.Updated,
UpdatedBy = u.UpdatedBy
});
return si.Search(tags);
}
