@using System.Data;
@{
    ViewBag.Title = "ImportExcel";
    Layout = "~/Views/Shared/_Layout.cshtml";
}
<div class="content-body">
    <section id="basic-input">
        <div class="row">
            <div class="col-md-12">
                <div class="card">
                    <div class="content-header ">
                        <div class="content-header-left col-12 mb-2 mt-1">
                            <div class="row breadcrumbs-top">
                                <div class="col-12">
                                    <h5 class="content-header-title float-left pr-1 mb-0">Nouveau</h5>
                                    EXPORT DE MASSE PAR FICHIER EXCEL
                                    <hr />
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="card-content">
                        <div class="card-body">


                            <!--<![endif]-->
                            @using (Html.BeginForm("ImportExcel", "ExcelUpload", FormMethod.Post, new { enctype = "multipart/form-data" }))

                            {
                                <div class="row">
                                    <div class="col-md-12">
                                        <div class="form-group">
                                            <div class="col-md-10">
                                                <label>Fichier Excel</label>
                                                <input type="file" id="FileUpload1" name="FileUpload1" class="form-control"/>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="col-md-12">
                                        <div class="form-group">
                                            <div class="col-md-10">
                                                <input type="submit" id="Submit" name="Submit" value="Ouvrir" class="btn btn-primary" />
                                            </div>
                                        </div>
                                    </div>
                                </div>

                            }
                            @using (Html.BeginForm("Create", "ExcelUpload", FormMethod.Post, new { enctype = "multipart/form-data" }))

                            {
                        <div class="row">
                            <div class=" col-md-6"></div>
                            <div class="col-md-6">
                                <div class="form-group">

                                    <div class=" col-md-12">
                                        <input type="submit" value="Enregistrement " class="btn btn-primary pull-right" style=" float: right;"/>
                                    </div>
                                </div>
                            </div>
                        </div>

                            }
                        <div class="table-responsive">
                            <table class="table table-striped dataex-html5-selectors">

                                @if (ViewBag.Data != null)
                                {
                                    <thead>

                                        @foreach (DataColumn column in (ViewBag.Data as System.Data.DataTable).Columns)
                                        {
                                        <th>@column.ColumnName.ToUpper()</th>
                                    }
                                        </thead>
                                        if ((ViewBag.Data as System.Data.DataTable).Rows.Count > 0)
                                        {
                                            <tbody>
                                                @foreach (DataRow dr in (ViewBag.Data as System.Data.DataTable).Rows)
                                                {

                                                    <tr>

                                                        @foreach (DataColumn column in (ViewBag.Data as System.Data.DataTable).Columns)
                                                        {
                                                            <td data-title='@column.ColumnName'>

                                                                @dr[column].ToString()
                                                            </td>

                                                        }
                                                    </tr>



                                                }
                                            </tbody>

                                        }
                                        else
                                        {
                                            int count = (ViewBag.Data as System.Data.DataTable).Columns.Count;
                                            <tfoot>
                                                <tr>

                                                    <td colspan='@count' style="color:red;">

                                                        No Data Found.
                                                    </td>



                                                </tr>
                                            </tfoot>





                                        }

                                    }
                                    else
                                    {
                                        if (ViewBag.Error != null)
                                        {
                                            <tr>
                                                <td style="color:red;">

                                                    @(ViewBag.Error != null ? ViewBag.Error.ToString() : "")
                                                </td>



                                            </tr>

                                        }
                                    }
                            </table>

                        </div>
                        </div>
                    </div>
                </div>
            </div>
    </section>


</div>