C# 클래스 NanoTimeTracker.DatabaseManager

파일 보기 프로젝트 열기: TaoK/NanoTimeTracker 1 사용 예제들

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