HYTOS

using ID2.Manager.Dapper.Repository;

using ID2.Manager.Data.Models;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ID2.Manager.Controller.Controllers

{

    public  class ExcelDataController : BaseController

    {

        public IEnumerable<ExcelData> GetExcelData(string FileName, string WorksheetName)

        {

            IEnumerable<ExcelData> result = null;

            using (ExcelDataRepository repository = new ExcelDataRepository(this._MSSQLCONNSTR))

            {

                result = repository.GetExcelData(FileName, WorksheetName);

            }

            return result;

        }

        public IEnumerable<ExcelDataInfo> GetExcelDataInfo()

        {

            IEnumerable<ExcelDataInfo> result = null;

            using (ExcelDataRepository repository = new ExcelDataRepository(this._MSSQLCONNSTR))

            {

                result = repository.GetExcelDataInfo();

            }

            return result;

        }

        public bool DeleteExcelData(string FileName, string WorksheetName)

        {

            using (ExcelDataRepository repository = new ExcelDataRepository(this._MSSQLCONNSTR))

            {

                return repository.DeleteExcelData(FileName, WorksheetName);

            }

        }

    }

}