@{
}
@model Recipes.Business.ViewModels.Recipes.ManageRecipeViewModel
@using Recipes.Business.ViewModels.Recipes
<div class="container-fluid">
    <div class=" d-sm-flex align-items-center justify-content-between mb-4">
                <h3 class="h3 mb-2 text-gray-800">@ViewBag.FormName</h3>
    </div>
    <div class="card-shadow mb-4">
        <form method="post">
        <div class="card-header py-3 border-all">
            <div class=" d-sm-flex align-items-center justify-content-between mb-4">
                <h5 class="h5 mb-2 text-gray-800">Hlavička Receptury</h5>
            </div>
                <div class="form-row ">
                    <div class="col ">
                        <label asp-for="@Model.RecipeId">Číslo Receptury</label>
                        <input type="text" asp-for="@Model.RecipeId" class="form-control" required placeholder="Číslo Receptury">
                    </div>
                    <div class="col ">
                        <label asp-for="@Model.RecipeName">Název Receptury</label>
                        <input asp-for="@Model.RecipeName" type="text" class="form-control " required placeholder="Název Receptury">
                    </div>
                    <div class="col">
                        <label asp-for="SelectedCalculationId">Metoda výpočtu</label>
                             <kendo-combobox name="SelectedCalculationId" filter="FilterType.Contains"
                                                bind-to="Model.CalculationMethods"
                                                value="@Model.SelectedCalculationId"
                                                placeholder="Vyber metodu výpočtu..."
                                                datatextfield="CalculationMethodName"
                                                datavaluefield="CalculationMethodId"
                                                style="width:100%">
                                </kendo-combobox>
                    </div>
                </div>
                <div class="form-row">      
                    <div class="col">
                        <label asp-for="@Model.RecipeNote">Poznámka</label>
                        <input type="text" class="form-control text-xs" id="inpNote" placeholder="Poznámka k receptuře">
                    </div>
                    <div class="col" id="prescriptionInput">
                            <label for="prescriptionComboBox_input">Předpis</label>
                            <kendo-combobox name="prescriptionComboBox" filter="FilterType.Contains"
                                            bind-to="Model.Prescriptions"
                                            value="@Model.SelectedPrescriptionId"
                                            placeholder="Vyber předpis..."
                                            datatextfield="PrescriptionName"
                                            datavaluefield="PrescriptionId"
                                            style="width:100%"
                                            >
                            </kendo-combobox>
                    </div>
                </div>
                <div class="form-row">
                    <div class="col">
                        <div class="form-check">
                            <label class="form-check-label" for="switch">
                                Receptura pro barvení
                            </label>
                            @(Html.Kendo().Switch()
                            .Name("IsColorRecipe")
                            .Messages(c=>c.Checked("Ano").Unchecked("Ne"))
                            .Events(ev => ev.Change("changeSwitch"))
                            .Checked(@Model.IsColorRecipe)
                            )
                        </div>
                    </div>
                    <div id="colorInputs"class="form-row" hidden >
                        <div class="col ">
                            <label asp-for="@Model.WaterInRecipe">Voda na sůl</label>
                            <input type="number" class="form-control text-xs" asp-for="@Model.WaterInRecipe" id="inpWater">
                        </div> 
                        <div class=" col">
                            <label asp-for="@Model.SaltInRecipe">Program </label>
                            <input type="number"  class="form-control text-xs" asp-for="@Model.SaltInRecipe" id="inpProgram">
                        </div>
                    </div>
                </div>
        </div>
         <div class ="card-body mt-2 py-3 border-all">
            <div class="table-responsive">
                @(Html.Kendo().Grid<RecipeLinesDetailViewModel>()
                .Name("#grid")
                .Editable(editable => editable.Mode(GridEditMode.InCell))
                
                .DataSource(dataSource => dataSource
                .Ajax()
                .Batch(true)
                .Read(read=>read.Action("Recipes_ReadLines", "Recipes"))
                .Update(update => update.Action("Update", "Recipes"))
                .Create(create => create.Action("Create", "Recipes"))
                .Destroy(destroy => destroy.Action("Destroy", "Recipes"))
                .Model(m =>{
                    m.Id(id=>id.RecipeLineId);
                    m.Field(id=>id.RecipeLineId).Editable(false);
                    m.Field(f=>f.ChemistryRecipeViewModel).DefaultValue(
                        new ChemistryRecipeViewModel{
                            ChemistryId="1",
                            ChemistryName="testChemistry"
                        });
                }))

                .ToolBar(toolbar =>
                {
                    toolbar.Create();
                    toolbar.Save();
                    toolbar.Excel();
                    toolbar.Search();
                })

                .Columns(c=>{
                    c.Bound(c=>c.RecipeLineId).Hidden(true);
                    c.Bound(c=>c.ChemistryRecipeViewModel.ChemistryName).EditorTemplateName("ChemistryIdEditor");
                    c.Bound(c=>c.Dosage);
                    c.Bound(c=>c.Units);
                    c.Bound(c=>c.Rounded);
                    c.Bound(c=>c.Units);
                    c.Bound(c=>c.Comment);
                })
                .Excel(excel=>excel.ProxyURL(Url.Action("Excel_Export_Save", "Grid")))
                .Pageable()
                .Sortable()
                .Filterable()
                .Editable())
            </div>
        </div>
        <div class="card-footer mt-2 py-3 border-top">
            <button class="btn btn-primary" type="submit">Uložit</button>
        </div>
        </form>
                       
    </div>
