C# Class Quilt4.Service.SqlRepository.SqlRepository

Inheritance: IRepository

Afficher le fichier Open project: Quilt4/Quilt4.Service

Méthodes publiques

Méthode	Description
AddProjectMember ( string userName, System.Guid projectKey, string role ) : void
AddUserExtraInfo ( string userName, string fullName, string defaultAvatarUrl ) : void
AddUserToRole ( string userName, string roleName ) : void
CreateIssue ( System.Guid issueKey, System.Guid issueTypeKey, System.Guid issueThreadKey, string sessionKey, System.DateTime clientTime, string>.IDictionary data, System.DateTime serverTime ) : void
CreateIssueType ( System.Guid issueTypeKey, System.Guid versionKey, int ticket, string type, string issueLevel, string message, string stackTrace, System.DateTime serverTime, IssueTypeRequestEntity innerIssueTypes ) : void
CreateProject ( string userName, System.Guid projectKey, string name, System.DateTime createTime, string dashboardColor, string projectApiKey ) : void
CreateProjectInvitation ( System.Guid projectKey, string userName, string inviteCode, string userKey, string email, System.DateTime serverTime ) : void
CreateRole ( System.Entity role ) : void
CreateSession ( string sessionKey, System.DateTime clientStartTime, string callerIp, System.Guid versionKey, System.Guid applicationUserKey, System.Guid machineKey, string environment, System.DateTime serverTime ) : void
CreateUser ( System.Entity user, System.DateTime serverTime ) : void
DeleteProject ( System.Guid projectKey ) : void
DeleteProjectInvitation ( System.Guid projectKey, string userName ) : void
DeleteSettng ( string settingName ) : void
GetAllProjects ( ) : Quilt4.Service.Entity.ProjectPageProject[]
GetApplicationKey ( System.Guid projectKey, string name ) : Guid?
GetApplicationUser ( System.Guid projectKey, string fingerprint ) : Guid?
GetApplications ( System.Guid projectKey ) : IEnumerable
GetApplications ( string userName, System.Guid projectKey ) : IEnumerable
GetDatabaseInfo ( ) : DatabaseInfo
GetInvitations ( ) : Entity.ProjectInvitation[]
GetInvitations ( string userName ) : Entity.ProjectInvitation[]
GetIssueTypeKey ( System.Guid versionKey, string type, string issueLevel, string message, string stackTrace ) : Guid?
GetIssueTypes ( System.Guid versionKey ) : IEnumerable
GetIssues ( System.Guid versionKey ) : IEnumerable
GetMachineKey ( System.Guid projectKey, string fingerprint ) : Guid?
GetNextTicket ( System.Guid projectKey ) : int
GetProjectInvitation ( System.Guid projectKey ) : Quilt4.Service.Entity.ProjectMember[]
GetProjectKey ( string projectApiKey ) : Guid?
GetProjectUsers ( System.Guid projectKey ) : Quilt4.Service.Entity.ProjectMember[]
GetProjects ( string userName ) : Quilt4.Service.Entity.ProjectPageProject[]
GetRole ( string roleName ) : Entity.Role
GetRolesByUser ( string userName ) : IEnumerable
GetSession ( string sessionKey ) : Entity.Session
GetSetting ( string settingName ) : Entity.Setting
GetSettings ( ) : IEnumerable
GetUserByEMail ( string email ) : Entity.User
GetUserByUserKey ( string userKey ) : Entity.User
GetUserByUserName ( string username ) : Entity.User
GetUserInfo ( string userName ) : UserInfo
GetUsers ( ) : IEnumerable
GetVersionKey ( System.Guid applicaitonKey, string versionNumber, System.DateTime buildTime ) : Guid?
GetVersions ( System.Guid applicationKey ) : IEnumerable
GetVersions ( string userName, System.Guid applicationKey ) : IEnumerable
SaveApplication ( System.Guid applicationKey, System.Guid projectKey, string name, System.DateTime serverTime ) : void
SaveApplicationUser ( System.Guid applicationUserKey, System.Guid projectKey, string fingerprint, string userName, System.DateTime serverTime ) : void
SaveMachine ( System.Guid machineKey, System.Guid projectKey, string fingerprint, string name, string>.IDictionary data, System.DateTime serverTime ) : void
SaveVersion ( System.Guid versionKey, System.Guid applicaitonKey, string versionNumber, System.DateTime buildTime, string supportToolkitNameVersion, System.DateTime serverTime ) : void
SetSessionEnd ( string sessionKey, System.DateTime serverDateTime ) : void
SetSessionUsed ( string sessionKey, System.DateTime serverDateTime ) : void
SetSetting ( string settingName, string value ) : void
UpdateProject ( System.Guid projectKey, string name, string dashboardColor ) : void
UpdateUser ( System.Entity user ) : void

