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;
}));
}