</div>


<style >
   .border-all{border: 0.15rem solid #9e9e9e !important;}
   .border-top{border-top: 0.15rem solid #36b9cc !important;}
   .k-grid .k-grid-search {
        margin-left: auto;
        margin-right: 0;
    }
</style>

@section Scripts{

<script>
    function changeSwitch(e){
        if(e.checked){
                $('#IsColorRecipe').attr('checked','true')
                document.getElementById("colorInputs").hidden = false;
                document.getElementById("inpWater").setAttribute("required","");
                document.getElementById("inpProgram").setAttribute("required","");
            } 
            else{
                document.getElementById("colorInputs").hidden = true;
                document.getElementById("inpWater").removeAttribute("required","");
                document.getElementById("inpProgram").removeAttribute("required","");
            }
    }
    
</script>
}

@model Recipes.Business.ViewModels.Recipes.ChemistryRecipeViewModel

@(Html.Kendo().DropDownListFor(x => x).DataSource(x => x.Read(y => y
.Action("AllChemistry", "Recipes")))
.DataTextField("ChemistryName").DataValueField("ChemistryId")
.Filter(FilterType.Contains)
.HtmlAttributes(new { data_bind = "value: ChemistryName" }))

public class RecipeLinesDetailViewModel
    {
        
        public int? RecipeLineId { get; set; }
        
        public ChemistryRecipeViewModel ChemistryRecipeViewModel { get; set; }
        [UIHint("Units")]

        public UnitRecipeViewModel Units { get; set; }

        [Display(Name = "Dávkování")]
        public float Dosage { get; set; }
        [Display(Name = "Zaokrouhlení")]
        public float Rounded { get; set; }

        [Display(Name = "Poznámka")]
        public string? Comment { get; set; }
    }

using Kendo.Mvc.Extensions;
using Kendo.Mvc.UI;
using Microsoft.AspNetCore.Mvc;
using Recipes.Business.Interfaces;
using Recipes.Business.ViewModels.Recipes;
using Recipes.Data.Models;
using System;
using System.Collections.Generic;
using System.Linq;

namespace Recipes.Controllers
{
    public class RecipesController : Controller
    {
        IRecipeManager recipeManager;
        IChemistryManager chemistryManager;

        public RecipesController(IRecipeManager recipeManager,IChemistryManager chemistryManager)
        {
            this.recipeManager = recipeManager;
            this.chemistryManager = chemistryManager;
        }

        public IActionResult Index()
        {

            return View();
        }

        public IActionResult ManageRecipe()
        {
            ViewBag.FormName = "Nová receptura";

            return View(recipeManager.GetNewRecipeData());
        }
        [HttpPost]
        [ValidateAntiForgeryToken]
        public IActionResult ManageRecipe(ManageRecipeViewModel model)
        {
            if (!ModelState.IsValid)
            {
                return View(model);
            }
            return View();
        }
        public IActionResult Recipes_Read([DataSourceRequest] DataSourceRequest request)
        {
            
            return Json(recipeManager.GetRecipesOverView().ToDataSourceResult(request));
        }
        public IActionResult Recipes_ReadLines([DataSourceRequest] DataSourceRequest request)
        {
            var x = recipeManager.GetTestData();
            return Json(x.ToDataSourceResult(request));
        }
        public IActionResult AllChemistry()
        {
            return Json(recipeManager.GetRecipesChemistry());
        }
    }
}

var xlsxFormatProvider = new XlsxFormatProvider();

// Import 
using Stream input = new FileStream("c:\\tmp\\Charts.xlsx", FileMode.Open);
var workbook = xlsxFormatProvider.Import(input);


// Export
using Stream output = new FileStream("c:\\tmp\\Charts_Edited.xlsx", FileMode.Create);
xlsxFormatProvider.Export(workbook, output);

public product
{
        public int ProductId { get; set; }
        public string ProductName { get; set; }
        public int? SupplierId { get; set; }
        public int? CategoryId { get; set; }
        public string QuantityPerUnit { get; set; }
        public decimal? UnitPrice { get; set; }
        public short? UnitsInStock { get; set; }
}