public async Task <MeasureUnitSearchResponse> Search(MeasureUnitSearchRequest request) { MeasureUnitSearchResponse response = new MeasureUnitSearchResponse(); RefSqlPaging paging = new RefSqlPaging(request.PageIndex, 30); try { RefSqlPaging sqlpaging = new RefSqlPaging(request.PageIndex, request.PageSize); RMeasureUnit[] measureUnit = await _measureUnitService.Search(request.UnitName, request.UnitStatus, sqlpaging); response.TotalRow = paging.TotalRow; response.MeasureUnits = measureUnit.Select(p => p.ToModel()).ToArray(); response.BaseUnits = measureUnit.Select(p => p.ToKeyValueTypeStringModel()).ToArray(); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <RoleSearchResponse> Search(RoleSearchRequest request) { RoleSearchResponse response = new RoleSearchResponse(); try { RefSqlPaging paging = new RefSqlPaging(request.PageIndex, 30); RRole[] roles = await _roleService.RoleSearch(request.Name, request.Status, request.DepartmentId, paging); var departments = await _roleService.DepartmentSearchFromDb(string.Empty, 0, new RefSqlPaging(0, Int32.MaxValue)); if (roles != null && roles.Length > 0) { // RDepartment[] departments = await _roleService.DepartmentGetFromDb(roles.Select(p => p.Id).ToArray()); response.Roles = roles.Select(p => p.ToModel(departments.FirstOrDefault(q => q.Id == p.DepartmentId))).ToArray(); } else { response.Roles = new RoleViewModel[0]; } response.Departments = departments.Select(p => p.ToKeyValueTypeStringModel()).ToArray(); response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <ActionDefineSearchResponse> Search(ActionDefineSearchRequest request) { ActionDefineSearchResponse response = new ActionDefineSearchResponse(); try { RefSqlPaging sqlPaging = new RefSqlPaging(request.PageIndex, 30); RActionDefine[] actionDefines = await _roleService.ActionDefineGet(request.Group, string.Empty, sqlPaging); RRoleActionMapping[] roleActionMappings = await _roleService.RoleActionMappingGetByRoleIdFromDb(request.RoleId); response.TotalRow = sqlPaging.TotalRow; response.ActionDefines = actionDefines.Select(p => p.ToModel(roleActionMappings.Any(q => q.ActionId == p.Id))).GroupBy(p => p.Group).Select(p => new KeyValuePair <string, ActionDefineViewModel[]>(p.Key, p.OrderBy(q => q.Name).ToArray())).ToArray(); response.PageIndex = sqlPaging.PageIndex; response.PageSize = sqlPaging.PageSize; response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <LocaleStringResourceSearchResponse> Search(LocaleStringResourceSearchRequest request) { LocaleStringResourceSearchResponse response = new LocaleStringResourceSearchResponse(); RefSqlPaging paging = new RefSqlPaging(request.PageIndex, 30); try { RefSqlPaging sqlpaging = new RefSqlPaging(request.PageIndex, request.PageSize); var data = await _localeStringResourceService.Search(request.LanguageId, request.ResourceName, request.ResourceValue, sqlpaging); response.TotalRow = paging.TotalRow; response.Locales = data.Select(p => p.ToModel()).ToArray(); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; RLanguage[] languages = await _languageService.Get(); if (languages.Length > 0) { response.Languages = languages.Select(p => p.ToKeyValueModel()).ToArray(); } response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <BannerItemSearchResponse> SearchBannerItem(BannerItemSearchRequest request) { BannerItemSearchResponse response = new BannerItemSearchResponse(); try { var banner = await _bannerService.GetBannerById(request.BannerId); if (banner == null) { response.SetFail("Banner not found!!!"); return(response); } RefSqlPaging paging = new RefSqlPaging(request.PageIndex, request.PageSize); DateTimeRange from = new DateTimeRange(request.FromStartDate?.AsDateTimeNullable(SystemDefine.DateFormat), request.ToStartDate?.AsDateTimeNullable(SystemDefine.DateFormat)); DateTimeRange to = new DateTimeRange(request.FromEndDate?.AsDateTimeNullable(SystemDefine.DateFormat), request.ToEndDate?.AsDateTimeNullable(SystemDefine.DateFormat)); var data = await _bannerService.SearchBannerItem(request.Id, request.BannerItemName, request.BannerId, request.Status, request.IsDefault, from, to, paging); response.TotalRow = paging.TotalRow; response.BannerItems = data.Select(p => p.ToModel()).ToArray(); response.Banner = banner.ToModel(); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <CategoryManufacturerGetListResponse> GetListManufacturer(CategoryManufacturerGetListRequest request) { CategoryManufacturerGetListResponse response = new CategoryManufacturerGetListResponse(); try { RefSqlPaging sqlpaging = new RefSqlPaging(request.PageIndex, request.PageSize); var data = await _categoryService.GetListManufacturer(request.Id, sqlpaging); response.TotalRow = sqlpaging.TotalRow; response.Manufacturers = data.Select(p => p.ToModel()).ToArray(); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <ComponentsAutocompleteResponse> ComponentsAutocomplete(ComponentsAutocompleteRequest request) { ComponentsAutocompleteResponse response = new ComponentsAutocompleteResponse(); try { RefSqlPaging sqlPaging = new RefSqlPaging(0, 100); switch (request.ComponentType) { case EnumDefine.TemplateConfigComponentTypeEnum.Banner: { var banners = await _bannerService.SearchBanner(string.Empty, request.Tearm, 0, sqlPaging); response.Components = banners.Select(p => p.ToAutocompleteModel()).ToArray(); } break; case EnumDefine.TemplateConfigComponentTypeEnum.Menu: { } break; case EnumDefine.TemplateConfigComponentTypeEnum.ProductGroup: break; } } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <WarehouseSearchResponse> Search(WarehouseSearchRequest request) { WarehouseSearchResponse response = new WarehouseSearchResponse(); try { List <WarehouseViewModel> warehouseViewModels = new List <WarehouseViewModel>(); RefSqlPaging paging = new RefSqlPaging(request.PageIndex, request.PageSize); var data = await _warehouseService.Search(request.Code, request.Email, request.Phone, request.Name, request.Status, request.Type, paging); var venderIds = data.Select(p => p.VendorId).ToArray(); Dictionary <string, string> vendorNameByIds = new Dictionary <string, string>(); if (venderIds.Length > 0) { var vendors = await _vendorService.GetFromDb(venderIds); vendorNameByIds = vendors.ToDictionary(p => p.Id, p => p.Name); } response.TotalRow = paging.TotalRow; foreach (var item in data) { //item.VendorName = dataVendor.Where(x => x.Id == item.VendorId.ToString()).FirstOrDefault().Name; var province = await _locationService.GetProvinceById(item.ProvinceId.ToString()); var district = await _locationService.GetDistrictById(item.DistrictId.ToString()); var village = await _locationService.GetWardById(item.VillageId.ToString()); RStreet road = await _locationService.GetStreetById(item.RoadId.ToString()); string venderName = string.Empty; if (!string.IsNullOrEmpty(item.VendorId)) { venderName = vendorNameByIds.ContainsKey(item.VendorId) ? vendorNameByIds[item.VendorId] : string.Empty; } var warehouseModel = item.ToModel(province.ProvinceName, district.DistrictName, village.WardName, road.StreetName, venderName); warehouseViewModels.Add(warehouseModel); } response.Warehouses = warehouseViewModels.ToArray(); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <RCategoryAttr[]> GetListAttr(string id, RefSqlPaging sqlPaging) { return(await WithConnection(async (connection) => { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Id", id, DbType.String); parameters.Add("@OFFSET", sqlPaging.OffSet, DbType.Int32); parameters.Add("@FETCH", sqlPaging.PageSize, DbType.Int32); var data = (await connection.QueryAsync <RCategoryAttr>(ProcName.Category_GetListAttr, parameters, commandType: CommandType.StoredProcedure)).ToArray(); if (data.Length > 0) { sqlPaging.TotalRow = data[0].TotalRow; } return data; })); }
public async Task <RActionDefine[]> Get(string group, string name, RefSqlPaging paging) { return(await WithConnection(async (connection) => { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Group", group, DbType.String); parameters.Add("@Name", name, DbType.String); parameters.Add("@OFFSET", paging.OffSet, DbType.Int32); parameters.Add("@FETCH", paging.PageSize, DbType.Int32); var data = (await connection.QueryAsync <RActionDefine>(ProcName.ActionDefine_Search, parameters, commandType: CommandType.StoredProcedure)).ToArray(); if (data.Length > 0) { paging.TotalRow = data[0].TotalRow; } return data; })); }
public async Task <RLanguage[]> Search(string name, RefSqlPaging paging) { return(await WithConnection(async (connection) => { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Name", name, DbType.String); parameters.Add("@OFFSET", paging.OffSet, DbType.Int32); parameters.Add("@FETCH", paging.PageSize, DbType.Int32); var data = await connection.QueryAsync <RLanguage>(ProcName.Language_Search, parameters, commandType: CommandType.StoredProcedure); var dataReturn = data.ToArray(); if (dataReturn.Length > 0) { paging.TotalRow = dataReturn[0].TotalRow; } return dataReturn; })); }
public async Task<TemplateSearchResponse> Search(TemplateSearchRequest request) { request.PageSize = ConfigSettingEnum.PageSizeDefault.GetConfig().AsInt(30); TemplateSearchResponse response = new TemplateSearchResponse(); try { RefSqlPaging paging = new RefSqlPaging(request.PageIndex, request.PageSize); var data = await _templateService.Search(request.Code, request.TemplateName, request.Status, paging); response.TotalRow = paging.TotalRow; response.Templates = data.Select(p => p.ToModel()).ToArray(); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return response; }
public async Task <DepartmentSearchResponse> Search(DepartmentSearchRequest request) { DepartmentSearchResponse response = new DepartmentSearchResponse(); try { RefSqlPaging sqlPaging = new RefSqlPaging(request.PageIndex, request.PageSize); RDepartment[] departments = await _roleService.DepartmentSearchFromDb(request.Name, request.Status, sqlPaging); response.TotalRow = sqlPaging.TotalRow; response.Departments = departments.Select(p => p.ToModel()).ToArray(); response.PageIndex = sqlPaging.PageIndex; response.PageSize = sqlPaging.PageSize; response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <VendorSearchResponse> Search(VendorSearchRequest request) { VendorSearchResponse response = new VendorSearchResponse(); try { RefSqlPaging paging = new RefSqlPaging(request.PageIndex, request.PageSize); var data = await _vendorService.Search(request.Code, request.Email, request.Phone, request.Name, request.Status, paging); response.TotalRow = paging.TotalRow; response.Vendors = data.Select(p => p.ToModel()).ToArray(); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <GiftCodeCampaignGetsResponse> GiftCodeCampaignGet(GiftCodeCampaignGetsRequest request) { GiftCodeCampaignGetsResponse response = new GiftCodeCampaignGetsResponse(); try { RefSqlPaging paging = new RefSqlPaging(request.PageIndex, request.PageSize); var data = await _giftcodeService.GiftCodeGetsFromDb(string.Empty, request.CampaignName, request.BeginDateValue, request.EndDateValue, request.Status, paging); response.TotalRow = paging.TotalRow; response.Campaigns = data.Select(p => p.ToModel()).ToArray(); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <LanguageSearchResponse> Search(LanguageSearchRequest request) { LanguageSearchResponse response = new LanguageSearchResponse(); try { RefSqlPaging paging = new RefSqlPaging(request.PageIndex, request.PageSize); var data = await _languageService.Search(request.Name, paging); response.TotalRow = paging.TotalRow; response.Languages = data.Select(p => p.ToModel()).ToArray(); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <ProductAttributeSearchResponse> Search(ProductAttributeSearchRequest request) { var response = new ProductAttributeSearchResponse(); try { var paging = new RefSqlPaging(request.PageIndex, request.PageSize); var data = await _productAttributeService.Search(request.AttributeId, request.AttributeName, paging); response.ProductAttributes = data.Select(x => x.ToModel()).ToArray(); response.TotalRow = paging.TotalRow; response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <CustomerSearchResponse> Search(CustomerSearchRequest request) { CustomerSearchResponse response = new CustomerSearchResponse(); try { RefSqlPaging paging = new RefSqlPaging(request.PageIndex, request.PageSize); var data = await _customerService.Search(request.Code, request.Email, request.Mobile, request.FullName, request.FromBirthdayValue, request.ToBirthDayValue, request.Type, request.Status, paging); response.TotalRow = paging.TotalRow; response.Customers = data.Select(p => p.ToModel()).ToArray(); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <EmailOrSmsSearchResponse> Search(EmailOrSmsSearchRequest request) { EmailOrSmsSearchResponse response = new EmailOrSmsSearchResponse(); RefSqlPaging paging = new RefSqlPaging(request.PageIndex, 30); try { RefSqlPaging sqlpaging = new RefSqlPaging(request.PageIndex, request.PageSize); var data = await _emailSmsService.Search(request.Type, request.MessageType, request.PhoneNumber, request.Email, request.Status, request.CreatedDateUtc, request.SendDate, sqlpaging); response.TotalRow = paging.TotalRow; response.EmailSmses = data.Select(p => p.ToModel()).ToArray(); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <TemplateConfigSearchResponse> Search(TemplateConfigSearchRequest request) { TemplateConfigSearchResponse response = new TemplateConfigSearchResponse(); try { if (string.IsNullOrEmpty(request.TemplateId)) { response.SetFail("Template not found!!!"); return(response); } var template = await _templateService.GetById(request.TemplateId); if (template == null) { response.SetFail("Template not found!!!"); return(response); } RefSqlPaging paging = new RefSqlPaging(request.PageIndex, request.PageSize); var data = await _templateService.SearchTemplateConfig(request.Id, request.TemplateId, request.ComponentType, request.Status, paging); response.TotalRow = paging.TotalRow; response.TemplateConfigs = data.Select(p => p.ToModel()).ToArray(); response.Template = template.ToModel(); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; response.SetSucess(); } catch (Exception e) { response.SetFail(e); _logger.LogError(e, e.Message, request); } return(response); }
public async Task <RWarehouse[]> Search(string venderId, string keyword, EnumDefine.WarehouseStatusEnum status, EnumDefine.WarehouseTypeEnum type, RefSqlPaging paging) { return(await WithConnection(async (connection) => { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@VendorId", venderId, DbType.String); parameters.Add("@Keyword", keyword, DbType.String); parameters.Add("@Status", status.AsEnumToInt(), DbType.Int16); parameters.Add("@Type", type.AsEnumToInt(), DbType.Int16); parameters.Add("@OFFSET", paging.OffSet, DbType.Int16); parameters.Add("@FETCH", paging.PageSize, DbType.Int16); var data = await connection.QueryAsync <RWarehouse>(ProcName.Warehouse_SearchByKeyword, parameters, commandType: CommandType.StoredProcedure); var dataReturn = data.ToArray(); if (dataReturn.Length > 0) { paging.TotalRow = dataReturn[0].TotalRow; } return dataReturn; })); }
public async Task <RBannerItem[]> SearchBannerItem(string id, string bannerItemName, string bannerId, EnumDefine.CommonStatusEnum status, bool isDefault, DateTimeRange startDate, DateTimeRange endDate, RefSqlPaging paging) { return(await _bannerItemRepository.Search(id, bannerItemName, bannerId, status, isDefault, startDate, endDate, paging)); }
public async Task <RBanner[]> SearchBanner(string id, string bannerName, EnumDefine.CommonStatusEnum bannerStatus, RefSqlPaging paging) { return(await _bannerRepository.Search(id, bannerName, bannerStatus, paging)); }
public async Task <RProductGroup[]> Search(string name, EnumDefine.CommonStatusEnum status, RefSqlPaging sqlPaging) { return(await _productGroupRepository.Search(name, status, sqlPaging)); }
public async Task <RProduct[]> SearchByCodeAndName(string keyword, EnumDefine.ProductStatus status, RefSqlPaging sqlPaging) { return(await _productRepository.SearchByCodeAndName(keyword, status, sqlPaging)); }
public async Task <RBannerItem[]> Search(string id, string bannerItemName, string bannerId, EnumDefine.CommonStatusEnum status, bool isDefault, DateTimeRange startDate, DateTimeRange endDate, RefSqlPaging paging) { return(await WithConnection(async (connection) => { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Id", string.IsNullOrEmpty(id) ? string.Empty : id, DbType.String); parameters.Add("@BannerItemName", string.IsNullOrEmpty(bannerItemName) ? string.Empty : bannerItemName, DbType.String); parameters.Add("@BannerId", string.IsNullOrEmpty(bannerId) ? string.Empty : bannerId, DbType.String); parameters.Add("@Status", status.AsEnumToInt(), DbType.Int16); parameters.Add("@IsDefault", isDefault, DbType.Boolean); parameters.Add("@StartDateUtcFrom", startDate.FromDate, DbType.DateTime); parameters.Add("@StartDateUtcTo", startDate.ToDate, DbType.DateTime); parameters.Add("@EndDateUtcFrom", endDate.FromDate, DbType.DateTime); parameters.Add("@EndDateUtcTo", endDate.ToDate, DbType.DateTime); parameters.Add("@OFFSET", paging.OffSet, DbType.Int32); parameters.Add("@FETCH", paging.PageSize, DbType.Int32); parameters.Add("@DeletedStatus", EnumDefine.CommonStatusEnum.Deleted.AsEnumToInt(), DbType.Int32); var data = await connection.QueryAsync <RBannerItem>(ProcName.BannerItem_Search, parameters, commandType: CommandType.StoredProcedure); var dataReturn = data.ToArray(); if (dataReturn.Length > 0) { paging.TotalRow = dataReturn[0].TotalRow; } return dataReturn; })); }
public async Task <RProductGroup[]> Search(string name, EnumDefine.CommonStatusEnum status, RefSqlPaging sqlPaging) { return(await WithConnection(async (connection) => { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Name", name, DbType.String); parameters.Add("@Status", status.AsEnumToInt(), DbType.Int32); parameters.Add("@DeleteStatus", EnumDefine.CommonStatusEnum.Deleted.AsEnumToInt(), DbType.Int32); parameters.Add("@OFFSET", sqlPaging.OffSet, DbType.Int32); parameters.Add("@FETCH", sqlPaging.PageSize, DbType.Int32); var data = await connection.QueryAsync <RProductGroup>(ProcName.ProductGroup_Search, parameters, commandType: CommandType.StoredProcedure); var dataReturn = data.ToArray(); if (dataReturn.Length > 0) { sqlPaging.TotalRow = dataReturn[0].TotalRow; } return dataReturn; })); }
public async Task <RProductAttributeValue[]> Search(string attributeId, string attributeValueId, string value, RefSqlPaging paging) { return(await WithConnection(async (connection) => { var parameters = new DynamicParameters(); parameters.Add("@AttributeId", attributeId, DbType.String); parameters.Add("@AttributeValueId", attributeValueId, DbType.String); parameters.Add("@Value", value, DbType.String); parameters.Add("@OffSet", paging.OffSet, DbType.Int32); parameters.Add("@PageSize", paging.PageSize, DbType.Int32); var data = await connection.QueryAsync <RProductAttributeValue>(ProcName.ProductAttributeValue_Search, parameters, commandType: CommandType.StoredProcedure); var dataReturn = data.ToArray(); if (dataReturn.Any()) { paging.TotalRow = dataReturn[0].TotalRow; } return dataReturn; })); }
public async Task <RProduct[]> SearchByCodeAndName(string keyword, EnumDefine.ProductStatus status, RefSqlPaging sqlPaging) { var datas = await WithConnection(async (connection) => { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Keyword", keyword, DbType.String); parameters.Add("@Status", status.AsEnumToInt(), DbType.Int32); parameters.Add("@OFFSET", sqlPaging.OffSet, DbType.String); parameters.Add("@FETCH", sqlPaging.PageSize, DbType.String); return(await connection.QueryAsync <RProduct>(ProcName.Product_SearchByCodeOrName, parameters, commandType: CommandType.StoredProcedure)); }); return(datas.ToArray()); }
public async Task <RCustomer[]> Search(string code, string email, string mobile, string fullName, DateTime?fromBirthday, DateTime?toBirthday, EnumDefine.CustomerTypeEnum type, EnumDefine.CustomerStatusEnum status, RefSqlPaging paging) { return(await WithConnection(async (connection) => { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Code", code, DbType.String); parameters.Add("@Email", email, DbType.String); parameters.Add("@PhoneNumber", mobile, DbType.String); parameters.Add("@FullName", fullName, DbType.String); parameters.Add("@FromBirthday", fromBirthday, DbType.String); parameters.Add("@ToBirthday", toBirthday, DbType.String); parameters.Add("@Type", type.AsEnumToInt(), DbType.String); parameters.Add("@Status", status.AsEnumToInt(), DbType.String); parameters.Add("@OFFSET", paging.OffSet, DbType.String); parameters.Add("@FETCH", paging.PageSize, DbType.String); var data = await connection.QueryAsync <RCustomer>(ProcName.Customer_Search, parameters, commandType: CommandType.StoredProcedure); var dataReturn = data.ToArray(); if (dataReturn.Length > 0) { paging.TotalRow = dataReturn[0].TotalRow; } return dataReturn; })); }