public user GetGroupCommentUser(group_comments comment)
{
user user = new user();
using (var connection = SqlConncetionHelper.Connection)
{
connection.Open();
DbCommand command = connection.CreateCommand();
DbParameter groupParameter = command.CreateParameter();
groupParameter.DbType = DbType.Int32;
groupParameter.ParameterName = "@userId";
groupParameter.Value = comment.User_id;
command.Parameters.Add(groupParameter);
command.CommandText = "select * from users" +
" where user_id = @userId";
DbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
user.user_id = (int)reader["user_id"];
user.nickname = reader["nickname"].ToString();
user.password = reader["password"].ToString();
user.register_date = DateTime.Parse(reader["register_date"].ToString());
user.wallet_id = (int)reader["wallet_id"];
user.status_id = (int)reader["status_id"];
user.IsDeleted = (byte)(reader["IsDeleted"]);
}
}
return(user);
}
public void CreateGroupComment(group_comments groupComment)
{
#region Подключенный режим
//DbCommand command = SqlConncetionHelper.Connection.CreateCommand();
//DbParameter groupIdParameter = command.CreateParameter();
//groupIdParameter.DbType = System.Data.DbType.Int32;
//groupIdParameter.IsNullable = false;
//groupIdParameter.ParameterName = "@GroupId";
//groupIdParameter.Value = groupComment.GroupId;
//DbParameter userIdParameter = command.CreateParameter();
//userIdParameter.DbType = System.Data.DbType.Int32;
//userIdParameter.IsNullable = false;
//userIdParameter.ParameterName = "@UserId";
//userIdParameter.Value = groupComment.UserId;
//DbParameter textParameter = command.CreateParameter();
//textParameter.DbType = System.Data.DbType.String;
//textParameter.IsNullable = false;
//textParameter.ParameterName = "@Text";
//textParameter.Value = groupComment.Text;
//command.Parameters.AddRange(new DbParameter[] { groupIdParameter, userIdParameter, textParameter });
//command.CommandText = @"INSERT INTO [dbo].[group_comments]([group_id],[user_id],[comment_text]) VALUES
// (@GroupId, @UserId, @Text)";
//SqlConncetionHelper.ExecuteCommands(command);
#endregion
//Отключеный режим
DbDataAdapter adapter = SqlConncetionHelper.DataAdapter;
DbCommand selectCommand = SqlConncetionHelper.Connection.CreateCommand();
selectCommand.CommandText = "select * from group_comments";
DbCommandBuilder builder = SqlConncetionHelper.ProviderFactory.CreateCommandBuilder();
builder.DataAdapter = adapter;
adapter.SelectCommand = selectCommand;
DataSet ds = new DataSet();
adapter.Fill(ds);
DataTable table = ds.Tables[0];
DataRow newRow = table.NewRow();
newRow["group_id"] = groupComment.Group_id;
newRow["user_id"] = groupComment.User_id;
newRow["comment_text"] = groupComment.Comment_text;
table.Rows.Add(newRow);
adapter.Update(ds);
ds.AcceptChanges();
}
/// <summary>
/// Метод для получения комментариев конкретной группы
/// </summary>
/// <param name="group">Группа, комментарии которой нужно получить</param>
/// <returns></returns>
public List <group_comments> SelectGroupComments(group group)
{
List <group_comments> groupComments = new List <group_comments>();
using (var connection = SqlConncetionHelper.Connection)
{
connection.Open();
DbCommand command = connection.CreateCommand();
DbParameter groupParameter = command.CreateParameter();
groupParameter.DbType = DbType.Int32;
groupParameter.ParameterName = "@GroupId";
groupParameter.Value = group.Group_id;
command.Parameters.Add(groupParameter);
command.CommandText = "select * from group_comments" +
" where group_id = @GroupId";
DbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
group_comments comment = new group_comments()
{
Gc_id = (int)reader["gc_id"],
User_id = (int)reader["user_id"],
Group_id = (int)reader["group_id"],
Comment_text = reader["comment_text"].ToString(),
Send_date = (DateTime)reader["send_date"]
};
comment.User = GetGroupCommentUser(comment);
groupComments.Add(comment);
}
}
return(groupComments);
}
