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 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 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)); }
//********************************************************************************** //********************************************************************************** //********************************************************************************** //EJEMPLOS public User Login() { DataTable dt = WikiDBAdapter.GetDataTable("GetNewsConfiguration"); User user = new User(); if (dt != null && dt.Rows.Count > 0) { var dsm = new DataSetMapper <User>(); user = dsm.ConvertSingleFromBackend(dt.Rows[0]); } return(user); }
public User GetUserByUserName(string userName) { DataAccessParameter[] parameters = new DataAccessParameter[1]; parameters[0] = new DataAccessParameter("@UserName", userName, typeof(string), null, ParameterDirection.Input); DataTable dt = WikiDBAdapter.GetDataTable("GetUserByUserName", parameters); User user = new User(); if (dt != null && dt.Rows.Count > 0) { var dsm = new DataSetMapper <User>(); user = dsm.ConvertSingleFromBackend(dt.Rows[0]); } return(user); }
public bool IsUserOwnerComent(Coment coment, User user) { DataAccessParameter[] parameters = new DataAccessParameter[2]; parameters[0] = new DataAccessParameter("@ComentId", coment.ComentId, typeof(int), null, ParameterDirection.Input); parameters[1] = new DataAccessParameter("@UserId", user.UserId, typeof(int), null, ParameterDirection.Input); DataTable dt = WikiDBAdapter.GetDataTable("IsUserOwnerComent", parameters); bool result = false; if (dt != null && dt.Rows.Count > 0) { result = true; } return(result); }
/// <summary> /// Obtiene la información de un post por id /// </summary> /// <param name="post">Post con el id</param> /// <returns></returns> public Post GetPostById(Post post) { DataAccessParameter[] parameters = new DataAccessParameter[1]; parameters[0] = new DataAccessParameter("@PostId", post.PostId, typeof(int), null, ParameterDirection.Input); DataTable dt = WikiDBAdapter.GetDataTable("GetPostById", parameters); Post result = new Post(); if (dt != null && dt.Rows.Count > 0) { var dsm = new DataSetMapper <Post>(); result = dsm.ConvertSingleFromBackend(dt.Rows[0]); } return(result); }
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 List <User> GetNewsItems() { DataSet ds = WikiDBAdapter.GetDataSet("GetNewsItems"); List <User> newsItems = new List <User>(); if (ds != null && ds.Tables.Count > 0) { DataTable myTable = ds.Tables[0]; if (myTable != null && myTable.Rows.Count > 0) { var dsm = new DataSetMapper <User>(); newsItems = dsm.ConvertFromBackend <List <User> >(myTable); } } return(newsItems); }
public List <DifficultyLevel> GetDifficultyLevel() { DataSet ds = WikiDBAdapter.GetDataSet("GetDifficultyLevel"); List <DifficultyLevel> difficultyLevels = new List <DifficultyLevel>(); if (ds != null && ds.Tables.Count > 0) { DataTable myTable = ds.Tables[0]; if (myTable != null && myTable.Rows.Count > 0) { var dsm = new DataSetMapper <DifficultyLevel>(); difficultyLevels = dsm.ConvertFromBackend <List <DifficultyLevel> >(myTable); } } return(difficultyLevels); }
public List <Topic> GetTopics() { DataSet ds = WikiDBAdapter.GetDataSet("GetTopics"); List <Topic> topics = new List <Topic>(); if (ds != null && ds.Tables.Count > 0) { DataTable myTable = ds.Tables[0]; if (myTable != null && myTable.Rows.Count > 0) { var dsm = new DataSetMapper <Topic>(); topics = dsm.ConvertFromBackend <List <Topic> >(myTable); } } return(topics); }
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); }
/// <summary> /// Retornna todos los post relacionados a un subtopic /// </summary> /// <param name="subTopic">Sub topic del cual se quieren obtener los post</param> /// <returns></returns> public List <Post> GetPostBySubTopicId(SubTopic subTopic) { DataSet ds = WikiDBAdapter.GetDataSet("GetPostBySubTopicId", new DataAccessParameter("@SubTopicId", subTopic.SubTopicId, typeof(int), null, ParameterDirection.Input)); List <Post> postResult = new List <Post>(); if (ds != null && ds.Tables.Count > 0) { DataTable myTable = ds.Tables[0]; if (myTable != null && myTable.Rows.Count > 0) { var dsm = new DataSetMapper <Post>(); postResult = dsm.ConvertFromBackend <List <Post> >(myTable); } } return(postResult); }
public List <SubTopic> GetSubTopicsByTopicId(Topic topic) { DataSet ds = WikiDBAdapter.GetDataSet("GetSubTopicsByTopicId", new DataAccessParameter("@TopicId", topic.TopicId, typeof(int), null, ParameterDirection.Input)); List <SubTopic> subTopics = new List <SubTopic>(); if (ds != null && ds.Tables.Count > 0) { DataTable myTable = ds.Tables[0]; if (myTable != null && myTable.Rows.Count > 0) { var dsm = new DataSetMapper <SubTopic>(); subTopics = dsm.ConvertFromBackend <List <SubTopic> >(myTable); } } return(subTopics); }