C# Class UT.Helper.cExcel

Show file Open project: CISC181/VolTeerNET Class Usage Examples

Public Methods

Method	Description
GetAllExcelFiles ( ) : List
GetAllVendExcelFiles ( ) : List
GetAllVolExcelFiles ( ) : List
GetHelperFilesDir ( ) : String
InsertData ( string ExcelFilenames ) : void
InsertProjectData ( Microsoft.VisualStudio.TestTools.UnitTesting.TestContext testContext ) : void
QueryExcelFile ( string path, string query ) : DataTable
ReadExcelFile ( string sheetName, string path ) : DataTable
RemoveAllData ( ) : void
RemoveData ( string ExcelFilenames ) : void
getConnectionString ( ) : string
getNumRecordsFromDB ( string tableName ) : int
setIdentityInsert ( SqlCommand command, string table, string value ) : void

Method Details

GetAllExcelFiles() public static method

public static GetAllExcelFiles ( ) : List
return	List

GetAllVendExcelFiles() public static method

public static GetAllVendExcelFiles ( ) : List
return	List

GetAllVolExcelFiles() public static method

public static GetAllVolExcelFiles ( ) : List
return	List

GetHelperFilesDir() public static method

public static GetHelperFilesDir ( ) : String
return	String

InsertData() public static method

public static InsertData ( string ExcelFilenames ) : void
ExcelFilenames	string
return	void

InsertProjectData() public static method

public static InsertProjectData ( Microsoft.VisualStudio.TestTools.UnitTesting.TestContext testContext ) : void
testContext	Microsoft.VisualStudio.TestTools.UnitTesting.TestContext
return	void

QueryExcelFile() public static method

public static QueryExcelFile ( string path, string query ) : DataTable
path	string
query	string
return	System.Data.DataTable

ReadExcelFile() public static method

public static ReadExcelFile ( string sheetName, string path ) : DataTable
sheetName	string
path	string
return	System.Data.DataTable

RemoveAllData() public static method

public static RemoveAllData ( ) : void
return	void

RemoveData() public static method

public static RemoveData ( string ExcelFilenames ) : void
ExcelFilenames	string
return	void

getConnectionString() public static method

public static getConnectionString ( ) : string
return	string

getNumRecordsFromDB() public static method

public static getNumRecordsFromDB ( string tableName ) : int
tableName	string
return	int

setIdentityInsert() public static method

public static setIdentityInsert ( SqlCommand command, string table, string value ) : void
command	System.Data.SqlClient.SqlCommand
table	string
value	string
return	void