public List <ProductandServiceStockValueListEntity> GetExportDataList(string FileName)
        {
            IPandSStockValueListDAL exportdata = new PandSStockValueListDAL();

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

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

            return(pandSStockvalue);
        }
        public List <PandSStockValueListEntity> GetPandSList()
        {
            IPandSStockValueListDAL pandsdal = new PandSStockValueListDAL();

            return(pandsdal.GetPandSList());
        }