public B2CSearchBlock Fetch()
{
B2CSearchBlock b2CSearchBlock = new B2CSearchBlock();
_customerDataManagementContext.LoadStoredProc("dm.usp_B2CSearchBlock")
.ExecuteStoredProc((handler) =>
{
b2CSearchBlock.Roles = handler.ReadToList <Role>();
handler.NextResult();
b2CSearchBlock.Experience = handler.ReadToList <TotalExperience>();
handler.NextResult();
b2CSearchBlock.Country = handler.ReadToList <SearchCountry>();
handler.NextResult();
b2CSearchBlock.State = handler.ReadToList <SearchState>();
handler.NextResult();
b2CSearchBlock.City = handler.ReadToList <SearchCity>();
handler.NextResult();
b2CSearchBlock.Area = handler.ReadToList <SearchArea>();
handler.NextResult();
b2CSearchBlock.Age = handler.ReadToList <SearchAge>();
handler.NextResult();
b2CSearchBlock.Salary = handler.ReadToList <SearchSalary>();
handler.NextResult();
b2CSearchBlock.Tags = handler.ReadToList <BToCTags>();
});
return(b2CSearchBlock);
}
public CustomerDataSearchBlock Fetch()
{
CustomerDataSearchBlock customerDataSearchBlock = new CustomerDataSearchBlock();
_customerDataManagementContext.LoadStoredProc("dm.usp_CDSearchBlock")
.ExecuteStoredProc((handler) =>
{
customerDataSearchBlock.Country = handler.ReadToList <SearchCountry>();
handler.NextResult();
customerDataSearchBlock.State = handler.ReadToList <SearchState>();
handler.NextResult();
customerDataSearchBlock.City = handler.ReadToList <SearchCity>();
handler.NextResult();
customerDataSearchBlock.Network = handler.ReadToList <SearchNetwork>();
handler.NextResult();
customerDataSearchBlock.BusinessVertical = handler.ReadToList <SearchBusinessVertical>();
handler.NextResult();
customerDataSearchBlock.CustomerName = handler.ReadToList <SearchCustomerName>();
handler.NextResult();
customerDataSearchBlock.DataQuality = handler.ReadToList <SearchDataQuality>();
handler.NextResult();
customerDataSearchBlock.Tags = handler.ReadToList <CustomerTags>();
});
return(customerDataSearchBlock);
}
public IEnumerable<SelectListItem> Get()
{
IList<Role> roles;
IList<TotalExperience> experence;
IList<SearchCountry> country;
IList<SearchState> state;
IList<SearchCity> city;
IList<SearchArea> area;
IList<SearchSalary> salary;
IList<SearchAge> age;
IList<BToCTags> tags;
_customerDataManagementContext.LoadStoredProc("dm.usp_B2CSearchBlock")
.ExecuteStoredProc((handler) =>
{
roles = handler.ReadToList<Role>();
handler.NextResult();
experence = handler.ReadToList<TotalExperience>();
handler.NextResult();
country = handler.ReadToList<SearchCountry>();
handler.NextResult();
state = handler.ReadToList<SearchState>();
handler.NextResult();
city = handler.ReadToList<SearchCity>();
handler.NextResult();
area = handler.ReadToList<SearchArea>();
handler.NextResult();
age = handler.ReadToList<SearchAge>();
handler.NextResult();
salary = handler.ReadToList<SearchSalary>();
handler.NextResult();
tags = handler.ReadToList<BToCTags>();
});
var area1 = _customerDataManagementContext.BusinessToCustomer
.Select(x => x.City.Trim())
.Distinct<string>()
.OrderBy(x => x).ToArray();
return area1.Where(x => !string.IsNullOrWhiteSpace(x)).Select(x =>
new SelectListItem()
{
Value = x,
Text = x
}).AsEnumerable<SelectListItem>();
}
public B2BSearchBlock Fetch()
{
B2BSearchBlock b2BSearchBlock = new B2BSearchBlock();
_customerDataManagementContext.LoadStoredProc("dm.usp_B2BSearchBlock")
.ExecuteStoredProc((handler) =>
{
b2BSearchBlock.Country = handler.ReadToList <SearchCountry>();
handler.NextResult();
b2BSearchBlock.State = handler.ReadToList <SearchState>();
handler.NextResult();
b2BSearchBlock.City = handler.ReadToList <SearchCity>();
handler.NextResult();
b2BSearchBlock.Area = handler.ReadToList <SearchArea>();
handler.NextResult();
b2BSearchBlock.BusinessCategory = handler.ReadToList <BusinessCategory>();
handler.NextResult();
b2BSearchBlock.Desigination = handler.ReadToList <SearchDesigination>();
handler.NextResult();
b2BSearchBlock.Tags = handler.ReadToList <BToBTags>();
});
return(b2BSearchBlock);
}