public bool UpdatePushNotificationNews(User user) { var inputParameters = new DataAccessParameter[1]; inputParameters[0] = new DataAccessParameter("@NewsItemId", user.UserId, typeof(int)); return(1 == WikiDBAdapter.ExecuteStoredProcedure("UpdatePushNotificationNews", inputParameters)); }
public bool DeleteComent(Coment coment) { var parameters = new DataAccessParameter[1]; parameters[0] = new DataAccessParameter("@ComentId", coment.ComentId, typeof(int), null, ParameterDirection.Input); return(1 == WikiDBAdapter.ExecuteStoredProcedure("DeleteComent", parameters)); }
public bool DeletePost(Post post) { var parameters = new DataAccessParameter[1]; parameters[0] = new DataAccessParameter("@PostId", post.PostId, typeof(int), null, ParameterDirection.Input); return(1 == WikiDBAdapter.ExecuteStoredProcedure("DeletePost", parameters)); }
public int CountCompanyActiveUsersInvArea(string search_column, string search_data) { var outputParameter = new DataAccessParameter("@count", null, typeof(string), null, ParameterDirection.Output); WikiDBAdapter.ExecuteStoredProcedure("CountCompanyActiveUsersInvArea", outputParameter, new DataAccessParameter("@search_column", search_column, typeof(int), ParameterDirection.Input), new DataAccessParameter("@search_data", search_data, typeof(string), ParameterDirection.Input)); return(Convert.ToInt32(outputParameter.Value)); }
public bool InsertComent(Coment coment) { var parameters = new DataAccessParameter[4]; parameters[0] = new DataAccessParameter("@PostId", coment.Post.PostId, typeof(int), null, ParameterDirection.Input); parameters[1] = new DataAccessParameter("@ComentReferenceId", coment.ComentReferenceId, typeof(int), null, ParameterDirection.Input); parameters[2] = new DataAccessParameter("@ComentText", coment.ComentText, typeof(int), null, ParameterDirection.Input); parameters[3] = new DataAccessParameter("@UserId", coment.User.UserId, typeof(int), null, ParameterDirection.Input); return(1 == WikiDBAdapter.ExecuteStoredProcedure("InsertComent", parameters)); }
public bool UpdatePost(Post post) { var parameters = new DataAccessParameter[8]; parameters[0] = new DataAccessParameter("@PostId", post.PostId, typeof(int), null, ParameterDirection.Input); parameters[1] = new DataAccessParameter("@TopicId", post.Topic.TopicId, typeof(int), null, ParameterDirection.Input); parameters[2] = new DataAccessParameter("@SubTopicId", post.SubTopic.SubTopicId, typeof(int), null, ParameterDirection.Input); parameters[3] = new DataAccessParameter("@UserId", post.User.UserId, typeof(int), null, ParameterDirection.Input); parameters[4] = new DataAccessParameter("@DifficultyLevelId", post.DifficultyLevel.DifficultyLevelId, typeof(int), null, ParameterDirection.Input); parameters[5] = new DataAccessParameter("@Tags", post.Tags, typeof(string), null, ParameterDirection.Input); parameters[6] = new DataAccessParameter("@ContentPost", post.ContentPost, typeof(string), null, ParameterDirection.Input); parameters[7] = new DataAccessParameter("@Title", post.Title, typeof(string), null, ParameterDirection.Input); return(1 == WikiDBAdapter.ExecuteStoredProcedure("UpdatePost", parameters)); }
public Post InsertPost(Post post) { var parameters = new DataAccessParameter[7]; parameters[0] = new DataAccessParameter("@TopicId", post.Topic.TopicId, typeof(int), null, ParameterDirection.Input); parameters[1] = new DataAccessParameter("@SubTopicId", post.SubTopic.SubTopicId, typeof(int), null, ParameterDirection.Input); parameters[2] = new DataAccessParameter("@UserId", post.User.UserId, typeof(int), null, ParameterDirection.Input); parameters[3] = new DataAccessParameter("@DifficultyLevelId", post.DifficultyLevel.DifficultyLevelId, typeof(int), null, ParameterDirection.Input); parameters[4] = new DataAccessParameter("@Tags", post.Tags, typeof(string), null, ParameterDirection.Input); parameters[5] = new DataAccessParameter("@ContentPost", post.ContentPost, typeof(string), null, ParameterDirection.Input); parameters[6] = new DataAccessParameter("@Title", post.Title, typeof(string), null, ParameterDirection.Input); //Retorno el id del objeto creado y lo asigno al post post.PostId = WikiDBAdapter.ExecuteStoredProcedure("InsertPost", parameters); return(post); }