Private Methods

Méthode	Description
CreateIssueTypeDetail ( IssueTypeRequestEntity innerIssueTypes, IssueTypeDetail detail, Quilt4DataContext context ) : void
GetDataContext ( ) : Quilt4DataContext

Method Details

AddProjectMember() public méthode

public AddProjectMember ( string userName, System.Guid projectKey, string role ) : void
userName	string
projectKey	System.Guid
role	string
Résultat	void

AddUserExtraInfo() public méthode

public AddUserExtraInfo ( string userName, string fullName, string defaultAvatarUrl ) : void
userName	string
fullName	string
defaultAvatarUrl	string
Résultat	void

AddUserToRole() public méthode

public AddUserToRole ( string userName, string roleName ) : void
userName	string
roleName	string
Résultat	void

CreateIssue() public méthode

public CreateIssue ( System.Guid issueKey, System.Guid issueTypeKey, System.Guid issueThreadKey, string sessionKey, System.DateTime clientTime, string>.IDictionary data, System.DateTime serverTime ) : void
issueKey	System.Guid
issueTypeKey	System.Guid
issueThreadKey	System.Guid
sessionKey	string
clientTime	System.DateTime
data	string>.IDictionary
serverTime	System.DateTime
Résultat	void

CreateIssueType() public méthode

public CreateIssueType ( System.Guid issueTypeKey, System.Guid versionKey, int ticket, string type, string issueLevel, string message, string stackTrace, System.DateTime serverTime, IssueTypeRequestEntity innerIssueTypes ) : void
issueTypeKey	System.Guid
versionKey	System.Guid
ticket	int
type	string
issueLevel	string
message	string
stackTrace	string
serverTime	System.DateTime
innerIssueTypes	Quilt4.Service.Entity.IssueTypeRequestEntity
Résultat	void

CreateProject() public méthode

public CreateProject ( string userName, System.Guid projectKey, string name, System.DateTime createTime, string dashboardColor, string projectApiKey ) : void
userName	string
projectKey	System.Guid
name	string
createTime	System.DateTime
dashboardColor	string
projectApiKey	string
Résultat	void

CreateProjectInvitation() public méthode

public CreateProjectInvitation ( System.Guid projectKey, string userName, string inviteCode, string userKey, string email, System.DateTime serverTime ) : void
projectKey	System.Guid
userName	string
inviteCode	string
userKey	string
email	string
serverTime	System.DateTime
Résultat	void

CreateRole() public méthode

public CreateRole ( System.Entity role ) : void
role	System.Entity
Résultat	void

CreateSession() public méthode

public CreateSession ( string sessionKey, System.DateTime clientStartTime, string callerIp, System.Guid versionKey, System.Guid applicationUserKey, System.Guid machineKey, string environment, System.DateTime serverTime ) : void
sessionKey	string
clientStartTime	System.DateTime
callerIp	string
versionKey	System.Guid
applicationUserKey	System.Guid
machineKey	System.Guid
environment	string
serverTime	System.DateTime
Résultat	void

CreateUser() public méthode

