コード例 #1
0
        public Message addUpdateNoticeBoard(NoticeDashBoard noticeBoard)
        {
            Message msg = null;

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                msg = new Message();
                connection.Open();
                SqlCommand command = new SqlCommand(Helper.sp_CreateUpdateNoticeBoard, connection);
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.AddWithValue("@Id", noticeBoard.Id);
                command.Parameters.AddWithValue("@ClassId", noticeBoard.ClassId);
                command.Parameters.AddWithValue("@DivisionId", noticeBoard.DivisionId);
                command.Parameters.AddWithValue("@Description", noticeBoard.Description);
                command.Parameters.AddWithValue("@CreatedBy", noticeBoard.CreateBy);
                command.Parameters.AddWithValue("@UpdatedBy", noticeBoard.UpdatedBy);
                command.Parameters.AddWithValue("@CreatedDate", noticeBoard.CreatedDate);
                command.Parameters.AddWithValue("@UpdatedDate", noticeBoard.UpdatedDate);

                msg.status = command.ExecuteNonQuery();
            }

            return(msg);
        }
コード例 #2
0
 public Message addUpdateNoticeBoard(NoticeDashBoard noticeBoard)
 {
     return(_noticeBoard.addUpdateNoticeBoard(noticeBoard));
 }