/// <summary> /// Gets UserRight by ID. /// </summary> /// <param name="CategoryID">The CategoryID.</param> /// <param name="UserID">The UserID.</param> /// <returns></returns> public UserRightValue SelectByID(System.Int32 CategoryID, System.Int32 UserID) { IDbCommand command = Database.CreateSPCommand("UserRight_GetByID"); command.AddInputParameter("@CategoryID", DbType.Int32, CategoryID); command.AddInputParameter("@UserID", DbType.Int32, UserID); return(SelectSingle(command)); }
/// <summary> /// Deletes the specified UserRight. /// </summary> /// <param name="CategoryID">The CategoryID.</param> /// <param name="UserID">The UserID.</param> public void Delete(System.Int32 CategoryID, System.Int32 UserID) { IDbCommand command = Database.CreateSPCommand("UserRight_Delete"); command.AddInputParameter("@CategoryID", DbType.Int32, CategoryID); command.AddInputParameter("@UserID", DbType.Int32, UserID); Database.ExecuteNonQuery(command); }
/// <summary> /// Deletes the specified FileStorage. /// </summary> /// <param name="FileStorageID">The FileStorageID.</param> /// <param name="SettingsID">The SettingsID.</param> public void Delete(System.Int16 FileStorageID, System.Byte SettingsID) { IDbCommand command = Database.CreateSPCommand("FileStorage_Delete"); command.AddInputParameter("@FileStorageID", DbType.Int16, FileStorageID); command.AddInputParameter("@SettingsID", DbType.Byte, SettingsID); Database.ExecuteNonQuery(command); }
/// <summary> /// Deletes the specified FileStorage. /// </summary> /// <param name="value">The value.</param> public void Delete(FileStorageValue value) { IDbCommand command = Database.CreateSPCommand("FileStorage_Delete"); command.AddInputParameter("@FileStorageID", DbType.Int16, value.FileStorageID); command.AddInputParameter("@SettingsID", DbType.Byte, value.SettingsID); Database.ExecuteNonQuery(command); }
/// <summary> /// Creates from user file. /// </summary> /// <param name="userFileId">The user file id.</param> /// <param name="fileIncludeID">The file include ID.</param> /// <param name="knowledgeID">The knowledge ID.</param> public void CreateFromUserFile(int userFileId, Guid fileIncludeID, int knowledgeID) { IDbCommand command = Database.CreateSPCommand("_FileIncludes_CreateFromUserFile", "@UserFileId", userFileId); command.AddInputParameter("@FileIncludeID", DbType.Guid, fileIncludeID); command.AddInputParameter("@KnowledgeID", DbType.Int32, knowledgeID); Database.ExecuteNonQuery(command); }
/// <summary> /// Selects the by file storage ID by path. /// </summary> /// <param name="FileStorageID">The file storage ID.</param> /// <param name="Path">The path.</param> /// <returns></returns> public FileLinkValue SelectByFileStorageIDByPath(Int16 FileStorageID, string Path) { IDbCommand command = Database.CreateSPCommand("_FileLinks_GetByFileStorageIDByPath"); command.AddInputParameter("@FileStorageID", DbType.Int16, FileStorageID); command.AddInputParameter("@Path", DbType.String, Path); return(SelectSingle(command)); }
/// <summary> /// Deletes the specified UserRight. /// </summary> /// <param name="value">The value.</param> public void Delete(UserRightValue value) { IDbCommand command = Database.CreateSPCommand("UserRight_Delete"); command.AddInputParameter("@CategoryID", DbType.Int32, value.CategoryID); command.AddInputParameter("@UserID", DbType.Int32, value.UserID); Database.ExecuteNonQuery(command); }
/// <summary> /// Gets FileStorage by ID. /// </summary> /// <param name="FileStorageID">The FileStorageID.</param> /// <param name="SettingsID">The SettingsID.</param> /// <returns></returns> public FileStorageValue SelectByID(System.Int16 FileStorageID, System.Byte SettingsID) { IDbCommand command = Database.CreateSPCommand("FileStorage_GetByID"); command.AddInputParameter("@FileStorageID", DbType.Int16, FileStorageID); command.AddInputParameter("@SettingsID", DbType.Byte, SettingsID); return(SelectSingle(command)); }
/// <summary> /// Gets the by login by password. /// </summary> /// <param name="Login">The login.</param> /// <param name="Password">The password.</param> /// <returns></returns> public UserValue GetByLoginByPassword(string Login, string Password) { IDbCommand command = database.CreateSPCommand("_User_GetByLoginByPassword"); command.AddInputParameter("@Login", DbType.String, Login); command.AddInputParameter("@Password", DbType.String, Password); return(SelectSingle(command)); }
/// <summary> /// Creates the insert command. /// </summary> /// <param name="value">The value.</param> /// <returns></returns> public void Insert(UserRightValue value) { IDbCommand command = Database.CreateSPCommand("UserRight_Insert"); command.AddInputParameter("@CategoryID", DbType.Int32, value.CategoryID); command.AddInputParameter("@PermissionID", DbType.Int16, value.PermissionID); command.AddInputParameter("@UserID", DbType.Int32, value.UserID); Database.ExecuteNonQuery(command); }
/// <summary> /// Sets the status. /// </summary> /// <param name="keywordId">The keyword ID.</param> /// <param name="keywordStatusId">The keyword status ID.</param> public void SetStatus(int keywordId, byte keywordStatusId) { IDbCommand command = Database.CreateSPCommand("_Keywords_SetStatus"); command.AddInputParameter("@KeywordID", DbType.Int32, keywordId); command.AddInputParameter("@KeywordStatusID", DbType.Byte, keywordStatusId); Database.ExecuteNonQuery(command); }
/// <summary> /// Updates the specified UserFile. /// </summary> /// <param name="value">The UserFile value.</param> public void Update(UserFileValue value) { IDbCommand command = Database.CreateSPCommand("UserFile_Update"); command.AddInputParameter("@FileName", DbType.String, value.FileName); command.AddInputParameter("@Size", DbType.Int32, value.Size); command.AddInputParameter("@UserFileID", DbType.Int32, value.UserFileID); command.AddInputParameter("@UserID", DbType.Int32, value.UserID); Database.ExecuteNonQuery(command); }
/// <summary> /// Updates the specified Keyword. /// </summary> /// <param name="value">The Keyword value.</param> public void Update(KeywordValue value) { IDbCommand command = Database.CreateSPCommand("Keyword_Update"); command.AddInputParameter("@KeywordID", DbType.Int32, value.KeywordID); command.AddInputParameter("@KeywordStatusID", DbType.Byte, value.KeywordStatusID); command.AddInputParameter("@KeywordTypeID", DbType.Int16, value.KeywordTypeID); command.AddInputParameter("@Name", DbType.String, value.Name); Database.ExecuteNonQuery(command); }
/// <summary> /// Updates the specified FileLink. /// </summary> /// <param name="value">The FileLink value.</param> public void Update(FileLinkValue value) { IDbCommand command = Database.CreateSPCommand("FileLink_Update"); command.AddInputParameter("@FileLinkID", DbType.Int32, value.FileLinkID); command.AddInputParameter("@FileStorageID", DbType.Int16, value.FileStorageID); command.AddInputParameter("@Path", DbType.String, value.Path); command.AddInputParameter("@PublicID", DbType.Guid, value.PublicID); Database.ExecuteNonQuery(command); }
/// <summary> /// Creates the insert command. /// </summary> /// <param name="value">The value.</param> /// <returns></returns> public void Insert(FileStorageValue value) { IDbCommand command = Database.CreateSPCommand("FileStorage_Insert"); command.AddInputParameter("@FileStorageID", DbType.Int16, value.FileStorageID); command.AddInputParameter("@Name", DbType.String, value.Name); command.AddInputParameter("@Path", DbType.String, value.Path); command.AddInputParameter("@SettingsID", DbType.Byte, value.SettingsID); Database.ExecuteNonQuery(command); }
/// <summary> /// Updates the specified Category. /// </summary> /// <param name="value">The Category value.</param> public void Update(CategoryValue value) { IDbCommand command = Database.CreateSPCommand("Category_Update"); command.AddInputParameter("@CategoryID", DbType.Int32, value.CategoryID); command.AddInputParameter("@CreationDate", DbType.DateTime, value.CreationDate); command.AddInputParameter("@Name", DbType.String, value.Name); command.AddInputParameter("@ParentCategoryID", DbType.Int32, value.ParentCategoryID); Database.ExecuteNonQuery(command); }
/// <summary> /// Updates the specified FileInclude. /// </summary> /// <param name="value">The FileInclude value.</param> public void Update(FileIncludeValue value) { IDbCommand command = Database.CreateSPCommand("FileInclude_Update"); command.AddInputParameter("@FileIncludeID", DbType.Guid, value.FileIncludeID); command.AddInputParameter("@FileName", DbType.String, value.FileName); command.AddInputParameter("@KnowledgeID", DbType.Int32, value.KnowledgeID); command.AddInputParameter("@Size", DbType.Int32, value.Size); Database.ExecuteNonQuery(command); }
/// <summary> /// Updates the specified Product. /// </summary> /// <param name="value">The Product value.</param> public void Update(ProductValue value) { IDbCommand command = database.CreateSPCommand("Product_Update"); command.AddInputParameter("@CreationDate", DbType.DateTime, value.CreationDate); command.AddInputParameter("@Name", DbType.String, value.Name); command.AddInputParameter("@PrivateKey", DbType.Binary, value.PrivateKey); command.AddInputParameter("@ProductID", DbType.Int32, value.ProductID); command.AddInputParameter("@PublicKey", DbType.Binary, value.PublicKey); database.ExecuteNonQuery(command); }
/// <summary> /// Creates the insert command. /// </summary> /// <param name="value">The value.</param> /// <returns></returns> public void Insert(KeywordValue value) { IDbCommand command = Database.CreateSPCommand("Keyword_Insert"); IDbDataParameter KeywordIDParameter = command.AddParameter("@KeywordID", DbType.Int32, null, ParameterDirection.Output); command.AddInputParameter("@KeywordStatusID", DbType.Byte, value.KeywordStatusID); command.AddInputParameter("@KeywordTypeID", DbType.Int16, value.KeywordTypeID); command.AddInputParameter("@Name", DbType.String, value.Name); Database.ExecuteNonQuery(command); value.KeywordID = (System.Int32)KeywordIDParameter.Value; }
/// <summary> /// Creates the insert command. /// </summary> /// <param name="value">The value.</param> /// <returns></returns> public void Insert(CategoryValue value) { IDbCommand command = Database.CreateSPCommand("Category_Insert"); IDbDataParameter CategoryIDParameter = command.AddParameter("@CategoryID", DbType.Int32, null, ParameterDirection.Output); command.AddInputParameter("@CreationDate", DbType.DateTime, value.CreationDate); command.AddInputParameter("@Name", DbType.String, value.Name); command.AddInputParameter("@ParentCategoryID", DbType.Int32, value.ParentCategoryID); Database.ExecuteNonQuery(command); value.CategoryID = (System.Int32)CategoryIDParameter.Value; }
/// <summary> /// Creates the insert command. /// </summary> /// <param name="value">The value.</param> /// <returns></returns> public void Insert(FileLinkValue value) { IDbCommand command = Database.CreateSPCommand("FileLink_Insert"); IDbDataParameter FileLinkIDParameter = command.AddParameter("@FileLinkID", DbType.Int32, null, ParameterDirection.Output); command.AddInputParameter("@FileStorageID", DbType.Int16, value.FileStorageID); command.AddInputParameter("@Path", DbType.String, value.Path); command.AddInputParameter("@PublicID", DbType.Guid, value.PublicID); Database.ExecuteNonQuery(command); value.FileLinkID = (System.Int32)FileLinkIDParameter.Value; }
/// <summary> /// Creates the insert command. /// </summary> /// <param name="value">The value.</param> /// <returns></returns> public void Insert(UserFileValue value) { IDbCommand command = Database.CreateSPCommand("UserFile_Insert"); command.AddInputParameter("@FileName", DbType.String, value.FileName); command.AddInputParameter("@Size", DbType.Int32, value.Size); IDbDataParameter UserFileIDParameter = command.AddParameter("@UserFileID", DbType.Int32, null, ParameterDirection.Output); command.AddInputParameter("@UserID", DbType.Int32, value.UserID); Database.ExecuteNonQuery(command); value.UserFileID = (System.Int32)UserFileIDParameter.Value; }
/// <summary> /// Creates the insert command. /// </summary> /// <param name="value">The value.</param> /// <returns></returns> public void Insert(ProductValue value) { IDbCommand command = database.CreateSPCommand("Product_Insert"); command.AddInputParameter("@CreationDate", DbType.DateTime, value.CreationDate); command.AddInputParameter("@Name", DbType.String, value.Name); command.AddInputParameter("@PrivateKey", DbType.Binary, value.PrivateKey); IDbDataParameter ProductIDParameter = command.AddParameter("@ProductID", DbType.Int32, null, ParameterDirection.Output); command.AddInputParameter("@PublicKey", DbType.Binary, value.PublicKey); database.ExecuteNonQuery(command); value.ProductID = (System.Int32)ProductIDParameter.Value; }
/// <summary> /// Selects User values RootPermissionID . /// ForeignKey: FK_Users_Permissions /// </summary> /// <param name="RootPermissionID">The RootPermissionID.</param> /// <returns>List of User</returns> public IList <UserValue> SelectByRootPermissionID(System.Int16 RootPermissionID) { IDbCommand command = Database.CreateSPCommand("User_GetByRootPermissionID"); command.AddInputParameter("@RootPermissionID", DbType.Int16, RootPermissionID); return(Select(command)); }
/// <summary> /// Updates the specified User. /// </summary> /// <param name="value">The User value.</param> public void Update(UserValue value) { IDbCommand command = Database.CreateSPCommand("User_Update"); command.AddInputParameter("@CreationDate", DbType.DateTime, value.CreationDate); command.AddInputParameter("@Email", DbType.String, value.Email); command.AddInputParameter("@FirstName", DbType.String, value.FirstName); command.AddInputParameter("@LastName", DbType.String, value.LastName); command.AddInputParameter("@Login", DbType.String, value.Login); command.AddInputParameter("@Password", DbType.String, value.Password); command.AddInputParameter("@RootPermissionID", DbType.Int16, value.RootPermissionID); command.AddInputParameter("@SecurityAnswer", DbType.String, value.SecurityAnswer); command.AddInputParameter("@SecurityQuestion", DbType.String, value.SecurityQuestion); command.AddInputParameter("@UserID", DbType.Int32, value.UserID); Database.ExecuteNonQuery(command); }
/// <summary> /// Selects Knowledge values ModificatorID . /// ForeignKey: FK_Knowledges_Modificator /// </summary> /// <param name="ModificatorID">The ModificatorID.</param> /// <returns>List of Knowledge</returns> public IList <KnowledgeValue> SelectByModificatorID(System.Int32 ModificatorID) { IDbCommand command = Database.CreateSPCommand("Knowledge_GetByModificatorID"); command.AddInputParameter("@ModificatorID", DbType.Int32, ModificatorID); return(Select(command)); }
/// <summary> /// Selects Knowledge values KnowledgeTypeID . /// ForeignKey: FK_Knowledges_KnowledgeTypes /// </summary> /// <param name="KnowledgeTypeID">The KnowledgeTypeID.</param> /// <returns>List of Knowledge</returns> public IList <KnowledgeValue> SelectByKnowledgeTypeID(System.Int16 KnowledgeTypeID) { IDbCommand command = Database.CreateSPCommand("Knowledge_GetByKnowledgeTypeID"); command.AddInputParameter("@KnowledgeTypeID", DbType.Int16, KnowledgeTypeID); return(Select(command)); }
/// <summary> /// Deletes the specified Knowledge. /// </summary> /// <param name="value">The value.</param> public void Delete(KnowledgeValue value) { IDbCommand command = Database.CreateSPCommand("Knowledge_Delete"); command.AddInputParameter("@KnowledgeID", DbType.Int32, value.KnowledgeID); Database.ExecuteNonQuery(command); }
/// <summary> /// Gets Knowledge by ID. /// </summary> /// <param name="KnowledgeID">The KnowledgeID.</param> /// <returns></returns> public KnowledgeValue SelectByID(System.Int32 KnowledgeID) { IDbCommand command = Database.CreateSPCommand("Knowledge_GetByID"); command.AddInputParameter("@KnowledgeID", DbType.Int32, KnowledgeID); return(SelectSingle(command)); }
/// <summary> /// Updates the specified Knowledge. /// </summary> /// <param name="value">The Knowledge value.</param> public void Update(KnowledgeValue value) { IDbCommand command = Database.CreateSPCommand("Knowledge_Update"); command.AddInputParameter("@CategoryID", DbType.Int32, value.CategoryID); command.AddInputParameter("@CreationDate", DbType.DateTime, value.CreationDate); command.AddInputParameter("@CreatorID", DbType.Int32, value.CreatorID); command.AddInputParameter("@KnowledgeID", DbType.Int32, value.KnowledgeID); command.AddInputParameter("@KnowledgeStatusID", DbType.Byte, value.KnowledgeStatusID); command.AddInputParameter("@KnowledgeTypeID", DbType.Int16, value.KnowledgeTypeID); command.AddInputParameter("@ModificationDate", DbType.DateTime, value.ModificationDate); command.AddInputParameter("@ModificatorID", DbType.Int32, value.ModificatorID); command.AddInputParameter("@Summary", DbType.String, value.Summary); command.AddInputParameter("@Title", DbType.String, value.Title); Database.ExecuteNonQuery(command); }