public CreateUser ( System.Entity user, System.DateTime serverTime ) : void
user	System.Entity
serverTime	System.DateTime
Résultat	void

DeleteProject() public méthode

public DeleteProject ( System.Guid projectKey ) : void
projectKey	System.Guid
Résultat	void

DeleteProjectInvitation() public méthode

public DeleteProjectInvitation ( System.Guid projectKey, string userName ) : void
projectKey	System.Guid
userName	string
Résultat	void

DeleteSettng() public méthode

public DeleteSettng ( string settingName ) : void
settingName	string
Résultat	void

GetAllProjects() public méthode

public GetAllProjects ( ) : Quilt4.Service.Entity.ProjectPageProject[]
Résultat	Quilt4.Service.Entity.ProjectPageProject[]

GetApplicationKey() public méthode

public GetApplicationKey ( System.Guid projectKey, string name ) : Guid?
projectKey	System.Guid
name	string
Résultat	Guid?

GetApplicationUser() public méthode

public GetApplicationUser ( System.Guid projectKey, string fingerprint ) : Guid?
projectKey	System.Guid
fingerprint	string
Résultat	Guid?

GetApplications() public méthode

public GetApplications ( System.Guid projectKey ) : IEnumerable
projectKey	System.Guid
Résultat	IEnumerable

GetApplications() public méthode

public GetApplications ( string userName, System.Guid projectKey ) : IEnumerable
userName	string
projectKey	System.Guid
Résultat	IEnumerable

GetDatabaseInfo() public méthode

public GetDatabaseInfo ( ) : DatabaseInfo
Résultat	Quilt4.Service.Entity.DatabaseInfo

GetInvitations() public méthode

public GetInvitations ( ) : Entity.ProjectInvitation[]
Résultat	Entity.ProjectInvitation[]

GetInvitations() public méthode

public GetInvitations ( string userName ) : Entity.ProjectInvitation[]
userName	string
Résultat	Entity.ProjectInvitation[]

GetIssueTypeKey() public méthode

public GetIssueTypeKey ( System.Guid versionKey, string type, string issueLevel, string message, string stackTrace ) : Guid?
versionKey	System.Guid
type	string
issueLevel	string
message	string
stackTrace	string
Résultat	Guid?

GetIssueTypes() public méthode

public GetIssueTypes ( System.Guid versionKey ) : IEnumerable
versionKey	System.Guid
Résultat	IEnumerable

GetIssues() public méthode

public GetIssues ( System.Guid versionKey ) : IEnumerable
versionKey	System.Guid
Résultat	IEnumerable

GetMachineKey() public méthode

public GetMachineKey ( System.Guid projectKey, string fingerprint ) : Guid?
projectKey	System.Guid
fingerprint	string
Résultat	Guid?

GetNextTicket() public méthode

public GetNextTicket ( System.Guid projectKey ) : int
projectKey	System.Guid
Résultat	int

GetProjectInvitation() public méthode

public GetProjectInvitation ( System.Guid projectKey ) : Quilt4.Service.Entity.ProjectMember[]
projectKey	System.Guid
Résultat	Quilt4.Service.Entity.ProjectMember[]

GetProjectKey() public méthode

public GetProjectKey ( string projectApiKey ) : Guid?
projectApiKey	string
Résultat	Guid?

GetProjectUsers() public méthode

public GetProjectUsers ( System.Guid projectKey ) : Quilt4.Service.Entity.ProjectMember[]
projectKey	System.Guid
Résultat	Quilt4.Service.Entity.ProjectMember[]

GetProjects() public méthode

public GetProjects ( string userName ) : Quilt4.Service.Entity.ProjectPageProject[]
userName	string
Résultat	Quilt4.Service.Entity.ProjectPageProject[]

GetRole() public méthode

public GetRole ( string roleName ) : Entity.Role
roleName	string
Résultat	Entity.Role

GetRolesByUser() public méthode

