public List <ProductandServiceStockQuantitiesListEntity> GetExportDataList(string FileName)
        {
            IPandSStockQuantitiesListDAL exportdata = new PandSStockQuantitiesListDAL();

            DataSet   ds = new DataSet();
            DataTable dt = new DataTable();

            pandSStockQuantities = exportdata.GetExportDataList(FileName);
            dt = ToDataTable(pandSStockQuantities);
            ds.Tables.Add(dt);
            ExportToExcel(ds, FileName);

            return(pandSStockQuantities);
        }
        public List <PandSStockQuantitiesListEntity> GetPandSList()
        {
            IPandSStockQuantitiesListDAL pandsdal = new PandSStockQuantitiesListDAL();

            return(pandsdal.GetPandSList());
        }