using System;
using System.Linq;
using AwesomeWebFormsDemo.Data;
using AwesomeWebFormsDemo.Models;
using AwesomeWebFormsDemo.Utils.Awesome;
using System.Web.Mvc;


using Omu.AwesomeWebForms;

namespace AwesomeWebFormsDemo.Controllers.Awesome.Grid
{
    public class LunchGridController : Controller
    {
        public ActionResult GetItems(GridParams g, int? country, string person, string food)
        {            
            var query = Db.Lunches.AsQueryable();

            // filtering
            if (person != null) query = query.Where(o => o.Person.ToLower().Contains(person.ToLower()));
            if (food != null) query = query.Where(o => o.Food.Name.ToLower().Contains(food.ToLower()));
            if (country.HasValue) query = query.Where(o => o.Country.Id == country);

            // data can be from any source as long here you pass an IQueryable<T>
            var gmb = new GridModelBuilder<Lunch>(query.AsQueryable(), g);

            // define grid key, used to identify rows
            gmb.KeyProp = o => o.Id;

            // grid row model
            // columns bound to Prop1.Prop2 will automatically display Prop1Prop2,
            // or you could specify in the view Column.Prop ="Prop1Prop2", or ClientFormat = ".(Prop1Prop2)"
            gmb.Map = o => new
            {
                o.Id,
                o.Person,
                FoodName = o.Food.Name,
                FoodPic = o.Food.Pic,
                o.Location,
                o.Price,
                Date = o.Date.ToShortDateString(),
                CountryName = o.Country.Name,
                ChefName = o.Chef.FullName
            };

            return Json(gmb.Build());
        }

        public ActionResult GetItemsEFExample(GridParams g, int? country, string person, string food)
        {
            var query = Db.Lunches.AsQueryable();

            // Filter - custom extension in demo code
            // equivalent to .Where(o => o.Food.Name.Contains(food) || ...)

            query = query
                .Filter(food, o => o.Food.Name)
                .Filter(person, o => o.Person);

            if (country.HasValue) query = query.Where(o => o.Country.Id == country);

            var gmb = new GridModelBuilder<Lunch>(query, g);
            gmb.KeyProp = o => o.Id;
            gmb.Map = o => new
            {
                o.Id,
                o.Person,
                FoodName = o.Food.Name,
                FoodPic = o.Food.Pic,
                o.Location,
                o.Price,
                Date = o.Date.ToShortDateString(),
                CountryName = o.Country.Name,
                ChefName = o.Chef.FullName
            };

            return Json(gmb.Build());
        }
    }
}

public ActionResult LunchDetail(int key)
{
    var lunch = Db.Get<Lunch>(key);
    return PartialView(lunch);
}

@model AwesomeWebFormsDemo.Models.Lunch
<div style="padding:0.2em 2em;">
    @Model.Person had @Model.Food.Name  at @Model.Location in @Model.Country.Name<br/>
    View loaded from server at: @DateTime.UtcNow UTC
</div>

public ActionResult MealGrid(int key)
{
    ViewData["Id"] = key;
    return PartialView();
}

<div style="margin: 5px;">
    @(Html.Awe().Grid("MealsGrid" + ViewData["Id"]) // please note, you need to have unique html ids
        .Url(Url.Action("ChildMealsGrid", "Data"))
        .Columns(
        new Column { Bind = "Id", Width = 50 },
        new Column { Bind = "Name", Width = 150 },
        new Column { Bind = "Description" })
        .Resizable()
        .Parameter("categories", ViewData["Id"]))
</div>

public ActionResult CategoriesGrid(GridParams g)
{
    return Json(new GridModelBuilder<Category>(Db.Categories.AsQueryable(), g)
    {
        Key = "Id"
    }.Build());
}

public ActionResult ChildMealsGrid(GridParams g, int[] categories)
{
    categories = categories ?? new int[] { };

    return Json(new GridModelBuilder<Meal>(Db.Meals
        .Where(o => categories.Contains(o.Category.Id)).AsQueryable(), g).Build());
}