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 int Post(UserPostsRequest request)
{
UserPost post = new UserPost();
List <Int32> posts = new List <Int32>();
var dbConnection = new DatabaseConnector();
var paramsList = new List <SqlParameter>();
SqlDataReader dataReader;
string command;
try
{
SqlParameter loginParam = new SqlParameter("@Login", SqlDbType.VarChar, request.Login.Length);
loginParam.Value = request.Login;
paramsList.Add(loginParam);
command = "select id from Users where Login=@Login";
dataReader = dbConnection.executeCommand(command, paramsList);
dataReader.Read();
post.authorId = dataReader.GetInt32(0);
post.title = request.Title;
post.text = request.Content;
post.tags = 0;
post.reblog = 0;
post.attachment = "empty";
dataReader.Close();
command = "INSERT into Wall (Autor, Tytul, reblog, Tresc, Tagi, attachment, DataPosta) values (@AuthorId, @Title, @Reblog, @Text, @Tags, @Attach, GETDATE())";
paramsList.Clear();
SqlParameter tempParam = new SqlParameter("@AuthorId", SqlDbType.Int);
tempParam.Value = post.authorId;
paramsList.Add(tempParam);
tempParam = new SqlParameter("@Title", SqlDbType.VarChar, post.title.Length);
tempParam.Value = post.title;
paramsList.Add(tempParam);
tempParam = new SqlParameter("@Reblog", SqlDbType.Int, post.reblog);
tempParam.Value = post.reblog;
paramsList.Add(tempParam);
tempParam = new SqlParameter("@Text", SqlDbType.VarChar, post.text.Length);
tempParam.Value = post.text;
paramsList.Add(tempParam);
tempParam = new SqlParameter("@Tags", SqlDbType.Binary);
tempParam.Value = BitConverter.GetBytes(post.tags);
paramsList.Add(tempParam);
tempParam = new SqlParameter("@Attach", SqlDbType.VarChar, post.attachment.Length);
tempParam.Value = post.attachment;
paramsList.Add(tempParam);
dataReader = dbConnection.executeCommand(command, paramsList);
if (dataReader.RecordsAffected > 0)
{
return((int)HttpStatusCode.OK);
}
else
{
return((int)HttpStatusCode.InternalServerError);
}
}
catch (Exception ex)
{
return(0);
}
}
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);
}
}