public List <UserPost> Get(UserPostRequest request) { var userPosts = new List <UserPost>(); UserPost post = new UserPost(); var dbConnection = new DatabaseConnector(); var paramsList = new List <SqlParameter>(); SqlDataReader dataReader; string command; try { if (request.Id == 0) { command = "Select * from Wall"; dataReader = dbConnection.executeCommand(command, paramsList); while (dataReader.Read()) { userPosts.Add(new UserPost { id = dataReader.GetInt32(0), authorId = dataReader.GetInt32(1), title = dataReader.GetString(2), reblog = dataReader.GetInt32(3), text = dataReader.GetString(4), attachment = dataReader.GetString(6), date = dataReader.GetDateTime(7) }); } dataReader.Close(); return(userPosts); } else { paramsList.Clear(); SqlParameter loginParam = new SqlParameter("@Id", SqlDbType.Int); loginParam.Value = request.Id; paramsList.Add(loginParam); command = "Select * from Wall where id=@Id"; dataReader = dbConnection.executeCommand(command, paramsList); if (dataReader.HasRows) { dataReader.Read(); userPosts.Add(new UserPost { id = dataReader.GetInt32(0), authorId = dataReader.GetInt32(1), title = dataReader.GetString(2), reblog = dataReader.GetInt32(3), text = dataReader.GetString(4), attachment = dataReader.GetString(6), date = dataReader.GetDateTime(7) }); dataReader.Close(); return(userPosts); } else { dataReader.Close(); return(null); } } } catch (Exception ex) { return(null); } }
public List <UserPost> Patch(UserPostRequest request) { var userPosts = new List <UserPost>(); var dbConnection = new DatabaseConnector(); var paramsList = new List <SqlParameter>(); SqlDataReader dataReader; string command; try { SqlParameter loginParam = new SqlParameter("@Id", SqlDbType.Int); loginParam.Value = request.Id; paramsList.Add(loginParam); command = "Select * from Wall where id=@Id"; dataReader = dbConnection.executeCommand(command, paramsList); if (dataReader.HasRows) { dataReader.Read(); userPosts.Add(new UserPost { id = dataReader.GetInt32(0), authorId = dataReader.GetInt32(1), title = dataReader.GetString(2), reblog = dataReader.GetInt32(3), text = dataReader.GetString(4), attachment = dataReader.GetString(6), date = dataReader.GetDateTime(7) }); dataReader.Close(); //update post userPosts.ElementAt(0).title = request.Title; userPosts.ElementAt(0).text = request.Content; command = "UPDATE Wall set Tytul=@Title, Tresc=@Content where id=@IId"; paramsList.Clear(); SqlParameter tempParam = new SqlParameter("@Title", SqlDbType.VarChar, request.Title.Length); tempParam.Value = request.Title; paramsList.Add(tempParam); tempParam = new SqlParameter("@Content", SqlDbType.VarChar, request.Content.Length); tempParam.Value = request.Content; paramsList.Add(tempParam); tempParam = new SqlParameter("@IId", SqlDbType.Int); tempParam.Value = request.Id; paramsList.Add(tempParam); dataReader = dbConnection.executeCommand(command, paramsList); if (dataReader.RecordsAffected > 0) { dataReader.Close(); return(userPosts); } else { dataReader.Close(); return(null); } } else { dataReader.Close(); return(null); } } catch (Exception ex) { return(null); } }