public HttpResponseMessage ListAllPolicies() { PolicyLoader(); List <Policy> policyList = new List <Policy>(); PolicyDBConnect policyDBConnect = new PolicyDBConnect(); var pol = from p in policyDBConnect.Policies select p; foreach (var item in pol) { policyList.Add(item); } if (policyList.Count > 0) { string output = JsonConvert.SerializeObject(policyList); return(new HttpResponseMessage() { Content = new StringContent(output, Encoding.UTF8, "application/json"), StatusCode = HttpStatusCode.Created }); } else { return(new HttpResponseMessage() { StatusCode = HttpStatusCode.NotFound }); } }
public HttpResponseMessage ReadPolicy(int id) { // Read Policy PolicyDBConnect policyDBConnect = new PolicyDBConnect(); var pol = from p in policyDBConnect.Policies where p.Id == id select p; Policy po = new Policy(); foreach (var p in pol) { po.Id = p.Id; po.Copay = p.Copay; po.Deductible = p.Deductible; po.Rate = p.Rate; po.Type = p.Type; po.Name = p.Name; } if (po != null) { string output = JsonConvert.SerializeObject(po); return(new HttpResponseMessage() { Content = new StringContent(output, Encoding.UTF8, "application/json"), StatusCode = HttpStatusCode.Created }); } else { return(new HttpResponseMessage() { StatusCode = HttpStatusCode.NotFound }); } }
public HttpResponseMessage UpdatePolicy([FromBody] Policy policy) { // Update Policy PolicyDBConnect policyDBConnect = new PolicyDBConnect(); Policy pi = null; var pol = from p in policyDBConnect.Policies where p.Id == policy.Id select p; foreach (var item in pol) { item.Name = policy.Name; item.Rate = policy.Rate; item.Deductible = policy.Deductible; item.Copay = policy.Copay; } policyDBConnect.SaveChanges(); string output = JsonConvert.SerializeObject(pi); return(new HttpResponseMessage() { Content = new StringContent(output, Encoding.UTF8, "application/json"), StatusCode = HttpStatusCode.Created }); }
public void PolicyLoader() { PolicyDBConnect policyDBConnect = new PolicyDBConnect(); var v = from p in policyDBConnect.Policies select p; if (v.ToList().Count > 0) { return; } Policy[] policies = new Policy[] { new Policy { Id = 1, Copay = 20, Deductible = 40, Name = "Standard", Rate = 250, Type = "Medical" }, new Policy { Id = 2, Copay = 40, Deductible = 60, Name = "Excellent", Rate = 300, Type = "Medical" }, new Policy { Id = 3, Copay = 50, Deductible = 80, Name = "Best", Rate = 350, Type = "Medical" } }; policyDBConnect.Policies.AddRange(policies); policyDBConnect.SaveChanges(); }
public ActionResult PolicySearch(PolicySearch policysearch) { if (!ModelState.IsValid) { return(View()); } PolicyDBConnect context = new PolicyDBConnect(); bool all = (policysearch.PolicyName == null) ? true : false; if (all) { var pol = from p in context.Policies select p; policysearch.policies = pol.ToList(); } else { var pol = from p in context.Policies where p.PolicyName.StartsWith(policysearch.PolicyName) select p; policysearch.policies = pol.ToList(); } return(View(policysearch)); }
public ActionResult AddPolicy(Policy policy) { if (!ModelState.IsValid) { return(View()); } PolicyDBConnect context = new PolicyDBConnect(); context.Policies.Add(policy); context.SaveChanges(); ViewBag.Message = "Policy " + policy.PolicyName + " added."; return(View()); }
public HttpResponseMessage AddPolcy([FromBody] Policy policy) { // Add Policy PolicyDBConnect policyDBConnect = new PolicyDBConnect(); policyDBConnect.Policies.Add(policy); policyDBConnect.SaveChanges(); string output = JsonConvert.SerializeObject(policy); return(new HttpResponseMessage() { Content = new StringContent(output, Encoding.UTF8, "application/json"), StatusCode = HttpStatusCode.Created }); }
public void SetUpPolicies() { // not best practice but for demo purposes. PolicyDBConnect context = new PolicyDBConnect(); Policy[] array = new Policy[] { new Policy { PolicyID = 1, Copay = 200, Deductible = 500, PolicyName = "Standard", Rate = 250, PolicyType = "Medical" }, new Policy { PolicyID = 2, Copay = 20, Deductible = 100, PolicyName = "Excellent", Rate = 150, PolicyType = "Medical" } }; context.Policies.AddRange(array); context.SaveChanges(); }
public List <SelectListItem> UtilityPolicySearch() { // produces item list of policies in system // used in assign policy screen and policy search screens. List <SelectListItem> a = new List <SelectListItem>(); PolicyDBConnect context = new PolicyDBConnect(); var list = from p in context.Policies select p; foreach (var p in list) { SelectListItem b = new SelectListItem(); b.Text = p.PolicyName; b.Value = p.PolicyID.ToString(); a.Add(b); } return(a); }