C# Class appBLL.UtilitiesBLL

Afficher le fichier Open project: nirzaf/appAPPKK

Méthodes publiques

Méthode	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 méthode

Convert To String

public static ConvertToString ( object input ) : string
input	object
Résultat	string

CreateConnection() public méthode

Create SQL Server Database Connection

public CreateConnection ( bool &returnStatus, string &returnErrorMessage ) : SqlConnection
returnStatus	bool
returnErrorMessage	string
Résultat	SqlConnection

CreateConnectionRMSPROD() public méthode

Create SQL Server Database Connection

public CreateConnectionRMSPROD ( bool &returnStatus, string &returnErrorMessage ) : SqlConnection
returnStatus	bool
returnErrorMessage	string
Résultat	SqlConnection

EncodeMailAdres() public static méthode

Encode Email Address

public static EncodeMailAdres ( string input ) : string
input	string
Résultat	string

FormatDate() public static méthode

Convert Date to Formatted Date

public static FormatDate ( DateTime inDate ) : string
inDate	DateTime
Résultat	string

IsDateSupplied() public static méthode

Is Date Suppled

public static IsDateSupplied ( string dateString ) : bool
dateString	string
Résultat	bool

IsNumeric() public méthode

public IsNumeric ( object value ) : bool
value	object
Résultat	bool

IsValidDate() public static méthode

Is Valid Date

public static IsValidDate ( string dateString ) : bool
dateString	string
Résultat	bool

SetProperties() public static méthode

Set Properties

public static SetProperties ( Array fromFields, object fromRecord, object toRecord ) : void
fromFields	Array
fromRecord	object
toRecord	object
Résultat	void

TableToXLSXms() public méthode

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