public string GetProvidersFromApi()
{
ProviderFilter providerFilter = new ProviderFilter()
{
};
ProviderFieldsToReturn providerFieldsToReturn = new ProviderFieldsToReturn();
GetProvidersResp response = null;
GetProvidersReq request = new GetProvidersReq()
{
RequestHeader = _requestHeader,
Filter = providerFilter,
Fields = providerFieldsToReturn
};
response = _kareoServices.GetProviders(request);
if (response.ErrorResponse.IsError)
{
return(response.ErrorResponse.ErrorMessage);
}
if (response.Providers == null || response.Providers.Length == 0)
{
return("No results. Check Customer Key is valid in .config file.");
}
List <ProviderData> responseData = response.Providers.ToList();
// Only export active providers
var data = responseData.Where(p => p.Active == "True").ToList();
return(ExportProviders(data));
}
public void TestGetSource_SheetNotFoundException()
{
const string fileName = "./Internal Resources/sample.xls";
var filter = new ProviderFilter();
filter.FileName = fileName;
filter.SheetName = "Sheet1";
IProvider provider = new NPOIProvider(filter);
var dataTable = provider.GetSource();
}
public void TestInstance()
{
var filter = new ProviderFilter();
filter.FileName = ExcelFileName;
IProvider viewProvider = new NPOIProvider(filter);
IProvider workProvider = new NPOIProvider(filter);
Worker worker = new Worker(viewProvider, workProvider, PythonFileName);
}
public void TestGetSource_SheetNotFoundException()
{
const string fileName = "./Internal Resources/sample.xls";
var filter = new ProviderFilter();
filter.FileName = fileName;
filter.SheetName = "Sheet1";
IProvider provider = new NPOIProvider(filter);
var dataTable = provider.GetSource();
}
public void TestDo()
{
var filter = new ProviderFilter();
filter.FileName = ExcelFileName;
filter.SetColumnType = true;
IProvider viewProvider = new NPOIProvider(filter);
IProvider workProvider = new NPOIProvider(filter);
Worker worker = new Worker(viewProvider, workProvider, PythonFileName);
worker.DataTableBefore += new SetDataTableBefore(worker_DataTableBefore);
worker.DataTableAfter += new SetDataTableAfter(worker_DataTableAfter);
worker.Do();
}
public void TestGetSource()
{
const string fileName = "./Internal Resources/sample.xls";
var filter = new ProviderFilter();
filter.FileName = fileName;
filter.SheetName = "Лист1";
IProvider provider = new NPOIProvider(filter);
var dataTable = provider.GetSource();
Assert.That(dataTable.Columns.Count, Is.EqualTo(2));
Assert.That(dataTable.Columns[0].ColumnName, Is.EqualTo("A"));
Assert.That(dataTable.Columns[1].ColumnName, Is.EqualTo("B"));
Assert.That(dataTable.Rows.Count, Is.EqualTo(6));
}
private static ProviderStatus MapProviderFilter(ProviderFilter filter)
{
switch (filter)
{
case ProviderFilter.Active:
return(ProviderStatus.Active);
case ProviderFilter.Inactive:
return(ProviderStatus.Inactive);
case ProviderFilter.Potential:
return(ProviderStatus.Potential);
default:
throw new InvalidProgramException();
}
}
public void TestGetSource()
{
const string fileName = "./Internal Resources/sample.xls";
var filter = new ProviderFilter();
filter.FileName = fileName;
filter.SheetName = "Лист1";
IProvider provider = new NPOIProvider(filter);
var dataTable = provider.GetSource();
Assert.That(dataTable.Columns.Count, Is.EqualTo(2));
Assert.That(dataTable.Columns[0].ColumnName, Is.EqualTo("A"));
Assert.That(dataTable.Columns[1].ColumnName, Is.EqualTo("B"));
Assert.That(dataTable.Rows.Count, Is.EqualTo(6));
}
public IEnumerable <ProvidersListItemVM> GetProviderListItems(ProviderFilter filter)
{
var results = ProviderSearchService.GetAll();
switch (filter)
{
case ProviderFilter.All:
break;
case ProviderFilter.AllExceptInactive:
results = results.Where(x => x.Status != ProviderStatus.Inactive);
break;
default:
var providerStatus = MapProviderFilter(filter);
results = results.Where(x => x.Status == providerStatus);
break;
}
return(results.OrderBy(p => p.LastName));
}
public ActionResult ExternalLoginCallback(string returnUrl)
{
AuthenticationResult result = OAuthWebSecurity.VerifyAuthentication(Url.Action("ExternalLoginCallback", new { ReturnUrl = returnUrl }));
if (!result.IsSuccessful)
{
return(RedirectToAction("ExternalLoginFailure"));
}
if (!ProviderFilter.IsAllowed(result))
{
return(View("ProviderNotAllowed"));
}
if (OAuthWebSecurity.Login(result.Provider, result.ProviderUserId, createPersistentCookie: false))
{
return(RedirectToLocal(returnUrl));
}
if (User.Identity.IsAuthenticated)
{
// If the current user is logged in add the new account
OAuthWebSecurity.CreateOrUpdateAccount(result.Provider, result.ProviderUserId, User.Identity.Name);
return(RedirectToLocal(returnUrl));
}
else
{
// User is new, ask for their desired membership name
string loginData = OAuthWebSecurity.SerializeProviderUserId(result.Provider, result.ProviderUserId);
ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(result.Provider).DisplayName;
ViewBag.ReturnUrl = returnUrl;
return(View("ExternalLoginConfirmation", new RegisterExternalLoginModel {
UserName = result.UserName, ExternalLoginData = loginData
}));
}
}
public void TestInstance()
{
var filter = new ProviderFilter();
IProvider provider = new NPOIProvider(filter);
}
public void TestInstance()
{
var filter = new ProviderFilter();
IProvider provider = new NPOIProvider(filter);
}
public Paged <ProviderFilter> QueryProviders(int pageIndex, int pageSize, float latitude, float longitude, string json, int radius)
{
Paged <ProviderFilter> pagedResult = null;
List <ProviderFilter> result = null;
int totalCount = 0;
_data.ExecuteCmd("[dbo].[UserProfiles_Filter_V2]", inputParamMapper : delegate(SqlParameterCollection parameterCollection)
{
parameterCollection.AddWithValue("@PageIndex", pageIndex);
parameterCollection.AddWithValue("@PageSize", pageSize);
parameterCollection.AddWithValue("@Latitude", latitude);
parameterCollection.AddWithValue("@Longitude", longitude);
parameterCollection.AddWithValue("@JSON", json);
parameterCollection.AddWithValue("@Radius", radius);
},
singleRecordMapper : delegate(IDataReader reader, short set)
{
ProviderFilter providerfilter = new ProviderFilter();
int index = 0;
providerfilter.Id = reader.GetSafeInt32(index++);
providerfilter.UserId = reader.GetSafeInt32(index++);
providerfilter.FirstName = reader.GetSafeString(index++);
providerfilter.LastName = reader.GetSafeString(index++);
providerfilter.Mi = reader.GetSafeString(index++);
providerfilter.AvatarUrl = reader.GetSafeString(index++);
providerfilter.DateCreated = reader.GetSafeDateTime(index++);
providerfilter.DateModified = reader.GetSafeDateTime(index++);
providerfilter.Phone = reader.DeserializeObject <List <PhoneNumber> >(index++);
providerfilter.Title = reader.GetSafeString(index++);
providerfilter.Summary = reader.GetSafeString(index++);
providerfilter.Bio = reader.GetSafeString(index++);
providerfilter.Price = reader.GetSafeDecimal(index++);
providerfilter.IsActive = reader.GetSafeBool(index++);
providerfilter.Certifications = reader.DeserializeObject <List <Certification> >(index++);
providerfilter.Expertise = reader.DeserializeObject <List <TwoColumn> >(index++);
providerfilter.Licenses = reader.DeserializeObject <List <License> >(index++);
providerfilter.Languages = reader.DeserializeObject <List <TwoColumn> >(index++);
providerfilter.Locations = reader.DeserializeObject <List <Loc> >(index++);
providerfilter.CareNeeds = reader.DeserializeObject <List <TwoColumn> >(index++);
providerfilter.Concerns = reader.DeserializeObject <List <TwoColumn> >(index++);
providerfilter.Ratings = reader.DeserializeObject <List <Rating> >(index++);
providerfilter.AverageRating = reader.GetSafeDecimal(index++);
providerfilter.HelperNeeds = reader.DeserializeObject <List <TwoColumn> >(index++);
providerfilter.ExperienceDetails = reader.DeserializeObject <List <Experience> >(index++);
providerfilter.Distance = reader.GetSafeDouble(index++);
if (totalCount == 0)
{
totalCount = reader.GetSafeInt32(index++);
}
if (result == null)
{
result = new List <ProviderFilter>();
}
result.Add(providerfilter);
}
);
if (result != null)
{
pagedResult = new Paged <ProviderFilter>(result, pageIndex, pageSize, totalCount);
}
return(pagedResult);
}
