C# Class appBLL.UtilitiesBLL

Mostra file Open project: nirzaf/appAPPKK

Public Methods

Method	Description
ConvertToString ( object input ) : string	Convert To String
CreateConnection ( bool &returnStatus, string &returnErrorMessage ) : SqlConnection	Create SQL Server Database Connection
CreateConnectionRMSPROD ( bool &returnStatus, string &returnErrorMessage ) : SqlConnection	Create SQL Server Database Connection
EncodeMailAdres ( string input ) : string	Encode Email Address
FormatDate ( DateTime inDate ) : string	Convert Date to Formatted Date
IsDateSupplied ( string dateString ) : bool	Is Date Suppled
IsNumeric ( object value ) : bool
IsValidDate ( string dateString ) : bool	Is Valid Date
SetProperties ( Array fromFields, object fromRecord, object toRecord ) : void	Set Properties
TableToXLSXms ( DataTable SourceData, Array SourceColOrder, Array SourceColText, bool IncludeHeader, string FileToSave ) : MemoryStream

Method Details

ConvertToString() public static method

Convert To String

public static ConvertToString ( object input ) : string
input	object
return	string

CreateConnection() public method

Create SQL Server Database Connection

public CreateConnection ( bool &returnStatus, string &returnErrorMessage ) : SqlConnection
returnStatus	bool
returnErrorMessage	string
return	SqlConnection

CreateConnectionRMSPROD() public method

Create SQL Server Database Connection

public CreateConnectionRMSPROD ( bool &returnStatus, string &returnErrorMessage ) : SqlConnection
returnStatus	bool
returnErrorMessage	string
return	SqlConnection

EncodeMailAdres() public static method

Encode Email Address

public static EncodeMailAdres ( string input ) : string
input	string
return	string

FormatDate() public static method

Convert Date to Formatted Date

public static FormatDate ( DateTime inDate ) : string
inDate	DateTime
return	string

IsDateSupplied() public static method

Is Date Suppled

public static IsDateSupplied ( string dateString ) : bool
dateString	string
return	bool

IsNumeric() public method

public IsNumeric ( object value ) : bool
value	object
return	bool

IsValidDate() public static method

Is Valid Date

public static IsValidDate ( string dateString ) : bool
dateString	string
return	bool

SetProperties() public static method

Set Properties

public static SetProperties ( Array fromFields, object fromRecord, object toRecord ) : void
fromFields	Array
fromRecord	object
toRecord	object
return	void

TableToXLSXms() public method

public TableToXLSXms ( DataTable SourceData, Array SourceColOrder, Array SourceColText, bool IncludeHeader, string FileToSave ) : MemoryStream
SourceData	DataTable
SourceColOrder	Array
SourceColText	Array
IncludeHeader	bool
FileToSave	string
return	MemoryStream