C# Class Quilt4.Service.SqlRepository.SqlRepository

Inheritance: IRepository

Show file Open project: Quilt4/Quilt4.Service

Public Methods

Method	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

Method	Description
CreateIssueTypeDetail ( IssueTypeRequestEntity innerIssueTypes, IssueTypeDetail detail, Quilt4DataContext context ) : void
GetDataContext ( ) : Quilt4DataContext

Method Details

AddProjectMember() public method

public AddProjectMember ( string userName, System.Guid projectKey, string role ) : void
userName	string
projectKey	System.Guid
role	string
return	void

AddUserExtraInfo() public method

public AddUserExtraInfo ( string userName, string fullName, string defaultAvatarUrl ) : void
userName	string
fullName	string
defaultAvatarUrl	string
return	void

AddUserToRole() public method

public AddUserToRole ( string userName, string roleName ) : void
userName	string
roleName	string
return	void

CreateIssue() public method

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
return	void

CreateIssueType() public method

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
return	void

CreateProject() public method

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
return	void

CreateProjectInvitation() public method

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
return	void

CreateRole() public method

public CreateRole ( System.Entity role ) : void
role	System.Entity
return	void

CreateSession() public method

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
return	void

CreateUser() public method

public CreateUser ( System.Entity user, System.DateTime serverTime ) : void
user	System.Entity
serverTime	System.DateTime
return	void

DeleteProject() public method

public DeleteProject ( System.Guid projectKey ) : void
projectKey	System.Guid
return	void

DeleteProjectInvitation() public method

public DeleteProjectInvitation ( System.Guid projectKey, string userName ) : void
projectKey	System.Guid
userName	string
return	void

DeleteSettng() public method

public DeleteSettng ( string settingName ) : void
settingName	string
return	void

GetAllProjects() public method

public GetAllProjects ( ) : Quilt4.Service.Entity.ProjectPageProject[]
return	Quilt4.Service.Entity.ProjectPageProject[]

GetApplicationKey() public method

public GetApplicationKey ( System.Guid projectKey, string name ) : Guid?
projectKey	System.Guid
name	string
return	Guid?

GetApplicationUser() public method

public GetApplicationUser ( System.Guid projectKey, string fingerprint ) : Guid?
projectKey	System.Guid
fingerprint	string
return	Guid?

GetApplications() public method

public GetApplications ( System.Guid projectKey ) : IEnumerable
projectKey	System.Guid
return	IEnumerable

GetApplications() public method

public GetApplications ( string userName, System.Guid projectKey ) : IEnumerable
userName	string
projectKey	System.Guid
return	IEnumerable

GetDatabaseInfo() public method

public GetDatabaseInfo ( ) : DatabaseInfo
return	Quilt4.Service.Entity.DatabaseInfo

GetInvitations() public method

public GetInvitations ( ) : Entity.ProjectInvitation[]
return	Entity.ProjectInvitation[]

GetInvitations() public method

public GetInvitations ( string userName ) : Entity.ProjectInvitation[]
userName	string
return	Entity.ProjectInvitation[]

GetIssueTypeKey() public method

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
return	Guid?

GetIssueTypes() public method

public GetIssueTypes ( System.Guid versionKey ) : IEnumerable
versionKey	System.Guid
return	IEnumerable

GetIssues() public method

public GetIssues ( System.Guid versionKey ) : IEnumerable
versionKey	System.Guid
return	IEnumerable

GetMachineKey() public method

public GetMachineKey ( System.Guid projectKey, string fingerprint ) : Guid?
projectKey	System.Guid
fingerprint	string
return	Guid?

GetNextTicket() public method

public GetNextTicket ( System.Guid projectKey ) : int
projectKey	System.Guid
return	int

GetProjectInvitation() public method

public GetProjectInvitation ( System.Guid projectKey ) : Quilt4.Service.Entity.ProjectMember[]
projectKey	System.Guid
return	Quilt4.Service.Entity.ProjectMember[]

GetProjectKey() public method

public GetProjectKey ( string projectApiKey ) : Guid?
projectApiKey	string
return	Guid?

GetProjectUsers() public method

public GetProjectUsers ( System.Guid projectKey ) : Quilt4.Service.Entity.ProjectMember[]
projectKey	System.Guid
return	Quilt4.Service.Entity.ProjectMember[]

GetProjects() public method

public GetProjects ( string userName ) : Quilt4.Service.Entity.ProjectPageProject[]
userName	string
return	Quilt4.Service.Entity.ProjectPageProject[]

GetRole() public method

public GetRole ( string roleName ) : Entity.Role
roleName	string
return	Entity.Role

GetRolesByUser() public method

public GetRolesByUser ( string userName ) : IEnumerable
userName	string
return	IEnumerable

GetSession() public method

public GetSession ( string sessionKey ) : Entity.Session
sessionKey	string
return	Entity.Session

GetSetting() public method

public GetSetting ( string settingName ) : Entity.Setting
settingName	string
return	Entity.Setting

GetSettings() public method

public GetSettings ( ) : IEnumerable
return	IEnumerable

GetUserByEMail() public method

public GetUserByEMail ( string email ) : Entity.User
email	string
return	Entity.User

GetUserByUserKey() public method

public GetUserByUserKey ( string userKey ) : Entity.User
userKey	string
return	Entity.User

GetUserByUserName() public method

public GetUserByUserName ( string username ) : Entity.User
username	string
return	Entity.User

GetUserInfo() public method

public GetUserInfo ( string userName ) : UserInfo
userName	string
return	Quilt4.Service.Entity.UserInfo

GetUsers() public method

public GetUsers ( ) : IEnumerable
return	IEnumerable

GetVersionKey() public method

public GetVersionKey ( System.Guid applicaitonKey, string versionNumber, System.DateTime buildTime ) : Guid?
applicaitonKey	System.Guid
versionNumber	string
buildTime	System.DateTime
return	Guid?

GetVersions() public method

public GetVersions ( System.Guid applicationKey ) : IEnumerable
applicationKey	System.Guid
return	IEnumerable

GetVersions() public method

public GetVersions ( string userName, System.Guid applicationKey ) : IEnumerable
userName	string
applicationKey	System.Guid
return	IEnumerable

SaveApplication() public method

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
return	void

SaveApplicationUser() public method

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
return	void

SaveMachine() public method

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
return	void

SaveVersion() public method

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
return	void

SetSessionEnd() public method

public SetSessionEnd ( string sessionKey, System.DateTime serverDateTime ) : void
sessionKey	string
serverDateTime	System.DateTime
return	void

SetSessionUsed() public method

public SetSessionUsed ( string sessionKey, System.DateTime serverDateTime ) : void
sessionKey	string
serverDateTime	System.DateTime
return	void

SetSetting() public method

public SetSetting ( string settingName, string value ) : void
settingName	string
value	string
return	void

UpdateProject() public method

public UpdateProject ( System.Guid projectKey, string name, string dashboardColor ) : void
projectKey	System.Guid
name	string
dashboardColor	string
return	void

UpdateUser() public method

public UpdateUser ( System.Entity user ) : void
user	System.Entity
return	void