public HttpResponseMessage ListAllServices()
{
// list services for policy id
ServiceDBConnect serviceDBConnect = new ServiceDBConnect();
var serv = from s in serviceDBConnect.Services
select s;
List <Service> services = new List <Service>();
foreach (var item in serv)
{
services.Add(item);
}
if (services.Count > 0)
{
string output = JsonConvert.SerializeObject(services);
return(new HttpResponseMessage()
{
Content = new StringContent(output, Encoding.UTF8, "application/json"),
StatusCode = HttpStatusCode.Created
});
}
else
{
return(new HttpResponseMessage()
{
StatusCode = HttpStatusCode.NotFound
});
}
}
// not done this way in prod!
public void LoadServices()
{
ServiceDBConnect serviceDBConnect = new ServiceDBConnect();
var v = from s in serviceDBConnect.Services
select s;
if (v.ToList().Count > 0)
{
return;
}
Service[] services = new Service[] {
new Service {
Id = 1, PolicyId = 1, ServiceName = "X Ray"
},
new Service {
Id = 2, PolicyId = 1, ServiceName = "Exam"
},
new Service {
Id = 3, PolicyId = 2, ServiceName = "Exam"
},
new Service {
Id = 4, PolicyId = 3, ServiceName = "Exam"
}
};
serviceDBConnect.Services.AddRange(services);
serviceDBConnect.SaveChanges();
}
public void SetUpServices()
{
// not best practice but for demo purposes.
ServiceDBConnect context = new ServiceDBConnect();
Service[] array = new Service[]
{
new Service {
Id = 1, PolicyID = 1, ServiceName = "Medical Exam"
},
new Service {
Id = 2, PolicyID = 1, ServiceName = "X Ray"
},
new Service {
Id = 1, PolicyID = 2, ServiceName = "Medical Exam"
},
new Service {
Id = 2, PolicyID = 2, ServiceName = "X Ray"
},
new Service {
Id = 3, PolicyID = 2, ServiceName = "Check Up"
},
new Service {
Id = 4, PolicyID = 2, ServiceName = "Some Procedure"
}
};
context.Services.AddRange(array);
context.SaveChanges();
}
public List <SelectListItem> PopulateServices()
{
// find policy id in customer database and look up services in the service database.
var custID = Session["CustomerID"].ToString();
CustomerDBConnect customerDBConnect = new CustomerDBConnect();
var pol = from c in customerDBConnect.Customers
where custID == c.CustomerID
select c;
int policyID = 0;
foreach (var p in pol)
{
policyID = p.PoicyID;
}
if (policyID == 0)
{
return(null); // no policy set
}
List <SelectListItem> items = new List <SelectListItem>();
ServiceDBConnect serviceDBConnect = new ServiceDBConnect();
var serviceList = from service in serviceDBConnect.Services
where policyID == service.PolicyID
select service;
foreach (var s in serviceList)
{
SelectListItem item = new SelectListItem();
item.Value = s.ServiceName;
item.Text = s.ServiceName;
items.Add(item);
}
return(items);
}
