C# Класс NanoTimeTracker.DatabaseManager

Показать файл Открыть проект Примеры использования класса

Private Properties

Свойство	Тип	Описание
DeriveLogFileName	string
Export	void
FindExistingInProgressTask	System.Data.DataRow
GetComputedDouble	double
GetTaskRow	System.Data.DataRow
Import	void
UpdateTask	System.DateTime

Открытые методы

Метод	Описание
DatabaseManager ( ) : System
DeleteLogs ( ) : void
GetBindingSource ( ) : System.Windows.Forms.BindingSource
GetHoursTotals ( System.DateTime fromDate, System.DateTime toDate, bool billableOnly ) : double
GetInProgressTaskDetails ( System.DateTime &taskStartTime, string &taskDescription, string &taskCategory, bool &taskBillable ) : bool
GetTaskDetailsByTask ( System.DateTime existingTaskTime, System.DateTime &taskEndDate, string &taskDescription, string &taskCategory, bool &taskTimeBillable ) : bool
LoadDatabase ( ) : void
ReadAutoCompletionDataFromDB ( ) : void
SaveTimeTrackingDB ( ) : void
SaveTimeTrackingDB ( bool AllowDateSwitch ) : void
StartLoggingTask ( System.DateTime taskStartTime, string taskDescription, string taskCategory, bool taskTimeBillable ) : void
UpdateLogOpenTask ( System.DateTime taskStartTime, System.DateTime taskEndDate, string taskDescription, string taskCategory, bool taskTimeBillable ) : void
UpdateLogTask ( System.DateTime taskStartTime, System.DateTime taskNewStartTime, System.DateTime taskNewEndDate, string taskNewDescription, string taskNewCategory, bool taskNewTimeBillable ) : void

Приватные методы

Метод	Описание
DeriveLogFileName ( ) : string
Export ( string destinationFileName, System.DateTime fromDate, System.DateTime toDate, bool billableEntriesOnly ) : void
FindExistingInProgressTask ( System.DateTime taskStartTime ) : DataRow
GetComputedDouble ( string expression, string filter ) : double
GetTaskRow ( System.DateTime existingTaskTime ) : DataRow
Import ( string sourceFileName ) : void
UpdateTask ( DataRow rowToUpdate, System.DateTime taskStartTime, System.DateTime taskEndDate, string taskDescription, string taskCategory, bool taskTimeBillable ) : System.DateTime

Описание методов

DatabaseManager() публичный Метод

public DatabaseManager ( ) : System
Результат	System

DeleteLogs() публичный Метод

public DeleteLogs ( ) : void
Результат	void

GetBindingSource() публичный Метод

public GetBindingSource ( ) : System.Windows.Forms.BindingSource
Результат	System.Windows.Forms.BindingSource

GetHoursTotals() публичный Метод

public GetHoursTotals ( System.DateTime fromDate, System.DateTime toDate, bool billableOnly ) : double
fromDate	System.DateTime
toDate	System.DateTime
billableOnly	bool
Результат	double

GetInProgressTaskDetails() публичный Метод

public GetInProgressTaskDetails ( System.DateTime &taskStartTime, string &taskDescription, string &taskCategory, bool &taskBillable ) : bool
taskStartTime	System.DateTime
taskDescription	string
taskCategory	string
taskBillable	bool
Результат	bool

GetTaskDetailsByTask() публичный Метод

public GetTaskDetailsByTask ( System.DateTime existingTaskTime, System.DateTime &taskEndDate, string &taskDescription, string &taskCategory, bool &taskTimeBillable ) : bool
existingTaskTime	System.DateTime
taskEndDate	System.DateTime
taskDescription	string
taskCategory	string
taskTimeBillable	bool
Результат	bool

LoadDatabase() публичный Метод

public LoadDatabase ( ) : void
Результат	void

ReadAutoCompletionDataFromDB() публичный Метод

public ReadAutoCompletionDataFromDB ( ) : void
Результат	void

SaveTimeTrackingDB() публичный Метод

public SaveTimeTrackingDB ( ) : void
Результат	void

SaveTimeTrackingDB() публичный Метод

public SaveTimeTrackingDB ( bool AllowDateSwitch ) : void
AllowDateSwitch	bool
Результат	void

StartLoggingTask() публичный Метод

public StartLoggingTask ( System.DateTime taskStartTime, string taskDescription, string taskCategory, bool taskTimeBillable ) : void
taskStartTime	System.DateTime
taskDescription	string
taskCategory	string
taskTimeBillable	bool
Результат	void

UpdateLogOpenTask() публичный Метод

public UpdateLogOpenTask ( System.DateTime taskStartTime, System.DateTime taskEndDate, string taskDescription, string taskCategory, bool taskTimeBillable ) : void
taskStartTime	System.DateTime
taskEndDate	System.DateTime
taskDescription	string
taskCategory	string
taskTimeBillable	bool
Результат	void

UpdateLogTask() публичный Метод

public UpdateLogTask ( System.DateTime taskStartTime, System.DateTime taskNewStartTime, System.DateTime taskNewEndDate, string taskNewDescription, string taskNewCategory, bool taskNewTimeBillable ) : void
taskStartTime	System.DateTime
taskNewStartTime	System.DateTime
taskNewEndDate	System.DateTime
taskNewDescription	string
taskNewCategory	string
taskNewTimeBillable	bool
Результат	void