public List <DTO.ShowroomItemMng.SampleProduct> QuickSearchSampleProduct(Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
totalRows = 0;
List <DTO.ShowroomItemMng.SampleProduct> data = new List <DTO.ShowroomItemMng.SampleProduct>();
try
{
using (ShowroomItemMngEntities context = CreateContext())
{
string searchQuery = null;
if (filters.ContainsKey("searchQuery") && !string.IsNullOrEmpty(filters["searchQuery"].ToString()))
{
searchQuery = filters["searchQuery"].ToString().Replace("'", "''");
}
totalRows = context.ShowroomItem_function_QuickSearchSampleProduct(searchQuery, orderBy, orderDirection).Count();
var result = context.ShowroomItem_function_QuickSearchSampleProduct(searchQuery, orderBy, orderDirection);
data = converter.DB2DTO_SampleProduct(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList());
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
notification.DetailMessage.Add(ex.Message);
if (ex.GetBaseException() != null)
{
notification.DetailMessage.Add(ex.GetBaseException().Message);
}
}
return(data);
}
