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);
}
}
}
