/// <summary>
/// Lấy thông tin.
/// </summary>
/// <param name="inputObject">DataModel</param>
/// <returns>DataModel</returns>
private FilterDataModel GetInfo(FilterDataModel inputObject)
{
// Khởi tạo biến cục bộ
var getResult = new FilterDataModel();
// Map dữ liệu
DataHelper.CopyObject(inputObject, getResult);
// Lấy thông tin sản phẩm
var pagerItems = GetPagerItems(inputObject);
// Trường hợp không tìm thấy sản phẩm
if (pagerItems.ListData.Count == decimal.Zero)
{
// Gán message
getResult.Messages.Add(MessageHelper.GetMessage("I_MSG_00008"));
// Kết quả trả về
return(getResult);
}
// Gán giá trị trả về
getResult.ListData = pagerItems.ListData;
getResult.Total = pagerItems.Total;
// Kết quả trả về
return(getResult);
}
/// <summary>
/// Execute convert ouput.
/// </summary>
/// <param name="resultObject">DataModel</param>
/// <returns>ResponseModel</returns>
private FilterResponseModel Convert(FilterDataModel resultObject)
{
// Local variable declaration
FilterResponseModel responseModel = null;
IList <OutputAcceptModel> listAccepts = null;
MCodeCom mCodeCom = null;
OutputAcceptModel accept = null;
// Variable initialize
responseModel = new FilterResponseModel();
listAccepts = new List <OutputAcceptModel>();
mCodeCom = new MCodeCom();
// Get value
var slipStatusName = string.Empty;
var paymentMethodsName = string.Empty;
var deleteFlagName = string.Empty;
var cbSlipStatus = new ComboModel();
foreach (var obj in resultObject.ListAccepts)
{
accept = new OutputAcceptModel();
accept.AcceptSlipNo = DataHelper.ToString(obj.AcceptSlipNo);
accept.SlipStatus = DataHelper.ToString(obj.SlipStatus);
slipStatusName = mCodeCom.GetCodeName(Logics.GROUP_SLIP_STATUS, accept.SlipStatus);
accept.SlipStatusName = DataHelper.ToString(slipStatusName);
accept.AcceptDate = DataHelper.ToString(Formats.DATE, obj.AcceptDate);
accept.DeliveryDate = DataHelper.ToString(Formats.DATE, obj.DeliveryDate);
accept.ClientCd = DataHelper.ToString(obj.ClientCd);
accept.ClientName = DataHelper.ToString(obj.ClientName);
accept.ClientAddress = DataHelper.ToString(obj.ClientAddress);
accept.ClientTel = DataHelper.ToString(obj.ClientTel);
accept.DeliveryCd = DataHelper.ToString(obj.DeliveryCd);
accept.DeliveryName = DataHelper.ToString(obj.DeliveryName);
accept.DeliveryAddress = DataHelper.ToString(obj.DeliveryAddress);
accept.DeliveryTel = DataHelper.ToString(obj.DeliveryTel);
accept.PaymentMethods = DataHelper.ToString(obj.PaymentMethods);
paymentMethodsName = mCodeCom.GetCodeName(Logics.GROUP_PAYMENT_METHODS, accept.PaymentMethods);
accept.PaymentMethodsName = DataHelper.ToString(paymentMethodsName);
accept.GiftCd = DataHelper.ToString(obj.GiftCd);
accept.ViewId = DataHelper.ToString(obj.ViewId);
accept.Notes = DataHelper.ToString(obj.Notes);
accept.UpdateUser = DataHelper.ToString(obj.UpdateUser);
accept.UpdateDate = DataHelper.ToString(Formats.UPDATE_DATE, obj.UpdateDate);
accept.DeleteFlag = DataHelper.ToString(obj.DeleteFlag);
deleteFlagName = mCodeCom.GetCodeName(Logics.GROUP_DELETE_FLAG, accept.DeleteFlag);
accept.DeleteFlagName = DataHelper.ToString(deleteFlagName);
cbSlipStatus = MCodeCom.ToComboItems(resultObject.ListSlipStatus, accept.SlipStatus);
accept.ListSlipStatus = cbSlipStatus.ListItems;
accept.SlipStatus = cbSlipStatus.SeletedValue;
listAccepts.Add(accept);
}
// Set value
responseModel.ListAccepts = listAccepts;
// Return value
return(responseModel);
}
public IEnumerable <Game> FilterGames(FilterDataModel filters)
{
var gamePipelineExpression = GetFilterGameExpression(filters);
var games = GetAllGames(filters.SortType, _language, gamePipelineExpression,
(filters.CurrentPage - 1) * filters.ItemsPerPage, filters.ItemsPerPage);
return(games);
}
public IEnumerable <BassGuitarDataModel> GetBassGuitars(FilterDataModel filter, int lowerBound, int upperBound)
{
var guitars = ApplyFilteringFor(_repoProvider.BassGuitarRepository, filter);
return(MiddlewareMappings.Map <List <BassGuitarDataModel> >(guitars.Skip(lowerBound)
.Take(upperBound - lowerBound)
.ToList()));
}
/// <summary>
/// Check processing.
/// </summary>
/// <param name="inputObject">DataModel</param>
private void Check(FilterDataModel inputObject)
{
// Check role
if (!PageHelper.AuthRole(Logics.RL_GIFTS))
{
throw new ExecuteException("E_MSG_00013");
}
}
public IActionResult GetGameList(FilterDataModel filters)
{
var valuesDto = GetFilterValues();
var hotelsFiltersDto = _hotelService.ProcessFiltering(filters);
hotelsFiltersDto.DefaultValues = valuesDto;
return(PartialView("_Games", hotelsFiltersDto));
}
/// <summary>
/// Xử lý filter.
/// </summary>
/// <param name="inputObject">DataModel</param>
/// <returns>DataModel</returns>
public FilterDataModel Execute(FilterDataModel inputObject)
{
// Kiểm tra thông tin
Check(inputObject);
// Lấy thông tin
var resultObject = GetInfo(inputObject);
// Kết quả trả về
return resultObject;
}
public List <DeviceModel> ApplyAllFilters(FilterDataModel filters)
{
var filter1 = ApplyMeasurementsFilter(filters.Measurements, _filteredDevices);
var filter2 = ApplyWeightFilter(filters.Weight, filter1);
var filter3 = ApplyResolutionFilter(filters.Resolution, filter2);
var filter4 = ApplyBatteryCapacityFilter(filters.Batterycapacity, filter3);
return(filter4);
}
public ViewResult Index(FilterDataModel filters)
{
var valuesDto = GetFilterValues();
var hotelsFiltersDto = _hotelService.ProcessFiltering(filters);
hotelsFiltersDto.DefaultValues = valuesDto;
return(View(hotelsFiltersDto));
}
/// <summary>
/// Xử lý filter.
/// </summary>
/// <param name="inputObject">DataModel</param>
/// <returns>DataModel</returns>
public FilterDataModel Execute(FilterDataModel inputObject)
{
// Kiểm tra thông tin
Check(inputObject);
// Lấy thông tin
var resultObject = GetInfo(inputObject);
// Kết quả trả về
return(resultObject);
}
public IEnumerable <BassGuitarDataModel> GetSortedBassGuitars(FilterDataModel filter, int lowerBound, int upperBound, SortingDataModel sorting)
{
if (sorting.SortHeader == SortHeader.Price)
{
return(_blGuitarWorker.GetSortedBassGuitarsByPrice(filter, lowerBound, upperBound, sorting.SortDirection));
}
else
{
return(_blGuitarWorker.GetSortedBassGuitarsByVendor(filter, lowerBound, upperBound, sorting.SortDirection));
}
}
public IActionResult GetAll([FromForm] FilterDataModel filters)
{
var games = _gameService.FilterGames(filters);
if (!games.Any())
{
return(StatusCode(StatusCodes.Status404NotFound));
}
return(Ok(games));
}
public Expression <Func <Game, bool> > GetFilterGameExpression(FilterDataModel filters)
{
var gamePipelineExpression = new GamePipelineBuilder(filters)
.WithSearchFilter()
.WithGameGenreFilter()
.WithGamePlatformsFilter()
.WithGamePriceFilter()
.WithGamePublisherFilter()
.WithGameReleaseDateFilter()
.Build();
return(gamePipelineExpression);
}
/// <summary>
/// Lấy đối tượng pager
/// </summary>
private PagerInfoModel<TourObject> GetPagerData(FilterDataModel inputObject)
{
// Khởi tạo biến cục bộ
var pagerResult = new PagerInfoModel<TourObject>();
var processDao = new MasterToursDao();
// Lấy đối tượng pager
var pagerData = processDao.GetPagerData(inputObject);
// Gán giá trị trả về
pagerResult.ListData = pagerData.ListData;
pagerResult.Total = pagerData.Total;
// Kết quả trả về
return pagerResult;
}
public IList <GiftCard> GetListGifts(FilterDataModel inputObject)
{
// Get value
var listResult = from tbl in EntityManager.GiftCards
where (tbl.GiftCd.Contains(inputObject.GiftCd) || DataCheckHelper.IsNull(inputObject.GiftCd)) &&
(tbl.GiftStatus == inputObject.GiftStatus || DataCheckHelper.IsNull(inputObject.GiftStatus)) &&
(tbl.DeleteFlag == inputObject.DeleteFlag || DataCheckHelper.IsNull(inputObject.DeleteFlag))
orderby tbl.UpdateDate ascending
select tbl;
// Return value
return(listResult.ToList());
}
public IActionResult GetAll([FromForm] FilterDataModel filters)
{
var hotels = _hotelService.ProcessFiltering(filters);
if (hotels.Hotels.Any())
{
var serializedHotels = JsonConvert.SerializeObject(hotels.Hotels);
return(Ok(serializedHotels));
}
return(NoContent());
}
public IList <Offer> GetListOffers(FilterDataModel inputObject)
{
// Get value
var listResult = from tbl in EntityManager.Offers
where (tbl.ItemCd.Contains(inputObject.ItemCd) || DataCheckHelper.IsNull(inputObject.ItemCd)) &&
(tbl.OfferDiv == inputObject.OfferDiv || DataCheckHelper.IsNull(inputObject.OfferDiv)) &&
(tbl.DeleteFlag == inputObject.DeleteFlag || DataCheckHelper.IsNull(inputObject.DeleteFlag))
orderby tbl.UpdateDate ascending
select tbl;
// Return value
return(listResult.ToList());
}
/// <summary>
/// Execute convert ouput.
/// </summary>
/// <param name="resultObject">DataModel</param>
/// <returns>ResponseModel</returns>
private FilterResponseModel Convert(FilterDataModel resultObject)
{
// Local variable declaration
FilterResponseModel responseModel = null;
IList <OutputItemModel> listItems = null;
MCodeCom mCodeCom = null;
OutputItemModel item = null;
// Variable initialize
responseModel = new FilterResponseModel();
listItems = new List <OutputItemModel>();
mCodeCom = new MCodeCom();
// Get value
var itemDivName = string.Empty;
var deleteFlagName = string.Empty;
foreach (var obj in resultObject.ListItems)
{
item = new OutputItemModel();
item.ItemCd = DataHelper.ToString(obj.ItemCd);
item.ItemName = DataHelper.ToString(obj.ItemName);
item.CategoryCd = DataHelper.ToString(obj.CategoryCd);
item.CategoryName = DataHelper.ToString(obj.Category.CategoryName);
item.AgeCd = DataHelper.ToString(obj.AgeCd);
item.AgeName = DataHelper.ToString(obj.Age.AgeName);
item.GenderCd = DataHelper.ToString(obj.GenderCd);
item.GenderName = DataHelper.ToString(obj.Gender.GenderName);
item.BrandCd = DataHelper.ToString(obj.BrandCd);
item.BrandName = DataHelper.ToString(obj.Brand.BrandName);
item.CountryCd = DataHelper.ToString(obj.CountryCd);
item.CountryName = DataHelper.ToString(obj.Country.CountryName);
item.UnitCd = DataHelper.ToString(obj.UnitCd);
item.UnitName = DataHelper.ToString(obj.Unit.UnitName);
item.ItemDiv = DataHelper.ToString(obj.ItemDiv);
itemDivName = mCodeCom.GetCodeName(Logics.GROUP_ITEM_DIV, item.ItemDiv);
item.ItemDivName = DataHelper.ToString(itemDivName);
item.UpdateDate = DataHelper.ToString(Formats.UPDATE_DATE, obj.UpdateDate);
item.DeleteFlag = DataHelper.ToString(obj.DeleteFlag);
deleteFlagName = mCodeCom.GetCodeName(Logics.GROUP_DELETE_FLAG, item.DeleteFlag);
item.DeleteFlagName = DataHelper.ToString(deleteFlagName);
listItems.Add(item);
}
// Set value
responseModel.ListItems = listItems;
// Return value
return(responseModel);
}
//public IEnumerable<string> GetAllGameGenres(string hotelId)
//{
// var hotel = _hotelRepository.FirstOrDefault(a => a.Key == hotelId);
// var genres = new List<string>();
// foreach (GameGenre genre in hotel.GameGenres)
// {
// var genreEntity = _genreRepository.FirstOrDefault(a => a.Id == genre.GenreId);
// genres.Add(genreEntity.Name);
// }
// return genres;
//}
public HotelFilters ProcessFiltering(FilterDataModel filters)
{
var hotelsFilters = new HotelFilters {
Filters = filters
};
var hotelPipelineExpression = new GamePipelineBuilder(filters).WithSearchFilter()
.WithGamePriceFilter().WithGameRoomFilter().WithGameReleaseDateFilter().Build();
var hotels = GetAllHotels(filters.SortType, _language, filter: hotelPipelineExpression, skip: (filters.CurrentPage - 1) * filters.ItemsPerPage, take: filters.ItemsPerPage);
filters.TotalPages = GetTotalPages(_hotelRepository.Count(hotelPipelineExpression), filters.ItemsPerPage);
hotelsFilters.Hotels = hotels;
return(hotelsFilters);
}
/// <summary>
/// Execute convert input.
/// </summary>
/// <param name="request">RequestModel</param>
/// <returns>DataModel</returns>
private FilterDataModel Convert(FilterRequestModel request)
{
// Local variable declaration
FilterDataModel inputObject = null;
// Variable initialize
inputObject = new FilterDataModel();
// Convert data input
DataHelper.ConvertInput(request, inputObject);
// Return value
return(inputObject);
}
/// <summary>
/// Lấy thông tin.
/// </summary>
/// <param name="inputObject">DataModel</param>
/// <returns>DataModel</returns>
private FilterDataModel GetInfo(FilterDataModel inputObject)
{
// Khởi tạo biến cục bộ
var getResult = new FilterDataModel();
// Map dữ liệu
DataHelper.CopyObject(inputObject, getResult);
// Lấy đối tượng pager
var pagerData = GetPagerData(inputObject);
// Gán giá trị trả về
getResult.ListData = pagerData.ListData;
getResult.Total = pagerData.Total;
// Kết quả trả về
return getResult;
}
public ViewResult Index(FilterDataModel filters)
{
var valuesDto = GetFilterValues();
var filteredGames = _gameService.FilterGames(filters);
var filterExpression = _gameService.GetFilterGameExpression(filters);
filters.TotalPages =
_gameService.GetTotalPages(_gameService.CountAllGames(filterExpression), filters.ItemsPerPage);
var gameFilters = new GamesFilters {
DefaultValues = valuesDto, Filters = filters, Games = filteredGames
};
return(View(gameFilters));
}
public IActionResult GetGameList(FilterDataModel filters)
{
var valuesDto = GetFilterValues();
var filteredGames = _gameService.FilterGames(filters);
var filterExpression = _gameService.GetFilterGameExpression(filters);
filters.TotalPages =
_gameService.GetTotalPages(_gameService.CountAllGames(filterExpression), filters.ItemsPerPage);
var gameFilters = new GamesFilters {
DefaultValues = valuesDto, Filters = filters, Games = filteredGames
};
return(PartialView("_Games", gameFilters));
}
public IList <Brand> GetListBrands(FilterDataModel inputObject)
{
// Get value
var listResult = from tbl in EntityManager.Brands
where (tbl.BrandCd.Contains(inputObject.BrandCd) || DataCheckHelper.IsNull(inputObject.BrandCd)) &&
(tbl.BrandName.Contains(inputObject.BrandName) ||
tbl.BrandSearchName.Contains(inputObject.BrandName) ||
DataCheckHelper.IsNull(inputObject.BrandName)) &&
(tbl.DeleteFlag == inputObject.DeleteFlag || DataCheckHelper.IsNull(inputObject.DeleteFlag))
orderby tbl.SortKey ascending
select tbl;
// Return value
return(listResult.ToList());
}
/// <summary>
/// Execute convert ouput.
/// </summary>
/// <param name="resultObject">DataModel</param>
/// <returns>ResponseModel</returns>
private FilterResponseModel Convert(FilterDataModel resultObject)
{
// Local variable declaration
FilterResponseModel responseModel = null;
IList <OutputOfferModel> listOffers = null;
MCodeCom mCodeCom = null;
OutputOfferModel offer = null;
// Variable initialize
responseModel = new FilterResponseModel();
listOffers = new List <OutputOfferModel>();
mCodeCom = new MCodeCom();
// Get value
var cbDeleteFlag = new ComboModel();
var offerDivName = string.Empty;
foreach (var obj in resultObject.ListOffers)
{
offer = new OutputOfferModel();
offer.OfferCd = DataHelper.ToString(obj.OfferCd);
offer.OfferGroupCd = DataHelper.ToString(obj.OfferGroupCd);
offer.ItemCd = DataHelper.ToString(obj.ItemCd);
offer.StartDate = DataHelper.ToString(Formats.DATE, obj.StartDate);
offer.EndDate = DataHelper.ToString(Formats.DATE, obj.EndDate);
offer.Percent = DataHelper.ToString(Formats.NUMBER, obj.Percent);
offer.Notes = DataHelper.ToString(obj.Notes);
offer.DeleteFlag = DataHelper.ToString(obj.DeleteFlag);
offer.UpdateDate = DataHelper.ToString(Formats.UPDATE_DATE, obj.UpdateDate);
offerDivName = mCodeCom.GetCodeName(Logics.GROUP_OFFER_DIV, obj.OfferDiv);
offer.OfferDiv = DataHelper.ToString(obj.OfferDiv);
offer.OfferDivName = DataHelper.ToString(offerDivName);
cbDeleteFlag = MCodeCom.ToComboItems(resultObject.ListDeleteFlag, offer.DeleteFlag);
offer.ListDeleteFlag = cbDeleteFlag.ListItems;
offer.DeleteFlag = cbDeleteFlag.SeletedValue;
listOffers.Add(offer);
}
// Set value
responseModel.ListOffers = listOffers;
// Return value
return(responseModel);
}
/// <summary>
/// Execute convert ouput.
/// </summary>
/// <param name="resultObject">DataModel</param>
/// <returns>ResponseModel</returns>
private FilterResponseModel Convert(FilterDataModel resultObject)
{
// Local variable declaration
FilterResponseModel responseModel = null;
IList <OutputUserModel> listUsers = null;
MCodeCom mCodeCom = null;
OutputUserModel user = null;
// Variable initialize
responseModel = new FilterResponseModel();
listUsers = new List <OutputUserModel>();
mCodeCom = new MCodeCom();
// Get value
var deleteFlagName = string.Empty;
foreach (var obj in resultObject.ListUsers)
{
user = new OutputUserModel();
user.UserCd = DataHelper.ToString(obj.UserCd);
user.Email = DataHelper.ToString(obj.Email);
user.FullName = DataHelper.ToString(obj.FullName);
user.Address = DataHelper.ToString(obj.Address);
user.CityCd = DataHelper.ToString(obj.CityCd);
user.CityName = DataHelper.ToString(obj.City.CityName);
user.Phone1 = DataHelper.ToString(obj.Phone1);
user.Phone2 = DataHelper.ToString(obj.Phone2);
user.UpdateDate = DataHelper.ToString(Formats.UPDATE_DATE, obj.UpdateDate);
user.DeleteFlag = DataHelper.ToString(obj.DeleteFlag);
deleteFlagName = mCodeCom.GetCodeName(Logics.GROUP_DELETE_FLAG, user.DeleteFlag);
user.DeleteFlagName = DataHelper.ToString(deleteFlagName);
if (obj.UserGroups.Count > decimal.Zero)
{
user.GroupCd = DataHelper.ToString(obj.UserGroups[0].GroupCd);
user.GroupName = DataHelper.ToString(obj.UserGroups[0].Group.GroupName);
}
listUsers.Add(user);
}
// Set value
responseModel.ListUsers = listUsers;
// Return value
return(responseModel);
}
public IList <User> GetListUsers(FilterDataModel inputObject)
{
// Get value
var listResult = from tbl in EntityManager.Users
where tbl.UserCd != PageHelper.UserCd &&
(tbl.Email.Contains(inputObject.Email) || DataCheckHelper.IsNull(inputObject.Email)) &&
(tbl.FullName.Contains(inputObject.FullName) || DataCheckHelper.IsNull(inputObject.FullName)) &&
(tbl.CityCd == inputObject.CityCd || DataCheckHelper.IsNull(inputObject.CityCd)) &&
((from sub in tbl.UserGroups select sub.GroupCd).Contains(inputObject.GroupCd) ||
DataCheckHelper.IsNull(inputObject.GroupCd)) &&
(tbl.DeleteFlag == inputObject.DeleteFlag || DataCheckHelper.IsNull(inputObject.DeleteFlag))
orderby tbl.UpdateDate ascending
select tbl;
// Return value
return(listResult.ToList());
}
public IEnumerable <BassGuitarDataModel> GetSortedBassGuitarsByVendor(FilterDataModel filter, int lowerBound, int upperBound, SortDirection sortDirection)
{
var guitars = ApplyFilteringFor(_repoProvider.BassGuitarRepository, filter);
if (sortDirection == SortDirection.Ascending)
{
return(MiddlewareMappings.Map <List <BassGuitarDataModel> >(guitars.OrderBy(g => g.Vendor.Name)
.Skip(lowerBound)
.Take(upperBound - lowerBound)
.ToList()));
}
else
{
return(MiddlewareMappings.Map <List <BassGuitarDataModel> >(guitars.OrderByDescending(g => g.Vendor.Name)
.Skip(lowerBound)
.Take(upperBound - lowerBound)
.ToList()));
}
}
/// <summary>
/// Execute convert ouput.
/// </summary>
/// <param name="resultObject">DataModel</param>
/// <returns>ResponseModel</returns>
private FilterResponseModel Convert(FilterDataModel resultObject)
{
// Local variable declaration
FilterResponseModel responseModel = null;
IList <OutputGiftModel> listGifts = null;
MCodeCom mCodeCom = null;
OutputGiftModel gift = null;
// Variable initialize
responseModel = new FilterResponseModel();
listGifts = new List <OutputGiftModel>();
mCodeCom = new MCodeCom();
// Get value
var deleteFlagName = string.Empty;
ComboModel cbGiftStatus = null;
foreach (var obj in resultObject.ListGifts)
{
gift = new OutputGiftModel();
gift.GiftCd = DataHelper.ToString(obj.GiftCd);
gift.GiftStatus = DataHelper.ToString(obj.GiftStatus);
gift.StartDate = DataHelper.ToString(Formats.DATE, obj.StartDate);
gift.EndDate = DataHelper.ToString(Formats.DATE, obj.EndDate);
gift.Price = DataHelper.ToString(Formats.CURRENCY, obj.Price);
gift.UpdateDate = DataHelper.ToString(Formats.UPDATE_DATE, obj.UpdateDate);
gift.DeleteFlag = DataHelper.ToString(obj.DeleteFlag);
deleteFlagName = mCodeCom.GetCodeName(Logics.GROUP_DELETE_FLAG, gift.DeleteFlag);
gift.DeleteFlagName = DataHelper.ToString(deleteFlagName);
cbGiftStatus = MCodeCom.ToComboItems(resultObject.ListGiftStatus, gift.GiftStatus);
gift.ListGiftStatus = cbGiftStatus.ListItems;
gift.GiftStatus = cbGiftStatus.SeletedValue;
listGifts.Add(gift);
}
// Set value
responseModel.ListGifts = listGifts;
// Return value
return(responseModel);
}
public IList <Item> GetListItems(FilterDataModel inputObject)
{
// Get value
var listResult = from tbl in EntityManager.Items
where (tbl.ItemCd.Contains(inputObject.ItemCd) || DataCheckHelper.IsNull(inputObject.ItemCd)) &&
(tbl.ItemName.Contains(inputObject.ItemName) || DataCheckHelper.IsNull(inputObject.ItemName)) &&
(tbl.CategoryCd == inputObject.CategoryCd || DataCheckHelper.IsNull(inputObject.CategoryCd)) &&
(tbl.AgeCd == inputObject.AgeCd || DataCheckHelper.IsNull(inputObject.AgeCd)) &&
(tbl.GenderCd == inputObject.GenderCd || DataCheckHelper.IsNull(inputObject.GenderCd)) &&
(tbl.BrandCd == inputObject.BrandCd || DataCheckHelper.IsNull(inputObject.BrandCd)) &&
(tbl.CountryCd == inputObject.CountryCd || DataCheckHelper.IsNull(inputObject.CountryCd)) &&
(tbl.UnitCd == inputObject.UnitCd || DataCheckHelper.IsNull(inputObject.UnitCd)) &&
(tbl.ItemDiv == inputObject.ItemDiv || DataCheckHelper.IsNull(inputObject.ItemDiv)) &&
(tbl.DeleteFlag == inputObject.DeleteFlag || DataCheckHelper.IsNull(inputObject.DeleteFlag))
orderby tbl.SortKey ascending
select tbl;
// Return value
return(listResult.ToList());
}
/// <summary>
/// Lấy thông tin danh sách sản phẩm.
/// </summary>
public PagerInfoModel <MAItem> GetPagerItems(FilterDataModel inputObject)
{
// Tạo tham số
var param = new
{
ItemSearchName = inputObject.ItemSearchName,
CategorySearchName = inputObject.CategorySearchName
};
// Tạo đối tượng pager
var pagerInfo = new PagerInfoModel <MAItem>();
// Sao chép thông tin pager
DataHelper.CopyPagerInfo(inputObject, pagerInfo);
// Gán tham số điêu kiện tim kiếm sản phẩm.
pagerInfo.Critial = param;
// Kết quả trả về
return(GetPagerByFile <MAItem>(ITEMS_LIST_DAO_GET_PAGER_ITEMS_SQL, pagerInfo));
}
/// <summary>
/// Get infomation
/// </summary>
/// <param name="inputObject">DataModel</param>
/// <returns>DataModel</returns>
private FilterDataModel GetInfo(FilterDataModel inputObject)
{
// Local variable declaration
FilterDataModel getResult = null;
MCodeCom mCodeCom = null;
AdminBrandListDao adminBrandListDao = null;
// Variable initialize
getResult = new FilterDataModel();
mCodeCom = new MCodeCom();
adminBrandListDao = new AdminBrandListDao();
// Get data
var listBrands = adminBrandListDao.GetListBrands(inputObject);
// Set value
getResult.ListBrands = listBrands;
// Return value
return(getResult);
}
/// <summary>
/// Lấy pager sản phẩm
/// </summary>
private PagerInfoModel <ItemObject> GetPagerItems(FilterDataModel inputObject)
{
// Khởi tạo biến cục bộ
var pagerResult = new PagerInfoModel <ItemObject>();
var listData = new List <ItemObject>();
var processDao = new ItemsListDao();
var storageFileCom = new StorageFileCom();
// Lấy thông tin danh sách sản phẩm
var pagerItems = processDao.GetPagerItems(inputObject);
// Khai báo biến dùng trong loop
ItemObject info = null;
// Duyệt danh sách sản phẩm mới
foreach (var item in pagerItems.ListData)
{
// Khởi tạo đối tượng sản phẩm mới
info = new ItemObject();
// Gán giá trị vào đối tượng sản phẩm mới
info.ItemCd = item.ItemCd;
info.ItemName = item.ItemName;
info.ItemSearchName = item.ItemSearchName;
info.ItemImage = storageFileCom.GetFileName(
Logics.LOCALE_DEFAULT,
item.FileCd,
false);
// Thêm vào đối tượng kết quả
listData.Add(info);
}
// Gán giá trị trả về
pagerResult.ListData = listData;
pagerResult.Total = pagerItems.Total;
// Kết quả trả về
return(pagerResult);
}
/// <summary>
/// Kiểm tra thông tin.
/// </summary>
/// <param name="inputObject">DataModel</param>
private void Check(FilterDataModel inputObject)
{
}
