public SpecialistNearbyViewModel SpecialistSearch(SpecialistNearbyViewModel specialistvm)
{
SpecialistNearbyViewModel result = new SpecialistNearbyViewModel();
try
{
if (String.IsNullOrEmpty(specialistvm.SearchText))
{
specialistvm.SearchText = "All";
}
if (String.IsNullOrEmpty(specialistvm.PostalCode))
{
specialistvm.PostalCode = "All";
}
PatientData dataLayer = new PatientData();
result = dataLayer.SpecialistSearch(specialistvm);
if (result != null)
{
new LogHelper().LogMessage("PatientBusiness.SpecialistSearch : " + "Success");
}
}
catch (Exception err)
{
new LogHelper().LogMessage("PatientBusiness.PatientLogin : " + err);
}
return(result);
}
public List <SpecialistNearby> SpecialistSearch(SpecialistNearbyViewModel speacialistvm)
{
SpecialistNearbyViewModel result = new SpecialistNearbyViewModel();
PatientBusiness businessLayer = new PatientBusiness();
result = businessLayer.SpecialistSearch(speacialistvm);
return(result.ResultTable);
}
public List <SpecialistNearby> SpecialistSearch(SpecialistNearbyViewModel speacialistvm)
{
var client = new RestClient(ConstantHelper.AppSettings.BackEndUrl);
RestRequest request = new RestRequest(ConstantHelper.API.Patient.SpecialistSearch, Method.POST);
request.RequestFormat = DataFormat.Json;
request.AddBody(speacialistvm);
IRestResponse <List <SpecialistNearby> > response = client.Execute <List <SpecialistNearby> >(request);
List <SpecialistNearby> result = response.Data;
return(result);
}
public SpecialistNearbyViewModel SpecialistSearch(SpecialistNearbyViewModel vm)
{
SpecialistNearbyViewModel result = new SpecialistNearbyViewModel();
try
{
SqlConnection conn = new SqlConnection(ConstantHelper.DBAppSettings.FYP);
conn.Open();
SqlCommand cmd = new SqlCommand(ConstantHelper.StoredProcedure.SpecialistSearch, conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter(ConstantHelper.StoredProcedure.Parameter.SearchText, vm.SearchText));
cmd.Parameters.Add(new SqlParameter(ConstantHelper.StoredProcedure.Parameter.Specialist, vm.SpecialistSelected));
cmd.Parameters.Add(new SqlParameter(ConstantHelper.StoredProcedure.Parameter.State, vm.StateSelected.ToString()));
cmd.Parameters.Add(new SqlParameter(ConstantHelper.StoredProcedure.Parameter.PostalCode, vm.PostalCode));
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
SpecialistNearby specialist = new SpecialistNearby();
specialist.AccId = Guid.Parse(reader[ConstantHelper.SQLColumn.SpecialistSearch.Id].ToString());
specialist.SpecialistName = reader[ConstantHelper.SQLColumn.SpecialistSearch.SpecialistName].ToString();
specialist.SpecialistType = reader[ConstantHelper.SQLColumn.SpecialistSearch.Specialist].ToString();
specialist.CompanyName = reader[ConstantHelper.SQLColumn.SpecialistSearch.CompanyName].ToString();
specialist.CompanyAddressLine1 = reader[ConstantHelper.SQLColumn.SpecialistSearch.CompanyAddressLine1].ToString();
specialist.CompanyAddressLine2 = reader[ConstantHelper.SQLColumn.SpecialistSearch.CompanyAddressLine2].ToString();
specialist.CompanyAddressLine3 = reader[ConstantHelper.SQLColumn.SpecialistSearch.CompanyAddressLine3].ToString();
specialist.CompanyPhoneNumber = reader[ConstantHelper.SQLColumn.SpecialistSearch.CompanyPhoneNumber].ToString();
specialist.PostalCode = Convert.ToInt32(reader[ConstantHelper.SQLColumn.SpecialistSearch.PostalCode].ToString());
specialist.City = reader[ConstantHelper.SQLColumn.SpecialistSearch.City].ToString();
specialist.State = reader[ConstantHelper.SQLColumn.SpecialistSearch.State].ToString();
result.ResultTable.Add(specialist);
////place data accordingly
//SpecialistNearby specialist = new SpecialistNearby();
//result.ResultTable.Add(specialist);
}
}
catch (Exception err)
{
new LogHelper().LogMessage("PatientData.SpecialistSearch : " + err);
}
return(result);
}
public ActionResult SpecialistNearby(string searchText, int specialist, int state, string postalCode)
{
var selectedSpecialist = (Specialist)specialist;
var selectedState = (State)state;
SpecialistNearbyViewModel specialistvm = new SpecialistNearbyViewModel();
specialistvm.SearchText = searchText; //Search Text
specialistvm.SpecialistSelected = selectedSpecialist.ToString(); //Specialist
specialistvm.StateSelected = selectedState.ToString(); //State
specialistvm.PostalCode = postalCode; //Posstal Code
SpecialistNearbyViewModel result = new SpecialistNearbyViewModel();
PatientProcess process = new PatientProcess();
result.ResultTable = process.SpecialistSearch(specialistvm);
return(Json(result, JsonRequestBehavior.AllowGet));
}
