public PartialViewResult OptionTypes(int?id) { using (var context = new SeniorCareEntities()) { string sql = "SELECT * FROM FacilityOptionTypes"; var optiontypes = context.Database.SqlQuery <OptionTypeModel>(sql, new SqlParameter("ID", id)).SingleOrDefault(); return(PartialView(optiontypes)); } }
public IEnumerable <OptionTypeModel> Get() { using (var context = new SeniorCareEntities()) { var sql = "SELECT * FROM FacilityOptionTypes"; var types = context.Database.SqlQuery <OptionTypeModel>(sql).ToList(); return(types); } }
public ActionResult List() { ViewBag.Title = "Facility Listing"; using (var context = new SeniorCareEntities()) { string sql = "SELECT * FROM Facilities"; var facilities = context.Database.SqlQuery <FacilityModel>(sql).ToList(); return(View(facilities)); } }
public IHttpActionResult Get(int id) { using (var context = new SeniorCareEntities()) { var sql = "SELECT * FROM FacilityOptionTypes WHERE ID = @ID"; OptionTypeModel model = context.Database.SqlQuery <OptionTypeModel>(sql, new SqlParameter("ID", id)).SingleOrDefault(); if (model == null) { return(NotFound()); } return(Ok(model)); } }
public ActionResult Detail(int?id) { if (id == null) { return(RedirectToAction("Index")); } using (var context = new SeniorCareEntities()) { string sql = "SELECT * FROM Facilities WHERE ID = @ID"; var facility = context.Database.SqlQuery <FacilityModel>(sql, new SqlParameter("ID", id)).SingleOrDefault(); if (facility == null) { return(HttpNotFound()); } return(View(facility)); } }
public async Task <HttpResponseMessage> Get(string ID) { using (var context = new SeniorCareEntities()) { string sql = "SELECT ID, Image FROM Facilities WHERE ID = @ID"; FacilityModel facility = await context.Database.SqlQuery <FacilityModel>(sql, new SqlParameter("@ID", ID)).FirstOrDefaultAsync(); if (facility.Image == null) { return(new HttpResponseMessage(HttpStatusCode.NotFound)); } else { byte[] data = facility.Image; var stream = new MemoryStream(data); var httpResponse = new HttpResponseMessage(HttpStatusCode.OK); httpResponse.Content = new ByteArrayContent(stream.ToArray()); httpResponse.Content.Headers.ContentType = new MediaTypeHeaderValue("image/png"); return(httpResponse); } } }