public DataResponse <EntityList <EntityColumnLookup> > GetReportColumnLookup(FilterServices filter, int?ReportColumnId, int currentBusineId, int take = 10, int skip = 0)
{
var response = new DataResponse <EntityList <EntityColumnLookup> >();
try
{
if (filter != null)
{
take = filter.Take;
skip = filter.Skip;
}
base.DBInit();
var query = DBEntity.LookupServiceColumns.Where(a => a.ColumnId == ReportColumnId);
if (filter != null)
{
if (!String.IsNullOrEmpty(filter.KeyWords))
{
query = query.Where(a => a.Text.ToLower().Contains(filter.KeyWords));
}
}
var selectQuery = query.Select(a => new EntityColumnLookup
{
Id = a.Id,
Text = a.Text,
CreatedBy = a.CreatedBy,
CreatedOn = a.CreatedOn,
UpdatedBy = a.UpdatedBy,
UpdatedOn = a.UpdatedOn,
ColumnId = a.ColumnId,
ColumnName = a.ReportColumn.ColumnName,
CreatedByName = a.User.FirstName + " " + a.User.LastName,
UpdatedByName = a.User1.FirstName + " " + a.User1.LastName
});
if (string.IsNullOrEmpty(filter.SortKey) || string.IsNullOrEmpty(filter.SortOrder))
{
selectQuery = selectQuery.OrderByDescending(o => o.CreatedOn);
}
else
{
string orderBy = string.Format("{0} {1}", filter.SortKey, filter.SortOrder);
selectQuery = selectQuery.OrderBy(orderBy);
}
response = GetList <EntityColumnLookup>(selectQuery, skip, take);
}
catch (Exception ex)
{
ex.Log();
}
finally
{
base.DBClose();
}
return(response);
}
public IHttpActionResult GetAll(FilterServices filter)
{
if (filter == null)
{
filter = new FilterServices();
filter.PageSize = 25;
filter.CurrentPage = 1;
}
var response = repository.GetServices(filter, CurrentBusinessId);
return(Ok <DataResponse <EntityList <EntityServices> > >(response));
}
public async Task <IActionResult> FilterServices([FromBody] FilterServices filterServices)
{
var result = await _repository.FilterServicesAsync(filterServices);
var searchResultList = new List <ServiceSearchResults>();
foreach (var data in result)
{
decimal totalReviewPoint = 0;
var counter = 0;
var serviceDetails = await _repository.GetServiceAsync(data.Id);
var serviceLocationDetails = await _locationRepository.GetServiceCurrentLocationAsync(data.Id);
var searchResult = new ServiceSearchResults();
searchResult.Id = data.Id;
searchResult.Title = serviceDetails.Title;
searchResult.RiderPerVessel = serviceDetails.RiderPerVessel;
searchResult.Quantity = serviceDetails.Quantity;
searchResult.IsActive = serviceDetails.IsActive;
searchResult.IsDeleted = serviceDetails.IsDeleted;
searchResult.IsOnRide = serviceDetails.IsOnRide;
searchResult.Rate = data.Rate;
searchResult.ServiceProviderId = data.ServiceProviderId;
searchResult.StreetAddress = data.StreetAddress;
searchResult.City = data.City;
searchResult.State = data.State;
searchResult.PostalCode = data.PostalCode;
searchResult.Longitude = serviceLocationDetails.Longitude;
searchResult.Latitude = serviceLocationDetails.Latitude;
searchResult.ReviewComments = new List <string>();
var reviewDetails = await _serviceReviewRepository.GetReviews(data.Id);
var serviceReviews = reviewDetails as ServiceReview[] ?? reviewDetails.ToArray();
if (Enumerable.Count(serviceReviews) > 0)
{
foreach (var review in serviceReviews)
{
searchResult.ReviewComments.Add(review.Comments);
totalReviewPoint = totalReviewPoint + review.RatingPoint;
counter++;
}
searchResult.AvgRatingsPoint = totalReviewPoint / counter;
}
searchResultList.Add(searchResult);
}
return(Ok(searchResultList));
}
public async Task <IEnumerable <Service> > FilterServicesAsync(FilterServices filterService)
{
var serviceCatagoryTbl = new DataTable("ServiceCatagoriesType");
serviceCatagoryTbl.Columns.Add("ServiceCatagoryId", typeof(int));
var filterResultList = new List <Service>();
foreach (var serviceCatagory in filterService.ServiceCatagoryIds)
{
serviceCatagoryTbl.Rows.Add(Convert.ToInt32(serviceCatagory));
}
var filterDatesTbl = new DataTable("FilterDateRangeTable");
filterDatesTbl.Columns.Add("dates");
for (var day = filterService.StartDate; day <= filterService.EndDate; day = day.AddDays(1))
{
filterDatesTbl.Rows.Add(day);
}
var connection = _context.Database.GetDbConnection();
await connection.OpenAsync();
var command = connection.CreateCommand();
command.CommandText = "SEARCH_NEAREST_SERVICES";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@serviceTypeId", filterService.ServiceTypeId));
command.Parameters.Add(new SqlParameter("@serviceCatagoryTempTable", serviceCatagoryTbl));
command.Parameters.Add(new SqlParameter("@distance", filterService.Distance));
command.Parameters.Add(new SqlParameter("@Longitude", filterService.Longitude));
command.Parameters.Add(new SqlParameter("@latitude", filterService.Latitude));
command.Parameters.Add(new SqlParameter("@datesTempTable", filterDatesTbl));
var dr = await command.ExecuteReaderAsync();
while (dr.Read())
{
var s = new Service {
Id = Convert.ToInt32(dr["ServiceId"])
};
filterResultList.Add(s);
}
dr.Close();
return(filterResultList);
}
public IHttpActionResult GetByFilter(FilterServices filter)
{
var repository = new RepositoryEnrolledServices();
if (filter == null)
{
filter = new FilterServices {
PageSize = 25, CurrentPage = 1
}
}
;
var response = repository.GetServices(filter, CurrentBusinessId.Value);
return(Ok <DataResponse <EntityList <EntityServices> > >(response));
}
public BuiltFilterModel(FilterServices service)
{
FilterModelManager = ServiceLocator.Current.GetInstance <IFilterModelManagerService>(service.ToString());
Initialize();
}
public DataResponse <EntityList <EntityReportColumn> > GetReportColumns(FilterServices filter, int?ServiceId, int currentBusineId, int take = 10, int skip = 0)
{
var response = new DataResponse <EntityList <EntityReportColumn> >();
try
{
if (filter != null)
{
take = filter.Take;
skip = filter.Skip;
}
base.DBInit();
var query = DBEntity.ReportColumns.Where(a => a.BusinessId == currentBusineId && a.LookupEnrolledService.Id == ServiceId && a.LookupEnrolledService.BusinessId == currentBusineId);
if (filter != null)
{
if (!String.IsNullOrEmpty(filter.KeyWords))
{
query = query.Where(a => a.ColumnName.ToLower().Contains(filter.KeyWords));
}
}
var selectQuery = query.Select(a => new EntityReportColumn
{
Id = a.Id,
ColumnName = a.ColumnName,
DisplayInFilter = a.DisplayInFilter,
DisplayName = a.DisplayName,
IsMandatory = a.IsMandatory,
ShowInGrid = a.ShowInGrid,
ColumnType = a.ColumnType,
InputType = a.InputType,
ServiceId = a.ServiceId,
CreatedBy = a.CreatedBy,
CreatedOn = a.CreatedOn,
UpdatedBy = a.UpdatedBy,
UpdatedOn = a.UpdatedOn,
BusinessId = a.BusinessId,
ServiceName = a.LookupEnrolledService.ServiceName,
CreatedByName = a.User.FirstName + " " + a.User.LastName,
UpdatedByName = a.User1.FirstName + " " + a.User1.LastName,
RolePrivilegeIds = a.SalesRolePrivileges.Select(b => b.Id).ToList(),
DepartmentPrivilegeIds = a.SalesDepartmentPrivileges.Select(b => b.Id).ToList(),
UserPrivilegeIds = a.SalesUserPrivileges.Select(b => b.Id).ToList()
});
if (string.IsNullOrEmpty(filter.SortKey) || string.IsNullOrEmpty(filter.SortOrder))
{
selectQuery = selectQuery.OrderByDescending(o => o.CreatedOn);
}
else
{
string orderBy = string.Format("{0} {1}", filter.SortKey, filter.SortOrder);
selectQuery = selectQuery.OrderBy(orderBy);
}
response = GetList <EntityReportColumn>(selectQuery, skip, take);
}
catch (Exception ex)
{
ex.Log();
}
finally
{
base.DBClose();
}
return(response);
}
public DataResponse <EntityList <EntityServices> > GetServices(FilterServices filter, int?currentBusineId, int take = 10, int skip = 0)
{
var response = new DataResponse <EntityList <EntityServices> >();
try
{
if (filter != null)
{
take = filter.Take;
skip = filter.Skip;
}
base.DBInit();
var query = DBEntity.LookupEnrolledServices.Where(a => a.BusinessId == currentBusineId);
if (filter != null)
{
if (!String.IsNullOrEmpty(filter.KeyWords))
{
query = query.Where(a => a.ServiceName.ToLower().Contains(filter.KeyWords));
}
}
var selectQuery = query.Select(a => new EntityServices
{
Id = a.Id,
ServiceName = a.ServiceName,
ServiceDecription = a.ServiceDecription,
ServiceColor = a.ServiceColor,
CreatedBy = a.CreatedBy,
CreatedOn = a.CreatedOn,
UpdatedBy = a.UpdatedBy,
UpdatedOn = a.UpdatedOn,
BusinessId = a.BusinessId,
IsActive = a.IsActive,
OldId = a.OldId,
Status = a.Status,
ImportMode = a.ImportMode,
CreatedByName = a.User.FirstName + " " + a.User.LastName,
UpdatedByName = a.User1.FirstName + " " + a.User1.LastName,
});
if (string.IsNullOrEmpty(filter.SortKey) || string.IsNullOrEmpty(filter.SortOrder))
{
selectQuery = selectQuery.OrderByDescending(o => o.CreatedOn);
}
else
{
string orderBy = string.Format("{0} {1}", filter.SortKey, filter.SortOrder);
selectQuery = selectQuery.OrderBy(orderBy);
}
response = GetList <EntityServices>(selectQuery, skip, take);
}
catch (Exception ex)
{
ex.Log();
}
finally
{
base.DBClose();
}
return(response);
}
public IHttpActionResult GetAllReportColumnLookup(int?reportcolumnid, FilterServices filter)
{
var response = repository.GetReportColumnLookup(filter, reportcolumnid, CurrentBusinessId.Value);
return(Ok <DataResponse <EntityList <EntityColumnLookup> > >(response));
}
public IHttpActionResult GetAllServiceReportColumns(int?ServiceId, FilterServices filter)
{
var response = repository.GetReportColumns(filter, ServiceId, CurrentBusinessId.Value);
return(Ok <DataResponse <EntityList <EntityReportColumn> > >(response));
}