public GetRolesByUser ( string userName ) : IEnumerable
userName	string
Résultat	IEnumerable

GetSession() public méthode

public GetSession ( string sessionKey ) : Entity.Session
sessionKey	string
Résultat	Entity.Session

GetSetting() public méthode

public GetSetting ( string settingName ) : Entity.Setting
settingName	string
Résultat	Entity.Setting

GetSettings() public méthode

public GetSettings ( ) : IEnumerable
Résultat	IEnumerable

GetUserByEMail() public méthode

public GetUserByEMail ( string email ) : Entity.User
email	string
Résultat	Entity.User

GetUserByUserKey() public méthode

public GetUserByUserKey ( string userKey ) : Entity.User
userKey	string
Résultat	Entity.User

GetUserByUserName() public méthode

public GetUserByUserName ( string username ) : Entity.User
username	string
Résultat	Entity.User

GetUserInfo() public méthode

public GetUserInfo ( string userName ) : UserInfo
userName	string
Résultat	Quilt4.Service.Entity.UserInfo

GetUsers() public méthode

public GetUsers ( ) : IEnumerable
Résultat	IEnumerable

GetVersionKey() public méthode

public GetVersionKey ( System.Guid applicaitonKey, string versionNumber, System.DateTime buildTime ) : Guid?
applicaitonKey	System.Guid
versionNumber	string
buildTime	System.DateTime
Résultat	Guid?

GetVersions() public méthode

public GetVersions ( System.Guid applicationKey ) : IEnumerable
applicationKey	System.Guid
Résultat	IEnumerable

GetVersions() public méthode

public GetVersions ( string userName, System.Guid applicationKey ) : IEnumerable
userName	string
applicationKey	System.Guid
Résultat	IEnumerable

SaveApplication() public méthode

public SaveApplication ( System.Guid applicationKey, System.Guid projectKey, string name, System.DateTime serverTime ) : void
applicationKey	System.Guid
projectKey	System.Guid
name	string
serverTime	System.DateTime
Résultat	void

SaveApplicationUser() public méthode

public SaveApplicationUser ( System.Guid applicationUserKey, System.Guid projectKey, string fingerprint, string userName, System.DateTime serverTime ) : void
applicationUserKey	System.Guid
projectKey	System.Guid
fingerprint	string
userName	string
serverTime	System.DateTime
Résultat	void

SaveMachine() public méthode

public SaveMachine ( System.Guid machineKey, System.Guid projectKey, string fingerprint, string name, string>.IDictionary data, System.DateTime serverTime ) : void
machineKey	System.Guid
projectKey	System.Guid
fingerprint	string
name	string
data	string>.IDictionary
serverTime	System.DateTime
Résultat	void

SaveVersion() public méthode

public SaveVersion ( System.Guid versionKey, System.Guid applicaitonKey, string versionNumber, System.DateTime buildTime, string supportToolkitNameVersion, System.DateTime serverTime ) : void
versionKey	System.Guid
applicaitonKey	System.Guid
versionNumber	string
buildTime	System.DateTime
supportToolkitNameVersion	string
serverTime	System.DateTime
Résultat	void

SetSessionEnd() public méthode

public SetSessionEnd ( string sessionKey, System.DateTime serverDateTime ) : void
sessionKey	string
serverDateTime	System.DateTime
Résultat	void

SetSessionUsed() public méthode

public SetSessionUsed ( string sessionKey, System.DateTime serverDateTime ) : void
sessionKey	string
serverDateTime	System.DateTime
Résultat	void

SetSetting() public méthode

public SetSetting ( string settingName, string value ) : void
settingName	string
value	string
Résultat	void

UpdateProject() public méthode

public UpdateProject ( System.Guid projectKey, string name, string dashboardColor ) : void
projectKey	System.Guid
name	string
dashboardColor	string
Résultat	void

UpdateUser() public méthode

public UpdateUser ( System.Entity user ) : void
user	System.Entity
Résultat	void